How to restore a MySQL database in Windows

To restore a MySQL database on a Windows machine:

Place the database backup file in the root directory of your C: drive (trust me, this will make your life easier)
Open the Command Prompt
Start the MySQL command prompt
```
mysql -u root -p
```
This command will prompt you for the MySQL root password
Switch to the new database
```
use db;
```
Import the database
```
source C:/BACKUP_FILE_NAME.sql
```
To avoid the Failed to open file ‘…’ , error 2 and error 22 error message
You can have spaces in the name of the backup file, but not in the directory names in the path
Do not use quotes around the file path
Use forward slashes
Do not end the command with semicolon (;)

Failed to open file ‘…’ , error 2 and error 22