I have an external hard drive that has a non-bootable clone of an old machine (that I no longer have). One of the things that was present on that machine was a MySQL installation (v 5.5.19) with several databases that I'd like to save.
I poked around and found that there's a {root}/usr/local/mysql/data
directory, and that contains subdirectories that appear to correspond to the databases I'd like to save.
I copied over one of these directories to my main machine (also running MySQL 5.5.19) and got the file permissions and ownership all set back up correctly (_mysql:wheel
, 0660
on the .frm files, etc).
When I log in to PHPMyAdmin now, I can see the database listed on the left, with the correct number of tables in parentheses. However, when I attempt to connect to that database, it says that there are no tables in the database.
Obviously, I've missed something. What have I missed, and is there another way to do this that might be easier? Could I, perhaps, alter the myriad of .cnf files to point to the MySQL files on my external hard drive and then use mysqldump
on those? Which files would I need to alter?