MYSQLDUMP MYSQL MASTER SERVER

Dump with binary and log position

# mysqldump –single-transaction –master-data=2 DATABASE NAME| gzip > /root/DATABASE.sql.gz

restore

# gunzip < /root/DATABASE.sql.gz | mysql DATABASE