echo off
echo Backing up Database....
"/prog/util/mysqldump" -u cfaw -pcfaw --compress --add-drop-table --extended-insert gooscrape > c:/temp/gooscrape.sql
echo Compressing Database....
"/prog/util/bzip2" -f9 c:/temp/gooscrape.sql
echo Done! Please upload file: c:\temp\gooscrape.sql.bz2 to cfaw.info
pause
------------------------------------------------------
# backup and compress MySQL database
import os
import datetime

mysqldump='/prog/util/mysqldump'
bzip2='/prog/util/bzip2'
db = 'gooscrape'
tempdir='c:/temp'
backupfile=tempdir + '/' + db + str(datetime.date.today()) + '.sql'
dbuser='lschultz'

#first get rid of old files
for root, dirs, files in os.walk(tempdir):
    for name in files:
        #print 'checking ' + os.path.join(root,name)
        if name.startswith(db):
            #print 'removing ' + os.path.join(root,name)
            os.remove(os.path.join(root,name))
           
dbpw=raw_input('Please enter the password for the user <' + dbuser + '> :')

print 'Backing up Database....'
status=os.system(mysqldump+' -u '+dbuser+' -p'+dbpw+' --compress --add-drop-table --extended-insert '+db+' >'+backupfile)
if status != 0:
  raw_input('Database backup failed. Program aborted. Press enter to quit.')
  exit()
else:
  print 'Done!'
print 'Compressing Database....'
status=os.system(bzip2+' -f9 '+backupfile)
if status != 0:
  raw_input('Database compression failed. Program aborted. Press enter to quit.')
  exit()
else:
  print 'Done!'
print 'Please upload file: '+backupfile+'.bz2 to cfaw.info'
raw_input('press enter to continue...')