CODEWITHSUNDEEP
macosmysql
Richard Testani
Richard Testani

Reputation: 1482

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 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!

Upvotes: 1

Views: 282

Answers (2)

Chris
Chris

Reputation: 6325

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?

Upvotes: 1

markratledge
markratledge

Reputation: 17561

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

Upvotes: 1

Related Questions