How to Backup and Restore MySQL Database in VPS?

Problem

How to backup and restore MySQL database without MYSQL installed?

Solution

  1. Login to MySQL server.
  2. Open a command window.
  3. Input a run command.

Backup MySQL Database using the following prompts:

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

Restore MySQL Database using the following prompts:

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

Add Feedback