Cron - Revision history

Tim: /* sitebuilt current backup setup */

2014-11-12T16:00:08Z

sitebuilt current backup setup

← Older revision		Revision as of 12:00, 12 November 2014
Line 8:		Line 8:

	/usr/local/lib/tim/scripts		/usr/local/lib/tim/scripts


			you need composer
			apt-get update
			apt-get install curl
			apt-get install php5 git php5-curl php5-cli
			curl -sS https://getcomposer.org/installer \| php

	composer.json lists the aws php dependencies		composer.json lists the aws php dependencies

Tim: /* sitebuilt current backup setup */

2014-11-12T03:00:41Z

sitebuilt current backup setup

← Older revision		Revision as of 23:00, 11 November 2014
Line 34:		Line 34:

	The tar command takes a file list, it has to be correct		The tar command takes a file list, it has to be correct


	<pre>		<pre>
	# m h dom mon dow command		# m h dom mon dow command

Tim: /* sitebuilt current backup setup */

2014-11-12T02:54:23Z

sitebuilt current backup setup

← Older revision		Revision as of 22:54, 11 November 2014
Line 32:		Line 32:
	php s3_db.php restoring		php s3_db.php restoring
	</syntaxhighlight>		</syntaxhighlight>

			The tar command takes a file list, it has to be correct
	<pre>		<pre>
	# m h dom mon dow command		# m h dom mon dow command

Tim: /* sitebuilt current backup setup */

2014-11-12T02:52:51Z

sitebuilt current backup setup

← Older revision		Revision as of 22:52, 11 November 2014
Line 16:		Line 16:
	aws credentails are in /root/.aws/credentials		aws credentails are in /root/.aws/credentials

	<~~syntaxhighight~~ lang="bash">		<syntaxhighlight lang="bash">
	#!/bin/bash		#!/bin/bash
	_now=$(date +"%m_%d_%Y")		_now=$(date +"%m_%d_%Y")
Line 31:		Line 31:
	php s3_db.php hsc		php s3_db.php hsc
	php s3_db.php restoring		php s3_db.php restoring
	</~~syntaxhighight~~>		</syntaxhighlight>
	<pre>		<pre>
	# m h dom mon dow command		# m h dom mon dow command

Tim: /* sitebuilt current backup setup */

2014-11-12T02:51:46Z

sitebuilt current backup setup

← Older revision		Revision as of 22:51, 11 November 2014
Line 16:		Line 16:
	aws credentails are in /root/.aws/credentials		aws credentails are in /root/.aws/credentials

			<syntaxhighight lang="bash">
			#!/bin/bash
			_now=$(date +"%m_%d_%Y")
			_dir="/var/backups/s3/"
			_file="files_$_now.tar.gz"
			_bth=$_dir$_file
			echo "Starting backup to $_bth..."
			tar czf $_bth $(<file-dir-list.txt)
			php s3_dir.php $_file

			php s3_db.php sitebuil_wuffdb
			php s3_db.php sitebuil_wikidb
			php s3_db.php sitebuil_wrdp1
			php s3_db.php hsc
			php s3_db.php restoring
			</syntaxhighight>
	<pre>		<pre>
	# m h dom mon dow command		# m h dom mon dow command

Tim at 02:43, 12 November 2014

2014-11-12T02:43:12Z

← Older revision		Revision as of 22:43, 11 November 2014
Line 9:		Line 9:
	/usr/local/lib/tim/scripts		/usr/local/lib/tim/scripts

	*composer.json lists the aws php dependencies		composer.json lists the aws php dependencies

	composer install		composer install
	composer update		composer update

			aws credentails are in /root/.aws/credentials




	<pre>		<pre>

Tim at 02:39, 12 November 2014

2014-11-12T02:39:30Z

← Older revision		Revision as of 22:39, 11 November 2014
Line 4:		Line 4:
	[[php www-data program that creates a crontab and calls a C program that executes root commands to copy it into crontabs and install it]]		[[php www-data program that creates a crontab and calls a C program that executes root commands to copy it into crontabs and install it]]

			===sitebuilt current backup setup===
			scripts are in

			/usr/local/lib/tim/scripts

			*composer.json lists the aws php dependencies

			composer install
			composer update

	<pre>		<pre>

Tim at 02:33, 12 November 2014

2014-11-12T02:33:08Z

← Older revision		Revision as of 22:33, 11 November 2014
Line 4:		Line 4:
	[[php www-data program that creates a crontab and calls a C program that executes root commands to copy it into crontabs and install it]]		[[php www-data program that creates a crontab and calls a C program that executes root commands to copy it into crontabs and install it]]

	~~current crontab in /var/spool/cron/crontab/pathbost~~
	~~<syntaxhighlight>~~
	<pre>		<pre>
	# m h dom mon dow command		# m h dom mon dow command

Tim: /* cron and backups */

2014-11-12T02:31:52Z

cron and backups

← Older revision		Revision as of 22:31, 11 November 2014
Line 6:		Line 6:
	current crontab in /var/spool/cron/crontab/pathbost		current crontab in /var/spool/cron/crontab/pathbost
	<syntaxhighlight>		<syntaxhighlight>
			<pre>
	# m h dom mon dow command		# m h dom mon dow command
	~~# backup MYSQL databases every 4 days (starting at 3:00AM)~~		0 3 * * * cd /usr/local/lib/tm/scripts; ./backup.sh
	00 3 /4 * cd /~~home~~/~~sitebuil~~/~~scripts~~/~~S3-Site-Backups; php s3cli_backupDb.php sitebuil_wikidb~~		0 2 * * * find /var/backups/s3/*.gz -ctime +21 -type f -print \| xargs rm -f
	~~05 3 /4 * cd /home/sitebuil~~/scripts~~/S3-Site-Backups~~; ~~php s3cli_backupDb~~.~~php sitebuil_wrdp1~~		</pre>
	10 3 /~~4 * cd /home/sitebuil/scripts/S3-Site-Backups; php s3cli_backupDb~~.~~php sitebuil_wuffdb~~
	~~15 3 /4 * cd /home/sitebuil/scripts/S3-Site-Backups; php s3cli_backupDb.php taxplans~~
	~~20 3 /4 * cd /home/sitebuil/scripts/S3-Site-Backups; php s3cli_backupDb.php webeshoppin~~
	~~#Delete all local backups older than 3 weeks (at 2am)~~
	00 2 * * * find /var/backups/~~backup~~/*.gz -ctime +21 -type f -print \| xargs rm -f
	</~~syntaxhighlight~~>
	~~crontab to delete files older than 21 days~~
	~~#Delete all local backups older than 3 weeks (at 2am)~~
	~~00 2 * * * find /PATH/TO/HOME_DIR/backups/*.gz -ctime +21 -type f -print \| xargs rm -f~~
	~~#Run it every three days...~~
	0 0 /3 *
	:[http://www.scrounge.org/linux/cron.html cron tutorial] [http://www.linuxweblog.com/crotab-tutorial another]		:[http://www.scrounge.org/linux/cron.html cron tutorial] [http://www.linuxweblog.com/crotab-tutorial another]
	:Re: Where is crontab stored?		:Re: Where is crontab stored?

Tim: /* cron and backups */

2014-01-01T14:59:46Z

cron and backups

← Older revision		Revision as of 10:59, 1 January 2014
Line 1:		Line 1:
	===cron and backups===		===cron and backups===
			https://help.ubuntu.com/community/CronHowto

	[[php www-data program that creates a crontab and calls a C program that executes root commands to copy it into crontabs and install it]]		[[php www-data program that creates a crontab and calls a C program that executes root commands to copy it into crontabs and install it]]