Hi Scott, if your search tables are that big, then Drupal is unlikely to perform well with it's native search. MySQL will be burned managing those large tables and slow your entire Drupal site down. I suggest you segment your load by using an external search engine like Apache Solr, http://drupal.org/project/apachesolr. This is what we use on Drupal.org.
If you don't have the ability to quickly set-up Solr in a Java environment, you can create a free 30 day subscription at Acquia.com to try hosted Apache Solr search. Installation instructions are here: http://acquia.com/documentation/acquia-search/activation . This would allow you to reduce your DB size, and get higher quality search.
Cheers, Kieran
On Wed, Feb 24, 2010 at 1:45 AM, Scott scott@bscottholmes.com wrote:
I have a site that has become too large to effectively use the backup and Migrate module. I've just finished updating the site from my development platform and in order to migrate the latest version of the database I had to exclude the search_index table from the backup. To get around this I did backup the search_index table using phpmyadmin and importing it separately. Neither drupal nor phpmyadmin would restore the entire database as a single file. Does anyone have any recommendations to improve this situation?
Thanks in advance, Scott
-- [ Drupal support list | http://lists.drupal.org/ ]