brunocarvalhodearaujo · December 22, 2017 16:56
diff --git a/mysql_dump.sh b/mysql_dump.sh
 #!/bin/sh

 mysqldump -u root -pmysql123 –all-databases –routines| gzip > /root/MySQLDB_`date ‘+%m-%d-%Y’`.sql.gz
 mysqldump -h 172.16.21.3 -u root -pmysql123 –all-databases –routines | gzip > /root/MySQLDB.3_`date ‘+%m-%d-%Y’`.sql.gz

 #now create cron script smth like this
 #crontab -e
 #30 15 * * * /root/MySQLdump.sh 2>&1>> /root/MySQLdump.log
 #The above will dump the database every day at 15:30.

 #http://dbperf.wordpress.com/2010/06/11/automate-mysql-dumps-using-linux-cron-job/
	#!/bin/sh

	mysqldump -u root -pmysql123 –all-databases –routines\| gzip > /root/MySQLDB_`date ‘+%m-%d-%Y’`.sql.gz
	mysqldump -h 172.16.21.3 -u root -pmysql123 –all-databases –routines \| gzip > /root/MySQLDB.3_`date ‘+%m-%d-%Y’`.sql.gz

	#now create cron script smth like this
	#crontab -e
	#30 15 * * * /root/MySQLdump.sh 2>&1>> /root/MySQLdump.log
	#The above will dump the database every day at 15:30.

	#http://dbperf.wordpress.com/2010/06/11/automate-mysql-dumps-using-linux-cron-job/