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!
ReplyDeletePackers and Movers Bangalore - Reliable and Verified Household Shifting Service Providers Give Reasonable ###Packers and Movers Charges. Cheap and Best Office Relocation Compare Quotation for Assurance for Local and Domestic House Shifting and Get estimates today to save upto 20%, ***Read Customer Reviews - @ Packers And Movers Bangalore
ReplyDeletePackers and Movers Chennai Give Safe and Reliable ***Household Shifting Services in Chennai with Reasonable ###Packers and Movers Price Quotation. We Provide Household Shifting, Office Relocation, ✔✔✔ Local and Domestic Transportation Services, Affordable and Reliable Shifting Service Charges @ Packers And Movers Chennai
ReplyDelete