Is it possible to restore MySQL database from FRM MYI and MYD files only?

Tags:
Database
MySQL
I accidentally deleted  my database while testing mysql work bench. As its a relatively new DB on a new server, I had no back up running. Luckily I can see some FRM, MYI and MYD files. Afaik I had both innodb and Myisam tables and some stored procs. So is there any chance at all recovering the DB from these files?
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

Copy all your
data folder into mysql/data folder (Folder to Store all database)

Create folder
with name of your database under mySql_HOME/data folder OR folder where MYSQL
save all database, on linux you can find it from my.ini file.

copy all your
.myd, .myi, etc files into that folder and restart it,

I tried this
things on windows and it works, and i am able to attached/detached all mySql database
on this way.  In a pinch, you can use the
utility MySql Recovery Toolbox and try to restore your database. I think that
you will succeed.
http://www.oemailrecovery.com/mysql_recovery.html

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: