Copy/duplicate mysql database

When you need make a working copy of your database for example to use with copy of your wordpress site, you need to make few things:

Now that we have a db, let us dump the original db to file:

This will dump database_to_copy database to file named db-copy.sql. Now we need to import this dump to our newly created database db_copy.

Facebooktwittergoogle_plusreddit

Leave a Reply

Your email address will not be published. Required fields are marked *

*