A way to duplicate data across databases

From: 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

« previous php.general (#39144) next »