The company I work for uses two servers DEV and PROD to host its sites. DEV is obviously where we do all of our work, and PROD is where we host live sites for clients.
On DEV we have created a deployment app that is used to create new sites and perform a few other administrative tasks. Right now I am looking into a way to transfer sites easily from DEV to PROD using a PHP script to perform the whole process. Things that I need to transfer over include:
- The PHP Files
- The Sites SVN Project
- MySQL Database
I had already coded a solution which exports a site from DEV by: compressing the desired site, dumping the database to file and then FTPing them through PHP to PROD. From that point I have to connect to PROD and run another script which decompresses the file, imports the database, and adds the project to PROD's SVN.
My boss didn't like that you had to log onto PROD, he wants it all done with the click of one button.
Does anybody have any wisdom to offer? What's the simplest way I can do this with the click of a button?