What I have:
1. Mysql 4.1.11 on local computer, Mysql 4.0.24 on my server
2. Identical databases on both computers
When I perform fulltext search in a way like folowing:
select * from program where match (name, keywords, description) against ('+3gp* +converter*' in boolean mode)
the result on local machine is quite different from the result on server - server version does not include some records. Cannot understand why. I suppose that fulltext indexing in 4.0 and 4.1 cannot be so much different. Will greatly appreciate any advice.
Also I can assume that some parameters in my.cnf differ for local and server version that may cause such behavior, but cannot even predict which ones.
http://www.shareware-download.org/ - Download programs found by keyword instead of browsing categories.