Re: [rt-users] MySQL backups of RT 4.4.1 truncated

[Cena, Stephen (ext. 300)]

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?


--



Message: 4

Date: Wed, 18 Jan 2017 13:54:57 +

From: "Cena, Stephen (ext. 300)" >

To: "'rt-users@lists.bestpractical.com'"


>

Subject: [rt-users] MySQL backups of RT 4.4.1 truncated

Message-ID:


<87f81e27495dc8489147e34a4152e268a4950...@mailstore2010.ogp.qvii.com>

Content-Type: text/plain; charset="us-ascii"



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 (https://docs.bestpractical.com/rt/4.4.1/backups.html) 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.



Thank you in advance!



Stephen Cena

Senior Systems Administrator

Quality Vision International, Inc.

Phone: (585) 544-0450 x300

To notify helpdesk: http://helpdesk.ogp.qvii.com or email: 
hd-gene...@qvii.com>

To report email issues: 
postmas...@qvii.com>

Stephen Cena
Senior Systems Administrator
Quality Vision International, Inc.
Phone: (585) 544-0450 x300
To notify helpdesk: http://helpdesk.ogp.qvii.com or email: 
hd-gene...@qvii.com
To report email issues: postmas...@qvii.com

[rt-users] MySQL backups of RT 4.4.1 truncated

[Cena, Stephen (ext. 300)]

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 (https://docs.bestpractical.com/rt/4.4.1/backups.html) 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.

Thank you in advance!

Stephen Cena
Senior Systems Administrator
Quality Vision International, Inc.
Phone: (585) 544-0450 x300
To notify helpdesk: http://helpdesk.ogp.qvii.com or email: 
hd-gene...@qvii.com
To report email issues: postmas...@qvii.com