[rt-users] MySQL backups of RT 4.4.1 truncated
Cena, Stephen (ext. 300)
SJC at qvii.com
Fri Jan 20 09:04:04 EST 2017
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.
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
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
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.
More information about the rt-users