Loading...

Knowledge Base
Up to 70% off on  WordPress  hosting for WordPress Websites and Stores!

How To Copy A Database Using PHPMyAdmin

Did you find this article helpful?
Copy Link

 
* Your feedback is too short
Share

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

  1. Log in to your Bluehost Account Manager.
  2. Click the Hosting tab from the side navigation menu to the left.
  3. Click the CPANEL button under the Quick Links section.
  4. Under the Database section, select phpMyAdmin.
  5. Select the database you wish to copy (by clicking on the database from the phpMyAdmin home screen).
    phpmyadmin-expand-tables
  6. Once inside the database, select the Operations tab.
    phpmyadmin-copy-database
  7. Scroll down to the section where it says "Copy database to:"
  8. Type in the name of the new database.
  9. Select "Structure and data" to copy everything.  Alternately, you can select "Structure only" if you want the columns but not the data.
  10. Check the box "CREATE DATABASE before copying" to create a new database.
  11. Check the box "Add AUTO_INCREMENT value."
  12. 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.
phpmyadmin-home-icon

If you need further assistance, feel free to contact us via Chat or Phone:

  • Chat Support - While on our website, you should see a CHAT bubble in the bottom right-hand corner of the page. Click anywhere on the bubble to begin a chat session.
  • Phone Support -
    • US: 888-401-4678
    • International: +1 801-765-9400

You may also refer to our Knowledge Base articles to help answer common questions and guide you through various setup, configuration, and troubleshooting steps.

Did you find this article helpful?
Copy Link

 
* Your feedback is too short

Loading...