[thelist] copying a db tables to multiple servers

[Jeremy Weiss]

Rudy replied..
> have you tried mysqldump?

No, I wasn't sure if I could do that from within a PHP script.

Jeffrey replied...
> AFAIK, the SHOW CREATE TABLE SQL statement is the easiest way:
><http://dev.mysql.com/doc/refman/5.0/en/show-create-table.html>

Very interesting, Jeffrey. I figured there was a command that I wasn't finding.

John replied...
> What type/brand of database (MySQL, MSSQL etc) are the source database and the destination databases?

All the db's involved are MySQL 5


Thanks,
-jeremy