MysqlBackupAll - Revision history

imported>T1t0 at 03:13, 8 July 2018

2018-07-08T03:13:55Z

← Older revision		Revision as of 03:13, 8 July 2018
Line 158:		Line 158:
	[[Category:backup]]		[[Category:backup]]
	[[Category:mysql]]		[[Category:mysql]]
			[[Category:to_translate]]

imported>T1t0 at 12:01, 1 July 2016

2016-07-01T12:01:06Z

← Older revision		Revision as of 12:01, 1 July 2016
Line 9:		Line 9:


	<pre>#!/bin/bash		<pre>
			#!/bin/bash
			#
			# NAME mysqlBackupAll.sh
			# VERSION 1.1
			# REQUIRED mysqldump, mail, mutt, gzip, ftp
	#		#
	~~# mysqlBackupAll~~


Line 136:		Line 140:
	if test ${SEND_BY_EMAIL} = "y";		if test ${SEND_BY_EMAIL} = "y";
	then		then
	ls -l "${BACKUP_DIR}" \| mutt -s "${SUBJECT} success." -a "${BACKUP_DIR}${BACKUP_FILE}" -- "${EMAIL}";		ls -l "${BACKUP_DIR}" \| mutt -n -e 'set copy=no' -s "${SUBJECT} success." -a "${BACKUP_DIR}${BACKUP_FILE}" -- "${EMAIL}";
	exit 0;		exit 0;
	else		else

imported>T1t0 at 16:23, 25 October 2012

2012-10-25T16:23:28Z

← Older revision		Revision as of 16:23, 25 October 2012
Line 26:		Line 26:
	SEND_BY_FTP="y";		SEND_BY_FTP="y";
	FTP_HOST="[DESTDOMSIN.WHR]";		FTP_HOST="[DESTDOMSIN.WHR]";
	FTP_DIR="~~postgresql~~/alldatabases";		FTP_DIR="mysql/alldatabases";
	FTP_USER="[USER]";		FTP_USER="[USER]";
	FTP_PASS="[PASS]";		FTP_PASS="[PASS]";

imported>T1t0 at 16:21, 25 October 2012

2012-10-25T16:21:06Z

← Older revision		Revision as of 16:21, 25 October 2012
Line 5:		Line 5:
	= Requirements =		= Requirements =

	Il percorso /srv/backup/mysql/alldatabases/ deve esistere e essere di proprietà dell'utente mysql, e i comandi mail, mysqldump, gzip e mutt devono essere accessibili.		Il percorso /srv/backup/mysql/alldatabases/ deve esistere e essere di proprietà dell'utente mysql, e i comandi mail, mysqldump, gzip, ftp e mutt devono essere accessibili.


Line 53:		Line 53:
	then		then
	echo "Command gzip not found, exit." \| mail -s "${SUBJECT} error." "${EMAIL}";		echo "Command gzip not found, exit." \| mail -s "${SUBJECT} error." "${EMAIL}";
			exit 1;
			fi;

			if test ! `which ftp`
			then
			echo "Command ftp not found, exit." \| mail -s "${SUBJECT} error." "${EMAIL}";
	exit 1;		exit 1;
	fi;		fi;

imported>T1t0 at 15:40, 25 October 2012

2012-10-25T15:40:38Z

← Older revision		Revision as of 15:40, 25 October 2012
Line 5:		Line 5:
	= Requirements =		= Requirements =

	Il percorso /srv/backup/mysql/ deve esistere e essere di proprietà dell'utente ~~backup~~, e i comandi mail, mysqldump, gzip e mutt devono essere accessibili.		Il percorso /srv/backup/mysql/alldatabases/ deve esistere e essere di proprietà dell'utente mysql, e i comandi mail, mysqldump, gzip e mutt devono essere accessibili.



	<pre>		<pre>#!/bin/bash
	#!/bin/bash
	#		#
	# mysqlBackupAll		# mysqlBackupAll
