Mysql 数据库恢复案例
MYSQL数据库修复 ibdata1不能启动修复 innodb数据库修复
客 户 名 称 北京某电子商务公司
数 据 类 型 MYSQL5.5 FOR x64
数 据 大 小 4GB
故 障 检测 断电导致mysq无法启动.
客 户 要 求 恢复全部数据.要求100%完美。
修 复 结 果 :
客户传来后尝试启动数据库,mysql报错
InnoDB: than specified in the .cnf file 0 10485760 bytes!
140620 9:16:28 [ERROR] Default storage engine (InnoDB) is not available
140620 9:16:28 [ERROR] Aborting
手工修正一致性信息,再次启动报错
InnoDB: Doing recovery: scanned up to log sequence number 16 1671440031
InnoDB: Transaction 0 196602710 was in the XA prepared state.
InnoDB: 2 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 0 row operations to undo
InnoDB: Trx id counter is 0 196603136
InnoDB: Last MySQL binlog file position 0 342174, file name ./mysql-bin.000019
InnoDB: Starting in background the rollback of uncommitted transactions
InnoDB: Cleaning up trx with id 0 196602371
看以看到 MYSQL在清理事务的时候,没了反应. XA事务损坏 无法清理事务条目。
手工矫正XA事务信息 再次启动MYSQL、
InnoDB: Doing recovery: scanned up to log sequence number 16 1671439884
InnoDB: Transaction 0 196602710 was in the XA prepared state.
InnoDB: 3 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 30 row operations to undo
InnoDB: Trx id counter is 0 196602624
InnoDB: Last MySQL binlog file position 0 342174, file name ./mysql-bin.000019
InnoDB: Starting in background the rollback of uncommitted transactions
140620 9:30:00 InnoDB: Rolling back trx with id 0 196602711, 2 rows to undo
140620 9:30:00 InnoDB: Started; log sequence number 16 1671439884
140620 9:30:00 InnoDB: Starting recovery for XA transactions...
140620 9:30:00 InnoDB: Transaction 0 196602710 in prepared state after recovery
140620 9:30:00 InnoDB: Transaction contains changes to 2 rows
140620 9:30:00 InnoDB: 1 transactions in prepared state after recovery
140620 9:30:00 [Note] Found 1 prepared transaction(s) in InnoDB
140620 9:30:00 [Warning] Found 1 prepared XA transactions
InnoDB: Rolling back of trx id 0 196602711 completed
InnoDB: Cleaning up trx with id 0 196602371
140620 9:30:00 InnoDB: Rollback of non-prepared transactions completed
140620 9:30:00 [Note] D:\Program Files (x86)\MySQL\MySQL Server 5.5\bin\mysqld-nt: ready for connections.
Version: '5.5-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
启动完成,导出客户需要的4个数据库为.SQL备份文件.
客 户 满 意 是 数据完美OK。
深圳极佳数据救援中心友情提醒:重要数据一定要勤备份,遇到数据丢失 数据损坏 等问题,要第一时间联系专业人士。
对于各类主流数据库,我们可以做最底层的数据恢复及数据修复,对于数据库的某些特定故障我们保证数据库100%原模原样恢复,
无论多大的数据库都立等可取。