there is a new compressor/deduplicator command in bcfg2-1.1.0rc3 that you might try running on the db; it should really cut down on the amount of data that is stored. -nld On Jun 22, 2010, at 8:07 AM, Dan Olson wrote:
Is anyone using the data in the bcfg2_reports database on spock? If I don't get any replies I'm going to archive it and clear it out.
---- Daniel Murphy-Olson Systems Administrator Mathematics & Computer Science Division Argonne National Laboratory 630-252-0055
----- Forwarded Message ----- From: "root" <[email protected]> To: [email protected] Sent: Monday, June 21, 2010 10:55:48 PM GMT -06:00 US/Canada Central Subject: [backup-admins] MySQL@spock backup
mysqldump: Got errno 28 on write
gzip: /sandbox/backup/mysql_dbs/bcfg2_reports.20100621220002.dump.gz: No space left on device mysqldump: Got errno 28 on write
gzip: /sandbox/backup/mysql_dbs/mysql.20100621220002.dump.gz: No space left on device Backup # 1 = bcfg2_reports.20100621220002.dump -> 46809354240 bytes Backup # 2 = bcfg2_reports.20100620220001.dump -> deleted Backup # 1 = information_schema.20100621220002.dump.gz -> 465 bytes Backup # 2 = information_schema.20100620220001.dump.gz -> deleted Backup # 1 = mysql.20100621220002.dump -> 0 bytes Backup # 2 = mysql.20100620220001.dump -> deleted