phpMyAdmin operation tips: How to copy MySQL database in phpMyAdmin?

Turn the--http://blogunion.org/posts/copy-mysql-data-in-phpmyadmin.html

For each webmaster, will encounter the site to test the time. At this time, it is often necessary to back up the database. If you follow the normal operation, the database is exported and backed up locally before being tested on the server. If everything is OK, once something goes wrong, you have to re-import the database locally to the server. If the database is relatively large, especially for the longer-standing stations, there may be a single database close to a G. If you follow the usual export and re-import method, the estimate will be directly on the street.

At this time, you can copy the database directly inside the phpMyAdmin operation. In the event of a problem, simply modify the database configuration file and connect directly to the backup database. Here's how it works:

1, login to the phpMyAdmin management interface, click to enter the database you want to copy, and find the navigation bar operation options.

2, after entering the interface, pull down, there is a Copy database box, fill in the name of the database you want to copy to, and click on the execution.

3, when the following prompt, it indicates that the data card replication is successful, you can directly do the operation of the database.

It is absolutely useful for large database operations.

phpMyAdmin operation tips: How to copy MySQL database in phpMyAdmin?