<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Nur Text Zchn";
margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.NurTextZchn
{mso-style-name:"Nur Text Zchn";
mso-style-priority:99;
mso-style-link:"Nur Text";
font-family:"Consolas",serif;}
span.E-MailFormatvorlage19
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
p.PlainText, li.PlainText, div.PlainText
{mso-style-name:"Plain Text";
mso-style-link:"Plain Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.PlainTextChar
{mso-style-name:"Plain Text Char";
mso-style-priority:99;
mso-style-link:"Plain Text";
font-family:"Calibri",sans-serif;}
span.E-MailFormatvorlage22
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=DE link="#0563C1" vlink="#954F72"><div class=WordSection1><p class=MsoNormal><span style='color:#1F497D;mso-fareast-language:EN-US'>Hello Stephen,<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D;mso-fareast-language:EN-US'>just a stab in the dark, but could you please check the value set for “max_allowed_packet” in the mysqldump section of /etc/mysql/my.cnf (or whatever your my.cnf file is named)? If you try to dump mysql objects that are larger than this size, mysqldump will stop; probably with a message like “mysql server has gone away”. You can raise that value for mysqldump just by editing that file; no server restart is required. <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D;mso-fareast-language:EN-US'> <o:p></o:p></span></p><div><p class=MsoNormal><span style='color:#1F497D'>HTH,<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Thomas Bätzler<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>-- <o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>BRINGE Informationstechnik GmbH<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Zur Seeplatte 12<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>D-76228 Karlsruhe<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Germany<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Fon: +49 721 94246-0<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Fon: +49 171 5438457<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Fax: +49 721 94246-66<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Web: http://www.bringe.de/<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Geschäftsführer: Dipl.-Ing. (FH) Martin Bringe<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Ust.Id: DE812936645, HRB 108943 Mannheim<o:p></o:p></span></p></div><p class=MsoNormal><span style='color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><div style='border:none;border-left:solid blue 1.5pt;padding:0cm 0cm 0cm 4.0pt'><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b>Von:</b> rt-users [mailto:rt-users-bounces@lists.bestpractical.com] <b>Im Auftrag von </b>Cena, Stephen (ext. 300)<br><b>Gesendet:</b> Mittwoch, 18. Januar 2017 18:23<br><b>An:</b> 'rt-users@lists.bestpractical.com' <rt-users@lists.bestpractical.com><br><b>Betreff:</b> Re: [rt-users] MySQL backups of RT 4.4.1 truncated<o:p></o:p></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span lang=EN-US>I just ran a test with the attachments table “ignored”, and the backup worked perfectly. As a “sanity check”, I also ran mysqlcheck on the schema & no errors were found. Should I split my backup job into two pieces, or is there a better way to get a backup all in one shot?<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoPlainText><span lang=EN-US>------------------------------<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p><p class=MsoPlainText><span lang=EN-US>Message: 4<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US>Date: Wed, 18 Jan 2017 13:54:57 +0000<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US>From: "Cena, Stephen (ext. 300)" <<a href="mailto:SJC@qvii.com">SJC@qvii.com</a>><o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US>To: "'rt-users@lists.bestpractical.com'"<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US> <<a href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a>><o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US>Subject: [rt-users] MySQL backups of RT 4.4.1 truncated<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US>Message-ID:<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US> <<a href="mailto:87F81E27495DC8489147E34A4152E268A49508BA@MailStore2010.ogp.qvii.com">87F81E27495DC8489147E34A4152E268A49508BA@MailStore2010.ogp.qvii.com</a>><o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US>Content-Type: text/plain; charset="us-ascii"<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p><p class=MsoPlainText><span lang=EN-US>I'm currently running RT 4.4.1 on Ubuntu 14.04 LTS with MySQL 5.6 on Windows Server 2012. Recently, we enabled full-text indexing in native MySQL & everything is great. After doing some work on the server over the weekend, I discovered that the .sql files being generated for the backup are being "truncated" after the attachments table (~18-19GB). After reviewing your documentation (<a href="https://docs.bestpractical.com/rt/4.4.1/backups.html">https://docs.bestpractical.com/rt/4.4.1/backups.html</a>) I realized my mysqldump command was incorrect. I'm working in a lab environment now to see how I can optimize/change my script to more closely match yours. The only thought I have right now is to exclude the data from the AttachmentsIndex as that would get rebuilt on restoration anyways. Is there any other reason that the backup would just "stop" after the attachment table? I apologize if this is beyond the scope of the forums thread.<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p><p class=MsoPlainText><span lang=EN-US>Thank you in advance!<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US><o:p> </o:p></span></p><p class=MsoPlainText><span lang=EN-US>Stephen Cena<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US>Senior Systems Administrator<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US>Quality Vision International, Inc.<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US>Phone: (585) 544-0450 x300<o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US>To notify helpdesk: <a href="http://helpdesk.ogp.qvii.com">http://helpdesk.ogp.qvii.com</a> or email: <a href="mailto:hd-general@qvii.com%3cmailto:hd-general@qvii.com">hd-general@qvii.com<mailto:hd-general@qvii.com</a>><o:p></o:p></span></p><p class=MsoPlainText><span lang=EN-US>To report email issues: <a href="mailto:postmaster@qvii.com%3cmailto:postmaster@qvii.com">postmaster@qvii.com<mailto:postmaster@qvii.com</a>><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><b><span lang=EN-US style='font-size:14.0pt;color:black'>Stephen Cena<o:p></o:p></span></b></p><p class=MsoNormal><span lang=EN-US style='color:black'>Senior Systems Administrator <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:black'>Quality Vision International, Inc.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:black'>Phone: (585) 544-0450 x300<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:black'>To notify helpdesk: <a href="http://helpdesk.ogp.qvii.com"><span style='color:blue'>http://helpdesk.ogp.qvii.com</span></a> or email: <u><a href="mailto:hd-general@qvii.com"><span style='color:black'>hd-general@qvii.com</span></a><o:p></o:p></u></span></p><p class=MsoNormal><span lang=EN-US style='color:black'>To report email issues: <a href="mailto:postmaster@qvii.com"><span style='color:blue'>postmaster@qvii.com</span></a><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p></div></div></body></html>