What if I delete ibdata1 in mysql (LINUX)

Question

Hi,

I am using LINUX and I have mistakenly deleted ibdata1 file in mysql folder.

I restarted the 'mysqld' service and Now when I am trying to read data from the databases it is not able to find out older tables.

Am I in a big trouble? Please throw some light on this if any idea.

Thanks for your time.

Thanks and Regards, SachinJadhav.

Answer 1

You are in big trouble...

By default ibdata1 contains all the table's data (and therefore is lost). Even if you configure it to use a separate file per table, all internal MySQL's data is stored in that file, and as far as I know, there is no way to restore it.

Really hope you have a backup....

Answer 2

Unless you defined innodb_file_per_table, this is a single tablespace that along with the transaction logs (stored in ib_logfile*) keep your table data.

Deleting it will effictively delete all data stored in the InnoDB tables.