Copy Entire Database or Rename Database

Is there a way for me to copy an entire database in cPanel 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.

If you experience this timeout, please upload the database backup file to your Deezon account and email support@deezon.com with the details. Our administrators will perform the import for you. For security reasons, it's best to upload your database to the /home/USERNAME section of your account. (Replace USERNAME with your cPanel username.)


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.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Apache Error Logs

When you check the error logs, you can see many things. Some things you can ignore: File does...

Accessing Web Disk

Web disk (also known as Web Dav) is a drag-and-drop interface which allows you to access your...

Apache Handlers (running html as php)

Apache handlers allow you to control what Apache will do with certain file types. When Apache...

Backup File Types

So, you have a backup file, but you need to know what type of backup it is so you can know what...

Custom Error Pages

To create a custom error page for your account, please login to cPanel and click Error Pages,...