Mailing List Archive

On Nov 27, 2004, at 5:24 PM, Andrew Reberry wrote:
> I would really like full text indexing to be installed so advanced
> searching
> would be possible. However, the database dump I used has the table
> 'cur' as
> a table type of 'InnoDB'. If I'm not mistaken, fulltext indexes can
> only be
> created on tables of type MyISAM, correct?

The fulltext index is on the 'searchindex' table.

If you've imported text from one of the Wikipedia dumps, you'll need to
regenerate the searchindex entries with rebuildtextindex.php (in the
maintenance directory).

-- brion vibber (brion @ pobox.com)

Thanks Brion. I will have to look into this and it would seem I was barking
up the wrong tree.

Andrew



-----Original Message-----
From: mediawiki-l-bounces@Wikimedia.org
[mailto:mediawiki-l-bounces@Wikimedia.org] On Behalf Of Brion Vibber
Sent: Saturday, November 27, 2004 6:47 PM
To: MediaWiki announcements and site admin list
Subject: Re: [Mediawiki-l] Enabeling Full Text Searching

On Nov 27, 2004, at 5:24 PM, Andrew Reberry wrote:
> I would really like full text indexing to be installed so advanced
> searching
> would be possible. However, the database dump I used has the table
> 'cur' as
> a table type of 'InnoDB'. If I'm not mistaken, fulltext indexes can
> only be
> created on tables of type MyISAM, correct?

The fulltext index is on the 'searchindex' table.

If you've imported text from one of the Wikipedia dumps, you'll need to
regenerate the searchindex entries with rebuildtextindex.php (in the
maintenance directory).

-- brion vibber (brion @ pobox.com)

Hi wonderfull wikimedia world

Le Dimanche 28 Novembre 2004 02:46, Brion Vibber a écrit :
> On Nov 27, 2004, at 5:24 PM, Andrew Reberry wrote:
> > I would really like full text indexing to be installed so advanced
> > searching
.../...
> The fulltext index is on the 'searchindex' table.
>
> If you've imported text from one of the Wikipedia dumps, you'll need to
> regenerate the searchindex entries with rebuildtextindex.php (in the
> maintenance directory).
>
> -- brion vibber (brion @ pobox.com)
>

First i want to thanks you for that incredibly nice wikimedia.

I have a local installation, rebuild with the french-text-dump.sql
and it works fine . As i need full text search (for the moment i htdig a
local static dump ;) I try to use the "rebuildtextindex.php" but it
does'nt works (at least the way i want;)

when i click on
http://localhost/pedia/maintenance/rebuildtextindex.php
it says :
This script must be run from the command line

hmm, well. How do i run that from command line ?
(i have mediawiki-1.3.8 on sarge)

regards
Alain (Dakar)

On Dec 2, 2004, at 9:43 AM, Baeckeroot alain wrote:
> when i click on
> http://localhost/pedia/maintenance/rebuildtextindex.php
> it says :
> This script must be run from the command line

Trust me, this is good. You wouldn't want just anybody on the internet
to rebuild your search index whenever they feel like it. :)

> hmm, well. How do i run that from command line ?
> (i have mediawiki-1.3.8 on sarge)

Something like:
cd /var/www/html/pedia/maintenance
php rebuildtextindex.php

(depending on packaging, you might need to say 'php4' or 'php4-cli' or
something silly instead of just 'php')

As an extra precaution, you must create an AdminSettings.php before
running any of the maintenance scripts. See AdminSettings.sample for a
sample.

-- brion vibber (brion @ pobox.com)