So, I have a couple cool posts coming, but just to keep the blogging momentum going, I'll write about my drupal site not indexing properly. Since I'm getting closer to this CMS launch for our company's new Asia Pacific office, I had to make sure I got this solved ASAP. I had made some changes via administrator->settings->search, so I suspect that is when the indexing was "broken".

Via phpMyAdmin, I located the mysql database's 2 tables "search_index" and "search_total" and deleted both table's contents, but did NOT remove the tables. I deleted my cron job and set it back up again.

Then I simply loaded http://site.tld/cron.php and everything was indexed and finally searchable.