Import/Export updated rows in MySQL database via PHP

leroreast

New Member
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 dbAs 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
 
Back
Top