Bug #9493 Administrator backup does not save stored procedures
Submitted: 30 Mar 2005 16:53 Modified: 22 Jun 2005 15:36
Reporter: Paul van Rossem Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:5.0.3 beta OS:Windows (windows XP)
Assigned to: Vladimir Kolesnikov CPU Architecture:Any

[30 Mar 2005 16:53] Paul van Rossem 
Description:
The backup facility in Administrator does not save stored procedures when saving a database. Using InnoDB, server 5.0.3. beta and Administrator 1.0.19.

How to repeat:
Start Administrator. Select the Backup tab. Create new backup project and select a database. For InnoDB select "single transaction" as execution method. Excute backup and inspect file with text editor. There are no Create Stored Procedure statements defined in the file, hence the database backup is incomplete.

Suggested fix:
Add stored procedures and functions into the backup file.
[22 Jun 2005 15:36] Vladimir Kolesnikov 
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html
[6 Aug 2005 10:26] Paul van Rossem 
Not clear to me why this bug has been closed, it still exists in all new versions since 5.0.3B.