# created a dumpfile from my mysql db # and found that it was too large to # upload to my new db host. # this python script breaks up the database # into smaller pieces that you can more # easily import through phpmyadmin # (if I'd only had shell access I wouldn't # have this problem at all!) # indicates a new table is about to be # created dlmtr = "-- Table structure for table" wholeFile = open("myDBDump.sql") fileN = 0 oFile = open(str(fileN) + ".sql", 'w') reducing = True for line in wholeFile: if line.find(dlmtr) > -1: # this is the seam for the next file print "starting new file" oFile.close() fileN += 1 oFile = open(str(fileN) + ".sql", 'w') oFile.write(line) oFile.close() print "Done"
A python example based blog that shows how to accomplish python goals and how to correct python errors.
Tuesday, October 27, 2009
Python - break a large mysql dump into small dumps
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment