Backup

USER FOR DUMP

CREATE USER 'dumper'@'X.X.X.X' IDENTIFIED BY 'PASSWORD';
GRANT SELECT,LOCK TABLES ON DB.* TO 'dumper'@'X.X.X.X';

DUMP

mysqldump -h ${HOST} -u ${USER} -p ${DB} --add-drop-database --skip-add-locks --skip-lock-tables --single-transaction > /data/dump.sql