Bug #14435 mysqldump --routines produces corrupted Proc table
Submitted: 28 Oct 2005 18:51 Modified: 30 Nov 2005 22:26
Reporter: philip antoniades Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: mysqldump Command-line Client Severity:S2 (Serious)
Version:5.0.15 OS:Linux (Linux)
Assigned to: CPU Architecture:Any

[28 Oct 2005 18:51] philip antoniades
Description:
I dumped a database from RHAS 3.0 (MySQL 5.0.15) using mysqldump --routines and loaded it into the same release on SUSE 10. Trying to call or drop a procedure gives these results:

mysql> drop procedure comp_cache_upd;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*/' at line 860
mysql> call comp_cache_upd();
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*/' at line 860

Oddly, it does not even catch that I am sending the wrong number of parameters. 

How to repeat:
I can give you the dump file.
[31 Oct 2005 16:22] Patrick Galbraith
Philip,

Please send the dump file ;)
[31 Oct 2005 22:24] Jorge del Conde
Hey Philip,

Can you please upload a copy of your dumpfile ?

Thanks!
[1 Dec 2005 0:00] Bugs System
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".