mysql_upgrade shows error

2006-10-21 Thread Yves Goergen
Hello,

I've just upgraded my MySQL server to version 5.0.26 and ran the
mysql_upgrade script with basedir, datadir, password and socket
arguments. The first time, I ran it, it listed a bunch of tables
(database.tablename) with an OK after them. In the end, it said:

ERROR 1060 (42S21) at line 22: Duplicate column name 'File_priv'

This is the only message it prints out when I run it again.

Does anybody know what that means? Is mysql_upgrade broken? Is a table
broken? Which one? Do I need to care about it?

My OS is Debian 3.1, I downloaded the glibc 2.3 linux max version of MySQL.

-- 
Yves Goergen LonelyPixel [EMAIL PROTECTED]
http://beta.unclassified.de – My web laboratory.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: mysql_upgrade shows error

2006-10-21 Thread Dan Buettner

Yves, my recollection is that I ran into this exact same error msg on
a recent 4.1 - 5.0 upgrade, and the bottom line is you don't need to
worry about it.  The 'File_priv' column exists as it should for 5.0.

Dan


On 10/21/06, Yves Goergen [EMAIL PROTECTED] wrote:

Hello,

I've just upgraded my MySQL server to version 5.0.26 and ran the
mysql_upgrade script with basedir, datadir, password and socket
arguments. The first time, I ran it, it listed a bunch of tables
(database.tablename) with an OK after them. In the end, it said:

ERROR 1060 (42S21) at line 22: Duplicate column name 'File_priv'

This is the only message it prints out when I run it again.

Does anybody know what that means? Is mysql_upgrade broken? Is a table
broken? Which one? Do I need to care about it?

My OS is Debian 3.1, I downloaded the glibc 2.3 linux max version of MySQL.

--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
http://beta.unclassified.de – My web laboratory.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]