MySQL Forums
Forum List  »  Data Recovery

Re: How to access old mysql databas??
Posted by: addision philip
Date: October 20, 2011 04:09AM

Hello Jonas,

You can flow these steps:

Install the same version of mysql.
Remove mysql directory from data directory of the server and copy it from the crashed server. This is the key element.
Copy directory of database you want to recover into data directory of new server.
Start mysql.
Switch to mysql database: USE mysql; and run REPAIR TABLE <table name> on every table.
Do the same with database you want to recover.

Ref: http://stackoverflow.com/questions/3799743/how-can-i-recover-mysql-tables-from-data-files



Edited 2 time(s). Last edit at 10/20/2011 02:13AM by addision philip.

Options: ReplyQuote


Subject
Views
Written By
Posted
2851
October 17, 2011 05:43AM
Re: How to access old mysql databas??
1894
October 20, 2011 04:09AM


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.