Automatis backup database di MySQL

Seru juga nih dapet tugas dari suhu master tuk bikin automatic backup database operasional. ok,... laksanakan dengan semboyan ikhlas dan ridho insya4JJ1 tuh akan jadi ilmu dan ane tuangin di blog sebagai wadahnya. karena ane masih cupu maka ane selalu ditemani prof google tuk berkelana dan hasilnya :
1. Download AutoMySQLBackup ada di sini source nya -->

root@pc-it:/opt# wget wget http://downloads.sourceforge.net/project/automysqlbackup/AutoMySQLBackup/AutoMySQLBackup%20VER%202.5/automysqlbackup.sh.2.5
--2011-08-15 13:05:34--  http://wget/
Resolving wget... failed: Name or service not known.
wget: unable to resolve host address `wget'
--2011-08-15 13:05:35--  http://downloads.sourceforge.net/project/automysqlbackup/AutoMySQLBackup/AutoMySQLBackup%20VER%202.5/automysqlbackup.sh.2.5
Resolving downloads.sourceforge.net... 216.34.181.59
Connecting to downloads.sourceforge.net|216.34.181.59|:80... connected.
HTTP request sent, awaiting response... 302 Moved Temporarily
Location: http://nchc.dl.sourceforge.net/project/automysqlbackup/AutoMySQLBackup/AutoMySQLBackup%20VER%202.5/automysqlbackup.sh.2.5 [following]
--2011-08-15 13:05:36--  http://nchc.dl.sourceforge.net/project/automysqlbackup/AutoMySQLBackup/AutoMySQLBackup%20VER%202.5/automysqlbackup.sh.2.5
Resolving nchc.dl.sourceforge.net... 211.79.60.17, 2001:e10:ffff:1f02::17
Connecting to nchc.dl.sourceforge.net|211.79.60.17|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 25316 (25K) [application/x-sh]
Saving to: `automysqlbackup.sh.2.5.1'

100%[=======================================================================================================================================>] 25,316      8.88K/s   in 2.8s   

2011-08-15 13:05:40 (8.88 KB/s) - `automysqlbackup.sh.2.5.1' saved [25316/25316]

FINISHED --2011-08-15 13:05:40--
Downloaded: 1 files, 25K in 2.8s (8.88 KB/s)

2. biar asyik bikin deh folder backup di var caranya :

$mkdir /var/backup;
$chmod -R 777 /var/backup

3. mulai deh hajar tuh script,... nih sedikit obok-obokannya :

# Username to access the MySQL server e.g. dbuser
USERNAME=[isi dengan user] ==> Saran Ane mendingan buat user sendiri buat backup
# Username to access the MySQL server e.g. password
PASSWORD=[isi dengan password]  ==> Saran Ane mendingan buat password sendiri dengan user diatas
# Host name (or IP address) of MySQL server e.g localhost
DBHOST=localhost ==> nah ini yang bikin puyeng karena ane rencana backup database di komputer server alias pake IP tapi dh ketemu sih tutorial menyusul
# List of DBNAMES for Daily/Weekly Backup e.g. “DB1 DB2 DB3″
DBNAMES=”[nama database]″
# Backup directory location e.g /backups
BACKUPDIR="/var/backup"
# Buat LOG FILEnya
echo “Log backup: $(date)” >> /var/backup/testing.log

 4. selanjutnya jalanin deh perintah $ crontab -e ENTER kalo ada pilihan biasanya ane milih yang ada tulisan NANO itu maksudnya qt mau edit pake editor apaan.

5. isi deh dalam crontab :

3 3 * * * sh /home/[nama user]/automysqlbackup.sh.2.5

maksudnya tuh crontab akan jalanin file automysqlbackup.sh.2.5 di folder tersebut pada jam 3 lewat 3 menit di pagi hari setiap harinya. selesai....

semoga bermanfaat bagi ane dan para pembaca,.. AMIN