Upgrading from 1 MySQL 5.1 version to Another

T

topdog

Verified User
Joined
Jun 22, 2009
Messages
135
:confused:
Hi,
I am running DA 1.33.6, CentOS5.3, PHP 5.2.10, HTTPD 2.2.11, and MySQL 5.1.35.
I want to upgrade to MySQL 5.1.36 using custombuild, but not sure how to do so.
Do I just get the .tar.gz file and put it in the custombuild dir, then run ./build mysql, then ./build php n?
Thanks.
 
Code: 
cd /usr/local/directadmin/custombuild
./build update
./build mysql
 
When I do the selected ./build update command
It says nothing about a mysql tarball existing nore that it is downloading another one.
I can tell MySQL is installed, but it's not installed via RPM or Yum, as when I do rpm -q mysql, or rpm -q da_mysql, the system says that none of those packages are installed.
When I do yum install mysql, it wants to install 5.0.45, but apparently Yum says MySQL is already installed.
This is a fresh install of DirectAdmin on this CentOS5.3 server. So then how else can I upgrade MySQL?
Does custombuild download a tar and build MySQL from there?
 
Cant upgrade MySQL

Hi

i also looking to upgrade mysql to version MySQL 5.1.34

Im also running DA 1.33.7, CentOS5.2, PHP 5.2.10, Apache 2.2.12, and MySQL 5.0.67





cd /usr/local/directadmin/custombuild
./build update
./build mysql

when i do ./build mysql

it says

You can not install MySQL, because you do not have it set in options.conf file.


what dose this mean?


how do i set it in options.conf


thanks
 
dan2 said:
Hi

i also looking to upgrade mysql to version MySQL 5.1.34

Im also running DA 1.33.7, CentOS5.2, PHP 5.2.10, Apache 2.2.12, and MySQL 5.0.67





cd /usr/local/directadmin/custombuild
./build update
./build mysql

when i do ./build mysql

it says

You can not install MySQL, because you do not have it set in options.conf file.


what dose this mean?


how do i set it in options.conf


thanks
Click to expand...
You can not install MySQL, because you do not have it set in options.conf.
what dose this mean? how do i set it in options.conf
it says in the context of the message.
In /usr/local/directadmin/custombuild, somehow MySQL options weren't set. But then again, how is that possible when you already have MySQL installed to begin with?
It would not install unless MySQL was set to yes in options.conf.
Can you post your options.conf here or at least send it via e-mail so I can have a look at it.
And by the way, I successfully upgraded MySQL to the latest version.
I can tell you how I did it once options.conf has been looked at by meor by someone else first to make sure things are set properly.
I failed to ask: Is this a fresh install of DirectAdmin on your CentOS machine? if so, MySQL should be at 5.1 already. If not perhaps then you may have upgraded from an older DA control panel version and DA didn't bother upgrading it's software.
 
Dan2, I have sent you a pm so that I might try and help you with your MySQL upgrading.
If you're willing, we can discuss this further via e-mail. I've left my email address in a pm to you.
 
Hi

this is a fresh install of centos 5.2

here are the options.conf file in /usr/local/directadmin/custombuild






#PHP settings. default_php possible values - 4 or 5
default_php=5
php4_cli=no
php4_cgi=no
php5_cli=yes
php5_cgi=no
zend=yes

#Possible values - 4.1, 5.0, 5.1
mysql=5.1
mysql_inst=no
mysql_backup=yes

#Possible values - 1.3, 2.0 or 2.2
apache_ver=2.2

#Web applications
phpmyadmin=yes
atmail=no
squirrelmail=yes
roundcube=yes
uebimiau=no

#Mail options
exim=no
mail-header-patch=yes
dovecot=yes

#Statistics
awstats=no
webalizer=yes

#FTP options
proftpd=no

#Jailed shell (beta)
jail=no

#CustomBuild options
custombuild=1.1
autover=no
bold=yes
clean=yes
clean_old_tarballs=no
clean_old_webapps=yes

#Cron settings
cron=no
[email protected]
notifications=yes
da_autoupdate=no
updates=no
webapps_updates=yes

