To restore your mysql database from dump file, specially with large backup file, you should do it from shell command in unix/linux or command prompt in Windows by using mysql command.
1. Restore mysql database from dump sql file
mysql -u root -p your_database_name < your_dump_file.sql |
2. Restore mysql database from dump sql file with GZIP compression
gunzip < your_dump_file.sql | mysql -u root -p your_database_name |
The command above assumes that you would to restore a database named “your_database_name” from a backup sql dump file named: “your_dump_file.sql” with Mysql root account.
Note: you should be asked to enter your mysql account password, once you enter the password just key in your database password and you are done after minutes 🙂
If you need to know how to backup your mysql database, read this post.