Reindex with erase

Re: Reindex with erase

damiancds — Tue, 06 Apr 2010 18:28:34 +0300

great, thanks for the quick reply,

I just ran the reindexing, and my computer didn't blow up,

thanks,

Re: Reindex with erase

Willy — Tue, 06 Apr 2010 17:49:05 +0300

replace it with a

Re: Reindex with erase

damiancds — Tue, 06 Apr 2010 16:59:09 +0300

I hate to bring up an old topic, but looking at the code, there's smileys in it which I doubt is syntactically correct.

Instead of the smiley, what goes there, just a ")" ?

I'm not really sure and I don't want to go corrupting my databases on a guess,

thanks to anyone who catches this,

Re: Reindex with erase

Tec — Fri, 19 Dec 2008 13:16:56 +0200

Site individual 'Erase & Re-index' is enabled by Sphider-plus

Tec

Re: Reindex with erase

Willdk — Fri, 19 Dec 2008 12:21:15 +0200

ok. thanks for the info, Tec. reindexing with erase is like a couple days of work in my case.

Re: Reindex with erase

Tec — Fri, 19 Dec 2008 10:46:13 +0200

Also table contents of 'categories' and 'query log' remain untouched.

Tec

Re: Reindex with erase

Willy — Fri, 19 Dec 2008 10:06:57 +0200

Yes, it'll empty all the tables except for the ones containing the site(s).

Re: Reindex with erase

Willdk — Fri, 19 Dec 2008 09:25:13 +0200

I don't understand how this mod will treat the database. The size of my database is more than 400 mb, so I'm a bit scared to mess up this.

If you choose "Reindex all with erase" the tables will be emptied, therefore 400 mb gone?

Re: Reindex with erase

mdekok3000 — Fri, 25 Jan 2008 20:49:39 +0200

Thanks

Re: Reindex with erase

Anonymous User — Wed, 13 Jun 2007 01:10:35 +0300

Excellent.

Reindex with erase

Tec — Sat, 19 May 2007 08:14:11 +0300

Sphider's Reindex detects MD5 checksum changes at the sites you indexed before. But it dosn't recocnize changes you did in admin section. In order to solve this, here is a solution truncating the required tables of your database before reindexing.

Install a new script into folder ./admin/ which is called erase.php with the following content:

include "auth.php";
$settings_dir = "../settings";
include "$settings_dir/conf.php";

$erase =array ("domains","keywords","links","link_keyword0","link_keyword1","link_keyword2","link_keyword3","link_keyword4","link_keyword5","link_keyword6","link_keyword7","link_keyword8","link_keyword9","link_keyworda","link_keywordb","link_keywordc","link_keywordd","link_keyworde","link_keywordf","pending");
foreach ($erase as $allthis){
mysql_query ("TRUNCATE `".$mysql_table_prefix."$allthis`");
echo mysql_error();
}

print "
Erasing done

";

?>

Okay, now reindex all

Return to admin without reindex

Now open /admin/admin.php and search for:

Reindex all

After this, place a new row with this content:

Reindex all with erase

Ready. In admin section "Sites" now you will find a new item called "Reindex with erase". Use this to do an index after you changed admin settings.

Tec