CODEWITHSUNDEEP
mysqldatabasesdi
newCoder
newCoder

Reputation: 25

Move tables backup to local

I had a dropped a database by mistake, but I still have the 3 extensions of my tables inside the database (MYD, MYI and sdi), when I move these files to "/usr/local/var/mysql/MY_DATABASE" inside MacOs, and I go into phpMyadmin or MySQL, I could not find the table, is there a way to backup my tables inside my database?

Upvotes: 0

Views: 54

Answers (1)

BendaThierry.com
BendaThierry.com

Reputation: 2109

You can restore tables (orphan included) following instructions provided in MySQL documentation : https://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html

Upvotes: 0

Related Questions