WEB HOSTING SUPPORT NETWORK
     
 

Importing a database using phpMyAdmin

We assume that you already have an SQL dump/schema file of your database on your computer, or you have it uploaded on your hosting account with us.

To import the MySQL database using phpMyAdmin, please follow these steps:

1. Load the phpMyAdmin interface via the "MySQL databases" section in your Control panel. Detailed information on accessing the phpMyAdmin interface is available in the Accessing phpMyAdmin article.

2. In phpMyAdmin you need to select the database in which you want to import the SQL dump. If you have not created any databases, please check the Creating a MySQL database article for detailed information on creating a database.

In order to select a database in phpMyAdmin, please click on the "Databases" link and load the list of databases

Select a MySQL database.

After the list of database is loaded, you need to click on the name of the database you want to manage.

Select a MySQL database.

3. On the next screen you need to click on the "Import" link on top of the page.

Importing an SQL dump.

4. On the next screen you will see the Import options.

You can import an uncompressed SQL dump file, or a file compressed in .zip, .gzip or .bzip2 format. In case the SQL file is big (more than 5-10MB), then you should use the database Import Wizard in the "MySQL databases" section in the Control panel. You can check the "Importing a database" article for additional information on using the Import Wizard.

Click on the "Browse" button to select a file from your local computer.

If the SQL file uses a character set other than UTF-8, you need to select the appropriate character set. In most cases you need to leave the default value of UTF-8.

If the file is in format, other than SQL, select the appropriate format from the "Format" drop-down menu.

When ready to upload and import the file, click on the "Go" button.

Importing the SQL dump.