Line 18:		Line 17:
	# Var		# Var

	BACKUP_DIR="/srv/backup/mysql/";		BACKUP_DIR="/srv/backup/mysql/alldatabases/";
	BACKUP_FILE="bkp-mysql_alldatabases-`date +%Y.%m.%d_%H.%M.%S`-dump.sql.gz";		BACKUP_FILE="bkp-mysql_alldatabases-`date +%Y.%m.%d_%H.%M.%S`-dump.sql.gz";
	BACKUP_COMMAND="mysqldump --user=root --single-transaction --all-databases --flush-logs --lock-tables --flush-privileges \| gzip > ${BACKUP_DIR}${BACKUP_FILE}";		BACKUP_COMMAND="mysqldump --user=root --single-transaction --all-databases --flush-logs --lock-tables --flush-privileges \| gzip > ${BACKUP_DIR}${BACKUP_FILE}";
	BACKUP_USER="~~backup~~";		BACKUP_USER="root";
	ROTATE_USER="~~backup~~";		ROTATE_USER="mysql";
	ROTATE_DAYS="7";		ROTATE_DAYS="8";

	EMAIL="~~email~~@~~server~~.~~whr~~";		SEND_BY_FTP="y";
	SUBJECT="~~domain~~.~~whr~~ MySQL backup";		FTP_HOST="[DESTDOMSIN.WHR]";
			FTP_DIR="postgresql/alldatabases";
			FTP_USER="[USER]";
			FTP_PASS="[PASS]";

			SEND_BY_EMAIL="n";
			EMAIL="[WHO@MAILSERVER.WHR]";
			SUBJECT="[YOURDOMAIN.WHR] MySQL backup";


Line 92:		Line 98:
	# Rotate		# Rotate

	if ! su - "${ROTATE_USER}" -s /bin/sh -c "ls -t ${BACKUP_DIR}*-dump.sql.gz \| tail -n +8 \| xargs -d '\n' rm -f";		if ! su - "${ROTATE_USER}" -s /bin/sh -c "ls -t ${BACKUP_DIR}*-dump.sql.gz \| tail -n +${ROTATE_DAYS} \| xargs -d '\n' rm -f";
	then		then
	echo "Rotate ${BACKUP_DIR} failure, exit." \| mail -s "${SUBJECT} error." "${EMAIL}";		echo "Rotate ${BACKUP_DIR} failure, exit." \| mail -s "${SUBJECT} error." "${EMAIL}";
Line 100:		Line 106:


	~~# Exit~~

	~~ls -l "${BACKUP_DIR}" \| mutt -s "${SUBJECT} success." -a "${BACKUP_DIR}${BACKUP_FILE}" -- "${EMAIL}";~~
	~~exit 0;~~



	~~# End~~

	~~</pre>~~



	~~E' facilmente modificabile per fare l'ulpload tramite ftp aggiungendo i comandi a seguire poco prima della label ''# Exit''~~

	~~<pre>~~
	# Upload		# Upload

	ftp -i -n ${FTP_HOST} << EOF		if test ${SEND_BY_FTP} = "y";
			then
			ftp -i -n ${FTP_HOST} << EOF
	user ${FTP_USER} ${FTP_PASS}		user ${FTP_USER} ${FTP_PASS}
	binary		binary
Line 125:		Line 117:
	EOF		EOF

	if test $? -ne 0;		if test $? -ne 0;
			then
			echo "Upload to ${FTP_HOST} failure, exit." \| mail -s "${SUBJECT} error." ${EMAIL};
			exit 1;
			fi;
			fi;



			# Exit

			if test ${SEND_BY_EMAIL} = "y";
	then		then
	~~echo~~ "~~Upload to~~ ${~~FTP_HOST~~} ~~failure, exit.~~" \| ~~mail~~ -s "${SUBJECT} ~~error~~." ${EMAIL};		ls -l "${BACKUP_DIR}" \| mutt -s "${SUBJECT} success." -a "${BACKUP_DIR}${BACKUP_FILE}" -- "${EMAIL}";
	exit 1;		exit 0;
			else
			ls -l "${BACKUP_DIR}" \| mail -s "${SUBJECT} success." "${EMAIL}";
	fi;		fi;



			# End

	</pre>		</pre>

