Update: I tried increasing the database permissions on the account I'm using to 
run the backup but that didn't change anything. I don't think it's a file size 
limitation as before they stopped working, my backups were reaching 19GB. When 
I look at the actual database file on the server for the attachments table its 
19.7GB on disk. I'm going to see if there is a way to turn on any additional 
logging during operation/backup but this really has me scratching my head. Any 
additional help would be appreciated & I will update the group as soon as I 
know something new.

Message: 1
Date: Fri, 20 Jan 2017 14:04:04 +0000
From: "Cena, Stephen (ext. 300)" <s...@qvii.com>
To: 'Jeffrey Pilant' <jeffrey.pilant....@bayer.com>,
Subject: Re: [rt-users] MySQL backups of RT 4.4.1 truncated
Content-Type: text/plain; charset="us-ascii"

All the backups I'm doing are local to keep performance high. I sadly lost the 
"discussion" to keep the MySQL server on a Linux machine. What we're going to 
try is the following:
We're snapshotting/backing up the system at regular intervals so I will always 
have a backup of the .sql files. I'm going to move the MySQL TMP folder to the 
larger drive to see if that solves the issue. I think you might be on to 
something with the drive issue as it looks to be the only consistent factor. 
I'll update as I know more.

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

Reply via email to