Restoration Of MySQL Database From SQL Dump File

- Click on Import tab on the top.
- Select your sql dumb file at File to import
- Then select your mysql database charset (ex: Latin1, utf-8)
- and click GO and it�s completed!

There are two ways to restore your MySQL Database from sql dump file.
1st way to restore mysql database from sql dump file is using mysql web control panel � phpMyAdmin
- Log in to phpMyAdmin.
- Select your preference database on the left database navigation drop down list.

The solution to restore huge mysql database from sql dump file is using unix/linux shell command.
To restore mysql database from a dump file, type the command below:-

Do not use phpMyAdmin to import or restore your MySQL database if your MySQL database file is huge. This is because, phpMyAdmin has limit on total upload size which depend on php setting. Besides, there is also maximum execution time which may cause browser to time out.



mysql -u #username# -p #database# < #dump_file#

Of work you need to replace #username# to your database username and #database# to your target database. and rename #dump_file# to your dump file file name (Ex: dump.sql) One time you enter the command, the linux/unix shell will prompt you for your database user password, key in your database password and you are completed.