Re: InnoDB Bug
Posted by:
Rick James
Date: April 18, 2013 08:46PM
If ibdata1 is an empty file, then no InnoDB tables can be accessed.
If you had innodb_file_per_table = ON, (and the .ibd files exist), then there is a chance of recovery.
With .ibd files, it will involve something like
1. moving the .frm files out of the way.
2. starting up mysqld,
3. CREATEing the database(s) and table(s) that should be there.
CAUTION! I probably don't have the exact details, so do more research.
If you have a backup, it may be better to try to recover from it.
If you never took a backup, then :(...
Subject
Views
Written By
Posted
2305
April 14, 2013 10:43PM
Re: InnoDB Bug
946
April 18, 2013 08:46PM
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.