Upgrading from MySQL 4 to MySQL5?

[holyfuzz]

Hi all,

Great product! I'm a very happy user...

However, I'm trying to upgrade from from mysql 4 to mysql 5 because my web host will soon be discontinuing support for mysql 4. I have already created a mysql 5 database and converted my old mysql 4 database into my new mysql 5 database.

mysql4 db name: flyingfu_wdcms
mysql5 db name: flyingfu_wdcms5

After that, I opened up my config.php file and changed...
$config['db_name'] = 'flyingfu_wdcms';
to
$config['db_name'] = 'flyingfu_wdcms5';

However, this change does not work. By "not work", I mean that when I go to my website, all I see is a blank page.

So my question is: What else do I need to change so that cmsms uses my new mysql 5 database?

Thanks for any help! Here's all the info I know about my setup:

My mysql user/password has not changed.

CMSMS version 1.2.4.

MySQL 4 Connection Settings:

Local (web applications): Host: localhost | Socket: /tmp/mysql.sock
Remote (MySQL clients): Host: mysql4.server312.com | Port: 3306

When using "mysql4.server312.com" as a MySQL Host, you need to enable "Remote Connections" for your MySQL user. (more info)

DB Master Username: flyingfu. User flyingfu has 3 of 10 maximum allowed DBs.
You can manipulate your DBs with phpMyAdmin (log in)

MySQL 5 Connection Settings:

Local (web applications): Host: localhost | Socket: /tmp/mysql5.sock
Note: Most PHP applications/scripts will accept the following syntax:
MySQL Host: localhost:/tmp/mysql5.sock

Remote (MySQL clients): Host: mysql5.server312.com | Port: 3307

When using "mysql5.server312.com" as a MySQL Host, you need to enable "Remote Connections" for your MySQL user. (more info)

DB Master Username: flyingfu. User flyingfu has 3 of 10 maximum allowed DBs.
You can manipulate your DBs with phpMyAdmin (log in)

INSTALLED SOFTWARE
Service Version Path
PHP4 (more info) 4.4.9 (obsolete) -
PHP5 (more info) 5.2.6 (default) -
PERL 5.6 (more info) 5.6.1 /usr/bin/perl
PERL 5.8 (more info) 5.8.8 /usr/bin/perl5.8
Ruby 1.8.6 /usr/local/bin/ruby
Python 2.5.2 /usr/local/bin/python
MySQL 4 4.0.27 -
MySQL 5 5.0.45 -
ImageMagick - /usr/local/bin
NetPBM - /usr/local/netpbm/bin
Zend Optimizer 3.2.2 -
Sendmail - /usr/lib/sendmail

Thanks again!

[Pierre M.]

The database engine provider upgrade is not a CMSms related issue. Neither is the database content migration.
Because CMSms doesn't care which engine version it talks with.

Have your database engine upgrade and your database content migration. Then test your new database context with some very simple PHP sample script. When this CMSms unrelated thing works reliably use the same database parameters in CMSms' config.php.

It may be a MySQL user/access rights issue but you'd better ask your MySQL support.

Pierre M.