mysqldump

all

Backups MySQL databases. See also: `mysql`.

Examples (4)

Create a backup (user will be prompted for a password)

mysqldump --user user --password database_name --result-file=path/to/file.sql

Backup a specific table redirecting the output to a file (user will be prompted for a password)

mysqldump --user user --password database_name table_name > path/to/file.sql

Backup all databases redirecting the output to a file (user will be prompted for a password)

mysqldump --user user --password --all-databases > path/to/file.sql

Backup all databases from a remote host, redirecting the output to a file (user will be prompted for a password)

mysqldump --host=ip_or_hostname --user user --password --all-databases > path/to/file.sql