build problems
I have Redhat 7.2 - clean install When I try to compile my own mysql 49a version, I get a hostname error and it said it can't use the resolveIP function. It also says it might be that mysql isn't 100% compatible with the libc (or glibc) version I have. I also saw on the www.mysql.com homepage that there are problems with a glibc version 2.96 I can use the rpm but it installs with errors. Is it possible to install without errors? has anyone gotten a clean install with mysql? and how? thanks, Paul - 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: Why v3.23.49 does not build on RedHat 6.2 ?????
Hi. I have following rpm packages from redhat.com: glibc-2.2.2-10.i386.rpm glibc-2.2.2-10.i686.rpm compat-glibc-6.2-2.1.3.2.i386.rpm glibc-common-2.2.2-10.i386.rpm glibc-devel-2.2.2-10.i386.rpm I get this packet to upgrade my glibc 2.1 running on my RH 6.2 system, but it fails. Do i have missed some rpm packages ? When yes, where can i it found ? Maybe it is impossible to upgrade glibc2.1 to 2.2 on RH 6.2 ? I don't would like to change to RH 7.2 I use rpm 4.0.2. regrads I. Piasecki. - Original Message - From: Trond Eivind Glomsrød [EMAIL PROTECTED] To: Dr. Michael Wittmann [EMAIL PROTECTED] Cc: Gabriele Carioli [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, March 06, 2002 1:32 AM Subject: Re: Why v3.23.49 does not build on RedHat 6.2 ? Dr. Michael Wittmann [EMAIL PROTECTED] writes: one solution could be to install a more recent compiler version and try to recompile again. be aware that actual rpm's will be created by rpm version 4, whereas redhat 6.2 has rpm version 3 installed which possibly cannot handle version-4-rpm's Everyone on RHL 6.2 should be running rpm v4 - if not, they are extremely likely to have plenty of unpatched security holes. besides that, there may be glibc issues. redhat 6.2 has glibc 2.1.3 installed. i don't know if actual gcc or mysql versions work ok if compiled against this 'old' glibc. afaik, redhat does _not_ recommend to update the glibc version installed... I would definitely recommend against a major upgrade, e.g. to 2.2. Sizes and interfaces change, so that while old binaries will continue working, anything compiled afterwards will get in a world of pain. -- Trond Eivind Glomsrød Red Hat, Inc. - 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 -- Tego nie znajdziesz w zadnym sklepie! [ http://oferty.onet.pl ] - 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: Default record order...
Richard, Thanks. Interestingly enough, pulling records without a sort was rather random (rather, influence by the last sort) - but once I placed a primary key on the table, the order of unsorted records is always constant, even after a sort (based on numerous tests yesterday and today with the tables and a bunch of selects). I'm a little surprised - and yet I'm not (which is a particularly decisive statement!). Did you CREATE the table, add data, manipulate it, and later impose the PK? When you queried/listed, was that the whole table or less than (say) 25%? If only a proportion of the table is SELECTed (WHERE clause) then an index will be employed, but if it is an entire table list it is more efficient to do a table scan. These would have the potential to yield different sequences of rows from the table. I would do a LOT of testing before relying on the PK-data sequence behavior mentioned above. Let's take another trip down 'memory lane' and review our 'old' terminology. A table consists of at least two files, the data and the index (more in the manual). The data part is a SAM file (sequential access method - remember that in this context sequential is talking about a series of records not of key values) structure, ie the sequence of rows is initially (only) chronological, new records are added to the end, and deletions result in 'holes' being left mid-way. Periodically one would do a 'reorg' (some call it 'compression') to recover the 'lost space' and close up the holes. That process may also result in some re-arrangement of the records, but regardless the idea even of 'chronology' is lost. The second part(s) is the index(es). In the 'good old days' we talked about ISAM (Indexed-sequential access method), where the data was kept in a SAM format, but an 'index' structure was added to kept a note of which key-values/records were in which 'block' of the file. INSERT still took place at the end, but SELECT could pre-access the index and then quickly locate a particular record from amongst the random-ness. In this case a re-org could be much more sophisticated. You can still see the 'history' of ISAM in MySQL today - look at the filenames/types/terminology in use in the docs. However I understand that with various improvements they now use different algorithms, eg b-tree structures for index organisation, etc - but that sounds like 'new tricks' so us 'old dogs' won't go there... NB: I have no idea if a reorg by MySQL can be expected to inject some 'order' into the data as well as 'balancing' the b-trees - the terminology of which puts me in mind of bonsai, so goodness knows what it's doing whilst pruning a little off the top, and squirrelling the nuts away for winter... If the 'optimiser' decides that it will be quicker to deliver query results using an index/PK, then you will see this influenced in the sequence of rows in the resultset (AFAIK). If however the RDBMS figures out that it will be faster to ignore the index and deliver from the data 'file' only, then who knows in what sequence the rows will be delivered! SQL/relational algebra has no concept of 'sequence'. An RDBMS has no requirement/responsibility to store data in a particular sequence. The 'set theory' says that a SELECT is required only to return a set of rows. Thus the only way to impose your own or indeed today's view of order on this (potential) chaos, is to use the ORDER BY clause! Regards, =dn I guess your problem comes from the fact that SQL has no concept of internal order. If you do not specify an ORDER BY clause, the order or records returned is undefined, i.e. random. That's what I was figuring. I asked because I wanted it confirmed. Thank you. Of course, MySQL has some kind of internal order depending on many factors, but you may not rely on it. And neither you may rely on the fact that a PRIMARY KEY influences the internal order. You have to use an ORDER BY clause if you want to get a sorted result (of course, you want a key to speed up the ORDER BY clause). Hmmm. Perhaps I'm misled by the default behaviour of other database engines, but I was taught that the primary key was stored in the database to optimize search/insert/delete - which meant *sorted*. That is why you don't want a large (complex) primary key on tables that must run fast - the overhead of sorting each insert/delete negatively affects performance. Or so I was taught, anyway (back in the dark ages - primative data structures and all that G). As others have said, this is not part of the relational model. However you are correct - back in the 'good old days' we could rely upon hierarchical databases to do this, and I'm fairly sure that the early 'SQL' DBMSes also used to do this because they physically separated the Primary Key and the 'dependent part' of the row, so that any 'straight' listing would come out in PK sequence. =dn
Re: how can I use 'C' programs accessing a MySql
On Tue, 5 Mar 2002 [EMAIL PROTECTED] wrote: I'm trying to understand how can I use 'C' programs accessing a MySql DataBase, please, could you send me a small program or so that creates a Table or two and make some changes on them. I read so many examples but all of them only contain parts of the code. please... help...what library I must include... Alexandre there was an example on this list quite recently. It was a complete piece of code showing how to insert image files into blob columns. This will get you started. Thomas quote From: paradoxix [EMAIL PROTECTED] #include stdio.h #include stdlib.h #include unistd.h #include fcntl.h #include sys/fcntl.h #include mysql/mysql.h MYSQL dbcon; int main(int argc, char *argv[]) { int i; char *tmpQ=malloc(2*1024*1024); char *end; int file; int size; char *mem; char tmpstr[1024]; mysql_init(dbcon); mysql_real_connect(dbcon, NULL, username, password, dbname,0,/tmp/mysql.sock,0); for(i=1;iargc;i++) { file = open(argv[i], O_RDONLY); lseek(file, 0, SEEK_SET); size = lseek(file, 0, SEEK_END); lseek(file, 0, SEEK_SET); mem = malloc(size); read(file,mem,size); printf(inserting: %s\n,argv[i]); end = (char *) strmov(tmpQ,INSERT INTO image values(); *end++ = '\''; sprintf(tmpstr,%i,i); end = strmov(end, tmpstr); *end++ = '\''; *end++ = ','; *end++ = '\''; sprintf(tmpstr,%i,i); end = strmov(end, tmpstr); *end++ = '\''; *end++ = ','; *end++ = '\''; end += mysql_escape_string(end, mem, size); *end++ = '\''; *end++ = ')'; mysql_real_query(dbcon, tmpQ, (unsigned int) (end - tmpQ)); free(mem); close(file); } mysql_close(dbcon); exit(0); return 0; } - 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
in libmysql bad coding causes crash of program
Description: in file libmysql.c, function mysql_read_default_options, which is executed at every start of any mySQL client is a string conversion subroutine, which causes stack overflow Line 715 for (end = *option ; (end = strcend(end,'_')); ) *end= '-'; BUT! strcend returns always a valid and non-NULL pointer, stopping value is the ending NULL in its parameter. Infinite loop. How-To-Repeat: call function mysql_read_default_options Fix: how to correct or work around the problem, if known (multiple lines) for (end = *option ; (end = strcend(end,'_')) (*end); ) *end= '-'; Add in end loop condition ' (*end)' Submitter-Id: [EMAIL PROTECTED] Originator: Jan Struhar Organization: MySQL support: none Synopsis: crash at read_defaults in libmysql Severity: serious Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.49 (Source distribution) Server: lt-mysqladmin Ver 8.23 Distrib 3.23.49, for pc-linux-gnu on i586 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.22.32 Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 1 hour 47 min 28 sec Threads: 1 Questions: 2 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 2 Environment: System: Linux luthien 2.2.14 #15 Po pro 24 11:58:53 CET 2001 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: -rwxr-xr-x 1 root root 4060736 May 30 2000 /lib/libc.so.6 -rw-r--r-- 1 root root 19182014 May 30 2000 /usr/lib/libc.a -rw-r--r-- 1 root root 178 May 30 2000 /usr/lib/libc.so lrwxrwxrwx 1 root root 29 Jul 28 2001 /usr/lib/libc.so.1 - /usr/i486-sysv4/lib/libc.so.1 Configure command: ./configure --with-pthread --enable-thread-safe-client --without-server Perl: This is perl, version 5.005_03 built for i586-linux - 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: Cannot import mysql dump
On Mon, 28 Jan 2002, Sinisa Milivojevic wrote: =?iso-8859-2?Q?Martin MOKREJ=A9?= writes: On Mon, 28 Jan 2002, Sinisa Milivojevic wrote: Hi, I am retrying to an answer to my question from January. Could please someone from the developers have a look into this? http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:97726:200201:ljpgbhblfacaahpnemag The problem still persists, namely when I try to dump some tables on mysql-3.23.42 (linux binary distrib.), I get: My script: Just dumping Bordetella_pertussis_Tohama_I.nonglob_data ERROR 1064 at line 12: You have an error in your SQL syntax near 'PRIMARY (id), KEY contig_data_id (contig_data_id), KEY contig_data_id_2 (con' at line 9 My script: Failed to dump Bordetella_pertussis_Tohama_I.nonglob_data My script: Just dumping Brucella_melitensis_16M.nonglob_data ERROR 1064 at line 12: You have an error in your SQL syntax near 'PRIMARY (id), KEY contig_data_id (contig_data_id), KEY contig_data_id_2 (con' at line 9 My script: Failed to dump Brucella_melitensis_16M.nonglob_data My script: Just dumping Brucella_melitensis_16M.scop2_data ERROR 1064 at line 12: You have an error in your SQL syntax near 'PRIMARY (id), KEY contig_data_id (contig_data_id), KEY contig_data_id_2 (con' at line 9 My script: Failed to dump Brucella_melitensis_16M.scop2_data The problem is either in mysqld exporting data in wrong format or in mysqld 3.23.47 (see mails from january) or 3.23.49a when importing dumps into the database. The only conclusion from January is that the PRIMARY KEY syntax used in dumps is wrong. Dump of usable table using 3.23.42 client, but the dumps is not importable: # MySQL dump 8.16 # # Host: localhost.Database: Bordetella_pertussis_Tohama_I # # Server version3.23.42-log # # Table structure for table 'nonglob_data' # CREATE TABLE nonglob_data ( id int(11) NOT NULL default '0', contig_data_id int(11) NOT NULL default '0', contig_data_code varchar(100) NOT NULL default '', code varchar(100) NOT NULL default '', descr varchar(255) default NULL, dat longtext, created varchar(100) NOT NULL default '', UNIQUE KEY PRIMARY (id), KEY contig_data_id (contig_data_id), KEY contig_data_id_2 (contig_data_id), KEY contig_data_code (contig_data_code), KEY contig_data_id_3 (contig_data_id), KEY code (code), KEY contig_data_id_4 (contig_data_id), KEY descr (descr), KEY contig_data_code_2 (contig_data_code), KEY contig_data_code_3 (contig_data_code), KEY code_2 (code), KEY contig_data_code_4 (contig_data_code), KEY code_3 (code), KEY contig_data_id_5 (contig_data_id), KEY contig_data_id_6 (contig_data_id), KEY code_4 (code), KEY descr_2 (descr), KEY descr_3 (descr), KEY contig_data_code_5 (contig_data_code), KEY contig_data_code_6 (contig_data_code), KEY descr_4 (descr), KEY contig_data_id_7 (contig_data_id), KEY contig_data_id_8 (contig_data_id), KEY contig_data_code_7 (contig_data_code), KEY contig_data_code_8 (contig_data_code), KEY code_5 (code), KEY descr_5 (descr), KEY code_6 (code), KEY code_7 (code), KEY descr_6 (descr), KEY code_8 (code), KEY descr_7 (descr) ) TYPE=MyISAM; Dump of usable table using 3.23.42 client (this dump is importable): # MySQL dump 8.16 # # Host: localhost.Database: Aeropyrum_pernix_K1 # # Server version3.23.42-log # # Table structure for table 'nonglob_data' # CREATE TABLE nonglob_data ( id mediumint(8) unsigned NOT NULL default '0', contig_data_id mediumint(8) unsigned NOT NULL default '0', contig_data_code varchar(100) NOT NULL default '', code varchar(100) NOT NULL default '', descr varchar(255) NOT NULL default '', dat longtext, created varchar(100) default NULL, PRIMARY KEY (id), KEY code (code), KEY descr (descr), KEY contig_data_id (contig_data_id), KEY contig_data_code (contig_data_code) ) TYPE=MyISAM; mysql use Bordetella_pertussis_Tohama_I; mysql describe nonglob_data; +--+--+--+-+-+---+ | Field| Type | Null | Key | Default | Extra | +--+--+--+-+-+---+ | id | int(11) | | PRI | 0 | | | contig_data_id | int(11) | | MUL | 0 | | | contig_data_code | varchar(100) | | MUL | | | | code | varchar(100) | | MUL | | | | descr| varchar(255) | YES | MUL | NULL| | | dat | longtext | YES | | NULL| | | created | varchar(100) | | | | | +--+--+--+-+-+---+ mysql use Aeropyrum_pernix_K1; mysql describe nonglob_data; +--+---+--+-+-+---+ | Field| Type |
Re: Question
on 6/3/02 9:41 PM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --B_3098296036_457240 Content-type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: quoted-printable Hi, This isn=B9t a problem. Just wondering if you are going to bring out a Macintosh version of this software? Cheer Paul --B_3098296036_457240 Content-type: text/html; charset=ISO-8859-1 Content-transfer-encoding: quoted-printable HTML HEAD TITLEQuestion/TITLE /HEAD BODY FONT FACE=3DVerdanaHi,BR BR This isn#8217;t a problem. nbsp;Just wondering if you are going to bring = out a Macintosh version of this software?BR BR CheerBR Paul/FONT /BODY /HTML --B_3098296036_457240-- - 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 on Linux
I know in at least 2 e-mails I did indeed mention that I executed safe_mysqld -u root, So I did it using your syntax, safe_mysqld --user=root, I had the same text returned which again said the following. Starting mysqld daemon with databases from /var/lib/mysql 020305 17:46:10 mysqld ended I presume that means that mysqld ended Basically the mysql started then abruptly stopped. Again the error in the ONLY error log linux.err said the exact same text that was displayed on my screen, making that no help. There is no mysql.sock on my system because the server is not running, anyone have any REAL ideas? The documentation is of NO help whatsoever and I am getting very frustrated with it. Trying mysqp -u root -ppassword was a desperate attempt to try it another way. As I have done numerous different ways. I don't know how many different ways I can try to get mysqld daemon running. Mark - Original Message - From: Steven Roussey [EMAIL PROTECTED] To: 'Mysql' [EMAIL PROTECTED] Sent: Tuesday, March 05, 2002 8:14 PM Subject: Re: mysql on Linux When I execute mysqld -u root -p password I am presented with the default variables. The manual says to use safe_mysqld to properly start mysqld. Also, --user=root is clearer for that option. And, what are you doing with -p password in starting the daemon? This is not an option, it is an error. http://www.mysql.com/doc/s/a/safe_mysqld.html Sincerely, Steven Roussey http://Network54.com/?pp=e - 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
index not hit?
Hello, We are running a mysql database version 3.22.32. I have an simple table: id, int(10) unsigned, PRI, default 0, auto_increment usernummer, int(10) unsigned, default 0 productcode, char(10), default '' monat, tinyint(3) unsigned, default 0 jahr, mediumint(8) unsigned, MUL, 0 and two indizes: mysql show index from reporting; +---++--+--+-+---+-+--+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | +---++--+--+-+---+-+--+ | reporting | 0 | PRIMARY |1 | id | A |3689 | NULL | | reporting | 1 | jahr_idx |1 | jahr| A |NULL | NULL | +---++--+--+-+---+-+--+ when i commit this select: 'SELECT * FROM reporting WHERE jahr=2002;' it seems that the index isn't hit. mysql explain select * from reporting where jahr=2002; +---+--+---+--+-+--+--++ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---+--+---+--+-+--+--++ | reporting | ALL | jahr_idx | NULL |NULL | NULL | 3689 | where used | +---+--+---+--+-+--+--++ 1 row in set (0.00 sec) Can someone tell me why the index is not hit??? Thanks, Stephan - 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
Feature idea inspired by bug report
Hi! Sasha == Sasha Pachev [EMAIL PROTECTED] writes: Sasha On Monday 04 March 2002 02:41 pm, Vladimir V. Kolpakov wrote: -- P.S. so far, it's helpful bug: I use it as catch for poor queries!:) Sasha This actually gives me an idea for a feature. --disable-disk-temp-tables - Sasha fail all queries that need a disk temp table, and --restrict-disk-temp-tables Sasha - allow creation of a temporary disk table only if the user has set Sasha SQL_BIG_RESULT. Sasha I think our users would love it, especially the ISP's with lots of users Sasha running all kinds of problem queries that they do not have much control over. Sasha Monty - what do you think? The problem with this is that a lot of queries requires disk based temporary tables. By disabling these a lot of queries, especially GROUP BY and DISTINCT queries, will unexpectedly stop working. The rules when MySQL uses a disk based instead of a memory based table is also quite hard to formalize, so this could easily cause more confusion that it's worth. Instead of disabling disk based temp tables, we could instead restrict the size of them which should be equally good. (By setting the disk size to 0 you would be able to disable them, but we should not recommend this setting). Regards, Monty - 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
multiple servers
Dear group. (Debian 2.4.19, MySQL 3.23.49) I have problem with starting multiple servers on one machine. According documentation it is enough to start each another then first server using ex.: safe_mysqld --socket=/..path../mysql.socket.x --port=numberx and so on. And this is enough when the server I'm starting is second. But. When I'm trying to start third one (using the same ex. as above) I recive error that mysqld is already active. I'm so more confused that the script /etc/init.d/mysql.server contains nothing more then call: safe_mysqld !!! Can someone tell me where I am wrong (if I am ;-))) ? Thanks in advance. Marek Wysmulek. - 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
Question concerning UPDATE command
I'm relatively new to MySQL but think I am getting a grip on it. However, I am seeing some strange behavior when I perform an update command (through PHP). This following query not only results in the sessionLastTime column updated but also another column sessionStartTime (key, auto_increment). $dateNow=date(YmdHis); ... $query = update sessions set sessionLastTime=.$dateNow. where sessionPHPSessID='.$PHPSESSID.' limit 1; mysql_query($query) or die(mysql_error()); Any idea why this would happen? Pertinent system info Mac OS X (10.1.3) on Dual 1 GHz G4 w 1.5 GB RAM Apache 1.3.20 PHP 4.1.2 MySQL 3.23.39 Stuart Chalk, Ph.D. Department of Natural Sciences Phone:904-620-2831 University of North Florida Fax:904-620-3885 4567 St. Johns Bluff Road S. The Flow Analysis Database Jacksonville FL 32224 USA http://www.fia.unf.edu/ - 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: Why v3.23.49 does not build on RedHat 6.2 ?????
Do you mean: You can forget upgrading on RH6.2 the glibc 2.1 to 2.2. Maybe one did it succesful, so now he has RH.6.2 with glibc 2.2. I still waiting for these persons. P.S: I don't understand word: cos. Is it: Computer Operating System ? regards. - Original Message - From: Ben Edwards [EMAIL PROTECTED] To: Ireneusz Piasecki [EMAIL PROTECTED] Sent: Wednesday, March 06, 2002 12:44 PM Subject: Re: Why v3.23.49 does not build on RedHat 6.2 ? Cos redhat is at least at 7, you have an old version. At 08:33 06/03/2002, you wrote: Hi. I have following rpm packages from redhat.com: glibc-2.2.2-10.i386.rpm glibc-2.2.2-10.i686.rpm compat-glibc-6.2-2.1.3.2.i386.rpm glibc-common-2.2.2-10.i386.rpm glibc-devel-2.2.2-10.i386.rpm I get this packet to upgrade my glibc 2.1 running on my RH 6.2 system, but it fails. Do i have missed some rpm packages ? When yes, where can i it found ? Maybe it is impossible to upgrade glibc2.1 to 2.2 on RH 6.2 ? I don't would like to change to RH 7.2 I use rpm 4.0.2. regrads I. Piasecki. - Original Message - From: Trond Eivind Glomsrød [EMAIL PROTECTED] To: Dr. Michael Wittmann [EMAIL PROTECTED] Cc: Gabriele Carioli [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, March 06, 2002 1:32 AM Subject: Re: Why v3.23.49 does not build on RedHat 6.2 ? Dr. Michael Wittmann [EMAIL PROTECTED] writes: one solution could be to install a more recent compiler version and try to recompile again. be aware that actual rpm's will be created by rpm version 4, whereas redhat 6.2 has rpm version 3 installed which possibly cannot handle version-4-rpm's Everyone on RHL 6.2 should be running rpm v4 - if not, they are extremely likely to have plenty of unpatched security holes. besides that, there may be glibc issues. redhat 6.2 has glibc 2.1.3 installed. i don't know if actual gcc or mysql versions work ok if compiled against this 'old' glibc. afaik, redhat does _not_ recommend to update the glibc version installed... I would definitely recommend against a major upgrade, e.g. to 2.2. Sizes and interfaces change, so that while old binaries will continue working, anything compiled afterwards will get in a world of pain. -- Trond Eivind Glomsrød Red Hat, Inc. - 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 -- Tego nie znajdziesz w zadnym sklepie! [ http://oferty.onet.pl ] - 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 * Ben Edwards +44 (0)117 9400 636 * * Critical Site Builderhttp://www.criticaldistribution.com * * online collaborative web authoring content management system * * i-Contact Progressive Video http://www.videonetwork.org * * Smashing the Corporate image http://www.subvertise.org * * Bristol Indymedia http://bristol.indymedia.org * * Bristol's radical news http://www.bristle.org.uk * * PGP : F0CA 42B8 D56F 28AD 169B 49F3 3056 C6DB 8538 EEF8 * -- Okresl Swoje potrzeby - my znajdziemy oferte za Ciebie! [ http://oferty.onet.pl ] - 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
TIMESTAMP not acting as I'd like
Hi, small problem. I have a table set up like so. It has a number of entries that were added on a certain date, I use TIMESTAMP to keep track of the date. +-+---+--+-+-+-- --+ | Field | Type | Null | Key | Default | Extra | +-+---+--+-+-+-- --+ | auto| mediumint(10) | | PRI | NULL| auto_increment | | accref | varchar(6)| YES | | NULL| | | orderdate | timestamp(8) | YES | | NULL| | | version | varchar(9)| YES | | NULL| | | upgradep| varchar(4)| YES | | NULL| | | status | varchar(8)| YES | | NULL| | | status_relate_to_id | int(11) | YES | | NULL| | +-+---+--+-+-+-- --+ Unfortunately, I used this query on the table mysql UPDATE deerfield SET version = '2.1' WHERE product = 'WinGate LITE'; and all of the dates of the filed that match the where clause updated to today's date. How can I avoid this? Is there a problem with the set-up of the timestamp itself. Any help would be greatly appreciated. Rob - 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: TIMESTAMP not acting as I'd like
[EMAIL PROTECTED] wrote: Hi, small problem. I have a table set up like so. It has a number of entries that were added on a certain date, I use TIMESTAMP to keep track of the date. +-+---+--+-+-+-- --+ | Field | Type | Null | Key | Default | Extra | +-+---+--+-+-+-- --+ | auto| mediumint(10) | | PRI | NULL| auto_increment | | accref | varchar(6)| YES | | NULL| | | orderdate | timestamp(8) | YES | | NULL| | | version | varchar(9)| YES | | NULL| | | upgradep| varchar(4)| YES | | NULL| | | status | varchar(8)| YES | | NULL| | | status_relate_to_id | int(11) | YES | | NULL| | +-+---+--+-+-+-- --+ Unfortunately, I used this query on the table mysql UPDATE deerfield SET version = '2.1' WHERE product = 'WinGate LITE'; and all of the dates of the filed that match the where clause updated to today's date. How can I avoid this? Is there a problem with the set-up of the timestamp itself. That is the correct operation. The manual says, The TIMESTAMP column type provides a type that you can use to automatically mark INSERT or UPDATE operations with the current date and time. If you have multiple TIMESTAMP columns, only the first one is updated automatically., in section 6.2.2.2. You may want to use a DATETIME column type and use the NOW() function to set it. Jim -- /\ ASCII Ribbon Campaign . \ / - NO HTML/RTF in e-mail . X - NO Word docs in e-mail . / \ - [EMAIL PROTECTED] http://www.FreeBSD.org The Power to Serve [EMAIL PROTECTED] http://www.TheHousleys.net [EMAIL PROTECTED] http://www.SimTel.Net - Hi! I'm a .signature virus! Copy me in your ~/.signature to help me spread! - Save this lifeform ;-) - 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
Trouble with BOOLEAN fulltext search
Dear listmembers My problems are: jokers appear not to work as expected in boolean fulltext search and I can't figure out how to order results according to any relevance. I need someone to point me into the right direction. I run MySQL 4.0.1: mysqladmin version mysqladmin Ver 8.23 Distrib 4.0.1-alpha, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 4.0.1-alpha Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 56 days 2 hours 14 min 38 sec My table contains some data: -rw-rw1 mysqldaemon 187621564 Jan 8 20:02 plaintext.MYD -rw-rw1 mysqldaemon 92874752 Jan 8 20:04 plaintext.MYI -rw-rw1 mysqldaemon 8648 Jan 8 20:02 plaintext.frm mysql select count(id) from plaintext; +---+ | count(id) | +---+ | 14579 | +---+ 1 row in set (0.02 sec) and looks like this: mysql describe plaintext; ++--+--+-+-++ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-++ | id | int(11) | | PRI | NULL| auto_increment | | doc| varchar(16) | | MUL | || | code | int(10) unsigned | | MUL | 0 || | part | tinyint(4) | | | 0 || | bgetxt | text | YES | MUL | NULL|| ++--+--+-+-++ 5 rows in set (0.02 sec) which was created this way: CREATE TABLE plaintext ( id int(11) NOT NULL auto_increment, doc varchar(16) NOT NULL default '', code int(10) unsigned NOT NULL default '0', part tinyint(4) NOT NULL default '0', bgetxt text, PRIMARY KEY (id), KEY doc (doc), KEY code (code), FULLTEXT KEY bgetxt (bgetxt) ) TYPE=MyISAM; Data: The word 'Placidus' appears 9 times in document '122 III 150' and just once in document '84 II 304' and in no other document at all. This works (not in boolean mode): mysql SELECT doc FROM plaintext WHERE MATCH(bgetxt) AGAINST('placidus'); +-+ | doc | +-+ | 122 III 150 | | 84 II 304 | +-+ 2 rows in set (0.00 sec) This works too: mysql SELECT doc FROM plaintext WHERE MATCH(bgetxt) AGAINST('placidus' IN BOOLEAN MODE); +-+ | doc | +-+ | 122 III 150 | | 84 II 304 | +-+ 2 rows in set (0.00 sec) ...and this boolean fulltext search correctly returns just one row: mysql SELECT doc FROM plaintext WHERE MATCH(bgetxt) AGAINST('+placidus +christina' IN BOOLEAN MODE); +-+ | doc | +-+ | 122 III 150 | +-+ 1 row in set (0.00 sec) According to the Very Fine Manual I would expect that the following query would return at least 2 rows (remember: the word 'placidus' appears in two of the documents): mysql SELECT doc FROM plaintext WHERE MATCH(bgetxt) AGAINST('placi*' IN BOOLEAN MODE); Empty set (0.00 sec) What happens? As it appears, the *asterisk* joker is not supported. And I can't see from the manual, how to obtain some relevance data when using the modifier 'IN BOOLEAN MODE'. I tried this: mysql SELECT doc, MATCH(bgetxt) AGAINST('placidus' IN BOOLEAN MODE) AS score FROM plaintext WHERE MATCH(bgetxt) AGAINST('placidus' IN BOOLEAN MODE); +-+---+ | doc | score | +-+---+ | 122 III 150 | 1 | | 84 II 304 | 1 | +-+---+ 2 rows in set (0.00 sec) I need to sort rows returned by a boolean search in some order of relevance. Any enlightenment would be very helpful. TIA Thomas Spahni - 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
Deleting a Record
Hi, I a seting up a php page that will let me delete a record from my mysql database, but I want it be able to match to fields before it will let a user delete that record. I know the basic sql command is DELETE FROM $table WHERE field 1 = $value But I don't know how to write the state for a second field. Can some one tell, but one field seem to give too much choose and would make it to easy to delete the wrong record. | Chuck Payne | | Magi Design and Support | | [EMAIL PROTECTED] | BeOS, Macintosh 68K, Classic, and OS X, Linux Support. Web Design you can afford. Never be bullied into silence. Never allow yourself to be made a victim. Accept no one's definition of your life; define yourself.- Harvey Fierstein - 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
ANN: EMS MySQL Manager 1.65 released
Dear Sirs and Madams, EMS HiTech company is announcing the next version (1.65) of MySQL Manager -- A Powerful MySQL Administration and Development Tool for Windows95/98/ME/NT/2000/XP. You can download the latest version from http://www.mysqlmanager.com/download.phtml What's new in version 1.65? 1. Import Data Wizard is greatly improved: now you can import data from four different file formats - Microsoft Excel files, DBF files, text files and CSV files. The import doesn't require Microsoft Excel, BDE or ODBC to be installed on your machine. (*) 2. SQL Script: ability to execute scripts on specified host was added. Now you can specify destination of script execution (host or active database) by selecting a node from popup tree of the tool bar combo box. 3. Register Database dialogue: two new options was added: Use SSL protocol and Use compression protocol. Both of these options are also available in Register Host wizard. 4. Data View: Set To Now item was added to data grid local menu. Now you can set the values of DATE, TIME and DATETIME to the current date and time. 5. German and Spanish localizations are added since releasing previous version. Now MySQL Manager supports English, German, French, Dutch, Italian, Spanish and Russian languages. Icelandic and Slovenian localizations will be added soon. We'll be very grateful to anyone who will translate the 'english.lng' file from $(MySQL Manager)\Languages directory to his native language different from the already existing. Send your translation to [EMAIL PROTECTED] and get your copy for free of charge! 6. Fixed bug with periodically Access Violation error occurances on exit the MySQL Manager. 7. DB Explorer: fixed bug with showing/hiding of DB Explorer's window. 8. Some minor bugfixes and small improvements. (*) -- Professional Edition only What is the EMS MySQL Manager? EMS MySQL Manager provides you powerful and effective tools for MySQL Server administration and objects management. Its Graphical User Interface (GUI) allows you to create/edit of all MySQL database objects most easy and simple way, run SQL scripts, manage users and administrate users' privileges, visually build SQL queries, extract or print metadata, export/import data, view/edit BLOBs and many more services that will make you work with MySQL server as easy as you want... Best regards, EMS HiTech development team. http://www.ems-hitech.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
source install problem - solaris2.6
Hello all, I am having some problems with installing 3.23.49 from source. Below is the output from mysqlbug with my additions to help explain the problem. Any help would be great - my experience with this kind of stuff is not that great. Description: I am trying to upgrade from 3.20.32a by installing the source since there is no binary for Solaris 2.6. While attempting to install make fails: I used CFLAGS=-O3 CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti ./configure --prefix=/usr/local/mysql --enable-assembler --with-mysqld-ldflags=-all-static Here's the end of the output from the make mkdir .libs gcc -O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti -fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_RWLOCK_T -o mysqld sql_lex.o item.o item_sum.o item_buff.o item_func.o item_cmpfunc.o item_strfunc.o item_timefunc.o thr_malloc.o item_create.o field.o key.o sql_class.o sql_list.o net_serv.o violite.o net_pkg.o lock.o my_lock.o sql_string.o sql_manager.o sql_map.o mysqld.o password.o hash_filo.o hostname.o convert.o sql_parse.o sql_yacc.o sql_base.o table.o sql_select.o sql_insert.o sql_update.o sql_delete.o sql_do.o procedure.o item_uniq.o sql_test.o log.o log_event.o init.o derror.o sql_acl.o unireg.o time.o opt_range.o opt_sum.o opt_ft.o records.o filesort.o handler.o ha_heap.o ha_myisam.o ha_myisammrg.o ha_berkeley.o ha_innobase.o ha_gemini.o ha_isam.o ha_isammrg.o sql_db.o sql_table.o sql_rename.o sql_crypt.o sql_load.o mf_iocache.o field_conv.o sql_show.o sql_udf.o sql_analyse.o sql_cache.o slave.o sql_repl.o mini_client.o mini_client_errors.o md5.o stacktrace.o -static ../isam/libnisam.a ../merge/libmerge.a ../myisam/libmyisam.a ../myisammrg/libmyisammrg.a ../heap/libheap.a ../mysys/libmysys.a ../dbug/libdbug.a ../regex/libregex.a ../strings/libmystrings.a -ldl -lpthread -lthread -lcrypt -lgen -lsocket -lnsl -lm -lpthread -lthread ld: fatal: library -ldl: not found ld: fatal: library -lpthread: not found ld: fatal: library -lthread: not found ld: fatal: library -lpthread: not found ld: fatal: library -lthread: not found ld: fatal: File processing errors. No output written to mysqld collect2: ld returned 1 exit status make[3]: *** [mysqld] Error 1 make[3]: Leaving directory `/tmp/mysql-3.23.49/sql' make[2]: *** [all-recursive] Error 1 make[2]: Leaving directory `/tmp/mysql-3.23.49/sql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/tmp/mysql-3.23.49' make: *** [all-recursive-am] Error 2 How-To-Repeat: make Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: submitter ID Originator:Duncan Salada Organization: organization of PR author (multiple lines) MySQL support: [none | licence | email support | extended email support ] Synopsis: synopsis of the problem (one line) Severity: [ non-critical | serious | critical ] (one line) Priority: [ low | medium | high ] (one line) Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-3.23.49 (Source distribution) Server: mysqladmin Ver 8.23 Distrib 3.23.49, for sun-solaris2.6 on sparc Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.20.32a Protocol version9 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 20 hours 2 min 24 sec Running threads: 1 Questions: 35871 Reloads: 1 Open tables: 15 Environment: machine, os, target, libraries (multiple lines) System: SunOS literacy 5.6 Generic_105181-12 sun4u sparc SUNW,Ultra-1 Architecture: sun4 Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc /usr/ucb/cc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.6/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' LIBC: Duncan -- Duncan Salada | Titan | www.titan.com/testeval Email: [EMAIL PROTECTED] | Voice: 301-925-3222x375 | Fax: 301-925-3216 - 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: TIMESTAMP not acting as I'd like
Maybe not. MySQL won't auto-maintain a date field. I can't count the number of times that some unanticipated issue was solved through having separate modifydate and createdate fields, with the modifydate being maintained by MySQL (which means that I don't have to worry about it going out of sync from ad hoc update queries). - Original Message - From: [EMAIL PROTECTED] To: Douglas Forrest [EMAIL PROTECTED] Sent: Wednesday, March 06, 2002 7:54 AM Subject: Re: TIMESTAMP not acting as I'd like At 07:43 06/03/2002 -0500, you wrote: Thanks, I think I am complicating things too much. Using DATE will probably suffice. Rob Use multiple timestamp columns in the table, i.e., modifydate and orderdate. MySQL will only maintain the first timestamp column in tables with more than one timestamp column, leaving the subsequent timestamp columns unchanged and up to you to maintain. Alternatively, you may (I didn't test) be able to re-set the column to maintain its orginal value in your update statement (add , orderdate = orderdate to the set portion of your query. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 06, 2002 7:19 AM Subject: TIMESTAMP not acting as I'd like Hi, small problem. I have a table set up like so. It has a number of entries that were added on a certain date, I use TIMESTAMP to keep track of the date. +-+---+--+-+-+- - --+ | Field | Type | Null | Key | Default | Extra | +-+---+--+-+-+- - --+ | auto| mediumint(10) | | PRI | NULL| auto_increment | | accref | varchar(6)| YES | | NULL| | | orderdate | timestamp(8) | YES | | NULL| | | version | varchar(9)| YES | | NULL| | | upgradep| varchar(4)| YES | | NULL| | | status | varchar(8)| YES | | NULL| | | status_relate_to_id | int(11) | YES | | NULL| | +-+---+--+-+-+- - --+ Unfortunately, I used this query on the table mysql UPDATE deerfield SET version = '2.1' WHERE product = 'WinGate LITE'; and all of the dates of the filed that match the where clause updated to today's date. How can I avoid this? Is there a problem with the set-up of the timestamp itself. Any help would be greatly appreciated. Rob - 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: Trouble with BOOLEAN fulltext search
Hi! On Mar 06, Thomas Spahni wrote: Dear listmembers My problems are: jokers appear not to work as expected in boolean fulltext search and I can't figure out how to order results according to any relevance. I need someone to point me into the right direction. According to the Very Fine Manual I would expect that the following query would return at least 2 rows (remember: the word 'placidus' appears in two of the documents): mysql SELECT doc FROM plaintext WHERE MATCH(bgetxt) AGAINST('placi*' IN BOOLEAN MODE); Empty set (0.00 sec) It is a bug. You can - either create a repeatable test case, to be sure, the bug will be fixed in 4.0.2, or just wait till 4.0.2 and try it out, hoping that one of the boolean fulltext search bugs that were fixed recently is yours. What happens? As it appears, the *asterisk* joker is not supported. And I can't see from the manual, how to obtain some relevance data when using the modifier 'IN BOOLEAN MODE'. I tried this: mysql SELECT doc, MATCH(bgetxt) AGAINST('placidus' IN BOOLEAN MODE) AS score FROM plaintext WHERE MATCH(bgetxt) AGAINST('placidus' IN BOOLEAN MODE); +-+---+ | doc | score | +-+---+ | 122 III 150 | 1 | | 84 II 304 | 1 | +-+---+ 2 rows in set (0.00 sec) I need to sort rows returned by a boolean search in some order of relevance. Any enlightenment would be very helpful. TIA Without seeing actual row data I cannot say whether 1 is correct score or not. Boolean fulltext search uses VERY simple scoring, so it is quite possible that both rows have the score of 1. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - 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: source install problem - solaris2.6
Please ignore my original message. I was finally able to get it to work using: CC=gcc CFLAGS=-O3 CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti ./configure --prefix=/usr/local/mysql-3.23.49 --with-low-memory --enable-assembler Duncan -- Duncan Salada | Titan | www.titan.com/testeval Email: [EMAIL PROTECTED] | Voice: 301-925-3222x375 | Fax: 301-925-3216 -Original Message- From: Salada, Duncan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 8:14 AM To: '[EMAIL PROTECTED]' Subject: source install problem - solaris2.6 Hello all, I am having some problems with installing 3.23.49 from source. Below is the output from mysqlbug with my additions to help explain the problem. Any help would be great - my experience with this kind of stuff is not that great. Description: I am trying to upgrade from 3.20.32a by installing the source since there is no binary for Solaris 2.6. While attempting to install make fails: I used CFLAGS=-O3 CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti ./configure --prefix=/usr/local/mysql --enable-assembler --with-mysqld-ldflags=-all-static Here's the end of the output from the make mkdir .libs gcc -O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti -fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_RWLOCK_T -o mysqld sql_lex.o item.o item_sum.o item_buff.o item_func.o item_cmpfunc.o item_strfunc.o item_timefunc.o thr_malloc.o item_create.o field.o key.o sql_class.o sql_list.o net_serv.o violite.o net_pkg.o lock.o my_lock.o sql_string.o sql_manager.o sql_map.o mysqld.o password.o hash_filo.o hostname.o convert.o sql_parse.o sql_yacc.o sql_base.o table.o sql_select.o sql_insert.o sql_update.o sql_delete.o sql_do.o procedure.o item_uniq.o sql_test.o log.o log_event.o init.o derror.o sql_acl.o unireg.o time.o opt_range.o opt_sum.o opt_ft.o records.o filesort.o handler.o ha_heap.o ha_myisam.o ha_myisammrg.o ha_berkeley.o ha_innobase.o ha_gemini.o ha_isam.o ha_isammrg.o sql_db.o sql_table.o sql_rename.o sql_crypt.o sql_load.o mf_iocache.o field_conv.o sql_show.o sql_udf.o sql_analyse.o sql_cache.o slave.o sql_repl.o mini_client.o mini_client_errors.o md5.o stacktrace.o -static ../isam/libnisam.a ../merge/libmerge.a ../myisam/libmyisam.a ../myisammrg/libmyisammrg.a ../heap/libheap.a ../mysys/libmysys.a ../dbug/libdbug.a ../regex/libregex.a ../strings/libmystrings.a -ldl -lpthread -lthread -lcrypt -lgen -lsocket -lnsl -lm -lpthread -lthread ld: fatal: library -ldl: not found ld: fatal: library -lpthread: not found ld: fatal: library -lthread: not found ld: fatal: library -lpthread: not found ld: fatal: library -lthread: not found ld: fatal: File processing errors. No output written to mysqld collect2: ld returned 1 exit status make[3]: *** [mysqld] Error 1 make[3]: Leaving directory `/tmp/mysql-3.23.49/sql' make[2]: *** [all-recursive] Error 1 make[2]: Leaving directory `/tmp/mysql-3.23.49/sql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/tmp/mysql-3.23.49' make: *** [all-recursive-am] Error 2 How-To-Repeat: make Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: submitter ID Originator:Duncan Salada Organization: organization of PR author (multiple lines) MySQL support: [none | licence | email support | extended email support ] Synopsis: synopsis of the problem (one line) Severity: [ non-critical | serious | critical ] (one line) Priority: [ low | medium | high ] (one line) Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-3.23.49 (Source distribution) Server: mysqladmin Ver 8.23 Distrib 3.23.49, for sun-solaris2.6 on sparc Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.20.32a Protocol version9 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 20 hours 2 min 24 sec Running threads: 1 Questions: 35871 Reloads: 1 Open tables: 15 Environment: machine, os, target, libraries (multiple lines) System: SunOS literacy 5.6 Generic_105181-12 sun4u sparc SUNW,Ultra-1 Architecture: sun4 Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc /usr/ucb/cc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.6/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' LIBC: Duncan -- Duncan Salada | Titan | www.titan.com/testeval
RE: MySQL Database Replication
Yes, I did flush the privileges when nothing else worked but that didn't do the trick either. Thanks for trying. -Original Message- From: James Housley [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 6:00 PM To: Thi Cao Cc: MySQL Subject: Re: MySQL Database Replication Thi Cao wrote: Hello everyone, This is my first attempt at MySQL database replication. Can't seem to get it to work yet. The problem reported in the error log of the slave server is as follows: Error reading packet from server: Access denied for user 'repl@slave_host' (Using password: YES) (read_errno 0,server_errno=1045) I believe it has something to do with the way I granted privileges to the user repl. I did the following: GRANT FILE ON dbname.* to repl@'%' identified by 'some_password'; Did you do a FLUSH PRIVILIGES after that? That is needed in some cases. Jim -- /\ ASCII Ribbon Campaign . \ / - NO HTML/RTF in e-mail . X - NO Word docs in e-mail . / \ - [EMAIL PROTECTED] http://www.FreeBSD.org The Power to Serve [EMAIL PROTECTED] http://www.TheHousleys.net [EMAIL PROTECTED] http://www.SimTel.Net - Studies show that 1 out of every 4 Americans suffer some form of mental illness. So look at your three best friends, if they are okay it is YOU! - 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 on Linux
try running safe_mysqld without any options I wouldn't know why you would need to specify a user name to start the daemon -Original Message- From: Intrex [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 5:55 AM To: [EMAIL PROTECTED]; 'Mysql' Subject: Re: mysql on Linux I know in at least 2 e-mails I did indeed mention that I executed safe_mysqld -u root, So I did it using your syntax, safe_mysqld --user=root, I had the same text returned which again said the following. Starting mysqld daemon with databases from /var/lib/mysql 020305 17:46:10 mysqld ended I presume that means that mysqld ended Basically the mysql started then abruptly stopped. Again the error in the ONLY error log linux.err said the exact same text that was displayed on my screen, making that no help. There is no mysql.sock on my system because the server is not running, anyone have any REAL ideas? The documentation is of NO help whatsoever and I am getting very frustrated with it. Trying mysqp -u root -ppassword was a desperate attempt to try it another way. As I have done numerous different ways. I don't know how many different ways I can try to get mysqld daemon running. Mark - Original Message - From: Steven Roussey [EMAIL PROTECTED] To: 'Mysql' [EMAIL PROTECTED] Sent: Tuesday, March 05, 2002 8:14 PM Subject: Re: mysql on Linux When I execute mysqld -u root -p password I am presented with the default variables. The manual says to use safe_mysqld to properly start mysqld. Also, --user=root is clearer for that option. And, what are you doing with -p password in starting the daemon? This is not an option, it is an error. http://www.mysql.com/doc/s/a/safe_mysqld.html Sincerely, Steven Roussey http://Network54.com/?pp=e - 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 - 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
multiple servers (2)
Dear group. (Debian 2.4.19, MySQL 3.23.49) I have problem with starting multiple servers on one machine. According documentation it is enough to start each another then first server using ex.: safe_mysqld --socket=/..path../mysql.socket.x --port=numberx and so on. And this is enough when the server I'm starting is second. But. When I'm trying to start third one (using the same ex. as above) I recive error that mysqld is already active. I'm so more confused that the script /etc/init.d/mysql.server contains nothing more then call: safe_mysqld !!! Can someone tell me where I am wrong (if I am ;-))) ? Thanks in advance. Marek Wysmulek. - 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
CPU Usage
Hi I am running Mysql-3.23.38 on Slackware 8 with Kernel-2.4.17. This morning I suddenly had a problem where when I start Mysql server at startup it uses all cpu available and the machine freezes. To fix the problem I had to remove the complete installation and install mysql from scratch. Anyone who has any ideas what could have cause this problem. Thanks Isak - 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 Database Replication
When I grant privileges as follows, the slave gets updated: GRANT FILE ON *.* to repl@'%' identified by 'some_password'; Could someone please tell me why I must grant the FILE privilege on all databases for the repl (slave) to be able to update one particular database? Thanks everyone. Thi -Original Message- From: James Housley [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 6:00 PM To: Thi Cao Cc: MySQL Subject: Re: MySQL Database Replication Thi Cao wrote: Hello everyone, This is my first attempt at MySQL database replication. Can't seem to get it to work yet. The problem reported in the error log of the slave server is as follows: Error reading packet from server: Access denied for user 'repl@slave_host' (Using password: YES) (read_errno 0,server_errno=1045) I believe it has something to do with the way I granted privileges to the user repl. I did the following: GRANT FILE ON dbname.* to repl@'%' identified by 'some_password'; Did you do a FLUSH PRIVILIGES after that? That is needed in some cases. Jim -- /\ ASCII Ribbon Campaign . \ / - NO HTML/RTF in e-mail . X - NO Word docs in e-mail . / \ - [EMAIL PROTECTED] http://www.FreeBSD.org The Power to Serve [EMAIL PROTECTED] http://www.TheHousleys.net [EMAIL PROTECTED] http://www.SimTel.Net - Studies show that 1 out of every 4 Americans suffer some form of mental illness. So look at your three best friends, if they are okay it is YOU! - 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 3.23 Lost Connection
Adam, Tuesday, March 05, 2002, 10:14:28 PM, you wrote: A I have compiled/rebuilt the MySQL 3.23.49 Source RPM under kernel A 2.4.17, and glibc 2.1. A Using gcc version 2.95.4 20010319 (prerelease). I had 2.96 on there and A headed the warnings and downgraded to 2.95. A Randomly I get the Lost Connection using PHP 4.1.2... Any idea why? Connection lost error occurs when communication bug or bug in the client take place. You can find description of error, if you check the following links. Probably they will help you: http://www.mysql.com/doc/G/o/Gone_away.html http://www.mysql.com/doc/P/a/Packet_too_large.html A Adam -- For technical support contracts, goto https://order.mysql.com/ 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
Dual Languages??
bipin, Wednesday, March 06, 2002, 9:56:53 AM, you wrote: bvc I have a requirement of storing and retrieving data in 2 languages - namely English and Arabic. bvc From what I have been able to understand, that would require me to have 2 MySQL servers running simultaneously. bvc Can somebody please tel me : 1)if there are any other better ways 2) if this is the right way and if it is 3) how this itself can be made possible It's impossible to run one mysqld with several character sets in present time. We plan to do this in future. bvc Bipin -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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
Which Linux version to download (all?)
Elissa, Wednesday, March 06, 2002, 6:44:26 AM, you wrote: E I'm a newie to SQL, and to Linux, so please forgive my blaring blunders... E I know I have an x86 Linux machine, running Redhat 7.2, and I know that I E like RPMs better than binary installations E When I get to the Stable Version/Linux/RPMs download area, the following E options are available: E MySQL 3.23.49a Server (i386) (14M) E MySQL 3.23.49a Benchmark/test suites (i386) (690K) E MySQL 3.23.49a Client programs (i386) (5.2M) E MySQL 3.23.49a Libraries and Header files for development (i386) (1.2M) E MySQL 3.23.49a Client shared libraries (i386) (231K) E My question is: do I have to install ALL these files? I'm just a little E end-user, who wants to make my own database for academic sources, notes, E maybe my own addressbook (I like custom-configured stuff, I used to do a lot E of it with Filemaker Pro). I'm never going to use this on a server or do E development stuff with it. Which of the above RPMs do I download and E install? I thought I'd find out for sure before I downloaded all this stuff E (not with a high-speed modem...). I'm planning on using a MySQL gui that E works well in Gnome or KDE. For minimal installation you should install MySQL server and MySQL client. You can find info about MySQL installation on Linux if you check the following links: http://www.mysql.com/doc/L/i/Linux-RPM.html http://www.mysql.com/doc/L/i/Linux.html E Elissa Teeple -- For technical support contracts, goto https://order.mysql.com/ 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
Loops in Mysql
Amit, Wednesday, March 06, 2002, 6:38:30 AM, you wrote: AL What I want to do is import data from some other AL database to Mysql. For this the requirement is that, AL each record before being added to Mysql database, AL should pass through a loop say 5 times. This I want to AL do using only SQL. I do not want ot use Java or any AL other language. Any idea as to how this can be done. Unfortunately, loops are not presently supported in MySQL. AL Amit Lonkar -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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
index not hit?
Stephan, Wednesday, March 06, 2002, 1:24:37 PM, you wrote: SB We are running a mysql database version 3.22.32. SB I have an simple table: SB id, int(10) unsigned, PRI, default 0, auto_increment SB usernummer, int(10) unsigned, default 0 SB productcode, char(10), default '' SB monat, tinyint(3) unsigned, default 0 SB jahr, mediumint(8) unsigned, MUL, 0 SB and two indizes: SB mysql show index from reporting; SB +---++--+--+-+---+-+--+ SB | Table | Non_unique | Key_name | Seq_in_index | Column_name | SB Collation | Cardinality | Sub_part | SB +---++--+--+-+---+-+--+ SB | reporting | 0 | PRIMARY |1 | id | SB A |3689 | NULL | SB | reporting | 1 | jahr_idx |1 | jahr| SB A |NULL | NULL | SB +---++--+--+-+---+-+--+ SB when i commit this select: SB 'SELECT * FROM reporting WHERE jahr=2002;' SB it seems that the index isn't hit. SB mysql explain select * from reporting where jahr=2002; SB +---+--+---+--+-+--+--++ SB | table | type | possible_keys | key | key_len | ref | rows | SB Extra | SB +---+--+---+--+-+--+--++ SB | reporting | ALL | jahr_idx | NULL |NULL | NULL | 3689 | SB where used | SB +---+--+---+--+-+--+--++ SB 1 row in set (0.00 sec) SB Can someone tell me why the index is not hit??? In some cases MySQL doesn't use indexes. If result of query is more than 30% rows in a table, MySQL won't use indexes. It works much faster without index usage. You can read about how MySQL uses indexes at: http://www.mysql.com/doc/M/y/MySQL_indexes.html SB Stephan -- For technical support contracts, goto https://order.mysql.com/ 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
TIMESTAMP not acting as I'd like
rob, Wednesday, March 06, 2002, 2:19:01 PM, you wrote: recu small problem. I have a table set up like so. It has a number of entries recu that were added on a certain date, I use TIMESTAMP to keep track of the date. recu +-+---+--+-+-+-- recu --+ recu | Field | Type | Null | Key | Default | Extra recu | recu +-+---+--+-+-+-- recu --+ recu | auto| mediumint(10) | | PRI | NULL| recu auto_increment | recu | accref | varchar(6)| YES | | NULL| recu | recu | orderdate | timestamp(8) | YES | | NULL| recu | recu | version | varchar(9)| YES | | NULL| recu | recu | upgradep| varchar(4)| YES | | NULL| recu | recu | status | varchar(8)| YES | | NULL| recu | recu | status_relate_to_id | int(11) | YES | | NULL| recu | recu +-+---+--+-+-+-- recu --+ recu Unfortunately, I used this query on the table recu mysql UPDATE deerfield SET version = '2.1' WHERE product = 'WinGate LITE'; recu and all of the dates of the filed that match the where clause updated to recu today's date. How can I avoid this? Is there a problem with the set-up of recu the timestamp itself. It is a particular feature of timestamp type. You should use another type of data. You can read info about date, time and timestamp types at: http://www.mysql.com/doc/D/A/DATETIME.html recu Rob -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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: Why v3.23.49 does not build on RedHat 6.2 ?????
*mysql, to please stupid filter* On Wed, 6 Mar 2002, Trond Eivind Glomsrød wrote: On Wed, 6 Mar 2002, Ireneusz Piasecki wrote: Hi. I have following rpm packages from redhat.com: glibc-2.2.2-10.i386.rpm glibc-2.2.2-10.i686.rpm compat-glibc-6.2-2.1.3.2.i386.rpm glibc-common-2.2.2-10.i386.rpm glibc-devel-2.2.2-10.i386.rpm I get this packet to upgrade my glibc 2.1 running on my RH 6.2 system, but it fails. Do i have missed some rpm packages ? When yes, where can i it found ? Maybe it is impossible to upgrade glibc2.1 to 2.2 on RH 6.2 ? As I told you, that's a very bad idea. Very bad. I don't would like to change to RH 7.2 You're introducing a _lot_ more risk by just upgrading that part of the system. Upgrading to RHL 7.2 should be painfree, upgrading just glibc will be painful. -- Trond Eivind Glomsrød Red Hat, Inc. - 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 3.23 Lost Connection
Yes thank you for these links. I have already read the documentation as the first thing I did. The second thing I did was recompile. The third thing I did was subscribe to the list. I can write a php script like this: ? $o=mysql_connect(localhost,root,xxx); mysql_select_db(db,$o); for ($x=0;$x100;$x++) { $row=mysql_query(select firstName from users limit 1); if (!row) echo Failed; } mysql_close($o); ? I will run this. A lot of the time I wont get anything to the screen. Other times I will get a bunch of Failed. Completely Random. Oh, users has 17 rows in it. Machine is a dual p3-500 with 1gb RAM. I've tried recompiling with GCC 2.95, 2.96 and 3.04. I've tried this under GLIBC 2.1.3 and 2.2.5. Running linux kernel 2.4.17. Tried default startup, and my own options that works well on another production server of a similar configuration. Apache/PHP and Qmail work flawlessly on this machine. Thanks for everyones help on this matter! -adam -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 9:48 AM To: [EMAIL PROTECTED] Subject: MySQL 3.23 Lost Connection Adam, Tuesday, March 05, 2002, 10:14:28 PM, you wrote: A I have compiled/rebuilt the MySQL 3.23.49 Source RPM under kernel A 2.4.17, and glibc 2.1. A Using gcc version 2.95.4 20010319 (prerelease). I had 2.96 on there and A headed the warnings and downgraded to 2.95. A Randomly I get the Lost Connection using PHP 4.1.2... Any idea why? Connection lost error occurs when communication bug or bug in the client take place. You can find description of error, if you check the following links. Probably they will help you: http://www.mysql.com/doc/G/o/Gone_away.html http://www.mysql.com/doc/P/a/Packet_too_large.html A Adam -- For technical support contracts, goto https://order.mysql.com/ 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 - 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
SQL coding: Finding singular when search with plural.
Hello, This is a good question for when you are sipping coffee or tea and are inspired to write some code. I require additional functionality for my SQL search: MY CURRENT SEARCH SELECT ID, Authors, Year, Title FROM libraryTable WHERE (Authors LIKE '% + varAuthor + %') OR (Keywords LIKE '% + varKeyword + %') OR (Title LIKE '% + varTitle + %'); ORDER BY Year; ADDITIONAL FUNCTIONALITY REQUIRED 1) The search should be able to locate singular words when the plural (s or es) is entered. Example: If singers is entered in the search box, than singer would be found. 2)When two or more words are entered in search box (for example, into the variable varTitle), each word entered should be searched for separately. So if Iyengar Yoga is entered, than the records found might contain: yoga iyengar India yoga style iyengar yoga tai chi iyengar 3)The search should NOT locate words in which the search word is merely a component. So if low is entered in the search box: SHOULD FIND: low lows SHOULD NOT FIND slow below - 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: Which Linux version to download (all?)
Hi. Yopu wrote. You can find info about MySQL installation on Linux if you check the following links: http://www.mysql.com/doc/L/i/Linux-RPM.html http://www.mysql.com/doc/L/i/Linux.html The section: linux-rpm.html it seems to bee out of date: The MySQL RPMs are currently being built on a RedHat Version 6.2 system but should work on other versions of Linux that support rpm and use glibc. But a kuku. On RH 6.2 with glibc 2.1 that isn't work. - from this section. I find, that all user of 6.2 if they want to run mysql from RPM 2.32.49 or above must have glibc 2.2, so must upgrade system to RH 7.0 or above. I give up. I will upgrade my RH.6.2 to 7.2 to have the newest mysql 3.23.49. AMEN. Bye. I. Piasecki. - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 06, 2002 3:48 PM Subject: Which Linux version to download (all?) Elissa, Wednesday, March 06, 2002, 6:44:26 AM, you wrote: E I'm a newie to SQL, and to Linux, so please forgive my blaring blunders... E I know I have an x86 Linux machine, running Redhat 7.2, and I know that I E like RPMs better than binary installations E When I get to the Stable Version/Linux/RPMs download area, the following E options are available: E MySQL 3.23.49a Server (i386) (14M) E MySQL 3.23.49a Benchmark/test suites (i386) (690K) E MySQL 3.23.49a Client programs (i386) (5.2M) E MySQL 3.23.49a Libraries and Header files for development (i386) (1.2M) E MySQL 3.23.49a Client shared libraries (i386) (231K) E My question is: do I have to install ALL these files? I'm just a little E end-user, who wants to make my own database for academic sources, notes, E maybe my own addressbook (I like custom-configured stuff, I used to do a lot E of it with Filemaker Pro). I'm never going to use this on a server or do E development stuff with it. Which of the above RPMs do I download and E install? I thought I'd find out for sure before I downloaded all this stuff E (not with a high-speed modem...). I'm planning on using a MySQL gui that E works well in Gnome or KDE. For minimal installation you should install MySQL server and MySQL client. You can find info about MySQL installation on Linux if you check the following links: http://www.mysql.com/doc/L/i/Linux-RPM.html http://www.mysql.com/doc/L/i/Linux.html E Elissa Teeple -- For technical support contracts, goto https://order.mysql.com/ 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 -- Okresl Swoje potrzeby - my znajdziemy oferte za Ciebie! [ http://oferty.onet.pl ] - 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
Patch for compiling mysql++-1.7.9 with gcc-3.0.3
Hello folks, I do not succeed to install the patch in order to compile the mysql++-1.7.9 with the GCC-3.0.3. I use the command /usr/local/src/mysql++-1.7.9-patched# /usr/local/bin/patch -p0 -i mysql++-gcc-3.0.patch but the output is: can't find file to patch at input line 17 Perhaps you used the wrong -p or --strip option? The text leading up to this was: -- |Only in mysql++-1.7.9-patched/: COPYING |Only in mysql++-1.7.9-patched/: INSTALL |Only in mysql++-1.7.9-patched/: Makefile |Only in mysql++-1.7.9-patched/: Makefile.in |Only in mysql++-1.7.9-patched/: aclocal.m4 |Only in mysql++-1.7.9-patched/: build |Only in mysql++-1.7.9-patched/: config.guess |Only in mysql++-1.7.9-patched/: config.h |Only in mysql++-1.7.9-patched/: config.log |Only in mysql++-1.7.9-patched/: config.status |Only in mysql++-1.7.9-patched/: config.sub |Only in mysql++-1.7.9-patched/: configure |Only in mysql++-1.7.9-patched/examples: .deps |Only in mysql++-1.7.9-patched/examples: .libs |Only in mysql++-1.7.9-patched/examples: Makefile |diff -r mysql++-1.7.9/examples/Makefile.in mysql++-1.7.9-patched/examples/Makefile.in -- File to patch: and after to have specific the rows (to es. Makefile) to me gives the error: File to patch: Makefile patching file `Makefile' Hunk #1 FAILED at 67. Hunk #2 FAILED at 73. Hunk #6 FAILED at 164. Hunk #7 FAILED at 199. Hunk #10 FAILED at 255. Hunk #11 FAILED at 259. Hunk #12 FAILED at 263. Hunk #13 FAILED at 267. Hunk #14 FAILED at 271. Hunk #15 FAILED at 275. Hunk #16 FAILED at 279. Hunk #17 FAILED at 283. Hunk #18 FAILED at 287. Hunk #19 FAILED at 291. Hunk #20 FAILED at 295. Hunk #21 FAILED at 299. Hunk #23 FAILED at 351. 17 out of 23 hunks FAILED -- saving rejects to Makefile.rej can't find file to patch at input line 152 Perhaps you used the wrong -p or --strip option? The text leading up to this was: -- |Only in mysql++-1.7.9-patched/examples: cgi_image |diff -r mysql++-1.7.9/examples/cgi_image.cc mysql++-1.7.9-patched/examples/cgi_image.cc -- File to patch: You can help me? Thanks in advance payment. Erminio Riezzo. - 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: Deleting a Record
* Chuck PUP Payne I know the basic sql command is DELETE FROM $table WHERE field 1 = $value But I don't know how to write the state for a second field. Can some one tell, but one field seem to give too much choose and would make it to easy to delete the wrong record. I think this is what you are asking for: DELETE FROM $table WHERE field1 = $value AND field2 = $value2 Very often you would want an unique key for your table, a so called PRIMARY KEY. In general, using the primary key is the safest and fastest way to delete one and only one record. -- Roger 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: Which Linux version to download (all?)
sorry. I made mistake. Cite should be like this: The MySQL RPMs are currently being built on a RedHat Version 6.2 system but should work on other versions of Linux that support rpm and use glibc. - from http://www.mysql.com/doc/L/i/Linux-RPM.html I. Piasecki. - Original Message - From: Ireneusz Piasecki [EMAIL PROTECTED] To: [EMAIL PROTECTED]; Egor Egorov [EMAIL PROTECTED] Sent: Wednesday, March 06, 2002 4:15 PM Subject: Re: Which Linux version to download (all?) Hi. Yopu wrote. You can find info about MySQL installation on Linux if you check the following links: http://www.mysql.com/doc/L/i/Linux-RPM.html http://www.mysql.com/doc/L/i/Linux.html The section: linux-rpm.html it seems to bee out of date: The MySQL RPMs are currently being built on a RedHat Version 6.2 system but should work on other versions of Linux that support rpm and use glibc. But a kuku. On RH 6.2 with glibc 2.1 that isn't work. - from this section. I find, that all user of 6.2 if they want to run mysql from RPM 2.32.49 or above must have glibc 2.2, so must upgrade system to RH 7.0 or above. I give up. I will upgrade my RH.6.2 to 7.2 to have the newest mysql 3.23.49. AMEN. Bye. I. Piasecki. - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 06, 2002 3:48 PM Subject: Which Linux version to download (all?) Elissa, Wednesday, March 06, 2002, 6:44:26 AM, you wrote: E I'm a newie to SQL, and to Linux, so please forgive my blaring blunders... E I know I have an x86 Linux machine, running Redhat 7.2, and I know that I E like RPMs better than binary installations E When I get to the Stable Version/Linux/RPMs download area, the following E options are available: E MySQL 3.23.49a Server (i386) (14M) E MySQL 3.23.49a Benchmark/test suites (i386) (690K) E MySQL 3.23.49a Client programs (i386) (5.2M) E MySQL 3.23.49a Libraries and Header files for development (i386) (1.2M) E MySQL 3.23.49a Client shared libraries (i386) (231K) E My question is: do I have to install ALL these files? I'm just a little E end-user, who wants to make my own database for academic sources, notes, E maybe my own addressbook (I like custom-configured stuff, I used to do a lot E of it with Filemaker Pro). I'm never going to use this on a server or do E development stuff with it. Which of the above RPMs do I download and E install? I thought I'd find out for sure before I downloaded all this stuff E (not with a high-speed modem...). I'm planning on using a MySQL gui that E works well in Gnome or KDE. For minimal installation you should install MySQL server and MySQL client. You can find info about MySQL installation on Linux if you check the following links: http://www.mysql.com/doc/L/i/Linux-RPM.html http://www.mysql.com/doc/L/i/Linux.html E Elissa Teeple -- For technical support contracts, goto https://order.mysql.com/ 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 -- Okresl Swoje potrzeby - my znajdziemy oferte za Ciebie! [ http://oferty.onet.pl ] - 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: SQL coding: Finding singular when search with plural.
I'm assuming your users arnt using a MySQL client directly to perform the queries... And your using middleware like PHP or something. So your PHP code can parse the users responses and then design your SQL queries around your parsed data. -Original Message- From: BadgerBay [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 10:10 AM To: [EMAIL PROTECTED] Subject: SQL coding: Finding singular when search with plural. Hello, This is a good question for when you are sipping coffee or tea and are inspired to write some code. I require additional functionality for my SQL search: MY CURRENT SEARCH SELECT ID, Authors, Year, Title FROM libraryTable WHERE (Authors LIKE '% + varAuthor + %') OR (Keywords LIKE '% + varKeyword + %') OR (Title LIKE '% + varTitle + %'); ORDER BY Year; ADDITIONAL FUNCTIONALITY REQUIRED 1) The search should be able to locate singular words when the plural (s or es) is entered. Example: If singers is entered in the search box, than singer would be found. 2)When two or more words are entered in search box (for example, into the variable varTitle), each word entered should be searched for separately. So if Iyengar Yoga is entered, than the records found might contain: yoga iyengar India yoga style iyengar yoga tai chi iyengar 3)The search should NOT locate words in which the search word is merely a component. So if low is entered in the search box: SHOULD FIND: low lows SHOULD NOT FIND slow below - 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: Why v3.23.49 does not build on RedHat 6.2 ?????
Ireneusz Piasecki [EMAIL PROTECTED] writes: Do you mean: You can forget upgrading on RH6.2 the glibc 2.1 to 2.2. Maybe one did it succesful, so now he has RH.6.2 with glibc 2.2. I still waiting for these persons. Don't do it. You will do bad things to your system. If you want to upgrade to a newer glibc, upgrade it all (newer versions of RHL has mysql included, too :) -- Trond Eivind Glomsrød Red Hat, Inc. - 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
libncurses.so.5 problem
Hello, I feel i am dead in the water with this problem, it appears that libncurses.so.5 is a linux library, i downloaded mysql-3.23.45 from sunfreeware and did pkgadd on it on Soalris 8 Sparc box, i was able to start mysqld daemon and i can run mysqladmin commands but when i try to connect i m getting : bash-2.03$ mysql ld.so.1: mysql: fatal: libncurses.so.5: open failed: No such file or directory Killed bash-2.03$ I have done a whole find for libncurses.so.5 on system and couldn't find it anywhere. I am really confused, please HELP. Thanks, Atif Faruqui Unix Systems Administrator triVIN, Inc 115 Poheganut Drive Groton, CT 06340 (860) 448-3177 Ext: 4712 - 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
Table Qualified Column Names
Does mysql jdbc driver support table quailified column names? For example, this seems to work: select id from people But this doesn't: select people.id from people. Thanks. Dave Ford Smart Soft - The Developer Training Company http://www.smart-soft.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
Urgent can't create table
hi i get a strange can't create table 'databasename\bigdata1.frm' error 140 when i try to run the following create query: DROP TABLE /*!32200 IF EXISTS*/ bigdata1; CREATE TABLE /*!32300 IF NOT EXISTS*/ bigdata1 ( IDData bigint(20) unsigned NOT NULL auto_increment, REFLang char(2) NOT NULL DEFAULT 'fr' , REFGeo bigint(20) unsigned NOT NULL DEFAULT '1' , REFChannel bigint(20) unsigned NOT NULL DEFAULT '1' , DataTitle varchar(255) binary NOT NULL DEFAULT '' , DataHeader varchar(255) binary NOT NULL DEFAULT '' , DataKeyWords varchar(255) binary NOT NULL DEFAULT '' , DateAdded timestamp(14) , ShortText1 varchar(255) binary , ShortText2 varchar(255) binary , ShortText3 varchar(255) binary , Number1 bigint(20), Number2 bigint(20), Number3 bigint(20), MediumText1 blob NOT NULL DEFAULT '', MediumText2 blob NOT NULL DEFAULT '', MediumText3 blob NOT NULL DEFAULT '', LongText1 longblob NOT NULL DEFAULT '', LongText2 longblob NOT NULL DEFAULT '', LongText3 longblob NOT NULL DEFAULT '', LongText4 longblob NOT NULL DEFAULT '', LongText5 longblob NOT NULL DEFAULT '', PRIMARY KEY (IDData), INDEX GlobalReference (REFLang, REFGeo, REFChannel), INDEX KeySearch (DataTitle(100), DataKeyWords(200), DataHeader(200)), FULLTEXT FullSearch (LongText1, LongText2, LongText3, LongText4, LongText5) ); anything wrong with my query ?? i'm using mysql 4.0.1alpha on WIn2k, Thanks _ Hassan El Forkani http://WarmAfrica.com EveryOne's Africa _ - 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: Transact Sql
On Tuesday 05 March 2002 10:15 pm, Amit Lonkar wrote: hi Does Mysql support Transat SQL??? Assuming you mean Transact SQL, no. 'Transact SQL' is Microsoft's name for their proprietary extensions to SQL. Only Microsoft SQL Server supports it. But then again, MS SQL doesn't support MySQL's extensions either. :) - 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
System Suggestions
Could someone, please, provide me with a link and/or facilitate some suggestons for configuration of the following components for a new DB server hosting MySQL 4.01MAX? I'm only looking to get a start and don't expect THE answer since all things are relative and I will have to further test the various scenarios. SuSE 7.3-2.4.18 512MB RAM 4x40GB Maxtor IDE (7200RPM) drives 3Ware 7800 RAID Controller LVM XFS Thank You, Anthony - 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
Configuration Problem
shell groupadd mysql shell useradd -g mysql mysql shell gunzip mysql-VERSION.tar.gz | tar -xvf - shell cd mysql-VERSION shell ./configure --prefix=/usr/local/mysql Receiving message: ./configure: not found Should this script be included in the unzipped directory. Or is it native to the OS? Please help. shell make shell make install shell scripts/mysql_install_db shell chown -R root /usr/local/mysql shell chown -R mysql /usr/local/mysql/var shell chgrp -R mysql /usr/local/mysql shell cp support-files/my-medium.cnf /etc/my.cnf shell /usr/local/mysql/bin/safe_mysqld --user=mysql - 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: libncurses.so.5 problem
This is not a MySQL question, it's a Solaris question. :) But anyway, you need to get and install ncurses (version 5). You can find more information at: http://www.gnu.org/software/ncurses/ncurses.html On Wednesday 06 March 2002 8:57 am, Atif Faruqui wrote: Hello, I feel i am dead in the water with this problem, it appears that libncurses.so.5 is a linux library, i downloaded mysql-3.23.45 from sunfreeware and did pkgadd on it on Soalris 8 Sparc box, i was able to start mysqld daemon and i can run mysqladmin commands but when i try to connect i m getting : bash-2.03$ mysql ld.so.1: mysql: fatal: libncurses.so.5: open failed: No such file or directory Killed bash-2.03$ I have done a whole find for libncurses.so.5 on system and couldn't find it anywhere. I am really confused, please HELP. - 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
synopsis of the problem (one line)
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:root Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.23.49 (Official MySQL binary) Environment: System: Linux eadmw.ccet.umc.br 2.4.2-2 #1 Sun Apr 8 20:41:30 EDT 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-85) Compilation info: CC='ccc' CFLAGS='-fast' CXX='cxx' CXXFLAGS='-fast -noexceptions -nortti' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Nov 20 09:47 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 1283580 Oct 3 15:10 /lib/libc-2.2.4.so -rw-r--r--1 root root 27314604 Oct 3 14:52 /usr/lib/libc.a -rw-r--r--1 root root 178 Oct 3 14:52 /usr/lib/libc.so lrwxrwxrwx1 root root 10 Sep 6 11:41 /usr/lib/libc-client.a - c-client.a Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-thread-safe-client --enable-local-infile --with-mysqld-ldflags=-non_shared --with-client-ldflags=-non_shared --disable-shared - 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
Urgent can't create table
gaouzief, Wednesday, March 06, 2002, 6:28:01 PM, you wrote: g i get a strange can't create table 'databasename\bigdata1.frm' g error 140 when i try to run the following create query: g DROP TABLE /*!32200 IF EXISTS*/ bigdata1; g CREATE TABLE /*!32300 IF NOT EXISTS*/ bigdata1 ( g IDData bigint(20) unsigned NOT NULL auto_increment, g REFLang char(2) NOT NULL DEFAULT 'fr' , g REFGeo bigint(20) unsigned NOT NULL DEFAULT '1' , g REFChannel bigint(20) unsigned NOT NULL DEFAULT '1' , g DataTitle varchar(255) binary NOT NULL DEFAULT '' , g DataHeader varchar(255) binary NOT NULL DEFAULT '' , g DataKeyWords varchar(255) binary NOT NULL DEFAULT '' , g DateAdded timestamp(14) , g ShortText1 varchar(255) binary , g ShortText2 varchar(255) binary , g ShortText3 varchar(255) binary , g Number1 bigint(20), g Number2 bigint(20), g Number3 bigint(20), g MediumText1 blob NOT NULL DEFAULT '', g MediumText2 blob NOT NULL DEFAULT '', g MediumText3 blob NOT NULL DEFAULT '', g LongText1 longblob NOT NULL DEFAULT '', g LongText2 longblob NOT NULL DEFAULT '', g LongText3 longblob NOT NULL DEFAULT '', g LongText4 longblob NOT NULL DEFAULT '', g LongText5 longblob NOT NULL DEFAULT '', g PRIMARY KEY (IDData), g INDEX GlobalReference (REFLang, REFGeo, REFChannel), g INDEX KeySearch (DataTitle(100), DataKeyWords(200), DataHeader(200)), g FULLTEXT FullSearch (LongText1, LongText2, LongText3, LongText4, LongText5) g ); g anything wrong with my query ?? g i'm using mysql 4.0.1alpha on WIn2k, According to MySQL manual, you can create fulltext index only on VARCHAR and TEXT columns. g Thanks -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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
MySQL Availability
Where can I find most recent (ie; 4.0.2 builds ;Nightly/CVS) at? Thank You, Anthony sql - 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: libncurses.so.5 problem
hi, the ncurses library is available as a solaris binary package at sunfreeware, too. look for ncurses-5.2. Christopher Thompson wrote: This is not a MySQL question, it's a Solaris question. :) But anyway, you need to get and install ncurses (version 5). You can find more information at: http://www.gnu.org/software/ncurses/ncurses.html On Wednesday 06 March 2002 8:57 am, Atif Faruqui wrote: Hello, I feel i am dead in the water with this problem, it appears that libncurses.so.5 is a linux library, i downloaded mysql-3.23.45 from sunfreeware and did pkgadd on it on Soalris 8 Sparc box, i was able to start mysqld daemon and i can run mysqladmin commands but when i try to connect i m getting : bash-2.03$ mysql ld.so.1: mysql: fatal: libncurses.so.5: open failed: No such file or directory Killed bash-2.03$ I have done a whole find for libncurses.so.5 on system and couldn't find it anywhere. I am really confused, please HELP. - 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: Trouble with BOOLEAN fulltext search
On Wed, 6 Mar 2002, Sergei Golubchik wrote: Hi! On Mar 06, Thomas Spahni wrote: My problems are: jokers appear not to work as expected in boolean fulltext search ... mysql SELECT doc FROM plaintext WHERE MATCH(bgetxt) AGAINST('placi*' IN BOOLEAN MODE); Empty set (0.00 sec) It is a bug. You can - either create a repeatable test case, to be sure, the bug will be fixed in 4.0.2, or just wait till 4.0.2 Thanks, Sergei I will try to reduce this to a repeatable test case. Regards, Thomas Spahni - 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
Read previous record with C API
Can someone tell me how to find the previous record in C (with mySQL API function). I do a SELECT statement, read it with mysql_store_result(), read the first record with mysql_fetch_row(), the next record with mysql_fetch_row(), etc.. . But what about reading the previous record ? (sorry for my english). Friendly. - 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
ALTER TABLE Foreign key problems
Hi. I am using MySQL 3.23.44-max and InnoDB tables. I also using foreign key in my tables. I have problem, I couldn't alter my table and add any foreign keys. SQL like this: alter table data_entry add FOREIGN KEY (data_task_id) REFERENCES data_task(identity); give me any error but key doesn't created. If I am creating table with foreign key - all is ok. Sincerely yours, Ivan Latysh. [EMAIL PROTECTED] http://ivan.yourmail.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: Read previous record with C API
mysql_row_seek(). On Wednesday 06 March 2002 10:26 am, JOUANNET, Rodolphe wrote: Can someone tell me how to find the previous record in C (with mySQL API function). I do a SELECT statement, read it with mysql_store_result(), read the first record with mysql_fetch_row(), the next record with mysql_fetch_row(), etc.. . But what about reading the previous record ? (sorry for my english). Friendly. - 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: mytop
deletes, and other) as is possible with the Com_ status variable in the later versions of MySQL (no documentation though..)? I've got a bunch of improvements planned now that I'm regularly using MySQL 4.x. Having all those counters is handy. :-) The counters are in 3.23.47 as well. I don't know how far back they go. One of these days, I need to finish off my graphing stuff and release that, too. Sound great! We store load average data for both our servers (mysql and web) in a mysql database that holds lots of fun stuff for us to watch (like page views, etc) that we graph. We sample every minute. Maybe we'll add qps to the sampling. I just didn't think of that before... Sincerely, Steven Roussey http://Network54.com/?pp=e -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 8:47 pm To: [EMAIL PROTECTED] Subject: Re: mytop On Tue, Mar 05, 2002 at 05:30:31PM -0800, Steven Roussey wrote: Jeremy, Mytop is simply awesome. Thanks! Thanks, glad ya like it. I recently updated to 0.9. I have a request: how about the qps mode show total qps as well as breaking them out (selects, inserts, updates, Too cool. At peak seconds we get 3000 queries per second. :) Nice! Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 26 days, processed 911,593,753 queries (396/sec. avg) - 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: OS X
Ray wrote: I have been going out of 'my' mind. I am trying to install mysql on a Macintosh OS X server. Can anyone give me instructions on how to do this? I have been to numerous sites with no luck. We run OS 10.1.2 server, I have mySQL 3.23.49 running (from entropy). During the install I had to change the hostname of my server but that seemed easy enough. The reason for the database is for WebEvent calendar software. Now when I try to install the WebEvent software it tells me I need the DBI module installed. I have tried CPAN, it tells me it can't find make (I am running Perl 5.6) and something about MD5 security. Is there anywhere a program that installs all of this in one, easy to use package? All I am looking for is a small database for a school. Also where can I find information about the way my server file system works. I am not a UNIX person but I do need to begin learning.--Ray It looks as though your install of MySQL went fine. The problem is your calendar software relies on perl modules to interface with your Database. The primary module it needs is DBI. If you go to search.cpan.org and do a search for DBI you will find many things but DBI-1.21 is what you want. You will need to download this. It will be a good idea to keep all the stuff you download from CPAN in a common directory. Untar the file how every you like but you will need the terminal after that point. In the terminal cd in the directory that was untared then run 'perl Makefile.PL'. At this point you may find some errors that says other modules are required and you will have to download and go though this same process before you can install the module you needed in the first place. You may also get some questions asking how to configure the module. Once that is done run 'make' then 'make test' and 'make install'. Some modules do not have a test so that may not produce anything. If you got this far it should be installed. If you are having problems with the make command, you may need to install the Dev Tools. If you need more info you can email me directly at [EMAIL PROTECTED] or ask a newsgroup/mailinglist that is more related to perl and/or Mac OS X since this is not really a MySQL issue. -- David Steinbrunner mailto:[EMAIL PROTECTED] MFM Communication Software, Inc. http://www.mfm.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 on Linux
Starting mysqld daemon with databases from /var/lib/mysql 020305 17:46:10 mysqld ended This is written by safe_mysqld. It seems that mysqld was never started successfully. I've had this issue before. Every time it was a permissions issue. When I execute mysqld -u root -p password I am presented with the default variables. Which are? Also, what is in /var/lib/mysql? Sincerely, Steven Roussey http://Network54.com/?pp=e - 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
multiple servers (2)
Marek, Wednesday, March 06, 2002, 4:19:28 PM, you wrote: MW (Debian 2.4.19, MySQL 3.23.49) MW I have problem with starting multiple servers on one machine. MW According documentation it is enough to start each another then first MW server using ex.: MW safe_mysqld --socket=/..path../mysql.socket.x --port=numberx You may also add --datadir= ... to separate data directories. MW and so on. so on - please, specify. MW And this is enough when the server I'm starting is second. MW But. When I'm trying to start third one (using the same ex. as above) MW I recive error that mysqld is already active. Add --pid-file=... to separate pid files for different servers. MW I'm so more confused that the script /etc/init.d/mysql.server contains nothing MW more then call: MW safe_mysqld For sure, there is nothing else needed to add when you run only single server. MW Marek Wysmulek. -- For technical support contracts, goto https://order.mysql.com/ 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: Patch for compiling mysql++-1.7.9 with gcc-3.0.3
Erminio Efisio Riezzo writes: Hello folks, I do not succeed to install the patch in order to compile the mysql++-1.7.9 with the GCC-3.0.3. I use the command /usr/local/src/mysql++-1.7.9-patched# /usr/local/bin/patch -p0 -i mysql++-gcc-3.0.patch You can help me? Thanks in advance payment. Erminio Riezzo. Hi! What payment ?? Simply cd to a directory above mysql++... (freshly untarred) and type : patch -p1 mysql++ -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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 on Linux
The /var/lib/mysql contains the following files: linux-bin.001 linux-bin.002 linux-bin.003 linux-bin.004 linux-bin.005 linux-bin.006 linux-bin.007 linux-bin.008 linux-bin.009 linux-bin.index linux-bin.err the directory mysql the directory test directory mysql contains columns_priv.MYD columns_priv.MYI columns_priv.frm db.MYD db.MYI db.frm func.MYD func.MYI fun.frm host.MYD host.MYI host.frm tables_priv.MYD tables_priv.MYI tables_frm user.MYD user.MYI user.frm Directory test contains nothing When I remove all the files and recreate the directory using mysql_install_db then follow the directions for installing the privileges I get the same files, and the same errors. I am unable to use mysqladm create databasename since the mysql daemon is not running. It is my understanding that the database it is looking for is the permission files located in the /var/lib/mysql directories. Mark Mark - Original Message - From: Steven Roussey [EMAIL PROTECTED] To: 'Intrex' [EMAIL PROTECTED] Cc: Mysql [EMAIL PROTECTED] Sent: Wednesday, March 06, 2002 1:07 PM Subject: RE: mysql on Linux Starting mysqld daemon with databases from /var/lib/mysql 020305 17:46:10 mysqld ended This is written by safe_mysqld. It seems that mysqld was never started successfully. I've had this issue before. Every time it was a permissions issue. When I execute mysqld -u root -p password I am presented with the default variables. Which are? Also, what is in /var/lib/mysql? Sincerely, Steven Roussey http://Network54.com/?pp=e - 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 Availability
http://www.mysql.com/doc/I/n/Installing_source_tree.html Ken - Original Message - From: Anthony W. Marino [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 06, 2002 12:12 PM Subject: MySQL Availability Where can I find most recent (ie; 4.0.2 builds ;Nightly/CVS) at? Thank You, Anthony sql - 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: multiple servers (2)
MW safe_mysqld --socket=/..path../mysql.socket.x --port=numberx You may also add --datadir= ... to separate data directories. Don't need to. Servers can work on the same datas. ( Obviously it is comon solution to separate) MW and so on. so on - please, specify. Ups. My english is not too fluent. I've meant that I can start servers using ex. safe_mysqld --socket=/..path../mysql.socket.1 --port=number1 safe_mysqld --socket=/..path../mysql.socket.2 --port=number2 ... (in polish I could say and so on ;- MW safe_mysqld For sure, there is nothing else needed to add when you run only single server. but I could start two servers this way (literally): 1) safe_mysqld 2) safe_mysqld --socket=/..path../mysql.socket.1 --port=number1 Strange, isn't it ? Marek Wysmulek. - 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 Availability
On Wednesday 06 March 2002 01:37 pm, Ken Menzel wrote: http://www.mysql.com/doc/I/n/Installing_source_tree.html Someone, replying earlier, mentioned that MySQL AB folks don't grant permission to nightly stuff. I'll test it out, regardless. Thank You, Anthony - Original Message - From: Anthony W. Marino [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 06, 2002 12:12 PM Subject: MySQL Availability Where can I find most recent (ie; 4.0.2 builds ;Nightly/CVS) at? Thank You, Anthony sql - 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: Deleting a Record
At 7:46 -0500 3/6/02, Chuck \PUP\ Payne wrote: Hi, I a seting up a php page that will let me delete a record from my mysql database, but I want it be able to match to fields before it will let a user delete that record. I know the basic sql command is DELETE FROM $table WHERE field 1 = $value But I don't know how to write the state for a second field. Can some one tell, but one field seem to give too much choose and would make it to easy to delete the wrong record. Connect the conditions with AND: DELETE FROM tbl_name WHERE col1 = 'value1' AND col2 = 'value2' | Chuck Payne | | Magi Design and Support | | [EMAIL PROTECTED] | BeOS, Macintosh 68K, Classic, and OS X, Linux Support. Web Design you can afford. Never be bullied into silence. Never allow yourself to be made a victim. Accept no one's definition of your life; define yourself.- Harvey Fierstein - 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: Deleting a Record
Thanks I have now five ways to try. | Chuck Payne | | Magi Design and Support | | [EMAIL PROTECTED] | -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 10:43 AM To: Chuck PUP Payne; [EMAIL PROTECTED] Cc: PHP General Subject: Re: Deleting a Record At 7:46 -0500 3/6/02, Chuck \PUP\ Payne wrote: Hi, I a seting up a php page that will let me delete a record from my mysql database, but I want it be able to match to fields before it will let a user delete that record. I know the basic sql command is DELETE FROM $table WHERE field 1 = $value But I don't know how to write the state for a second field. Can some one tell, but one field seem to give too much choose and would make it to easy to delete the wrong record. Connect the conditions with AND: DELETE FROM tbl_name WHERE col1 = 'value1' AND col2 = 'value2' | Chuck Payne | | Magi Design and Support | | [EMAIL PROTECTED] | BeOS, Macintosh 68K, Classic, and OS X, Linux Support. Web Design you can afford. Never be bullied into silence. Never allow yourself to be made a victim. Accept no one's definition of your life; define yourself.- Harvey Fierstein - 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
trace tools for MySql
Does anyone have any good tools for putting a trace on an MySql server. I want to be able to see what is happening on the server. Thanks, Eddie - 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: TIMESTAMP not acting as I'd like
Victoria Reznichenko wrote: recu small problem. I have a table set up like so. It has a number of entries recu that were added on a certain date, I use TIMESTAMP to keep track of the date. recu mysql UPDATE deerfield SET version = '2.1' WHERE product = 'WinGate LITE'; recu and all of the dates of the filed that match the where clause updated to recu today's date. How can I avoid this? Is there a problem with the set-up of recu the timestamp itself. It is a particular feature of timestamp type. You should use another type of data. You can read info about date, time and timestamp types at: http://www.mysql.com/doc/D/A/DATETIME.html MySQL only does this to the first TIMESTAMP column in a table, so the usual other solution is to have a last_modified column in the table right at the head (before any other timestamps). This gives you two benefits: an automatic timestamping of the modifications, and you can use the TIMESTAMP type safely for other timestamp values. - 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
RH 7.2 connections problems w 16 web servers to 2 MySQL servers
We have a very high volume site (3 million page views a day) that's run on 16 Apache / PHP web servers 2 MySQL servers. We are using PHP with persistent connections. Each MySQL serves 8 web servers is supposed to act as a failover machine for the other group of 8 web servers. The failover won't work now as if one MySQL goes down the cost of the 8 web servers switching over is so high the other MySQL locks up. Each Apache / PHP server takes up hundreds of connections even when they're idle so we ran into the Linux connection limit of 1000 had to recompile to get past that. Our actual MySQL CPU useage is low but the goes when with the connection overhead when starting up or failing over a bank of machines. We get a mysterious MySQL lockup once a week at the same day time. Questions : - Is our configuration of 2 sets of 8 Apache/PHP web servers 1 MySQL servers just not a good idea ? - Would we better off with FreeBSD ? - Is there anyone doing any similar setups with lots of web servers a few MySQLs ? - Is there any way to get Apache / PHP to use fewer connections ? We pay for MySQL support but haven't had much help from them. - Sam. - 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: [linux-lvm] System Suggestions
On Wed, Mar 06, 2002 at 11:52:30AM -0500, Anthony W. Marino wrote: Could someone, please, provide me with a link and/or facilitate some suggestons for configuration of the following components for a new DB server hosting MySQL 4.01MAX? I'm only looking to get a start and don't expect THE answer since all things are relative and I will have to further test the various scenarios. SuSE 7.3-2.4.18 512MB RAM 4x40GB Maxtor IDE (7200RPM) drives 3Ware 7800 RAID Controller LVM XFS You really don't provide us with enough information here. How big is your database, both in total size and in number of tables. How are those tables utilized, when they get used do you primarily open one table, manipulate it, then close it, or do you go across a bunch of tables? All of these, and more will have a dramatic impact on how you set this stuff up. -- Share and Enjoy. - 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
Structure as a field
this is an obvious 'newbie' question, so please bare with me. i'm parsing a lot of data from file, and a good deal of this data is in the form of nested C structs. within any given struct, you might have an array of 256 floats, or an array of 256 structs, with 256 floats, etc, etc. i'd like to have one entry in the field column which can be accessed by name and index. i.e. fieldnameX(1), fieldnameX(2), etc. where the index is the floating point value, a character string, or whatever in an array within a struct. how do i go about doing this, if it's at all possible? (it would seem odd if i had to create n number of fields for each value in an array. especially arrays of large sizes) i'm not looking for the C/C++ or Perl to SQL mechanism, i just haven't found the syntax to create a field of that type in SQL, which is my first, and obvious starting point. thanks, christian - 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: Bug with heap table ??
Fournier Jocelyn [Presence-PC] writes: I believe the problem occurs only when I execute the DELETE when someone is inserting a records at the same time. Perhaps the hash index is not updated properly whereas the data are deleted properly, which entails a mismatch between data and index ? (I believe this because the following behaviour : mysql INSERT INTO online1 SELECT * FROM online; Query OK, 139 rows affected (0.01 sec) Records: 139 Duplicates: 0 Warnings: 0 mysql DELETE FROM online1 WHERE date 1015111; Query OK, 139 rows affected (0.01 sec) mysql SELECT * FROM online1; Empty set (0.00 sec) mysql DELETE FROM online WHERE date 1015111; Query OK, 141 rows affected (0.00 sec) mysql SELECT * FROM online; ERROR 1030: Got error 124 from table handler ) online1 table is not used by anyone, I create it for the testcase, but the online table is heavily used and updated. Hi! I have a temporary fix for you. Final fix will come in 4.0.2. *** tmp/hp_rnext.c Wed Mar 6 21:55:06 2002 --- heap/hp_rnext.c Wed Mar 6 14:39:16 2002 *** *** 24,29 --- 24,35 HP_SHARE *share=info-s; DBUG_ENTER(heap_rnext); + if (!(info-s-records)) + { + my_errno=HA_ERR_END_OF_FILE; + DBUG_RETURN(my_errno); + } + if (info-lastinx 0) DBUG_RETURN(my_errno=HA_ERR_WRONG_INDEX); -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: RH 7.2 connections problems w 16 web servers to 2 MySQL servers
We pay for MySQL support but haven't had much help from them. You could pay me, I need work... :) Seriously... We have a very high volume site (3 million page views a day) that's run on 16 Apache / PHP web servers 2 MySQL servers. We are using PHP with persistent connections. Each MySQL serves 8 web servers is supposed to act as a failover machine for the other group of 8 web servers. Nice. We have over 3 million page views a day also (for forums -- a recursive query application if there ever was one -- that is, lots of queries per page), though we use two hand-made dual Athlon machines (one apache/php, the other mysql). Its amazing what you can do with less than $10K. Once upon a time we had 4 web servers in front of 2 mysql servers. I've gone through this before. More below We get a mysterious MySQL lockup once a week at the same day time. No idea. Does it just pause for a bit? Are there any cronjobs? Can you get a mysql process list? Questions : - Is our configuration of 2 sets of 8 Apache/PHP web servers 1 MySQL servers just not a good idea ? Just will need some work... - Would we better off with FreeBSD ? No, that is not the issue. - Is there anyone doing any similar setups with lots of web servers a few MySQLs ? We had 4 per mysql server before, not as big but has the same issues. - Is there any way to get Apache / PHP to use fewer connections ? Yes. First a few questions: - How many Apache servers? 8. - Are you using HTTP Keep-Alives? - Are you using persistent connections? Yes. - What is connecting to mysql (PHP, an Apache module, Perl, JSP)? - What is Apache's http.conf value of MaxClients? - What is Apache's http.conf value of StartServers? - What is Apache's http.conf value of MaxRequestsPerChild? Multiply these three numbers: # of apache servers # of apache's MaxClients # of unique server/user/pass pairs The result is the ceiling on the number of connections needed for mysql. When one goes down, then you will multiply by two, since you have twice as many web servers in that situation. Note this number and work it into MySQL's documentation for memory requirements for the MySQL server. You may be shocked. If you are in an emergency, do this: A. Turn off apache's HTTP Keep-Alive B. Turn off persistent connections C. Up the number of cached threads for mysql That should immediately help. There is a more optimal solution, but the amount of work to properly tune will take at least another email and the answers to the above questions. I can write a chapter Apache/PHP/MySQL optimizations Steven Roussey Network54.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
UPATE Using Max?
Hello, In my application I would like to update a MySQL record where one column is the largest value. Do I have to create a separate SELECT sql query statement to get that value and then update it? Or, is there a function that allows me to specify it as part of my WHERE clause. I scanned the manual and found reference to MAX, which appears to do it and can't get it working. The syntax I've tried... UPDATE PICKING SET COL_1 =3D 'My_VAL' WHERE COL_2=3D'My_VAL2' AND MAX(AUDIT); and.. UPDATE PICKING SET COL_1 =3D 'My_VAL' WHERE COL_2=3D'My_VAL2' AND AUDIT = =3D MAX(AUDIT); Does MAX only worke for SELECTS? Thanks for any help to this obvious newbie question! --Aaron - 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
foreign key doesn't work
Hello, I am encountering one problem. I am using mysql as the dabase for my application. I create a table like takeexam as following:create table takelabexam( sid varchar(10) not null, cid varchar(20) not null, marks integer foreign key (cid) references course on Update cascade , primary key (sid, cid,labsection,year)); cid in takelabexam references cid in table courses. so if i update the cid in courses table. the records in table takelabexam which references to courses should be updated automatically. but it doesn't work. Could any one can help me out. i will appreciate very much bin __ Find, Connect, Date! http://personals.yahoo.ca - 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: core dump in clients in MYSQL 3.23.49 using groups
Hi! We have a fix for the problem that you have hit. It is a temporary one. Final one will come in the nexe MySQL release: *** tmp/libmysql.c Wed Mar 6 22:00:00 2002 --- tmp/fixed.c Wed Mar 6 21:59:34 2002 *** *** 737,743 *end=0; /* Remove '=' */ } /* Change all '_' in variable name to '-' */ ! for (end= *option ; (end= strcend(end,'_')) ; ) *end= '-'; switch (find_type(*option+2,option_types,2)) { case 1: /* port */ --- 737,743 *end=0; /* Remove '=' */ } /* Change all '_' in variable name to '-' */ ! for (end= *option ; *(end= strcend(end,'_')) ; ) *end= '-'; switch (find_type(*option+2,option_types,2)) { case 1: /* port */ -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: RH 7.2 connections problems w 16 web servers to 2 MySQL servers
Sam Iam wrote: We have a very high volume site (3 million page views a day) that's run on 16 Apache / PHP web servers 2 MySQL servers. We are using PHP with persistent connections. Each MySQL serves 8 web servers is supposed to act as a failover machine for the other group of 8 web servers. The failover won't work now as if one MySQL goes down the cost of the 8 web servers switching over is so high the other MySQL locks up. Each Apache / PHP server takes up hundreds of connections even when they're idle so we ran into the Linux connection limit of 1000 had to recompile to get past that. Our actual MySQL CPU useage is low but the goes when with the connection overhead when starting up or failing over a bank of machines. We get a mysterious MySQL lockup once a week at the same day time. Questions : - Is our configuration of 2 sets of 8 Apache/PHP web servers 1 MySQL servers just not a good idea ? - Would we better off with FreeBSD ? I am not sure that would help in this case. - Is there anyone doing any similar setups with lots of web servers a few MySQLs ? - Is there any way to get Apache / PHP to use fewer connections ? PHP and persistant connections might be causing you problems. I can't find it now, but I just read on the MySQL web site that the way PHP handles persistant connection is not good, and even very bad, for busy web sites. It might have been in the server tuning section. Basically the problem is PHP has a pool of connections per thread instead of per server. Jim -- /\ ASCII Ribbon Campaign . \ / - NO HTML/RTF in e-mail . X - NO Word docs in e-mail . / \ - [EMAIL PROTECTED] http://www.FreeBSD.org The Power to Serve [EMAIL PROTECTED] http://www.TheHousleys.net [EMAIL PROTECTED] http://www.SimTel.Net - It's always a long day, 86400 doesn't fit into a short. - 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 on Linux
When I execute mysqld -u root -p password I am presented with the default variables. Which are? How about showing what mysqld --user=root displays? Also, you see linux-bin.* files? That indicates that mysqld was running at some point (maybe nine times). Can you get the directory listings with ls -l ? Sincerely, Steven Roussey http://Network54.com/?pp=e - 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 license problem on Windows
Hi,: I heard that when we use MySQL on windows, we need to pay fees. But I can't find anything on MySQL document to talk about this. Do you know this problem? Thanks a lot! Zengfa __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.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: [linux-lvm] System Suggestions
On Wednesday 06 March 2002 02:40 pm, Petro wrote: On Wed, Mar 06, 2002 at 11:52:30AM -0500, Anthony W. Marino wrote: Could someone, please, provide me with a link and/or facilitate some suggestons for configuration of the following components for a new DB server hosting MySQL 4.01MAX? I'm only looking to get a start and don't expect THE answer since all things are relative and I will have to further test the various scenarios. SuSE 7.3-2.4.18 512MB RAM 4x40GB Maxtor IDE (7200RPM) drives 3Ware 7800 RAID Controller LVM XFS You really don't provide us with enough information here. How big is your database, both in total size and in number of tables. How are those tables utilized, when they get used do you primarily open one table, manipulate it, then close it, or do you go across a bunch of tables? All of these, and more will have a dramatic impact on how you set this stuff up. Thanks. I'm more concerned about any specifics as it applies to MySQL Max and XFS, RAID and LVM as a whole. Are there any nuances as it applies to the whole? Anthony - 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 license problem on Windows
http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.html#MySQL_server_licenses On Wednesday 06 March 2002 1:17 pm, Zengfa Gao wrote: Hi,: I heard that when we use MySQL on windows, we need to pay fees. But I can't find anything on MySQL document to talk about this. Do you know this problem? Thanks a lot! Zengfa __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.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 - 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: SQL coding: Finding singular when search with plural.
At 16:10 2002-03-06, BadgerBay wrote: Hello, This is a good question for when you are sipping coffee or tea and are inspired to write some code. I require additional functionality for my SQL search: MY CURRENT SEARCH SELECT ID, Authors, Year, Title FROM libraryTable WHERE (Authors LIKE '% + varAuthor + %') OR (Keywords LIKE '% + varKeyword + %') OR (Title LIKE '% + varTitle + %'); ORDER BY Year; ADDITIONAL FUNCTIONALITY REQUIRED 1) The search should be able to locate singular words when the plural (s or es) is entered. Example: If singers is entered in the search box, than singer would be found. 1. language-dependent (may not be an issue if all you're using is English - but some languages are more regular than English so it may be even *less* of an issue if what you're using is not English!) 2. gammar-dependent: - not every word that ends in an 's' is a plural (like 'ends' in thi ssentence, or 'grass') - irregular (or more exactly ancient) plurals: child-children to correctly detect plurals you need at least a basic knowledge of grammar - and a dictionary. -- Marjolein Katsma HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools The Bookstore - http://books.hshelp.com/ - Books for webmasters and webrookies - 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 on Linux
when you run mysqld -u root -p password and it gives you the list of default variables. You can get this same message by typing mydqld --help, which might indicate some error in the command line arguments. This file also shows you configurations supplied on the command line as well as configurations found in files such as my.cnf (this may help you). It wont tell you where the value came from, but it will show them. the few lines after the following line might show something of importance: The default values (after parsing the command line arguments) are: It also shows which command line options are allowed. -u or --user are valid, -p however is not listed in those options -Original Message- From: Steven Roussey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 3:13 PM To: 'Intrex' Cc: 'Mysql' Subject: RE: mysql on Linux When I execute mysqld -u root -p password I am presented with the default variables. Which are? How about showing what mysqld --user=root displays? Also, you see linux-bin.* files? That indicates that mysqld was running at some point (maybe nine times). Can you get the directory listings with ls -l ? Sincerely, Steven Roussey http://Network54.com/?pp=e - 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 license problem on Windows
All releases of MySQL were GPL'd, see article: http://www.mysql.com/news/article-23.html John On Wednesday 06 March 2002 15:17, Zengfa Gao wrote: Hi,: I heard that when we use MySQL on windows, we need to pay fees. But I can't find anything on MySQL document to talk about this. Do you know this problem? Thanks a lot! Zengfa __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.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 - 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 license problem on Windows
Hi Zengfa: No. The operating system has nothing to do with it BUT there are requirements for buying a license. Visit http://www.mysql.com/support/arrangements.html for more details. Thx, Craig At 12:17 3/6/02 -0800, you wrote: Hi,: I heard that when we use MySQL on windows, we need to pay fees. But I can't find anything on MySQL document to talk about this. Do you know this problem? Thanks a lot! Zengfa __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.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 - 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[2]: [linux-lvm] System Suggestions
Anthony, I'd be careful with the IDE Raid controller. We just built a lab machine with a Promise IDE Raid controller and the assumption that we could get it and XFS to co-exist. I'm not doing the work, but the engineer that is tells me that the Promise Patch Kit only works with a very limited number of stock Redhat Kernels, and that we are NOT free to add the XFS patch. Even worse, promise does not supply their patch in source, so we are not free to tweak it ourselves. I'm not sure I really believe that, but that is what I'm told. If you do get the 3Ware IDE RAID controller to work with XFS, please let me know. Greg Freemyer Internet Engineer Deployment and Integration Specialist The Norcross Group www.NorcrossGroup.com On Wednesday 06 March 2002 02:40 pm, Petro wrote: On Wed, Mar 06, 2002 at 11:52:30AM -0500, Anthony W. Marino wrote: Could someone, please, provide me with a link and/or facilitate some suggestons for configuration of the following components for a new DB server hosting MySQL 4.01MAX? I'm only looking to get a start and don't expect THE answer since all things are relative and I will have to further test the various scenarios. SuSE 7.3-2.4.18 512MB RAM 4x40GB Maxtor IDE (7200RPM) drives 3Ware 7800 RAID Controller LVM XFS You really don't provide us with enough information here. How big is your database, both in total size and in number of tables. How are those tables utilized, when they get used do you primarily open one table, manipulate it, then close it, or do you go across a bunch of tables? All of these, and more will have a dramatic impact on how you set this stuff up. Thanks. I'm more concerned about any specifics as it applies to MySQL Max and XFS, RAID and LVM as a whole. Are there any nuances as it applies to the whole? Anthony - 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: RH 7.2 connections problems w 16 web servers to 2 MySQL servers
If you can turn on the query log the amount of disk space it takes would be well worth troubleshooting the problem. Try and discern the last queries run on them, in order to help. Perhaps do this twice and you could check for consitency. How much disk space is in use on the drives related to it? Remember that disk space can vary immensley in seconds on some larger servers. Sometimes it may not even claim the space as taken, though it really is, if you catch my drift. Does the mysqld die or lockup? Does the entire server lockup? What day and time do you get it? Are there any cron jobs running that are doing anything? Perhaps someone has a script to pull something off your site once a week, and this is causing it? (Refer to troubleshooting explained above with query log) -Original Message- From: Sam Iam [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 12:06 PM To: MySQL List Subject: RH 7.2 connections problems w 16 web servers to 2 MySQL servers We have a very high volume site (3 million page views a day) that's run on 16 Apache / PHP web servers 2 MySQL servers. We are using PHP with persistent connections. Each MySQL serves 8 web servers is supposed to act as a failover machine for the other group of 8 web servers. The failover won't work now as if one MySQL goes down the cost of the 8 web servers switching over is so high the other MySQL locks up. Each Apache / PHP server takes up hundreds of connections even when they're idle so we ran into the Linux connection limit of 1000 had to recompile to get past that. Our actual MySQL CPU useage is low but the goes when with the connection overhead when starting up or failing over a bank of machines. We get a mysterious MySQL lockup once a week at the same day time. Questions : - Is our configuration of 2 sets of 8 Apache/PHP web servers 1 MySQL servers just not a good idea ? - Would we better off with FreeBSD ? - Is there anyone doing any similar setups with lots of web servers a few MySQLs ? - Is there any way to get Apache / PHP to use fewer connections ? We pay for MySQL support but haven't had much help from them. - Sam. - 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: RH 7.2 connections problems w 16 web servers to 2 MySQL servers
Also, I forgot these questions: - What is Apache's http.conf value of MinSpareServers? - What is Apache's http.conf value of MaxSpareServers? Steven Roussey Network54.com sql,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
foreign key doesn't work with mysql
Hello, I am encountering one problem. I am using mysql as the dabase for my application. I create a table like takeexam as following:create table takelabexam( sid varchar(10) not null, cid varchar(20) not null, marks integer foreign key (cid) references course on Update cascade , primary key (sid, cid,labsection,year)); cid in takelabexam references cid in table courses. so if i update the cid in courses table. the records in table takelabexam which references to courses should be updated automatically. but it doesn't work. Could any one can help me out. i will appreciate very much bin __ Find, Connect, Date! http://personals.yahoo.ca - 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
Converting Access2000 to Mysql: Illegal character issue
Im convertinga couple of fully functioning access databases to mysql, however I had problems converting the data over using a number of tools because of illegal characters especially a colon : in the table column names. Now I can change these names to import the data ok but all of the queries reports etc. are still trying to call up the old names with the colons. is there an easy way around this? Joseph ### Any views in this message are those of the individual sender, except where the sender expressly, and with authority, states them to be the views of Electrolux Home Products Pty. Ltd. ### - 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
foreign key doesn't work with mysql
Hello, I am encountering one problem. I am using mysql as the dabase for my application. I create a table like takeexam as following:create table takelabexam( sid varchar(10) not null, cid varchar(20) not null, marks integer foreign key (cid) references course on Update cascade , primary key (sid, cid,labsection,year)); cid in takelabexam references cid in table courses. so if i update the cid in courses table. the records in table takelabexam which references to courses should be updated automatically. but it doesn't work. Could any one can help me out. i will appreciate very much bin __ Find, Connect, Date! http://personals.yahoo.ca - 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
Syntax question.
Hi, Trying to figure out how to convert Sybase ASA syntax to MySQL. Need to select alpha ranges as in: SELECT * FROM table WHERE name LIKE '[A-Z]%' but this doesn't work. Appreciate your help, Erik Schwartz Systems Engineer InfoUSA 818-428-1040 [EMAIL PROTECTED] --- Outgoing mail was sniffed for Viruses. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/2002 --- Outgoing mail was sniffed for Viruses. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/2002 - 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: Structure as a field
Christian, this is an obvious 'newbie' question, so please bare with me. If you had ever seen me without my clothes on, you would not be asking me to do this! Pardon me for joking at the expense of your English, but I've seen this wording/spelling so often on the lists... Bare = unclothed. Bear = to carry a load. Both pronounced the same way (homophones). Hence bear with me means to help you while you do something, or possibly that we should exercise forbearance (as you have just had to do with me and my warped sense of humor). i'm parsing a lot of data from file, and a good deal of this data is in the form of nested C structs. within any given struct, you might have an array of 256 floats, or an array of 256 structs, with 256 floats, etc, etc. i'd like to have one entry in the field column which can be accessed by name and index. i.e. fieldnameX(1), fieldnameX(2), etc. where the index is the floating point value, a character string, or whatever in an array within a struct. how do i go about doing this, if it's at all possible? (it would seem odd if i had to create n number of fields for each value in an array. especially arrays of large sizes) i'm not looking for the C/C++ or Perl to SQL mechanism, i just haven't found the syntax to create a field of that type in SQL, which is my first, and obvious starting point. Relational algebra deals with data in sets (or tables). The repetition structure is rows. MySQL (and many other RDBMS) does not (yet) have user defined data types, leave alone complex/grouped data types of this nature. So-called object-oriented DBMS are starting to bring in these ideas - which in turn encourages the RDBMS suppliers to move in those directions. However you could try to implement the proposals in your first paragraph by merging (as far as possible) SQL's rows and existing data types with the 256 floats structure, for example, eg a table of 256 rows with one float value column. You could also think about serialising the C data onto a single row with 256 columns, but I think that would be quite unwieldy to implement (just off the top of my head). Moving on to the second paragraph: life is going to get much more complex. You could implement this by having a table with two columns: the index with float or char data type, and the value in the second column. Again, instead of multiplying the number of fields across a row, I'd think instead of going 'down' the rows of a table. The retrieval mechanism would presumably involve a search of the index column and the retrieval of the row's/corresponding value field. I'm not a C-prog. I hope I've not missed some subtlety about the way things work in that language (feel free to 'take a shot' at my expense!) I doubt the above are 'complete' answers for you, but if I can encourage the thinking that got you so far, perhaps you can take it the rest of the way? Regards, =dn (with apologies if your sense of humor was offended) - 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: MyODBC for Core Business, followup...
To all: This is in response to a request for more information. I thought others may find it useful. Thanks so much for your reply. It's good news to hear that someone is relying on MyODBC for an important purpose, much of the usage I've seen seemed rather small. Like I said, we have had not problems with it, other than the problems that Access is causing because of its non-standard implementation of ODBC. I will make note of the fact, however, that we *did* have some issues with the driver, but those were fixed, and those bugs are now no longer a problem. Again, I think when it came right down to it, it was Access issues, and not really MyODBC issues. If you don't mind, I'd like to ask just a few more questions... Not at all. I'll do my best. - Can you describe what your application does a bit? I'm also interested in why you chose the Access/MyODBC route. My reasoning is a desire to PHP on the Web side of things, and certainly the easse and cost of running a MySQL server... The application primarily provides for entry, editing, and procession (through various states) of student government legislation. It also keeps track of who is in what postion, when they were placed and removed, and why. We also plan to implement a module that prints agendas and minutes. We chose Access/ODBC for a few reasons. 1) We were rewriting an existing application, and while it *was* a total rewrite, and went from using a local Access database to using a MySQL server, we wanted to keep the interface and behavior as similar as possible. 2) We wanted more control over format of reports. As much as I hate to admit it, Access does have strong (and pretty easy) report design and generation. This especially comes in handy when printing out official documents. Also, I didn't want to design reports by hand, as I would have had to do in Perl (formating issues, etc). 3) When wanting to update fields on the fly, e.g. change the values available in another field based on a drop down box, it can be very cumbersome to convert that to the web. Either you have to use Javascript and pull a new page every time, or make it a multistep process. It is much easier, from a design viewpoint, to use the instant response of a local GUI. We will, however, have an online module pretty soon here to search and view existing legislation, which was why we moved it to a MySQL back-end in the first place. - Any details on the 'gotcha' issues with Access you mentioned you've been through is certainly appreciated. Some you may have heard, others you may not. 1) Make sure every table has a unique ID field (auto increment works just fine) and a TIMESTAMP field. Access will use those on updates to make sure nothing has changed since it pulled in the record for edit, and to make sure it's only affecting one record. 2) On your connect options (either the FLAGS in connect parameters, or in ODBC setup) make sure you select Don't optimize column width and Return matching rows. Using both of these would make for FLAGS=3 in your connect statement 3) On direct connections, for some reason, using rst.addnew, adding values, and rst.update, then repeating that will repeat the value of the first rst.addnew. I'm quite sure it's an access bug. I have an MDB file with a test case if you are interested. 4) If you don't use the Don't optimize option above, updates using recordssets may end up with truncated data if the new data is longer than the old data. 5) Inserts on direct connections (and an empty table) using recordsets (not a direct INSERT query) fail, and insert blank records. Again, I have a test case for that. - I'm assuming your Access application is all with linked ODBC tables... what type of load does it receive and how is performance (vs. a more typical SQL Server setup if you happen to know)? We use a hybrid linked/direct connection set up. Partially for Gotchas 3, 4 and 5 above. But also for speed. We use some pretty hairy joins in our program. Some as large as 4 or 5 tables. When Access processes that, it breaks it down into 3 or 4 queries (for computability, I'm sure) and sends those. This makes it very slow. In one case, when I pull in a history, it could take 2 or 3 seconds (literally). When I optimized the query, and sent it over the direct connection, it could pull in histories as fast as I could click the mouse. We also use the hybrid setup because reports can't use direct connections. This does, of course, make for a rather dicey situation, since we need to do inserts and updates (sometimes with recordsets) on attached tables. Which means those tables need to be connected with the proper username/permissions. Which means we have the slightly ugly hack of attaching/unattaching the tables everytime someone logs in or out. It's not pretty, but it works. Our next time around for this application is going to be in VB (using
RE: Dual Languages??
Doesn't version 4 support Unicode? - isn't this a solution or am I missing something? DA -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Sent: 06 March 2002 14:48 To: [EMAIL PROTECTED] Subject: Dual Languages?? bipin, Wednesday, March 06, 2002, 9:56:53 AM, you wrote: bvc I have a requirement of storing and retrieving data in 2 languages bvc - namely English and Arabic. bvc From what I have been able to understand, that would require me to have 2 MySQL servers running simultaneously. bvc Can somebody please tel me : 1)if there are any other better ways 2) if this is the right way and if it is 3) how this itself can be made possible It's impossible to run one mysqld with several character sets in present time. We plan to do this in future. bvc Bipin -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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 - 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: foreign keys in mysql
Hi, On Thu, 2002-03-07 at 08:20, bin cai wrote: I am encountering one problem. I am using mysql as the dabase for my application. I create a table like takeexam as following:create table takelabexam( sid varchar(10) not null, cid varchar(20) not null, marks integer foreign key (cid) references course on Update cascade , primary key (sid, cid,labsection,year)); cid in takelabexam references cid in table courses. so if i update the cid in courses table. the records in table takelabexam which references to courses should be updated automatically. but it doesn't work. Could any one can help me out. i will appreciate very much http://www.mysql.com/doc/A/N/ANSI_diff_Foreign_Keys.html Regards, Arjen. -- MySQL Training in Brisbane: 18-22 March, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia ___/ 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
Timestamp function formatting bug?
With MySQL 3.23.38: If you have a TIMESTAMP column with zero values, then SELECT ts from table; returns 00 But SELECT min(ts) from table; returns 0 This causes the JDBC driver to fall over when getting the timestamp value from this query. Isn't this a formatting bug? min() and max() should inherit the same type and formatting as their underlying data type, no? -- Shankar. - 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
OFF-TOPIC Create 4 componets to make the 4 bisics operation in a DB
Hi everyone, I know some softwarehouses develop some components in orde to make esier their project. So, folliwng the same steps I would lihe to do develop 4 component to make the 4 basisc operations in a DB:a INSERTER, UPDATER, SELECTER and DROPPER. Imagine the aplication has a class or an object wich is the user layer and has form the the user write some information and this information shuold be record in the DB. Supose variables recive the datas of the form and now you make an INSERT operation and this class or object will sent a message to the INSERTER class. This class will do all the insert operation of any object the requires it. So in the SQL querry instead of the name of the field of the DB there will be variables wich will recive the name of the field, but how? I was thinking use hashing. I sad above variables will recive the datas of the form, the will associate the name of the variable with the of the DB field. It's a crazy mess! But when done, it works! If any wouldo like to discuss it, please PVT-ME, I 'd like to implement it in PHP, Objetc Pascal (Delphi or Kylix) or evem in Java. Thanks for giving me your atention. See you! - 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