In the Control Panel of our VPS appears:

Important Notice: Incompatible versions of Mysql 4.0.x and NPTL based systems.

If you are running a newer linux system which is NPTL based (CentOS 4, Fedora 3+, RHE 4, etc) and are having problems with MySQL 4.0.x (versions later then 4.0.23*), we recommend upgrading to MySQL 4.1.x as we have determined that there are compatibility issues on these platforms. You can easily upgrade to 4.1.x by changing the Mysql Version in Tweak Settings

If you are worried about compatibility with MySQL 4.0, be sure to check the box labeled: Use old style (4.0) passwords with mySQL 4.1. in Tweak Settings.

If you are unsure if your system is NPTL based, run getconf GNU_LIBPTHREAD_VERSION at the command line and see if it displays NPTL.

* 4.0.23 does not have any known issues, but is subject to security vulnerabilities:

http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2006-1516, http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2006-1517

-----------------------------------

Our questions are:
1) We have to upgrade to 4.1?
2) What's going to happen with Drupal 4.7 (installed in 4.0)?
3) How to upgrade Drupal sites from mySQL 4.0 to 4.1?

Thanks in advance,
Ferran

Comments

pwolanin’s picture

I've moved (small) Drupal sites between mySQL 4.0 and 4.1 (on different servers) just using mysqldump and then loading the tables back in using mysql or phpmyadmin. Everything works fine.

There is a minor difference in the database scheme for 4.0 vs. 4.1, so you might have to make this change by hand if you want everything to be optimal. The difference is that the 4.1 version of the schema adds "DEFAULT CHARACTER SET utf8;" to each table.

---
Work: BioRAFT

pwolanin’s picture

You conacted me by e-mail, but I can't really glean from you message whether you are asking me a specific question. I'm not an expert in server management by any stretch, so if you need more or expert help you're probably better off continuing to post in this forum or hiring a consultant.

That said, you might find this forum post of relevance:

http://drupal.org/node/33230

and you should also take a look at the MySQL docs:

http://dev.mysql.com/doc/

http://dev.mysql.com/doc/refman/4.1/en/upgrading-from-4-0.html

---
Work: BioRAFT