Re: MySQL dump truncating backups at ~18GB - RT database
Your suggestion worked. I needed to modify it slightly. It looks like the max_allowed_packet setting in the my.cnf/my.ini ISN'T carrying over to the backup account/activity.
To get it to successfully backup, I am using the following command line parameters:
-u USER -h HOST --max_allowed_packet=512M --single_transaction --extended_insert=FALSE > outputfile.sql
Just ran it & I've got my first full backup in weeks. Thank you!!!
Subject
Views
Written By
Posted
2278
January 25, 2017 07:32AM
1020
January 26, 2017 08:06AM
900
January 28, 2017 08:26AM
1001
January 30, 2017 11:43AM
1040
January 30, 2017 12:03PM
1099
January 30, 2017 12:23PM
Re: MySQL dump truncating backups at ~18GB - RT database
996
January 30, 2017 12:50PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.