Database
mysqldump
MySQL Database Backup
Ubuntu
CentOS
Debian
SUSE
Fedora
RHEL
Verified: 2026-03-04
Syntax
$mysqldump [options] [database] [tables]
Optionen
-u
-p
--all-databases
--single-transaction
Examples
$mysqldump -u root -p database > backup.sql
$mysqldump -u root -p --all-databases > all_backup.sql
$mysqldump -u root -p database table1 table2 > partial_backup.sql
See also
Typical use cases
?
Standard usage
mysqldump --help
Note
Creates SQL dumps of MySQL databases.
Export