Just a quick note:
MySQL has deprecated the use of the keyword ‘TYPE’ to define the database engine. The database engine is now defined using the syntax engine.
So if you are using a script which still uses this keyword, you will get an error message like:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘TYPE=MyISAM’ at line 11.
To correct this error, simply replace your engine definition from TYPE=MyISAM to ENGINE=MyISAM.
So now you would define a table like this:
CREATE TABLE `mytable` ( `post_id` int(10) unsigned NOT NULL auto_increment, `title` varchar(255) NOT NULL default '', `desc` text NOT NULL, `comments` text NOT NULL, PRIMARY KEY (`post_id`), KEY `word_title` (`word_title`(5)), FULLTEXT KEY `word_desc` (`word_desc`) ) ENGINE=MyISAM ;