RE: wildcard character in sql grant statement
Hey Scott, Try: GRANT ALL ON DATA.* TO user1@"%" IDENTIFIED BY "password" /or simply/ GRANT ALL ON DATA.* TO user1 IDENTIFIED BY "password" Not specifying a domain defaults to %. HTH Ben -Original Message- From: Scott Meesseman [mailto:[EMAIL PROTECTED]] Sent: 09 April 2001 01:27 To: [EMAIL PROTECTED] Subject: wildcard character in sql grant statement Hello, Is there a new wildcard character in 3.23? I am trying to use the grant statement GRANT ALL ON DATA.* TO user1@% IDENTIFIED BY "password" It doesnt seem to like the % as it returns an sql error Thanks for your time, Scott - 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
problem of MYSQL GUI
I am experienced a problem of using MYSQL GUI on windowME to connect mysql server, which was v3.22 and installed on open linux . I couldn't make any connection with it and don't know why. I checked my password and Ip address, they both are correct and working properly. please be kind to giving hand Thanks
Re: Disappearing \
Hi On Monday 09 April 2001 05:34, Jack A. Tinsley Jr. wrote: First, things, first - I am a newbie to MySQL but I have it up and running quite well. The only thing I haven't been able to figure out is why I'm losing "\" (back slashes) in my stored data. I have a application I'm considering MySQL for and one table must have a column containing a UNC path. When I insert the value of "\\server\folder", MySQL turns it into "\serverfolder" - very strange. I've set this column up as a varchar. Actually, this behaviour is not strange it is correct, since the '\' character is considered an escape character. If you want to insert the value "\\server\folder" you would need to add extra '\' characters i.e. "\\\server\\folder" - 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 -- Regards John -- MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / John Dean [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mansfield, England, UK ___/ - 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: Disappearing \
Without being picky, and just to let Jack know, the line: "\\\server\\folder" should be: "server\\folder" Each double slash pair (\\) is replaced in the database with one slash (\). I recommend you take a look at the AddSlashes() and ereg_replace() functions if you're using PHP (http://php.net), or looking at some regular expressions for perl in order to format strings for database insertion. Ben -Original Message- From: John Dean [mailto:[EMAIL PROTECTED]] Sent: 09 April 2001 08:25 To: Jack A. Tinsley Jr.; [EMAIL PROTECTED] Subject: Re: Disappearing "\" Hi On Monday 09 April 2001 05:34, Jack A. Tinsley Jr. wrote: First, things, first - I am a newbie to MySQL but I have it up and running quite well. The only thing I haven't been able to figure out is why I'm losing "\" (back slashes) in my stored data. I have a application I'm considering MySQL for and one table must have a column containing a UNC path. When I insert the value of "\\server\folder", MySQL turns it into "\serverfolder" - very strange. I've set this column up as a varchar. Actually, this behaviour is not strange it is correct, since the '\' character is considered an escape character. If you want to insert the value "\\server\folder" you would need to add extra '\' characters i.e. "\\\server\\folder" - 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 -- Regards John -- MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / John Dean [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mansfield, England, UK ___/ - 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: Hierarchical lists
just some thoughts, this is a nice way of creating one "tree"-table of unlimited levels, top-level-items has for example parent_id -1, and if you want to get the items (the childs of a parent) just say select * from items where parent_id = x create table items ( item_id int unsigned not null auto_increment parent_id int unsigned not null default -1 somedata varchar(1000) ) kinds regards Tomas - Original Message - From: "Realbad Atgames" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 09, 2001 1:12 AM Subject: Hierarchical lists Hello, I'm new to MySQL and have ran into a problem in designing my database. I have a table of items, A, and each item should have any number of other records from another table, B, associated with it. I also need to have any number of records from table C associated with table B. They need to be associated in such a way that I can quickly find out what is associated with a record in table A, as well as what is associated with a record in table B. In other words, how do I store an array of pointers? What's the best way to do this? I couldn't find anything relevant in the docs. Any help greatly appreciated. __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.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
mysql/mysql++ fail on sun-solaris-sparc with segfault
(that was already sent to [EMAIL PROTECTED]) Description: Programs, compiled with mysql++ on that machine, abort with a segfault at an attempt to connect to the mysql server, while programs using Mysql C API (for instance, mysql's own benchmark suite) and the same programs executed on a local Linux machine run OK. I used mysql++-1.7.8 and recent stable 3.26.36 mysql (source). According to debugger's backtrace, it stops with signal 11 (and message: 'Segmentation fault (core dumped)') in mysql connection / memory allocation code: (gdb) bt #0 0xef545c18 in _malloc_unlocked () #1 0xef545b38 in malloc () #2 0xef78acec in my_malloc () #3 0xef7899c0 in vio_new () #4 0xef786a28 in mysql_real_connect () #5 0xef5c6568 in MysqlConnection::real_connect () #6 0xef5c5e74 in MysqlConnection::MysqlConnection () #7 0x2e398 in main () at test1.cc:9 It is not only my programs that fail like that, all the mysql++ examples abort exactly this way. Interestingly enough, one of the programs I use behave a bit differently. It starts with "Bad free() ignored" message and stops with 'Abort (core dumped)' message. Debugger produces the following backtrace (formatted manually for readability): (gdb) bt #0 0xef50828c in _libc_kill () #1 0xef4ba608 in abort () #2 0xef578bd0 in Letext () #3 0xef578c00 in __terminate () #4 0xef579708 in throw_helper (eh=0xef59be4c, pc=0xef5c7bff, my_udata=0xefffec70, offset_p=0xefffec6c) #5 0xef579910 in __throw () #6 0xef5c7c00 in MysqlConnection::execute () #7 0x111e38 in basic_stringchar, string_char_traitschar, __default_alloc_templatefalse, 0 ::unique () #8 0x10f51c in basic_stringchar, string_char_traitschar, __default_alloc_templatefalse, 0 ::append () #9 0x10af58 in MysqlQuery::~MysqlQuery () #10 0x4193c in _init () #11 0x3b6b4 in _init () #12 0x3cb04 in _init () #13 0x3dfb8 in _init () The more detailed report and listing of debugger outputs and some code is available online for your reference at: http://netec.mcc.ac.uk/HoPEc/g4/mysql-problem-details.txt I've tried several versions of mysql deamon (mentioned in the details doc), and to recompile mysql and mysql++ several times with two versions of gcc (2.95.1 and 2.95.2) and with different options (according to Mysql Documentation/installation/system specific/Solaris recommendations), with little success and minimal changes of soft behaviour. I've also tried --safe-mode and --loging but that didn't make situation clear, but please look into the details file mentioned above: may be for you it will make something clear. How-To-Repeat: should be obvious from the above description Fix: no idea, sorry Submitter-Id: submitter ID Originator:ivan kurmanov, [EMAIL PROTECTED] Organization: RePEc, http://repec.org MySQL support: none Synopsis: synopsis of the problem (one line) Severity: critical Priority: high Category: mysql mysql++ Class: sw-bug Release: mysql-3.23.36 (Source distribution) Environment: Library used: Mysql++ 1.7.8 System: SunOS irwell 5.6 Generic_105181-20 sun4u sparc SUNW,Ultra-Enterprise Architecture: sun4 Some paths: /home/adnetec/usr/local/bin/perl /home/adnetec/bin/make /usr/local/bin/gmake /home/adnetec/usr/local/bin/gcc /opt/SUNWspro/bin/cc GCC: Reading specs from /home/adnetec/usr/local/lib/gcc-lib/sparc-sun-solaris2.6/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='-O6 ' CXX='c++' CXXFLAGS='-O6 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti ' LDFLAGS='' LIBC: -rw-r--r-- 1 bin bin 1608144 Feb 7 2000 /lib/libc.a lrwxrwxrwx 1 root root 11 Jun 21 1999 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 1014272 Feb 7 2000 /lib/libc.so.1 -rw-r--r-- 1 bin bin 1608144 Feb 7 2000 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Jun 21 1999 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 1014272 Feb 7 2000 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/home/adnetec/Ivan --with-unix-socket-path=/home/adnetec/Ivan/tmp/mysql.socket --with-low-memory --enable-assembler Perl: This is perl, version 5.005_02 built for sun4-solaris NB: I didn't send this report with mysql-bug script, I just used its output for this message as draft, because I couldn't send mail from that machine, it is remote for me. Sorry, if that sets any limits to usefulnes of this report. Ivan - 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
how to make a jdbc connection?
HI Friends ... I wish u help me in this problem ... I have installed the mysql(recommended version) For NT(my platform) and the odbc, and finally I installed the mm.mysql.jdbc-1.2c.zip and made all the required configurations . Mysql driver works properly and I build a database using the SQL Commands, it works fine ... The problem is : When I need to connect my databse with my JSP page, it asks me for a connection ... So How can I make a connection for my database named (mailingdb)that I can connect it to my JSP page ? Please I need help as soon as possible Thnx in Advance ... Hanan _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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
3.23.36: mysqlshow, mysqldump problems
Hi, After Upgrade to 3.23.36 from source tarball on debian 2.2r2 potato with kernel 2.4.1 not mysqlshow neither mysqldump show results. Only the version will be prompted. Access via mysql-client is working. All databases are myisam-dbs. Access via phpmyadmin doesn't work because of the malfunction of mysqlshow Any hints? Thanks Martin - 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
Linking errors
Hi!, My application uses an archive 'libmysqlclient.a' and another object module 'dblib.o' which internally make calls to functions supported by 'libmysqlclient.a'. So i decided to use a single archive file containing both of them i.e. 'libmysqlclient.a' and 'dblib.o'. At link time, i get 'undefined reference' errors for all functions defined in dblib.o although the archive file contains dblib.o. I tried to move dblib.o at various positions in the archive file but it makes no difference. I still get undefined reference errors for all functions defined in dblib.o. If i link them as seperate files i.e. 'libmysqlclient.a' and dblib.o rather than having both of them in a single archive file, it works. Can somebody tell me the reason why that happens?? If possible let me know how can i make things work by still having a single archive file. Thanks, Rahul - 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
Oracle = MySQL migration
Is it somebody out there who has made a migration from an Oracle server to an MySQL server?? (Or do I have to talk to those NASA guys again?? =))) The scenario is as simply: A SUN machine with an Oracle 8.1.7 server with a database with content that I want to transfer to a MySQL database. No special data, constraints etc that MySQL not will handle. My solution is to reverse engineer the database from ERStudio and then produce a SQL script that will insert the data into the MySQL engine. But I can't do this, because the customer want me to do a PL/SQL script that does this, even if he never have worked with Oracle.. So the question is.. Do someone know a simplier way to do this (perl script, or whatever) or do I have to teach myself PL/SQL and make a script that produces a MySQL sql script ? Regards, Johan Andersson Consultant - 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: WinMySQLadmin database view fields misaligned
Lance Benson writes: In my version of WinMySQLadmin (v 3.23.33 running on Windows98, said on the MySQL site to have been modified 3/1/1), in the Databases tab, in the Table Columns frame, the Fields do not display properly. The first one is ok, but then the name of the second field/column is in the column labelled "Previleges" (the last column in this view). Every subsequent Field name appears shifted back one additional column. Hi! This is a bug that is already reported and which is worked upon. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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
Deleted user
I've made a stupid error. While logged in as root I was deleting records from the user table. Someone was talking to me while I was entering a command and I didn't realize what I entered until it was too late. I entered: delete from user where user='root'; I immediately used an insert statement to re-insert the root entry, but it's not working. I can still log in as root but appear to have lost access to the mysql database. Is there any way to recover? Thanks, Bob - 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: unsecsribe me
At 11:06 09-04-2001 +, you 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: database,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. You have written the following: please remove me from mailing lists - 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: Deleted user
I've made a stupid error. While logged in as root I was deleting records from the user table. Someone was talking to me while I was entering a command and I didn't realize what I entered until it was too late. I entered: delete from user where user='root'; I immediately used an insert statement to re-insert the root entry, but it's not working. I can still log in as root but appear to have lost access to the mysql database. Ways -Reinstall mysql, the databases will not lost, but the mysql table will updated -try to restart the mysql server... if u didnt enter 'flush privileges' it can help Rebirth - 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: Deleted user
stop mysql service, restore the backup from the mysql.user table (or: copy from a other mysql with known users, or: copy from the installation files), restart mysql. - Original Message - From: "Bob Dushok" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 09, 2001 1:09 PM Subject: Deleted user I've made a stupid error. While logged in as root I was deleting records from the user table. Someone was talking to me while I was entering a command and I didn't realize what I entered until it was too late. I entered: delete from user where user='root'; I immediately used an insert statement to re-insert the root entry, but it's not working. I can still log in as root but appear to have lost access to the mysql database. Is there any way to recover? Thanks, Bob - 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: Possible silly Question
Thanks very much for your help on this, it is appreciated. I downloaded and ran the appropriate makefiles as the readme files said, however when I get to running install Bundle::DBD::mysql then I get an error telling me that it does not have an associated bundle so it cant continue...I know this is probably because I have done something out of sequence ( am sure its a case of "user error" :-) ) any idea's what I have done ?? I have gone back and retraced my steps and ran the whole process right from downloading again but with the same results...any idea's ?? Thanks again for the help Regards Davidt -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: 06 April 2001 17:17 To: David Thomas Cc: [EMAIL PROTECTED] Subject: Re: Possible silly Question On Fri, Apr 06, 2001 at 04:48:52PM +0100, David Thomas wrote: I am quite a newbie on using MySQL so any help would be appreciated. I have managed to install MySQL smoothly (or so I thought) and the mysqld starts without any problems. However, on trying to use the mysql_setpermission script I get errors of: Cant locate DBI.pm in @inc @inc contains: /usr/lib/perl5/5.00503/i386 snip I have got perl installed but I believe that it is a different version number to the one that MySQL is trying to locate the path for...I guess my question is...what file do I need to alter to reflect the correct path for this or have I got it completely wrong... Thank you for any help you can give on this...its driving me nuts :-) Regards David Thomas Perl may be installed, but it's not necessarily true that DBI is installed. You'll need to obtain and install it (along with DBD::mysql and Data::Dumper). Links for obtaining these are available at: http://www.mysql.com/downloads/api-dbi.html If these things are installed but in a directory that Perl doesn't normally looks in, put a line like this to modify your script's search path: use lib qw(/path/to/directory/); This should go before the use DBI; line. - 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/mysql++ fail on sun-solaris-sparc with segfault
HI! This is due to a bug in connection.cc. Rebuild MySQL++ with this source and you will have no more problems like this. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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: REXEXP in select only works with short expressions on Alpha
[EMAIL PROTECTED] writes: Description: When transfering a database application to use an Alpha Linux server rather than intel Linux previously working regular expressions fail to work. It appears to be due to a length limit. This effects both binary downloads and home compiled distributions. How-To-Repeat: Simple test case (with results) mysql create table test (xxx char(128)); Query OK, 0 rows affected (0.00 sec) mysql insert into test (xxx) values('this is a test of some long text to see what happens'); Query OK, 1 row affected (0.00 sec) mysql select * from test where xxx regexp('is a test of some long text to'); +--+ | xxx | +--+ | this is a test of some long text to see what happens | +--+ 1 row in set (0.00 sec) mysql select * from test where xxx regexp('is a test of some long text to '); Empty set (0.00 sec) mysql select * from test where xxx regexp('is a test of some long text to s'); Empty set (0.00 sec) mysql select * from test where xxx regexp('is a test of some long text to se'); Empty set (0.00 sec) mysql select * from test where xxx regexp('test of some long text to se'); +--+ | xxx | +--+ | this is a test of some long text to see what happens | +--+ 1 row in set (0.00 sec) Fix: Unknown - I have revererted to the working Intel system - hopefully this a fix will be found soon since the original move was due to capacity problems on the intel hardware ! Submitter-Id: submitter ID Originator: [EMAIL PROTECTED] Organization: MySQL support: [none] Synopsis: on linux Alpha regexp does not work with long expressions Severity: critical Priority: high Category: mysql Class: sw-bug Release:mysql-3.23.36 (Source distribution) Environment: System: Linux rossem.octopus-technologies.co.uk 2.2.14-6.0 #1 Tue Mar 28 16:56:56 EST 2000 alpha unknown Architecture: alpha 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/alpha-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Apr 7 17:16 /lib/libc.so.6.1 - libc-2.1.3.so -rwxr-xr-x1 root root 8070122 Mar 27 2000 /lib/libc-2.1.3.so -rw-r--r--1 root root 18837112 Mar 27 2000 /usr/lib/libc.a -rw-r--r--1 root root 180 Mar 27 2000 /usr/lib/libc.so Configure command: ./configure Perl: This is perl, version 5.005_03 built for alpha-linux Hi! Please try using gcc 2.95.2 and let us know if problem reccurs. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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: Searching text fields
database,sql,query Hi All, Is there a nice way to take a search string eg "America spying China" and search a text or blob field for occurances of all of the words in the text in any order (ie not just a literal string match, but the equivalent of AND X LIKE "%America%" AND X LIKE "%China%" AND X LIKE "%spying%") I'm not on the list so please reply to this address. Thanks in advance, Mark. -- Mail Headers -- - 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: Enquiry
I bet you downloaded the source code version and not the binary version. check your download. Daniel Katcher 202-619-7643 ( voice ) 202-619-7655 ( fax ) [EMAIL PROTECTED] "Amit" [EMAIL PROTECTED] 04/07/01 12:40PM Dear Sir, This a mail from a new established software company. We are developing a software using vb6.0 as front-end and want to use MYSQL as back-end. We have already downloaded it from your site. It was the latest version MYSQL 3.23 for win95/98. But now we don't know how to install it on our system because we are unable to find any setup.exe or install.exe file in it. and the make_dir.bat file is causing a problem and does not execute. Another information we want is that wheather our software which is developed in VB 6.0 will be able to access the database in MYSQL if it is not installed on our client's machine. - 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: problem of MYSQL GUI
I am experienced a problem of using MYSQL GUI on windowME to connect = mysql server, which was v3.22 and installed on open linux . I couldn't make any connection with it and don't know why. =20 I checked my password and Ip address, they both are correct and working = properly. please be kind to giving hand Thanks Hi! All you have to do is follow instructions from the README file that came with mysqlgui. Here is a relevant excerpt : When you start it for the first time, click on ``Options'' button, fill up all entries correctly and click on ``Save'' button. From then on, you will logon automatically to the running server on every mysqlgui startup. Take care to put the right value in ``Ask for password'' button. Also, if you have problems with location of socket files on *nix, enter a full path of the socket file in the ``SQL command on the start-up''. This input field is used on Windoze if you wish to specify that named pipe option. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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
Slave to host connection
Hi there, the master is running on 192.168.1.2 and the slave on 192.168.1.5 , yes, the master is running. the user name and password are correct. actually i dont think it gets to the state of actually verifying the user name and password. even if i do just a mysql -h 192.168.1.2 it gives me an immediate error at 192.168.1.5 [root@linux] /var/lib/mysql# mysql -h 192.168.1.2 -P 3306 -u slave -p Enter password: ERROR 2003: Can't connect to MySQL server on '192.168.1.2' (111) there are no errors at the server side and the error log is clean Mathew - 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
Can i get type IV driver for MySQL
Hi I am MySQL as database in my project. Can i get Type IV driver for JDBC to connect with database. If so, can u send me the information. If not, when can i get drivers information for JDBC. thanks in advance bye venkatesh - 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 from a newbie...
Hello, i would like to know if it is possible to have mysql running on a unix server (HP-UX 11) and a C++ client application running on windows. Thanx for your help, Aurlien - Ce message a ete envoye grace a Endymion MailMan. depuis l'adresse : 194.2.91.222 - 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: table locking
http://www.mysql.com/doc/I/n/Internal_locking.html Hope this helps. -- Rodney Zach Hollandsworth wrote: Is there an explanation somewhere about the rules mysql uses when lock tables? - 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: Transactions in MySql
Marco Baldacchini wrote: MySql support transactions? The OLE-DB provider support transactions? Call the method Begintrans on a connection object (ADO) return an error!!! And you read the manual, right? Transaction support depends on the version of MySQL you are running, and the table type created. Read the manual, then ask questions. - 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: Commands
Well, if this is zdnets's MySQL tutor, I would suggest you find another one, or get the book "MySQL" by Paul DuBois ( New Riders ). This command will not work, even if you are in the MySQL monitor. You can start right now by reading the manual that comes with the MySQL package. Once you have read the instructions and examples, you will be better prepared to post questions here. To answer your question; you need to be in the monitor. I don't run windows, but it should be something like cmysql.exe or mysql.exe. Ben Butler wrote: Dear sir/madam, I am new to MySQL and downloaded it last night. I now have it running on my Windows 2000 Server but have a rather large problem. This may sound stupid but everywhere in the manual etc there are commands for me to enter, eq I an learning from zdnet.com how to use MySQL and it has told be to use the following statemt to create a table: CREATE TABLE TipsTable (tipID INT IDENTITY, subDate DATETIME DEFAULT GETDATE(), author VARCHAR(50), journal VARCHAR(3), title VARCHAR(255), tip TEXT) but the problem is I dont know where to type this statement. There are also other commands in the manual but I just dont know where to enter them. PLEASE HELP ME Thanks, Ben Butler - 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
Does Mysql support QNX RTP
Could please let me know whether Mysql database can be used with QNX realtime 4.25? If so which version? What are the terms for commercial licensing? Can I get a trial version. I appreciate your help Thanks Lekha Das - 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: Slave to host connection
To eliminate DNS problems, put each machine in the others /etc/hosts file. MCA Department PESIT wrote: Hi there, the master is running on 192.168.1.2 and the slave on 192.168.1.5 , yes, the master is running. the user name and password are correct. actually i dont think it gets to the state of actually verifying the user name and password. even if i do just a mysql -h 192.168.1.2 it gives me an immediate error at 192.168.1.5 [root@linux] /var/lib/mysql# mysql -h 192.168.1.2 -P 3306 -u slave -p Enter password: ERROR 2003: Can't connect to MySQL server on '192.168.1.2' (111) there are no errors at the server side and the error log is clean Mathew - 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: Deleted user
THe manual recommends restarting the server with --skip-grants. Fix your user table, and flush privileges to reload the grant tables. Bob Dushok wrote: I've made a stupid error. While logged in as root I was deleting records from the user table. Someone was talking to me while I was entering a command and I didn't realize what I entered until it was too late. I entered: delete from user where user='root'; I immediately used an insert statement to re-insert the root entry, but it's not working. I can still log in as root but appear to have lost access to the mysql database. Is there any way to recover? Thanks, Bob - 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]: Some more about mysql perfomance.
Hi! "Peter" == Peter Zaitsev [EMAIL PROTECTED] writes: cut Peter It's a pity what mysql misses something like PROFILE call for the Peter query so I could check how much time is spent for different phases of Peter query execution. MW Any suggestions for the output for this? Peter Well Yes. It should be the table with some columns - first name of Peter stage, second some additional info, and the last one the time taken. Peter The problem is some info can be collected only on client - i.e time Peter to send query and time to send resive all data. Also some interesting Peter indo may be printed about caches (misses/hits) Peter Totaly it would be nice to have something like Peter Send query to server Peter pharse query Peter open tables Peter make plan Peter Read keys 1024512 Hits 512 Mises Peter Read rows 10121056 Fragments Peter Send result to client Peter So the idea is to get not only timings data on different stages, but Peter also some additional information from different stages for example Peter number of key cache misses and hits. Peter The other odea is to have an special compile option profile - so Peter information will be gathered and aviable via special interface after Peter each query so it can be processed on application special way. We plan in 4.0 to add a 'show thread status' command to get status per connection; This will make it much easier to do things like this. cut 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
RE: mysqlbug
hi i downloaded Linux (Intel libc6 systems) [pc-linux-gnu-i686] i have uncompressed it and untarred it onto a PC. but i cannot find the necessary make and make install files to compile and run sql ! why is that ? machine i am running on is P166, 64mb ram using red hat linux 7. thanks i hope you can help ! Regards Khuram Khan - 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: mysqlbug
That is a binary tarball. If you want to compile it, download the source. [EMAIL PROTECTED] wrote: hi i downloaded Linux (Intel libc6 systems) [pc-linux-gnu-i686] i have uncompressed it and untarred it onto a PC. but i cannot find the necessary make and make install files to compile and run sql ! why is that ? machine i am running on is P166, 64mb ram using red hat linux 7. thanks i hope you can help ! Regards Khuram Khan - 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: select into outfile problem
On Mon, Apr 09, 2001 at 03:48:43PM +0200, Niklas Rudemo wrote: I'm trying to select into outfile to a file that already exist. This has been discussed before, I know, but the solution suggested results in an SQL-error, as shown below. So what's the real solution? Select your rows into a temporary table, which will allow you to run several queries to obtain the rows. Then use SELECT ... INTO OUTFILE with the temporary table (into a file that doesn't exist). Niklas Rudemo Virtutech mysql select * into outfile 'person.txt' from person; Query OK, 0 rows affected (0.00 sec) mysql select * into outfile 'person.txt' from person; ERROR 1086: File 'person.txt' already exists mysql select * into outfile 'person.txt' REPLACE from person; ERROR 1064: You have an error in your SQL syntax near 'REPLACE from person' at l ine 1 - 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
logging doesnt work with bdb if --with-debug
Description: oliver After several sig 11 I compliled a --with-debug version and enabled oliver debugging and logging. Mysqld crashed shortly after starting without oliver trace (!) and then immediatly crashed again after restart. oliver /sw/pkg/mysqldebug/3.23.36/libexec/mysqld: ready for connections oliver mysqld got signal 11; oliver The manual section 'Debugging a MySQL server' tells you how to use a oliver stack trace and/or the core file to produce a readable backtrace that may oliver help in finding out why mysqld died. oliver 010407 20:37:48 mysqld restarted oliver __db_assert: "( logp-dbentry[i].dblist)-tqh_first == ( dbp)" failed: file "../.././bdb/dist/../log/log_rec.c", line 433 oliver 010407 20:37:48 mysqld ended How-To-Repeat: oliver Compile mysql with --with-debug and --with-berkeley-db, use bdb tables oliver and run mysqld with --debug --log Fix: oliver Dont do that :/ Actually, the above problem has nothing to do with debugging. The problem is that you have got something bad in the BDB log files, which BDB because of some strange reason can't resolve. Fix: Remove all filed of type 'log.xxx' from the MySQL data directory and restart MySQL. If you get this problem again, then where is what you should try to do: - Dump all BDB tables to text files. - close down mysqld - Remove all log files of the above format - Move all BDB tables to some secure place (as a backup) - Restart mysqld - Read back the BDB tables. If you get a crash, make a copy of log files and the bdb tables and contact us; We will help you make a bug report that we can send to the Berkeley DB people to help sort this out; They are very dedicated in trying to find and fix any bugs in their recovery code. 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
show databases forbidden or limited to the owner database
Hello, is it possible to prevent users from seing other databases than the one there are using ? I thought it was possible using priveleges and "Select_priv", but It doesn't work... I am using 3.23.33 Thanks in advance for your help... - Fabien SALVI Centre de Ressources Informatiques Archamps, France -- http://www.cri74.org PingOO GNU/linux distribution : http://www.pingoo.org - 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: show databases forbidden or limited to the owner database
Try putting a line in your my.cnf that contains: safe-show-database This will only allow the user to see databases that they have permissions for You can optionally use skip-show-database, which will not allow the command at all. John Barton Unix Systems Administrator Primary Networks, Inc. [EMAIL PROTECTED] On Mon, 9 Apr 2001, Fabien Salvi wrote: Hello, is it possible to prevent users from seing other databases than the one there are using ? I thought it was possible using priveleges and "Select_priv", but It doesn't work... I am using 3.23.33 Thanks in advance for your help... - Fabien SALVI Centre de Ressources Informatiques Archamps, France -- http://www.cri74.org PingOO GNU/linux distribution : http://www.pingoo.org - 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: show databases forbidden or limited to the owner database
I sent that reply about this 1 WEEK Back. Look up safe_show_databases and skip_show_databases in http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html regards, thalis On Mon, 9 Apr 2001, Fabien Salvi wrote: Hello, is it possible to prevent users from seing other databases than the one there are using ? I thought it was possible using priveleges and "Select_priv", but It doesn't work... I am using 3.23.33 Thanks in advance for your help... - Fabien SALVI Centre de Ressources Informatiques Archamps, France -- http://www.cri74.org PingOO GNU/linux distribution : http://www.pingoo.org - 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 ServerClient Myodbc Silent installation successfully completed
the page must be : http://www.avukatpro.com/mysql.html but i really don't know this is included as my signature and this page contains mysql and visual basic samples. not included about silent install yet. Regards. Yusuf INCEKARA - Original Message - From: John Steele [EMAIL PROTECTED] To: Yusuf Incekara [EMAIL PROTECTED] Sent: Sunday, April 08, 2001 9:39 PM Subject: Re: Mysql ServerClient Myodbc Silent installation successfully completed Hello, I would be interested in a copy. Do you have it available from a website or ftp machine? BTW, your link in your signature returns a directory listing denied page (www.avukatpro.com/mysql). John At 4/8/2001 09:13 AM, you wrote: I have created a setup program using Wise Windows Installer Professional 3.0 . I also create a merge module. It can distribute mysql odbc driver and set it installed ot target windows system by using odbcinst.ini and odbc ini and required registry key. My setup uses that merge module and distribute out commercial software , mysqlserver , mysql client , myodbc with odbc2.5 and 3.0 support , creates a required dsn etc... by using just one install button :) And it works perfect. If anyone need this please mail me. If i get too many mail i will put theese subject on our company web page. Regards. Yusuf Incekara Avukatpro Limited Sirketi http://www.avukatpro.com/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 -- /* SteeleSoft Consulting John Steele - Systems Analyst/Programmer * We also walk dogs... PHP/MySQL/Linux/Hosting - [EMAIL PROTECTED] *http://www.steelesoftconsulting.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: mysqlbug
#--That is a binary tarball. #--If you want to compile it, download the source. What you mean with tarball? Its supposed just to uncompress it and it should work?
MySQL Server
Hi everybody, I am new to MySQL. I have Linux server through my hosting company. I want to install MySQL on server. I need your help in this regard how I can install the same on my remote server? Thanks in advannce. Anoop _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.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: show databases forbidden or limited to the owner database
"Thalis A. Kalfigopoulos" wrote: I sent that reply about this 1 WEEK Back. Look up safe_show_databases and skip_show_databases in http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html regards, thalis On Mon, 9 Apr 2001, Fabien Salvi wrote: Hello, is it possible to prevent users from seing other databases than the one there are using ? I thought it was possible using priveleges and "Select_priv", but It doesn't work... I am using 3.23.33 Thanks a lot for your help to you and John Barton. I am new on this list and I didn't see your previous post about it, sorry (I should have check it on the archives...). Notice = there is a bug in the documentation "safe_show_databases" instead of "safe_show_database". B.R. - Fabien SALVI Centre de Ressources Informatiques Archamps, France -- http://www.cri74.org PingOO GNU/linux distribution : http://www.pingoo.org - 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: problem with jdbc
On Sunday 08 April 2001 12:59, Kamil Yildirim wrote: --- Sasha Pachev [EMAIL PROTECTED] wrote: On Saturday 07 April 2001 17:59, Kamil Yildirim wrote: Hi I have a problem with SQL UPDATE statement within a Java programm which establish a connection to a Mysql Server over JDBC. The SQL UPDATE statement looks like that: UPDATE tableX set x = x + ? where rowx = ? where the walue of ? on the x = x + ? part my some Server Version 3.22.32 3.22 branch does not handle updates of a key with the where clause containing same the key properly. To fix, upgrade to 3.23.36. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - 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: mysqlbug
it seems to be working after i type safe_mysqld --log but i get this message when i try to run mysql , i try creating a database using mysqladmin but the same socket thing comes into it ! my error message mysql admin connection to localhost failed error can't connect to local mysql server through socket /var/lib/mysql/mysql.sock (111) check that mysqld is running and the socket /var/lib/mysql/mysql.sock exists ! ok everythings is running ! but why do i get this when i try and run 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: MySQL Server
I am new to MySQL. I have Linux server through my hosting company. I want to install MySQL on server. I need your help in this regard how I can install the same on my remote server? Read: - this lists archive before sending questions - www.devshed.com - many many other websites.. you can find most of them via searchengines.. You need to study a LOT.. Bye, B. - 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: ./configure help
I would think it is because you don't have all of the development tools in place. also the path to mysql must be ok. On Sat, 07 Apr 2001 17:56:41 +0200, B. van Ouwerkerk wrote: At 17:25 7-4-01 +0200, com2 wrote: hi everybody we get this err mex when we run: ./configure --prefix=7usr/local/mysql Hrrr, 7usr/local/mysql ? dunno if that's the reason.. but it might not be able to find such path. /usr/local/mysql perhaps?? Bye, B. - 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: bug report - docs
On Sun, Apr 08, 2001 at 12:22:32PM -0500, Rodrigo Zerlotti wrote: Description: INSTALL-BIN file has errors: shell chown -R mysql /usr/local/mysql/var it should be chown -R mysql /usr/local/mysql/data instead "var" Thanks, Rodrigo. I have fixed it now. Tim -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Tim Smith [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Development Team /_/ /_/\_, /___/\___\_\___/ Boone, NC USA ___/ 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
Security
Okay, I'm about to rip my hair out trying to figure this out, and I thought before I start looking for a gun, maybe I should ask.. I need someone to explain the 'mysql' database to me. I've tried reading about it, tried different settings, but I'm lost. So far I've just been adding users and db's to the 'db' and 'user' tables, but something tells me that's not all there is to it. What are the other tables for? And how's about adding a user that can only access (and change) their DB (assigned by me), and/or adding a (different) user that can create their own DB(s), yet not muck with anything else on the entire (mysql) system (and screw up other users). I'm willing to entertain even more literature if that's easiest to point me to, but like I said, I've gone through the online docs, I've checked other resources online, and I'm still lost. AMK4 -- W | | I haven't lost my mind; it's backed up on tape somewhere. | ~ Ashley M. Kirchner mailto:[EMAIL PROTECTED] . 303.442.6410 x130 SysAdmin / Websmith . 800.441.3873 x130 Photo Craft Laboratories, Inc. .eFax 248.671.0909 http://www.pcraft.com . 3550 Arapahoe Ave #6 .. . . . . Boulder, CO 80303, USA - 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
BUG: Cannot DELETE all records with NULL entries in UNIQUE KEY fields
Description: Attempting to delete all records in a table containing NULL values in a UNIQUE KEY field does not work as expected. Only a single record is deleted, presumably because the server thinks that the table will only have one record with a NULL value in it (as it is in a UNIQUE field). How-To-Repeat: Run the following SQL commands: --- BEGIN SQL TEST STATEMENTS -- USE test; # # Create a table with a unique key in addition to a primary key # DROP TABLE IF EXISTS table_with_key; CREATE TABLE table_with_key ( id int(10) unsigned NOT NULL auto_increment, uniq_id int(10) unsigned default NULL, PRIMARY KEY (id), UNIQUE KEY idx1 (uniq_id) ) TYPE=MyISAM; # # Create a table with only a primary key # DROP TABLE IF EXISTS table_without_key; CREATE TABLE table_without_key ( id int(10) unsigned NOT NULL auto_increment, uniq_id int(10) unsigned default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; # # Insert test data into table with unique key # INSERT INTO table_with_key VALUES (1,NULL); INSERT INTO table_with_key VALUES (2,NULL); INSERT INTO table_with_key VALUES (3,1); INSERT INTO table_with_key VALUES (4,2); INSERT INTO table_with_key VALUES (5,NULL); INSERT INTO table_with_key VALUES (6,NULL); INSERT INTO table_with_key VALUES (7,3); INSERT INTO table_with_key VALUES (8,4); INSERT INTO table_with_key VALUES (9,NULL); INSERT INTO table_with_key VALUES (10,NULL); # # Insert identical data into table without unique key # INSERT INTO table_without_key VALUES (1,NULL); INSERT INTO table_without_key VALUES (2,NULL); INSERT INTO table_without_key VALUES (3,1); INSERT INTO table_without_key VALUES (4,2); INSERT INTO table_without_key VALUES (5,NULL); INSERT INTO table_without_key VALUES (6,NULL); INSERT INTO table_without_key VALUES (7,3); INSERT INTO table_without_key VALUES (8,4); INSERT INTO table_without_key VALUES (9,NULL); INSERT INTO table_without_key VALUES (10,NULL); # # Delete all records from each table where the uniq_id field is null # DELETE FROM table_with_keyWHERE uniq_id IS NULL; DELETE FROM table_without_key WHERE uniq_id IS NULL; # # Select what is left -- notice the difference # SELECT * FROM table_with_keyORDER BY uniq_id, id; SELECT * FROM table_without_key ORDER BY uniq_id, id; --- END SQL TEST STATEMENTS The output for the last four statements looks like the following: --- BEGIN SQL TEST OUTPUT -- mysql DELETE FROM table_with_keyWHERE uniq_id IS NULL; Query OK, 1 row affected (0.00 sec) mysql DELETE FROM table_without_key WHERE uniq_id IS NULL; Query OK, 6 rows affected (0.00 sec) mysql SELECT * FROM table_with_keyORDER BY uniq_id, id; ++-+ | id | uniq_id | ++-+ | 2 |NULL | | 5 |NULL | | 6 |NULL | | 9 |NULL | | 10 |NULL | | 3 | 1 | | 4 | 2 | | 7 | 3 | | 8 | 4 | ++-+ 9 rows in set (0.00 sec) mysql SELECT * FROM table_without_key ORDER BY uniq_id, id; ++-+ | id | uniq_id | ++-+ | 3 | 1 | | 4 | 2 | | 7 | 3 | | 8 | 4 | ++-+ 4 rows in set (0.00 sec) --- END SQL TEST OUTPUT Fix: No idea. Submitter-Id: submitter ID Originator:Matt Loschert Organization: ServInt Internet Services Matt Loschert | email: [EMAIL PROTECTED]| Software Engineer | web: http://www.servint.net/ | ServInt Internet Services | phone: (703) 847-1381 | MySQL support: none Synopsis: Cannot DELETE all records with NULL entries in UNIQUE KEY fields Severity: serious Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.36 (Source distribution) Environment: System: FreeBSD delft.servint.com 4.3-RC FreeBSD 4.3-RC #0: Thu Mar 29 11:50:53 EST 2001 [EMAIL PROTECTED]:/disk2/cvsup/branches/releng_4/obj/disk2/cvsup/branches/releng_4/src/sys/QUICKIE i386 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1176254 Mar 29 12:07 /usr/lib/libc.a lrwxr-xr-x 1 root wheel 9 Mar 29 12:07 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 566004 Mar 29 12:07 /usr/lib/libc.so.4 Configure command: ./configure --with-low-memory --prefix=/usr/local/mysql-23.36 Perl: This is perl, version 5.005_03 built for i386-freebsd - 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]
Re: MySQL Server
Check with your hosting company. My guess is that they handle the initial MySQL setup for you. Very few companies will allow you to install the software on their servers. -- Rodney Anoop k gupta wrote: Hi everybody, I am new to MySQL. I have Linux server through my hosting company. I want to install MySQL on server. I need your help in this regard how I can install the same on my remote server? Thanks in advannce. Anoop _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.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: Transactions in MySql
Look at the following pages in the manual: http://www.mysql.com/doc/M/i/Missing_Transactions.html http://www.mysql.com/doc/T/a/Table_types.html -- Rodney Gerald Clark wrote: Marco Baldacchini wrote: MySql support transactions? The OLE-DB provider support transactions? Call the method Begintrans on a connection object (ADO) return an error!!! And you read the manual, right? Transaction support depends on the version of MySQL you are running, and the table type created. Read the manual, then ask questions. - 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: Security
I haven't read Mysql's authorization mechanism from Paul's book, but from the Oreilly book and it was pretty comprehensive and intuitive. I suggest you borrow that book from your local library or buy it. To try to write here about how it works would be a waste of time for both of us. It is rather long and I'm not exactly proud of my explanatory abilities. It is a pretty elaborate and interesting mechanism though. Before you pull the trigger, I also suggest you remember to always do a 'mysqladmin reload' after every change you make to the mysql database, because otherwise you won't be able to see the changes you make. This has caused me lots of pain in the beginning. regards, thalis On Mon, 9 Apr 2001, Ashley M. Kirchner wrote: Okay, I'm about to rip my hair out trying to figure this out, and I thought before I start looking for a gun, maybe I should ask.. I need someone to explain the 'mysql' database to me. I've tried reading about it, tried different settings, but I'm lost. So far I've just been adding users and db's to the 'db' and 'user' tables, but something tells me that's not all there is to it. What are the other tables for? And how's about adding a user that can only access (and change) their DB (assigned by me), and/or adding a (different) user that can create their own DB(s), yet not muck with anything else on the entire (mysql) system (and screw up other users). I'm willing to entertain even more literature if that's easiest to point me to, but like I said, I've gone through the online docs, I've checked other resources online, and I'm still lost. AMK4 -- W | | I haven't lost my mind; it's backed up on tape somewhere. | ~ Ashley M. Kirchner mailto:[EMAIL PROTECTED] . 303.442.6410 x130 SysAdmin / Websmith . 800.441.3873 x130 Photo Craft Laboratories, Inc. .eFax 248.671.0909 http://www.pcraft.com . 3550 Arapahoe Ave #6 .. . . . . Boulder, CO 80303, USA - 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: Security
Ashley, Are you using the GRANT statement? That is the easiest way to get it right. Read up on the GRANT SQL statement. Look at the examples... Using regular inserts into the mysql database, can cause improper input into the tables, which can (from personal experience) cause mysqld to not run. It goes through a sanity check on start up, relating to security, and will not start, until the mysql database is replaced with a clean secure one. If you think you are pulling your hair out now, wait til this event occurs. Read up on GRANT, and stop using INSERT. Once you understand GRANT, you will see that it is much easier to add privileges all the way down to the column level. On 4/9/01 9:38 AM, "Ashley M. Kirchner" [EMAIL PROTECTED] wrote: Okay, I'm about to rip my hair out trying to figure this out, and I thought before I start looking for a gun, maybe I should ask.. I need someone to explain the 'mysql' database to me. I've tried reading about it, tried different settings, but I'm lost. So far I've just been adding users and db's to the 'db' and 'user' tables, but something tells me that's not all there is to it. What are the other tables for? And how's about adding a user that can only access (and change) their DB (assigned by me), and/or adding a (different) user that can create their own DB(s), yet not muck with anything else on the entire (mysql) system (and screw up other users). I'm willing to entertain even more literature if that's easiest to point me to, but like I said, I've gone through the online docs, I've checked other resources online, and I'm still lost. AMK4 -- W | | I haven't lost my mind; it's backed up on tape somewhere. | ~ Ashley M. Kirchner mailto:[EMAIL PROTECTED] . 303.442.6410 x130 SysAdmin / Websmith . 800.441.3873 x130 Photo Craft Laboratories, Inc. .eFax 248.671.0909 http://www.pcraft.com . 3550 Arapahoe Ave #6 .. . . . . Boulder, CO 80303, USA - 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: Security
"Thalis A. Kalfigopoulos" wrote: I haven't read Mysql's authorization mechanism from Paul's book, but from the Oreilly book and it was pretty comprehensive and intuitive. I suggest you borrow that book from your local library or buy it. Ya, it's already on its way...(the book that is). Before you pull the trigger, I also suggest you remember to always do a 'mysqladmin reload' after every change you make to the mysql database, because otherwise you won't be able to see the changes you make. This has caused me lots of pain in the beginning. Reloading (or flushing privileges) isn't the problem (well, it was when I first started a while back), that I've learned. It's just how to set users up properly, etc., etc. AMK4 -- W | | I haven't lost my mind; it's backed up on tape somewhere. | ~ Ashley M. Kirchner mailto:[EMAIL PROTECTED] . 303.442.6410 x130 SysAdmin / Websmith . 800.441.3873 x130 Photo Craft Laboratories, Inc. .eFax 248.671.0909 http://www.pcraft.com . 3550 Arapahoe Ave #6 .. . . . . Boulder, CO 80303, USA - 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
Setting up FULLTEXT table
I posted a couple problems regarding the use of the FULLTEXT indexing and a search query problem, but never got any responses. So maybe some one may shed some lite on setting up a table with the FULLTEXT index. I've read thru the MySQL docs on this and it's not real clear. When setting up a table, when an utilizing a FULLTEXT index. When creating the table, can it only have to columns or can the table have more then two columns: CREATE TABLE search ( id int(8), title varchar(200), keywords TEXT, category char(2) FULLTEXT (title,keywords) ) Is this correct or can you only have two columns when using the FULLTEXT Indexing?? Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-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: BUG: Cannot DELETE all records with NULL entries in UNIQUE KEYfields
On 9 Apr 2001 [EMAIL PROTECTED] wrote: Description: Attempting to delete all records in a table containing NULL values in a UNIQUE KEY field does not work as expected. Only a single record is deleted, presumably because the server thinks that the table will only have one record with a NULL value in it (as it is in a UNIQUE field). How-To-Repeat: Run the following SQL commands: --- BEGIN SQL TEST STATEMENTS -- USE test; # # Create a table with a unique key in addition to a primary key # DROP TABLE IF EXISTS table_with_key; CREATE TABLE table_with_key ( id int(10) unsigned NOT NULL auto_increment, uniq_id int(10) unsigned default NULL, PRIMARY KEY (id), UNIQUE KEY idx1 (uniq_id) ) TYPE=MyISAM; # # Create a table with only a primary key # DROP TABLE IF EXISTS table_without_key; CREATE TABLE table_without_key ( id int(10) unsigned NOT NULL auto_increment, uniq_id int(10) unsigned default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; # # Insert test data into table with unique key # INSERT INTO table_with_key VALUES (1,NULL); INSERT INTO table_with_key VALUES (2,NULL); INSERT INTO table_with_key VALUES (3,1); INSERT INTO table_with_key VALUES (4,2); INSERT INTO table_with_key VALUES (5,NULL); INSERT INTO table_with_key VALUES (6,NULL); INSERT INTO table_with_key VALUES (7,3); INSERT INTO table_with_key VALUES (8,4); INSERT INTO table_with_key VALUES (9,NULL); INSERT INTO table_with_key VALUES (10,NULL); # # Insert identical data into table without unique key # INSERT INTO table_without_key VALUES (1,NULL); INSERT INTO table_without_key VALUES (2,NULL); INSERT INTO table_without_key VALUES (3,1); INSERT INTO table_without_key VALUES (4,2); INSERT INTO table_without_key VALUES (5,NULL); INSERT INTO table_without_key VALUES (6,NULL); INSERT INTO table_without_key VALUES (7,3); INSERT INTO table_without_key VALUES (8,4); INSERT INTO table_without_key VALUES (9,NULL); INSERT INTO table_without_key VALUES (10,NULL); # # Delete all records from each table where the uniq_id field is null # DELETE FROM table_with_keyWHERE uniq_id IS NULL; DELETE FROM table_without_key WHERE uniq_id IS NULL; # # Select what is left -- notice the difference # SELECT * FROM table_with_keyORDER BY uniq_id, id; SELECT * FROM table_without_key ORDER BY uniq_id, id; --- END SQL TEST STATEMENTS The output for the last four statements looks like the following: --- BEGIN SQL TEST OUTPUT -- mysql DELETE FROM table_with_keyWHERE uniq_id IS NULL; Query OK, 1 row affected (0.00 sec) mysql DELETE FROM table_without_key WHERE uniq_id IS NULL; Query OK, 6 rows affected (0.00 sec) mysql SELECT * FROM table_with_keyORDER BY uniq_id, id; ++-+ | id | uniq_id | ++-+ | 2 |NULL | | 5 |NULL | | 6 |NULL | | 9 |NULL | | 10 |NULL | | 3 | 1 | | 4 | 2 | | 7 | 3 | | 8 | 4 | ++-+ 9 rows in set (0.00 sec) mysql SELECT * FROM table_without_key ORDER BY uniq_id, id; ++-+ | id | uniq_id | ++-+ | 3 | 1 | | 4 | 2 | | 7 | 3 | | 8 | 4 | ++-+ 4 rows in set (0.00 sec) --- END SQL TEST OUTPUT This is perfectly normal from Mysql's part. What you call a uniq_id in the table where you don't declare it as a unique key is merely another int field and a table scan will be performed to actually find ALL the occurences of the value you are deleting. On the other hand in the case where you actually declare the uniq_id to be unique by building a UNIQUE index on it, Mysql will of course use the asserted uniqueness and stop processing as soon as the first occurence of the value you want to delete is found. I.e. it assumes that as a unique field there will not be another occurence of this value. Of course on the other hand it allows you to insert multiple cases of NULL even though it is a unique field, because NULL is just SO DAMN NULL that it is NOT EVEN EQUAL TO ITSELF :-) So when you have a NULL in a unique field and add another NULL Mysql will not complain about it cause Null!=Null whereas it would complain if you had inserted a '1' and tried to insert another '1'. Clear as mud? regards, thalis - 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
how to connect MySql with Java?
I'd like to use MySql with Java (under Linux) bu I can't be able to do that: how can I do? Thank you in advance, Mario. - 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: Security
There's some good documentation (a lot of it in the form of 'warnings') on security aspects of the "mysql" database. http://mysql.com/documentation/mysql/bychapter/manual_Privilege_system.html#Privilege_system But, here's some quick notes: Anyone who has 'modify' permissions to the "mysql" database can modify ANYTHING in it (and grant the same ability to anyone else). I use different usernames for different databases (excluding the "mysql" one) to ensure that each user only has access to the database the username appears for (in the "db" table). User "yubbyuser" has an entry in "db" only for "yubbydb" database. User "dubbyuser" has an entry in "db" only for "dubbydb" database. If you want to do the same for the "mysql" database, you might have to have multiple "instances" of MySQL running. With each 'instance' controlling a different 'user' (or project) database, allowing you to enable the user in each 'instance' to have access to the "mysql" database, which keeps them out of the other 'instances' (and the other "mysql" databases). Make sure that the passwords for "root" and other users are different in each 'instance'... I haven't made use of the "host" or "columns_priv" tables yet, but am using "tables_priv" to give additional "create" and "drop" access to 'temporary' tables to the 'web user' (which, if they didn't have it, can't create temporary tables) only for those files (and not the ability to 'drop' every table in the database). Good Luck... "Ashley M. Kirchner" wrote: Okay, I'm about to rip my hair out trying to figure this out, and I thought before I start looking for a gun, maybe I should ask.. I need someone to explain the 'mysql' database to me. I've tried reading about it, tried different settings, but I'm lost. So far I've just been adding users and db's to the 'db' and 'user' tables, but something tells me that's not all there is to it. What are the other tables for? And how's about adding a user that can only access (and change) their DB (assigned by me), and/or adding a (different) user that can create their own DB(s), yet not muck with anything else on the entire (mysql) system (and screw up other users). I'm willing to entertain even more literature if that's easiest to point me to, but like I said, I've gone through the online docs, I've checked other resources online, and I'm still lost. AMK4
a sort of little bug?
Hi, I work on the big web site of the gouvernative statistical agency of Italy (www.istat.it). Recently, I have built a db to collect data from the web (it's like a census simulation...) with mySQL. Making my querys,I had a little difficult, not so big for me, but that can interest you. On a developpement machine (winNT, apache, mysql 3.23.33) I wrote this query: "SELECT (fra_g+fra_p+sor_g+sor_p), count(*) FROM alunniE GROUP BY (fra_g+fra_p+sor_g+sor_p)", where fra_g, fra_p, sor_p, sor_g are, obviously, columns. That works right. When I tried to run the same query on the site machine (Unix Aix, apache, mysql 3.22.32, see http://www.istat.it:8080/index.php) i discovered that the use of the formula in the GROUP BY clause cannot work (any formula). The situation on the unix machine seems to be in contrast with the manual: http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SELECT where it talks about the possibility to write a formula. Did you know it? Greetings Sergio Vaccaro -- Genial Brain Machine Via A. Camerini 50 00139 - Roma tel +39 6 87148219 +39 347 5056045 fax +39 6 87148219 (on demand) mail [EMAIL PROTECTED] icq genial 42632197
Re: BUG: Cannot DELETE all records with NULL entries in UNIQUE KEYfields
On Mon, 9 Apr 2001, Thalis A. Kalfigopoulos wrote: This is perfectly normal from Mysql's part. What you call a uniq_id in the table where you don't declare it as a unique key is merely another int field and a table scan will be performed to actually find ALL the occurences of the value you are deleting. On the other hand in the case where you actually declare the uniq_id to be unique by building a UNIQUE index on it, Mysql will of course use the asserted uniqueness and stop processing as soon as the first occurence of the value you want to delete is found. I.e. it assumes that as a unique field there will not be another occurence of this value. Of course on the other hand it allows you to insert multiple cases of NULL even though it is a unique field, because NULL is just SO DAMN NULL that it is NOT EVEN EQUAL TO ITSELF :-) So when you have a NULL in a unique field and add another NULL Mysql will not complain about it cause Null!=Null whereas it would complain if you had inserted a '1' and tried to insert another '1'. Clear as mud? regards, thalis Okay..? Your explanation makes sense, but it seems a bit counter-intuitive. In my mind, if you insert identical values (no matter what they are) into a field that is declared to be a unique key, the database should complain like crazy, if not completely disallow the action. In any case, thanks for the explanation. - Matt -- Matt Loschert | email: [EMAIL PROTECTED]| Software Engineer | web: http://www.servint.net/ | ServInt Internet Services | phone: (703) 847-1381 | - 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: Cannot DELETE all records with NULL entries in UNIQUE KEY fields
[EMAIL PROTECTED] writes: Description: Attempting to delete all records in a table containing NULL values in a UNIQUE KEY field does not work as expected. Only a single record is deleted, presumably because the server thinks that the table will only have one record with a NULL value in it (as it is in a UNIQUE field). How-To-Repeat: Run the following SQL commands: --- BEGIN SQL TEST STATEMENTS -- USE test; # # Create a table with a unique key in addition to a primary key # DROP TABLE IF EXISTS table_with_key; CREATE TABLE table_with_key ( id int(10) unsigned NOT NULL auto_increment, uniq_id int(10) unsigned default NULL, PRIMARY KEY (id), UNIQUE KEY idx1 (uniq_id) ) TYPE=MyISAM; # # Create a table with only a primary key # DROP TABLE IF EXISTS table_without_key; CREATE TABLE table_without_key ( id int(10) unsigned NOT NULL auto_increment, uniq_id int(10) unsigned default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; # # Insert test data into table with unique key # INSERT INTO table_with_key VALUES (1,NULL); INSERT INTO table_with_key VALUES (2,NULL); INSERT INTO table_with_key VALUES (3,1); INSERT INTO table_with_key VALUES (4,2); INSERT INTO table_with_key VALUES (5,NULL); INSERT INTO table_with_key VALUES (6,NULL); INSERT INTO table_with_key VALUES (7,3); INSERT INTO table_with_key VALUES (8,4); INSERT INTO table_with_key VALUES (9,NULL); INSERT INTO table_with_key VALUES (10,NULL); # # Insert identical data into table without unique key # INSERT INTO table_without_key VALUES (1,NULL); INSERT INTO table_without_key VALUES (2,NULL); INSERT INTO table_without_key VALUES (3,1); INSERT INTO table_without_key VALUES (4,2); INSERT INTO table_without_key VALUES (5,NULL); INSERT INTO table_without_key VALUES (6,NULL); INSERT INTO table_without_key VALUES (7,3); INSERT INTO table_without_key VALUES (8,4); INSERT INTO table_without_key VALUES (9,NULL); INSERT INTO table_without_key VALUES (10,NULL); # # Delete all records from each table where the uniq_id field is null # DELETE FROM table_with_keyWHERE uniq_id IS NULL; DELETE FROM table_without_key WHERE uniq_id IS NULL; # # Select what is left -- notice the difference # SELECT * FROM table_with_keyORDER BY uniq_id, id; SELECT * FROM table_without_key ORDER BY uniq_id, id; --- END SQL TEST STATEMENTS The output for the last four statements looks like the following: --- BEGIN SQL TEST OUTPUT -- mysql DELETE FROM table_with_keyWHERE uniq_id IS NULL; Query OK, 1 row affected (0.00 sec) mysql DELETE FROM table_without_key WHERE uniq_id IS NULL; Query OK, 6 rows affected (0.00 sec) mysql SELECT * FROM table_with_keyORDER BY uniq_id, id; ++-+ | id | uniq_id | ++-+ | 2 |NULL | | 5 |NULL | | 6 |NULL | | 9 |NULL | | 10 |NULL | | 3 | 1 | | 4 | 2 | | 7 | 3 | | 8 | 4 | ++-+ 9 rows in set (0.00 sec) mysql SELECT * FROM table_without_key ORDER BY uniq_id, id; ++-+ | id | uniq_id | ++-+ | 3 | 1 | | 4 | 2 | | 7 | 3 | | 8 | 4 | ++-+ 4 rows in set (0.00 sec) --- END SQL TEST OUTPUT Fix: No idea. Submitter-Id: submitter ID Originator: Matt Loschert Organization: ServInt Internet Services Matt Loschert | email: [EMAIL PROTECTED]| Software Engineer | web: http://www.servint.net/ | ServInt Internet Services | phone: (703) 847-1381 | MySQL support: none Synopsis: Cannot DELETE all records with NULL entries in UNIQUE KEY fields Severity: serious Priority: high Category: mysql Class: sw-bug Release:mysql-3.23.36 (Source distribution) Environment: System: FreeBSD delft.servint.com 4.3-RC FreeBSD 4.3-RC #0: Thu Mar 29 11:50:53 EST 2001 [EMAIL PROTECTED]:/disk2/cvsup/branches/releng_4/obj/disk2/cvsup/branches/releng_4/src/sys/QUICKIE i386 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1176254 Mar 29 12:07 /usr/lib/libc.a lrwxr-xr-x 1 root wheel 9 Mar 29 12:07 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 566004 Mar 29 12:07 /usr/lib/libc.so.4 Configure command: ./configure --with-low-memory --prefix=/usr/local/mysql-23.36 Perl: This is perl, version 5.005_03 built
Having a big problem in libmysqlclient.a with apache and php
Hi, I goot this error when I type "make" apache after installating (mysql-3.23.36-pc-linux-gnu-i686.tar.gz) configurating it with php 4.0.4pr1 on RedHat 7.0, the problme as seen bellow seems to be related to libmysqlclient.a(my_compress.o) but I don't know what to do. I'm following exactly the installation procedure described at http://www.e-gineer.com/instructions/install-php4x-for-apache1xx-on-linux.phtml apache "make" abort with these errors: usr/local/mysql/lib/libmysqlclient.a(my_compress.o): In function `my_uncompress': my_compress.o(.text+0x9a): undefined reference to `uncompress' /usr/local/mysql/lib/libmysqlclient.a(my_compress.o): In function `my_compress_alloc': my_compress.o(.text+0x12a): undefined reference to `compress' collect2: ld returned 1 exit status make[2]: *** [target_static] Erreur 1 make[2]: Quitte le rpertoire `/usr/local/etc/apache_1.3.14/src' make[1]: *** [build-std] Erreur 2 make[1]: Quitte le rpertoire `/usr/local/etc/apache_1.3.14' make: *** [build] Erreur 2 Can anyone helps. Thanks - 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: load aca from master
database,sql,query load table from master does not work for me. I get the error message ERROR 1189: Net error reading from master what can cause this? both the master and the slave are version 3.23.33-log -- [EMAIL PROTECTED] (Jim Ziegler) - 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
looking experience MySQL DBA
We're looking for a DBA (MySQL). We've been without a DBA to date and have gotten to the point where we need one. Please respond to [EMAIL PROTECTED] for more details. Thanks. EQ-
messed up app files
I have a db I made with mysql/php/apache. I was copying my script files to a floppy disc. I figured I'd also back up the data itself so I wouldn't have to re-enter it all. I went into C:\mysql\data\testTrack and, being an inquisitive fellow, I decided to have a look in the 3 files there - an FRM file, an ISD file, and an ISM file. I opened them with notepad. Now my scripts will not execute. The ISD file says that it was modified today. All 3 icons have changed to the notepad icon, although this is not necessarily the most unbearable part of the whole thing. Are they lost forever? Can they be made to work again? Please help.
SOLVED: Re: load aca from master
On Mon, Apr 09, 2001 at 02:01:55PM -0400, Jim Ziegler wrote: database,sql,query load table from master does not work for me. I get the error message ERROR 1189: Net error reading from master what can cause this? both the master and the slave are version 3.23.33-log apparantly, the load table from master command does not work with isam tables. I converted the tables to myisam and now it works. -- [EMAIL PROTECTED] (Jim Ziegler) - 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: Security
"Ashley M. Kirchner" wrote: Okay, I'm about to rip my hair out trying to figure this out, and I thought before I start looking for a gun, maybe I should ask.. I need someone to explain the 'mysql' database to me. I've tried reading about it, tried different settings, but I'm lost. So far I've just been adding users and db's to the 'db' and 'user' tables, but something tells me that's not all there is to it. What are the other tables for? And how's about adding a user that can only access (and change) their DB (assigned by me), and/or adding a (different) user that can create their own DB(s), yet not muck with anything else on the entire (mysql) system (and screw up other users). I'm willing to entertain even more literature if that's easiest to point me to, but like I said, I've gone through the online docs, I've checked other resources online, and I'm still lost. AMK4 Ashley: mysqladmin create database phil; INSERT INTO user (Host, User, Password, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv) VALUES ('localhost', 'phil', PASSWORD('password'), 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n') INSERT INTO db (Host, Db, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Grant_priv, References_priv, Index_priv, Alter_priv) VALUES ('localhost', 'phil', 'phil', 'y', 'y', 'y', 'y', 'y', 'y', 'n', 'y', 'y', 'y') mysqladmin reload. Of course you can use the grant command, too, but, this works better for me. Note that the db privs doesn't not give this user (Phil) grant privs. Regards, Van -- = Linux rocks!!! http://www.dedserius.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: BUG: Cannot DELETE all records with NULL entries in UNIQUE KEYfields
On Mon, 9 Apr 2001, Matt Loschert wrote: Sorry for jumping in ... another NULL Mysql will not complain about it cause Null!=Null whereas it would complain if you had inserted a '1' and tried to insert another '1'. Clear as mud? Your explanation makes sense, but it seems a bit counter-intuitive. In my mind, if you insert identical values (no matter what they are) into a field that is declared to be a unique key, the database should complain Not really. From a programmers point of view: define NULL NULL if(undefined NULL) # never can be TRUE because it's defined or in other words: if something is nothing nothing can't be nothing because nothing is 'something' ;-) Think about it, it's some kind of philosophy :-) Andreas Karl Wittwer Phone: +49-7052-92206 FAX: +49-7052-92208 Mobil: +49-172-542 541 4 - 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
Moving Data
We will be moving our MySql databases from a Winnt server to a linux server. Can I just copy the data files from one machine to the other? If not then how should I do it? Mat Murdock Your mouse has moved. Windows must be restarted for the change to take effect. Reboot now? [ OK ]
mysql uses 99% cpu under freebsd 4.3
Description: mysql uses 99% cpu and becomes extremely unresponsive under high load How-To-Repeat: send about 300 simultaneous visitors to www.chicagobusiness.com and tell them to click around. Fix: restart mysql. this usally helps, at least for a few minutes. sometimes it climbs back to 99% though. Submitter-Id: submitter ID Originator:Jon Nathan Organization: Chaffee Interactive MySQL support: extended email support Synopsis: mysql uses 99% cpu and becomes unresponsive Severity: serious Priority: high Category: mysql Class: support Release: mysql-3.23.36 (Source distribution) from freebsd ports Environment: System: FreeBSD d1.crain.com 4.3-RC FreeBSD 4.3-RC #1: Tue Apr 3 16:17:52 GMT 2001 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/CHAFFEE i386 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.2 19991024 (release) Compilation info: CC='cc' CFLAGS='-O2 -pipe -mpentiumpro ' CXX='c++' CXXFLAGS='-O2 -pipe -mpentiumpro -felide-constructors -fno-rtti -fno-exceptions' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1170734 Apr 3 12:24 /usr/lib/libc.a lrwxr-xr-x 1 root wheel 9 Apr 3 12:24 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 559764 Apr 3 12:24 /usr/lib/libc.so.4 Configure command: ./configure --localstatedir=/data/db --without-perl --without-debug --without-readline --without-bench --with-mit-threads=no --with-libwrap --with-low-memory --enable-assembler --with-berkeley-db --with-charset=latin1 --prefix=/usr/local i386--freebsd4.3 Perl: This is perl, version 5.005_03 built for i386-freebsd - 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
recommended install
is it recommended to install mysql by rpm or tar? dave - 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: Moving Data
It depends on what version of MySQL you are running. MyISAM tables will move across platforms fine, but ISAM tables will not. You could always choose the failsafe and use mysqldump to dump the contents of your database into a file, and then use that to reload the contents on the new machine. John Barton Unix Systems Administrator Primary Networks, Inc. [EMAIL PROTECTED] On Mon, 9 Apr 2001, Mat Murdock wrote: We will be moving our MySql databases from a Winnt server to a linux server. Can I just copy the data files from one machine to the other? If not then how should I do it? Mat Murdock Your mouse has moved. Windows must be restarted for the change to take effect. Reboot now? [ OK ] - 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: Cannot DELETE all records with NULL entries in UNIQUE KEY fields
Hello. On Mon, Apr 09, 2001 at 01:05:01PM -0400, [EMAIL PROTECTED] wrote: On 9 Apr 2001 [EMAIL PROTECTED] wrote: Description: Attempting to delete all records in a table containing NULL values in a UNIQUE KEY field does not work as expected. Only a single record is deleted, presumably because the server thinks that the table will only have one record with a NULL value in it (as it is in a UNIQUE field). Sounds like an optimization too much. ;-) How-To-Repeat: [...] This is perfectly normal from Mysql's part. What you call a uniq_id in the table where you don't declare it as a unique key is merely another int field and a table scan will be performed to actually find ALL the occurences of the value you are deleting. On the other hand in the case where you actually declare the uniq_id to be unique by building a UNIQUE index on it, Mysql will of course use the asserted uniqueness and stop processing as soon as the first occurence of the value you want to delete is found. I.e. it assumes that as a unique field there will not be another occurence of this value. Of course on the other hand it allows you to insert multiple cases of NULL even though it is a unique field, because NULL is just SO DAMN NULL that it is NOT EVEN EQUAL TO ITSELF :-) You explanation what happens inside is correct, but it is a misbehaviour. He is not using "col = NULL" but "col IS NULL" and the latter one is defined to match all NULL values. So I think MySQL optimizes to much (stopping after the first found value when using indexes). You see that it is bogus also from the fact that the result is different when used with resp. without indexes, which may never happen (as indexes have to behave transparently regarding the result set in SQL). So when you have a NULL in a unique field and add another NULL Mysql will not complain about it cause Null!=Null whereas it would complain if you had inserted a '1' and tried to insert another '1'. Clear as mud? ;-) Bye, Benjamin. - 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 uses 99% cpu under freebsd 4.3
On Mon, 9 Apr 2001 [EMAIL PROTECTED] wrote: I have the same problem under FreeBSD-4.2 STABLE sometimes it work fin 1week, but sometimes 1 day. Description: mysql uses 99% cpu and becomes extremely unresponsive under high load How-To-Repeat: send about 300 simultaneous visitors to www.chicagobusiness.com and tell them to click around. Fix: restart mysql. this usally helps, at least for a few minutes. sometimes it climbs back to 99% though. Submitter-Id:submitter ID Originator: Jon Nathan Organization: Chaffee Interactive MySQL support: extended email support Synopsis:mysql uses 99% cpu and becomes unresponsive Severity:serious Priority:high Category:mysql Class: support Release: mysql-3.23.36 (Source distribution) from freebsd ports Environment: System: FreeBSD d1.crain.com 4.3-RC FreeBSD 4.3-RC #1: Tue Apr 3 16:17:52 GMT 2001 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/CHAFFEE i386 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.2 19991024 (release) Compilation info: CC='cc' CFLAGS='-O2 -pipe -mpentiumpro ' CXX='c++' CXXFLAGS='-O2 -pipe -mpentiumpro -felide-constructors -fno-rtti -fno-exceptions' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1170734 Apr 3 12:24 /usr/lib/libc.a lrwxr-xr-x 1 root wheel 9 Apr 3 12:24 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 559764 Apr 3 12:24 /usr/lib/libc.so.4 Configure command: ./configure --localstatedir=/data/db --without-perl --without-debug --without-readline --without-bench --with-mit-threads=no --with-libwrap --with-low-memory --enable-assembler --with-berkeley-db --with-charset=latin1 --prefix=/usr/local i386--freebsd4.3 Perl: This is perl, version 5.005_03 built for i386-freebsd - 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 ___ Andrey Kotrekhov [EMAIL PROTECTED] - 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
How update 1 of two identical rows.
DateDB_amount CR_amount 2001-04-09 NULL300.00 2001-04-09 NULL750.00 2001-04-09 NULL300.00 Anyone know how can I do a query that will update the third record without updating the first? - 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 uses 99% cpu under freebsd 4.3
Have you tried this under a 'stable' version of freebsd? In FreeBSD 4.2 beta, mysql would crash with user locks. Not mysql's fault. now, I understand RC's are generally stable; but I would still make sure that this bug doesn't show up in a stable os. regards, -- Andrew - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 09, 2001 3:34 PM Subject: mysql uses 99% cpu under freebsd 4.3 Description: mysql uses 99% cpu and becomes extremely unresponsive under high load How-To-Repeat: send about 300 simultaneous visitors to www.chicagobusiness.com and tell them to click around. Fix: restart mysql. this usally helps, at least for a few minutes. sometimes it climbs back to 99% though. Submitter-Id: submitter ID Originator: Jon Nathan Organization: Chaffee Interactive MySQL support: extended email support Synopsis: mysql uses 99% cpu and becomes unresponsive Severity: serious Priority: high Category: mysql Class: support Release: mysql-3.23.36 (Source distribution) from freebsd ports Environment: System: FreeBSD d1.crain.com 4.3-RC FreeBSD 4.3-RC #1: Tue Apr 3 16:17:52 GMT 2001 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/CHAFFEE i386 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.2 19991024 (release) Compilation info: CC='cc' CFLAGS='-O2 -pipe -mpentiumpro ' CXX='c++' CXXFLAGS='-O2 -pipe -mpentiumpro -felide-constructors -fno-rtti -fno-except ions' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1170734 Apr 3 12:24 /usr/lib/libc.a lrwxr-xr-x 1 root wheel 9 Apr 3 12:24 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 559764 Apr 3 12:24 /usr/lib/libc.so.4 Configure command: ./configure --localstatedir=/data/db --without-perl --without-debug --witho ut-readline --without-bench --with-mit-threads=no --with-libwrap --with-low- memory --enable-assembler --with-berkeley-db --with-charset=latin1 --prefix= /usr/local i386--freebsd4.3 Perl: This is perl, version 5.005_03 built for i386-freebsd - 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: messed up app files
ISM file. I opened them with notepad. Now my scripts will not execute. The ISD file says that it was modified today. All 3 icons have changed to the notepad icon, although this is not necessarily the most unbearable part of the whole thing. Are they lost forever? Can they be made to work again? Please help. Aaah, yes.. Windooz.. Go to explorer and find the screen where you can associate files with apps. Somewhere next to edit.. then you can remove the association for these files.. I don't think this has damaged your tables.. as long as you didn't write back.. Otherwise you might want to try if you can repair them.. I'm not sure if M$ will put the last opened date or last edited date on the file.. But, since you did make a backup every day it's not that much of a problem.. is it.. Bye, B. To satisfy the new spam filter: You may query our database and buy products.. like books on sql. Not that we sell any.. but is does satisfy the filter :-) - 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: Security
On 4/9/01 10:12 AM, "Burke Patrick" [EMAIL PROTECTED] wrote: Hi Lindsay, maybe you can help me? I am trying to give a user SELECT access to just one table in my database. If I don't give him SELECT privileges in the mysql.user table or mysql.db table, he cannot even login to the database. - Well he can when I do a GRANT USAGE statement. If I give him SELECT privileges in the user table or the db table, he can SELECT from all tables in my database. How can I get around this? regards Patrick Okay, to grant select on one table in one database, use the following GRANT select ON database.table TO 'username@host' IDENTIFIED BY 'password' So, if you only want to grant select access to user joeblow on the clothing table in a merchandise database, and you want that user to be able to log in from ANY computer in the world, then you have: GRANT select ON merchandise.clothing to 'joeblow@%' IDENTIFIED BY 'password' The database.table section uses * as the wildcard, So to grant select on all tables in one database, you would use: GRANT select ON merchandise.* to... To grant select on ALL databases use: Grant select on *.* to... The user@host section uses % as a wildcard. So to grant a specific user, connecting from any machine in a certain domain: user@%.domain.com Or, anyone on a .net domain: user@%.net Or anyone on the private subnet 192.168.10: [EMAIL PROTECTED]% Or any user at any domain %@% Then of course, you can expand the GRANt statement to include column level privs. From the online manual: http://www.mysql.com/doc/G/R/GRANT.html GRANT priv_type [(column_list)] [, priv_type [(column_list)] ...] ON {tbl_name | * | *.* | db_name.*} TO user_name [IDENTIFIED BY 'password'] [, user_name [IDENTIFIED BY 'password'] ...] [WITH GRANT OPTION] The problem with using inserts and updates on the mysql databse, is you might put something in the wrong place,and open your security up and not even realize it. For restrictive access, use grant, because you will get it right quicker. To allow only table level access, then ALL privs in the user table should be 'N' You really have to read up and understand how mysql 'falls' through the security tables. By setting something to Y in the user table, that means that that user has global right to do that priv on all databases and tables. MySQL stops right there and says, okay, you are allowed. If it sees an 'N', then it checks other tables. Read the security chapter in the books multiple times. Over and over, and it will start to sink in. - 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: How update 1 of two identical rows.
delete from db where date="2001-04-09" and CR_amount=300.00 insert into from db (date, DB_amount, CR_amount) values ("2001-04-09", NULL, 300.00); insert into from db (date, DB_amount, CR_amount) values ("2001-04-09", NULL, 350.00); would change the 3rd to 350.00 credit. Unfortunately, there is no easy way of doing this, and if the above is an example, where the number of duplicates is much higher, then it's going to be awkward. you might want to try (on a backup version of the table): alter table db add id int auto_increment primary key; This would insert a unique key field, but I'm not sure if it would pre-populate existing records. If it works, you can then use the update function where id="xxx"; Hope this helps Ben -Original Message- From: Richard Reina [mailto:[EMAIL PROTECTED]] Sent: 09 April 2001 10:59 To: [EMAIL PROTECTED] Subject: How update 1 of two identical rows. DateDB_amount CR_amount 2001-04-09 NULL300.00 2001-04-09 NULL750.00 2001-04-09 NULL300.00 Anyone know how can I do a query that will update the third record without updating the first? - 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: How update 1 of two identical rows.
Your table has no primary key. You have a badly malformed database. How can you tell one transaction from another? You have debit and credit amounts with no timestamp or account identifier. Add an autoincrement id field as a primary key. Then you can update based on that key. Richard Reina wrote: DateDB_amount CR_amount 2001-04-09 NULL300.00 2001-04-09 NULL750.00 2001-04-09 NULL300.00 Anyone know how can I do a query that will update the third record without updating the first? - 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: Binlog has bad magic number
database,sql,query What causes: 010409 15:47:42 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 4 010409 15:47:42 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position 4 010409 15:47:42 Error reading packet from server: Binlog has bad magic number, fire your magician (read_errno 0,server_errno=65535) in the err log of a replication slave? I can do a "load table xxx from master" so the two are communicating ok, does this have anything to do with the replication resumed in log 'FIRST' message? The log file on the master is not named FIRST. -- [EMAIL PROTECTED] (Jim Ziegler) - 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
How update 1 of two identical rows.
You can update the "first" row by adding LIMIT 1 to your update query. If the rows are identical, "first" vs. "third" doesn't matter. If it does matter, you should probably add a unique, tiebreaking field (sequence or DateTime, if you can assure there will never be 2 identical records inserted per second). Cheers, Kent - 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
Someone give me suggestion please?
is it recommended to install mysql by rpm or tar? dave - 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
Strange queries
SELECT url,newwebsites.description,newwebsites.title,newwebsites.catid,category.fullname,MATCH newwebsites.description AGAINST ('aliens') as GOO from newwebsites,category LEFT JOIN userrestrictions ON userrestrictions.name REGEXP '[[::]]username|GLOBALAUTHADMIN[[::]]' AND newwebsites.catid=userrestrictions.catid where category.catid=newwebsites.catid AND userrestrictions.catid IS NULL AND category.groupid='1' ORDER BY newwebsites.groupid DESC limit 10; Can anyone tell me why the above query works, and responds with a column labelled "GOO", but if I take the exact same query, and add "AND GOO 0" to it, it complains that there is : ERROR 1054: Unknown column 'GOO' in 'where clause' What gives? If the column GOO exists when MYSQL does an output from that query, why can't I address it in the query? Thanks for any help anyone may have! Quoting Andrew Schmidt [EMAIL PROTECTED]: Have you tried this under a 'stable' version of freebsd? In FreeBSD 4.2 beta, mysql would crash with user locks. Not mysql's fault. now, I understand RC's are generally stable; but I would still make sure that this bug doesn't show up in a stable os. regards, -- Andrew - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 09, 2001 3:34 PM Subject: mysql uses 99% cpu under freebsd 4.3 Description: mysql uses 99% cpu and becomes extremely unresponsive under high load How-To-Repeat: send about 300 simultaneous visitors to www.chicagobusiness.com and tell them to click around. Fix: restart mysql. this usally helps, at least for a few minutes. sometimes it climbs back to 99% though. Submitter-Id: submitter ID Originator: Jon Nathan Organization: Chaffee Interactive MySQL support: extended email support Synopsis: mysql uses 99% cpu and becomes unresponsive Severity: serious Priority: high Category: mysql Class: support Release: mysql-3.23.36 (Source distribution) from freebsd ports Environment: System: FreeBSD d1.crain.com 4.3-RC FreeBSD 4.3-RC #1: Tue Apr 3 16:17:52 GMT 2001 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/CHAFFEE i386 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.2 19991024 (release) Compilation info: CC='cc' CFLAGS='-O2 -pipe -mpentiumpro ' CXX='c++' CXXFLAGS='-O2 -pipe -mpentiumpro -felide-constructors -fno-rtti -fno-except ions' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1170734 Apr 3 12:24 /usr/lib/libc.a lrwxr-xr-x 1 root wheel 9 Apr 3 12:24 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 559764 Apr 3 12:24 /usr/lib/libc.so.4 Configure command: ./configure --localstatedir=/data/db --without-perl --without-debug --witho ut-readline --without-bench --with-mit-threads=no --with-libwrap --with-low- memory --enable-assembler --with-berkeley-db --with-charset=latin1 --prefix= /usr/local i386--freebsd4.3 Perl: This is perl, version 5.005_03 built for i386-freebsd - 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 --- Dynamic Hosting HTTP://www.L8R.net/ "We Provide Static Hostnames for Dynamic IP's" - 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: Someone give me suggestion please?
.deb :) Jeff Levy Software Design Meta-Craft Creations On Mon, 9 Apr 2001, David Loszewski wrote: is it recommended to install mysql by rpm or tar? dave - 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: Someone give me suggestion please?
hi. according to this: http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html the binary is recommended for linux. if you know what you're doing, or want support for wacky options, compile your own. instructions for both options are on the above page as well. hth. -ravi. -Original Message- From: David Loszewski [mailto:[EMAIL PROTECTED]] Sent: Monday, April 09, 2001 4:40 PM To: [EMAIL PROTECTED] Subject: Someone give me suggestion please? is it recommended to install mysql by rpm or tar? dave - 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
[MySQL] Backup error
Hello, I have a box running Win2k and MySQL 3.23.36, I had made a backup of all my databases/tables to CD-ROM last week. When I tried to access them again from the CD-ROM, I noticed that all file names had been altered to be displayed in uppercase and now they will not function in the php scripts I had generated. I've tried renaming the files to lowercase letters with no luck. Fortunately, these were only test databases so there won't be much loss. My question is in the future, is there a recommended way of backing up the databases that will not cause any errors? Also, would anyone know of a fix to my current problem? As I said, it was only a test database that was lost, but it was one that I would like back without going through another week of tweeking to get it back the way it was. Thanks -Tim - 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: Setting up FULLTEXT table
Hi! On Apr 09, MikemickaloBlezien wrote: I posted a couple problems regarding the use of the FULLTEXT indexing and a search query problem, but never got any responses. So maybe some one may shed some lite on setting up a table with the FULLTEXT index. I've read thru the MySQL docs on this and it's not real clear. When setting up a table, when an utilizing a FULLTEXT index. When creating the table, can it only have to columns or can the table have more then two columns: CREATE TABLE search ( id int(8), title varchar(200), keywords TEXT, category char(2) FULLTEXT (title,keywords) ) Is this correct or can you only have two columns when using the FULLTEXT Indexing?? The above is correct. By the way, you was able to find it yourself - thus saving your time - by trying to execute the SQL statement above. 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
How do I get tableName.Colname after doing a select, I can only get col name
Hi, I am doing a select from to tables which are join'ed, I cannot determine automatically which table a column belongs to:- I have tried both these selects:- SELECT * FROM staff, staffsubjectTitles WHERE staff.id = 11 AND staffsubjectTitles.staff_id = 11 SELECT staff.*, staffsubjectTitles.* FROM staff, staffsubjectTitles WHERE staff.id = 11 AND staffsubjectTitles.staff_id = 11 But both give me:- name is TYPE 12 uid is TYPE 12 id is TYPE 4 departmentTitles_id is TYPE 4 jobTitles_id is TYPE 4 taAdmin is TYPE 1 studentAdmin is TYPE 1 groupBSD_id is TYPE 4 taUser is TYPE 1 staffAdmin is TYPE 1 keyroll_id is TYPE 4 doesReports is TYPE 1 homeEmail is TYPE 12 id is TYPE 4 staff_id is TYPE 4 subjectTitles_id is TYPE 4 What I am hoping to get is:- staff.name is TYPE 12 staff.uid is TYPE 12 staff.id is TYPE 4 staff.departmentTitles_id is TYPE 4 staff.jobTitles_id is TYPE 4 staff.taAdmin is TYPE 1 staff.studentAdmin is TYPE 1 staff.groupBSD_id is TYPE 4 staff.taUser is TYPE 1 staff.staffAdmin is TYPE 1 staff.keyroll_id is TYPE 4 staff.doesReports is TYPE 1 staff.homeEmail is TYPE 12 staffsubjectTitles.id is TYPE 4 staffsubjectTitles.staff_id is TYPE 4 staffsubjectTitles.subjectTitles_id is TYPE 4 This is what I use to display the results (Perl):- for ( $i = 1 ; $i = $sth-{NUM_OF_FIELDS} ; $i++ ) { print "$sth-{NAME}-[$i-1] is TYPE $sth-{TYPE}-[$i-1] br\n"; } Unfortunately I left my O'reilly mySql perl dbi book at work. M. -- He came from Econet - Oh no, I've run out of underpants :( Home:- [EMAIL PROTECTED] http://www.wizdom.org.uk Shadow:- [EMAIL PROTECTED] http://www.shadow.org.uk Work:- [EMAIL PROTECTED] http://www.hinwick.demon.co.uk - 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: How update 1 of two identical rows.
Unfortunately I am using 3.22.32. Does this mean I am out of luck with this query. Peter Schwenk wrote: If you are using version 3.23.x of MySQL, there is a LIMIT clause that you can use to just update up to a certain number of records, so you could add 'LIMIT 1' to the UPDATE command to only change one record. Richard Reina wrote: DateDB_amount CR_amount 2001-04-09 NULL300.00 2001-04-09 NULL750.00 2001-04-09 NULL300.00 Anyone know how can I do a query that will update the third record without updating the first? - 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 -- PETER SCHWENK| Campus IT Associate 3 Department of Mathematical Sciences | University of Delaware [EMAIL PROTECTED]| (302)831-0437 - 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: Unaligned address crash on Tru64
Hi! I have tested a bit today. Various logfiles are at : http://www.dassic.dk/~jfn/mysql/ I found that after compiling with full debugging, I got the error that one of the my.cnf parameters was too little and should be increased on the server. The default is 1 MB. I tried to increase it to 16 M, then 32 MB, then 512 MB, then 5 GB. No go at all. I tried both slave server (I have 6 GB on the machine and a unlimited ulimit and full access to all memory (no sysconfigtab limitations), so I'm not low on memory). The configure and make options for this crashing debug version is in the make_bad.sh, and the error in O4_error.txt and the mysqld.trace in mysqld.trace.txt I then decided to strip down the compiler options to what you find in make_good.sh. Did a recompile (output from this in make_good.log.txt (stdout) and make_good.typescript.txt (stderr)). As the name say, this version works. I compiled with no optimization, and arch set to generic since the machine I compile on is a EV67 and the machine I test on is EV56, and I don't want any EV67 instructions to be emulated by the kernel. I deleted master.info and let the slave update about 1 GB of data. This worked without problems and I got no errors. So it appears that the recommended optimization settings from INSTALL-SOURCE does something bad to MySQL in my environment. I've tried -O3 and -O2. No go, only -O0 works. Haven't tried playing with some of the other parameters. -- Un saludo / Venlig hilsen / Regards Jesper Frank Nemholt Unix System Manager Compaq Computer Corporation Phone : +34 699 419 171 E-Mail: [EMAIL PROTECTED] - 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: Strange queries
Since MATCH is evaluated AFTER the where, you need to use HAVING SELECT url,newwebsites.description,newwebsites.title,newwebsites.catid,category.ful lname,MATCH newwebsites.description AGAINST ('aliens') as GOO from newwebsites,category LEFT JOIN userrestrictions ON userrestrictions.name REGEXP '[[::]]username|GLOBALAUTHADMIN[[::]]' AND newwebsites.catid=userrestrictions.catid where category.catid=newwebsites.catid AND userrestrictions.catid IS NULL AND category.groupid='1' ORDER BY newwebsites.groupid DESC limit 10 HAVING GOO 0; - Original Message - From: "Brad Barnett" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 09, 2001 1:43 PM Subject: Strange queries SELECT url,newwebsites.description,newwebsites.title,newwebsites.catid,category.ful lname,MATCH newwebsites.description AGAINST ('aliens') as GOO from newwebsites,category LEFT JOIN userrestrictions ON userrestrictions.name REGEXP '[[::]]username|GLOBALAUTHADMIN[[::]]' AND newwebsites.catid=userrestrictions.catid where category.catid=newwebsites.catid AND userrestrictions.catid IS NULL AND category.groupid='1' ORDER BY newwebsites.groupid DESC limit 10; Can anyone tell me why the above query works, and responds with a column labelled "GOO", but if I take the exact same query, and add "AND GOO 0" to it, it complains that there is : ERROR 1054: Unknown column 'GOO' in 'where clause' What gives? If the column GOO exists when MYSQL does an output from that query, why can't I address it in the query? Thanks for any help anyone may have! Quoting Andrew Schmidt [EMAIL PROTECTED]: Have you tried this under a 'stable' version of freebsd? In FreeBSD 4.2 beta, mysql would crash with user locks. Not mysql's fault. now, I understand RC's are generally stable; but I would still make sure that this bug doesn't show up in a stable os. regards, -- Andrew - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 09, 2001 3:34 PM Subject: mysql uses 99% cpu under freebsd 4.3 Description: mysql uses 99% cpu and becomes extremely unresponsive under high load How-To-Repeat: send about 300 simultaneous visitors to www.chicagobusiness.com and tell them to click around. Fix: restart mysql. this usally helps, at least for a few minutes. sometimes it climbs back to 99% though. Submitter-Id: submitter ID Originator: Jon Nathan Organization: Chaffee Interactive MySQL support: extended email support Synopsis: mysql uses 99% cpu and becomes unresponsive Severity: serious Priority: high Category: mysql Class: support Release: mysql-3.23.36 (Source distribution) from freebsd ports Environment: System: FreeBSD d1.crain.com 4.3-RC FreeBSD 4.3-RC #1: Tue Apr 3 16:17:52 GMT 2001 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/CHAFFEE i386 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.2 19991024 (release) Compilation info: CC='cc' CFLAGS='-O2 -pipe -mpentiumpro ' CXX='c++' CXXFLAGS='-O2 -pipe -mpentiumpro -felide-constructors -fno-rtti -fno-except ions' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1170734 Apr 3 12:24 /usr/lib/libc.a lrwxr-xr-x 1 root wheel 9 Apr 3 12:24 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 559764 Apr 3 12:24 /usr/lib/libc.so.4 Configure command: ./configure --localstatedir=/data/db --without-perl --without-debug --witho ut-readline --without-bench --with-mit-threads=no --with-libwrap --with-low- memory --enable-assembler --with-berkeley-db --with-charset=latin1 --prefix= /usr/local i386--freebsd4.3 Perl: This is perl, version 5.005_03 built for i386-freebsd - 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 --- Dynamic Hosting HTTP://www.L8R.net/ "We Provide Static Hostnames for Dynamic IP's" - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/
Re: mysql uses 99% cpu under freebsd 4.3
I have experienced the same problems on a dual processor machine running 4.2-STABLE and mysql 3.23.36 from the ports tree. regards, Lars Andersson At 16:03 2001-04-09 -0400, Andrew Schmidt wrote: Have you tried this under a 'stable' version of freebsd? In FreeBSD 4.2 beta, mysql would crash with user locks. Not mysql's fault. now, I understand RC's are generally stable; but I would still make sure that this bug doesn't show up in a stable os. regards, -- Andrew - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 09, 2001 3:34 PM Subject: mysql uses 99% cpu under freebsd 4.3 Description: mysql uses 99% cpu and becomes extremely unresponsive under high load How-To-Repeat: send about 300 simultaneous visitors to www.chicagobusiness.com and tell them to click around. Fix: restart mysql. this usally helps, at least for a few minutes. sometimes it climbs back to 99% though. Submitter-Id: submitter ID Originator: Jon Nathan Organization: Chaffee Interactive MySQL support: extended email support Synopsis: mysql uses 99% cpu and becomes unresponsive Severity: serious Priority: high Category: mysql Class: support Release: mysql-3.23.36 (Source distribution) from freebsd ports Environment: System: FreeBSD d1.crain.com 4.3-RC FreeBSD 4.3-RC #1: Tue Apr 3 16:17:52 GMT 2001 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/CHAFFEE i386 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.2 19991024 (release) Compilation info: CC='cc' CFLAGS='-O2 -pipe -mpentiumpro ' CXX='c++' CXXFLAGS='-O2 -pipe -mpentiumpro -felide-constructors -fno-rtti -fno-except ions' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1170734 Apr 3 12:24 /usr/lib/libc.a lrwxr-xr-x 1 root wheel 9 Apr 3 12:24 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 559764 Apr 3 12:24 /usr/lib/libc.so.4 Configure command: ./configure --localstatedir=/data/db --without-perl --without-debug --witho ut-readline --without-bench --with-mit-threads=no --with-libwrap --with-low- memory --enable-assembler --with-berkeley-db --with-charset=latin1 --prefix= /usr/local i386--freebsd4.3 Perl: This is perl, version 5.005_03 built for i386-freebsd - 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
libmysqlclient.so.9: cannot open blah blah blah
Hello, I have jsut installed mysql,DBI etc on my linux 7.0 box. I got this error first thing trying to change the root password. I do NOT have a file libmysqlclient.so.9 but i DO have a file libmysqlclient.so.10. how did this get out of sync and how can I repair this install? Thanks, Gim - 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: Transactions in MySql
Uh, before you take his head off, consider that most people using MySQL are not in a position to build MySQL themselves (or trust whatever comes out of "./configure --whatever_options; make"). And the default binary distribution does not include BDB or InnoBase for any platform (that's coming soon, but is still in process..). So telling them to RTFM doesn't help, because even if they do, it won't give them transactions. MySQL seems to ignore TABLE TYPE specifications if it isn't compiled for that table type (i.e. if you take the default distribution and create a table with TYPE=BDB, it just quietly ignores that spec and creates a MyISAM table, leading to much confusion for the uninitiated - shouldn't it at least give a warning about "unknown table type"??). So until we have such binary distributions that support BDB and InnoBase, it's probably more appropriate to point out to them that they have to build their own distribution with BDB and/or InnoBase, and *then* tell them to continue on and RTFM.. -Original Message- From: Gerald Clark [mailto:[EMAIL PROTECTED]] Sent: Monday, April 09, 2001 6:19 AM To: Marco Baldacchini Cc: [EMAIL PROTECTED] Subject: Re: Transactions in MySql Marco Baldacchini wrote: MySql support transactions? The OLE-DB provider support transactions? Call the method Begintrans on a connection object (ADO) return an error!!! And you read the manual, right? Transaction support depends on the version of MySQL you are running, and the table type created. Read the manual, then ask questions.
RE: Strange queries
Hi, You can't use aliases in a where, but you can in a HAVING clause. Regards Quentin -Original Message- From: Brad Barnett [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 10 April 2001 8:44 a.m. To: [EMAIL PROTECTED] Subject: Strange queries SELECT url,newwebsites.description,newwebsites.title,newwebsites.catid,category.ful lname,MATCH newwebsites.description AGAINST ('aliens') as GOO from newwebsites,category LEFT JOIN userrestrictions ON userrestrictions.name REGEXP '[[::]]username|GLOBALAUTHADMIN[[::]]' AND newwebsites.catid=userrestrictions.catid where category.catid=newwebsites.catid AND userrestrictions.catid IS NULL AND category.groupid='1' ORDER BY newwebsites.groupid DESC limit 10; Can anyone tell me why the above query works, and responds with a column labelled "GOO", but if I take the exact same query, and add "AND GOO 0" to it, it complains that there is : ERROR 1054: Unknown column 'GOO' in 'where clause' What gives? If the column GOO exists when MYSQL does an output from that query, why can't I address it in the query? Thanks for any help anyone may have! Quoting Andrew Schmidt [EMAIL PROTECTED]: Have you tried this under a 'stable' version of freebsd? In FreeBSD 4.2 beta, mysql would crash with user locks. Not mysql's fault. now, I understand RC's are generally stable; but I would still make sure that this bug doesn't show up in a stable os. regards, -- Andrew - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 09, 2001 3:34 PM Subject: mysql uses 99% cpu under freebsd 4.3 Description: mysql uses 99% cpu and becomes extremely unresponsive under high load How-To-Repeat: send about 300 simultaneous visitors to www.chicagobusiness.com and tell them to click around. Fix: restart mysql. this usally helps, at least for a few minutes. sometimes it climbs back to 99% though. Submitter-Id: submitter ID Originator: Jon Nathan Organization: Chaffee Interactive MySQL support: extended email support Synopsis: mysql uses 99% cpu and becomes unresponsive Severity: serious Priority: high Category: mysql Class: support Release: mysql-3.23.36 (Source distribution) from freebsd ports Environment: System: FreeBSD d1.crain.com 4.3-RC FreeBSD 4.3-RC #1: Tue Apr 3 16:17:52 GMT 2001 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/CHAFFEE i386 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.2 19991024 (release) Compilation info: CC='cc' CFLAGS='-O2 -pipe -mpentiumpro ' CXX='c++' CXXFLAGS='-O2 -pipe -mpentiumpro -felide-constructors -fno-rtti -fno-except ions' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1170734 Apr 3 12:24 /usr/lib/libc.a lrwxr-xr-x 1 root wheel 9 Apr 3 12:24 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 559764 Apr 3 12:24 /usr/lib/libc.so.4 Configure command: ./configure --localstatedir=/data/db --without-perl --without-debug --witho ut-readline --without-bench --with-mit-threads=no --with-libwrap --with-low- memory --enable-assembler --with-berkeley-db --with-charset=latin1 --prefix= /usr/local i386--freebsd4.3 Perl: This is perl, version 5.005_03 built for i386-freebsd - 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 --- Dynamic Hosting HTTP://www.L8R.net/ "We Provide Static Hostnames for Dynamic IP's" - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your
Re: [MySQL] Backup error
Unfortunately, you're using MySQL on a Microsoft product, and you've probably run into one of those issues where Redmond decided what's best for you (changing the 'case' of the filenames). BUT, in both the Microsoft and UNIX realm of products, 'packaging' files (on UNIX using 'tar' and 'gzip', and on Windows-XX using "pkzip" or "winzip" or GNU's tar and Gzip for MS products) before moving or backing them up should help 'protect' them (since thought the 'package' might change, the files within are 'protected'). Tim Thorburn wrote: Hello, I have a box running Win2k and MySQL 3.23.36, I had made a backup of all my databases/tables to CD-ROM last week. When I tried to access them again from the CD-ROM, I noticed that all file names had been altered to be displayed in uppercase and now they will not function in the php scripts I had generated. I've tried renaming the files to lowercase letters with no luck. Fortunately, these were only test databases so there won't be much loss. My question is in the future, is there a recommended way of backing up the databases that will not cause any errors? Also, would anyone know of a fix to my current problem? As I said, it was only a test database that was lost, but it was one that I would like back without going through another week of tweeking to get it back the way it was. Thanks -Tim - 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: Setting up FULLTEXT table
On Mon, 9 Apr 2001 23:16:21 +0200, Sergei Golubchik [EMAIL PROTECTED] wrote: Then how come I keep getting these results when setting a test table. Am I missing something here?? Create the table: DROP TABLE IF EXISTS bus_search; CREATE TABLE bus_search ( bus_id int(8), title varchar(200), keywords TEXT, cat_prefix char(2), FULLTEXT (title,keywords) ); Insert Test Data: INSERT INTO bus_search (bus_id,tite,keywords,cat_prefix) VALUES('9','Dealersecrets, Inc.','Secrets to the Best Car Deals negotiating prices book with tips for buying','VE'); Run queries: QUERY1: SELECT title FROM bus_search WHERE MATCH(title,keywords) AGAINST('car deals') 0 rows returned -- QUERY2: EXPLAIN SELECT title FROM bus_search WHERE MATCH(title,keywords) AGAINST('car deals') Comment Impossible WHERE noticed after reading const tables Hi! On Apr 09, MikemickaloBlezien wrote: I posted a couple problems regarding the use of the FULLTEXT indexing and a search query problem, but never got any responses. So maybe some one may shed some lite on setting up a table with the FULLTEXT index. I've read thru the MySQL docs on this and it's not real clear. When setting up a table, when an utilizing a FULLTEXT index. When creating the table, can it only have to columns or can the table have more then two columns: CREATE TABLE search ( id int(8), title varchar(200), keywords TEXT, category char(2) FULLTEXT (title,keywords) ) Is this correct or can you only have two columns when using the FULLTEXT Indexing?? The above is correct. By the way, you was able to find it yourself - thus saving your time - by trying to execute the SQL statement above. Regards, Sergei Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-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: [MySQL] Backup error
Fortunately, these were only test databases so there won't be much loss. My question is in the future, is there a recommended way of backing up the databases that will not cause any errors? I'm using mysqldump to create backups.. but that's on linux, I'm not sure about windooz version. Probably the same.. Bye, B. To satisfy the new spam filter: You may query our database and buy products.. like books on sql. Not that we sell any.. but is does satisfy the filter :-) - 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 uses 99% cpu under freebsd 4.3
Similar problems on FreeBSD 4.2-RELEASE. Dedicated Mysql server is pinning the CPU, under a load of 500+ queries per second. Memory is not exausted, and Disk usage is 0. Just the CPU is pinned. [EMAIL PROTECTED] wrote: Description: mysql uses 99% cpu and becomes extremely unresponsive under high load How-To-Repeat: send about 300 simultaneous visitors to www.chicagobusiness.com and tell them to click around. Fix: restart mysql. this usally helps, at least for a few minutes. sometimes it climbs back to 99% though. Submitter-Id: submitter ID Originator:Jon Nathan Organization: Chaffee Interactive MySQL support: extended email support Synopsis: mysql uses 99% cpu and becomes unresponsive Severity: serious Priority: high Category: mysql Class: support Release: mysql-3.23.36 (Source distribution) from freebsd ports Environment: System: FreeBSD d1.crain.com 4.3-RC FreeBSD 4.3-RC #1: Tue Apr 3 16:17:52 GMT 2001 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/CHAFFEE i386 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.2 19991024 (release) Compilation info: CC='cc' CFLAGS='-O2 -pipe -mpentiumpro ' CXX='c++' CXXFLAGS='-O2 -pipe -mpentiumpro -felide-constructors -fno-rtti -fno-exceptions' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1170734 Apr 3 12:24 /usr/lib/libc.a lrwxr-xr-x 1 root wheel 9 Apr 3 12:24 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 559764 Apr 3 12:24 /usr/lib/libc.so.4 Configure command: ./configure --localstatedir=/data/db --without-perl --without-debug --without-readline --without-bench --with-mit-threads=no --with-libwrap --with-low-memory --enable-assembler --with-berkeley-db --with-charset=latin1 --prefix=/usr/local i386--freebsd4.3 Perl: This is perl, version 5.005_03 built for i386-freebsd - 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