How do I import data into a MySQL database?
Print this Article
Comment on this Article
Last Updated:
September 2, 2008 3:46 PM
To Import a .SQL File Into a MySQL Database:
- Log in to your Account Manager.
- Under the My Products section, select Hosting.
- Click Manage Account.
- Under the Databases heading, click MySQL.
- Click the Open Manager button.
- Enter your user name and password for your database.
- Click the database into which you are importing data.
- On the far upper-left corner of the page, click the SQL button. This will be immediately to the right of the green Exit button.
- Click the Import files tab in the new window that appears.
- Click Browse, and then locate the .SQL file on your machine.
- 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.
NOTE: It is unnecessary to include a CREATE DATABASE line in your MySQL database, and if present can even cause your import to fail. If your database includes this line, remove it before uploading the database to your hosting account.