The goal is to make a copy of a database and rename it to another name. We want to do this on a single database server without resorting to messy file copies and/or stopping the server.

In this case, we want to copy the world_innodb database in its entirety and rename the copy to word_innodb_clone.

The utility of choice here is named mysqldbcopy and it is capable of copying databases from server to another or on the same server. Lets have a look at the execution.

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