> 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.
Couldn't you just use MySQL dump to dump it all out and suck it back in?...
Perhaps, after dumping it out once, you could find a way to script the
changes you need to the dumped file.
Another option -- I dunno about MySQL, but I think in PostgreSQL you could
maybe alter the database known as "template1". PostgreSQL pretty much just
copies that database to create a new one.
WARNING: I've never tried this. I don't know that this is a supported
feature of PostgreSQL. You should be very, very diligent and careful if you
try this.
--
Visit the Zend Store at http://www.zend.com/store/
Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm
Volunteer a little time: http://chatmusic.com/volunteer.htm
--
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]
