RE: problems creating fulltext index

-Original Message- From: Salada, Duncan [mailto:[EMAIL PROTECTED]] Sent: 28. januar 2003 20:40 To: '[EMAIL PROTECTED]' Subject: problems creating fulltext index Hello everyone, I'm running Ver 8.39 Distrib 4.0.9-gamma, for intel-linux on i686. I'm trying to create a

RE: Mysqlhotcopy and reuilding indexes

-Original Message- From: Harald Fuchs [mailto:[EMAIL PROTECTED]] Sent: 28. januar 2003 10:46 To: [EMAIL PROTECTED] Subject: Re: Mysqlhotcopy and reuilding indexes In article [EMAIL PROTECTED], Erlend Hopsø Strømsvik [EMAIL PROTECTED] writes: Hi Sorry if I'm just being

Mysqlhotcopy and reuilding indexes

Hi Sorry if I'm just being feeble minded here but I can't get this to work. First I take a copy of my database using: mysqlhotcopy --allowold --noindices db_name /path/path using the '--noindices' since it says --noindices Don't include full index files in copy to make the backup smaller and

MySQL fulltext. Question about the stopword list

Hi I'm currently using MySQL (4.0.4 recompiled) as our database for storing information about books. There are about 1.5mill book titles + other information in the database now. The fulltext search capabilities of MySQL have turned out to become very good with the 4+ version and with a little

RE: fulltext, trying to index 2 character words

Just a small comment to this thread: If you follow this link you'll see that you are searching on two words which both are only two chars long. Just press the 'søk' bottom and you will be doing a search on the booktitles, in a database containing 1.4mill books, running Mysql 4.0.4-beta. I

How to rebuild indexes..

It says in the manual .. recompile MySQL, and rebuild your FULLTEXT indexes First time I downloaded the source code and compiled it, I just deleted the old indexes and created new ones. But now I have a lot of tables with fulltext indexes. So I'm looking for an easy way to do it. Searched

RE: protecting CC numbers

One other thing.. If something goes wrong or some costumers complain about being charged without their request etc. the credit card companies can come after you. And if they are able to prove that you have not done everything you should to keep the CC information secure and that your routines

RE: MySQL Backup

-Original Message- From: Tom McCay (Ramesys - Nottingham) [mailto:[EMAIL PROTECTED]] Sent: 3. september 2002 11:59 To: [EMAIL PROTECTED] Subject: MySQL Backup Hi, can someone point me in the right direction please regarding backing up a MySQL database using Veritas 8.6 on a

RE: MySQL Backup

I usually just copy the complete DB directory from one computer to another one. With fast ethernet it takes around 5-10 minutes (30 minutes if I have to backup the table where I store images). Only thing is that mysql can't write to the table currently being copied. But that's

RE: fulltext searching

I've never gotten the boolean features to work with version 4.0.1-alpha of MySQL. Also the database will crash with some queries where some of the search words are the same as words in the stopword list (myisam/ft_static.c in the sourcecode) Download the 4.0.2 source and compile it. Things

RE: MYSQL 4.0

Hi I'm running MySQL 4.0.2 compiled from the source tree on this site: www.gnist.no (The largest online bookstore in Norway) Used 4.0.1 earlier but that version had some small problems with fulltext search. Server version: 4.0.2-alpha-log Uptime: 2 days 12 hours 40 min

Question about compiling mysql-source

Hi I've got MySQL-4.0.1-2.i386.rpm installed on a PC here. But I would like to do some changes to the fulltext search. Since I have to compile from source to be able to change the stopword, can I make it so that I only have to replace the old mysqld executable? ( downloaded

Mysql text search and fulltext

(first some info and 'things that I want', then a few questions) Hi I'm actually using MySQL 4.0.1-alpha in a production system now. Only using MyISAM tables. ( http://www.gnist.no ) The only problem I have is that sometimes the database crash with some fulltext searches... And with only some

Mysql 4.0.1 crashing in fulltext search with some words..

I'm not sure if this has been reported earlier, but my mysql-server goes down if I run a query with two 'match against' where one of them contains/matches the word 'think'... It terminates after the first query, but when I change the word 'think' to 'excel' or any other word it works flawlessy.

MySQL crashes is fulltext search on with some words.

I'm not sure if this has been reported earlier, but my mysql-server goes down if I run a query with two 'match against' where one of them contains/matches the word 'think'... It terminates after the first query, but when I change the word 'think' to 'excel' or any other word it works flawlessy.