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

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