Re: MySQL backups of RT 4.4.1 truncated

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)" <[email protected]>
To: 'Jeffrey Pilant' <[email protected]>,
	"'[email protected]'"
	<[email protected]>
Subject: Re: [rt-users] MySQL backups of RT 4.4.1 truncated
Message-ID:
	<87F81E27495DC8489147E34A4152E268A4962E65@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: [email protected] To report email issues: [email protected]