copy tables
| From: | Gronquist, Jim M | 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