MySQL 4.1.12

[jmstacey]

MySQL 4.1.12 has been out now.
This worked for me on Debian, however won't for FreeBSD.


wget http://www.mark87.com/directadmin/tools/upgrade.mysql.sh
chmod 755 upgrade.mysql.sh
./upgrade.mysql.sh


You can also find methods of upgrading other Operating systems in the Version updates forum.

[Chrysalis]

thanks for update.

[servertweak]

got this


[root@server root]# wget http://www.mark87.com/directadmin/tools/upgrade.mysql.sh
--08:17:32-- http://www.mark87.com/directadmin/tools/upgrade.mysql.sh
=> `upgrade.mysql.sh'
Resolving www.mark87.com... done.
Connecting to www.mark87.com[66.54.206.17]:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 1,819 [application/x-sh]

100%[====================================>] 1,819 1.73M/s ETA 00:00

08:17:33 (1.73 MB/s) - `upgrade.mysql.sh' saved [1819/1819]

[root@server root]# chmod 755 upgrade.mysql.sh
[root@server root]# ./upgrade.mysql.sh

******************************************************
* MySQL upgrade tool for DirectAdmin servers. *
* Supports: Debian 3.0 *
* *
* Author: Jon Stacey <admin@saevian.com> *
* Modified: April 6, 2005 @ 8:22pm MST *
******************************************************


Upgrade to what version? [4.1.10a]


Upgrading to MySQL 4.1.10a
--08:18:27-- http://mysql.he.net/Downloads/MySQL-4.1/mysql-standard-4.1.10a-pc-linux-gnu-i686.tar.gz
=> `mysql-standard-4.1.10a-pc-linux-gnu-i686.tar.gz'
Resolving mysql.he.net... done.
Connecting to mysql.he.net[64.71.164.2]:80... connected.
HTTP request sent, awaiting response... 302 Found
Location: http://mirrors.he.net/cgi-bin/error404 [following]
--08:18:27-- http://mirrors.he.net/cgi-bin/error404
=> `error404'
Resolving mirrors.he.net... done.
Connecting to mirrors.he.net[64.71.164.2]:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/html]

[ <=> ] 734 716.80K/s

08:18:27 (716.80 KB/s) - `error404' saved [734]

!!! Cannot find new MySQL Package. Aborting !!!
[root@server root]#

[NetJaro]

Upgrade to what version? [4.1.10a]


Upgrading to MySQL 4.1.10a
--11:27:42-- http://mysql.he.net/Downloads/MySQL-4.1/mysql-standard-4.1.10a-pc-linux-gnu-i686.tar.gz
=> `mysql-standard-4.1.10a-pc-linux-gnu-i686.tar.gz'
Resolving mysql.he.net... done.
Connecting to mysql.he.net[64.71.164.2]:80... connected.
HTTP request sent, awaiting response... 302 Found
Location: http://mirrors.he.net/cgi-bin/error404 [following]
--11:27:42-- http://mirrors.he.net/cgi-bin/error404
=> `error404.1'
Resolving mirrors.he.net... done.
Connecting to mirrors.he.net[64.71.164.2]:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/html]

[ <=> ] 734 716.80K/s

11:27:42 (716.80 KB/s) - `error404.1' saved [734]

!!! Cannot find new MySQL Package. Aborting !!!
[root@multihost root]#

[jmstacey]

4.1.10a is no longer on that mirror. Currently on 4.1.11 and 4.1.12 which was released recently.
When the script asks what version to upgrade to be sure to input one of the above versions.

[servertweak]

Upgrade to what version? [4.1.10a]
4.1.12

Upgrading to MySQL 4.1.12
--09:46:58-- http://mysql.he.net/Downloads/MySQL-4.1/mysql-standard-4.1.12-pc-linux-gnu-i686.tar.gz
=> `mysql-standard-4.1.12-pc-linux-gnu-i686.tar.gz'
Resolving mysql.he.net... done.
Connecting to mysql.he.net[64.71.164.2]:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 30,746,577 [application/x-tar]

100%[====================================>] 30,746,577 10.18M/s ETA 00:00

09:47:01 (10.18 MB/s) - `mysql-standard-4.1.12-pc-linux-gnu-i686.tar.gz' saved [30746577/30746577]

