Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Sync'ing Databases

Options
  • 23-06-2008 12:11pm
    #1
    di11on
    Registered Users 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

  • Options
    #2
    di11on
    Registered Users 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?


  • Options
    #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