Bug #59339 after upgraded to 5.5.8 , ran mysql_upgrade, got FATAL ERROR: Upgrade failed
| Submitted: | 6 Jan 2011 20:11 | Modified: | 6 Jan 2011 21:47 |
|---|---|---|---|
| Reporter: | steven tang | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Server | Severity: | S1 (Critical) |
| Version: | MySQL 5.5.8 | OS: | Linux (mysqlcheck: unknown option '--fix-db-names') |
| Assigned to: | CPU Architecture: | Any |
[6 Jan 2011 20:11]
steven tang
[6 Jan 2011 20:43]
Valeriy Kravchuk
Are you sure that mysql_upgrade from proper version, 5.5.8, is called? Please, send the results of: which mysql_upgrade Linux command.
[6 Jan 2011 20:48]
steven tang
[root@dev80 data]# which mysql_upgrade /usr/local/mysql/bin/mysql_upgrade [root@dev80 data]# mysql_upgrade --help mysql_upgrade Ver 1.1 Distrib 5.5.8, for linux2.6 (x86_64) Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. MySQL utility for upgrading databases to new MySQL versions.
[6 Jan 2011 20:59]
Valeriy Kravchuk
Please, send the results of: mysqlcheck --version
[6 Jan 2011 21:10]
steven tang
Found the problem: in somehow under /usr/bin/, there also some mysql stuff: [root@dev80 bin]# pwd /usr/bin [root@dev80 bin]# dir mysql* -rwxr-xr-x 1 root root 314568 May 27 2010 mysql* -rwxr-xr-x 1 root root 110776 May 27 2010 mysqlaccess* -rwxr-xr-x 1 root root 35144 May 27 2010 mysqladmin* -rwxr-xr-x 1 root root 112944 May 27 2010 mysqlbinlog* -rwxr-xr-x 1 root root 30576 May 27 2010 mysqlcheck* -rwxr-xr-x 1 root root 7632 May 27 2010 mysql_config* -rwxr-xr-x 1 root root 75184 May 27 2010 mysqldump* -rwxr-xr-x 1 root root 3245 May 27 2010 mysql_find_rows* -rwxr-xr-x 1 root root 26160 May 27 2010 mysqlimport* -rwxr-xr-x 1 root root 28224 May 27 2010 mysqlshow* -rwxr-xr-x 1 root root 14473 May 27 2010 mysql_tableinfo* -rwxr-xr-x 1 root root 112136 May 27 2010 mysql_waitpid* [root@dev80 bin]# del mysql* Now the mysql_upgrade has been run properly. [root@dev80 bin]# mysql_upgrade -hdev80 -p<p> Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck Running 'mysqlcheck' with connection arguments: '--host=dev80' Running 'mysqlcheck' with connection arguments: '--host=dev80' mysql.columns_priv OK mysql.db OK ... Thanks, Steven
[6 Jan 2011 21:47]
Valeriy Kravchuk
Good news. The problem was, probably, not a result of any bug in 5.5.8...
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.040 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.