rm: cannot lstat `/usr/local/mysql': No such file or directory
Killing mysqld with pid 8148
Giving MySQL 5 seconds to shutdown before restarting


Assuming upgrade was successfully to MySQL 4.1.12 :-|
[root@server root]#



but still says i'm using 4.0.17

[NetJaro]

Upgrading to MySQL 4.1.12
--11:57:15-- http://mysql.he.net/Downloads/MySQL-4.1/mysql-standard-4.1.12-pc-linux-gnu-i686.tar.gz
=> `mysql-standard-4.1.12-pc-linux-gnu-i686.tar.gz'
Resolving mysql.he.net... done.
Connecting to mysql.he.net[64.71.164.2]:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 30,746,577 [application/x-tar]

100%[====================================>] 30,746,577 1.07M/s ETA 00:00

11:57:42 (1.07 MB/s) - `mysql-standard-4.1.12-pc-linux-gnu-i686.tar.gz' saved [30746577/30746577]

rm: cannot lstat `/usr/local/mysql': No such file or directory
Killing mysqld with pid 1255
Wait for mysqld to exit.. done
Giving MySQL 5 seconds to shutdown before restarting


Assuming upgrade was successfully to MySQL 4.1.12 :-|


In DirectAdmin: MySQL 4.0.23

[jmstacey]

1. You are using Debian?
2. When you originally installed DirectAdmin, was it before or after this version?http://www.directadmin.com/features.php?id=477
If it was before you must manually convert over to the new installation method for this script to work which uses precompiled binaries from MySQL while DirectAdmin before that version used Debian packages.

[NetJaro]

Sorry! I have Redhat Enterprise 3.0

Sorry!

Such program is under Redhat Enterprise 3.0 ?

[servertweak]

Originally posted by NetJaro
Sorry! I have Redhat Enterprise 3.0

Sorry!

Such program is under Redhat Enterprise 3.0 ?

< running CentOS 3.4 which is RH 3

[jmstacey]

Try this for RedHat although I am unsure if it works or not: wget http://www.l0rdphi1.com/tools/update.mysql.sh

[NetJaro]

Upgrade to what version? [4.1.10a]
4.1.12

Upgrading to MySQL 4.1.12
--12:15:41-- http://mysql.he.net/Downloads/MySQL-4.1/mysql-standard-4.1.12-pc-linux-gnu-i686.tar.gz
=> `mysql-standard-4.1.12-pc-linux-gnu-i686.tar.gz'
Resolving mysql.he.net... done.
Connecting to mysql.he.net[64.71.164.2]:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 30,746,577 [application/x-tar]

100%[====================================>] 30,746,577 1.04M/s ETA 00:00

12:16:09 (1.04 MB/s) - `mysql-standard-4.1.12-pc-linux-gnu-i686.tar.gz' saved [30746577/30746577]

Killing mysqld with pid 9489
Wait for mysqld to exit.... done
Giving MySQL 5 seconds to shutdown before restarting


Assuming upgrade was successfully to MySQL 4.1.12 :-|

DirectAdmin: MySQL 4.0.23

Why??

P.S
http://www.l0rdphi1.com/tools/update.phpmyadmin.sh - It's for RH3? :-):rolleyes:

[servertweak]

Originally posted by jmstacey
1. You are using Debian?
2. When you originally installed DirectAdmin, was it before or after this version?http://www.directadmin.com/features.php?id=477
If it was before you must manually convert over to the new installation method for this script to work which uses precompiled binaries from MySQL while DirectAdmin before that version used Debian packages.


maybe i should leave it alone

[NetJaro]

And who help me?

[jmstacey]

