How to Backup and Restore MySQL Database?

Problem

If without MySQL manager installed, how to backup and restore MySQL database?

Solution

Login to MySQL server, open command window, input an run:

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.