Kurobyte

Kurobyte / table-split.py

Last active December 13, 2015 03:30 — forked from stuartloxton/table-split.py

Split PHPMyAdmin export into individual tables.

	import sys, re

	f = open(sys.argv[1])
	files = f.read().split('-- --------------------------------------------------------')
	files.pop(0)

	for file in files:
	table = re.search('-- .\`(.)\`\n--', file).group(1) #Get table name
	f = open('./' + table + '.sql', 'w')
	f.write(file)