Bug #97114 Schema transfere does not transfere events

• Submitted: 6 Oct 2019 11:15
• Modified: 17 Oct 2019 7:24
• Reporter: Mato Otam
• Status: Verified
• Category: MySQL Workbench: Migration
• Severity: S3 (Non-critical)
• Version: 8.0.17, 8.0.18
• OS: Windows (Microsoft Windows 10 Pro)
• CPU Architecture: Any
• Tags: WBBugReporter

[6 Oct 2019 11:15] Mato Otam

Description:
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.

Regards,
Ashwini Patil