Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
This command executes a full MySQL dump on a remote machine and transfers it back to your local machine.
ssh user@host "mysqldump --lock-tables=0 -h HOST -u USER -pPASSWORD --all-databases | gzip -c" > ~/full_mysql_dump.sql.gz
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment