I want to make backups every day automatically. It was fine when database was 700-800Mb, but now database (dumped sql file) is 1.5G and when using mysqldump it errors on random table with 2013 error.
When I comment out my setting of
mysqldump works perfectly.
Is there nice way to set to defaults
mysqldump and then back to
p.s. I'm using mysqldump as following
mysqldump --max_allowed_packet=500M --net_buffer_length=548576 --single-transaction?