I am trying to switch servers and getting this error when importing my existing MySQL database to the new server:

--------------
ALTER TABLE `core_search_index`
  ADD PRIMARY KEY (`index_id`),
  ADD UNIQUE KEY `object` (`index_class`(240),`index_object_id`),
  ADD KEY `index_hidden` (`index_hidden`),
  ADD KEY `index_prune` (`index_item_id`,`index_date_updated`),
  ADD KEY `index_class_and_object_id` (`index_class`(240),`index_object_id`),
  ADD KEY `index_class_type_id_hash` (`index_class_type_id_hash`),
  ADD KEY `index_club_id` (`index_club_id`),
  ADD KEY `container` (`index_class`(230),`index_container_id`,`index_date_commented`),
  ADD KEY `author_posted_in` (`index_author`,`index_item_index_id`),
  ADD KEY `index_date_updated` (`index_date_updated`,`index_date_commented`),
  ADD KEY `index_date_created` (`index_date_created`,`index_date_commented`),
  ADD KEY `index_date_commented` (`index_date_commented`,`index_date_updated`),
  ADD KEY `index_stream` (`index_class`(219),`index_item_id`,`index_date_commented`,`index_date_updated`),
  ADD KEY `author_lookup` (`index_author`,`index_class`(209),`index_hidden`,`index_date_updated`,`index_date_commented`),
  ADD KEY `index_item_author` (`index_item_author`,`index_date_commented`),
  ADD KEY `followed_content` (`index_class`(227),`index_is_last_comment`,`index_hidden`,`index_date_commented`,`index_date_updated`),
  ADD KEY `item` (`index_class`(238),`index_item_id`,`index_is_last_comment`)
--------------

ERROR 1114 (HY000) at line 1518696: The table 'core_search_index' is full

Any hints on what to do?

It looks like you've run out of disk-space to me.

I believe I figured out the issue. My server was running daily backups, unbeknownst to me, and the diskspace ran out. So, it was a diskspace issue. I deleted the files causing the excessive diskspace problem, freeing up the diskspace, then I reimported the MySQL dump without the error.

Glad to see that it has been solved.

Edited March 3Mar 3 by Miss_B