<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 http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
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;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
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="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal">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></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thank you in advance!<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b><span style="font-size:14.0pt;color:black">Stephen Cena<o:p></o:p></span></b></p>
<p class="MsoNormal"><span style="color:black">Senior Systems Administrator <o:p>
</o:p></span></p>
<p class="MsoNormal"><span style="color:black">Quality Vision International, Inc.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">Phone: (585) 544-0450 x300<o:p></o:p></span></p>
<p class="MsoNormal"><span 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 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"><o:p> </o:p></p>
</div>
</body>
</html>