mysqldump

Back up MySQL databases. tldr-pages

On several platforms

Several platforms

Create a backup (user will be prompted for a password)

mysqldump --user user --password database_name --result-file=path/to/file.sqlIdentify

Back up 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.sqlIdentify

Back up all databases redirecting the output to a file (user will be prompted for a password)

mysqldump --user user --password --all-databases >path/to/file.sqlIdentify

Back up 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.sqlIdentify