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…