Syncing and using a local server

  • Wuvu2

    (@wuvu2)


    9 years, 1 month ago

    Hello,
    I work at a small NGO in rural area of Thailand. We have created an internet site that is exclusively for our staff’s use – it requires a login to view the site.

    Our internal team site is hosted at Godaddy in the USA.

    Our internet connection is intermittent, so would like to place a copy of the site on our local network server which runs our printer.

    We do quite a bit of editing of web pages, so we need the local server and Godaddy server to remain synced automatically ( or as near to automatically as possible).

    IS there a method for this?
    Thanks,
    eb

Viewing 4 replies - 1 through 4 (of 4 total)
  • cheesedude

    (@cheesedude)

    9 years, 1 month ago

    First make sure your web host allows remote connections to MySQL. If it does, then you can use a program to synchronize your local database with your hosted database. MySQL Workbench might work or you could look at HeidiSQL or possibly other programs.

    http://dev.mysql.com/doc/workbench/en/wb-database-synchronization.html
    http://dev.mysql.com/doc/refman/5.5/en/replication-howto.html
    http://stackoverflow.com/questions/7707859/mysql-database-sync-between-two-databases

    Just search Yahoo for “synchronize mysql” or other similar search terms and you will find more information.

    Thread Starter Wuvu2

    (@wuvu2)

    9 years, 1 month ago

    Wow thanks! Can I bug you for a couple of follow ups – I’m a very fledgling at building a website.

    Am i understanding correctly first we make a clone on our local server, then sync the the database as in your posts?

    Would we have to do another clone restore if we modify plugins or php pages?

    Would basic edits to pages, new pages, and new posts all sync with the data base sync?

    Lastly – is the sync – two way – so that edits on the local and edits on the Godaddy would effect each other?

    Thank you SO much for the answer!

    Best regards,
    WH

    cheesedude

    (@cheesedude)

    9 years, 1 month ago

    Am i understanding correctly first we make a clone on our local server, then sync the the database as in your posts?

    You will have to read up on it. I know it can be done, but I have never done it. Sorry.

    Would we have to do another clone restore if we modify plugins or php pages?

    Anything that makes changes to the database will have to be synched. Modifying PHP code will not change anything in the database. Any changes you make through the admin panel such as activating plugins, themes, configuration changes, and such will change the database and require synching.

    Lastly – is the sync – two way – so that edits on the local and edits on the Godaddy would effect each other?

    I don’t know about that. There is nothing that GoDaddy has (or any post) that is going to push out data. Your program would probably query your GD database and see if any changes have been made and if so, synch that way.

    I would not expect it to be a minute by minute process. You will have to read up on it.

    Thread Starter Wuvu2

    (@wuvu2)

    9 years, 1 month ago

    Thank you sir. Very kind of you to be so helpful.
    best regards,
    wh

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Syncing and using a local server’ is closed to new replies.