CODEWITHSUNDEEP
mysqlapachexampprestore
Ben Pearce
Ben Pearce

Reputation: 7094

Restoring SQL tables from .MYD, .MYI and .frm files, mysql can't find .frm files

I recently had to re-install XAMPP on my Mac and I'm now trying to restore some SQL database tables from .MYD, .MYI and .frm files. I have tried dragging them into the file below:

xamppfiles/var/mysql/{database_name}

As per the instructions in the following links

How to recover MySQL database from .myd, .myi, .frm files

Restoring MySQL database from physical files

The table is listed in phpMyAdmin but when I try to view it I get the error below

#1017 - Can't find file: './{database_name}/{table_name}.frm' (errno: 13)

I have tried changing the permission on the .frm file and running the Unix executable file

xamppfiles/bin/mysql_upgrade

Upvotes: 0

Views: 8777

Answers (2)

Help
Help

Reputation: 1

MySQL Utilities: using the FRM Reader

Upvotes: 0

Redas Jarušaitis
Redas Jarušaitis

Reputation: 11

MySQL Server must be down while copying files.

Upvotes: 1

Related Questions