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>, "'rt-users@lists.bestpractical.com'" <rt-users@lists.bestpractical.com> Subject: Re: [rt-users] MySQL backups of RT 4.4.1 truncated Message-ID: <87f81e27495dc8489147e34a4152e268a4962...@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-gene...@qvii.com To report email issues: postmas...@qvii.com