• Tweet

• Tweet

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.