ibbackup报错
使用ibbackup备份数据,出现以下问题。
ibbackup: Error: page at offset 0 1000669184 in /home/longxibendi/mysql/var/ibdata1 seems corrupt! 使用ibbackup备份出现这个错误。就是有块data无法读取出来
ibbackup: Re-reading page at offset 0 1000669184 in /home/longxibendi/mysql/var/ibdata1
ibbackup: Re-reading page at offset 0 1000669184 in /home/longxibendi/mysql/var/ibdata1
ibbackup: Re-reading page at offset 0 1000669184 in /home/longxibendi/mysql/var/ibdata1
ibbackup官网给出的解决方法,有谁用过。http://dev.mysql.com/doc/mysql-enterprise-backup/3.5/en/bugs.corruption.html
目前想的解决方法是:
1.导出全库,全表。
2.使用xtrabackup试着备份。
3.停主库,从主库copyvar 到从库。
谁遇到过这个问题。
页:
[1]