1. Knowledge Base
  2. >
  3. How to Copy a Database in phpMyAdmin

How to Copy a Database in phpMyAdmin

This tutorial will demonstrate how to copy or duplicate a database in phpMyAdmin.

Begin by accessing phpMyAdmin via cPanel or Plesk. Here are the steps outlined in the video guide above.

  1. Go to your phpMyadmin.

    cPanel's phpMyAdmin

  2. Select the database you wish to copy (by clicking on the database from the phpMyAdmin home screen).

    cPanel - Choose Database

  3. Once inside the database, select the Operations tab.

  4. Scroll down to the section where it says Copy database to.
  5. Type in the name of the new database.

    cPanel - Type in New Database Name

  6. Select structure and data to copy everything.  Alternately, you can select Structure only if you want the columns but not the data.
  7. Check the box CREATE DATABASE before copying to create a new database.
  8. Check the box Add AUTO_INCREMENT value.
  9. Click on the Go button to proceed.
  10. Click on the Home icon.

  11. You will notice your new database listed in the left column. If you go inside, you will see the database is a copy of the previous database.

    cPanel - New Database

Related Articles: