mysqldump

Backups MySQL databases.

See also `mysql` for restoring databases.

• 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}

Copyright © 2014—present the tldr-pages team and contributors.

This work is licensed under the Creative Commons Attribution 4.0 International License (CC-BY).