Importing MySQL Databases Print

Importing MySQL Databases

How to import a database:

1. In phpMyAdmin, select the new database name at the top left, if it exists. Skip this step if it does not.
2. Select "Import".
3. Find your .sql file on your computer, select "Go".

Common Errors

• If phpMyAdmin times out, your import file is too large. Timeout will occur after 30 seconds.
• #1044 - Access denied. Database contains a query that attempts to create a database for a nonexistent user. The import file must be edited. If you would like us to do it, please submit a ticket.
• #1049 - Unknown database. Your import file hasn't got a query to create a database prior to importing data. This can be fixed in cPanel - go to MySQL Database and create a database with the name the error calls for.
• #1007 - Can't create database; database exists. Your import file is attempting to create a database that already exists. If it is an empty database, delete it using the MySQL Databases tool in cPanel. If the database isn't empty, the import file must be edited to remove the query. If you would like us to do this, please submit a ticket.
• #1064 - You have an error in your SQL syntax. The import file doesn't contain the backup data for a database. The file may also have been corrupted or changed.
• ERROR 1044 (4200): Access denied for user. This is a priviledges issue, please submit a ticket. As a temporary solution, you can edit the import file to remove the CREATE DATABASE query. After removing the problem query, you can use the MySQL Databases tool in cPanel to create the database that the import file was trying to create. This should allow you to import the file.