[root@WEBSERVER02 ~]# more /etc/cron.hourly/fhc_backup.sh
#!/bin/sh
#stop the mysql slave thread but let the i/o thread run so it catches up faster to the master
/usr/bin/mysql -e 'stop slave sql_thread;'
#dump the database and compress it while appending the full date
/usr/bin/mysqldump fhc_vbulletin | gzip -9 > /forumbkp/fhc_vbulletin-$(date +%F--%T).sql.gz
#start the sql thread again
/usr/bin/mysql -e 'start slave sql_thread;'
#remove backups older than 48 hours
cd /forumbkp
ls -t | sed -e '1,48d' | xargs -d '\n' rm
{"html5":"htmlmixed","css":"css","javascript":"javascript","php":"php","python":"python","ruby":"ruby","lua":"text\/x-lua","bash":"text\/x-sh","go":"text\/x-go","c":"text\/x-csrc","cpp":"text\/x-c++src","diff":"diff","latex":"stex","sql":"mysql","xml":"xml","c_loadrunner":"text\/x-csrc","c_mac":"text\/x-csrc","coffeescript":"text\/x-coffeescript","csharp":"text\/x-csharp","ecmascript":"javascript","groovy":"text\/x-groovy","haskell":"text\/x-haskell","html4strict":"htmlmixed","java":"text\/x-java","java5":"text\/x-java","jquery":"javascript","mysql":"mysql","pascal":"text\/x-pascal","perl":"perl","perl6":"perl","plsql":"plsql","properties":"text\/x-properties","scheme":"text\/x-scheme","vb":"text\/vbscript","vbnet":"text\/vbscript","verilog":"text\/x-verilog","yaml":"text\/x-yaml"}