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