{"id":967,"date":"2018-04-05T07:41:11","date_gmt":"2018-04-05T06:41:11","guid":{"rendered":"http:\/\/oktobrima.staff.fe.uns.ac.id\/?p=967"},"modified":"2021-03-02T23:20:14","modified_gmt":"2021-03-02T23:20:14","slug":"membuat-auto-backup-mysql-sendiri","status":"publish","type":"post","link":"https:\/\/angga.feb.uns.ac.id\/?p=967","title":{"rendered":"Membuat Auto Backup mysql sendiri"},"content":{"rendered":"

Jika Anda membutuhkan pencadangan tiap-tiap\u00a0database<\/em> dalam satu berkas masing-masing, Anda bisa mencontoh skrip di bawah ini:<\/p>\n

Pertama-tama kita buat dahulu direktori misalnya di\u00a0\/backup<\/code>, lalu kemudian buat berkas bernama\u00a0db-backup.sh<\/code>:<\/p>\n

$<\/span> <\/span>sudo <\/span>mkdir<\/span> <\/span>\/<\/span>backup<\/span><\/div>\n
$<\/span> <\/span>sudo <\/span>touch<\/span> <\/span>\/<\/span>usr<\/span>\/<\/span>bin<\/span>\/<\/span>db<\/span>–<\/span>backup<\/span>.sh<\/span><\/div>\n
$<\/span> <\/span>sudo <\/span>chmod<\/span> <\/span>+<\/span>x<\/span> <\/span>\/<\/span>usr<\/span>\/<\/span>bin<\/span>\/<\/span>db<\/span>–<\/span>backup<\/span>.sh<\/span><\/div>\n
$<\/span> <\/span>sudo <\/span>nano<\/span> <\/span>\/<\/span>usr<\/span>\/<\/span>bin<\/span>\/<\/span>db<\/span>–<\/span>backup<\/span>.sh<\/span><\/div>\n
<\/div>\n
Kemdian, masukan skrip di bawah ini:<\/span><\/span><\/div>\n
<\/p>\n
#!\/bin\/bash<\/span><\/div>\n
<\/div>\n
DB_USER<\/span>=<\/span>“root”<\/span><\/div>\n
DB_PASSWORD<\/span>=<\/span>“PasswordAnda”<\/span><\/div>\n
DB_PATH_BACKUP<\/span>=<\/span>“\/backup”<\/span><\/div>\n
<\/div>\n
\/<\/span>usr<\/span>\/<\/span>bin<\/span>\/<\/span>mysql<\/span> <\/span>–<\/span>u<\/span> <\/span>$<\/span>DB_USER<\/span> <\/span>—<\/span>password<\/span>=<\/span>$<\/span>DB_PASSWORD<\/span> <\/span>–<\/span>e<\/span> <\/span>‘show databases’<\/span> <\/span>|<\/span> <\/span>\\<\/span><\/div>\n
\/<\/span>usr<\/span>\/<\/span>bin<\/span>\/<\/span>awk<\/span> <\/span>‘{print $1}’<\/span> <\/span>|<\/span> <\/span>\\<\/span><\/div>\n
\/<\/span>bin<\/span>\/<\/span>grep<\/span> <\/span>–<\/span>v<\/span> <\/span>“Database\\|information_schema\\|performance_schema”<\/span> <\/span>|<\/span> <\/span>\\<\/span><\/div>\n
\/<\/span>usr<\/span>\/<\/span>bin<\/span>\/<\/span>xargs<\/span> <\/span>–<\/span>i<\/span>{<\/span>}<\/span> <\/span>\\<\/span><\/div>\n
\/<\/span>usr<\/span>\/<\/span>bin<\/span>\/<\/span>mysqldump<\/span> <\/span>–<\/span>u<\/span> <\/span>$<\/span>DB_USER<\/span> <\/span>—<\/span>password<\/span>=<\/span>$<\/span>DB<\/span>_<\/span>PASSWORD <\/span>\\<\/span><\/div>\n
—<\/span>opt<\/span> <\/span>–<\/span>Q<\/span> <\/span>—<\/span>result<\/span>–<\/span>file<\/span>=<\/span>$<\/span>DB_PATH_BACKUP<\/span>\/<\/span>{<\/span>}<\/span>–<\/span>`<\/span>date<\/span> <\/span>+<\/span>%<\/span>F<\/span>–<\/span>%<\/span>I<\/span>%<\/span>p<\/span>`<\/span>.sql<\/span> <\/span>{<\/span>}<\/span><\/div>\n
<\/div>\n
gzip<\/span> <\/span>–<\/span>q<\/span> <\/span>$<\/span>DB_PATH_BACKUP<\/span>\/<\/span>*<\/span>.sql<\/span><\/div>\n
<\/div>\n
masukkan ke crontab \/etc\/crontab<\/span><\/div>\n
30<\/span> <\/span>0<\/span> <\/span>*<\/span> <\/span>*<\/span> <\/span>*<\/span> <\/span>\/<\/span>usr<\/span>\/<\/span>bin<\/span>\/<\/span>db<\/span>–<\/span>backup<\/span>.sh<\/span><\/span><\/div>\n
<\/div>\n
db-backup<\/a><\/span><\/span><\/div>\n
<\/div>\n
disadru dari\u00a0https:\/\/situsali.com\/membuat-skrip-auto-backup-mysqlmariadb\/<\/span><\/span><\/div>\n

<\/span><\/div>\n","protected":false},"excerpt":{"rendered":"

Jika Anda membutuhkan pencadangan tiap-tiap\u00a0database dalam satu berkas masing-masing, Anda bisa mencontoh skrip di bawah ini: Pertama-tama kita buat dahulu direktori misalnya di\u00a0\/backup, lalu kemudian buat berkas bernama\u00a0db-backup.sh: $ sudo mkdir \/backup $ sudo touch \/usr\/bin\/db–backup.sh $ sudo chmod +x \/usr\/bin\/db–backup.sh $ sudo nano \/usr\/bin\/db–backup.sh Kemdian, masukan skrip di bawah ini: #!\/bin\/bash DB_USER=“root” DB_PASSWORD=“PasswordAnda” DB_PATH_BACKUP=“\/backup” […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-967","post","type-post","status-publish","format-standard","hentry","category-freebsd"],"_links":{"self":[{"href":"https:\/\/angga.feb.uns.ac.id\/index.php?rest_route=\/wp\/v2\/posts\/967","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/angga.feb.uns.ac.id\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/angga.feb.uns.ac.id\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/angga.feb.uns.ac.id\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/angga.feb.uns.ac.id\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=967"}],"version-history":[{"count":1,"href":"https:\/\/angga.feb.uns.ac.id\/index.php?rest_route=\/wp\/v2\/posts\/967\/revisions"}],"predecessor-version":[{"id":4098,"href":"https:\/\/angga.feb.uns.ac.id\/index.php?rest_route=\/wp\/v2\/posts\/967\/revisions\/4098"}],"wp:attachment":[{"href":"https:\/\/angga.feb.uns.ac.id\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=967"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/angga.feb.uns.ac.id\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=967"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/angga.feb.uns.ac.id\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=967"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}