While testing mysql work bench I accidentally deleted my database. I have no backup. But still I have see some frm, myi ,and myd files. I had both innodb and myisam tables. So is there any chance at all recovering the db from these files?
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.
Shop for your Apple, Mac, iPhone and other computer products on Amazon.
We are a participant in the Amazon Services LLC Associates Program, an affiliate program designed to provide a means for us to earn fees by linking to Amazon and affiliated sites.