Dump a mysql table without locking

If you want to keep your site/application live, you can dump mysql tables online like so: mysqldump --single-transaction --quick -hhostname -uuser -ppassword database > /path/to/destination-sqlbackup.sql --compress = as it says, enabled compression on the connection to the mysql server. This will always speed up bulk loads 10x…

Google Cloud SQL Backup removal

I take backups using the Google Cloud API for Google Cloud SQL, and never implemented a trim process because we want longer term backups. I use the following bash one-liners to clean our backups up when needed. The following command will list all backups existing grep -v = inverted grep, find…