mySQL dump all databases command

by 11:45 AM 1 comments
I recently had to move data from one server to another.  The serevr runs linux, Railo and mysql.  It's always a pain migrating databases bewteen servers but mysql makes this so easy:

This will prompt you for the root password but if you want to can add the password after the -p and not be prompted.

Thats it.  you can now run this and restore all your databases on the new server or pick through it and restore the ones you need.

1 comment: