MySQL Bugs: #29872: Stored Procedures and Functions doesn't show up in 'Backup Content'

Bug #29872	Stored Procedures and Functions doesn't show up in 'Backup Content'
Submitted:	18 Jul 2007 16:02	Modified:	26 May 2009 11:56
Reporter:	Jarod McKnight	Email Updates:
Status:	Unsupported	Impact on me:	None
Category:	MySQL Administrator	Severity:	S2 (Serious)
Version:	1.2.12 and 1.2.7ga	OS:	MacOS (v 10.4.10, Intel Core 2 Duo)
Assigned to:		CPU Architecture:	Any
Tags:	Backup, functions, stored procedures

Description:
Hi, 
I used MySQL Administrator under Linux and Windows for nearly two 2 years, and switched to Mac OS (v10.4.10) a week ago. 
I downloaded the newest Mysql gui tools (5.0-r12) [EDIT: version 5.0-r7 has the same Problem], but I have a problem with the Administrator. If I want to Backup a schema with stored functions and procedures, the functions and procedures doesn't show up in the 'Backup Content' panel. The only way to get them saved with the Administrator is to choose 'Backup Selected Schema Completly' under Advanced Options. If I go into the 'Catalogs' view and choose 'Stored Procedures' or 'Functions' they show up, and I am shure, the last time I used the Administrator under Linux they showed up in the 'Backup Content' Panel of the 'Backup' view, too.

How to repeat:
Make a schema with a stored function oder procedure. Open the mysql administrator and go to backup. Select the schema, expand it in the 'Backup content' View. The functions and procedures should be at the end of the list, after the tables, but they are not. If you want to backup them, go to 'Advanced Options' and select 'Backup Selected Schema Completely', which includes them in the backup.

Thank you for the report.

Verified as described.

Non-repo InnoDB SPs backing up OK in Administrator 1.2.12.

Many thanks for writing a bug report. We are on the way to implement full functionality of MySQL Administrator into MySQL Workbench. Unfortunately you are using an unsupported platform. More informations about supported platforms you will find here:

http://www.mysql.com/support/supportedplatforms/tools.html

More informations about MySQL Workbench you will find here:

http://dev.mysql.com/workbench/

Recently MySQL enabled "Full Bakup" by default.