Home > Mac, Technology > MacPorts: MySQL upgrade from 5.0.x to 5.1.x gives error during insert ( mysql_upgrade / ERROR 1558 (HY000) )

MacPorts: MySQL upgrade from 5.0.x to 5.1.x gives error during insert ( mysql_upgrade / ERROR 1558 (HY000) )

January 5th, 2010
Skip to Comments

Yesterday I upgraded my mysql from 5.0.x to 5.1.x. After upgrade inserts started to fail with this error:

ERROR 1558 (HY000) at line 146: Column count of mysql.proc is wrong. Expected 20, found 16. Created with MySQL 50067, now running 50142. Please use mysql_upgrade to fix this error.

After little bit of google I found this solution. You need to run following command.

sudo  /opt/local/lib/mysql5/bin/mysql_upgrade -uroot -p –basedir=/opt/local/lib/mysql5/bin/mysql

This fixed my db issues. Hope this helps…

Mac, Technology , , ,
«
»
Comments ( 3 )
Feed for this Entry Trackback Leave a comment
  1. fleeforum Jan 8th, 2010 @ 09:36 | #1
    Reply Quote

    Thanks, dont understand why it had to show that error.. Been upgrading mysql for years, 5.0 to 5.1 wasnt that great for me.

    But thank you for posting the solution.

  2. Prasad Pednekar Jan 29th, 2010 @ 20:12 | #2
    Reply Quote

    Thanks a ton… helped me in upgrade of MySQl 5.1.35 to 5.1.42 .

  3. Geoff Knauth Jan 18th, 2012 @ 17:12 | #3
    Reply Quote

    Thank you very much. MySQL hit me with this error (of course) when I was in a rush to get a quick result out, so your post was a lifesaver.

Submitting Comment, Give me a second...

Leave a comment

Allowed tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>
Trackbacks & Pingbacks ( 0 )
Toggle the list
  1. No trackbacks yet.