mysql 4.1.8

[nettstedet]

Hello,

Has anyone upgraded to MySQL 4.1.8 ?

Any problems / issues with this release?

Thanks.

[wdv]

I am especially interested if there are any 4.0.x users who upgraded to 4.1.x

Did you encounter any problems during the upgrade?

[nettstedet]

Server has now been upgraded to the latest mysql 4.1.8

(upgraded from 4.0.22)

No problems and everything appears to be working very good.

[PauGasol]

Is Mysql 4.1.x full compatible with CMS , phpbbs etc etc?

[choon]

Originally posted by PauGasol
Is Mysql 4.1.x full compatible with CMS , phpbbs etc etc?
If you want problem/trouble free from upgrading MySQL from 4.0.x to 4.1.x... you can try but after upgrading MySQL, please do the following or else you might get errors related to mysqlclient issues:

1. recompile/reinstall php with mysql support
2. restart mysql
3. restart apache

[DJ_Max]

Basicly MySQL 4.1.x is a big improvement from 4.0.x. With that, comes the PHP's mysqli extension, which is what you need to access the new features, but still will accept PHP's old mysql extension. Recompiling PHP as choon suggested would be still be a smart thing to do.

[sander815]

Originally posted by choon
[B]
1. recompile/reinstall php with mysql support



can you describe how?

[choon]

Originally posted by sander815
can you describe how?
Try to learn from reading some help message within the DA build script ;)
cd /usr/local/directadmin/customapache/
./build
Look for building php option ... ... :p

[jstrzalko]

where did you guys get the rpm for it? (i am running rhel 3) if you compiled it what settings did you use?

thanks!
josh

[GoranTornqvist]

Didn't find any post here about how to upgrade from 4.0 to 4.1 so I tried it myself on my new freebsd 4 box, this is what I did:

/usr/local/mysql was a symlink to /usr/local/mysql-standard-4.0.17-unknown-freebsd4.7-i386

So I just downloaded mysql-standard-4.1.8-unknown-freebsd4.7-i386 and did tar zxvf, moved the dir to /usr/local, deleted the symlink and created it again to /usr/local/mysql-standard-4.1.8-unknown-freebsd4.7-i386.
/usr/local/mysql/data was a symlink to /home/mysql on my server so I remade that link. After that I just restarted mysql and it was running the new version, no problemo. I also executed the bin/mysql_fix_privilege_tables script as described here:
http://dev.mysql.com/doc/mysql/en/Upgrading-from-4.0.html
Is there anything else I need to do?

Next I will try recompiling php5, is there anything special I need to think of when compiling it with mysql 4.1?

[interfasys]

DA has put a file in their repository for FreeBSD 4.x, http://files.directadmin.com/services/freebsd4.8/mysql-standard-4.1.8-unknown-freebsd4.7-i386.tar.gz
but it seems the 5.X branch is abandonned. The last time mysql was updated was back in 2003.

[SeLLeRoNe]

hi guys, some one can say me what i've to do to upgrade myqsl step by step?

thanks a lot

[SeLLeRoNe]

i've freebsd 5.2.1 and i'm running mysql 4.0.17.. on website of mysql i didn't found any new version for my freebsd.. who can i do?

[GoranTornqvist]

DA isn't providing mysql 4.1...yet, I think.
I downloaded the binary release for freebsd from www.mysql.com.

I don't know if it's the same version for freebsd 4 as for freebsd 5...check the mysql site.

To update, do as I did above:

/usr/local/mysql was a symlink to /usr/local/mysql-standard-4.0.17-unknown-freebsd4.7-i386

So I just downloaded mysql-standard-4.1.8-unknown-freebsd4.7-i386 and did tar zxvf, moved the dir to /usr/local, deleted the symlink and created it again to /usr/local/mysql-standard-4.1.8-unknown-freebsd4.7-i386.
/usr/local/mysql/data was a symlink to /home/mysql on my server so I remade that link. After that I just restarted mysql and it was running the new version, no problemo. I also executed the bin/mysql_fix_privilege_tables script as described here:
http://dev.mysql.com/doc/mysql/en/U...g-from-4.0.html
Is there anything else I need to do?

