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.

Paul Kukiel


Cras justo odio, dapibus ac facilisis in, egestas eget quam. Curabitur blandit tempus porttitor. Vivamus sagittis lacus vel augue laoreet rutrum faucibus dolor auctor.

1 comment: