Restoring MySQL Databases from *.MYI & other non sql dump files

I recently needed to restore a MySQL  database from a backup of an entire filesystem without booting that filesystem up with out services running to do SQL dumps.

I was able to get the actual files containing the tables located in /var/lib/mysql/[database-name] and overwrote those files with the ones in the same location on the target machine.

I then performed the repairMyIsam tables command in the db directory.

myisamchk -r *.MYI

However using the phpMyAdmin system within Plesk it was unable to list the tables. Even restarting mysql did not help.

I then tried to list the tables while logged in as the MySQL administrator root. This worked.

All that was needed then to get it working was to recreate the DB User in Plesk and all was well.