MySQL 5.0.37

Sure you can :) MySQL <5.0 is out of date (end of life).
 
Wael, does your scipt convert mysql 4 to 5? Where can I read about changes for users? I don't want to upgrade and cause problems.
 
Is their any reason to move to it other then its EOL status?

Is it faster?

The upgrade process doesn't look trivial, though, if you'll just do a mysqldump then re-import it, it seems to be okay.
 
About the performance: http://www.mysqlperformanceblog.com/files/presentations/UC2006-MySQL-5.0-vs-4.1.pdf

You don't need to backup/restore all the data :) Just do this (on RedHat based OS):
Code:
 mkdir mysql
 cd mysql
 wget http://files.directadmin.com/services/all/mysql/MySQL-client-5.0.37-0.i386.rpm
 wget http://files.directadmin.com/services/all/mysql/MySQL-devel-5.0.37-0.i386.rpm
 wget http://files.directadmin.com/services/all/mysql/MySQL-server-5.0.37-0.i386.rpm
 wget http://files.directadmin.com/services/all/mysql/MySQL-shared-5.0.37-0.i386.rpm
 rpm -Uvh MySQL-*-5.0.37-0.i386.rpm
 /etc/rc.d/init.d/mysqld restart
 
About the performance: http://www.mysqlperformanceblog.com/files/presentations/UC2006-MySQL-5.0-vs-4.1.pdf

You don't need to backup/restore all the data :) Just do this (on RedHat based OS):
Code:
 mkdir mysql
 cd mysql
 wget http://files.directadmin.com/services/all/mysql/MySQL-client-5.0.37-0.i386.rpm
 wget http://files.directadmin.com/services/all/mysql/MySQL-devel-5.0.37-0.i386.rpm
 wget http://files.directadmin.com/services/all/mysql/MySQL-server-5.0.37-0.i386.rpm
 wget http://files.directadmin.com/services/all/mysql/MySQL-shared-5.0.37-0.i386.rpm
 rpm -Uvh MySQL-*-5.0.37-0.i386.rpm
 /etc/rc.d/init.d/mysqld restart

@ Martynas will this work on centos 64bit aswell?
We are currently running one 64Bit server ( rest is 32bit ) as a test to go with 64Bit in the future.

We use Weal's script too along with ELS but not sure if updating on our new server will work.

//Hans
 
For 64-bit system you should use:

Code:
mkdir mysql
cd mysql
wget http://mysql.proserve.nl/Downloads/MySQL-5.0/MySQL-client-5.0.37-0.glibc23.x86_64.rpm
wget http://mysql.proserve.nl/Downloads/MySQL-5.0/MySQL-devel-5.0.37-0.glibc23.x86_64.rpm
wget http://mysql.proserve.nl/Downloads/MySQL-5.0/MySQL-server-5.0.37-0.glibc23.x86_64.rpm
wget http://mysql.proserve.nl/Downloads/MySQL-5.0/MySQL-shared-5.0.37-0.glibc23.x86_64.rpm
rpm -Uvh MySQL-*-5.0.37-0.glibc23.x86_64.rpm
/etc/rc.d/init.d/mysqld restart
 
About the performance: http://www.mysqlperformanceblog.com/files/presentations/UC2006-MySQL-5.0-vs-4.1.pdf

You don't need to backup/restore all the data :) Just do this (on RedHat based OS):
Code:
 mkdir mysql
 cd mysql
 wget http://files.directadmin.com/services/all/mysql/MySQL-client-5.0.37-0.i386.rpm
 wget http://files.directadmin.com/services/all/mysql/MySQL-devel-5.0.37-0.i386.rpm
 wget http://files.directadmin.com/services/all/mysql/MySQL-server-5.0.37-0.i386.rpm
 wget http://files.directadmin.com/services/all/mysql/MySQL-shared-5.0.37-0.i386.rpm
 rpm -Uvh MySQL-*-5.0.37-0.i386.rpm
 /etc/rc.d/init.d/mysqld restart
This will work even if I've been installing/compiling from source?
 
Back
Top