{"id":486,"date":"2008-06-08T11:30:41","date_gmt":"2008-06-08T11:30:41","guid":{"rendered":"http:\/\/fiveforks.com\/jeb\/2008\/06\/automysqlbackup_monthly\/"},"modified":"2008-06-08T11:30:41","modified_gmt":"2008-06-08T11:30:41","slug":"automysqlbackup_monthly","status":"publish","type":"post","link":"https:\/\/www.fiveforks.com\/jeb\/2008\/06\/automysqlbackup_monthly\/","title":{"rendered":"AutoMySQLBackup (Monthly)"},"content":{"rendered":"<p>The contents (text) of mac5 are all stored in a MySQL database. I use a script called <a href=\"http:\/\/sourceforge.net\/projects\/automysqlbackup\/\">AutoMySQLBackup<\/a> to run daily, weekly, and monthly backups of the contents. These &#8220;dumps&#8221; are then copied over every night by Retrospect to a backup server (currently Mac17&#8217;s external Seagate drive.)<\/p>\n<p>I routinely check these to make sure they are running by inspecting the contents of a recent dump. I noticed in the monthly set that besides &#8220;fivefor1_mtfiveforks&#8221; was another database &#8220;mysql&#8221;. Went on a wild goose chase looking under the \/etc\/periodic\/monthly script and couldn&#8217;t even find AutoMySQLBackup. Turns out the monthly (and weekly) runs are all addressed in a single daily script under \/etc\/periodic\/daily. Oh. Right. Set it up 3 years ago&#8230; who can remember.<\/p>\n<p>Turns out I had not noticed an extra &#8220;advanced&#8221; setting that had a default database &#8220;mysql&#8221; in it, and so I was backing up a default, empty database every day for the past several years. Not much space, and easy enough to correct. While there decided I should add the gallery2 database (which holds photo titles, descriptions, and comments.)<\/p>\n<p>So on OZ in<\/p>\n<p>HD2:private:etc:periodic:daily:automysqlbackup.sh are two lines:<\/p>\n<p>DBNAMES=&#8221;fivefor1_mtfiveforks gallery2&#8243;<\/p>\n<p>MDBNAMES=&#8221;fivefor1_mtfiveforks gallery2&#8243; &lt;-under advanced settings<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The contents (text) of mac5 are all stored in a MySQL database. I use a script called AutoMySQLBackup to run daily, weekly, and monthly backups of the contents. These &#8220;dumps&#8221; are then copied over every night by Retrospect to a &hellip; <a href=\"https:\/\/www.fiveforks.com\/jeb\/2008\/06\/automysqlbackup_monthly\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-486","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.fiveforks.com\/jeb\/wp-json\/wp\/v2\/posts\/486","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fiveforks.com\/jeb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fiveforks.com\/jeb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fiveforks.com\/jeb\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fiveforks.com\/jeb\/wp-json\/wp\/v2\/comments?post=486"}],"version-history":[{"count":0,"href":"https:\/\/www.fiveforks.com\/jeb\/wp-json\/wp\/v2\/posts\/486\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.fiveforks.com\/jeb\/wp-json\/wp\/v2\/media?parent=486"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fiveforks.com\/jeb\/wp-json\/wp\/v2\/categories?post=486"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fiveforks.com\/jeb\/wp-json\/wp\/v2\/tags?post=486"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}