[thelist] copying a db tables to multiple servers

jft jft at worrigee.net
Mon Aug 11 08:21:20 CDT 2008


Jeremy.
What type/brand of database (MySQL, MSSQL etc) are the source database and the destination databases?
John
>  -------Original Message-------
>  From: Jeremy Weiss <eccentric.one at gmail.com>
>  Subject: [thelist] copying a db tables to multiple servers
>  Sent: 11 Aug '08 18:53
>  
>  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
>  
>  
>  --
>  
>  * * Please support the community that supports you.  * *
>  http://evolt.org/help_support_evolt/
>  
>  For unsubscribe and other options, including the Tip Harvester
>  and archives of thelist go to: http://lists.evolt.org
>  Workers of the Web, evolt !
>  



More information about the thelist mailing list