How to Clone MySQL database using PhpMyAdmin?

Database clone is a process to create a separate copy of the database. You can also use it as your Backup. Following are the steps to clone a MySQL Database from phpMyAdmin.

  1. Login to your phpMyAdmin from via your controlpanel.

  2. Once you are logged in to phpMyAdmin, click on the database which you want to clone.

  3. Click on Operations Button from the Top.

  4. At Copy Database to Box, enter the new name of the Database. It will be clone with the same name you provide here.

  5. Select the structure and data option to copy everything.

  6. Check the box CREATE DATABASE before copying and Add AUTO_INCREMENT value.

  7. Click on Go Button.

  8. To verify the clone Database click on the Databases button. Here, you should view your clone database with the name you have provided.

          This is it. We are done with the database clone.

  • 0 Users Found This Useful

Was this answer helpful?

Related Articles

How to Allow Remote Connection to MySQL Server in Windows?

This article will assist you to enable remote access to MySQL server through Windows command...

How to change phpMyAdmin password?

Following tutorial will guide you to reset the phpMyAdmin password. We assume that you have...

Fix :: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found

Error Message ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no...

How to connect MySQL using PHP?

Here, We have mentioned 4 methods to connect MySQL using PHP. Php extension(mysqli) Php data...

How to Stop and Start MySQL Service in Windows and Linux VPS?

This article will assist you to stop and start MySQL service from Windows VPS and Linux VPS....