ServerTweak,
If you installed DirectAdmin before that version, you will eventually have to convert over to the new system in order to easily update MySQL, otherwise you will have to depend on DirectAdmin releasing updated packages (which they most likely will not do since new installations use the precompiled binares from the MySQL website).
Find a compatible package in the Debian package lists or build your own from source, which would probably be harder than just downloading the precompiled binaries.

I would be willing to take a look if you'd like, just send me a PM.

NetJaro,
That script was written for RedHat and awhile ago at that. You may need to update manually without an automated script.

[Chrysalis]

Also a few people here trying to upgrade from 4.0.x to 4.1.x they are different releases and you might have problems if not preparing for the changes.

[NetJaro]

jmstacey can You install me this upgrade?

[jmstacey]

I can most certainly take a look. PM me ssh login details to access the server so I can investigate the setup and see about it.

[dragon2611]

can't get this verson working on centos when i installed it eveything lost access to mysql databases

had to remove it and go back to 4.1.11 :confused:

any ideas?

[jmstacey]

How did you upgrade?

1. You are using Debian?
2. When you originally installed DirectAdmin, was it before or after this version?http://www.directadmin.com/features.php?id=477
If it was before you must manually convert over to the new installation method for this script to work which uses precompiled binaries from MySQL while DirectAdmin before that version used Debian packages.

[dragon2611]

Originally posted by jmstacey
How did you upgrade?

me? using the upgrade scirpt someone wrote i changed it to look in the 4.1 tree

worked fine for installing 4.1.10 and for 4.1.11 but 4.1.12 results in no one being able to access their databases

[mr. green]

Originally posted by dragon2611
me? using the upgrade scirpt someone wrote i changed it to look in the 4.1 tree

worked fine for installing 4.1.10 and for 4.1.11 but 4.1.12 results in no one being able to access their databases

No problem here (RHEL3). I didn't use any upgrade script; just installed the three standard rpm's from the official MySQL site.

[Blaster]

Does this update work on Fedora Core 3? :)

[jmstacey]

Originally posted by Blaster
Does this update work on Fedora Core 3? :)

As I said earilier, my script is only for Debian. lordphils (sp) is for RedHat 9 I think but it may or may not work on related RedHat systems.

[Blaster]

OK thank you.
Do you know how I little to update with Fedora 3?

[jmstacey]

You might be able to use the provided rpm's from mysql.com
I have not gone through the process however since I do have my own servers to manage.

[Avenueduweb]

Hello,

I have modified the l0rdphi1's script to update mysql. But the rpm for mysql 4.1.12 is not ready to download but my script run perfectly with mysql 4.1.11 on fedora core 3. If directadmin's user are interesting do that :

wget http://www.avenueduweb.org/directadmin/update.mysql.sh
sh update.mysql.sh

And write the version you want.

Bye.

[Titam]

Originally posted by Avenueduweb
Hello,

I have modified the l0rdphi1's script to update mysql. But the rpm for mysql 4.1.12 is not ready to download but my script run perfectly with mysql 4.1.11 on fedora core 3. If directadmin's user are interesting do that :

wget http://www.avenueduweb.org/directadmin/update.mysql.sh
sh update.mysql.sh

And write the version you want.

Bye.

Thanks a lot Avenue du Web ^_^ I could update to 4.1.11, waiting for the 4.1.12 rpm^^ (FC3 too :) )

Marchi ^^

[dragon2611]

Originally posted by Avenueduweb
Hello,

I have modified the l0rdphi1's script to update mysql. But the rpm for mysql 4.1.12 is not ready to download but my script run perfectly with mysql 4.1.11 on fedora core 3. If directadmin's user are interesting do that :

wget http://www.avenueduweb.org/directadmin/update.mysql.sh
sh update.mysql.sh

And write the version you want.

Bye.

im wandering if they pulled the rpm first time i tryed to update using modiified script (i also modified one of those scripts probably that one) it updated but no one could access their db so i uninstalled mysql and used the script to reinstal 4.1.11

