How do I start MySQL without InnoDB?

[TonyGroves]

I have just installed MySQL 4.0.13 on Windows NT4, and would like to use only MyISAM tables. However, when I start the service, it creates several InnoDB files in the data directory, and then aborts with the error "table mysql.host doesn't exist".

Can anybody tell me how I can set up MySQL so that it does not do this?

Thanks a lot.

 

[vanekl]

Three host.{frm|MYD|MYI} files are installed in MySQL's data\mysql directory upon MySQL installation.
Did you accidently delete these files, or delete the data\mysql
directory, or delete the mysql database?
Just reinstall MySQL to reinstall these files.

You can get MySQL to not use InnoDB tables by adding 'skip-innodb' in the 'mysqld' block of the 'my.ini/my.cnf' file.

 

[TonyGroves]

That worked, thanks. What I did wrong was to change the data directory without moving the existing system tables across.