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.52. biar asyik bikin deh folder backup di var caranya :
--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)
$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. dbuser4. 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.
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
5. isi deh dalam crontab :
3 3 * * * sh /home/[nama user]/automysqlbackup.sh.2.5maksudnya 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