易截截图软件、单文件、免安装、纯绿色、仅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编译器的Eclipse的时候,对环境变量进行了配置,在安装MySQl的时候也要对环境变量进行配置;那么后面的配置会影响前面的Eclipse的配置吗?
请大家多指教~!谢谢!
不会把,我这都装了的 我系统里 还装了 ......

mysql数据库 - Java / Java相关

CREATE DATABASE ADDRESSLIST;
USE ADDRESSLIST;
DROP TABLE IF EXISTS FRIEND;
CREATE TABLE FRIEND
  (FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ,
FRIEND_NAME VARCHAR(20) NOT N ......

关于MySQL删除记录后ID如何联系

id INT NOT NULL PRIMARY KEY AUTO_INCREMENT
然后删除数据库中的若干重复记录后ID变的不连续,如何变得连续??
运行
ALTER TABLE tablename DROP id;
ALTER TABLE tablename ADD id INT NOT NULL PRIMARY KEY ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号