Mysql 5.1 upgrade Mysql 5.5

[backlog]

Hello

How do I upgrade to MySQL 5.1 MySQL 5.5?

OS: Centos 5.7 32 bit

control panel: directadmin

Thanks

 

[SeLLeRoNe]

If you have root access to the server use:

cd /usr/local/directadmin/custombuild
./build clean
./build set mysql 5.5
./build update
./build mysql
./build php d

Regards

 

[backlog]

Hi Andrea Thank you for the answer

If you have root access to the server use:

cd /usr/local/directadmin/custombuild
./build clean
./build set mysql 5.5
./build update
./build mysql
./build php d

Regards

 

[Arieh]

Anyone got info on why to use 5.5 over 5.1 or the other way around?

 

[SeLLeRoNe]

the only thing ive heard is that is like 400% faster.

Some customers ive manage their server confirmed that.

Personally, im not using it yet.

Regards

 

[Arieh]

Sounds interesting, mysql is always asking much of the cpu.

 

[syaman]

Greetings

I've just attempted an upgrade from MySQL 5.1 to MySQL 5.5 on my DA (CentOS 6) server.

But at

./build mysql

I get this output

Cannot find libaio.so.1.  Please install libaio
yum install libaio

So I do a yum install libaio
but the outcome is

Setting up Install Process
Package libaio-0.3.107-10.el6.i686 already installed and latest version
Nothing to do

Will appreciate any advise

 

[syaman]

I came across some advice to symlink

http://www.directadmin.com/forum/showthread.php?t=41562&pagenumber=

So I did

#locate libaio.so.1 
/lib/libaio.so.1
ln -s /lib/libaio.so.1 /usr/lib/libaio.so.1

And it worked