[l008com]

I'm looking for an easy way to backup and restore all of my SQL databases. I found a Cocoa program for doing stuff with MySQL but strangely it won't connect to my server. I have phpMyAdmin but it doesn't have any sort of backup feature. I'd prefer something simple that will, in one step, backup ALL databases into one neat package.

[ttjervaag]

Open a terminal and type:

mysqldump -u USERNAME -p --all-databases > backup.sql

, substituting USERNAME with your user. This will pipe the output of the mysqldump command to backup.sql.

And if you need to restore your database, type

mysql < backup.sql

, and you're off. You probably need some login information in that line as well...

hope this helps,
Terje