Backup mySQL-database with a cronjob - Revision history

imported>Johayek at 15:36, 31 January 2015

2015-01-31T15:36:59Z

← Older revision		Revision as of 15:36, 31 January 2015
Line 32:		Line 32:

	> kill -HUP 1229</pre>		> kill -HUP 1229</pre>

			[[Category:SynologyWiki]]
			[[Category:ToBeExported]]

imported>Johayek: 4 revisions imported: imported from forum.synology.com/wiki

2015-01-31T15:33:30Z

4 revisions imported: imported from forum.synology.com/wiki

← Older revision	Revision as of 15:33, 31 January 2015
(No difference)

imported>Frodelu: Added SIGHUP alternative to activate new crontab in bullet 6.

2008-07-23T17:57:31Z

Added SIGHUP alternative to activate new crontab in bullet 6.

← Older revision		Revision as of 17:57, 23 July 2008
Line 27:		Line 27:
	The script will start every day at 0:01h (just after the time update).		The script will start every day at 0:01h (just after the time update).

	6. Restart your Synology Station to activate the new crontab.		6. Restart your Synology Station to activate the new crontab or alternatively send a SIGHUP signal to the crond process to force a rescan of the crontab:
			<pre> > ps \| grep crond \| grep -v grep
			1229 root 580 S /usr/sbin/crond

			> kill -HUP 1229</pre>

imported>Trolli at 11:40, 6 December 2007

2007-12-06T11:40:16Z

← Older revision		Revision as of 11:40, 6 December 2007
Line 24:		Line 24:

	5. Finally you have to add this script to /etc/crontab to have the script run at a specific time. Add the following line into the crontab:		5. Finally you have to add this script to /etc/crontab to have the script run at a specific time. Add the following line into the crontab:
	<pre>1 0 * * * root sh /volume1/~~deinpfad~~/mysqlbackup.sh</pre>		<pre>1 0 * * * root sh /volume1/path/mysqlbackup.sh</pre>
	The script will start every day at 0:01h (just after the time update).		The script will start every day at 0:01h (just after the time update).

	6. Restart your Synology Station to activate the new crontab.		6. Restart your Synology Station to activate the new crontab.

imported>Trolli at 08:53, 19 November 2007

2007-11-19T08:53:11Z

← Older revision		Revision as of 08:53, 19 November 2007
Line 26:		Line 26:
	<pre>1 0 * * * root sh /volume1/deinpfad/mysqlbackup.sh</pre>		<pre>1 0 * * * root sh /volume1/deinpfad/mysqlbackup.sh</pre>
	The script will start every day at 0:01h (just after the time update).		The script will start every day at 0:01h (just after the time update).

			6. Restart your Synology Station to activate the new crontab.

imported>Trolli: New page: The script described below and the backups should be saved somewhere on volume1. You have to edit the script to match your preferred path. You also have to enter your sql-password in the s...

2007-11-16T16:12:42Z

New page: The script described below and the backups should be saved somewhere on volume1. You have to edit the script to match your preferred path. You also have to enter your sql-password in the s...

New page

The script described below and the backups should be saved somewhere on volume1. You have to edit the script to match your preferred path. You also have to enter your sql-password in the script.

1. Put the code below into a file called mysqlbackup.sh:
<pre>#!/bin/bash
# number of backups to be saved
KEEP=2
BACKUPS=`find /volume1/path/sqlbackup -name "mysqldump-*.gz" | wc -l | sed 's/\ //g'`
while [ $BACKUPS -ge $KEEP ]
do
ls -tr1 /volume1/path/sqlbackup/mysqldump-*.gz | head -n 1 | xargs rm -f
BACKUPS=`expr $BACKUPS - 1`
done
DATE=`date +%Y%m%d%H%M%S`
rm -f /volume1/path/sqlbackup/.mysqldump-${DATE}.gz_INPROGRESS
/usr/syno/mysql/bin/mysqldump --opt -uroot -psqlpassword --all-databases | gzip -c -9 > /volume1/path/sqlbackup/.mysqldump-${DATE}.gz_INPROGRESS
mv -f /volume1/path/sqlbackup/.mysqldump-${DATE}.gz_INPROGRESS /volume1/path/sqlbackup/mysqldump-${DATE}.gz
exit 0</pre>

2. This file has to be saved to /volume1/'''path'''.

3. Make a subdirectory /volume1/'''path'''/sqlbackup

4. For a test you can run the script with "sh /volume1/'''path'''/mysqlbackup.sh". When you start the script, the old backups will be deleted and after that the backup will start.

5. Finally you have to add this script to /etc/crontab to have the script run at a specific time. Add the following line into the crontab:
<pre>1 0 * * * root sh /volume1/deinpfad/mysqlbackup.sh</pre>
The script will start every day at 0:01h (just after the time update).