I'm having problems restoring a MySQL database from a backup and I hope you can help me.
There is a backup on my external drive, a folder full of *.frm, *.MYD and *.MYI files.
I copied the folder over to my working drive and I restarted the MySQL server and phpMyAdmin doesn't list all of the tables I would expect.
This question is XenForo related, the backup is from beta 1 but now most of the tables are missing and I am left with 8 tables.
In the backup folder there are 132 files so I'm almost sure all tables are there but why don't the show up?!
Oddly enough the dropdown in phpMyAdmin displays the correct number of the tables in database but as soon as I open it I can only see those 8 tables.
Unfortunately the backup is from my old iMac, I tried to start from the external drive but it doesn't
Can anyone help me please?