mysqldump
Backups MySQL databases.
See also mysql
for restoring databases.
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}}
License and Disclaimer
The content on this page is copyright © 2014—present the tldr-pages team and contributors.This page is used with permission under Creative Commons Attribution 4.0 International License.
While we do attempt to make sure content is accurate, there isn't a warranty of any kind.