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.
mySQL dump all databases command
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.
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.
Thanks!
ReplyDelete