I suspect you need to have the new version running instead of the old one,
for the mysql_upgrade script to work.
On Tue, Nov 30, 2010 at 11:23 AM, Machiel Richards <machielr@stripped>wrote:
> HI Guys
>
> I found some info regarding a method to upgrade mysql databases.
>
> Currently the version is at mysql-5.0.51a (as installed via the
> ubuntu-8.0.4 respository).
>
> I downloaded the only version available from the web (5.1.53)
> that will work on ubuntu [except for source]. This is the binary package
> that need to be untarred into a directory and then the database to be
> initialized.
>
> The option was was looking at was to do the following (according
> to some reccomendations)
>
>
> - untar new version into seperate directory.
> - keep the current version running.
> - cd to /path/to/new/directory/bin
> - ./mysql_upgrade -u root -p
>
>
> Running this I get a couple of errors / warnings though and
> I am hoping that someone can provide me with some answers or otherwise a
> better way to do the upgrade.
>
>
> Errors received:
>
>
> Enter password:
> Looking for 'mysql' as: ./mysql
> Looking for 'mysqlcheck' as: ./mysqlcheck
> Running 'mysqlcheck' with connection arguments: '--port=3306'
> '--socket=/var/run/mysqld/mysqld.sock'
> Running 'mysqlcheck' with connection arguments: '--port=3306'
> '--socket=/var/run/mysqld/mysqld.sock'
> machiel.test1 OK
> machiel.test2 OK
> mysql.columns_priv OK
> mysql.db OK
> mysql.event OK
> mysql.func OK
> mysql.help_category OK
> mysql.help_keyword OK
> mysql.help_relation OK
> mysql.help_topic OK
> mysql.host OK
> mysql.ndb_binlog_index OK
> mysql.plugin OK
> mysql.proc OK
> mysql.procs_priv OK
> mysql.servers OK
> mysql.tables_priv OK
> mysql.time_zone OK
> mysql.time_zone_leap_second OK
> mysql.time_zone_name OK
> mysql.time_zone_transition OK
> mysql.time_zone_transition_type OK
> mysql.user OK
> Running 'mysql_fix_privilege_tables'...
> ERROR 1193 (HY000) at line 69: Unknown system variable 'have_csv'
> ERROR 1064 (42000) at line 71: You have an error in your SQL syntax;
> check the manual that corresponds to your MySQL server version for the
> right syntax to use near 'NULL' at line 1
> ERROR 1243 (HY000) at line 72: Unknown prepared statement handler (stmt)
> given to EXECUTE
> ERROR 1243 (HY000) at line 73: Unknown prepared statement handler (stmt)
> given to DEALLOCATE PREPARE
> ERROR 1193 (HY000) at line 77: Unknown system variable 'have_csv'
> ERROR 1064 (42000) at line 79: You have an error in your SQL syntax;
> check the manual that corresponds to your MySQL server version for the
> right syntax to use near 'NULL' at line 1
> ERROR 1243 (HY000) at line 80: Unknown prepared statement handler (stmt)
> given to EXECUTE
> ERROR 1243 (HY000) at line 81: Unknown prepared statement handler (stmt)
> given to DEALLOCATE PREPARE
> ERROR 1193 (HY000) at line 309: Unknown system variable 'general_log'
> ERROR 1193 (HY000) at line 310: Unknown system variable 'general_log'
> ERROR 1146 (42S02) at line 311: Table 'mysql.general_log' doesn't exist
> ERROR 1193 (HY000) at line 318: Unknown system variable 'general_log'
> ERROR 1193 (HY000) at line 320: Unknown system variable 'slow_query_log'
> ERROR 1193 (HY000) at line 321: Unknown system variable 'slow_query_log'
> ERROR 1146 (42S02) at line 322: Table 'mysql.slow_log' doesn't exist
> ERROR 1193 (HY000) at line 334: Unknown system variable 'slow_query_log'
> ERROR 1305 (42000) at line 522: FUNCTION mysql.CONCAT does not exist
> ERROR 1305 (42000) at line 537: FUNCTION mysql.CONCAT does not exist
> ERROR 1305 (42000) at line 552: FUNCTION mysql.CONCAT does not exist
> FATAL ERROR: Upgrade failed
> root@machielr-laptop:/usr/local/mysql/bin#
>
>
>
> Regards
> Machiel
>
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
