Wednesday, August 5, 2009

Tukang nggame tips. Many ways to perform backups automatically mysql databasee, and can even in the automatic transfer it to the other srver also, here is one of them. This is very simple and just for dummy. :dSERVER I.Buat file dump.sh#!/bin/bashTheDATE=`date +%Y-%m-%d_`W=`date +%A`jamscript=`date +%Hh%Mm`myfiles="mywebdb_"$TheDATE"_"$jamscript"_"$W".sql"cd /var/www/bekap/usr/bin/mysqldump -u myuser --all --password=mypassword mywebdb > $myfilesif [ -e $myfiles ]; then gzip -c $myfiles >...