PhpMyAdmin Importing Database

From Hostek.com Wiki
Revision as of 13:16, 15 October 2012 by Justinaes (Talk | contribs) (Timing Out During Import)

Jump to: navigation, search


How to import your MySQL database

  1. Access Windows Control Panel (WCP)
  2. Click on the phpMyAdmin icon in the Database section
    1. If you have multiple databases/users, choose which database your want to access
  3. In phpMyAdmin, click on the database
  4. In the tab section look for select Import
  5. Under the File to Import: section, select Browse... to locate the SQL or .zip file on your computer
  6. 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.


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.