How to Clone a MySQL Database on the Same Instance?

Cloning a MySQL Database on the Same MySQL Instance

Replicating a database on the same MySQL instance can be achieved without the need for an intermediate SQL script dump. The following method utilizes the mysqldump and mysql commands to perform the cloning process efficiently:

<code class="bash">mysqldump --routines --triggers <original_database_name> | mysql <new_database_name></code>

This command will pipe the output of mysqldump, which includes the data and schema of the original database, directly into mysql, which will create the new database and populate it with the copied data.

Additional Options:

Both mysqldump and mysql allow for additional options to specify connection details:

<code class="bash">mysqldump -u <username> --password=<password> <original_database_name> | mysql -u <username> -p <new_database_name></code>

If the new database doesn't exist, it must be created beforehand:

<code class="bash">echo "CREATE DATABASE <new_database_name>" | mysql -u <username> -p</code>

The above is the detailed content of How to Clone a MySQL Database on the Same Instance?. For more information, please follow other related articles on the PHP Chinese website!