snippetbashTip
mysqldump — Backups MySQL databases. See also: `mysql`. More information: <https://dev.mysql.com/doc/refman/en/m
Viewed 0 times
mysqldumpcommandclimysqldatabasesbackupsseealso
Problem
How to use the
mysqldump command: Backups MySQL databases. See also: mysql. More information: <https://dev.mysql.com/doc/refman/en/mysqldump.html>.Solution
mysqldump — Backups MySQL databases. See also: mysql. More information: <https://dev.mysql.com/doc/refman/en/mysqldump.html>.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}}Code Snippets
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}}Context
tldr-pages: common/mysqldump
Revisions (0)
No revisions yet.