[rt-users] MySQL backups of RT 4.4.1 truncated

[Cena, Stephen (ext. 300)]

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)" <SJC at qvii.com>
To: 'Jeffrey Pilant' <jeffrey.pilant.ext at bayer.com>,
	"'rt-users at lists.bestpractical.com'"
	<rt-users at lists.bestpractical.com>
Subject: Re: [rt-users] MySQL backups of RT 4.4.1 truncated
Message-ID:
	<87F81E27495DC8489147E34A4152E268A4962E65 at MailStore2010.ogp.qvii.com>
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-general at qvii.com To report email issues: postmaster at qvii.com