#########################
\n# # # Function File # # #
\n#########################<\/p>\n
#########################
\n# Author : Fatih Acar | Msc. Computer Engineer, Database Administrator
\n# E-Mail : fatih@fatihacar.com
\n# Program Name : DBBackup
\n# Date : 15.01.2024
\n# Version : 2.0
\n# Description : Program take full database backup of Oracle,PostgreSQL or MySQL databases with export methods of databases.
\n#########################<\/p>\n
#-*- coding: utf-8 -*-<\/p>\n
import sys
\nimport string
\nfrom time import *
\nfrom config import *
\nimport os
\nimport sys
\nimport smtplib
\nimport logging
\nimport time<\/p>\n
from email.mime.text import MIMEText<\/p>\n
def SendMail(subject,content):<\/p>\n
mail = MIMEText(content)
\nmail[“From”] = mailfrom
\nmail[“To”] = mailto
\nmail[“Subject”] = subject<\/p>\n
send = smtplib.SMTP(mailserver)
\nsend.sendmail(mailfrom,mailto,mail.as_string())
\nsend.quit()<\/p>\n
def GetDateTime():<\/p>\n
mounth=str(localtime()[1])
\nhour=str(localtime()[3])
\nmin=str(localtime()[4])
\nsec=str(localtime()[5])
\nif(len(str(localtime()[1]))==1):
\nmounth=”0″+str(localtime()[1])
\nday=str(localtime()[2])
\nif(len(str(localtime()[2]))==1):
\nday=”0″+str(localtime()[2])
\nreturn str(localtime()[0])+”_”+mounth+”_”+day+”_”+hour+”_”+min+”_”+sec<\/p>\n
def MakeZip(filename,filestozip):<\/p>\n
status = os.system(‘zip -P ‘+zip_pass+’ ‘+zipdir+filename+’.zip ‘+backupdir+filestozip)
\nreturn status<\/p>\n
def WriteLog(logfile,logcontent):<\/p>\n
logcontent = GetDateTime()+’ : ‘+logcontent
\ntry:
\nfile=open(logfile,’a’)
\nfile.write(logcontent+’\\n’)
\nfile.close()
\nexcept:
\nprint (‘HATA : Log yazilirken hata olustu !’)<\/p>\n
def BackupDB(backupparts,backupname,dbtype):<\/p>\n
if(dbtype == ‘PostgreSQL’):
\nstatus = os.system(‘su – postgres -c “pg_dumpall -p ‘ +pgport+ ‘ > ‘+backupdir+backupname+'”‘)
\nreturn status
\nelif(dbtype == ‘Oracle’):
\nstatus = os.system(‘su – oracle -c “expdp ‘+orabackupuser+’\/’+orabackupuserpass+’@’+orasid+’ DIRECTORY=’+orabackupdir+’ DUMPFILE=’+backupparts+’ FULL=Y PARALLEL=8″‘)
\nreturn status
\nelif(dbtype == ‘MySQL’):
\nstatus = os.system(‘mysqldump –port=’+myport+’ –all-databases > ‘+backupdir+backupname)
\nreturn status
\nelse:
\nreturn ‘\\033[91mconfig.py dosyasindaki dbtype parametre degeri dogru degil !\\033[0m’<\/p>\n
def RemoveBackup(backupname):<\/p>\n
status = os.system(‘rm -f ‘+backupdir+backupname)
\nreturn status<\/p>\n
def RemoveOldZipBackup():<\/p>\n
try:
\ncurrent_time = time.time()
\nretention_period = int(retention) * 24 * 60 * 60 # Convert retention days to seconds<\/p>\n
for filename in os.listdir(zipdir):
\nfile_path = os.path.join(zipdir, filename)
\nif os.path.isfile(file_path):
\nfile_age = current_time – os.path.getmtime(file_path)
\nif file_age > retention_period:
\nos.remove(file_path)
\nprint(f”Deleted: {filename}”)<\/p>\n
return 0 # Return success
\nexcept Exception as e:
\nprint(f”An error occurred: {e}”)
\nreturn 1 # Return failure<\/p>\n
def TransportBackupSFTP(backupname):<\/p>\n
try:
\ntp=paramiko.Transport((SFTP_server,int(SFTP_port)))
\ntp.connect(username=SFTP_user,password=SFTP_pass)
\nsftp=paramiko.SFTPClient.from_transport(tp)
\nsftp.put(zipdir+backupname,”\/”+backupname)
\nreturn 0
\nexcept:
\nreturn 1
\nsftp.close()
\ntp.close()<\/p>\n
def TransportBackupSCP(backupname):<\/p>\n
if(usesshpass==1):
\nstatus = os.system(‘sshpass -p ‘ +SCP_pass+ ‘ scp -P ‘ +SCP_port+ ‘ ‘ +zipdir+backupname+ ‘ ‘ +SCP_user+ ‘@’ +SCP_server+ ‘:’+SCP_dir)
\nreturn status
\nelif(usesshpass==0):
\nstatus = os.system(‘scp -P ‘ +SCP_port+ ‘ ‘ +zipdir+backupname+ ‘ ‘ +SCP_user+ ‘@’ +SCP_server+ ‘:’+SCP_dir)
\nreturn status
\nelse:
\nreturn ‘\\033[91mconfig.py dosyasindaki usesshpass parametre degeri dogru degil !\\033[0m’<\/p><\/blockquote>\n
dbbackup.py<\/strong><\/p>\nfrom config import *
\nfrom functions import *
\nimport time<\/p>\n
<\/p>\n
backupname = backup_alias+’_’+GetDateTime()+’.dmp’
\nfilestozip = backup_alias+’_’+GetDateTime()+’*.dmp’
\nbackupparts = backup_alias+’_’+GetDateTime()+’_%u.dmp’<\/p>\n
<\/p>\n
def main():
\nfunctions=[(BackupDB,(backupparts,backupname,dbtype)),(MakeZip,(backupname,filestozip)),(RemoveBackup,(filestozip,)),(TransportBackupSCP,(backupname+’.zip’,)),(RemoveOldZipBackup,())]
\nlogging.basicConfig()
\nfor func,args in functions:
\nresult=func(*args)
\nfunction_name=func.__name__
\nif result == 0:
\nprint(f”{function_name} adimi ba\u015far\u0131yla tamamlandi.”)
\nWriteLog(logfile,f”{function_name} adimi ba\u015far\u0131yla tamamlandi.”)
\nelse:
\nWriteLog(logfile,f”{function_name} adiminda hata alindi. \u0130\u015flemler durduruldu.”)
\nprint(f”{function_name} adiminda hata alindi. \u0130\u015flemler durduruldu.”)
\nreturn
\nprint(“B\u00fct\u00fcn ad\u0131mlar ba\u015far\u0131yla tamamlandi.”)<\/p>\n
main()<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"
You can take export backup of Oracle, PostgreSQL and MySQL databases with one backup script. There are 3 files (config.py, functions.py, dbbackup.py) for backup operation. You can edit config file regarding to your system. You can download python scripts by clicking : dbbackup config.py ####################### # # # Config File # # # ####################### #########################…<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[20],"tags":[49],"class_list":["post-2862","post","type-post","status-publish","format-standard","hentry","category-oracle-backup-and-recovery","tag-oracle-backup-and-restore"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-Ka","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2862","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=2862"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2862\/revisions"}],"predecessor-version":[{"id":2864,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2862\/revisions\/2864"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=2862"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=2862"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=2862"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}