💾 Archived View for freeshell.de › tldr › mysqldump.gmi captured on 2023-11-14 at 10:03:46. Gemini links have been rewritten to link to archived content

-=-=-=-=-=-=-

mysqldump

Backups MySQL databases.

See also `mysql` for restoring databases.

More information.

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).

CC-BY