- First take backup of your database with below command:
Code:
#mysqldump -u username -p[username_password] databasename > /path_to_your_db/databasename_backup.sql
- You have to use below command to restore your database:
Code:
#mysql -u username -p[username_password] databasename < /path_to_your_db/databasename_backup.sql