Select Category
Sitemap Help Contact
print article

Import Your MySQL Database Using phpMyAdmin

This article has not been rated yet.
For Hosting packages

Learn how to use the phpMyAdmin web interface to import data into your MySQL database.

Step 1
Log in to your 1&1 Control Panel
Step 2
Click the MySQL link from the Hosting panel.
Click MySQL
Click MySQL

Step 3
Click the phpMyAdmin button for the database which will hold the imported data. This database should be completely empty to accept the import.

If you have not already done so, you may need to Create a MySQL Database so that you have an empty database in which to import your data.

Click phpMyAdmin
Click phpMyAdmin
Step 4
This will launch a new window where the phpMyAdmin for your database has been setup. At the top left, click on the query window icon (this will also open in a new window). Click the SQL icon
Click the SQL icon
Step 5
Click on the Import files tab. Click Import files
Click Import files
Step 6
Click the Choose File button to browser your computer for the file to import.
Please note:
Check the Max file size value against your import file. If your import file is larger than the maximum file size stated on the page, the import will fail. Please Import Your MySQL Database Using SSH instead. There are no file size limitations when importing using SSH.
Click Browse
Click Browse
Step 7
Locate the SQL file on your computer that you would like to import and then click the Open button. Click Open
Click Open
Step 8
As long as the file does not exceed the maximum file size limit, you may now click the Go button to import the database. If you are unsure of the file size, phpMyAdmin will report an error if the file is too large. Click Go
Click Go

If your datatbase file can not be imported via phpMyAdmin because of a large file size, you may import the database file via SSH if your package comes with SSH access.

For additional information, you may want to reference: