[Solved] Cara backup database auto di hosting

[ngalamcity]

Gan tolong dunk yang taw cara backup otomatis di hosting.. dari tadi gue nyari g ad yang bener.. nyarinya ap kluarnya ap

Pliiss Butuh banget gan...

[Joris]

(03-20-2012 08:44 AM)ngalamcity Wrote:  Gan tolong dunk yang taw cara backup otomatis di hosting.. dari tadi gue nyari g ad yang bener.. nyarinya ap kluarnya ap

Pliiss Butuh banget gan...

Kalao mau backup database secara berkala pake cron job aja...
Bisa ditentukan mau dibackup kapan aja.

[ngalamcity]

(03-20-2012 10:06 AM)Joris Wrote:  

(03-20-2012 08:44 AM)ngalamcity Wrote:  Gan tolong dunk yang taw cara backup otomatis di hosting.. dari tadi gue nyari g ad yang bener.. nyarinya ap kluarnya ap

Pliiss Butuh banget gan...

Kalao mau backup database secara berkala pake cron job aja...
Bisa ditentukan mau dibackup kapan aja.

Nice gan.. udah bs

Thanks AGAN ..

[Joris]

(03-20-2012 10:17 AM)ngalamcity Wrote:  

(03-20-2012 10:06 AM)Joris Wrote:  

(03-20-2012 08:44 AM)ngalamcity Wrote:  Gan tolong dunk yang taw cara backup otomatis di hosting.. dari tadi gue nyari g ad yang bener.. nyarinya ap kluarnya ap

Pliiss Butuh banget gan...

Kalao mau backup database secara berkala pake cron job aja...
Bisa ditentukan mau dibackup kapan aja.

Nice gan.. udah bs

Thanks AGAN ..

sama2 bro.......

[ngalamcity]

buat temen2 yang lom taw nh Ane pke script nya..
php(bak.php) :

PHP Code:

<?php  
$dbUser = "...";
$dbPass = "...";
$dbName = "...";
$dbHost = "localhost";
   
$backupfile = $dbName . date("Y-m-d-H-i-s") . '.sql';
exec("mysqldump -h $dbHost -u $dbUser -p$dbPass $dbName > $backupfile");
      
?>

settingan d cron jobnya :

Code:

0    0    *    *    0    php -q /home/user_akun/public_html/bak.php

*note nh bakup per minggu

[dzawa]

mantap gan, thx hee.. Mw tak test dulu... Hehe, lumayan..

[ngalamcity]

(03-20-2012 11:52 AM)dzawa Wrote:  mantap gan, thx hee.. Mw tak test dulu... Hehe, lumayan..

Yups sama2

[ditatompel]

Nih ane buat simple bash script buat backup all db ama www directory.. Sapa tau berguna..

Code:

#!/bin/sh
#simple backup script

THEDATE=`date +%d%m%y%H%M`

#backup database dan webdir
mysqldump -u root -password_ente -A | gzip -9 > /path/to/backup/dir/sql/backupnew.sql.gz
tar -pczf /path/to/backup/dir/web/backupnew.tar.gz /path/to/www/dir

# hapus backupan lama
find /path/to/backup/dir/sql/cron_* -exec rm {} \;
find /path/to/backup/dir/web/cron_* -exec rm {} \;

#rename file backupan baru
mv /path/to/backup/dir/sql/backupnew.sql.gz /path/to/backup/dir/sql/cron_backupalldb_$THEDATE.sql.gz
mv /path/to/backup/dir/web/backupnew.tar.gz  /path/to/backup/dir/web/cron_webbackup_$THEDATE.tar.gz

[ngalamcity]

(03-20-2012 08:18 PM)ditatompel Wrote:  

Nih ane buat simple bash script buat backup all db ama www directory.. Sapa tau berguna..

Code:

#!/bin/sh
#simple backup script

THEDATE=`date +%d%m%y%H%M`

#backup database dan webdir
mysqldump -u root -password_ente -A | gzip -9 > /path/to/backup/dir/sql/backupnew.sql.gz
tar -pczf /path/to/backup/dir/web/backupnew.tar.gz /path/to/www/dir

# hapus backupan lama
find /path/to/backup/dir/sql/cron_* -exec rm {} \;
find /path/to/backup/dir/web/cron_* -exec rm {} \;

#rename file backupan baru
mv /path/to/backup/dir/sql/backupnew.sql.gz /path/to/backup/dir/sql/cron_backupalldb_$THEDATE.sql.gz
mv /path/to/backup/dir/web/backupnew.tar.gz  /path/to/backup/dir/web/cron_webbackup_$THEDATE.tar.gz

Yuhuuu.. thanks y Gan..