imported>T1t0 at 14:12, 25 October 2012

2012-10-25T14:12:53Z

← Older revision		Revision as of 14:12, 25 October 2012
Line 127:		Line 127:
	if test $? -ne 0;		if test $? -ne 0;
	then		then
	echo "Upload to ${FTP_HOST} failure, exit." \| mail -s "${SUBJECT}		echo "Upload to ${FTP_HOST} failure, exit." \| mail -s "${SUBJECT} error." ${EMAIL};
	error." ${EMAIL};
	exit 1;		exit 1;
	fi;		fi;

imported>T1t0 at 16:08, 25 September 2012

2012-09-25T16:08:46Z

← Older revision		Revision as of 16:08, 25 September 2012
Line 1:		Line 1:
	Questo script fa un backup completo di MySQL e lo invia all'email configurato. E' possibile restaurare il backup con le istruzioni dell'articolo [[mysql\|MySQL]].		Questo script fa un backup completo di MySQL e lo invia all'email configurato. E' possibile restaurare il backup con le istruzioni dell'articolo [[mysql\|MySQL]].

	~~NOTA: il~~ percorso /srv/backup/mysql/ deve esistere e essere di proprietà dell'utente backup, e i comandi mail, mysqldump, gzip e mutt devono essere accessibili.

			= Requirements =

			Il percorso /srv/backup/mysql/ deve esistere e essere di proprietà dell'utente backup, e i comandi mail, mysqldump, gzip e mutt devono essere accessibili.



Line 21:		Line 26:

	EMAIL="email@server.whr";		EMAIL="email@server.whr";
	SUBJECT="domain.whr ~~Postgresql~~ backup";		SUBJECT="domain.whr MySQL backup";

imported>T1t0 at 01:17, 8 February 2012

2012-02-08T01:17:29Z

← Older revision		Revision as of 01:17, 8 February 2012
Line 87:		Line 87:
	# Rotate		# Rotate

	if ! su - "${ROTATE_USER}" -s /bin/sh -c "ls -t ${BACKUP_DIR}*.gz \| tail -n +8 \| xargs -d '\n' rm -f";		if ! su - "${ROTATE_USER}" -s /bin/sh -c "ls -t ${BACKUP_DIR}*-dump.sql.gz \| tail -n +8 \| xargs -d '\n' rm -f";
	then		then
	echo "Rotate ${BACKUP_DIR} failure, exit." \| mail -s "${SUBJECT} error." "${EMAIL}";		echo "Rotate ${BACKUP_DIR} failure, exit." \| mail -s "${SUBJECT} error." "${EMAIL}";

imported>T1t0 at 14:43, 7 February 2012

2012-02-07T14:43:54Z

← Older revision		Revision as of 14:43, 7 February 2012
Line 133:		Line 133:
	[[Category:unix]]		[[Category:unix]]
	[[Category:scripts]]		[[Category:scripts]]
			[[Category:backup]]
	[[Category:mysql]]		[[Category:mysql]]

imported>T1t0: Created page with "Questo script fa un backup completo di MySQL e lo invia all'email configurato. E' possibile restaurare il backup con le istruzioni dell'articolo MySQL. NOTA: il per..."

2012-02-07T13:31:29Z

Created page with "Questo script fa un backup completo di MySQL e lo invia all'email configurato. E' possibile restaurare il backup con le istruzioni dell'articolo MySQL. NOTA: il per..."

New page

Questo script fa un backup completo di MySQL e lo invia all'email configurato. E' possibile restaurare il backup con le istruzioni dell'articolo [[mysql|MySQL]].

NOTA: il percorso /srv/backup/mysql/ deve esistere e essere di proprietà dell'utente backup, e i comandi mail, mysqldump, gzip e mutt devono essere accessibili.

