Question

Locked

Is it possible to restore mysql database from frm myi and myd files only?

By FrankKelly ·
Tags: Windows, Software
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.

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

mysql database

by KristofLakatos In reply to Is it possible to restore ...

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. You can still read this resource for more information on your issue.
https://community.office365.com/en-us/f/172/t/266451

Collapse -
by ahmed052 In reply to Is it possible to restore ...

the commnetis useful


http://energypastry6.picturepush.com/profile
نقل الاثاث قي العين

Collapse -

mysql

by faeshaun In reply to Is it possible to restore ...
Back to Windows Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums