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.

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 connect MySQL using PHP?

You can connect your MySQL with PHP using the below methods. Method 1 - PHP extension(mysqli)...

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

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

  • 0 Users Found This Useful

Was this answer helpful?