Just Host Web Hosting Help
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 into a new database.
How to Export the Original Database
- Go to phpMyAdmin
- Click on the existing database on the left sidebar
- Click Export at the top
- Click the "Save on server in the directory" checkbox, and click Go
- This will save a .sql file to a temporary folder on your account.
How to Import onto a New Database
- Create a new database in cPanel
- Go to phpMyAdmin
- Click the new database name in the top left
- Click Import in the main area of phpMyAdmin
- Click the radio button "Select from the web server upload directory /home/USERNAME/tmp/:"
- Select the database you imported earlier from the drop down box and click Go
For security reasons, it's best to upload your database to the
/home/USERNAME
section of your account. (Replace USERNAME with your account username.)Renaming a Database
Unfortunately, the only way to rename a database is to follow the above direction and import the database to a new, empty database with the desired name.