Re: MySQL backups of RT 4.4.1 truncated
"Cena, Stephen (ext. 300)" <[email protected]> Mon, 30 Jan 2017 19:08:15 +0000
| Newsgroups | gmane.comp.bug-tracking.request-tracker.user |
|---|---|
| Message-ID | <87F81E27495DC8489147E34A4152E268A496A504@MailStore2010.ogp.qvii.com> |
It's fixed!!! Recap: large RT database (host Ubuntu 14.04LTS, database server MySQL 5.7.x on Windows Server 2012). Backup .sql files became truncated at ~18GB when the database is easily 20GB. It looks like (for whatever reason) the max_allowed_packet option is not carrying over to the backup scripts. I re-wrote my backup options as: -u USER -h HOST --max_allowed_packet=512M --single_transaction > output.sql That solved it. And I get a full backup of the file. Probably my own fault, but wanted to share the information. I'm now getting 19.5GB+ backups. Thanks to everyone! Stephen Cena Senior Systems Administrator Quality Vision International, Inc. Phone: (585) 544-0450 x300 To notify helpdesk: http://helpdesk.ogp.qvii.com or email: [email protected] To report email issues: [email protected]