Advertisement
Guest User

Untitled

a guest
Oct 30th, 2018
201
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.49 KB | None | 0 0
  1. import os
  2. import time
  3. import datetime
  4.  
  5. DB_HOST = 'kkkk.mysql.pythonanywhere-services.com'
  6. DB_USER = 'kkkk'
  7. DB_USER_PASSWORD = 'kkkk'
  8. DB_NAME = '$leandrojuazeiro$banco2'
  9. PASTA= time.strftime('%Y%m')
  10. BACKUP_PATH = 'tmp/'+ PASTA
  11. DATETIME = time.strftime('%Y%m%d-%H%M%S')
  12.  
  13. if not os.path.exists(BACKUP_PATH):
  14.     os.makedirs(BACKUP_PATH)
  15.  
  16. db = DB_NAME
  17. dumpcmd = "mysqldump -u " + DB_USER + " -p" + DB_USER_PASSWORD + " " + db + " > " + BACKUP_PATH  + '/' + DATETIME + ".sql"
  18. os.system(dumpcmd)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement