[Archivesspace_Users_Group] Backing up ArchivesSpace using mysqldump

[Chris Fitzpatrick]

Hi Helen,


That's odd. So, what is the output giving you when you run the script?

Something like:

./scripts/backup.sh --mysqldump --output /tmp/123.zip


Otherwise, you can just run a scheduled mysqldump process..this won't zip up the solr index, but you can rebuild those and it will greatly reduce the disk size that your backups use. Something like:


mysqldump -u myUser -pMyPassword -all-databases --single-transaction -routines | gzip > /some/safe/directory/aspace_`date '+%m-%d-%Y'`.sql.gz



I think that would work...

b,chris.


Chris Fitzpatrick | Developer, ArchivesSpace
Skype: chrisfitzpat  | Phone: 918.236.6048
http://archivesspace.org/


________________________________
From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of Helen Thomas <helen.thomas at nicholls.edu>
Sent: Monday, September 14, 2015 4:41 PM
To: archivesspace_users_group at lyralists.lyrasis.org
Subject: [Archivesspace_Users_Group] Backing up ArchivesSpace using mysqldump

Good morning,

I'm backing up my instance to a zip file, and would like to include the mysqldump option. I can create a backup from the provided script, but my attempts to include a dump of our MySQL database have been unsuccessful.  As far as I can tell, I have mysqldump installed correctly, but I think that I'm just not providing the mysqldump option correctly at the command line.

Would anyone be willing to share their amended version of the provided backup script (scripts/backup.sh --output /path/to/backup-yyyymmdd.zip) that includes the mysqldump option?

Best,
Helen

--
Helen Thomas
Assistant Archivist
Ellender Library, Nicholls State University
helen.thomas at nicholls.edu<mailto:helen.thomas at nicholls.edu> | (985) 448-4644
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150916/cde817c8/attachment.html>