List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:November 30 2010 10:29am
Subject:Re: MySQL upgrade from 5.0.51a to 5.1.53
View as plain text  
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

Thread
MySQL upgrade from 5.0.51a to 5.1.53Machiel Richards30 Nov
  • Re: MySQL upgrade from 5.0.51a to 5.1.53Johan De Meersman30 Nov
    • Re: MySQL upgrade from 5.0.51a to 5.1.53Machiel Richards30 Nov
      • Re: MySQL upgrade from 5.0.51a to 5.1.53杨涛涛29 Dec
    • RESOLVED - Re: MySQL upgrade from 5.0.51a to 5.1.53Machiel Richards30 Nov