Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/usr/bin/python
- import MySQLdb as dbapi #MUST INTALL THE APT DEPENDENCY (sudo apt-get install python-mysqldb)
- import sys
- import csv
- dbServer='localhost' #SET HOST
- dbPass='supersecretpassword' #PASSWORD
- dbSchema='dbTest' #NAME OF THE DATABASE
- dbUser='root' #USERNAME
- dbQuery='SELECT * FROM pbTest.Orders;' #SET DATA TO EXFILTRATE
- db=dbapi.connect(host=dbServer,user=dbUser,passwd=dbPass) #INIT CONNECTION
- cur=db.cursor()
- cur.execute(dbQuery)
- result=cur.fetchall()
- c = csv.writer(open("ChangeMe.csv","wb")) #SET CSV FILE AND ITERATE THROUGH RESULTS
- for row in result:
- c.writerow(row)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement