How to copy/duplicate a database in phpMyAdmin

This is recommended for making backups of your database.

Begin by accessing phpMyAdmin.

  1. Select the database you wish to copy (by clicking on the database name on the left side of the phpMyAdmin home screen).
  2. Once inside the database, select the Operations tab.
  3. Scroll down to the section where it says "Copy database to:"
  4. Type in the name of the new database.
  5. Select "structure and data" to copy everything. Alternately, you can select "Structure only" if you want the columns but not the data.
  6. Check the box "CREATE DATABASE before copying" to create a new database.
  7. Check the box "Add AUTO_INCREMENT value."
  8. Click on the Go button to proceed.

If you click on the home icon, 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.

Properties ID: 000394   Views: 3940   Updated: 9 years ago