Sunday, 11 March 2012

Backup Mysql


diksi@diksi-M7x0S:~$ mysqldump -uroot -p123 namadatabase > namadatabasebaru.sql
diksi@diksi-M7x0S:~$ cd /home/diksi/Desktop
diksi@diksi-M7x0S:~/Desktop$ chmod +x automysqlbackup2.4.sh

chmod: changing permissions of `automysqlbackup2.4.sh': Operation not permitted
diksi@diksi-M7x0S:~/Desktop$ sudo su
[sudo] password for diksi:
root@diksi-M7x0S:/home/diksi/Desktop# chmod +x automysqlbackup2.4.sh
root@diksi-M7x0S:/home/diksi/Desktop#
copy file automysqlbackup2.4.sh di desktop-buat folder di home:nama backup
edit file sh user/root
di sesuaikan ;; # Backup directory location e.g /backups
BACKUPDIR="/home/diksi/backup"

0 comments: