MySQL lost after upgrading to Snow Leopard

I made a silly mistake of upgrading Leopard a tad too soon.

I thought I dumped my mysql files but the last backup is about a 开发者_StackOverflow中文版month old.

Now I upgraded the computer to Snow Leopard, and trying to run the old mysql server wasn't happening. So I read you must reinstall mysql with a newer version which I did and it ran just fine and starts up just fine.

However - it seems it setup a new install, but since the older version cannot run on this platform - how can I dump the old data?

I tried mysqldump but it wasnt connecting.

Any ideas would be fantastic!

Have you tried PHPMyAdmin to work with the database and attempt an export? phpMyAdmin

Could you not just navigate to the folder where the MySQL data is stored for the old database server, copy the directories for each database from the 'DATA' folder to the new one and then attach the databases to the new MySQL database?