MySQL Forums
Forum List  »  Data Recovery

Recover missing schema
Posted by: Thiago Moreno Thimor
Date: February 23, 2015 07:32AM

Hi everyone,

I do not know how, but all innodb schemes disappeared from mysql. The schemas folder is also not in the data directory. It was only the ibdata, the ib_logfile0, ib_logfile1 and mysql and test folders.

I do not know if someone or some virus deleted. I want to know whether we can recover, because unfortunately have no backup.

I tried a tutorial that restore an old backup and then overwrites the file ibtada ib_logfiles and then start mysql with innodb_force_recovery = 6 parameter.

The database starts, but the INFORMATION_SCHEMA.TABLES table does not get the reference of the schemes that are gone.

Is there any way to recover the database without the backup?


Options: ReplyQuote

Written By
Recover missing schema
February 23, 2015 07:32AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.