1. bluehost knowledge base

How To Copy A Database Using PHPMyAdmin

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

  1. Log in to your Bluehost control panel.
  2. Under the Database section, select phpMyAdmin.
    Name of the article
  3. Select the database you wish to copy (by clicking on the database from the phpMyAdmin home screen).
  4. Once inside the database, select the Operations tab.
  5. Scroll down to the section where it says "Copy database to:"
  6. Type in the name of the new database.
  7. Select "Structure and data" to copy everything.  Alternately, you can select "Structure only" if you want the columns but not the data.
  8. Check the box "CREATE DATABASE before copying" to create a new database.
  9. Check the box "Add AUTO_INCREMENT value."
  10. 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.

For further assistance, you may contact our Chat Support or Phone Support via 888-401-4678. You may also refer to our Knowledge Base articles to help answer common questions and guide you through various setup, configuration, and troubleshooting steps.