聖誕假期

Posted on December 28, 2008 by wallace

終於可以休息一下了！２４號同佢地出左去打機，夜晚去左打邊爐之後佢地上左黎我屋企玩通宵！

打到朝早訓左陣..7點半去左偷翠M記食早餐

之後超攰…返到屋企訓到12點執好野2點幾再訓過@@

１２／１２

Posted on December 12, 2008 by wallace

終於過左辛苦既一個星期！可以休息兩日，但黎緊仲有一個星期又係勁忙忙忙….

尋日同fyproject 公司開埋今年最後一次既會，黎生話同我地影張相作紀念@@

backup your MySQL using a bash script and cron job

Posted on December 6, 2008 by wallace

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