mysqldump
MySQL Database Backup
Syntax
$mysqldump [options] [database] [tables]
Optionen
-u
-p
--all-databases
--single-transaction
Examples
Examples
$mysqldump -u root -p database > backup.sql
Examples
$mysqldump -u root -p --all-databases > all_backup.sql
Examples
$mysqldump -u root -p database table1 table2 > partial_backup.sql
See also
Typical use cases
Note
Creates SQL dumps of MySQL databases.
Export