MySQL backup

mysqldump --all-databases --quick --single-transaction -u backup -p| gzip > mybackup.sql.gz

Change backup with user of your choice and type password at prompt. Or create a localhost-only backup user with read-all privileges.