Guest User

Untitled

a guest
Aug 11th, 2018
113
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.38 KB | None | 0 0
  1. DB_HOST = '192.168.1.1'
  2. DB_USER = 'root'
  3. DB_USER_PASSWORD = '_root_user_password_'
  4. DB_NAME = 'db_name'
  5. BACKUP_PATH = '/backup/dbbackup/'
  6.  
  7. DATETIME = time.strftime('%m%d%Y-%H%M%S')
  8. TODAYBACKUPPATH = BACKUP_PATH + DATETIME
  9.  
  10. dumpcmd = "mysqldump -h " + DB_HOST + " -u " + DB_USER + " -p" + DB_USER_PASSWORD + " " + db + " > " + TODAYBACKUPPATH + "/" + db + ".sql"
  11.  
  12. os.system(dumpcmd)
Add Comment
Please, Sign In to add comment