Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Sync'ing Databases

  • 23-06-2008 12:11PM
    #1
    di11on
    Registered Users, Registered Users 2 Posts: 1,262 ✭✭✭


    Hey folks,

    What is the best way of syncronising two different databases which are with the same hosting provider but have different hosting accounts. I'm assuming they are sitting on different machines.

    Is this possible to do via cron jobs. I have one database automatically create a script every night and a cron job set up on the other scheduled to pick it up?

    Is there an easier way?

    Would be grateful for any suggestions!


Comments

  • #2
    di11on
    Registered Users, Registered Users 2 Posts: 1,262 ✭✭✭di11on


    Anyone, is it possible to create a MySQL triggers to alter a table on one database as a result of an action on another database?


  • #3
    Yerac
    Closed Accounts Posts: 235 ✭✭Yerac


    Well a generic kind of overview would be to export from the main database every night and import into the "backup" after that.

    e.g. export from database A and then transfer (FTP) the output file to the second server where a second cron job runs. That cron would then import the transferred file into database B.


Advertisement