MySQL Utilities 1.4 Manual  /  ...  /  How Do I Make a Copy of a Database on the Same Server?

3.1.2. How Do I Make a Copy of a Database on the Same Server?

If you are working with a database and want to experiment with changes to objects or data either from direct manipulation (SQL commands) or as a result of interaction with an application, it is prudent to always have a copy to fall back to if something should go wrong.

Naturally, a full backup is key for any production server but what if you just want to do something as a test or as a prototype? Sure, you can restore from your backup when the test is complete but who has the time for that? Why not just make a copy of the database in question and use it?


User Comments
Sign Up Login You must be logged in to post a comment.