Sam's Tech Blog

You can check out any time you like, But you can never leave!'

2019-08-21

mysqldump for large DB's

How to: backup large mysql DB's

mysqldump for large DB's

Having problems with high load while backing up a MySQL database?
Try this:

mysqldump -u root -dbPASSWORD --single-transaction --quick --lock-tables=false database17 | gzip > /root/db17.gz &