技术在线1
技术在线2
关注微信
13510228421
254897536@qq.com
  • 欢迎访问深圳极佳数据恢复救援网站!
0755-83281619 / 13510228421

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%原模原样恢复,
无论多大的数据库都立等可取。

联系我们

极佳技术总监:点这里给我发消息

电话: 0755-83281619

手机:13510228421 7x24小时开机

地址:深圳市福田区远洋大厦(嘉汇新城汇商中心)1213室

欢迎随时联系我们~!

Telephone

0755-83281619