mysql数据库无法启动恢复 mysql数据库崩溃恢复 mysql数据库恢复

mysql数据库无法启动恢复 mysql数据库崩溃恢复 mysql数据库恢复

客户名称 保密

数据类型 mysql 5.5 innodb

数据容量 1500 mb

故障类型 服务器断电导致mysql无法启动。客户自己尝试innodb崩溃恢复从参数1-6无效、

innodb: for more information.

innodb: error: trying to access page number 805281720 in space 0,

innodb: space name .\ibdata1,

innodb: which is outside the tablespace bounds.

innodb: byte offset 0, len 16384, i/o type 10.

innodb: if you get this error at mysqld startup, please check that

innodb: your my.cnf matches the ibdata files that you have in the

innodb: mysql server.

innodb: assertion failure in thread 11500 in file fil0fil.c line 4578

innodb: we intentionally generate a memory trap.

innodb: submit a detailed bug report to http://bugs.mysql.com.

innodb: if you get repeated assertion failures or crashes, even

innodb: immediately after the mysqld startup, there may be

innodb: corruption in the innodb tablespace. please refer to

innodb: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html

innodb: about forcing recovery.

修复结果 数据库文件发来后 分析文件发现有垃圾事务,直接屏蔽之 ,mysql直接启动ok。导出备份完成恢复。

innodb: highest supported file format is barracuda.

innodb: waiting for the background threads to start

innodb: 5.5.46 started; log sequence number 50311840278

[note] server hostname (bind-address): '0.0.0.0'; port: 3307

[note]   - '0.0.0.0' resolves to '0.0.0.0';

[note] server socket created on ip: '0.0.0.0'.

[note] event scheduler: loaded 0 events

[note] d:\program files\mysql\mysql server 5.5\bin\mysqld: ready for connections.

version: '5.5.46-log'  socket: ''  port: 3307  mysql community server (gpl)