Help Center

Version 2.0

• Linux Hosting
• Working With Databases

Related Articles

• Connecting to MySQL Using PHP
• Can I Use the Berkeley Database Engine With My MySQL Database?
• What are the Methods for Backing up my MySQL Database?
• Which Databases do You Support on Your Linux Hosting Accounts?
• Can I Connect to My Database Remotely?
• What MySQL Server Features are Disabled on my Shared Hosting Account?
• Setting up a MySQL Database for Your Web Site
• What is the Number of Maximum Connections Allowed to a Single MySQL Database?

How do I import data into a MySQL database?

To Import a .SQL File Into a MySQL Database:

1. Log in to your Account Manager.
2. Under the My Products section, select Hosting Account List.
3. Click the Open link under the Control panel heading for the hosting account which holds your database.
4. Under the Databases heading, click MySQL.
5. Click the Open Manager button.
6. Enter your user name and password for your database.
7. Click the database into which you are importing data.
8. On the far upper-left corner of the page, click on the SQL button. This will be immediately to the right of the green Exit button.
9. Click on the Import files tab in the new window that appears.
10. Click Browse, and then locate the .SQL file on your machine.
11. Click Go.

This will run the SQL file and update the database as specified in that file.

NOTE: The phpMyAdmin interface is limited to importing 2MB of data at one time. If you need to import more than 2MB, we recommend breaking up the file into 2MB pieces.