but 4.1.12 WAS avable initially using the script strange that it just dissapeared!

[Avenueduweb]

Originally posted by dragon2611
im wandering if they pulled the rpm first time i tryed to update using modiified script (i also modified one of those scripts probably that one) it updated but no one could access their db so i uninstalled mysql and used the script to reinstal 4.1.11

but 4.1.12 WAS avable initially using the script strange that it just dissapeared!

The script download the files :

MySQL-server-versionyouwant-0.i386.rpm
MySQL-client-versionyouwant-0.i386.rpm
MySQL-devel-versionyouwant-0.i386.rpm

And this files are not available for 4.1.12 on mysql.com but the files :

MySQL-server-4.1.12-1.i386.rpm
MySQL-client-4.1.12-1.i386.rpm
MySQL-devel-4.1.12-1.i386.rpm

are available.

I don't know what the difference between 4.1.12-0 and 4.1.12-1 ?

Sorry for that. It's possibly to upgrade the script simply change 0 to 1.

Bye.

[NetJaro]

Hi!

Who have this program on RH 3?

Thanks :-)

[interfasys]

It's now in ports.

[xlogicgroup]

For freebsd 5.x users running mysql 4.1 this worked for me:

/usr/local/etc/rc.d/mysqld stop
cd /usr/local
wget http://mysql.he.net/Downloads/MySQL-4.1/mysql-standard-4.1.12-unknown-freebsd5.3-i386.tar.gz
rm mysql
tar xvzf mysql-standard-4.1.12-unknown-freebsd5.3-i386.tar.gz
ln -s mysql-standard-4.1.12-unknown-freebsd5.3-i386 mysql
chown -fR root:mysql mysql-standard-4.1.12-unknown-freebsd5.3-i386
cd /usr/local/mysql
rm -rf data && ln -s /home/mysql data
/usr/local/etc/rc.d/mysql start

[dcabooter]

I wrote an upgrade script to update MySQL on Fedora Core 2. The script works with SRPMS from an official mirror. If anybody wants to use it you're welcome.

The script is located at
http://www.meesterlijk.nl/downloads/upgrade.mysql.sh

Kind regards.

[johnchan]

If using Debian (3.1), would it work to just use the Debian MySQL packages, and just leave it be?

[dcabooter]

If your question is about the script I posted for Fedora Core 2 I can't promise. In that case it's best to read the script and hunt for differences. The script does install/do some more than only installing MySQL.

[jmstacey]

johnchan,
That is how DirectAdmin originall installed MySQL, but that changed in version 1.235
http://www.directadmin.com/features.php?id=477

Which now simplifies upgrades by just downloading the latest precompiled binary from the MySQL website.

But yes, you can use your own method for upgrading and maintaining MySQL, such as just using Debian packages however it will require more work on your part.

[Chrysalis]

Interesting so DA went from using the OS integrated method of using mysql to a standalone package?

In most cases using the integrated OS method is usually much lower maintenance, I know it is for debian and FreeBSD and also maybe for redhat/centos.

look a few posts back at xlogicgroup post 10 steps.

Using ports it is 4 steps.

[jmstacey]

Depends on what your used to I guess. On both FreeBSD and Debian I wrote a shell script to do the upgrade for me which only requires 3 steps.

1. execute script
2. enter desired version
3. verify everything works

DirectAdmin probably did it because of the unreliability of maintaining most applications such as MySQL through a package system since installing or upgrading other software sometimes messes up MySQL trying to install newer or older versions because of dependencies etc.

[Chrysalis]

Not hard to see why DA did it since it allows them to use a generic installer across multiple os'es but for the admin himself it is harder, however you have mentioned you have a script for it which simplifies the process and DA's strength is it allows other ways of doing things by not taking over the system, which of course enabled me to use ports so it is good that the choice is there.

[jmstacey]

The location of this script has changed and can now be downloaded from the DirectAdmin download area on my website here:
http://www.mark87.com/download.php?view.1