MySQL 5.5 supported?

cnm

Verified User
Joined
Feb 28, 2008
Messages
36
Location
Sunnyvale, CA USA
Does DA support MySQL 5.5?
Current install is MySQL 5.1.54

Supposed to be huge improvement in speed with 5.5. Can I upgrade?
 
Why wouldnt it support mysql 5.5? Nothing in DA relies on mysql.
 
I asked my server support person to upgrade to MySQL 5.5 and they said not sure if DA supports.

Do you have MySQL 5.5 installed along with DA?
 
Last edited:
It has no problems with DA installation. Feel free to install MySQL packages. However, they are not available on DA servers yet.
 
My server Support says:
I have tried upgrading MySQL via DirectAdmin's custombuild script as well as the command line and nothing's working out. I'd rather not upgrade and cause more trouble, so I am electing to refrain from an unstable upgrade at this time. Until DirectAdmin itself has custombuild support for MySQL 5.5.8, we will be unable to make the changes.

Does this make sense?
 
It should be included into the CustomBuild scripts now. Please let me know your OS if you'd like me to provide you the installation instructions.
 
Try the following:
Code:
mkdir MySQL-5.5.8
cd MySQL-5.5.8
wget -O MySQL-client-5.5.8-1.linux2.6.x86_64.rpm "http://dev.mysql.com/get/Downloads/MySQL-5.5/MySQL-client-5.5.8-1.linux2.6.x86_64.rpm/from/http://ftp.gwdg.de/pub/misc/mysql/"
wget -O MySQL-devel-5.5.8-1.linux2.6.x86_64.rpm "http://dev.mysql.com/get/Downloads/MySQL-5.5/MySQL-devel-5.5.8-1.linux2.6.x86_64.rpm/from/http://ftp.gwdg.de/pub/misc/mysql/"
wget -O MySQL-server-5.5.8-1.linux2.6.x86_64.rpm "http://dev.mysql.com/get/Downloads/MySQL-5.5/MySQL-server-5.5.8-1.linux2.6.x86_64.rpm/from/http://ftp.gwdg.de/pub/misc/mysql/"
wget -O MySQL-shared-5.5.8-1.linux2.6.x86_64.rpm "http://dev.mysql.com/get/Downloads/MySQL-5.5/MySQL-shared-5.5.8-1.linux2.6.x86_64.rpm/from/http://ftp.gwdg.de/pub/misc/mysql/"
rpm -Uhv MySQL*-5.5.8-1.linux2.6.x86_64.rpm

Execute mysql_upgrade afterwards and reinstall PHP.
 
Try the following:
Code:
mkdir MySQL-5.5.8
cd MySQL-5.5.8
wget -O MySQL-client-5.5.8-1.linux2.6.x86_64.rpm "http://dev.mysql.com/get/Downloads/MySQL-5.5/MySQL-client-5.5.8-1.linux2.6.x86_64.rpm/from/http://ftp.gwdg.de/pub/misc/mysql/"
wget -O MySQL-devel-5.5.8-1.linux2.6.x86_64.rpm "http://dev.mysql.com/get/Downloads/MySQL-5.5/MySQL-devel-5.5.8-1.linux2.6.x86_64.rpm/from/http://ftp.gwdg.de/pub/misc/mysql/"
wget -O MySQL-server-5.5.8-1.linux2.6.x86_64.rpm "http://dev.mysql.com/get/Downloads/MySQL-5.5/MySQL-server-5.5.8-1.linux2.6.x86_64.rpm/from/http://ftp.gwdg.de/pub/misc/mysql/"
wget -O MySQL-shared-5.5.8-1.linux2.6.x86_64.rpm "http://dev.mysql.com/get/Downloads/MySQL-5.5/MySQL-shared-5.5.8-1.linux2.6.x86_64.rpm/from/http://ftp.gwdg.de/pub/misc/mysql/"
rpm -Uhv MySQL*-5.5.8-1.linux2.6.x86_64.rpm

Execute mysql_upgrade afterwards and reinstall PHP.
Hi I did this and everything seemed to work ok. I had to reset my mysql root password, but then I was able to run mysql_upgrade. I also ran ./build set mysql 5.5 and it seemed to set that option.

My question is that will updates for mysql 5.5 be available to install using CustomBuild?
 
It should be included into the CustomBuild scripts now. Please let me know your OS if you'd like me to provide you the installation instructions.


Debian Lenny 64bit

Code:
da:/usr/local/directadmin/custombuild# ./build mysql n
Cannot find /usr/bin/mysqldump
--15:00:29--  http://files.directadmin.com/services/all/mysql/debian/mysql-5.5.8-linux-i686.tar.gz
           => `mysql-5.5.8-linux-i686.tar.gz'
Translacja files.directadmin.com... 72.35.85.222
Connecting to files.directadmin.com|72.35.85.222|:80... połączono.
Żądanie HTTP wysłano, oczekiwanie na odpowiedź... 404 Not Found
15:00:30 BŁĄD 404: Not Found.
 
Just remember that 5.5 will break some websites. Make sure you read the upgrade procedure page on Oracle's website.
 
Back
Top