MySQL Error: ENGINE = MyISAM invalid SQL?

[Eikinskjaldi]

Originally Posted by Megareus Rex

What does that mean, exactly? Is there anything I could edit in the hacks to still have them install? My MySQL version is 4.0.16, btw.

I'm just trying to understand the problem. The MySQL is controlled by the host I have, so I can't really easily upgrade it, though moving to a new host with a newer version is always possible (I've been wanting to move anyways).

Thanks in advance for any help or suggestions.

I have no idea where Wayne is getting this from, unless there is some hidden extra error message I cannot see. Your mysql version is certainly incompatible with the engine declaration.

A character set defines what actual characters are represented in your strings, so if you were writing in French you would want a character set that supported accents over vowels. A collation determines how the members of the set are compared, for example does "a" come before "A".

Chances are you could delete any reference to these in the create table syntax, and not cause a problem. Obviously, I cannot guarantee this. Were it me, I'd be moving hosts. 4.0 is a poor choice of database for today. It's not even supported anymore.