How to determine where a program stores data in a MySQL database

Question

I have a commercial program that takes input from a delimited text file and stores that data in a MySQL database. I am writing a Perl script that essentially removes the need for the commercial program and uploads the data directly to the database. However, I am unsure in which tables the commercial program stores all the data. There are several hundred tables in this database, so I need a tool that can crawl through the database for me and map where the data goes. Is anyone aware of a tool (Perl or otherwise) that can help?

Answer 1

You can always just look at the general query log to figure out what the commercial app is doing.

This log will show all the connections it makes as well as the sql it is executing.

Answer 2

Indiguy, use the MySQL Query Profiler and run the commercial program. Then, it's just a mather of looking what the profiler logged on and then replicate on your perl program :)

http://dev.mysql.com/tech-resources/articles/using-new-query-profiler.html