客 户 名 称    北京某电子商务公司
 
数 据 类 型    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)MySQLMySQL Server 5.5binmysqld-nt: ready for connections.
Version: '5.5-community-nt'  socket: ''  port: 3306  MySQL Community Edition (GPL)
 
启动完成，导出客户需要的4个数据库为.SQL备份文件.
 
客 户 满 意   是   数据完美OK。
 
 
 
河南云尚云数据救援中心友情提醒：重要数据一定要勤备份，遇到数据丢失 数据损坏 等问题，要第一时间联系专业人士。
 
对于各类主流数据库，我们可以做最底层的数据恢复及数据修复，对于数据库的某些特定故障我们保证数据库100%原模原样恢复，
无论多大的数据库都立等可取。