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
1404
November 06, 2018 08:38AM
606
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.