The unofficial MySQL thread

[The_Unbeliever]

This thread was started to share hints and tips with local users. The main mySQL forum is located at www.mysql.com, and might not be accessible for users who are capped locally.

If you've got hints, tips, questions or just want to rave/rant, this is the place to be!

Cheers!

Libs

 

[The_Unbeliever]

To start off :

I've been battling to install MySQL 5.1.32 (Windows) on WindowsXP. Whenever I install it (and try to use the high-speed innoDB database), and try to get it to start, the installer is not able to start the service, and thereafter any reinstall/reconfiguration attempt is futile, and only a system restore will help you.

In the event log you will usually see the following errors :

Plugin 'InnoDB' init function returned error.


Plugin 'InnoDB' registration as a STORAGE ENGINE failed.


Unknown/unsupported table type: INNODB

The trick is to install MySQL first with the non-transactional database (myISAM) database, wait for the installation to finish successfully, and THEN run the instance configuration manager, and set it up with the high-speed innoDB database, this will ensure a successful installation.

Hope this will help a couple of people battling with it

Cheers!

Libs