mysqldump
Back up 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 --password --result-file=
- Back up a specific table redirecting the output to a file (user will be prompted for a password):
mysqldump --user --password >
- Back up all databases redirecting the output to a file (user will be prompted for a password):
mysqldump --user --password --all-databases >
- Back up all databases from a remote host, redirecting the output to a file (user will be prompted for a password):
mysqldump --host= --user --password --all-databases >
来源:tldr-pages contributors · 作者与贡献记录 · CC BY 4.0。离线整理了版式、链接和媒体显示。
