ibdata1 corrupted

mesranet

• August 13, 2016 06:21

Dear All, Today is my bad day, one of my server having issue with bad sector, when i try to copy everything to new hard disk, seem the only ibdata1 is unavailable to copy with input/output error, that mean the bad sector is seriously on the 8GB ibdata1, trying to fsck but still no luck, then trying to add the line of innodb_force_recovery = 1 - 5 at my.cnf also no luck, the mysql wont restart, the last thing is to copy ibdata1 from the last week backup and also the same issue. I'm totally lost, what should i do? Please help

• 

  24x7server

  • August 13, 2016 11:29

  You will be lucky if you have SQL dump file of the databases, I think you will have to restore the SQL database dumps on the new server as that will restore the innodb table information for that database.

  0
• 

  mesranet

  • August 13, 2016 11:46

  Dear Tech, Is it possible if i only need to restore all the client database without restoring email or any other data ? Will that possible ? Hopefully if you can give proper step. TQ so much

  0
• 

  Infopro

  • August 13, 2016 17:40

  I'm totally lost, what should i do?

  
  This thread may be of some use to you: InnoDB Corruption Repair Guide

  0
• 

  mesranet

  • August 14, 2016 10:05

  Dear All, Thanks god, after taking 1 day rest and long sleep, i got an idea by looking back to the corrupted disk, i boot the disk and i run the mysqldump --all-database > all_database.sql and its work, so now on part of restoration, may i know how to restore from the command line and how about the grant or ownership of database ? Please help. TQ

  0
• 

  cPanelMichael

  • August 15, 2016 01:20

  Thanks god, after taking 1 day rest and long sleep, i got an idea by looking back to the corrupted disk, i boot the disk and i run the mysqldump --all-database > all_database.sql and its work, so now on part of restoration, may i know how to restore from the command line and how about the grant or ownership of database ?

  
  Hello, You can restore the databases with a command such as:
  mysql < /path/to/all_databases.sql
  Also, the

  0

Please sign in to leave a comment.