[rt-users] MySQL backups of RT 4.4.1 truncated

[Cena, Stephen (ext. 300)]

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

-----Original Message-----
From: Jeffrey Pilant [mailto:jeffrey.pilant.ext at bayer.com] 
Sent: Friday, January 20, 2017 8:54 AM
To: Cena, Stephen (ext. 300) <SJC at qvii.com>
Subject: RE: MySQL backups of RT 4.4.1 truncated

Just FYI:
When windows copies files between drives, I believe it copies them to a temp area first before copying the temp area to the destination.
It probably does this to avoid writing a partial file when running out of space.  Because it causes a doubling of data transfer, it is stupid, but then, it is Microsoft Windows.

If your backup process includes copying the result across drives, this could be the source of the problem.

/jeff