Bug #21682 CR char missing from Stored Proc dump
Submitted: 16 Aug 2006 23:19 Modified: 28 Aug 2006 22:47
Reporter: Jared S (Silver Quality Contributor) Email Updates:
Status: Closed Impact on me:
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:24.NT OS:Windows (WinXP)
Assigned to: CPU Architecture:Any
Tags: adminstrator, cr, dump, export, sql file, stored proc

[16 Aug 2006 23:19] Jared S
Using Administrator 1.2.1 on a MySQL database 2.0.24-community-nt. 

With a database that has at least 2 Stored Procs, the backup will not include CR's characters after 'begin' and 'end' for every stored procedure axcept the first.

How to repeat:
Create DB with 3 Stored procs.

Backup using Administrator.

Import file into QB to see that BEGIN and END statements have been 'merged' with following line of text.

Suggested fix:
Correct issue to ensure that DB SP's are exported in acceptable manner.
[17 Aug 2006 8:00] Sveta Smirnova
Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

I can not repeat it usin MySQL Administrator 1.2.1. Text editor shows CR chars in the dump
[21 Aug 2006 23:26] Jared S
Thats cool, have just download latest GUI tools and I cant repeat either.
[24 Aug 2006 0:48] Jared S
Probelm is now even worse, where CRs are missing form end of line;

i.e My stored procs look like this after dumped

[24 Aug 2006 0:49] Jared S
Could you please try to re create error using Administrator 1.2.2 beta
[24 Aug 2006 8:15] Sveta Smirnova
I still can not repeat it with my test data.

Could you please provide dump of your database with 3 stored procedures. Also indicate how you created these stored procedures: using MySQL Administrator, by typing SQL in mysql command client or using other method?
[28 Aug 2006 22:47] Jared S
Probelm has disapeared again.  I guess this bug can be closed as it works fine on 2 computers for me now.