Re: REPOST: FULLTEXT searching help needed. Please somebody help.

2003-06-13 Thread Sergei Golubchik
Hi! On Jun 13, H M Kunzmann wrote: > The answer is that a fulltext index can only be built on > a TEXT field. Even though the mysql documentation describes > MEDIUMTEXT and LONGTEXT fields as 'BLOB or TEXT field that can hold..', > they can not be used. No, this is wrong. Any xxxTEXT field can be

Re: REPOST: FULLTEXT searching help needed. Please somebody help.

2003-06-13 Thread H M Kunzmann
The answer is that a fulltext index can only be built on a TEXT field. Even though the mysql documentation describes MEDIUMTEXT and LONGTEXT fields as 'BLOB or TEXT field that can hold..', they can not be used. On Thu, 2003-06-05 at 09:59, H M Kunzmann wrote: > Hello All. > > I am using Redhat

Re: REPOST: FULLTEXT searching help needed. Please somebody help.

2003-06-05 Thread H M Kunzmann
> > When mysql is indexing You can check your data file direcory and You > > ca see that one file (the index) is growing in size. > I see it grow up to 8M and it stays there. Watching this, it grows very slowly. After 5 minutes of indexing, the file size has barely hit 2MB. > > The command I use

Re: REPOST: FULLTEXT searching help needed. Please somebody help.

