How can I sync a database driven website to a different server
        Posted  
        
            by tbrandao
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by tbrandao
        
        
        
        Published on 2010-04-02T14:23:08Z
        Indexed on 
            2010/04/02
            15:03 UTC
        
        
        Read the original article
        Hit count: 301
        
I have a website using cPanel on a dedicated account, I would like to be able to automatically sync the website to a second hosting company or perhaps to a local (in house ) server.
Basically this is a type of replication. The website is database driven (MySQL), so Ideally it would sync everything (content, database, emails etc.) , but most importantly is syncing the website files and its database.
I'm not so much looking for a fail-over solution as an automatic replication solution, so if the primary site (Server) goes off-line, I can manually bring up the replicated site quickly.
I'm familiar with tools like unison and rsync, but most of these only sync file(s) and do not do too well with open database connections.
© Stack Overflow or respective owner