Hi,
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?
If so, are there any problems with switching from a table type of InnoDB to MyISAM? Or am I possibly barking up the complete wrong tree here? (Is the "Search" button on MediaWiki supposed to return fulltext results from the get-go?)
Thanks for pointers. I am going to continue to research this on my own, but figure someone on here can at least tell me if I'm looking in the right direction.
Andrew
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)
mediawiki-l@lists.wikimedia.org