MySQL Forums
Forum List  »  Backup

mysqldump backup of event
Posted by: Kiyoka Takahashi
Date: November 06, 2018 08:38AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
mysqldump backup of event
191
November 06, 2018 08:38AM
110
November 06, 2018 12:20PM


Sorry, only registered users may post in this forum.

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.