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: | |
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
[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.