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 generate MySQL (backup) dump from the command line in Windows VPS?

This article will assist you how to generate MySQL (backup) dump from the Command line in the...

Fix - Collection Max error, Cannot Connect to Server

Problem Statement Recently one of our customers was unable to connect to Collection Max and...

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....

How to turn on/off Mysql strict mode in the Windows server?

By default in the windows server, the strict mode will be enabled on MySQL. Please refer to the...

How do I connect to MySQL server from phpMyAdmin?

This article will guide you on how to connect to MySQL server from phpMyAdmin. You can obtain...