Mysql v4 hosting?

bstruss

I am locally developing on version 4.0 of Mysql and I would really like to take advantage of the boolean search features. However, I am finding that my hosting company only supports 3.23.
1) Can anyone recommend an inexpensive php/mysql host that supports ver 4.0 or above?
2) Also, is version 4.0 stable (I am wondering about this being that many hosts don't offer it yet)?
3) Finally, when I tried to do a table dump and then run the re-create query on my host, they bombed. However, they will run fine on my local v4. They bombed on the myisam table type line. We are both using myisam but they are on ver 3.23. Any ideas on this?

Thanks for any help!
Bailey--

nemonoman

http://www.mysql.com/doc/en/Fulltext_Search.html

"As of Version 3.23.23, MySQL has support for full-text indexing and searching. "

...

"Full-text indexes in MySQL are an index of type FULLTEXT. FULLTEXT indexes are used with MyISAM tables only and can be created from CHAR, VARCHAR, or TEXT columns at CREATE TABLE time or added later with ALTER TABLE or CREATE INDEX. "

If your host's MySQL is < 3.23.23, and you're trying to create FULLTEXT type indices, you'll probably bomb.

4.0 hosts are (literally) a dime a dozen. I think the Lounge has some host recommendation threads. (I like Lunarpages, hate Dot5)