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
