mysqldump backup of event
Hello,
I took a backup of a database using mysqldump I noticed "event" was not in the dump file. How do I include every objects to backup using mysqldump?
Source: MySQL on Windows 5.7.24-log community
mysqldump -uroot -pxxxxx mt > D:\MySQLBackupHome\mt20181102.sql
Event was created as:
delimiter |
CREATE EVENT LoadMassTransitEvent
ON SCHEDULE EVERY '1' DAY
STARTS '2018-10-30 1:25:00'
DO BEGIN
insert into mtdatabase.masstransitlog_all
(select * from `mtdatabase`.`mt10_ma-view`
where log_time_stamp >= subdate(CURDATE(), 1)
and log_time_stamp < CURDATE());
insert into mtdatabase.masstransitlog_all
(select * from `mtdatabase`.`mt20_ma-view`
where log_time_stamp >= subdate(CURDATE(), 1)
and log_time_stamp < CURDATE());
insert into mtdatabase.masstransitlog_all
(select * from `mtdatabase`.`mtwp01_ma-view`
where log_time_stamp >= subdate(CURDATE(), 1)
and log_time_stamp < CURDATE());
END|
delimiter ;
Thanks in advance!
KT
Subject
Views
Written By
Posted
mysqldump backup of event
1390
November 06, 2018 08:38AM
602
November 06, 2018 12:20PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.