Bug #33224 Events not exported

• Submitted: 13 Dec 2007 17:35
• Modified: 14 Dec 2007 22:48
• Reporter: Ziyod Abdullayev
• Status: Not a Bug
• Category: MySQL Server: Backup
• Severity: S3 (Non-critical)
• Version: 5.1.22
• OS: Any
• CPU Architecture: Any
• Tags: Backup/Restore

[13 Dec 2007 17:35] Ziyod Abdullayev

Description:
Exporting a database using mysqldump or MySQL Administrator tool doesn't generate a CREATE EVENT command inside of a DDL file.

How to repeat:
Backup a database using mysqldump --user=root --password=1111 db_name > backup.sql
or use MySQL Administrator to backup the database. Inspect the backup.sql file for CREATE EVENT.

[14 Dec 2007 17:39] Sveta Smirnova

Thank you for the report.

Have you specified --events option for mysqldump?

[14 Dec 2007 22:26] Ziyod Abdullayev

No I haven't. Can you give me an example? What about in the case of the MySQL Administrator 5.0?

[14 Dec 2007 22:48] Sveta Smirnova

Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Details of using mysqldump are at http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html. MySQL Administrator is specially designed for version 5.0, so feel free to create feature request for MySQL Administrator