Associate
- Joined
- 14 Apr 2003
- Posts
- 1,101
Hi,
I accidentally dropped and rebuilt a production database
I have the innodb binary log files (ibdata1 etc) and the .frm files of the database in question. I have also followed the following tutorial:
http://egil.biz/how-to-recover-mysql-data-from-innodb/
However, because I didnt just delete the table, but recreated it the backup produced by that tutorial is a lot of empty tables. Is there any way to rollback to a previous version using the ibdata1 file? I know the data is in there somewhere...
I accidentally dropped and rebuilt a production database
I have the innodb binary log files (ibdata1 etc) and the .frm files of the database in question. I have also followed the following tutorial:
http://egil.biz/how-to-recover-mysql-data-from-innodb/
However, because I didnt just delete the table, but recreated it the backup produced by that tutorial is a lot of empty tables. Is there any way to rollback to a previous version using the ibdata1 file? I know the data is in there somewhere...