[thelist] copying a db tables to multiple servers

[Jeremy Weiss]

I need to pull data from one database and upload it to others. However, I'll need to create the tables before I can insert the data and I'm not sure how to get the information from the primary database needed to create the table on the other servers. I've been playing with "SHOW COLUMNS FROM tablename" but this doesn't appear to be giving me the indexes, collation. So, I guess what I'm asking is, what's the easiest way, in PHP 5, to grab the structure of a table from a database on one server and use it to create the needed table in another database on another server?

thanks,
-jeremy