Skip navigation links

MySQL Forums :: InnoDB :: How to restore the database from ibdata, and frm files


Advanced Search

Re: How to restore the database from ibdata, and frm files
Posted by: Anirban Basu ()
Date: October 26, 2005 11:22PM

I also had to restore my database from my ibdata and .frm files. I copied my old database's entire /data folder to a backup location. Then i COMPLETELY uninstalled my old MySQL installation, and MANUALLY DELETED the old /data folder (MySQL uninstall doesn't do this for you).

Then I did a new installation of MySQL. Through an administrative tool called "Navicat", I created empty databases that were named the same as my old databases. This created corresponding database folders under the /data folder of my new MySQL installation.

Next, I turned off the MySQL service and closed out Navicat. I then copied the database folders from my backed up /data folder location to the new installation's /data folder location. Finally, I copied the ibdata1 file from my backed up location to the new installation's /data folder. Note, I DID NOT copy the ib_logfile0 or ib_logfile1 files from the old backup location.

Finally, I restarted the MySQL service, went back into Navicat, and the data was all restored! Please let me know if you need any more info on this...

-Bappa

Options: ReplyQuote


Subject Views Written By Posted
How to restore the database from ibdata, and frm files 49041 Salman Ashraf 09/29/2005 03:28PM
Re: How to restore the database from ibdata, and frm files 25269 Tyson 10/17/2005 12:15PM
Re: How to restore the database from ibdata, and frm files 28326 Dustin Davis 10/18/2007 06:10AM
Re: How to restore the database from ibdata, and frm files 40216 Anirban Basu 10/26/2005 11:22PM
Re: How to restore the database from ibdata, and frm files 15972 Lijo K I 10/22/2007 07:35AM
Re: How to restore the database from ibdata, and frm files 12230 Emmanuel arulgobinath 03/18/2008 11:29AM
How to restore the database from ibdata, and frm files 10219 Garto Monage 03/12/2009 05:09PM
Re: How to restore the database from ibdata, and frm files 9474 chhivhorng ly 03/30/2009 07:47PM
Re: How to restore the database from ibdata, and frm files 8234 vincent majavu 05/28/2009 02:28AM
Re: How to restore the database from ibdata, and frm files 9302 Sachin Sundar 07/20/2009 08:45PM


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.