Copy Entire Database or Rename Database

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

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 Microhosting account and email  support@microhosting.in 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.

  • 1 Benutzer fanden dies hilfreich
War diese Antwort hilfreich?

Verwandte Artikel

How to Connect to the MySQL Database

Note: If connecting from your home computer, you need a MySQL client like Navicat,...

How to log into cPanel

cPanel is used for managing your web hosting account and available on all Microhosting Linux...

Please read before creating an Addon Domain

About addon domainsAddon Domains are handled like subdomains as far as the server is concerned,...

How to generate/download a full backup

A full backup is a backup of all of your files, e-mail, databases, etc. To run a full backup, you...

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...