Restore the backup database to a local server.
mysql -u [username] –p[password] [database_name] < [dump_file.sql]
[username] - A valid MySQL username.
[password] - A valid MySQL password for the user.
[database_name] - A valid Database name you want to take backup.
[dump_file.sql] - The name of the backup dump file you want to restore.
Tags :
mysql