Hi all,
I am currently having two databases that contains same data on two servers. One is a VPS and other one is a reseller account. So, what I want to do is,
Import updated rows in few tables from reseller's database and export them to vps's database via PHP. I can add a 'lastupdate' field to database1 and update it's value when any change has been made.
Import selected tables completely from reseller's db
As I am unable to use MySQL Replication on the reseller account, I am looking for run the above PHP via a cron.
Reason for asking this question:
- I am developing an advertising/publishing script.
- I am using the reseller's database as front-end database. So, advertisers and publishers are creating/editing on this database.
- I am using the vps's database as back-end database. So, it needs to contains most recent data.
- I am using backend database to run some high number of queries. (display ads, create real-time logs etc.)
- As these two are on different servers, it doesn't matter whether the back-end server is down or etc.
- And also it's easy to make changed to front-end or back-end as one is up.
Any help?
Thank you, pnm123