Knowledge Base

How to Copy or Rename a Database

How to Copy or Rename a Database

How to Copy a Database

To copy a database you will need to export the original database, and then import it onto a new database.

How to Export the Original Database

  1. Go to phpMyAdmin
  2. Click on the existing database on the left sidebar
  3. Click Export at the top
  4. Click the "Save on server in the directory" checkbox, and click Go
  5. This will save a .sql file to a temporary folder on your account.

How to Import onto a New 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. Click the radio button "Select from the web server upload directory /home/USERNAME/tmp/:"
  6. Select the database you imported earlier from the drop-down box and click Go
Note: phpMyAdmin will timeout after 30 seconds of attempting to import.

 

If you experience this timeout, please upload the database backup file to your FINCHHOST account and Create a Ticket with the details. Our technicians will perform the import for you. 

Please rate this article to help us improve our Knowledge Base.

0 0