hint: symlinks are created with "ln" command, like:
ln -s /usr/local/mysql-standard-4.1.8-unknown-freebsd4.7-i386 /usr/local/mysql

[SeLLeRoNe]

i've tried but doesnt work.. i know hot to install but i didn't find any version for freebsd 5 :(

[GoranTornqvist]

Then the only way is to download the source download and compile it yourself.

See: http://dev.mysql.com/downloads/mysql/4.1.html
(at the bottom)

[werwin01]

Did anyone get this working for FreeBSD 5.x?

[jmstacey]

See the post right above yours ;)

People have gotten it to work, just search the forums ;)

[werwin01]

I saw that.
Any plans to have the package added into the DA configuration I don't have to build from source, (and so I don't break things)?

[jmstacey]

That I do not know, but my guess is later down the road or optional because of the password issue http://www.directadmin.com/features.php?id=466

[Mystical]

Originally posted by wdv
I am especially interested if there are any 4.0.x users who upgraded to 4.1.x

Did you encounter any problems during the upgrade?

I went fro 4.0.22 to 4.1.10a, no problems at all. Scripts working fine, no errors yet.

[jmstacey]

My script for FreeBSD 4.x now supports both 4.0 and 4.1 lines, however I do not suggest upgrading from 4.0 to 4.1 without giving more scrutiny than usual over the process.

http://www.saevian.com/da_tools/update.mysql.sh

I also put this script together which has the same capabilities for Debian 3.x
http://www.saevian.com/da_tools/upgrade.mysql.sh


* Notes:
1. I am not responsible for any ill actions these scripts might cause.

2. I have tested the Debian script on my servers

3. I have NOT tested the FreeBSD script, however I believe it should work fine.

4. You must already be converted to the new MySQL installation method in Debian for this script to work.
This is in reference to: http://www.directadmin.com/features.php?id=477

[drmike]

uisng 4.1.11 over here without any issue. I came across a bug with imap when trying to install horde that got fixed in 4.1.9 so anything above that was fine with me.

Download the four rpms and you should be fine.

MySQL-client-4.1.11-0.i386.rpm
MySQL-devel-4.1.11-0.i386.rpm
MySQL-server-4.1.11-0.i386.rpm
MySQL-shared-4.1.11-0.i386.rpm

Make sure you recompile php as well as per the link above. :)

-drmike

[CrazyLane]

Currently running 4.0.24 and php 5.0.3, I installed 4.1.11 works fine until I recompile php. Php will not recognize it, but mysql still works with perl, etc...

Here is my configure for php

--with-apxs2 \
--with-curl \
--with-curl-dir=/usr/local/lib \
--with-gd \
--with-gd-dir=/usr/local/lib \
--with-gettext \
--with-jpeg-dir=/usr/local/lib \
--with-kerberos \
--with-mcrypt \
--with-mhash \
--with-mysql \
--with-mysqli /usr/bin/mysql_config \
--with-pear \
--with-png-dir=/usr/local/lib \
--with-xml \
--with-zlib \
--with-zlib-dir=/usr/local/lib \
--with-zip \
--enable-bcmath \
--enable-calendar \
--enable-ftp \
--enable-magic-quotes \
--enable-sockets \
--enable-track-vars \
--with-dom=/usr/local/ \
--enable-sockets

I have tried the config several diff ways. Anyhelp would be great!

Thanks!

[interfasys]

That config will never work unless you change this:

--with-mysqli /usr/bin/mysql_config \

[CrazyLane]

Typo on my part, but still doesn't work even if I leave out mysqli

[jmstacey]

When you upgraded to 4.1 did you following the php build instructions here:http://www.directadmin.com/features.php?id=466

[CrazyLane]

I tried with:

--with-mysql=/usr

and

--with-mysql=/usr/local/mysql

Still I get a blank page with anysite running a database.

[albatroz]

Hi!
I wonder if you got this issue finally fixed

[CrazyLane]

Yes insure that php is built clean:

./build clean

[albatroz]

Well it works for me in most cases,
but still get blank pages in certain cases inside phpmyadmin 2.64pl

BTW I am using this trick..

[mysqld]
old_passwords