you should be able to query the structure of the database in php/mysql. this
should then give you everything you need to build your create table
statement dynamically so you can build a black-box function that takes
source and target databases and table name. You can proably find the tables
in a database so your function becomes one call database copier.
Tim Ward
Senior Systems Engineer
Please refer to the following disclaimer in respect of this message:
http://www.stivesdirect.com/e-mail-disclaimer.html
> -----Original Message-----
> From: Carsten Gehling [mailto:[EMAIL PROTECTED]]
> Sent: 11 February 2001 21:22
> To: [EMAIL PROTECTED]
> Subject: A way to duplicate data across databases
>
>
> I'm making a script that generates test sites usíng dummy
> data stored in one
> MySql database ("uwebsitebase")
>
> Now, using php-scripting, I'm copying these data to a demo-database
> ("uwebdemo"). The structure is the same - the same tables
> with the same
> fields. Only difference will be that the copied data should
> get new primary
> keys which are auto-incremented. No problem there.
>
> However, the process is tedious. I have tables that contains
> some 30 fields
> and it's just a bore selecting all fields from one table, and
> then writing a
> complete insert statement with all the fields except the PK.
>
> Is there an easier way? Remember 1) It's PHP 2) It's across databases.
>
> I have to script it, since I need the new keys on other places.
>
> - Carsten
>
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
