Hash Tables / Indexes

Hello, Can someone explain hash tables or hash indexes and if we can take advantage of them in MySQL? Thanks! Karl - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Search Engines

Hello, I need to create a search engine out of a few MySQL tables I should say: I need to search MySQL records like a search engin might. However, my first go ended up as a complete failure because it is highly un-optimized to search for (as an example) %apple% in all of the available text

Using indexes with regexp where initial characters are well defined

I hit a situation just now where a select using the 'regexp' operator would have been a tidy solution if mysql used indexes. I wasn't sure if this optimisation had been implemented, so I investigated and found that indexes are not used. The case where this is possible is relatively simple to id

lowercase table names on win2000 platform / uppercase on linux platform

Hi there, I made a mySQL database with uppercase table names on a linux platform. I migrated it, for maintenance reasons, on a win2000 platform. Now when I try to put everything back I discovered that mySQL on win2000 changed my table names to lowercase. For java this is not a problem on the win

Re: how to do increments in parallel

On Mon, Nov 12, 2001 at 10:52:39PM -0800, Bennett Haselton wrote: > Say I have two running programs and both of them periodically want to > increment a value in a database. How can I do this so that the increments > will be performed correctly even if the two programs try to do them at the > s

how to do increments in parallel

Say I have two running programs and both of them periodically want to increment a value in a database. How can I do this so that the increments will be performed correctly even if the two programs try to do them at the same time? If I have code like this: $x = read_value_from_databas

innodb inserts/select crash

