#! /bin/sh
filename=`date +%Y-%m-%d_%H%M%S`
mysqldump -utest -ptest -h 192.168.1.8 cn2 | gzip>/MySQL_Backup/cn2_$filename.gz
mysqldump -utest -ptest -h 192.168.1.8 transportation | gzip>/MySQL_Backup/trans_$filename.gz
mysqldump -uroot -proot1234 -h 192.168.1.13 canride | gzip>/MySQL_Backup/canride_$filename.gz