Ok an internal Ubuntu(11.04) box died the other day. We were using it as a webserver and it had a load of mysql databases on it.
I have access to all the files from the /var/lib/mysql dir but I can't figure out how to get them back up and running on another machine. I've tried copying them into a windows mysql install and I can see all the databases in phpmyadmin but no tables.
I've also tried changing the data dir on a mysql install on another ubuntu box (I also changed the apparmor settings) but have had no joy so far...
I just want to get them up to do a data dump... Any links/pointers greatly appreciated.