Monthly Archive: January 2018

MysqlDump without locking Tables

# dumping data without lock table mysqldump -u[USER] -p[PASS] –skip-lock-tables –single-transaction –flush-logs –hex-blob –master-data=2 –max_allowed_packet=1G globe_sdp > globe_sdp_v2.sql