5 {{ upvoteCount | shortNum }}
5 {{ upvoteCount | shortNum }}

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

by FrankKelly
5 replies
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.
#database #files #frm #myd #myi #mysql #restore
  • Profile picture of the author KirkMcD
    If the files in that directory are complete, try creating a new, blank db and the copy all the files to the directory created for the new database.
    {{ DiscussionBoard.errors[10683351].message }}
  • Profile picture of the author shsaad
    Yes it is possible to restore mysql database from those files.
    Signature

    WORDPRESS EXPERT FOR HIRE

    {{ DiscussionBoard.errors[10684608].message }}
  • Profile picture of the author KristofLakatos
    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
    {{ DiscussionBoard.errors[10692604].message }}
  • Profile picture of the author KristofLakatos
    You can still read this resource for more information on your issue.
    https://community.office365.com/en-us/f/172/t/266451
    {{ DiscussionBoard.errors[10692615].message }}
    • Profile picture of the author FrankKelly
      Thank you guys for your feedback and help. Sorry, that long time did not respond. This is because the issue was solved and I forgot to tell.) Thank you!
      {{ DiscussionBoard.errors[10698601].message }}

Trending Topics