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 -----Original Message----- From: Jeffrey Pilant [mailto:jeffrey.pilant....@bayer.com] Sent: Friday, January 20, 2017 8:54 AM To: Cena, Stephen (ext. 300) <s...@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
