Bug #97114 Schema transfere does not transfere events
Submitted: 6 Oct 2019 11:15 Modified: 17 Oct 2019 7:24
Reporter: Mato Otam Email Updates:
Status: Verified Impact on me:
Category:MySQL Workbench: Migration Severity:S3 (Non-critical)
Version:8.0.17, 8.0.18 OS:Windows (Microsoft Windows 10 Pro)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[6 Oct 2019 11:15] Mato Otam
Schema transfer does not transfer events from the source database to the target database. (both MySQL databases)
Source database version: MySQL 5.7.26 (Amazon RDS)
Target database version: 8.0.12 MySQL Community Server - GPL (Windows 10 64-bit)

How to repeat:
1. Top menu bar - Database
2. Schema transfer wizard
3. Source database - Amazon (MySQL 5.7.26)
4. Target database - Windows (MySQL 8.0.12 on localhost)
5.a) Pick schema which includes the event
5.b) Set true: Migrate MyISAM tables to InnoDB (not sure if it makes difference)
6. Start copy

Suggested fix:
Include events when migrating schemas trough the wizard between databases.
[17 Oct 2019 7:24] MySQL Verification Team
Hello Mato Otam,

Thank you for the report.
Verified as described.

Ashwini Patil