#CustomBuild 1.2 settings
php6_cli=no
php6_cgi=no
php_ini=no
#Possible values - recommended or dist
php_ini_type=recommended
cleanapache=no
fileserver=1
eximconf=no



thanks
 
How strange? Everything looks ok in that file ... weired.
Since I sent you a pm with my e-mail address, would you mind if I logged into your box to have a look at things?
if you would be willing, I can upgrade your MySQL for you if you'd like.
Send any username/password details to me in an email, I've left my email in a pm to you, so if I can help I will try.
 
mysql

Hi

this is what you need to do right?

to upgrade mysql


cd /usr/local/directadmin/custombuild
./build update
./build mysql
 
dan2 said:
Hi

this is what you need to do right?

to upgrade mysql


cd /usr/local/directadmin/custombuild
./build update
./build mysql
Click to expand...

That's correct. It doesn't seem to work for you for some reason.
This is why I asked if I could have a look at your machine to see what I could do to possibly help you out with that.
 
Mysql update

Hi

when i do

./build update


i get this bellow

i dont see any sql file there to update

may be it needs to be added to the list first


extracting custombuild.tar.gz for 1.1 ...
custombuild/
custombuild/build
custombuild/configure/
custombuild/configure/ap1/
custombuild/configure/ap1/configure.php5
custombuild/configure/ap1/configure.apache_ssl
custombuild/configure/ap1/conf/
custombuild/configure/ap1/conf/mime.types
custombuild/configure/ap1/conf/httpd.conf
custombuild/configure/ap1/conf/extra/
custombuild/configure/ap1/conf/extra/httpd-vhosts.conf
custombuild/configure/ap1/conf/extra/httpd-deflate.conf
custombuild/configure/ap1/conf/extra/httpd-multilang-errordoc.conf
custombuild/configure/ap1/conf/extra/httpd-info.conf
custombuild/configure/ap1/conf/extra/httpd-alias.conf
custombuild/configure/ap1/conf/extra/httpd-userdir.conf
custombuild/configure/ap1/conf/extra/httpd-languages.conf
custombuild/configure/ap1/conf/extra/httpd-default.conf
custombuild/configure/ap1/conf/extra/httpd-autoindex.conf
custombuild/configure/ap1/conf/extra/directadmin-vhosts.conf
custombuild/configure/ap1/conf/extra/httpd-ssl.conf
custombuild/configure/ap1/conf/magic
custombuild/configure/ap1/configure.php4
custombuild/configure/ap2/
custombuild/configure/ap2/configure.php5
custombuild/configure/ap2/conf/
custombuild/configure/ap2/conf/httpd.conf_2.0
custombuild/configure/ap2/conf/mime.types
custombuild/configure/ap2/conf/httpd.conf
custombuild/configure/ap2/conf/extra/
custombuild/configure/ap2/conf/extra/httpd-vhosts.conf
custombuild/configure/ap2/conf/extra/httpd-deflate.conf
custombuild/configure/ap2/conf/extra/httpd-mpm.conf
custombuild/configure/ap2/conf/extra/httpd-multilang-errordoc.conf
custombuild/configure/ap2/conf/extra/httpd-mpm.conf_2.0
custombuild/configure/ap2/conf/extra/httpd-info.conf
custombuild/configure/ap2/conf/extra/httpd-alias.conf
custombuild/configure/ap2/conf/extra/httpd-userdir.conf
custombuild/configure/ap2/conf/extra/httpd-languages.conf
custombuild/configure/ap2/conf/extra/httpd-dav.conf
custombuild/configure/ap2/conf/extra/httpd-default.conf
custombuild/configure/ap2/conf/extra/httpd-autoindex.conf
custombuild/configure/ap2/conf/extra/directadmin-vhosts.conf
custombuild/configure/ap2/conf/extra/httpd-ssl.conf
custombuild/configure/ap2/conf/extra/httpd-manual.conf
custombuild/configure/ap2/conf/magic
custombuild/configure/ap2/cert_config
custombuild/configure/ap2/configure.apache
custombuild/configure/ap2/configure.php4
custombuild/configure/dovecot/
custombuild/configure/dovecot/dovecot.conf
custombuild/configure/proftpd/
custombuild/configure/proftpd/configure.proftpd
custombuild/configure/suphp/
custombuild/configure/suphp/configure.php5
custombuild/configure/suphp/configure.suphp
custombuild/configure/suphp/configure.php4
--08:45:26-- http://files.directadmin.com/services/custombuild/versions.txt
Resolving files.directadmin.com... 72.35.85.222
Connecting to files.directadmin.com|72.35.85.222|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 3461 (3.4K) [text/plain]
Saving to: `./versions.txt'

100%[=======================================>] 3,461 --.-K/s in 0s

08:45:26 (236 MB/s) - `./versions.txt' saved [3461/3461]

