backup your MySQL using a bash script and cron job

From allenkan.com/blog
useful sql backup command
1. dump the DB into a sql file
mysqldump -u <username> -p<password> <database> > <output file name>.sql

2. compress it
gzip <Filename>

3. Ftp send to backup server
** it is not suggested because backup ftp account and the backup data is sent in plain text format **

ftp -n $ftpserver <<END_SCRIPT
quote USER $ftpuser
quote PASS $ftppwd
put $gzipOutFile
quit
END_SCRIPT
exit 0

29/11

今日diu team班中學同學約我夜晚去食野..因為陀主生日

7點去到NTP..之後去左禁機@@ 成班人都冇帶錢出街sosad

仲要俾人影左我地成班友禁機-.-

之後上左連城食雲南野..好辣但幾好味:P 食左$90/人..之後行左陣就返歸

24/11

今日約左同學夜晚10點去旺角一壽司食野! 因為10點後半價既關係..所以我地咁遲先去^^

真係食到好鬼飽!我地六個人食左7百幾蚊,每人要122蚊~ 半價黎講算係咁了

食到12點我地去左M記坐左陣就返歸,好彩仲有281A搭~

21/11

生日快樂Kendall!! 今日同佢慶祝生日,放左學我地係新城市打左陣機行左陣,之後再上黎我屋企玩左陣就去左小蜜蜂食飯

食完去左河畔食埋糖水再上我屋企打左陣機就散水了^^

佢地送左condom 俾kendall做生日禮物-.- 我就送左樣最特別既…就係…三年前係camp影佢果張裸照@@