How to Back Up a MySQL Database Without Downtime
How do I dump a MySQL database while it's serving traffic? Try: mysqldump --single-transaction --quick --lock-tables=false --routines --triggers --events -u backup -p production_db | gzip > backup_$(date +%Y%m%d).sql.gz Info: --single-transaction creates a consistent snapshot without locking tables for InnoDB. --quick streams rows instead of loading the entire result into memory, […]
Read More