How to copy entire database?

Capitan Hosting

You will need to export the original database, and import to a new database.

Exporting Database:

  1. Go to existing database in phpMyAdmin
  2. Click Export at the top
  3. Leave the settings as they are, click the “Save as file” checkbox and click Go
  4. This will download a .sql file to your computer

Importing a database?

  1. Create a new database in cPanel
  2. Go to phpMyAdmin
  3. Click the new database name in the top left
  4. Click Import in the main area of phpMyAdmin
  5. Browse for the .sql file on your computer and click Go
Back to top