My searchcore table is missing...

[Phaedrus]

It just disappeared. Can anybody tell me a command string or something I can use to rebuild it then I can run a search index? Please tell me this is repairable!

[Dave]

If the table is literally gone then it might be a better option to restore it from a backup.
If you don't have any backups then I'm afraid you can't restore the contents of the table and you have to create the table without any contents.

[Phaedrus]

I don't mind creating that particular table with no contents. My backups are what I used to get this far...

--------------- Added 1479073433 at 1479073433 ---------------

I just need to know what I need to do to create that table. Once I am done reindexing the search should repopulate that particular table. It's one of the tables that is truncated when you do a rebuild of the search index.

[Dave]

So you only need the "searchcore" table and not "searchcore_text"?
This should work:

CREATE TABLE searchcore (
searchcoreid INT UNSIGNED NOT NULL AUTO_INCREMENT,
contenttypeid INT UNSIGNED NOT NULL,
primaryid INT UNSIGNED NOT NULL,
groupcontenttypeid INT UNSIGNED NOT NULL,
groupid INT UNSIGNED NOT NULL DEFAULT 0,
dateline INT UNSIGNED NOT NULL DEFAULT 0,
userid INT UNSIGNED NOT NULL DEFAULT 0,
username VARCHAR(100) NOT NULL,
ipaddress INT UNSIGNED NOT NULL,
searchgroupid INT UNSIGNED NOT NULL,
PRIMARY KEY (searchcoreid),
UNIQUE KEY contentunique (contenttypeid, primaryid),
KEY groupid (groupcontenttypeid, groupid),
KEY ipaddress (ipaddress),
KEY dateline (dateline),
KEY userid (userid),
KEY searchgroupid (searchgroupid)
) ENGINE=MyISAM

[Phaedrus]

That worked, site is not throwing a dbase error with each post and I am rebuilding the search index.

THANK YOU!

[Lynne]

I would suggest talking to your host about how this could have happened. Imagine if it happened to your user or post table. That would be very, very serious!

[Phaedrus]

Indeed. The innodb got corrupted then by backups were messed up... It took a while to figure out how to get as far as I did. It was quite annoying.

[Paul M]

I dont rely on host backups, I take my own.

[Phaedrus]

I dont rely on host backups, I take my own.

my own were also compromised due to missing tables.

[Paul M]

Then you need to take a look at how you are taking them, you should not be missing any tables in a backup.