473,703 Members | 2,808 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to create fulltext indexes in MySQL 3.23.58?

Retracing my problem leads me to believe I never successfully created
fulltext indexes for MySQL 3.23.58 MyISAM tables. I went to the MySQL
manual and was able - or so I thought - to create them, however, my
fulltext search queries fail in 3.23.58 but the exact queries (with
same data) work perfectly in 4.0.10.

Expand|Select|Wrap|Line Numbers
  1. -- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
  2. --    File: INDEXES.SQL
  3. --    Created: 6/29/2004
  4. --    Modified: 6/29/2004
  5. --    Purpose: Create IVC table indexes
  6. --    Dependencies: MySQL 3.23+ Database
  7. --    Privacy Scope: SQL file.  Be sure to render lockdown on /sql folder
  8. to prevent viewing/downloading of this script
  9. -- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------*/
  10.  
  11. ALTER TABLE image ADD INDEX ix_image_path (image_path);
  12. ALTER TABLE image ADD FULLTEXT ix_search (image_name, image_alt,
  13. image_location_city, image_location_state, image_location_country);
  14.  
  15. ALTER TABLE album ADD INDEX ix_album_name (album_name);
  16.  
  17. ALTER TABLE department ADD INDEX ix_department_name (department_name);
  18. ALTER TABLE department ADD INDEX ix_department_parent_id
  19. (department_parent_id);
  20.  
  21. ALTER TABLE person ADD INDEX ix_department_id (department_id);
  22. ALTER TABLE person ADD FULLTEXT ix_search (first_name, last_name);
  23.  
  24. ALTER TABLE keyword ADD FULLTEXT ix_search (keyword_name);
  25.  
  26. ALTER TABLE event ADD FULLTEXT ix_search (event_name);
  27.  
  28. ALTER TABLE placement ADD FULLTEXT ix_search (placement_name);
  29.  
This results in what I thought would be fulltext indexes for each
table called "ix_search" but what it creates are indexes with COMMENTS
of "fulltext", not INDEX_TYPE of "FULLTEXT".

Could someone show me how to do this right for 3.23.58?

Thanx
Phil
Jul 20 '05 #1
0 1873

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
4011
by: Phil Powell | last post by:
Relevancy scores are normally defined by a MySQL query on a table that has a fulltext index. The rules for relevancy scoring will exclude certain words due to their being too short (minimum default is 4 letters). This is the Fed. Everything is a TLA (three-letter acronym). Therefore, since I'm building a PORTABLE web application, changing MySQL's default settings for fulltext index querying is completely undoable and unrealistic, so...
0
5767
by: Phil Powell | last post by:
The table already has a fulltext index and from there I can use the MySQL fulltext search query to get results as well as the relevancy score. The problem I have is that MySQL has a default setting whereby the minimum amount of characters is 4 for a search. Being that we're government and full of TLA (three-letter acronyms), that is not practical, and furthermore, the app I'm building must be fully portable, so having MySQL tweaked...
0
1462
by: Henry Hank | last post by:
Environment: I'm setting up a database server on a Dell Poweredge 2650, dual 1.8GHZ pentium with 1GB of memory and RAID5 drives. I've installed RedHat 9, and updated the kernel to 2.4.20-19.9smp. I've installed the RPM binary distribution of MySQL 4.0.14 right from the MySQL website. The only thing I have done is disable InnoDb in my my.cnf file. Database Table: I have a database with 21.4 million records. One field is a VARCHAR(255)...
0
1356
by: Chris Nolan | last post by:
Hi all, I was wondering, does anyone know if there are any plans to add FULLTEXT indexes to the almighty InnoDB such that it catches up with the funky MyISAM in terms of things you can pass to ALTER TABLE? Regards, Chris
0
1443
by: Pete | last post by:
Hi, I'm building a new database and I will need a search engine for it. I wonder if it would be ok if the database contains two fulltext indexes. It's because my database will contain English document and French document.
0
476
by: Phil Powell | last post by:
Retracing my problem leads me to believe I never successfully created fulltext indexes for MySQL 3.23.58 MyISAM tables. I went to the MySQL manual and was able - or so I thought - to create them, however, my fulltext search queries fail in 3.23.58 but the exact queries (with same data) work perfectly in 4.0.10. --...
0
1420
by: Robert Oschler | last post by:
I read a while back that MySQL will only use one index per query. (If this is not so, please tell me and point me to a doc that gives a good explanation of MySQL's current index usage policy). I'm using MySQL 4.2.x. Here's my dilemma. 1) --------- I have two tables that have records with a FULLTEXT index text field in each of them. The problem is the relationship between the tables is a
1
2417
by: Robert Oschler | last post by:
I read a while back that MySQL will only use one index per query. (If this is not so, please tell me and point me to a doc that gives a good explanation of MySQL's current index usage policy). I'm using MySQL 4.2.x. Here's my dilemma. 1) --------- I have two tables that have records with a FULLTEXT index text field in each of them. The problem is the relationship between the tables is a
0
2177
by: Roger Felstree | last post by:
Hi, I'm using MySQL v5.0 and we currently have a database containing several tables with Full Text indexes. Some of these tables contain ~800,000 records of >500Kb text. While the majority of queries are selects - when we need to do Inserts to these tables they are becoming horrendously slow. If I set up an additional server - is it possible to set up a replication partnership so that the fulltext index is only present on the slave?...
0
1033
by: AQSAPFI | last post by:
Hi, I have a problem restoring a Read-Only filegroup in a database. I've restored the Read/Write filegroups first without any problem. Then, I am able to recover Read-Only filegroups which do not contain fulltext indexes with the command : RESTORE DATABASE GSM FILEGROUP = 'FG_RO_20080214' WITH RECOVERY However, for filegroups containing FullText indexes (Fulltext indexes are in the same filegroup as data used for this index), I...
0
8739
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8654
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9089
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
7832
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6575
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5910
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4412
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4668
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
3
2037
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.