Upgrade from Mysql 4 to Mysql 5

[aspen1018]

Right now I have my board on mysql 4.1 and I would like to upgrade to vbulletin 3.7.0 and they recommend mysql 5.0

My database size is about 80mb. Is there an easy way to upgrade to mysql 5.0 when I upgrade to the new vbulletin version ?

Thanks

[Dismounted]

Just turn off vBulletin temporarily, upgrade MySQL, upgrade vBulletin, then turn it back on. Make sure you back up your database first.

[aspen1018]

I'm wondering how do you upgrade mysql ?

I called godaddy and they said to create a 5.0 mysql database and then export my data from the 4.0 mysql and then import into the 5.0 database

however phpmyadmin only imports 2mb at a time; so with an 80mb database I don't know how to do it

that is my question; can you do it with the vbulletin software ?

[aberg]

upgrade mysql from Mysql 4 to Mysql 5 gives me problem.
I can't upgrade because I get this messages:

The table 'bbm_live' in the database 'forum' uses the storage engine 'HEAP', which is not supported in MySQL 5.0.27.
The table 'bbm_user' in the database 'forum' uses the storage engine 'HEAP', which is not supported in MySQL 5.0.27.
The table 'cpsession' in the database 'forum' uses the storage engine 'HEAP', which is not supported in MySQL 5.0.27.
The table 'session' in the database 'forum' uses the storage engine 'HEAP', which is not supported in MySQL 5.0.27.

Have already ask support,but till now no solution for this isue

[Jase2]

The first one is not a vB table. The second should be MyISAM, not HEAP.

The last two are supposed to be HEAP which has changed to MEMORY in MySQL 5. I am clueless as to why mySQL isn't updating them automatically.

[aspen1018]

bump

[Eikinskjaldi]

if you dont have root access to your server (and I am assuming this is some kind of godaddy webhost) then you cannot upgrade your version of mysql, it is something the host has to do.