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 » How to import your MySQL database

How to import your MySQL database
  1. Go to phpMyAdmin
  2. Click the new database name in the top left (optional)
  3. Click Import in the main area of phpMyAdmin
  4. Browse for the .sql file on your computer and click Go

The optional step depends on if the new database name exists. If yes, then go ahead and click it. If no, skip it. If you get an error, refer top the list below.

Common Issues

Your import file is too large!
You will know this is the case when phpMyAdmin times out. (It will timeout after 30 seconds of attempting to import.) Simply email support@notableweb.com with the import file attached. Our administrators will import the database for you.

#1044 - Access denied for user 'username1'@'localhost' to database 'user2_wrdp9'
The problem here is your import file contains an SQL query that attempts to create a database for the wrong username. Notice the user2 in 'user2_wrdp9' does not match the username1 in 'username1'@'localhost'. Someone must edit the import file and change the old user2 to your new username1. (If you do not feel comfortable editing your import file, we will be glad to help you do that.) Here is an example of what it looks like (notice 3 places where the username is outdated):

□□--□-- Database: `user2_wrdp9`□--□CREATE DATABASE `user2_wrdp9` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;□USE `user2_wrdp9`;□□--

#1044 - Access denied for user 'username1'@'localhost' to database 'wrdp9'
Same as the previous issue; the correct username is missing. On a shared sever, your database names must always look like something_something.

#1049 - Unknown database 'username1_wrdp9'
The problem is your import file does not have a query to create the database before importing the data. Simply go to cPanel > MySQL Databases and create a database with that name (in my example, "wrdp9"). Then re-attempt your import.

#1007 - Can't create database 'username1_wrdp9'; database exists
The problem here is your import file contains an SQL query that attempts to create a database that already exists. If the database is empty, simply go to cPanel > MySQL Databases and remove that empty database; then re-attempt your import. If the database is not empty, someone must edit the import file and remove the CREATE DATABASE query. (If you do not feel comfortable editing your import file, we will be glad to help you do that.) Here is an example of what it looks like:

□CREATE DATABASE `username1_wrdp9` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

Less Common Issues

ERROR 1044 (42000): Access denied for user 'username1'@'localhost' to database 'username1_wrdp9'
If you get this error, you do not have privileges on user_* to use Create. Notable Web needs to correct this issue for you.

However, if you need to import now, and can't wait, here is a work-around.

The problem here is your import file contains at least one SQL query that attempts to create a database, and you do not have the privilege to do so. Someone must edit the import file and remove the CREATE DATABASE query. (If you do not feel comfortable editing your import file, we will be glad to help you do that.) Here is an example of what it looks like:

□CREATE DATABASE `username1_wrdp9` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

After you remove this code, you must go to cPanel and click the MySQL Databases icon. Here you must create your database with the name which was removed from the import file (in my example, "wrdp9"). Then you can Import the modified import file and it will work.




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.