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
