List:General Discussion« Previous MessageNext Message »
From:Yves Goergen Date:February 10 2007 4:39pm
Subject:mysql_upgrade shows errors
View as plain text  

I noticed that the current MySQL 5.0 release is not available as binary,
so I downloaded the source and compiled it on my testing machine.
Compilation went fine and I can connect to the new MySQL server version.
But then I tried to run the mysql_upgrade script to fix possible issues
and here's what it gave me:

ERROR 1060 (42S21) at line 22: Duplicate column name 'File_priv'
ERROR 1060 (42S21) at line 28: Duplicate column name 'Grant_priv'
ERROR 1060 (42S21) at line 29: Duplicate column name 'Grant_priv'
ERROR 1060 (42S21) at line 30: Duplicate column name 'Grant_priv'
ERROR 1060 (42S21) at line 41: Duplicate column name 'ssl_type'
ERROR 1061 (42000) at line 66: Duplicate key name 'Grantor'
ERROR 1054 (42S22) at line 102: Unknown column 'Type' in 'columns_priv'
ERROR 1060 (42S21) at line 124: Duplicate column name 'type'

(and some more similar stuff)

I tried it twice. At the first time, all other tables had an "OK"
besides them, at the second time, those lines didn't show up anymore.

MySQL server is version 5.0.33, OS is Debian Linux 3.1, previous MySQL
version was 5.0.17, installed from the binary release.

What do the above error messages mean?

Yves Goergen "LonelyPixel" <nospam.list@stripped>
Visit my web laboratory at
mysql_upgrade shows errorsYves Goergen10 Feb
  • Re: mysql_upgrade shows errorsYves Goergen11 Feb
  • Re: mysql_upgrade shows errorsColin Charles14 Feb
    • Re: mysql_upgrade shows errorsYves Goergen14 Feb
      • Re: mysql_upgrade shows errorsColin Charles15 Feb