MySQL Bugs: #22982: not able to restore stored procedures

Bug #22982	not able to restore stored procedures
Submitted:	4 Oct 2006 14:05	Modified:	5 Nov 2006 7:13
Reporter:	suman mehta	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server	Severity:	S1 (Critical)
Version:	5.0.22	OS:
Assigned to:		CPU Architecture:	Any

Description:
SQL server creates backupfile of the schema that contains stored procedures. But while restoring them it throws error and doesn't create stored procedures at target machine.

How to repeat:
1) Create a backup file of the schema that contains some stored procedure.
2) Restore it.
3) it throws following error.

Warning: Do not know how to handle this statement at line 30:
CREATE DEFINER=`root`@`localhost` PROCEDURE `sdf`()
BEGIN
 

END $$
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.

Suggested fix:
it should be able to restore stored procedures aswell.

sample file having a stored procedure

Attachment: aa 20061004 1933.sql (text/plain), 1.25 KiB.

one more

Attachment: suman (text/plain), 22.45 KiB.

changing severity

Please, try to repeat with a newer version of MySQL server, 5.0.24a, and use mysqldump/mysql command line tools to dump and restore, not MySQL Adminsitrator. Inform about the results.

Thanks..
I used mysqldump and mysql commands to dump and restore backup. with -R option I am able to restore stored procedures but it throws error and one of the stored procedures is not restored. 
ERROR 1074 (42000) at line 633: Column length too big for column '' (max = 21845
); use BLOB or TEXT instead

Please, send the exact statement that has that line 633 in it.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".