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}

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

-- Response ended

-- Page fetched on Fri May 17 13:08:38 2024