Hi there. Can anyone offer a solution to this problem. CREATE TABLE `raw` ( `cid` int(11) default NULL, `agent` char(255) default NULL, `referer` char(255) default NULL, `addr` char(15) default NULL, `via` char(255) default NULL, `forward` char(15) default NULL, `ctime` datetime def

Re: Online Documentation App Bug?: User Comments in MySQL docs are a little off

On Thu, Nov 08, 2001 at 05:27:41PM +0200, indrek siitan wrote: > Hi, > > > I just noticed that at least 2 pages in the online MySQL docs > > definitely have the associated user comments a little askew. > > I thought I'd mention it here while I was thinking of it. > > Apologies if not the correc

Re: pass variable in JS to php and mysql-query

Hi Phuc, I work around the problem and I fix the problem without the submit() function. It will dynamic update content in room by sending the sql_query to server and get info back. thank for your response. Nguyen Trong Phuc wrote: > > i think that u can't, b/c php is server side while JS is

Re: Can't stop mysql

you can also use mysqladmin shutdown Deepanshu - Nguyen Trong Phuc <[EMAIL PROTECTED]> wrote: > i don't use linuxconf. > if u want to stop mysql, execute : > /ect/init.d/mysql stop > easiest :) > Trong Phuc > > - Original Message - > From: <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]>

Re: Can't connect via IP, but can via hostname

Please read mysql manual, your question covered by manual. > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) Ady Wicaksono([EMAIL PR

mysql@lists.mysql.com

>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Release:

Re: automatic index for not null unique columns?

Hi Steve, - Original Message - From: "Steve Fink" <[EMAIL PROTECTED]> > > I couldn't find an explanation of this behavior in the docs. When I > > use the following CREATE command: > > CREATE TABLE D6 (id int(10) not null unique); > > it appears to automatically create an index for me:

Re: automatic index for not null unique columns?

Quoting Steve Fink ([EMAIL PROTECTED]): > I couldn't find an explanation of this behavior in the docs. When I > use the following CREATE command: > > CREATE TABLE D6 (id int(10) not null unique); > > it appears to automatically create an index for me: Argh! Never mind. Learn something new ever

automatic index for not null unique columns?

I couldn't find an explanation of this behavior in the docs. When I use the following CREATE command: CREATE TABLE D6 (id int(10) not null unique); it appears to automatically create an index for me: mysql> SHOW INDEX FROM D6; +---++--+--+-+... |

Re: OT: Securing username and password in script file

Tim Hewitt wrote: > Arjen G. Lentz [mailto:[EMAIL PROTECTED]] wrote: > > > >Hi Tim, > > > >- Original Message - > >From: "Tim Hewitt" <[EMAIL PROTECTED]> > > > >> It would be nice if mySQL supported some form of encrypted login > where > >> the username and password could be decrypted int

RE: OT: Securing username and password in script file

Arjen G. Lentz [mailto:[EMAIL PROTECTED]] wrote: > >Hi Tim, > >- Original Message - >From: "Tim Hewitt" <[EMAIL PROTECTED]> > >> It would be nice if mySQL supported some form of encrypted login where >> the username and password could be decrypted internally somehow. > >Security through o

Re: creating a Unix socket

I've been a fool. I didn't realize that I had to use the following option when starting up the mysql daemon: --socket=/usr/local/mysql/run/mysql_socket I suppose that my instructions might have left this out. Normally the socket is created in /tmp (absolute pathname) right? But when I specifi

Re: Bug#119076: mysql-server: signal 11

Hello I forward this bug report to this list as it seems to be not Debian specific. MySQL crashes with several kinds of /etc/nsswitch.conf configurations. bye, -christian- On Tue, Nov 13, 2001 at 11:45:27AM +1100, Brian May wrote: > > "Christian" == Christian Hammers <[EMAIL PROTECTED]>

Re: creating a Unix socket

Erik Price wrote: > Hello, > > Despite hours plumbing the MySQL documentation and Paul DuBois' book > "MySQL" (New Riders), I can't figure out what exactly creates the Unix > socket for local connections. For some reason no socket was created > during my setup, and I'm not sure how to go about m

creating a Unix socket

Hello, Despite hours plumbing the MySQL documentation and Paul DuBois' book "MySQL" (New Riders), I can't figure out what exactly creates the Unix socket for local connections. For some reason no socket was created during my setup, and I'm not sure how to go about making one. I compiled 3.23.44

Re: Can't connect via IP, but can via hostname

Check your users and db table at mysql database probably the problem comes from there On Tuesday 13 November 2001 02:47 pm, Alex wrote: > Dear Sirs, > > > My MySQL is not configured properly... > > I can connect using localhost with -h flag , but when I'm using IP > instead of hostname it doesn't

Re: OT: Securing username and password in script file

Hi Tim, - Original Message - From: "Tim Hewitt" <[EMAIL PROTECTED]> > It would be nice if mySQL supported some form of encrypted > login where the username and password could be decrypted > internally somehow. Security through obscurity isn't REALLY safe. It just hides it a bit. Anyone

Update Log and Load Data in file

Hi, I just updated a new database with the update log from another server, and the script failed on the LOAD DATA INFILE commands that I have to import data overnight from other sources, because, of course, those files didn't exist. Now, I know I can use --force to allow the script to complete,

newibie mysqladmin host password

I have a linux redhat 7.2 system. I am trying to install bugzilla which uses mysql. I have installed apache and have completed mysql installation post tests successfully using the -p form of the commands. However, I never succeeded in getting mysql -u root -h 192.168.1.15 -p password actua

Optimizing by drop then create an index

The MySQL manual http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Optimisation.html#MySQL_indexes states "All MySQL indexes (PRIMARY, UNIQUE, and INDEX) are stored in B-trees. Strings are automatically prefix- and end-space compressed.". Other RDBMSes out there state in the their

killing fulltext processes

Hello, I have some fulltext search queries that seem to be hanging my database. They're supposed to search a large text database, but every once and a while one doesn't come back and it brings the whole system down with it. My CPU load isn't very high, but my processlist is full (300) and mysql

Re: 'too many connections'

Christopher Book wrote: > > You mentioned this solved the problem when using pconnect. I'm using > connect, not pconnect so will this still work? > Will using pconnect instead of connect do anything for me? Basically > everything runs properly but then every once and a while I get a ton of > pr

Can't connect via IP, but can via hostname

Dear Sirs, My MySQL is not configured properly... I can connect using localhost with -h flag , but when I'm using IP instead of hostname it doesn't connects at all... What'd I do? Thank you. - Before posting, please check:

Re: Sub Count -- Correction

In the select statement, MySQL returns 1 for true so: SELECT LOCATION_T.ADDRESS, LOCATION_T.CITY, COUNT(DISTINCT HARDWARE_T.IP), COUNT(DISTINCT HARDWARE_T.SLOT), COUNT(DISTINCT HARDWARE_T.PORT), - SUM( HARDWARE_T.PORT_STATUS = 'up' ) AS up_cnt, SUM( HARDWARE_T.PORT_STATUS = 'down' ) a

compiling from source - OT

Hello All, I recently installed MySQL 3.23.44 from source with no problems and all seems to be working fine. From the docs, it recommends gcc 2.95, and our server has gcc 2.91, server specs: Red Hat Linux release 6.2 (Zoot) Kernel 2.4.10 on an i686 gcc version egcs-2.91.66 19990314/Linux (egcs-1

RE: 'too many connections'

You mentioned this solved the problem when using pconnect. I'm using connect, not pconnect so will this still work? Will using pconnect instead of connect do anything for me? Basically everything runs properly but then every once and a while I get a ton of processes that get stuck and send the w

My Book (WAS Re: MySQL Developer's Handbook)

On Mon, Nov 12, 2001 at 07:18:53AM -0600, Rick Emery wrote: > Jeremy, > > I was just cruising amazon.com for MYSQL books and I noted you have > a MYSQL book due-out in January. Will it cover version 4.0? Since > mySQL vers 4.1 is due out soon, do you intend to await the book's > release to cove

order by, group by

I asked before, but got no answer, so I ask again, but refrase myself a little Is it possible in myslq to do an order by before an group by? as far as I know, the order by will happen after the group by, and sort all the grouped rows(I assume that when grouping it just takes the first found uniqu

Re: 'too many connections'

Christopher Book wrote: > > No, I'm not using mysql_pconnect, and my apache configuration seems fine. I > don't have very many users at the moment so there is no reason for the > connections filling up. > > >>This can be due to your apache configuration. do you use mysql_pconnect > function in

Sub Count -- Correction

Sorry, for some reason, the select statement was cut off. Here is the complete statement (below): Thanks, Brad I'm trying to write a select statement that produces a SUB COUNT of column PORT_STATUS where (A) PORT_STATUS = 'up' and (B) PORT_STATUS = 'down'. I'd like to do this in one statment wit

Re: Natural Sort

In the last episode (Nov 12), Michael Kedl said: > Dan Nelson wrote: > > In the last episode (Nov 12), Michael Kedl said: > > > > Looking thru the MYSQL archives I see a few people had interest > > > > in a "natural sort" method to sort text fields containing > > > > numbers. I to would like this

Re: Mysqladmin help please help

"Wells, Kenneth L" wrote: > Please help > > I'm at the end of my rope... > > I just ran a script to create databases in my SQl server, it runs fine > > When it completes it says remember to set a password for the mysql root > user! > > I entered this? > > /usr/local/mysql/bin/mysqladmin -u ro

RE: how to move db

Hi The safest way to do this is to use "mysqldump" utility. mysqldump -u [username] -p dbname > /path/to/dumpfile and then mysql -u [username] -p dbname < /path/to/dumpfile Regards Daniel £aœ e-direct Polska sp. z o.o. WWW: http://www.e-direct.pl E-mail:

Re: how to move db

[EMAIL PROTECTED] wrote: > I'm switching over to a bigger better faster server. My old server is running > version 3.23.22-6 mysql on RH and I need to move all the db's to my new box > using 3.23.41 installed on RH7.2. So do I just simply move all of the db > directories from /var/lib/mysql from

RE: OT: Securing username and password in script file

Peter Lovatt [mailto:[EMAIL PROTECTED]] wrote: > >This is not really a problem for me now, because I have my own server, >and control who has access. This is a problem on virtual hosting, >because anybody could be on there. You are exactly correct. This problem is huge on virtual hosting accoun

Re: Can't stop mysql / possible bug?

> [EMAIL PROTECTED] wrote: > > > I changed the script and now all is well. However I have two concerns: > > 1) Paranoid about the password being in this script. Is there a way around this. > > chown root:root /etc/rc.d/init.d/mysqld > chmod go-rx /etc/rc.d/init.d/mysqld Just to be clear, if the

Re: Losing data

(Sorry for the double email Simon, forgot to switch the email to text...) Simon Windsor wrote: > Hi > > The OS is Redhat 7.1 on a dual processor Pentium box, running MySQL 3.23.36, > the standard RedHat version. > > The machine is running two databases, one is a full archive while the other > on

Re: Losing data

Simon Windsor wrote: > Hi > > The OS is Redhat 7.1 on a dual processor Pentium box, running MySQL 3.23.36, > the standard RedHat version. > > The machine is running two databases, one is a full archive while the other > ones holds current data. The same five records are unavailable using SQL in >

Mysqladmin help please help

Please help I'm at the end of my rope... I just ran a script to create databases in my SQl server, it runs fine When it completes it says remember to set a password for the mysql root user! I entered this? /usr/local/mysql/bin/mysqladmin -u root -p password password (I want password to

Re: Natural Sort

In the last episode (Nov 12), Michael Kedl said: > > Looking thru the MYSQL archives I see a few people had interest in > > a "natural sort" method to sort text fields containing numbers. I > > to would like this feature. Has anything been done for this? > > > > Currently sorts text like: > > 12

how to move db

I'm switching over to a bigger better faster server. My old server is running version 3.23.22-6 mysql on RH and I need to move all the db's to my new box using 3.23.41 installed on RH7.2. So do I just simply move all of the db directories from /var/lib/mysql from one box to the next or are there

RE: primary key based on unique value for two columns

I have not tested this with the primary key - my previous suggestion went off the logic in my head at the time (most likely not a good thing, since I'm tired right now), but I have a feeling Bill here is probably correct if he says it's possible with the primary key as well. I stand corrected. -

Re: Can't stop mysql / possible bug?

[EMAIL PROTECTED] wrote: > I changed the script and now all is well. However I have two concerns: > 1) Paranoid about the password being in this script. Is there a way around this. chown root:root /etc/rc.d/init.d/mysqld chmod go-rx /etc/rc.d/init.d/mysqld > 2) Since I had to change the script

Re: Can't stop mysql / possible bug?

I changed the script and now all is well. However I have two concerns: 1) Paranoid about the password being in this script. Is there a way around this. 2) Since I had to change the script to make it work, Is there a bug in 3.23.41?? Thanks for pointing me in the right direction. Bill Adams

Natural Sort

> Looking thru the MYSQL archives I see a few people had interest in a "natural > > sort" method to sort text fields > containing numbers. I to would like this feature. Has anything been > done for this? > > Currently sorts text like: > 1200 - A tale of 3 dogs > 3 bright lights go on > > "Should

Re: primary key based on unique value for two columns

sure you can CREATE TABLE xx (field1 INT NOT NULL,field2 INT NOT NULL,PRIMARY KEY (field1,field2)) and you have table xx with unique key in two fields hand primoz - Original Message - From: "Brendin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, November 12, 2001 7:37 PM Su

Re: Losing data

Hi The OS is Redhat 7.1 on a dual processor Pentium box, running MySQL 3.23.36, the standard RedHat version. The machine is running two databases, one is a full archive while the other ones holds current data. The same five records are unavailable using SQL in the two databases, but using mys

Re: show processlist: status

Hi! >I'm trying to understand what the status field of the "SHOW PROCESSLIST" >command means. When I execute a query - "SELECT count(*) as count from >table1 where col1 like "name%";", the query takes a long time to execute. >The table has over 47,000,000 records and is indexed on col1. > >What

Fulltext search - How to index "c++"

Hi. What do I need to do to make FTS index things like c++? I have tried setting ft_min_word_len=0 and ft_min_word_len=1 in /etc/my.cnf. Restarted the mysqld and did a RENAME on the table followed by a new CREATE TABLE and an INSERT ... SELECT to import the data back into the correctly named

RE: primary key based on unique value for two columns

This will work thanks... That's what I want a unique key based on two columns. -Original Message- From: Jonathan Hilgeman [mailto:[EMAIL PROTECTED]] Sent: Monday, November 12, 2001 12:09 PM To: 'Brendin'; [EMAIL PROTECTED] Subject: RE: primary key based on unique value for two col

Re:Can't start mysql daemon

Hi! >Description: Error message is: >02 11:31:41 mysqld started >InnoDB: Warning: operating system error number 13 in a file operation. >InnoDB: Cannot continue operation. >02 11:31:41 mysqld ended >How-To-Repeat: > >Fix: >Submitter-Id: Chad Smith <[EMAIL PROTECTED]> >Originator:

RE: primary key based on unique value for two columns

Will this relate the primary keys to one another or just create primary keys on the columns. Ie: Create table test (column1 int(11) not null, column2 int(11) not null, primary key (column1, column2) ) Then could you... Insert into test values ("1","2") Insert into test values ("1","3") Note t

RE: primary key based on unique value for two columns

You can't use a primary key for that, but you CAN make a unique two-column key: ALTER TABLE MyTable ADD UNIQUE MyNewIndex (Column1,Column2) - Jonathan -Original Message- From: Brendin [mailto:[EMAIL PROTECTED]] Sent: Monday, November 12, 2001 10:37 AM To: [EMAIL PROTECTED] Subject: prim

RE: primary key based on unique value for two columns

> I would like to have a table that has a primary key defined on a > combination of two columns in the table. In other words a unique key > based upon the values in two columns. > > I don't think I am able to do this in mysql. I think you can only have > a primary key on one column and not on a

RE: primary key based on unique value for two columns

Hi You are wrong. Just try for example: create table test( pk1 int not null, pk2 int not null, primary key(pk1,pk2) ); Regards Daniel £aœ e-direct Polska sp. z o.o. WW

Re: primary key based on unique value for two columns

Brendin wrote: > I would like to have a table that has a primary key defined on a > combination of two columns in the table. In other words a unique key > based upon the values in two columns. > > I don't think I am able to do this in mysql. I think you can only have > a primary key on one colu

RE: primary key based on unique value for two columns

Yes, you can have multi-column keys. see the manual, para. 6.5.3 CREATE TABLE Syntax -Original Message- From: Brendin [mailto:[EMAIL PROTECTED]] Sent: Monday, November 12, 2001 12:37 PM To: [EMAIL PROTECTED] Subject: primary key based on unique value for two columns I would like to hav

mysql+java: how to use LOAD DATA LOCAL INFILE

Hi ! If off-topic, forgive me, please. Environment: Win98 / mysql3.23.42-max / mm.mysql-2.0.7 / jdk1.3.1 Description: I'm trying to load data from file to table using following query: LOAD DATA LOCAL INFILE 'C:\\WINDOWS\\TEMP\\rec222.txt' INTO TABLE ext_call_info_ip FIELDS TERMINATED BY '\t' I

RE: load_file problem

oops...I'm wrong...you can load that way. -Original Message- From: Rick Emery Sent: Monday, November 12, 2001 12:56 PM To: [EMAIL PROTECTED] Subject: RE: load_file problem Are you trying to load the contents of a file with an INSERT statement? If so, you can't. The values MUST be con

Re: Cannot add blob data to innodb table

Hi! At 08:57 AM 11/12/01 -0800, you wrote: >> >> how do you communicate the binary strings to MySQL? From the manual I >> found: >> >> " >> If you want to insert binary data into a BLOB column, the following >> characters must be represented by escape sequences: >> >> NUL >> ASCII 0. You should r

Re: Can't stop mysql

[EMAIL PROTECTED] wrote: > The only reference to mysqladmin is for the reload at the end. I think this > whole thing started after doing the mysql_install_db and then creating the root > password - but it may be a coincidence. > > Any and all help is welcome as to why /etc/init.d/mysqld stop fail

Managing replication

I have a fairly complicated one-way replication set-up, whereby we have multiple master servers and multiple slaves, all replicating unrelated databases from one to another. It's set up and works, but not reliably. Pretty much every day I come into work to find one machine is no longer replicati

RE: load_file problem

Are you trying to load the contents of a file with an INSERT statement? If so, you can't. The values MUST be constants. What are your really trying to do? -Original Message- From: Venugopal Allavatam [mailto:[EMAIL PROTECTED]] Sent: Monday, November 12, 2001 12:26 PM To: Sinisa Milivoj

Re: Can't stop mysql

The only reference to mysqladmin is for the reload at the end. I think this whole thing started after doing the mysql_install_db and then creating the root password - but it may be a coincidence. Any and all help is welcome as to why /etc/init.d/mysqld stop fails. The /etc/init.d/mysql is as f

primary key based on unique value for two columns

I would like to have a table that has a primary key defined on a combination of two columns in the table. In other words a unique key based upon the values in two columns. I don't think I am able to do this in mysql. I think you can only have a primary key on one column and not on a combination

Re: Help with aggregate query

On Mon, Nov 12, 2001 at 11:14:21AM -0500, Johnson, Gregert wrote: % SELECT SUM(d.AcctSessionTime) + IFNULL(m.Minutes, 0) % FROM detail d LEFT OUTER JOIN monthly_usage m ON d.UserName = m.UserName % WHERE d.UserName = 'foo'; % % Or, to summarize for all users: % % SELECT d.UserName as user, SUM(d

Sub Count

Howdy, I'm trying to write a select statement that produces a SUB COUNT of column PORT_STATUS where (A) PORT_STATUS = 'up' and (B) PORT_STATUS = 'down'. I'd like to do this in one statment with GROUP by LOCATION_T.ADDRESS, LOCATION_T.CITY without altering the outer select. This sort of thing is

load_file problem

Hi! I am stuck with the load_file problem... I have created the following table : create table table_name (field_number1 int unsigned primary key not null, data_field longblob not null); I then tried to load the contents of a file with permissions -rw-r--r-- located in the /home/user directory o

Re: MySQL installation problem

On Mon, 12 Nov 2001, ? wrote: > > You need to get gcc-2.95.2 over newer. It is available on the > > stage.caldera.com site. or http://www.caldera.com/skunkware. > > > I do this, but message is the same: > gcc -03 -DDBUG_OFF -DSCO -O conf_to_src conf_tosrc.o -lcrypt -lsocket -lm > Un

Re: Fulltext search variable

Hi! On Nov 12, Craig Issod wrote: > Using 3.23.32 on FreeBsd 3.2 > > Have gotten a sample fulltext search going, but cannot figure out how > to shorten the word length to 2 o3 3, from the default 4. > > Yes, I've read the docs, and tried the following: > Setting variable using mysqld on comman

Re: Can't stop mysql

[EMAIL PROTECTED] wrote: > I'll agree with you but - when I shutdown my linux box or restart it, it tries > to stop the mysql server and it can't. The command /etc/init.d/mysqld stop > should work and it isn't. The question is why can't I stop the mysql server with > this command. As a matter of

show processlist: status

I'm trying to understand what the status field of the "SHOW PROCESSLIST" command means. When I execute a query - "SELECT count(*) as count from table1 where col1 like "name%";", the query takes a long time to execute. The table has over 47,000,000 records and is indexed on col1. What does the st

Re: Losing data

Simon Windsor wrote: > Hi > > I appear to have lost several records, but on doing mysqldump the > records are there. > > I have tried optimize|repair and the data hasn't re-appeared. > > Any ideas ? Not with this level of information. (Try including some sql, what you are trying to match, etc.

Re: MySQL installation problem

- Original Message - From: "Boyd Lynn Gerber" <[EMAIL PROTECTED]> To: "é×ÁÎ ðÏÎÏÍÁÒÅ×" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, November 11, 2001 5:57 PM Subject: Re: MySQL installation problem > You need to get gcc-2.95.2 over newer. It is available on the > stage.cal

Re: Fulltext search variable

Craig Issod wrote: > >Craig Issod wrote: > > > >> Using 3.23.32 on FreeBsd 3.2 > >> > >> Have gotten a sample fulltext search going, but cannot figure out how > >> to shorten the word length to 2 o3 3, from the default 4. > >> > > > Yes, I've read the docs, and tried the following: > >> Sett

Re: Can't stop mysql

i don't use linuxconf. if u want to stop mysql, execute : /ect/init.d/mysql stop easiest :) Trong Phuc - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, November 12, 2001 9:27 AM Subject: Can't stop mysql > > > Howdy, > I'm running version 3.23.41 on R

Re: Can't stop mysql

I'm having the same problem. At 12:27 PM 11/12/2001 -0500, [EMAIL PROTECTED] wrote: >Howdy, >I'm running version 3.23.41 on RH7.2. For the life of me I can't figure >out why >I can't stop mysqld. Linuxconf was where I first noticed this where mysqld >would >not respond to the stop request. I

Re: Can't stop mysql

[EMAIL PROTECTED] wrote: > Howdy, > I'm running version 3.23.41 on RH7.2. For the life of me I can't figure out why > I can't stop mysqld. Linuxconf was where I first noticed this where mysqld would > not respond to the stop request. I then tried to reboot the box and watched the > shutdown proce

Re: Fulltext search variable

Craig Issod wrote: > Using 3.23.32 on FreeBsd 3.2 > > Have gotten a sample fulltext search going, but cannot figure out how > to shorten the word length to 2 o3 3, from the default 4. > > Yes, I've read the docs, and tried the following: > Setting variable using mysqld on command line...it won't

Can't start mysql daemon

>Description: Error message is: 02 11:31:41 mysqld started InnoDB: Warning: operating system error number 13 in a file operation. InnoDB: Cannot continue operation. 02 11:31:41 mysqld ended >How-To-Repeat: >Fix: >Submitter-Id: Chad Smith <[EMAIL PROTECTED]>

Re: Load Data with extra field

M. A. Alves writes: > mysql database $!#"$#%&$ I know the feeling. :-P > > On Sun, 11 Nov 2001, Michael Conley wrote: > > > . . . even though the text files that I am importing don't have the > > > customer number of the person who submitted it, if I know the customer > > > number . . . > > >

Can't stop mysql

Howdy, I'm running version 3.23.41 on RH7.2. For the life of me I can't figure out why I can't stop mysqld. Linuxconf was where I first noticed this where mysqld would not respond to the stop request. I then tried to reboot the box and watched the shutdown process and noticed that mysqld failed

Losing data

Hi I appear to have lost several records, but on doing mysqldump the records are there. I have tried optimize|repair and the data hasn't re-appeared. Any ideas ? Simon - Before posting, please check: http://www.mysql.com

Fulltext search variable

Using 3.23.32 on FreeBsd 3.2 Have gotten a sample fulltext search going, but cannot figure out how to shorten the word length to 2 o3 3, from the default 4. Yes, I've read the docs, and tried the following: Setting variable using mysqld on command line...it won't take it. Looking at the variab

Re: Problem: myisamchk: error: Checksum for key....

Grzegorz Paszka writes: > > Yes, I say more, that I created new database and filled it by perl script from data >source and I have the same situation. I think that is the best way of rebuild index >file :) > > So what I should do in this case ? > > -- > Grzegorz > See in our manual what to

Re: Problem: myisamchk: error: Checksum for key....

On Mon, Nov 12, 2001 at 03:22:31PM +0200, Sinisa Milivojevic wrote: > Grzegorz Paszka writes: > > Hi. > > > > I've problem with mysql. > > > > I had i386 RH71 (kernel 2.4.13, 1.5GB RAM, single procesor) with mysql 3.23.36 >(now I have 3.23.41 and problem still exists). > > I run myisamchk on t

Re: Unique and case-insensitivity with indexes

Giuseppe Maxia <[EMAIL PROTECTED]> responded: > The workaround is to use the attribute BINARY for your field > create table test (myfield varchar(80) BINARY not null, UNIQUE KEY myfield); > This way, the index is case sensitive. > > Unfortunately, this feature was introduced in MySQL 3.23, so y

RE: v3: delete based on select

> I then want to delete these records from the source table. I have tried > various permutations of: > delete from sourcetable select * from sourcetable,targettable where > sourcetable.id=targettable.id; > but with no luck. > > The archive only seems to have questions relating to multi-table

Re: Cannot add blob data to innodb table

> > how do you communicate the binary strings to MySQL? From the manual I > found: > > " > If you want to insert binary data into a BLOB column, the following > characters must be represented by escape sequences: > > NUL > ASCII 0. You should represent this by `\0' (a backslash and an ASCII > `0'

Re: Unique and case-insensitivity with indexes

12/11/2001 17:34:07, Fulko Hew <[EMAIL PROTECTED]> wrote: > >I am using mySQL 3.22.4a-beta >yes, I know its old :-( > >I have just stumbled across a problem with how it >treats 'uniqueness' in table contents. > >I have a table with a column defined as: > > create table test (name varchar(80) not

Re: Unique and case-insensitivity with indexes

Bill Adams <[EMAIL PROTECTED]> replied: > Fulko Hew wrote: > > > I am using mySQL 3.22.4a-beta > > yes, I know its old :-( > > > > I have just stumbled across a problem with how it > > treats 'uniqueness' in table contents. > > > > I have a table with a column defined as: > > > > create table

RE: Unique and case-insensitivity with indexes

> If you create your columns with the 'binary' parm (look in the manual), > then all the comparisons will be case-sensitive. > >Can anyone either point out what I am doing wrong, or a workaround? > database, mysql, table -

Re: Re: MySQL installation problem

database,sql,query,table You have written the following: You need to get gcc-2.95.2 over newer. It is available on the stage.caldera.com site. or http://www.caldera.com/skunkware. Good Luck, -- Boyd Gerber <[EMAIL PROTECTED]> ZENEZ 3748 Valley Forge Road, Magna Utah 84044 Office 801-250-0

Re: Unique and case-insensitivity with indexes

Fulko Hew wrote: > I am using mySQL 3.22.4a-beta > yes, I know its old :-( > > I have just stumbled across a problem with how it > treats 'uniqueness' in table contents. > > I have a table with a column defined as: > > create table test (name varchar(80) not null); > alter table test ADD UNIQ

  1   2   >