generate json dump from mysqldump

mysqldump2json.py

#!/usr/bin/python
import fileinput
import json
output = {}
for line in fileinput.input():
    if line.startswith('CREATE TABLE'):
        table = line.split('`')[1]
    if line.startswith('  `'):
        if not table in output: output[table] = {}
        s = line[2:].split('`')
        output[table][s[1]] = s[2][:-2]
print json.dumps(output)