<pre>
#!/bin/bash
#
# mysqlBackupAll

# Var

BACKUP_DIR="/srv/backup/mysql/";
BACKUP_FILE="bkp-mysql_alldatabases-`date +%Y.%m.%d_%H.%M.%S`-dump.sql.gz";
BACKUP_COMMAND="mysqldump --user=root --single-transaction --all-databases --flush-logs --lock-tables --flush-privileges | gzip > ${BACKUP_DIR}${BACKUP_FILE}";
BACKUP_USER="backup";
ROTATE_USER="backup";
ROTATE_DAYS="7";

EMAIL="email@server.whr";
SUBJECT="domain.whr Postgresql backup";

# Test

if test ! `which mail`
then
echo "Command mail not found, exit.";
exit 1;
fi;

if test ! `which mysqldump`
then
echo "Command mysqldump not found, exit." | mail -s "${SUBJECT} error." "${EMAIL}";
exit 1;
fi;

if test ! `which gzip`
then
echo "Command gzip not found, exit." | mail -s "${SUBJECT} error." "${EMAIL}";
exit 1;
fi;

if test ! `which mutt`
then
echo "Command mutt not found, exit." | mail -s "${SUBJECT} error." "${EMAIL}";
exit 1;
fi;

if ! test -d "${BACKUP_DIR}";
then
echo "Directory ${BACKUP_DIR} don't exist, exit." | mail -s "${SUBJECT} error." "${EMAIL}";
exit 1;
fi;

if test -f "${BACKUP_DIR}${BACKUP_FILE}";
then
echo "File ${BACKUP_DIR}${BACKUP_FILE} alredy exist, exit." | mail -s "${SUBJECT} error." "${EMAIL}";
exit 1;
fi;

if ! su - "${BACKUP_USER}" -c "touch ${BACKUP_DIR}${BACKUP_FILE}";
then
echo "User ${BACKUP_USER} cannot write in ${BACKUP_DIR}${BACKUP_FILE}, exit." | mail -s "${SUBJECT} error." "${EMAIL}";
exit 1;
fi;

su - "${BACKUP_USER}" -c "rm -f ${BACKUP_DIR}${BACKUP_FILE}";

# Backup

if ! su - "${BACKUP_USER}" -s /bin/sh -c "${BACKUP_COMMAND}";
then
echo "Backup ${BACKUP_COMMAND} failure, exit." | mail -s "${SUBJECT} error." "${EMAIL}";
exit 1;
fi;

chown "${ROTATE_USER}":"${ROTATE_USER}" "${BACKUP_DIR}${BACKUP_FILE}";

# Rotate

if ! su - "${ROTATE_USER}" -s /bin/sh -c "ls -t ${BACKUP_DIR}*.gz | tail -n +8 | xargs -d '\n' rm -f";
then
echo "Rotate ${BACKUP_DIR} failure, exit." | mail -s "${SUBJECT} error." "${EMAIL}";
exit 1;
fi;

# Exit

ls -l "${BACKUP_DIR}" | mutt -s "${SUBJECT} success." -a "${BACKUP_DIR}${BACKUP_FILE}" -- "${EMAIL}";
exit 0;

# End

</pre>

E' facilmente modificabile per fare l'ulpload tramite ftp aggiungendo i comandi a seguire poco prima della label ''# Exit''

<pre>
# Upload

ftp -i -n ${FTP_HOST} << EOF
user ${FTP_USER} ${FTP_PASS}
binary
put ${BACKUP_DIR}${BACKUP_FILE} ${FTP_DIR}${BACKUP_FILE}
quit
EOF

if test $? -ne 0;
then
echo "Upload to ${FTP_HOST} failure, exit." | mail -s "${SUBJECT}
error." ${EMAIL};
exit 1;
fi;

</pre>

[[Category:unix]]
[[Category:scripts]]
[[Category:mysql]]