Bug #54972 5.5.3 vs 5.5.0
Submitted: 2 Jul 2010 23:03 Modified: 7 Jul 2010 1:38
Reporter: Ashr Ben Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Backup Severity:S2 (Serious)
Version:5.5.3 OS:Any
Assigned to: CPU Architecture:Any

[2 Jul 2010 23:03] Ashr Ben
Description:
Deleted Stored procedures.

How to repeat:
Version 5.5.3 x64 windows 

ignored all my stored procedures. 

Verion 5.5.0 m2 works just fine.... with Mysql Admin backup.

Installed 5.5.3 m3, said corrupted Proc file. 

deleted .3 reinstall .0 worked fine.
[3 Jul 2010 9:29] Sveta Smirnova
Thank you for the report.

Please provide detailed instructions how to repeat the problem including which commands and with which options do you call.
[3 Jul 2010 9:45] Sveta Smirnova
> said corrupted Proc file. 

Did you run mysql_upgrade after installing version 5.5.3?
[3 Jul 2010 18:09] Ashr Ben
No. I didnt upgrade. 
I always delete old verion and install new. 

So, everything running fine. 
Downld .3.....
bakup mysql with admin. 
uninstall .0 m2.

install .3 m3 
(did this exact procedure for downgrade from 6. to 5.5.)
check stored proc = nothing.
Prob. noticed
restore with Mysql admin 
(get error)
run with errors.
prob still...
check again..
Stored procedure missing. 

unistall .3 
install .0 m2 
Stored procedure are shown.
No. restore with backup. not needed....
[5 Jul 2010 5:05] Sveta Smirnova
Thank you for the feedback.

> I always delete old verion and install new. 

Do you manually delete datadir too? Un-installer would not do it for you.
[6 Jul 2010 16:42] Ashr Ben
No, i did not delete my datafiles.
if datafiles means 

\Application Data\MySQL\MySQL Server 5.5\data

I left alone.
[6 Jul 2010 20:39] Sveta Smirnova
Thank you for the feedback.

This is not a bug in this case. You must run mysql_upgrade command when install new version over old data directory.
[7 Jul 2010 1:38] Ashr Ben
How do I do that: run update command.