{"id":1788,"date":"2022-10-12T08:19:45","date_gmt":"2022-10-12T08:19:45","guid":{"rendered":"https:\/\/sunucucozumleri.com\/?p=1788"},"modified":"2022-10-12T08:21:22","modified_gmt":"2022-10-12T08:21:22","slug":"cpanel-icin-zamanlanmis-gorev-kullanarak-otomatik-veritabani-yedegi-alip-ftpye-aktarmak","status":"publish","type":"post","link":"https:\/\/sunucucozumleri.com\/blog\/cpanel-icin-zamanlanmis-gorev-kullanarak-otomatik-veritabani-yedegi-alip-ftpye-aktarmak\/","title":{"rendered":"cPanel \u0130\u00e7in Zamanlanm\u0131\u015f G\u00f6rev Kullanarak Otomatik Veritaban\u0131 Yede\u011fi Al\u0131p FTP’ye Aktarmak"},"content":{"rendered":"

Merhabalar, takvimler 12 ekim 2022 g\u00f6sterirken halen internette her arad\u0131\u011f\u0131m\u0131z\u0131 bulamaman\u0131n yan\u0131 s\u0131ra sanal sunucu<\/strong><\/a> ve fiziksel sunucu<\/strong><\/a> kullanan m\u00fc\u015fterilerimiz i\u00e7in basit ama etkili bir bash script yazd\u0131k. Hayati \u00f6nem arz eden bir konu oldu\u011funu d\u00fc\u015f\u00fcnmekteyiz. Belki sunucular\u0131n\u0131z\u0131 yedekleyemiyor olabilirsiniz ancak bu basit bash dosyas\u0131 ile veritabanlar\u0131n\u0131z\u0131 en az\u0131ndan daha g\u00fcvenilir bir \u015fekilde daha g\u00fcvenli bir alana yedekleyebilirsiniz. Daha \u00f6nce payla\u015fm\u0131\u015f oldu\u011fumuz cPanel \u2013 Zamanlanm\u0131\u015f G\u00f6revleri Kullanarak Veritaban\u0131 Yede\u011fi Almak<\/a> makalemizde en \u00e7ok sorulan sorulardan birisi olmu\u015ftur.<\/p>\n

\u00d6ncelikle bu bash dosyas\u0131 cpanel \/ whm sanal sunucu<\/a> yada fiziksel sunucu<\/a> kullananlar i\u00e7indir.<\/p>\n


\n#!\/bin\/bash<\/code><\/p>\n

backup_path=”\/root\/veritabaniyedekleri”<\/p>\n

create_backup() {
\numask 177<\/p>\n

FILE=”dosyaismi_$(date +%Y-%m-%d_%H.%M).sql.gz”
\nmysqldump –single-transaction –quick –lock-tables=false veritabaniadi | gzip –best > $FILE<\/p>\n

echo ‘Backup Alindi’
\n}<\/p>\n

clean_backup() {
\nrm -f $backup_path\/$FILE
\necho ‘Backup Silindi’
\n}<\/p>\n

##################################
\n# Bu alani duzenleyebilirsiniz #
\n##################################<\/p>\n

# FTP Login bilgileri
\nUSERNAME=”FTPKULLANICIADI”
\nPASSWORD=”FTPSIFRESI”
\nSERVER=”FTPIPADRESI”
\nPORT=”21″<\/p>\n

#Uzak dizin yolu
\nREMOTEDIR=”.\/”<\/p>\n

#Transfer tipi
\n#1=FTP
\n#2=SFTP
\nTYPE=1<\/p>\n

##############################
\n# Bu alani duzenlemeyin #
\n##############################<\/p>\n

d=$(date –iso)
\ncd $backup_path
\ncreate_backup<\/p>\n

if [ $TYPE -eq 1 ]
\nthen
\nftp -n -i $SERVER <<EOF
\nuser $USERNAME $PASSWORD
\nbinary
\ncd $REMOTEDIR
\nmput $FILE
\nquit
\nEOF
\nelif [ $TYPE -eq 2 ]
\nthen
\nrsync –rsh=”sshpass -p $PASSWORD ssh -p $PORT -o StrictHostKeyChecking=no -l $USERNAME” $backup_path\/$FILE $SERVER:$REMOTEDIR
\nelse
\necho ‘Lutfen Transfer Tipini Seciniz’
\nfi<\/p>\n

echo ‘Backup Yuklendi’
\nclean_backup
\n#END<\/p>\n

 <\/p>\n

Yapaca\u011f\u0131n\u0131z de\u011fi\u015fikler a\u015fa\u011f\u0131daki gibidir.<\/p>\n

FTPKULLANICIADI<\/p>\n

FTPSIFRESI<\/p>\n

FTPIPADRESI<\/p>\n

dosyaismi_<\/p>\n

veritabaniadi<\/p>\n

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

Merhabalar, takvimler 12 ekim 2022 g\u00f6sterirken halen internette her arad\u0131\u011f\u0131m\u0131z\u0131 bulamaman\u0131n yan\u0131 s\u0131ra sanal sunucu ve fiziksel sunucu kullanan m\u00fc\u015fterilerimiz i\u00e7in basit ama etkili bir bash script yazd\u0131k. Hayati \u00f6nem arz eden bir konu oldu\u011funu d\u00fc\u015f\u00fcnmekteyiz. Belki sunucular\u0131n\u0131z\u0131 yedekleyemiyor olabilirsiniz ancak bu basit bash dosyas\u0131 ile veritabanlar\u0131n\u0131z\u0131 en az\u0131ndan daha g\u00fcvenilir bir \u015fekilde daha g\u00fcvenli …<\/p>\n","protected":false},"author":1,"featured_media":1445,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[7],"tags":[],"class_list":["post-1788","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cpanel"],"acf":[],"_links":{"self":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/posts\/1788","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/comments?post=1788"}],"version-history":[{"count":0,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/posts\/1788\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/media\/1445"}],"wp:attachment":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/media?parent=1788"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/categories?post=1788"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/tags?post=1788"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}