易截截图软件、单文件、免安装、纯绿色、仅160KB

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的连接超时时间怎么设置 - VC/MFC / 数据库

我是用mysql自带的C API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))

AfxMessageBox("数据库连接失败") ......

eclipse连接mysql数据库 - Java / Eclipse

先上错误
无法联接数据库
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中文乱码 - C/C++ / C++ 语言

mysql数据库的编码格式是utf8
在c++程序中使用C API直接连接mysql数据库,把中文保存到mysql数据库中,中午变成乱码
使用mysql的load命令导入文本文件,无论文本文件是ANSI还是utf8编码,都是乱码
请问上面两个问 ......

Mysql效率问题 - 其他数据库开发 / MySQL/Postgresql


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 - MS-SQL Server / 基础类

刚刚接触MySQL,不知道该如何去查看数据,插入数据,创建数据库、表,用哪为前辈能指教一二?

MySQL 5.1参考手册

引用
兄弟你会结贴吗?
mysql 参考手册

baidu

MySQL官方文档 http://dev.mysql.com/doc ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号