How to Backup and Restore MySQL Database?

Problem

Solution

Backup MySQL Database

C:\> mysqldump --user=[DatabaseUserName] --password=[Password]  [DatabaseName] > [DatabaseBackupFile]

Restore MySQL Database

C:\> mysql --user=[DatabaseUserName] -p  [DatabaseName] < [DatabaseBackupFile]

Other Resources

1. User Manual
2. How to restore your MySQL database from dump file.

Navigator

Express Windows Server

Standard Windows Server