Restore MySQL DB from file system
Added by Anonymous over 12 years ago
After a system crash I'am not able to restore my redmine mysql database. I have a complete file system backup, but no SQL dump.
When I copy the old mysql/redmine folder into the new data base, I can see the db, use the db, show the tables, but cannot select something from one of the tables.
I get the following error:
ERROR 1146 (42S02): Table 'redminebackup.wikis' doesn't exist
The strange thing is the folder under mysql/redmine contains only .frm files, as far as I know these contain only the table structures and the data is stored in .MYD files, but these are missing in a fresh redmine installation, too.