Script to export MySQL tables to csv

Larry Bates larry.bates at websafe.com
Thu Nov 10 08:49:54 EST 2005


Jandre wrote:
> To anyone that can help
> 
> I have 2 MySQL databases that contain large amounts of tables. I need
> to be able to compare the data in the tables with older/newer versions
> of the tables. I figured the easiest way would be to get the info in
> csv format and then run a comparison. I can get all the data using
> MySQL front, but this has to be done tabe-by-table, and is too time
> consuming.
> 
> I am new to Python and also new to programming.
> Can anyone please help.
> 
> Thanks
> Jandre
> 
I recently had a need to do exactly what you are describing and
found this product to fit the bill nicely.

http://www.apexsql.com/sql_tools_diff.asp

Sometimes I find it better to buy than to write ;-).

Larry Bates



More information about the Python-list mailing list