Re: REPOST: FULLTEXT searching help needed. Please somebody help.
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 used in FULLTEXT index. TEXT, MEDIUMTEXT, LONGTEXT, TINYTEXT - they all work. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: REPOST: FULLTEXT searching help needed. Please somebody help.
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 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 fulltext index on the table, with
> > alter table table2002 add fulltext data (data);
> After this is done (takes about 20 minutes to do) I check
> out the index size, which is 8,722 KB...
>
> If I do a fulltext search against this table, it takes about
> 1.5 minutes.
> > select filename from table2002 where match(data) against ('whatever')
>
> If I do an explain on my query, it confirms that the index is used
> +--+-+-++---+---++---+
> |table |type |possible_keys|key |key_len|ref|rows|extra |
> +--+-+-++---+---++---+
> |table2002 |fulltext |data |data| 0| | 1 |using where|
> +--+-+-++---+---++---+
>
> I have another table, sized at only about 50MB, which I use the same
> query and index on, which takes less than a second to do. One thing I
> have noticed, is that the index size on this much smaller table is
> larger than the bigger table (about 9MB).
>
> This is a shot in the dark, but it seems to me that the index size is
> _way_ too small and as such obviously cannot really help. If this is the
> case, how do I increase it ?
>
> Here are some of my mysql settings:
> max_sort_length=16M
> table_cache=256M
> key_buffer=128M
> sort_buffer=4M
> read_buffer_size=1M
>
> Should I set anything else ?
> What can I do to get respectable return times ?
>
> Please lend me a helping hand...
> Thanks in advance.
> H M Kunzmann
--
Herbert Michael Kunzmann
Binary Chaos Magician
signature.asc
Description: This is a digitally signed message part
Re: REPOST: FULLTEXT searching help needed. Please somebody help.
> > 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 is: > > create fulltext index Name on Table(field) > So far I've only used the alter table call... I will use this call > next and see if I get any problems. I've used the create index call now, as described above, and it does not change anything. The index still only grows to 8MB. > I've read something of MySQL 4.0.12-0 having a fulltext index bug that > converts text into char. (MySQL documentation in MySQL 4.0.13-0 docs > describes this in a bug fix entry. Perhaps this is a symptom ? > I am busy downloading the newer version to find out. No change. > Can your system handle files larger than 2GB? Maybe this is the problem. Can anyone give me any indication as to whether this may be the case ? Should I load the kernel that supports bigger filesystems ? Thanks for all help Ciao H M Kunzmann signature.asc Description: This is a digitally signed message part
Re: REPOST: FULLTEXT searching 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 agree with this :-) > I suggest You to drop fulltext index, duplicate database and remove > some rrecords. > Then create index index again. I've done this a couple of times already with the same result. > Some questions: > Do You have disk space to index? I have 22GB free. > Can your system handle files larger than 2GB? I'm not sure. Perhaps not with my current kernel. I am using the standard RH9 kernel. > 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. > The command I use is: > create fulltext index Name on Table(field) So far I've only used the alter table call... I will use this call next and see if I get any problems. I've read something of MySQL 4.0.12-0 having a fulltext index bug that converts text into char. (MySQL documentation in MySQL 4.0.13-0 docs describes this in a bug fix entry. Perhaps this is a symptom ? I am busy downloading the newer version to find out. Thank you for your help. I'll get back to you on whether any of the above helped. signature.asc Description: This is a digitally signed message part
RE: REPOST: FULLTEXT searching help needed. Please somebody help.
create fulltext index Name on Table(field) i didnt get this
i usually do add fulltext field (field) i think , is that wrong ??
-Original Message-
From: Santino [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 05, 2003 6:14 PM
To: [EMAIL PROTECTED]
Subject: Re: REPOST: FULLTEXT searching 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 index again.
Some questions:
Do You have disk space to index?
Can your system handle files larger than 2GB?
When mysql is indexing You can check your data file direcory and You
ca see that one file (the index) is growing in size.
The command I use is:
create fulltext index Name on Table(field)
I have some tables with about 300.000 records (about 2k each) and all
works fine:
I rebuild index in minutes and the query needs only 1 or 2 seconds.
Santino
At 9:59 +0200 5-06-2003, H M Kunzmann wrote:
>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 fulltext index on the table, with
>> alter table table2002 add fulltext data (data);
>After this is done (takes about 20 minutes to do) I check
>out the index size, which is 8,722 KB...
>
>If I do a fulltext search against this table, it takes about
>1.5 minutes.
>> select filename from table2002 where match(data) against ('whatever')
>
>If I do an explain on my query, it confirms that the index is used
>+--+-+-++---+---++---+
>|table |type |possible_keys|key |key_len|ref|rows|extra |
>+--+-+-++---+---++---+
>|table2002 |fulltext |data |data| 0| | 1 |using where|
>+--+-+-++---+---++---+
>
>I have another table, sized at only about 50MB, which I use the same
>query and index on, which takes less than a second to do. One thing I
>have noticed, is that the index size on this much smaller table is
>larger than the bigger table (about 9MB).
>
>This is a shot in the dark, but it seems to me that the index size is
>_way_ too small and as such obviously cannot really help. If this is the
>case, how do I increase it ?
>
>Here are some of my mysql settings:
>max_sort_length=16M
>table_cache=256M
>key_buffer=128M
>sort_buffer=4M
>read_buffer_size=1M
>
>Should I set anything else ?
>What can I do to get respectable return times ?
>
>Please lend me a helping hand...
>Thanks in advance.
>H M Kunzmann
>
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: REPOST: FULLTEXT searching 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 index again.
Some questions:
Do You have disk space to index?
Can your system handle files larger than 2GB?
When mysql is indexing You can check your data file direcory and You
ca see that one file (the index) is growing in size.
The command I use is:
create fulltext index Name on Table(field)
I have some tables with about 300.000 records (about 2k each) and all
works fine:
I rebuild index in minutes and the query needs only 1 or 2 seconds.
Santino
At 9:59 +0200 5-06-2003, H M Kunzmann wrote:
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 fulltext index on the table, with
alter table table2002 add fulltext data (data);
After this is done (takes about 20 minutes to do) I check
out the index size, which is 8,722 KB...
If I do a fulltext search against this table, it takes about
1.5 minutes.
select filename from table2002 where match(data) against ('whatever')
If I do an explain on my query, it confirms that the index is used
+--+-+-++---+---++---+
|table |type |possible_keys|key |key_len|ref|rows|extra |
+--+-+-++---+---++---+
|table2002 |fulltext |data |data| 0| | 1 |using where|
+--+-+-++---+---++---+
I have another table, sized at only about 50MB, which I use the same
query and index on, which takes less than a second to do. One thing I
have noticed, is that the index size on this much smaller table is
larger than the bigger table (about 9MB).
This is a shot in the dark, but it seems to me that the index size is
_way_ too small and as such obviously cannot really help. If this is the
case, how do I increase it ?
Here are some of my mysql settings:
max_sort_length=16M
table_cache=256M
key_buffer=128M
sort_buffer=4M
read_buffer_size=1M
Should I set anything else ?
What can I do to get respectable return times ?
Please lend me a helping hand...
Thanks in advance.
H M Kunzmann
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
REPOST: FULLTEXT searching help needed. Please somebody help.
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 fulltext index on the table, with
> alter table table2002 add fulltext data (data);
After this is done (takes about 20 minutes to do) I check
out the index size, which is 8,722 KB...
If I do a fulltext search against this table, it takes about
1.5 minutes.
> select filename from table2002 where match(data) against ('whatever')
If I do an explain on my query, it confirms that the index is used
+--+-+-++---+---++---+
|table |type |possible_keys|key |key_len|ref|rows|extra |
+--+-+-++---+---++---+
|table2002 |fulltext |data |data| 0| | 1 |using where|
+--+-+-++---+---++---+
I have another table, sized at only about 50MB, which I use the same
query and index on, which takes less than a second to do. One thing I
have noticed, is that the index size on this much smaller table is
larger than the bigger table (about 9MB).
This is a shot in the dark, but it seems to me that the index size is
_way_ too small and as such obviously cannot really help. If this is the
case, how do I increase it ?
Here are some of my mysql settings:
max_sort_length=16M
table_cache=256M
key_buffer=128M
sort_buffer=4M
read_buffer_size=1M
Should I set anything else ?
What can I do to get respectable return times ?
Please lend me a helping hand...
Thanks in advance.
H M Kunzmann
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Query help needed please
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.lname, w.web_link, a.dra_id, a.area FROM tbl_personnel p LEFT JOIN tbl_personnel_weblinks w ON p.id=w.person_id LEFT JOIN tbl_personnel_dras a ON p.id = a.person_id LEFT JOIN tbl_dra dra ON a.dra_id = dra.id; If you must have the separate columns for each area, let me know. I'm pretty sure it can still be done, but it will be *ugly*. Basically, you'll have to join three more copies of the tbl_dra and tbl_personnel_dras tables, something like what you have below, but with left joins instead... and then put in a condition saying that dra1.id > dra2.id > dra3.id > dra4.id, but modify it to allow NULLs for dra4.id or dra3.id and dra4.id or dra2.id, dra3.id, and dra4.id, or all four of them. Like I said, *ugly*. Bruce Feist 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 (from tbl_personnel) and an area_id that corresponds to the field 'id' in tbl_dra. I am trying to display the person record with all of the areas (by name) that are associated with them. here is what I have so far. SELECT DISTINCT p.fname, p.lname, w.web_link, a1.dra_id, a2.dra_id, a3.dra_id, dra1.area as areaa, dra2.area as areab, dra3.area as areac FROM tbl_personnel p, tbl_personnel_weblinks w, tbl_personnel_dras a1, tbl_personnel_dras a2, tbl_personnel_dras a3, tbl_dra dra1, tbl_dra dra2, tbl_dra dra3 WHERE p.id = w.person_id AND p.id = a1.person_id AND p.id = a2.person_id AND p.id = a3.person_id AND a1.dra_id = dra1.id AND a2.dra_id = dra2.id AND a3.dra_id = dra3.id - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Query help needed please
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 (from tbl_personnel) and an area_id that corresponds to the field 'id' in tbl_dra. I am trying to display the person record with all of the areas (by name) that are associated with them. here is what I have so far. SELECT DISTINCT p.fname, p.lname, w.web_link, a1.dra_id, a2.dra_id, a3.dra_id, dra1.area as areaa, dra2.area as areab, dra3.area as areac FROM tbl_personnel p, tbl_personnel_weblinks w, tbl_personnel_dras a1, tbl_personnel_dras a2, tbl_personnel_dras a3, tbl_dra dra1, tbl_dra dra2, tbl_dra dra3 WHERE p.id = w.person_id AND p.id = a1.person_id AND p.id = a2.person_id AND p.id = a3.person_id AND a1.dra_id = dra1.id AND a2.dra_id = dra2.id AND a3.dra_id = dra3.id This query works, but if the person only has one record in tbl_personnel_dras I get the same value in areaa, areab and areac Thanks for any help. Charles - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: RE: MySQL Help Needed Please
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 from /usr/local/var > 030104 23:01:55 mysqld ended > > > [1]Done /usr/local/bin/safe_mysqld > --user=mysql > > How do I re-point mysql to look for my old database, I guess that's the > problem right? Anton, look in the error log file to see the causes of failed start. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Help Needed Please
Anton, > # Starting mysqld daemon with databases from /usr/local/var > 030104 23:01:55 mysqld ended This symptom shows when the privilege tables (i.e. the mysql database) has not been installed. Under Unix/Linux, there's a script for this. You can find details here: http://www.mysql.com/doc/en/Post-installation.html Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: "Anton Zavrin" <[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, 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 from /usr/local/var 030104 23:01:55 mysqld ended [1]Done /usr/local/bin/safe_mysqld --user=mysql How do I re-point mysql to look for my old database, I guess that's the problem right? Thank you Stefan Best Regards, Anton -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: 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, you start the MySQL Monitor (that's the SQL command line CLIENT tool that comes along with MySQL) and tell it to connect to a MySQL SERVER running on localhost, as user root and willing to enter a password. >Enter password: >ERROR 2002: Can't connect to local MySQL server through socket >'/tmp/mysql.sock' (61) Can't connect - this means the CLIENT tool cannot connect because there is no server running! Start the server using the mysql_safe script (more info here: http://www.mysql.com/doc/en/safe_mysqld.html). For a test, you can simply start the server like this: # mysqld & AFTER THAT you connect to the SERVER using the CLIENT tool mysql. Hope this gets you running, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: "Anton Zavrin" <[EMAIL PROTECTED]> To: "'Stefan Hinz, iConnect (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 Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) # Anything else I should try :( ? Best Regards, Anton -Original Message- From: Stefan Hinz, iConnect (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 mysqld, not mysql. Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-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 have this file: > srwxrwxrwx 1 mysql wheel0 Jan 2 16:45 mysql.sock > > I have two of .err files and non of the log files > > I also can't find my *.cnf file(s) > > Did: ps -ef | grep mysql > Got nothing > > What should I do? > > Best Regards, Anton > > > -Original Message- > From: Thomas Spahni [mailto:[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 30 19:12 mysql.sock > > and finally check for your > > socket= /tmp/mysql.sock > > entries in /etc/my.cnf and ~/.m
RE: MySQL Help Needed Please
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 from /usr/local/var 030104 23:01:55 mysqld ended [1]Done /usr/local/bin/safe_mysqld --user=mysql How do I re-point mysql to look for my old database, I guess that's the problem right? Thank you Stefan Best Regards, Anton -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: 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, you start the MySQL Monitor (that's the SQL command line CLIENT tool that comes along with MySQL) and tell it to connect to a MySQL SERVER running on localhost, as user root and willing to enter a password. >Enter password: >ERROR 2002: Can't connect to local MySQL server through socket >'/tmp/mysql.sock' (61) Can't connect - this means the CLIENT tool cannot connect because there is no server running! Start the server using the mysql_safe script (more info here: http://www.mysql.com/doc/en/safe_mysqld.html). For a test, you can simply start the server like this: # mysqld & AFTER THAT you connect to the SERVER using the CLIENT tool mysql. Hope this gets you running, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: "Anton Zavrin" <[EMAIL PROTECTED]> To: "'Stefan Hinz, iConnect (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 Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) # Anything else I should try :( ? Best Regards, Anton -Original Message- From: Stefan Hinz, iConnect (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 mysqld, not mysql. Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-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 have this file: > srwxrwxrwx 1 mysql wheel0 Jan 2 16:45 mysql.sock > > I have two of .err files and non of the log files > > I also can't find my *.cnf file(s) > > Did: ps -ef | grep mysql > Got nothing > > What should I do? > > Best Regards, Anton > > > -Original Message- > From: Thomas Spahni [mailto:[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 30 19:12 mysql.sock > > and finally check for your > > socket= /tmp/mysql.sock > > entries in /etc/my.cnf and ~/.my.cnf > > Thomas Spahni > > On Fri, 3 Jan 2003, Anton Zavrin wrote: > > > 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' exists! > > > > I checked /tmp/mysql.sock' and the file exists. > > But I don't see any process that would show me mysqld is running. > > > > Then I tried to re-install it from the ports and it says: > > You appear to already have a mysql database directory in > /var/db/mysql. > > > > In order to preserve your ex
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, you start the MySQL Monitor (that's the SQL command line CLIENT tool that comes along with MySQL) and tell it to connect to a MySQL SERVER running on localhost, as user root and willing to enter a password. >Enter password: >ERROR 2002: Can't connect to local MySQL server through socket >'/tmp/mysql.sock' (61) Can't connect - this means the CLIENT tool cannot connect because there is no server running! Start the server using the mysql_safe script (more info here: http://www.mysql.com/doc/en/safe_mysqld.html). For a test, you can simply start the server like this: # mysqld & AFTER THAT you connect to the SERVER using the CLIENT tool mysql. Hope this gets you running, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: "Anton Zavrin" <[EMAIL PROTECTED]> To: "'Stefan Hinz, iConnect (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 Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) # Anything else I should try :( ? Best Regards, Anton -Original Message- From: Stefan Hinz, iConnect (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 mysqld, not mysql. Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-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 have this file: > srwxrwxrwx 1 mysql wheel0 Jan 2 16:45 mysql.sock > > I have two of .err files and non of the log files > > I also can't find my *.cnf file(s) > > Did: ps -ef | grep mysql > Got nothing > > What should I do? > > Best Regards, Anton > > > -Original Message- > From: Thomas Spahni [mailto:[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 30 19:12 mysql.sock > > and finally check for your > > socket= /tmp/mysql.sock > > entries in /etc/my.cnf and ~/.my.cnf > > Thomas Spahni > > On Fri, 3 Jan 2003, Anton Zavrin wrote: > > > 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' exists! > > > > I checked /tmp/mysql.sock' and the file exists. > > But I don't see any process that would show me mysqld is running. > > > > Then I tried to re-install it from the ports and it says: > > You appear to already have a mysql database directory in > /var/db/mysql. > > > > In order to preserve your existing data, you should: > > - dump all your databases > > - kill mysql if it is running > > - delete the /var/db/mysql directory > > - run 'make install' > > - start up mysql > > - re-create all of your database > > - re-load your data > > > > If you understand the consequences of this upgrade, please re-build > this > > port with the environment variable OVERWRITE_DB defined. > > *** Error code 1 > > > > Stop in /usr/ports/databases/mysql323-server. > > > > Please help, what should I do? > > > > Best Regards, Anton > > > ---
RE: MySQL Help Needed Please
Did: ps -ef | grep mysqld got nothing Though I can do: # mysql -u root -p Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) # Anything else I should try :( ? Best Regards, Anton -Original Message- From: Stefan Hinz, iConnect (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 mysqld, not mysql. Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-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 have this file: > srwxrwxrwx 1 mysql wheel0 Jan 2 16:45 mysql.sock > > I have two of .err files and non of the log files > > I also can't find my *.cnf file(s) > > Did: ps -ef | grep mysql > Got nothing > > What should I do? > > Best Regards, Anton > > > -Original Message- > From: Thomas Spahni [mailto:[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 30 19:12 mysql.sock > > and finally check for your > > socket= /tmp/mysql.sock > > entries in /etc/my.cnf and ~/.my.cnf > > Thomas Spahni > > On Fri, 3 Jan 2003, Anton Zavrin wrote: > > > 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' exists! > > > > I checked /tmp/mysql.sock' and the file exists. > > But I don't see any process that would show me mysqld is running. > > > > Then I tried to re-install it from the ports and it says: > > You appear to already have a mysql database directory in > /var/db/mysql. > > > > In order to preserve your existing data, you should: > > - dump all your databases > > - kill mysql if it is running > > - delete the /var/db/mysql directory > > - run 'make install' > > - start up mysql > > - re-create all of your database > > - re-load your data > > > > If you understand the consequences of this upgrade, please re-build > this > > port with the environment variable OVERWRITE_DB defined. > > *** Error code 1 > > > > Stop in /usr/ports/databases/mysql323-server. > > > > Please help, what should I do? > > > > Best Regards, Anton > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Help Needed Please
Anton, first thing, try: ps [whatever options] | grep mysqld The daemon (database server) is called mysqld, not mysql. Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-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 have this file: > srwxrwxrwx 1 mysql wheel0 Jan 2 16:45 mysql.sock > > I have two of .err files and non of the log files > > I also can't find my *.cnf file(s) > > Did: ps -ef | grep mysql > Got nothing > > What should I do? > > Best Regards, Anton > > > -Original Message- > From: Thomas Spahni [mailto:[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 30 19:12 mysql.sock > > and finally check for your > > socket= /tmp/mysql.sock > > entries in /etc/my.cnf and ~/.my.cnf > > Thomas Spahni > > On Fri, 3 Jan 2003, Anton Zavrin wrote: > > > 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' exists! > > > > I checked /tmp/mysql.sock' and the file exists. > > But I don't see any process that would show me mysqld is running. > > > > Then I tried to re-install it from the ports and it says: > > You appear to already have a mysql database directory in > /var/db/mysql. > > > > In order to preserve your existing data, you should: > > - dump all your databases > > - kill mysql if it is running > > - delete the /var/db/mysql directory > > - run 'make install' > > - start up mysql > > - re-create all of your database > > - re-load your data > > > > If you understand the consequences of this upgrade, please re-build > this > > port with the environment variable OVERWRITE_DB defined. > > *** Error code 1 > > > > Stop in /usr/ports/databases/mysql323-server. > > > > Please help, what should I do? > > > > Best Regards, Anton > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL Help Needed Please
I have this file: srwxrwxrwx 1 mysql wheel0 Jan 2 16:45 mysql.sock I have two of .err files and non of the log files I also can't find my *.cnf file(s) Did: ps -ef | grep mysql Got nothing What should I do? Best Regards, Anton -Original Message- From: Thomas Spahni [mailto:[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 30 19:12 mysql.sock and finally check for your socket= /tmp/mysql.sock entries in /etc/my.cnf and ~/.my.cnf Thomas Spahni On Fri, 3 Jan 2003, Anton Zavrin wrote: > 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' exists! > > I checked /tmp/mysql.sock' and the file exists. > But I don't see any process that would show me mysqld is running. > > Then I tried to re-install it from the ports and it says: > You appear to already have a mysql database directory in /var/db/mysql. > > In order to preserve your existing data, you should: > - dump all your databases > - kill mysql if it is running > - delete the /var/db/mysql directory > - run 'make install' > - start up mysql > - re-create all of your database > - re-load your data > > If you understand the consequences of this upgrade, please re-build this > port with the environment variable OVERWRITE_DB defined. > *** Error code 1 > > Stop in /usr/ports/databases/mysql323-server. > > Please help, what should I do? > > Best Regards, Anton - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 30 19:12 mysql.sock and finally check for your socket= /tmp/mysql.sock entries in /etc/my.cnf and ~/.my.cnf Thomas Spahni On Fri, 3 Jan 2003, Anton Zavrin wrote: > 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' exists! > > I checked /tmp/mysql.sock' and the file exists. > But I don't see any process that would show me mysqld is running. > > Then I tried to re-install it from the ports and it says: > You appear to already have a mysql database directory in /var/db/mysql. > > In order to preserve your existing data, you should: > - dump all your databases > - kill mysql if it is running > - delete the /var/db/mysql directory > - run 'make install' > - start up mysql > - re-create all of your database > - re-load your data > > If you understand the consequences of this upgrade, please re-build this > port with the environment variable OVERWRITE_DB defined. > *** Error code 1 > > Stop in /usr/ports/databases/mysql323-server. > > Please help, what should I do? > > Best Regards, Anton - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Help Needed Please
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' exists! I checked /tmp/mysql.sock' and the file exists. But I don't see any process that would show me mysqld is running. Then I tried to re-install it from the ports and it says: You appear to already have a mysql database directory in /var/db/mysql. In order to preserve your existing data, you should: - dump all your databases - kill mysql if it is running - delete the /var/db/mysql directory - run 'make install' - start up mysql - re-create all of your database - re-load your data If you understand the consequences of this upgrade, please re-build this port with the environment variable OVERWRITE_DB defined. *** Error code 1 Stop in /usr/ports/databases/mysql323-server. Please help, what should I do? Best Regards, Anton
RE: Help Needed Please
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. Any help would be really great > since I've been working on this all day :( > > > case "$1" in > start) > if [ -x /usr/local/bin/safe_mysqld ]; then > /usr/local/bin/safe_mysqld --user=mysql > --set-variable=max_allowed_packet=16M > /dev/null & && echo -n ' > mysqld' > > try it in your /etc/my.cnf: [mysqld] socket=/tmp/mysql.sock set-variable = max_allowed_packet=16M Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. (53kr33t w0rdz: sql table query) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help Needed Please
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 on the command line into safe_mysqld script. Martin > 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 on this all day :( - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help Needed Please
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 on this all day :(
case "$1" in
start)
if [ -x /usr/local/bin/safe_mysqld ]; then
/usr/local/bin/safe_mysqld --user=mysql
--set-variable=max_allowed_packet=16M > /dev/null & && echo -n '
mysqld'
fi
;;
stop)
/usr/bin/killall mysqld > /dev/null 2>&1 && echo -n '
mysqld'
;;
*)
echo ""
echo "Usage: `basename $0` { start | stop }"
echo ""
exit 64
;;
esac
thanks!
Joe
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
