Upgrade MySql error

[aberg]

I try to update Mysql 4.1.22. to Mysql 5.0.27
But when I run the update I get this error:

The table 'pp_photoviews' in the database 'fotopost' uses the storage engine 'HEAP', which is not supported in MySQL 5.0.27.

Any idea how I can resolve this isue?

[Chuck S]

Thats just a warning error like if you try to optimize your tables it looks if the tables exist you should be fine unless there is something I am not seeing here?

http://dev.mysql.com/doc/refman/5.0/...ge-engine.html

They should be backward compatible if not let me know

[aberg]

Thanks,I have ask the hoster for support.
They have update the server for me.
This was they wrote to me:

I have upgraded MySQL to 5.0.27 and changed your HEAP tables to use MEMORY as the storage engine

On this moment no problems detect! (Vbulletin V 3.6.10 and photopost V 6.02 working fine)

[Chuck S]

Not a problem weird though how as that thread suggests heap is backward compatible but no harm no foul