File already exists: httpd-2.2.12.tar.gz
MD5 Checksum on httpd-2.2.12.tar.gz passed.
File already exists: httpd_2
File already exists: httpd_2_freebsd
File already exists: httpd_2_debian
File already exists: mime.types
File already exists: mod_perl-2.0.4.tar.gz
MD5 Checksum on mod_perl-2.0.4.tar.gz passed.
File already exists: curl-7.19.5.tar.gz
MD5 Checksum on curl-7.19.5.tar.gz passed.
File already exists: pcre-7.9.tar.gz
MD5 Checksum on pcre-7.9.tar.gz passed.
File already exists: libmcrypt-2.5.8.tar.gz
MD5 Checksum on libmcrypt-2.5.8.tar.gz passed.
File already exists: mhash-0.9.9.9.tar.gz
MD5 Checksum on mhash-0.9.9.9.tar.gz passed.
File already exists: freetype-2.3.9.tar.gz
MD5 Checksum on freetype-2.3.9.tar.gz passed.
File already exists: libiconv-1.13.tar.gz
MD5 Checksum on libiconv-1.13.tar.gz passed.
File already exists: libxml2-2.7.3.tar.gz
MD5 Checksum on libxml2-2.7.3.tar.gz passed.
File already exists: libxslt-1.1.24.tar.gz
MD5 Checksum on libxslt-1.1.24.tar.gz passed.
File already exists: icu4c-4_2_1-src.tgz
MD5 Checksum on icu4c-4_2_1-src.tgz passed.
File already exists: php-5.2.10.tar.gz
MD5 Checksum on php-5.2.10.tar.gz passed.
File already exists: php-5.2.10-mail-header.patch
MD5 Checksum on php-5.2.10-mail-header.patch passed.
File already exists: webalizer-2.21-02-src.tgz
File already exists: suphp-0.7.1.tar.gz
MD5 Checksum on suphp-0.7.1.tar.gz passed.
File already exists: dovecot-1.2.2.tar.gz
MD5 Checksum on dovecot-1.2.2.tar.gz passed.
File already exists: dovecot.boot
File already exists: dovecot.boot.freebsd
File already exists: dovecot.boot.debian
File already exists: dovecot.conf
File already exists: exim.conf.dovecot.patch
MD5 Checksum on exim.conf.dovecot.patch passed.
File already exists: autoconf-2.61.tar.gz
MD5 Checksum on autoconf-2.61.tar.gz passed.
File already exists: automake-1.10.2.tar.gz
MD5 Checksum on automake-1.10.2.tar.gz passed.
File already exists: libtool-2.2.6a.tar.gz
MD5 Checksum on libtool-2.2.6a.tar.gz passed.
File already exists: ZendOptimizer-3.3.3-linux-glibc23-i386.tar.gz
[root@5078 custombuild]#
 
Based upon what you've pasted, there's proof that it's not working.
When you do ./build update, it updates what's not updated to begin with which would have had to have been MySQL.
Adding MySQL to a list would not have done anything; DA knows based upon versions.txt what's not updated and what is updatable at the time you issue the build update command.
The only thing I can tell you is either I can have a look at it and see if I can attempt to help you upgrade or you contact your server provider to see if they'd upgrade MySQL for you.
I would not mind helping you upgrade MySQL as I've upgraded before.
 
You must log in or register to reply here.
Back
Top