Step 1: Open a Command Prompt. Press Windows + R and enter cmd.

Step 2: Go to the MySQL bin folder.

cd "C:\Program Files\MySQL\MySQL Server 5.6\bin"

or

cd "C:\Program Files\MySQL\MySQL Server 5.7\bin"

Step 3: Execute the following command to restore the database.

mysql -u [username] –p [database_name] < [dump_file.sql]

> database_name is the name of the empty database into which you want to load data from the backup file.

Step 4: Enter the username password if prompted for a password.

Was this answer helpful? 1 Users Found This Useful (2 Votes)

Most Popular Articles

Error 1503: Error while restarting MySQL service on Windows server

You may need to restart MySQL services from Services on the Windows server. While restarting...
How to Enable Relation View in phpMyAdmin?

The option Relation View is probably one of the best features available in phpMyadmin. Sometimes...
How to resolve “mcrypt extension is missing. Please check your PHP configuration” error in phpMyAdmin?

This article will guide you on resolving the “mcrypt extension is missing. Please check your PHP...
How to enable Remote Access for MariaDB in virtualmin?

For web hosts looking to make better use of their resources, moving the database server to a...
How do I connect to MySQL server from phpMyAdmin?

This article will guide you on how to connect to the MySQL server from phpMyAdmin. 1. You can...