Difference between revisions of "PhpMyAdmin Importing Database"
(→How to import your MySQL database using phpMyAdmin) |
|||
| Line 4: | Line 4: | ||
| − | # Access <b>Windows Control Panel (WCP)</b> | + | # Access <b>Windows Control Panel (WCP)</b> [https://wcp.hostek.com wcp.hostek.com] |
# You will first need to create a MySQL database by clicking on the <b>MySQL Icon</b> in the <b>Database</b> Section. | # You will first need to create a MySQL database by clicking on the <b>MySQL Icon</b> in the <b>Database</b> Section. | ||
## NOTE: If you just created the database, you will need to refresh the page in order to complete the next step. | ## NOTE: If you just created the database, you will need to refresh the page in order to complete the next step. | ||
| Line 19: | Line 19: | ||
To view a video tutorial of this: | To view a video tutorial of this: | ||
[http://hostek.com/tutorials/phpma-import.html Importing databases and tables with phpMyAdmin] | [http://hostek.com/tutorials/phpma-import.html Importing databases and tables with phpMyAdmin] | ||
| − | |||
| − | |||
==Troubleshooting== | ==Troubleshooting== | ||
Revision as of 22:25, 22 October 2012
Contents
How to import your MySQL database using phpMyAdmin
- Access Windows Control Panel (WCP) wcp.hostek.com
- You will first need to create a MySQL database by clicking on the MySQL Icon in the Database Section.
- NOTE: If you just created the database, you will need to refresh the page in order to complete the next step.
- Click on the phpMyAdmin icon in the Database section
- If you have multiple databases/users, choose which database your want to access
- In phpMyAdmin, click on the database
- In the tab section look for select Import
- Under the File to Import: section, select Browse... to locate the SQL or .zip file on your computer
- 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.