1

Actually i have problems with the database always down due to log. Usually when I restart it will work just fine. But recently the database cannot start and make me think to simply delete those mention file. At first I thought it's ok after delete the files because mySql can run as usual but i just found out that I lost my wordpress database. Upon checking mysql admin console, I can see all the tables are there. But I cannot perform any queries on it. How do I get back those missing tables as well as the data.

  • 3
    The ibdata1 file contained the actual data. You will need to restore from a backup. – Michael Hampton Dec 25 '15 at 4:39
  • 1
    depends. there’s a mode when innodb stores each table in separate files. – poige Jan 16 at 20:32
2

The ibdata files contain some of your InnoDB table data. Removing them has likely rendered the InnoDB data within your tables corrupt.

At this stage you should probably look into restoring a backup. Alternatively you could try to recover the data with extundelete, or similar tools for data recovery.

1

You should reach for your backups and restore from them. If you don't have backups then you could try undeleting the files but make a copy of the disk (using dd) and work on that.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.