How to copy a database in phpMyAdmin

Begin by accessing phpMyAdmin via cPanel or Plesk.

  1. Select the database you wish to copy (by clicking on the database from 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.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

My PHP scripts produce Internal Server Errors (500 error)

Some of our servers run PHP scripts as your own user instead of the global web server user. PHP...

PHP Sample Form mailer

Question: Where can I get sample php-form-mail script (form to email) script ? <!-- /*...

How can I view my client's web site before the domain propagates?

Since the client's account is sharing an IP with other sites, you have to use the ~account method...

How to use Entropy Search

This script enables a nice, quick search engine that can help your visitors find information that...

How to check server status?

http://www.trafficpullz.com/serverstatus/This will indicate to you whether a server or service,...