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

  • Question

  • User-1704542348 posted

    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.

    Monday, May 16, 2016 5:20 PM

Answers

  • User553715758 posted

    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

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, May 23, 2016 6:28 PM

All replies

  • User77042963 posted

    You posted your question in a wrong place. This is SQL Server related forum.

    Monday, May 16, 2016 6:19 PM
  • User553715758 posted

    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

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, May 23, 2016 6:28 PM
  • User-1704542348 posted
    I am very grateful for your advice. Thank you very much! The issue has been resolved.)
    Friday, May 27, 2016 3:29 PM