<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p><br>
</p>
<p><br>
</p>
<p>Hi Helen,</p>
<p><br>
</p>
<p>That's odd. So, what is the output giving you when you run the script? </p>
<p>Something like: <br>
</p>
<p>./scripts/backup.sh --mysqldump --output /tmp/123.zip<br>
</p>
<p><br>
</p>
<p>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:</p>
<p><br>
</p>
<p><em>mysqldump -u myUser -pMyPassword –all-databases </em><em><span class="pl-s">--single-transaction</span> –routines | gzip > /some/safe/directory/aspace_`date ‘+%m-%d-%Y’`.<span class="skimlinks-unlinked">sql.gz</span></em></p>
<p><br>
</p>
<p><br>
</p>
<p>I think that would work...</p>
<p>b,chris. <br>
</p>
<p><br>
</p>
<div id="Signature">
<div name="divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:; margin:0">
<div class="BodyFragment"><font size="2">
<div class="PlainText">Chris Fitzpatrick | <font size="2">Developer, ArchivesSpace</font><br>
Skype: chrisfitzpat | Phone: 918.236.6048<br>
http://archivesspace.org/<br>
</div>
</font></div>
</div>
</div>
<br>
<br>
<div style="color: rgb(0, 0, 0);">
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" face="Calibri, sans-serif" color="#000000"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of Helen Thomas
<helen.thomas@nicholls.edu><br>
<b>Sent:</b> Monday, September 14, 2015 4:41 PM<br>
<b>To:</b> archivesspace_users_group@lyralists.lyrasis.org<br>
<b>Subject:</b> [Archivesspace_Users_Group] Backing up ArchivesSpace using mysqldump</font>
<div> </div>
</div>
<div>
<div dir="ltr">Good morning,
<div><br>
</div>
<div>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. </div>
<div><br>
</div>
<div>Would anyone be willing to share their amended version of the provided backup script (<span style="font-family:Consolas,'Liberation Mono',Menlo,Courier,monospace; font-size:13.6px; line-height:inherit; color:rgb(51,51,51); background-color:transparent">scripts/backup.sh
--output /path/to/backup-yyyymmdd.zip)</span> that includes the mysqldump option? </div>
<div><br>
</div>
<div>Best,</div>
<div>Helen</div>
<div>
<div><br>
</div>
-- <br>
<div class="gmail_signature">
<div dir="ltr"><b>Helen Thomas</b>
<div>Assistant Archivist</div>
<div>Ellender Library, Nicholls State University </div>
<div><a href="mailto:helen.thomas@nicholls.edu" target="_blank">helen.thomas@nicholls.edu</a> | (985) 448-4644</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>