Sections

 Actions

 Language:
 RSS flow:
 92 visitors online.

Backup a MySQL database

Backup only one database

    mysqldump --user=MySQLUser --password=MySQLPassword MyDatabase > BackupFile.sql
This will backup the database "MyDatabase", with "MySQLUser" user, and "MySQLPassword" password. The file BackupFile.sql will be generated by this command.

Backup all databases

    mysqldump --user=MySQLUser --password=MySQLPassword --all-databases > BackupFile.sql
This will backup all MySQL databases, with "MySQLUser" user, and "MySQLPassword" password. The file BackupFile.sql will be generated by this command.

Go Back