A way to duplicate data across databases
| From: | Carsten Gehling | Date: | Sun, 11 Feb 2001 21:22:13 +0000 |
| Subject: | A way to duplicate data across databases | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-39144@lists.php.net to get a copy of this message | ||
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