Create even that updates tables/db every 5 minutes

[Marcus Dardy]

I want to create an event that runs every 5 minutes updates all of the tables in one server and updates them to another server. Is this possible? I currently have to export by creating to a self-contained file from one server and import that file into the other server.

Here is the script I have so far:

DELIMITER $$

DROP EVENT IF EXISTS run_event $$

CREATE DEFINER=`root`@`%`
EVENT `run_event`
ON SCHEDULE EVERY 5 MINUTE STARTS '2018-04-04 00:00:00'
ON COMPLETION NOT PRESERVE ENABLE
DO
BEGIN
SIGNAL SQLSTATE '01000' SET MESSAGE_TEXT = 'run_event started';
CALL my_db;
SIGNAL SQLSTATE '01000' SET MESSAGE_TEXT = 'run_event finished';
END $$