MySql Upgrade...Problem or Not ?

I'm already upgrade my mysql.But some error in ssh screen..

root [/rpmmysql]# rpm -Uvh MySQL-server-standard-4.1.16-0.rhel3.i386.rpm
warning: MySQL-server-standard-4.1.16-0.rhel3.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing... ########################################### [100%]
Giving mysqld a couple of seconds to exit nicely
1:MySQL-server-standard ########################################### [100%]
ERROR: 1064 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 '' at li ne 1
051215 18:03:49 [ERROR] Aborting
051215 18:03:49 [Note] /usr/sbin/mysqld: Shutdown complete
/usr/bin/mysql_install_db: line 299: 27954 Broken pipe cat $fill_help_tables

As I pointed out above:

USE THE GENERIC RPM FILES -- NOT THE RHEL ONES!

http://dev.mysql.com/downloads/mysql/4.1.html#Linux_x86_generic_RPM

Here is the result...

root [~]# rpm -qa grep MySQL

MySQL-client-4.1.16-0.glibc23
MySQL-embedded-4.1.16-0.glibc23
MySQL-devel-4.1.16-0.glibc23
MySQL-debuginfo-4.1.16-0.glibc23
MySQL-server-4.1.16-0.glibc23
perl-DBD-MySQL-2.1021-3
MySQL-Max-4.1.16-0.glibc23
MySQL-bench-4.1.16-0.glibc23
MySQL-shared-4.1.16-0.glibc23
It appears that you are already using the latest versions. :)

Although, the following are not necessary and I would remove them, by typing these commands:

rpm -e MySQL-embedded-4.1.16-0.glibc23
rpm -e MySQL-debuginfo-4.1.16-0.glibc23
rpm -e MySQL-Max-4.1.16-0.glibc23
rpm -e MySQL-bench-4.1.16-0.glibc23
rpm -e MySQL-shared-4.1.16-0.glibc23

Unless you have a specific need for them, but I doubt you do. Then just test your scripts that use MySQL and if they work, awesome! To be honest, I would do one last thing. I would repair your databases, just to make sure. The steps to do this are:

1. Shut down MySQL.
2. Change to the directory where your MySQL databases are stored.
3. Go into each database directory from there, and type myisamchk -r *.MYI as this will repair and optimize your tables. (It's much faster than anything else.)

I hope this helped. :)

I told you that was the right one to install...

Type this and paste the results here:

rpm -qa grep MySQL

I'm already download all packet

Server 4.1.16-0
Max 4.1.16-0
Benchmark/test suites 4.1.16-0
Client programs 4.1.16-0
Libraries and header files 4.1.16-0
Dynamic client libraries 4.1.16-0
Embedded server 4.1.16-0
Debug info 4.1.16-0

And same error,realy I'll be crazy :(

Giving mysqld a couple of seconds to exit nicely
1:MySQL-server-standard ########################################### [100%]
ERROR: 1064 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 '' at li ne 1
051215 18:03:49 [ERROR] Aborting
051215 18:03:49 [Note] /usr/sbin/mysqld: Shutdown complete
/usr/bin/mysql_install_db: line 299: 27954 Broken pipe cat $fill_help_tables

Where do I begin?

First of all, you don't need all of that. All you need is server (standard, not max), client, and devel.

I really hope you used my link to download these three things:
http://dev.mysql.com/downloads/mysql/4.1.html#Linux_x86_generic_RPM

I want you to show me me what you are typing to upgrade.

i.e. rpm -Uvh ..............................

Yes my server RHEL3 and cpanel etc.

Thanks

I tried this one today....

rpm -Uvh MySQL-server-4.1.16-0.glibc23.i386.rpm
warning: MySQL-server-4.1.16-0.glibc23.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing... ########################################### [100%]
package MySQL-server-4.1.16-0.glibc23 is already installed

It is already installed report.....Any idea ? Is it OK ?

This is mysql -V command result
mysql Ver 14.7 Distrib 4.1.16, for pc-linux-gnu (i686) using readline 4.3

This is mysql -v command result
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 1332167 to server version: 4.1.16-Max

And aslo vBulletin Admin screen report 4.1.16-Max

Before 4.1.13 to 4.1.15 no problem.But now problem :(

It has something to do with your table names, I believe. Make sure that your databases/tables don't contain any weird characters. It's not a problem with MySQL itself, it's something with the data, I believe.

If you can't figure it out, just backup all of your databases and try installing MySQL from scratch.

rpm -Uvh MySQL-server-standard-4.1.16-0.rhel3.i386.rpm --force

This should install the rpm forcefully without any dependencies.

Sorry for late answers :( But long holiday in Turkey ;)

Remove all that...

rpm -e MySQL-embedded-4.1.16-0.glibc23
rpm -e MySQL-debuginfo-4.1.16-0.glibc23
rpm -e MySQL-Max-4.1.16-0.glibc23
rpm -e MySQL-bench-4.1.16-0.glibc23
rpm -e MySQL-shared-4.1.16-0.glibc23

And after upgrade new mysql version...

New result is...

root [~]# rpm -qa grep MySQL
MySQL-shared-4.1.16-1.glibc23
MySQL-devel-4.1.16-1.glibc23
MySQL-client-4.1.16-1.glibc23
perl-DBD-MySQL-2.1021-3
MySQL-server-4.1.16-1.glibc23

I'm already reinstall MySQL-shared-4.1.16-1.glibc23 because cpanel is used that I think,because today failed mysql.

Is it OK ?

Thanks

Any idea for that ???

Are you using RedHat Enterprise Linux?

Because that is the MySQL version you have.

Try using the generic RPM:

http://dev.mysql.com/get/Downloads/MySQL-4.1/MySQL-server-4.1.16-0.glibc23.i386.rpm/from/pick

I tried this one today rpm -Uvh *.rpm

warning: MySQL-client-standard-4.1.16-0.rhel3.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
error: Failed dependencies:
libz.so.0 is needed by MySQL-shared-standard-4.1.16-0.rhel3
MySQL-client is needed by (installed) MySQL-bench-4.1.13-0
MySQL-devel is needed by (installed) MySQL-embedded-4.1.13-0

This is the latest result :)

Heheheh very interesting report

type mysql-v

Your MySQL connection id is 727118 to server version: 4.1.16-standard

type mysql -V

mysql Ver 14.7 Distrib 4.1.13, for pc-linux-gnu (i686) using readline 4.3

Any idea for difference ?

And same error again....

rpm -Uvh MySQL-server-standard-4.1.16-0.rhel3.i386.rpm --force
warning: MySQL-server-standard-4.1.16-0.rhel3.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing... ########################################### [100%]
Giving mysqld a couple of seconds to exit nicely
1:MySQL-server-standard ########################################### [100%]
ERROR: 1064 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 '' at line 1
051217 18:20:43 [ERROR] Aborting
051217 18:20:43 [Note] /usr/sbin/mysqld: Shutdown complete
/usr/bin/mysql_install_db: line 299: 24820 Broken pipe cat $fill_help_tables

#If you have any other info about this subject , Please add it free.#

17 March 2010 | cameltoepants.com | edit