MySQL upgrade from 5.0.51a to 5.1.53

--=-5892pBm+RBKW7jzrvuBU
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 7bit

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

--=-5892pBm+RBKW7jzrvuBU--

Re: MySQL upgrade from 5.0.51a to 5.1.53

--00032555136aeb82b7049642a9da
Content-Type: text/plain; charset=ISO-8859-1

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 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

--00032555136aeb82b7049642a9da--

Re: MySQL upgrade from 5.0.51a to 5.1.53

--=-qOPA1WwXANWYmpf1JBym
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 7bit

Hi

Thank you for the response, after reading a bit more about this, I
suspect you are right.

From what I can gather I need to do the following in order to use
this installation method:

- create a full backup of the old database and put in a safe
place.
- create a backup of the my.cnf file in a seperate directory
(in order to have access to the configuration to replicate details to
new database config).
- use package-manager (apt-get in this case) to remove current
version of MySQL that is running as well as all config files
and /etc/mysql dir
- setup new mysql version using the tar file
- start the new server and restore the backup.
- run mysql_upgrade in order to ensure all tables are well as
well as privilege tables.

Does this seem right to you guys?

Machiel

-----Original Message-----
From: Johan De Meersman
To: Machiel Richards
Cc: mysql mailing list
Subject: Re: MySQL upgrade from 5.0.51a to 5.1.53
Date: Tue, 30 Nov 2010 11:29:29 +0100

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
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

--=-qOPA1WwXANWYmpf1JBym--

RESOLVED - Re: MySQL upgrade from 5.0.51a to 5.1.53

--=-Kvbu+IXup2rqABQqcHRV
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 7bit

HI All

Just to let you know (if someone should be wondering)

I used the method below on a VM in order to test the methods of
upgrading before I do the actual systems.

I was able to do a successful upgrade with no errors as far as I
can see, using the method as described earlier.


Regards
Machiel

-----Original Message-----
From: Johan De Meersman
To: Machiel Richards
Cc: mysql mailing list
Subject: Re: MySQL upgrade from 5.0.51a to 5.1.53
Date: Tue, 30 Nov 2010 11:29:29 +0100

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
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

--=-Kvbu+IXup2rqABQqcHRV--

Re: MySQL upgrade from 5.0.51a to 5.1.53

--20cf3054a7cfa30351049886b1a8
Content-Type: text/plain; charset=UTF-8

Hi all,
I did a upgrade from 5.0 to 5.1 yesterday. And I paste some of my steps
on the following.
1. Use mysqldump to dump all the data to the disk.
2. Backup all the data including mysql system files to a safe place.
3. Remove all the file related to mysql.
4. Install the new 5.1 version.
5. Import the exist data into the new version.
I don't know whether the above is fit for you or not.

David Yeung, In China, Beijing.
My Msn: yueliangdao0608@gmail.com



2010/11/30 Machiel Richards

> Hi
>
> Thank you for the response, after reading a bit more about this, I
> suspect you are right.
>
> From what I can gather I need to do the following in order to use
> this installation method:
>
> - create a full backup of the old database and put in a safe
> place.
> - create a backup of the my.cnf file in a seperate directory
> (in order to have access to the configuration to replicate details to
> new database config).
> - use package-manager (apt-get in this case) to remove current
> version of MySQL that is running as well as all config files
> and /etc/mysql dir
> - setup new mysql version using the tar file
> - start the new server and restore the backup.
> - run mysql_upgrade in order to ensure all tables are well as
> well as privilege tables.
>
> Does this seem right to you guys?
>
> Machiel
>
> -----Original Message-----
> From: Johan De Meersman
> To: Machiel Richards
> Cc: mysql mailing list
> Subject: Re: MySQL upgrade from 5.0.51a to 5.1.53
> Date: Tue, 30 Nov 2010 11:29:29 +0100
>
> 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
> 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
>

--20cf3054a7cfa30351049886b1a8--