Troubleshoot Issue with Populating FullText Index on MySQL

I have an online MySQL database (on linux box) with a table that has two varchar fields (both in utf8_general_ci). I have successfully created a fulltext index consisting of these two fields. I also modified ft_min_word_len=1; in the MySQL config file and it has been picked up by the MySQL server as evident by SHOW VARIABLES after restarting both MySQL server and the hardware server box;

The problem I am facing is that after I execute either REPAIR TABLE xxxxtablename QUICK or REPAIR TABLE xxxxtablename EXTENDED, the fulltext index is not populated with indices data as evident in the "Cardinality field in PHPMyAdmin" that I use to manage the MySQL database. I have some 2000 records in the database, but the cardinality field displayed in PHPMyAdmin is always 1. When I issue the SQLs search using FULLText search, it always returns no result (which I assume is pretty much reasonable because the fulltext index is empty)

You can logon my PhpMyAdmin and I could also restart either MySQL or the server box. The data in the table needs to be preserved!

I can pay US$30 for this if you could solve this problem as I assume this is pretty much a "gotcha" catch. I have already googled it for a while for relevant solutions. So don't bid if you don't know exactly what I am talking about or the real cause/solutions to this problem per se.

I only pay for real result that is verifiable on my MySQL server with PhpMyAdmin. I won't pay for your idea or suggestion of any sorts or whatever else. No result, no payment.

Hope I made it clear. Your bids will be much appreciated.

Skills: Linux, MySQL, PHP, Script Install, SQL

See more: mysql fulltext cardinality index problem, quick sorts, online php execute, issue payment, execute php online, clear search fields, mysql fulltext fields index, cardinality field displayed phpmyadmin always, online mysql database, troubleshoot, issue, php script execute, mysql pretty, clear linux, php fulltext, server issue, issue linux, mysql search database table, indices, mysql empty database, mysql repair database, hardware php script, phpmyadmin mysql, index is, script restart server

About the Employer:
( 1 review ) Beijing, China

Project ID: #1089768

Awarded to:


hi, Can work on the mysql, psl check pmb, b/r TG Shakthi

$30 USD in 1 day
(6 Reviews)

4 freelancers are bidding on average $30 for this job


ready to work with u

$30 USD in 0 days
(0 Reviews)

I can easily do this. I can easily understand the problem and bring out the solution for you.

$30 USD in 3 days
(0 Reviews)

I can solve your problem. I am looking for ur job.

$31 USD in 1 day
(0 Reviews)