Difference between revisions of "PhpMyAdmin Importing Database"

Revision as of 21:26, 22 October 2012

How to import your MySQL database using phpMyAdmin

1. Access Windows Control Panel (WCP)
2. You will first need to create a MySQL database by clicking on the MySQL Icon in the Database Section.
   1. NOTE: If you just created the database, you will need to refresh the page in order to complete the next step.
3. Click on the phpMyAdmin icon in the Database section
   1. If you have multiple databases/users, choose which database your want to access
4. In phpMyAdmin, click on the database
5. In the tab section look for select Import
6. Under the File to Import: section, select Browse... to locate the SQL or .zip file on your computer
7. Hit Go at the bottom of the page to being the import.

Import Video Tutorial

To view a video tutorial of this: Importing databases and tables with phpMyAdmin

Troubleshooting

#1007 - Can't create database

   #1007 - Can't create database '%dbname%'; database exists 

This indicates that you have a query in your SQL file that is
trying to create a database, and since it already exist, it will not
work. Someone must edit the file and remove the CREATE DATABASE query.

#1044 - Access denied for user

   #1044 - Access denied for user 'username'@'host' to database '%dbname%' 

The issue here indicates there is a query that is attempting to
create a database with the wrong username. If the database was created
with a different user name than what is in the SQL file, it will need to be updated.

#1064 - You have an error in your SQL syntax

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

This issue indicated that there is a error in your syntax. It could be because you are trying to import an older version of sql with outdated syntax, or the file is corrupted in some way and the sql file is not readable. You can try exporting the file from the other location, but this error will generally give a location of the syntax error, and if it is only a few things, you can update the file then try to import it again.

Timing Out During Import

If your database is timing out during the import process this could mean that your database is too large. You will need to contact support by creating a support ticket at support.hostek.com Please upload your SQL or .zip database file to your root folder of your site. Windows (wwwroot) Linux (public_html). We will need to import your database for you.