Remote MySQL Database Backup/Dump

remote-mysql-database-backup-via-ssh-tunneling

# Reference: https://simplebackups.com/blog/remote-mysql-database-backup-via-ssh-tunneling/

# Setting up an SSH tunnel interactively
ssh -L 3306:mysql-server:3306 username@mysql-server

# How use mysqldump via SSH tunnel
mysqldump -P 3336  -u dbuser -p password database_name > dumpfile.sql

# How to restore a MySQL backup via the command line through an SSH tunne
mysql -P 3336 -u dbuser -p password database_name < dumpfile.sql

# How to dump a remote MySQL database (without SSH tunneling)
mysqldump -h 12.345.678.91 -u sb_user -P 3306 -p database_name > database_backup.sql