How to make a routine of sending certain data from one MySQL database to another

0

I'm a beginner and enthusiastic web developer.

I'm trying to develop a system that works basically like this: I have a registry of contacts, only running on localhost (PHP and MySQL) - because I need a system that works even when the machine by some chance is without internet.

I thought of doing a routine that works, for example, every 10min and sends only the new data to another database (sort of passing it to a MySQL DB on a same webhost). But to avoid data conflict (eg column id), it would send the variables to a form in PHP that would pass this data to the second MySQL database.

I was able to find ways that would work to send the MySQL database by email, but nothing to another host.

I could do this using PHP, I saw something about Cron Job. Does anyone have any north of what I should research and study strictly to develop this code?

    
asked by anonymous 10.10.2017 / 21:13

0 answers