Processing a MySQL Dump file with Python

[Nico Grubert]

Hi there,

I need to parse a textfile (~400 MByte) which represents a complete
MySQL dump (including table definitions and data records) .
How can I process a MySQL dump file with python? Is there any Python
module that can parse MySQL dump files -- or
can I somehow call the MySQL interpreter in background to pass the dump
file to it so the SQL Dump is imported in order
to write the tables and data into the MySQL database?

Thanks in advance,
Nico

 

[Jeffrey Froman]

can I somehow call the MySQL interpreter in background to pass the dump
file to it so the SQL Dump is imported in order
to write the tables and data into the MySQL database?

Sure, that's what dump files are good for. Simply pipe the contents of the
file into a mysql command. On a Unix-type system (maybe Windows too, I
wouldn't know) you'd run something like:

mysql -h myhost.com -p -u myusername < dumpfile

MySQL does all this by itself, no Python required.

Hope that helps,
Jeffrey