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

For security reasons, it's best to upload your database to the /home/USERNAME section of your account. (Replace USERNAME with your cPanel username.)

#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;

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near...

The file does not contain backup data for a database, or the file has been changed or corrupted.

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

 

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to log into cPanel

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

How to Connect to the MySQL Database

Host name = localhost (literally put localhost) Database name = (cpanelUsername_databaseName)...

How do I use shared SSL to access cPanel ?

Use https and our IP address, followed by the secure port number:...

How do I create and remove an Addon Domain?

An addon domain is a secondary domain hosted on a cPanel account. Addon domains typically have...

How to change DNS zones (MX, CNAME, and A records)

  Shared: With cPanel 11.25, you now have access to make some of these changes. Note: This...