Copy Entire Database or Rename Database

Is there a way for me to copy an entire database in cPanel?

  1. Go to cPanel > MySQL Databases and Create a New Database with the name you want.
  2. Go to phpMyAdmin and in the left menu click the original database you want to copy (do not click on any tables inside).
  3. Look to the top tabs and choose Operations.
  4. Enter the new database name (full name e.g. username_databasename) next to Copy database to: and uncheck "CREATE DATABASE before copying". Only "Structure and data" should be selected.
    • Note: You cannot use Rename database to: because you cannot create databases in phpMyAdmin.
  5. Click the GO button in the same box.


Or you can open a support ticket with the details, and our administrators will do it.


Is there a way for me to copy an entire database from another server?

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

How to export?

  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


How can I import 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


Note: phpMyAdmin will timeout after 30 seconds of attempting to import.


Is there a way to rename a database?

Unfortunately, the only way to rename a database is to copy it to a new, empty database with the desired name.

 

  • 168 Users Found This Useful
Was this answer helpful?

Related Articles

Why does my FTP fail to connect?

If your FTP progam is not connecting properly, here are some possible reasons: 1. Your firewall...

How to Use Web FTP or browser-based FTP - IE

Input one of the following URLs into your Address Bar, replacing the credentials listed with your...

Flush DNS

Sometimes there is an issue with your DNS resolvers caching the domain name to IP mapping. When...

How to change the password of your cPanel account

There may be times where you would like to change the password of your account. It is recommended...

Internal Server Error help, 500 error

Internal server errors can be caused by a few different things. Please check the Error Logs in...

Powered by WHMCompleteSolution