Re: MySQL dump truncating backups at ~18GB - RT database
Just tried adding that in & no luck. It's still getting farther but still failing.
C:\Tasks>"C:\Program Files\MySQL\MySQL Workbench 6.3 CE\mysqldump.exe" rt_servic
e -u backupdb -h 127.0.0.1 --single_transaction --extended-insert=FALSE 1>F:\te
st\rt_service-redir-20170130.sql
mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' bytes when du
mping table `attachments` at row: 503085
No matter that I do, I just seem to by dying at this particular row. And I was getting full backups before where the resulting file was ~19GB. Now I can't break 18.
Subject
Views
Written By
Posted
1736
January 25, 2017 07:32AM
859
January 26, 2017 08:06AM
751
January 28, 2017 08:26AM
838
January 30, 2017 11:43AM
891
January 30, 2017 12:03PM
Re: MySQL dump truncating backups at ~18GB - RT database
937
January 30, 2017 12:23PM
810
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.