copy tables

From: Date: Wed, 15 Oct 2003 13:08:08 +0000
Subject: copy tables
Groups: php.general 
Request: Send a blank email to php-general+get-166204@lists.php.net to get a copy of this message
I've set up dev and prod webservers. Users can go into the dev webserver content and edit it. The content is in a mysql database. I have a button on the webpage that says push content live. When the button is pushed I want it to run a php script that will copy the dev mysql table data into the prod mysql table. ex. mysql>select * from dev_faqs into outfile '/faqs/faqs.dat'; At this point I think that I would need to do loaddata in order to get the info from faqs.dat into the faqs.dat table. Any suggestions on how I actually implement this? Or is there a better way to do this? Thanks, Jim

« previous php.general (#166204) next »