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]