mysql自动停止
这两天才开始的,开了服务,不进行数据操作是正常的,但是备份,运行程序操作数据库时,就会自动关闭服务了。
重装了,也一样,我是用 xampp 套件的。
之前也没这种情况,我的数据有 几十万达百万条的。
win XP + Apache + php5 + mysql5 ....
先检查一下日志中的信息。
这是我在 mysql.err 里找出来的。请帮忙检查,谢谢
_____________________________________________________________________
InnoDB: stored checksum 3075374560, prior-to-4.0.14-form stored checksum 1158438285
InnoDB: Page lsn 4142669612 3360602035, low 4 bytes of lsn at page end 3586200832
InnoDB: Page number (if stored to page already) 4118889177,
InnoDB: space id (if created with >= MySQL-4.1.1 and stored already) 650564504
InnoDB: Database page corruption on disk or a failed
InnoDB: file read of page 2179.
InnoDB: You may have to recover from a backup.
InnoDB: It is also possible that your operating
InnoDB: system has corrupted its own file cache
InnoDB: and rebooting your computer removes the
InnoDB: error.
InnoDB: If the corrupt page is an index page
InnoDB: you can also try to fix the corruption
InnoDB: by dumping, dropping, and reimporting
InnoDB: the corrupt table. You can use CHECK
InnoDB: TABLE to scan your table for corruption.
InnoDB: See also http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html
InnoDB: about forcing recovery.
InnoDB: Ending processing because of a corrupt
相关问答:
我是用mysql自带的C API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("数据库连接失败") ......
先上错误
无法联接数据库
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......
mysql数据库的编码格式是utf8
在c++程序中使用C API直接连接mysql数据库,把中文保存到mysql数据库中,中午变成乱码
使用mysql的load命令导入文本文件,无论文本文件是ANSI还是utf8编码,都是乱码
请问上面两个问 ......
表
CREATE TABLE `ch1` (
`id` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT,
`no` int(10) unsigned DEFAULT NULL,
`dtime` datetime DEFAULT NULL,
PRIMARY KEY (`id ......
刚刚接触MySQL,不知道该如何去查看数据,插入数据,创建数据库、表,用哪为前辈能指教一二?
MySQL 5.1参考手册
引用
兄弟你会结贴吗?
mysql 参考手册
baidu
MySQL官方文档 http://dev.mysql.com/doc ......