MYSQL 隔段时间重起,日志不知道怎么打开,想让mysql 自动重起又不知道怎么办 ,继续帮助 MYSQL 隔段时间重起,日志不知道怎么打开,想让mysql 自动重起又不知道怎么办 ,继续帮助 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 用文本编辑器就可以打开了,要想它自动重启,那只能你自己写一个脚本,检查mysql有没有启动,没有的话就启动它 请问脚本怎么写! 是在win2k下面 由于mysql隔段时间自己就关了,所以我想隔段时间让他重起一次 ,谢谢! 写批处理问题啊,调用mysqld.exe,不过你要有时间限制的话,就要写程序来执行,或者借用某些自动执行工具来做了, 061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 763 user: 'root'上面的大哥,用at命令可以重起,谢谢!061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 762 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 761 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 760 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 759 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 758 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 757 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 756 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 713 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 709 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 696 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 687 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 685 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 593 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 588 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 583 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 580 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 578 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 576 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 575 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 571 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 565 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 555 user: 'root'061230 18:16:20 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Sort aborted061230 18:16:20 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Sort aborted061230 18:16:21 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Sort aborted061230 18:16:21 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Sort aborted061230 18:16:21 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Sort aborted061230 18:16:22 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Sort aborted061230 18:16:23 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Sort aborted061230 18:16:23 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Sort aborted061230 18:16:28 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Sort aborted061230 18:16:28 InnoDB: Starting shutdown...061230 18:16:34 InnoDB: Shutdown completed; log sequence number 0 118554744061230 18:16:34 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete我感觉这个mysql日志有问题,导致数据库关闭 。 请问我该怎么解决, 数据库查询,急啊,在线等,各位帮帮小弟 【讨论】究竟是设计数据库宁愿多些表,还是在查询语句上进行优化好 不明白INT(5)中的5是什么意思 提高系统消息的未读统计效率 MYSQL 自定义函数问题!!!!!!!!!!!!!!!!!!!!!!!!!!! 为什么执行全表查询,不执行模糊查询????????很郁闷 一条简单的SQL语句把我拦住了! 订餐系统的数据库设计,应该有哪些表,表关系 mysql 存储过程 通过参数查询的问题 MySQL运行语句报错 成功解决MYSQL的乱码问题! select into 导出的TXT文件中文为乱码 怎么样能够解决此问题呢?
061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 762 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 761 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 760 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 759 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 758 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 757 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 756 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 713 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 709 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 696 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 687 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 685 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 593 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 588 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 583 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 580 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 578 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 576 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 575 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 571 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 565 user: 'root'061230 18:16:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 555 user: 'root'061230 18:16:20 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Sort aborted
061230 18:16:20 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Sort aborted
061230 18:16:21 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Sort aborted
061230 18:16:21 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Sort aborted
061230 18:16:21 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Sort aborted
061230 18:16:22 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Sort aborted
061230 18:16:23 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Sort aborted
061230 18:16:23 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Sort aborted
061230 18:16:28 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Sort aborted
061230 18:16:28 InnoDB: Starting shutdown...
061230 18:16:34 InnoDB: Shutdown completed; log sequence number 0 118554744
061230 18:16:34 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
我感觉这个mysql日志有问题,导致数据库关闭 。
请问我该怎么解决,