Method 1 - phpMyAdmin You may use phpMyAdmin to load your database by pasting the SQL script and execute it.

1. Login to phpMyAdmin with a MySQL user that has been given DBA rights to the MySQL database you wish to load.

2. Then click on the SQL tab.

3. Paste the SQL script content into the text area, and click Go. If the SQL script contains a lot of data, you might still get away with this by pasting it bit by bit. If the data is simply too large, see the next section.

Method 2 - mysql command line client Due to the limitations imposed by PHP, phpMyAdmin is unable to load a large MySQL dump data. You can upload the MySQL dump file created by mysqldump --opt -Q dbname to your home directory, and then execute the MySQL client to load it.

This requires you to have SSH Access. To load your sql dump using MySQL, you can use the following command: mysql -h mysqlhost -u mysqlusername -p databasename < dumpfile or cat dumpfile | mysql -h mysqlhost -u mysqlusername -p databasename

Where: mysqlhost - The name of the server where your MySQL database is located.

You can find this out from the Control Panel in the MySQL Database area. mysqlusername - Your MySQL User name as created through the Control Panel.

This User must have DBA rights to the database so it can create / drop tables. databasename - This is the name of your database dumpfile - The file created by mysqldump