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 <machi...@rdc.co.za>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 > r...@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
