# 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
# 跨库复制表格
$ mysqldump --opt --host=<DB_HOST> --port=<DB_PORT> --user=<DB_USER> \
--password=<DB_PASSWD> <DB> <TABLE> | mysql -h <DB_HOST> -P <DB_PORT> \
-u <DB_USER> -p'<DB_PASSWD>' -D <DB>