2003-06-05 Thread H M Kunzmann
> I think your index is corrupted because I expect a 1.5 GB index and not 8M! > You can see word list wit a utility (sorry I don't remember te name ft_dump). I agree with this :-) > I suggest You to drop fulltext index, duplicate database and remove > some rrecords. > Then create index index aga

RE: REPOST: FULLTEXT searching help needed. Please somebody help.

2003-06-05 Thread electroteque
help needed. Please somebody help. I think your index is corrupted because I expect a 1.5 GB index and not 8M! You can see word list wit a utility (sorry I don't remember te name ft_dump). I suggest You to drop fulltext index, duplicate database and remove some rrecords. Then create index

Re: REPOST: FULLTEXT searching help needed. Please somebody help.

2003-06-05 Thread Santino
I think your index is corrupted because I expect a 1.5 GB index and not 8M! You can see word list wit a utility (sorry I don't remember te name ft_dump). I suggest You to drop fulltext index, duplicate database and remove some rrecords. Then create index index again. Some questions: Do You have d

REPOST: FULLTEXT searching help needed. Please somebody help.

2003-06-05 Thread H M Kunzmann
Hello All. I am using Redhat 9.0 with MySQL 4.0.12-0. I've hit something of a dead-end with fulltext searching and I don't know where to look next. I have a table that is about 1.5GB with about 400 records. As you can tell, every record is about 4MB, all of which is text. I've created a fullte

Re: Query help needed please

2003-03-21 Thread Bruce Feist
Charles Kline wrote: I am fairly new to SQL and this is a really complex query for me. Possibly more complex than necessary. Must you have a separate column for each of the areas? If you don't mind having them all in a single column, the query becomes simple and efficient: SELECT p.fname, p.lna

Query help needed please

2003-03-21 Thread Charles Kline
Hi all, I am fairly new to SQL and this is a really complex query for me. Here is the setup. 3 tables. tbl_personnel, tbl_personnel_dras, tbl_dra each person in the tbl_personnel table can have 0 - 3 records in the tbl_personnel_dras table. The tbl_personnel_dras table is just the person_id (fro

re: RE: MySQL Help Needed Please

2003-01-06 Thread Egor Egorov
On Sunday 05 January 2003 09:08, Anton Zavrin wrote: > Well, I read, played around and updated it (I guess) > Now, when I try to start mysql with this command (same as before), it > gives me that: > # /usr/local/bin/safe_mysqld --user=mysql & > [1] 71491 > # Starting mysqld daemon with databases f

Re: MySQL Help Needed Please

2003-01-05 Thread Stefan Hinz, iConnect \(Berlin\)
<[EMAIL PROTECTED]> To: "'Stefan Hinz, iConnect (Berlin)'" <[EMAIL PROTECTED]>; "'Thomas Spahni'" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, January 05, 2003 8:08 AM Subject: RE: MySQL Help Needed Please Well, I read,

RE: MySQL Help Needed Please

2003-01-04 Thread Anton Zavrin
Saturday, January 04, 2003 2:14 PM To: Anton Zavrin; 'Thomas Spahni' Cc: [EMAIL PROTECTED] Subject: Re: MySQL Help Needed Please Anton, >ps -ef | grep mysqld >got nothing Because the MySQL SERVER isn't running! >Though I can do: ># mysql -u root -p With this command,

Re: MySQL Help Needed Please

2003-01-04 Thread Stefan Hinz, iConnect \(Berlin\)
t (Berlin)'" <[EMAIL PROTECTED]>; "'Thomas Spahni'" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, January 04, 2003 9:59 PM Subject: RE: MySQL Help Needed Please Did: ps -ef | grep mysqld got nothing Though I can do: # mysql -u root -p E

RE: MySQL Help Needed Please

2003-01-04 Thread Anton Zavrin
Connect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 04, 2003 8:01 AM To: Anton Zavrin; 'Thomas Spahni' Cc: [EMAIL PROTECTED] Subject: Re: MySQL Help Needed Please Anton, first thing, try: ps [whatever options] | grep mysqld The daemon (database server) is called my

Re: MySQL Help Needed Please

2003-01-04 Thread Stefan Hinz, iConnect \(Berlin\)
70948-0 Fax: +49 30 7970948-3 - Original Message - From: "Anton Zavrin" <[EMAIL PROTECTED]> To: "'Thomas Spahni'" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, January 04, 2003 9:01 AM Subject: RE: MySQL Help Needed Please > I

RE: MySQL Help Needed Please

2003-01-04 Thread Anton Zavrin
ailto:[EMAIL PROTECTED]] Sent: Friday, January 03, 2003 7:01 AM To: Anton Zavrin Cc: [EMAIL PROTECTED] Subject: Re: MySQL Help Needed Please Anton, check the .err and .log files in your data directory. Then check permissions. My sock file looks like: srwxrwxrwx1 mysqldaemon 0 Dez

Re: MySQL Help Needed Please

2003-01-03 Thread Thomas Spahni
Anton, check the .err and .log files in your data directory. Then check permissions. My sock file looks like: srwxrwxrwx1 mysqldaemon 0 Dez 30 19:12 mysql.sock and finally check for your socket= /tmp/mysql.sock entries in /etc/my.cnf and ~/.my.cnf Thomas Spahn

MySQL Help Needed Please

2003-01-03 Thread Anton Zavrin
Hi guys, I'm new here and need help. I'm installing MySQL on FreeBSD 4.7. I actually had/have MySQL installed but when I'm trying to run it says: error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' ex

RE: Help Needed Please

2001-08-27 Thread Don Read
On 26-Aug-2001 [EMAIL PROTECTED] wrote: > Hi > > I need to set the max_allowed_packet to 16M. below is my > 01mysql-server.sh file. I use DBI and I know that I have to start this > before the DBI program and I did but if I use ./mysqld --help it shows > that my max_allowed_packet is still 1M. An

Re: Help Needed Please

2001-08-27 Thread Martin Mokrejs
Hi, use "mysqladmin variables" command to see current settings. I guess your mysqld does not read the config file you have edited. ;-) It happened to me me also few days ago. Remember mysqld looks for /etc/my.cnf and $DATADIR/var/my.cnf if I remember well. Maybe put the path to config file just

Help Needed Please

2001-08-26 Thread training88
Hi I need to set the max_allowed_packet to 16M. below is my 01mysql-server.sh file. I use DBI and I know that I have to start this before the DBI program and I did but if I use ./mysqld --help it shows that my max_allowed_packet is still 1M. Any help would be really great since I've been working