Done is better then perfect – sometimes even true in the PHP environment, e.g.: dealing with statistics when a raw calculation can be enough or just not as painful as eating all of the memory.
I write this post because I didn’t find perfect match to our svn exporting needs. Eventually performs an svn export only on changed files. Time to tome the php frameworks grows bigger and bigger – I had an unfortunate question here – well if I would like to use these nice frameworks and I don’t want to give up using subversion, the full export to the production environment is no longer acceptable. More
We run some LAMP server mostly on EC2 infrastructure. Considering the servers in different locations and environments there are no unified automate service for backpacking Mysql databases into separate files. And the other hand we don’t want to regular backup handle the fat archive tables.
So what we need is a mysql backup solution, probably a bash script what makes separate files per each db and ignores archive and memory engines of course with possibilities of gzipping.