MySQL Dump Master/Slave

mysqldump --opt --skip-lock-tables --single-transaction --master-data=2 --routines --triggers --hex-blob -Q -B -p --events --all-databases > /home/...

#!/bin/sh       
mysql -u root --password='XXXX' < /home/backup...

Comments are closed.