Call us today 253-891-9648 or Toll-Free: (866) 932-9778
Follow Notable Web on Facebook

Support Topics

Contact Information

Phone:

Local:(253) 891-9648
Toll Free: (866) 932-9778

Fax:Contact Notable Web Today
    (253) 891-9412

Mailing Address:
    P.O. Box 7762
    Bonney Lake, WA
    98391

NOTABLE WEB - Support Center

Support Home Page » cPanel Administration » Copy Entire Database or Rename Database

Copy Entire Database or Rename Database
  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.




Web Site Hosting

Web Site HostingWe know exactly what it takes to make a business successful on the Internet.

Our web hosting plans are very diverse and designed for almost any type of website or e-commerce solution. Notable Web has combined the best hardware, latest software and the ...
Read More!

Web Site Design

Website DesignThe team at Notable Web strives to create websites that are easy to navigate by both human visitors and by various search engine spiders. The clean slicing and coding we use provides the fastest possible page loads. Our websites are extremely versatile and allow maximum flexability for updates. ..
Read More!

Domain Name Registration

Domain Name RegistrationA domain name is the alias that identifies a certain organizations' presence on the Internet. For example, Microsoft uses the Internet address http://www.microsoft.com.

The choice, which you make for your personal or business domain name ...
Read More!

Notable Web Incorporated © 1996 - 2018. All Rights Reserved.