{"id":95,"date":"2003-09-17T22:30:12","date_gmt":"2003-09-17T22:30:12","guid":{"rendered":"http:\/\/fiveforks.com\/jeb\/2003\/09\/crontab_by_hand\/"},"modified":"2003-09-17T22:30:12","modified_gmt":"2003-09-17T22:30:12","slug":"crontab_by_hand","status":"publish","type":"post","link":"https:\/\/www.fiveforks.com\/jeb\/2003\/09\/crontab_by_hand\/","title":{"rendered":"crontab by hand"},"content":{"rendered":"<p>The system crontab text file controls events run by the UNIX system scheduler, CRON. It is found at \/private\/etc\/chron. I used <a href=\"http:\/\/www.koch-schmidt.de\/cronnix\/docs\/index.html\">Cronnix<\/a> to update it originally, but Cronnix quit working properly for some reason, so I just updated \/private\/etc\/crontab directly using BBEdit after setting read\/write for root using FileBuddy. (Update: I had pasted in a key with a line feed and did not see the extra text. Cleaning out the key fixed this, and Cronnix works fine now. )<\/p>\n<p>Apple added the first 3 cleanup commands. I added the the <a href=\"http:\/\/mac.fiveforks.com\/analog\/\">daily Analog reports<\/a> and the weekly dump of the MovableType SQL db to Yoda. That way I&#8217;ll always have 5 backup copies of the source database. (I&#8217;ve masked the password for the mysql user here.)<\/p>\n<p>I&#8217;ll end up going to a daily 31 cycle and then a monthly 12 cycle. That will be 43 instances of a 1 meg and growing MYSQL dump.<\/p>\n<p>Update: Using \/network\/ instead of \/volumes\/ because I can have a SAMBA volume automount as a network device, but not a volume.<\/p>\n<p>SHELL = \/bin\/sh<\/p>\n<p>PATH = \/etc:\/bin:\/sbin:\/usr\/bin:\/usr\/sbin<\/p>\n<p>HOME = \/var\/log<\/p>\n<p>0\t20\t*\t*\t*\troot\tperiodic daily<\/p>\n<p>15\t11\t*\t*\t6\troot\tperiodic weekly<\/p>\n<p>15\t11\t1\t*\t*\troot\tperiodic monthly<\/p>\n<p>30\t1\t*\t*\t*\troot\t\/usr\/local\/analog\/analog<\/p>\n<p>15\t4\t1\t*\t*\troot\t\/usr\/local\/bin\/mysqldump -u mysql -p***** mov_type &gt; \/volumes\/YODAMEDIA\/MOV_TYPE\/mov_type_1.sql<\/p>\n<p>15\t4\t7\t*\t*\troot\t\/usr\/local\/bin\/mysqldump -u mysql -p***** mov_type &gt; \/volumes\/YODAMEDIA\/MOV_TYPE\/mov_type_7.sql<\/p>\n<p>15\t4\t14\t*\t*\troot\t\/usr\/local\/bin\/mysqldump -u mysql -p***** mov_type &gt; \/volumes\/YODAMEDIA\/MOV_TYPE\/mov_type_14.sql<\/p>\n<p>15\t4\t21\t*\t*\troot\t\/usr\/local\/bin\/mysqldump -u mysql -p***** mov_type &gt; \/volumes\/YODAMEDIA\/MOV_TYPE\/mov_type_21.sql<\/p>\n<p>15\t4\t28\t*\t*\troot\t\/usr\/local\/bin\/mysqldump -u mysql -p***** mov_type &gt; \/volumes\/YODAMEDIA\/MOV_TYPE\/mov_type_28.sql<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The system crontab text file controls events run by the UNIX system scheduler, CRON. It is found at \/private\/etc\/chron. I used Cronnix to update it originally, but Cronnix quit working properly for some reason, so I just updated \/private\/etc\/crontab directly &hellip; <a href=\"https:\/\/www.fiveforks.com\/jeb\/2003\/09\/crontab_by_hand\/\">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":[5],"tags":[],"class_list":["post-95","post","type-post","status-publish","format-standard","hentry","category-tech"],"_links":{"self":[{"href":"https:\/\/www.fiveforks.com\/jeb\/wp-json\/wp\/v2\/posts\/95","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=95"}],"version-history":[{"count":0,"href":"https:\/\/www.fiveforks.com\/jeb\/wp-json\/wp\/v2\/posts\/95\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.fiveforks.com\/jeb\/wp-json\/wp\/v2\/media?parent=95"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fiveforks.com\/jeb\/wp-json\/wp\/v2\/categories?post=95"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fiveforks.com\/jeb\/wp-json\/wp\/v2\/tags?post=95"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}