mySQL dump all databases command

by 11:45 AM 3 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.

3 comments:

  1. Packers 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

    ReplyDelete
  2. Packers 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