[thelist] copying a db tables to multiple servers

Jeremy Weiss eccentric.one at gmail.com
Mon Aug 11 03:53:59 CDT 2008

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?


More information about the thelist mailing list