auto Incerment
HI I'm having problem with the AUTO_INCREMENT, we are using ver 3.23.33 This is the definition of table software_machineOSs ++--+--++-++ | Field | Type | Null | Key | Default | Extra | ++--+---+---+-++ | softwareID | char(20)| YES | MUL| NULL| | | id | int(2) || | NULL | auto_increment | | osName | char(20)| YES| | NULL || | osRevision | char(20)| YES| | NULL || ++--+---+---+---+--+ Adding an entry mysql insert into software_machineOSs (softwareID, id, osName, osRevision) - values (readline-4.3, NULL, test, test3); Selecting entries mysql select * from software_machineOSs where softwareid=readline-4.3; +--++---++ | softwareID | id | osName| osRevision | +--++---++ | readline-4.3 | 1 | Tru64 | 5.1| | readline-4.3 | 1 | Solaris/Sparc | 8 | | readline-4.3 | 1 | Solaris/x86 | 8 | | readline-4.3 | 1 | test | test | | readline-4.3 | 1 | test | test1 | | readline-4.3 | 1 | test | test1 | | readline-4.3 | 1 | test | test3 | +--++---++ 7 rows in set (0.00 sec) As you can see the ID did NOT increment, I'm not sure what I'm doing wrong. I tried with out giving any value for ID, 0 value for ID NULL for ID. Non of them seems working. Is this a bug in the version 3.23.33?? Appreciate your fast response Thank you for your time warm regards Vinita - 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: auto Incerment
HI I'm having problem with the AUTO_INCREMENT, we are using ver 3.23.33 This is the definition of table software_machineOSs ++--+--++-++ | Field | Type | Null | Key | Default | Extra | ++--+---+---+-++ | softwareID | char(20)| YES | MUL| NULL | | | id | int(2) || | NULL| auto_increment | | osName | char(20)| YES| | NULL || | osRevision | char(20)| YES| | NULL || ++--+---+---+---+--+ Adding an entry mysql insert into software_machineOSs (softwareID, id, osName, osRevision) - values (readline-4.3, NULL, test, test3); Selecting entries mysql select * from software_machineOSs where softwareid=readline-4.3; +--++---++ | softwareID | id | osName| osRevision | +--++---++ | readline-4.3 | 1 | Tru64 | 5.1| | readline-4.3 | 1 | Solaris/Sparc | 8 | | readline-4.3 | 1 | Solaris/x86 | 8 | | readline-4.3 | 1 | test | test | | readline-4.3 | 1 | test | test1 | | readline-4.3 | 1 | test | test1 | | readline-4.3 | 1 | test | test3 | +--++---++ 7 rows in set (0.00 sec) As you can see the ID did NOT increment, I'm not sure what I'm doing wrong. I tried with out giving any value for ID, 0 value for ID NULL for ID. Non of them seems working. Is this a bug in the version 3.23.33?? Appreciate your fast response Thank you for your time warm regards Vinita - 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: Multi-table updates in MySQL
Howdy, Multiple table updates are not available in MySQL. I had the same problem and it was driving me crazy... I suggest you try combining your nice query with some PHP code, did work for me! :) good luck, Maarten Roosen -Original Message- From: Phil Kernick [mailto:[EMAIL PROTECTED]] Sent: woensdag 18 september 2002 7:36 To: [EMAIL PROTECTED] Subject: Multi-table updates in MySQL I'm using MySQL v3.23.52. I want to update a column in one table to be based on a calculated expression from a column in another table. Specifically I want something like this: mysql update a set a.f1=b.f1 where a.f2=b.f2; mysql update a, b set a.f1=b.f1 where a.f2=b.f2; The first says table b is unknown, the second doesn't let there be multiple tables in an update. While I could do this programatically using PHP or Perl, it feels like this is something sensible to do in a single line. If there is a way to do this, please let me know directly as I'm not subscribed to the list. Thanks, Phil. -- _-_|\ Phil Kernick E-Mail: [EMAIL PROTECTED] / \ ROTFL Enterprises Mobile: 041 61 ROTFL \_.-*_/ v Humourist, satirist, and probably a few more 'ists to boot! - 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: mysqlbug
Hi Winnie, You can run rpm -qa |grep -i mysql to see exactly what the installed packages are named. Then you should be able to uninstall (rpm -e) these packages. On the other hand, there could be some package dependencies, which means, that some other software installed will not run without the RedHat MySQL RPMs... Regards, Michael - Original Message - From: Winnie Kwok [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 17, 2002 4:33 PM Subject: mysqlbug first of all , thanks for your help, i cannot install mysql yet as run: rpm -e MySQL;rpm -e MySQL-server error:package MySQL is not installed error:package MySQL-server is not installed From: Michael Paesold [EMAIL PROTECTED] To: Winnie Kwok [EMAIL PROTECTED] Subject: Re: mysqlbug Date: Mon, 16 Sep 2002 20:06:41 +0200 Winnie Kwok wrote: using REDHAT 7.3 After run [root@localhost root]#cd /usr/local/ [root@localhost local]#rpm -i MySQL-3.23.52-1.i386.rpm MySQL-client-3.23.52-1.i386.rpm error:failed dependencies: MySQL conflicts with -3.23.49-3 MySQL-server conflicts with MySQL-server-3.23.49-3 This is not a bug. You have already installed MySQL RPM's provided by RedHat on your server. You have to remove those first before you can install the RPM's from www.mysql.com. rpm -e MySQL; rpm -e MySQL-server There could be some dependencies, though. Regards, Michael _ Chat with friends online, try MSN Messenger: http://messenger.msn.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
sum column in mysql
Hi, I have a table table1, with a column Duration time type(ex 00:12:30) I want to make a sql selection: SELECT * from table1 WHERE condition, and after that, to make sum of values of column Duration and display it. Any Help? tx - 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
Connect to Database over the Internet
Hello All: I would appreciate some help on how to configure my application code or the computer which mysql resides on so it can be accesed over the intenet. Putting aside the obvious security concerns how can I achieve this. The application is written in VB using ADO to access the database. Currently this is the connect string I currently use to connect to the database. .ConnectionString = Data Source = REGIONAL;SERVER=xx.xx.xx.xxx;User ID = root; Password It works fine connecting to the database when run on the same computer which contains the MYSQL database. When I try the application from a remote computer configured it does not connect. No firewall is involved. I suspect I need to configure certain networking protocols on the host/ server machine, but am lost as to what I should be doing. The operating system is XP professional. Any suggestions. Thanks -=Bryan=-
Connect to Database over the Internet
Hello All: I would appreciate some help on how to configure my application code or the computer which mysql resides on so it can be accesed over the intenet. Putting aside the obvious security concerns how can I achieve this. The application is written in VB using ADO to access the database. Currently this is the connect string I currently use to connect to the database. .ConnectionString = Data Source = REGIONAL;SERVER=xx.xx.xx.xxx;User ID = root; Password It works fine connecting to the database when run on the same computer which contains the MYSQL database. When I try the application from a remote computer configured it does not connect. No firewall is involved. I suspect I need to configure certain networking protocols on the host/ server machine, but am lost as to what I should be doing. The operating system is XP professional. Any suggestions. Thanks -=Bryan=-
determine value of auto-increment field after adding record - @ runtime
I have a table that will auto increment it's PK field upon adding a new record. I would like obtain that auto-increment value immedicately after the add of that record so that I may reference it within another table ... sort of an informal PK/FK relationship. In SQLServer I believe I recall there was a function something like @@ID to retrieve this value ... could be written directly into your SQL. What sort of function exists in mySQL for this purpose? Thanks. NEal - 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
date field - default value = current date
Is there a wat to have mySQL auto fill in the current date into my dateCreated field? In SQLServer I would simply specify the getDate() method as a default value. I presume I would use the analogous MySQL function curDate() but it does not appear to work for me. Any suggestions? - 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
tinyInt(7) - not limited to 7 digits???
If Tomcat is installed and pointing to JDK1.3 but one wants to point instead to JDK1.4, is there an easy way to do this? If so, I'm not finding it. Seems like one would need to completely uninstall and reinstall tomcat??? Thanks. Neal [sql,query] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
compiling client only on SunOS 4.1.3
Hi all, Attempting to compile the mysql client only as a non-root user [install locally at $HOME/bin]. I grabbed the source from: http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.52.tar.gz uname -a reports: SunOS ka 4.1.3_U1 14 sun4m configure is run as such: ./configure --without-server --disable-shared --prefix=/oops/ka/vjl/bin and then, after it successfully [no errors] configures the files, I run a simple, make. make errors out with: echo timestamp llstr.lo gcc -DDEFAULT_CHARSET_HOME=\/oops/ka/vjl/bin\ -DDATADIR=\/oops/ka/vjl/bin/var\ -DSHAREDIR=\/oops/ka/vjl/bin/share/mysql\ -DUNDEF_THREADS_HACK -DDONT_USE_RAID -I./../include -I../include -I./.. -I.. -I.. -O3 -DDBUG_OFF -c conf_to_src.c conf_to_src.c: In function `main': conf_to_src.c:45: `EXIT_FAILURE' undeclared (first use this function) conf_to_src.c:45: (Each undeclared identifier is reported only once conf_to_src.c:45: for each function it appears in.) conf_to_src.c:64: `EXIT_SUCCESS' undeclared (first use this function) conf_to_src.c: In function `print_arrays_for': conf_to_src.c:124: `EXIT_FAILURE' undeclared (first use this function) *** Error code 1 make: Fatal error: Command failed for target `conf_to_src.o' Current working directory /oops/ka/vjl/tmp/mysql-3.23.52/libmysql *** Error code 1 make: Fatal error: Command failed for target `all-recursive' Current working directory /oops/ka/vjl/tmp/mysql-3.23.52 *** Error code 1 make: Fatal error: Command failed for target `all-recursive-am' I used gtar to untar the tarball, fwiw. I'm not sure what the above error is refering to; any incite into getting the above to work, or a source for a binary compile of SunOS 4.1.3 [client only] would be most appreciated. Thanks, /vjl/ -- Vince LaMonica UC Irvine, School of Social Ecology W3 Developer * 116 Social Ecology I, Irvine, CA 92697 [EMAIL PROTECTED] https://www.seweb.uci.edu/~vjl If Bill Gates had a nickel for every time Windows crashed... ... oh wait, never mind. - 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: Connect to Database over the Internet
Bryan, Hi! Did you specify --skip-networking in my.cnf? Check if MySQL is listening on port 3306 (or the port you specified) for TCP connections. Also, I highly suspect that you forgot to set the proper privilege for connections made from hosts other than localhost. SELECT * FROM mysql.user should give you the answer. Check if root is only allowed to connect from 127.0.0.1 (localhost) Hope this helps. SolNET Digital Jindo [EMAIL PROTECTED] Tel: +886 2 26547645 Fax:+886 2 26515005 Cell: 0922706509 -Original Message- From: Bryan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 4:00 PM To: [EMAIL PROTECTED] Subject: Connect to Database over the Internet Hello All: I would appreciate some help on how to configure my application code or the computer which mysql resides on so it can be accesed over the intenet. Putting aside the obvious security concerns how can I achieve this. The application is written in VB using ADO to access the database. Currently this is the connect string I currently use to connect to the database. .ConnectionString = Data Source = REGIONAL;SERVER=xx.xx.xx.xxx;User ID = root; Password It works fine connecting to the database when run on the same computer which contains the MYSQL database. When I try the application from a remote computer configured it does not connect. No firewall is involved. I suspect I need to configure certain networking protocols on the host/ server machine, but am lost as to what I should be doing. The operating system is XP professional. Any suggestions. Thanks -=Bryan=- - 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
optimizer bug in selecting fields that don´t belong to the index used by mysql/innodb
Hi! r == rafarife [EMAIL PROTECTED] writes: cut rAnd now, the explain selects: r 1) Slow query r explain Select Cod,Nom,Nif,Nombre_comercial from Clientes r Where (Nom = 'GARCIA MANCILLA,S.L' And Cod'061642') r Or Nom'GARCIA MANCILLA,S.L' Order by Nom ASC, Cod ASC Limit 50; r tabletype possible keys keykey_len refrowsExtra r - - ------ ---- r Clientes index PRIMARY,Nombre Nombre 464039where used The above explains what happens. For some strange reason MySQL uses a full index scan above instead of a 'range' query. This really looks like a bug in the optimiser. To solve this we would however need a copy of your tables to be able to repeat this. Can you please ftp them to ftp://support.mysql.com/pub/mysql/secret so that we can try to fix ASAP ? Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: optimizer bug in selecting fields that dont belong to the index used by mysql/innodb
Hi! Heikki == Heikki Tuuri [EMAIL PROTECTED] writes: Heikki Rafa, Heikki OR's are generally difficult to optimize. Heikki, this is true if you are using OR on different keys. MySQL can fully optimise the query when using OR on different key parts of the same key (which is the case for the used query:) Select Cod,Nom,Nif,Nombre_comercial from Clientes Where (Nom = 'GARCIA MANCILLA,S.L' And Cod'061642') Or Nom'GARCIA MANCILLA,S.L' Order by Nom ASC, Cod ASC Limit 50; In this case MySQL should start scanning the table from the key [(GARCIA MANCILLA),(061642)[ and continue until it has found 50 rows. 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
AES_DECRYPT(garabage, key) problem (4.0.4 bk snapshot)
Hi! Sergey == Sergey S Kostyliov [EMAIL PROTECTED] writes: Description: Sergey Server hang when trying to test field=AES_DECRYPT(filed, key) Sergey in case when filed contain garbage. How-To-Repeat: Sergey CREATE TABLE atest( Sergey id int(11) NOT NULL auto_increment, Sergey tmp text NOT NULL, Sergey KEY id (id) Sergey ) TYPE=MyISAM; Sergey INSERT INTO atest VALUES (1, 'a545f661efdd1fb66fdee3aab79945bf'); Sergey SELECT * FROM atest WHERE tmp=AES_DECRYPT(tmp,password); Thanks for the test case. This is now fixed in the upcoming 4.0.4 release. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ 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
BUG: 'strend' function in libmysql needs to be private
Hi! Ben == Ben Goodwin [EMAIL PROTECTED] writes: Ben There are probably other functions that need to be made private, too.. but Ben this one's directly affecting me. Ben I'm writing a shared library that loads libmysqlclient; When Solaris 'csh' Ben uses said library, there's a clash between csh (and/or one of the libs it Ben uses) and MySQL's 'strend' function. 'strend' will not return proper values Ben under these circumstances, preventing me from even connecting to the server Ben on intel, and, worse, core-dumping under sparc. Can you take a peek at Ben this? I'll provide more info if necessary. strend() is a function we use a lot in the MySQL client code and is thus included in the libmysqlclient library. I can't see how csh could affect this in any way as csh doesn't have anything directly to do with shared libraries. (Except of course if you are trying to load a shared library inside csh).using a patched csh Which public library is it that has a conflicting function ? (I have used Solaris a lot and never seen this problem before) What is it that core dumps; csh or your application ? Does your application work if you are running 'sh' ? Ben FWIW I renamed the function to _strend, recompiled/installed, and my Ben problems went away... Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ 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
optimizer bug in selecting fields that don´t belong to the index used by mysql
Hi! rafarife == rafarife [EMAIL PROTECTED] writes: rafarife Description: rafarife Hello, rafarife I am working with mysqld-max-nt under windows 2000 and unsing InnoDb rafarife tables. rafarife I have the following table: cut rafarifeI don´t understand why this select: rafarifeSelect Cod,Nom,Nif,Nombre_comercial from Clientes Where (Nom = 'GARCIA MANCILLA,S.L' And Cod'061642') rafarife Or Nom'GARCIA MANCILLA,S.L' Order by Nom ASC, Cod ASC Limit 50; rafarife(Mysql uses the unique index: Nombre) What is the output from EXPLAIN for this query ? Do you get a similar problem with MyISAM tables ? 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: aggregate functions producing bad data
Perhaps you should create a new table with an id column and a flag column. Select the found calls 5 or = 5 into that new table and set the flag. Then do a left join of your t_callog_calls table on the new table selecting only the rows where the flag is NULL, these should be the rows not found by either query. Inspect the data in these rows manually to determine what is wrong. -Original Message- From: Richard Unger [mailto:[EMAIL PROTECTED]] Sent: September 17, 2002 21:00 To: [EMAIL PROTECTED] Subject: aggregate functions producing bad data My query: SELECT count(id), count( IF(call_end - call_start 5, id, NULL) ), count( IF(call_end - call_start = 5, id, NULL) ) FROM t_calllog_calls; My result: 1994 1956 35 However, 1956 + 35 != 1994. Running MySQL 3.23.49-nt Cheers, Rich - 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: date field - default value = current date
Check TIMESTAMP type in the documentation. Best regards, Mikhail. - Original Message - From: neal [EMAIL PROTECTED] To: mySQL [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 10:32 AM Subject: date field - default value = current date Is there a wat to have mySQL auto fill in the current date into my dateCreated field? In SQLServer I would simply specify the getDate() method as a default value. I presume I would use the analogous MySQL function curDate() but it does not appear to work for me. Any suggestions? - 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
optimizer bug in selecting fields that don´t belong to the index used by mysql
Description: Hello Monty, I have already sent to pub/mysql/secret the table definition and data (clientes.txt) and my.ini file in a compressed file named clientes.zip. You can import clientes.txt and test it. I have only then problem with InnoDb tables. I tell you my test with the above table clientes ( InnoDB table I ran the following query: Select Cod,Nom,Nif,Nombre_comercial from Clientes Where (Nom = 'a2618' And Cod'059336') Or Nom'a2618' Order by Nom ASC, Cod ASC Limit 50; Time:0.08 secs. Handler_read_next: 1850 Explain: tabletype possible_keys keykey_len ref rows Extra Clientes index PRIMARY,Nombre Nombre 46 NULL 3899 where used I changed the table type to MyIsam (alter table clientes type=MyIsam), and I ran the above query: MyIsam table Select Cod,Nom,Nif,Nombre_comercial from Clientes Where (Nom = 'a2618' And Cod'059336') Or Nom'a2618' Order by Nom ASC, Cod ASC Limit 50; Time:0.00 secs. Handler_read_next: 49 Explain: tabletype possible_keys keykey_len ref rows Extra Clientes range PRIMARY,Nombre Nombre 46 NULL 4057 where used Thanks in advance, Rafa How-To-Repeat: Select Cod,Nom,Nif,Nombre_comercial from Clientes Where (Nom = 'a2618' And Cod'059336') Or Nom'a2618' Order by Nom ASC, Cod ASC Limit 50; Fix: - Synopsis:optimizer bug in selecting fields that don´t belong to the index used by mysql/innodb Submitter-Id: submitter ID Originator: Rafa Organization: Pecomark MySQL support: none Severity: non-critical Priority: medium Category: mysqld-max-nt Class: sw-bug Release:mysqld 4.0.3 beta(InnoDB) Exectutable: mysqld-max-nt Environment: Pentium III-MMX, 500 MHZ, 540 MB System:Windows 2000 Compiler: - Architecture: i __ The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.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
My Replication Story
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello All, Hope somebody can shed some light on this as i think my torch is running out of batteries ;-) I have two mysql 4.0.1 servers on two 1Ghz athlon boxes (which are both running on Mandrake linux 8.2). Our main server has been bulked up with 1Gb of ram and various other goodies whilst the second server is a more modest replication slave with 128mb and a single ide hdd and a dds4 drive. We use the replication slave to take snapshot backups of the database during the working day (hence the dds drive ;-) but recently have had problems... We make regular use of temporary tables in our application which seems to cause problems for the replication slave. Doing a 'SHOW SLAVE STATUS' gives us the following on one particular table. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Slave: query 'drop table gessica.tmpcredit_card' partially completed on the master and was aborted. There is a chance that your master is inconsistent at this point. If you are sure that your master is ok, run this query manually on the slave and then restart the slave with SET SQL_SLAVE_SKIP_COUNTER=1; SLAVE START; =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= We get messages like this for every temporary table we use. Normally i'd be happy to tell mysql to ignore this, as this particular temporary table is not used in any subsequent updates or inserts, but we need to use some temp tables to update data. In an effort to resolve this we upgraded to mysql-4.0.3 which seemed to go fine. Replication worked a treat and everything seemed ok until next morning. Once the server was under load (about 25 users), mysql processes started falling over on the server reporting mysqld got signal 11;. After trying everything we could think of, and in a last ditch attempt to make the system usable again we downgraded back to 4.0.1 and everything worked with exception to the replication. I had taken a backup of the logfile before downgrading to 4.0.1 which showed the following (many times obviously) =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=402649088 read_buffer_size=2093056 sort_buffer_size=2097144 max_used_connections=0 max_connections=500 threads_connected=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 2439208 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x8721418 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xbfe7ea78, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x8072b1a 0x827b7b8 0x80c817d 0x80c7010 0x80a4025 0x809d8b4 0x8096913 0x80a3a86 0x807ceda 0x8080af5 0x807bfe3 0x8081eae 0x807b1be 0x8278e9c 0x82ae29a New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x8728558 = SELECT DISTINCT job_headers.*, job_threads.access_timeslot, job_threads.access_c omments, job_threads.access_timeslot_details, job_threads.date_of_inspection, job_threads.access_type, job _threads.engineer_comments FROM job_headers, job_threads WHERE job_threads.jid_ptr=job_headers.jid AND cmp id=18874 thd-thread_id=1 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Running the backtrace through resolve_stack_dump with the sym file revealed the following... =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= thd=0x8721418 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xbfe7ea78, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x8072b1a handle_segfault__Fi + 450 0x827b7b8 pthread_sighandler + 184 0x80c817d open__7ha_heapPCciUi + 317 0x80c7010 ha_open__7handlerPCcii + 36 0x80a4025 open_tmp_table__FP8st_table + 29 0x809d8b4 create_tmp_table__FP3THDP15TMP_TABLE_PARAMRt4List1Z4ItemP8st_orderbN24Ul + 4560 0x8096913
Re: Japanese Charset
This is for anyone out there storing Japanese characters along with English characters. Hi. SUMMARY: The client recently requested that Japanese be stored in an otherwise standard English (Latin) MySQL database. Whereas all rows in the table used to be Latin only, now some rows store Latin and some store Japanese. This should create no problems for MySQL. Drivers and other software between may do funny things. Hmm. I wonder if the text is surviving your paste buffer, if you aren't running the system in Japanese. In other words, I'm wondering if your text survives the paste from Word to your publishing tool. I do not mix English with Japanese in the same row. Actually, with one or two exceptions, shift-JIS and euc-JIS should allow you to mix Japanese and English with no problems. Straight JIS would have problems, however, because it is two-byte-only. The problem characters are the ASCII backslash, which is the (half-width) yen symbol in shift-JIS, and the ASCII tilde, which is sometimes the (half-width) overbar in shift-JIS. I think euc-JIS does the same substitutions, but it's been several months since I messed with that. Upon writing Japanese data to the database (web form - ASP - MyODBC), and then viewing the record on a web page (Shift-Jis), I discover that random Japanese characters are being 'morphed' into other, seemingly random, Japanese characters, and very occasionally, 'morphed' into a Latin character (so far just the letter t). Can you catch what's going into IIS and what's coming out? Also, what's going into MyODBC and what's coming out of that? I vaguely recall that MyODBC sometimes coughs if not set up right. Say, how are you declaring your doctype? You know, the Content-Type header or meta-tag, or the XML doctype. See: HTML: http://www.w3.org/TR/html4/charset.html#h-5.2.2 Header: Content-Type: text/html; charset=EUC-JP or Meta-tag: META http-equiv=Content-Type content=text/html; charset=EUC-JP XML: http://www.w3c.org/TR/2000/REC-xml-20001006#sec-prolog-dtd ?xml version=1.0 encoding=shift-jis ? I think the driver may throw fits if you don't have the document type declared right. (See above about mixing character sets.) Hmm. You may find it easiest, if you are trying to display Japanese, Chinese, Korean, and English on the same page, to use Unicode UTF-8 throughout. With the exception of these few, random characters, all the Japanese data looks fine *when displayed on a web page*. Worst comes to worst, post the problem characters and what they're supposed to be. (Or mail them to me direct.) I can take a look and see what bit patterns are causing problems, and that should yield some clues. This is a standard install of MySQL version 3.23.38-nt (on Windows 2000 SP2) - support for Japanese characters is installed by default, I assume. Installed, but not selected. I also store Chinese and Korean characters in the same table, and those character sets are diplayed without error. I would expect errors there too, unless you're using Unicode (UTF-8) for those. Question 1. If I were to pull the Japanese rows out and put them in a separate table - what do I do to the table to 'configure' it as storing sjis characters without setting the default character set to the entire database? Your version of MySQL does not support that. It's set in the my.ini or my.cnf configuration file for the whole database when you start MySQL up. So changing the settings for Japanese won't solve your problems unless you want to set up another instance (MSWindows, so that probably means another machine) of MySQL just for the Japanese. You shouldn't need to do that, however. The settings in my.cnf/my.ini are primarily for sort and collation order. (And error messages. Ick. There's a back-burner project I'd forgotten. Has the pan melted yet?) Question 2. How do I view Japanese records in the command line *in Japanese* to eliminate the possiblity that the culprit is somewhere outside of MySQL, for example: Microsoft IIS or ASP or MyODBC? Sorry. You'll need to set up a machine running in Japanese to do that, as far as I know. Well, if you know how to redirect to a file, and if you have a text editor capable of displaying Japanese, that might get you a look at the text. But it might introduce some other unknowns, as well. I think you mentioned a colleague who can read Japanese? It might be worth your while to, oh, wait, the MSW2k box is your server, so you don't want to mess with that. It would be handy if the box your publishing tool runs on could be set up to boot the OS into either English or Japanese. (Mac OS X can set the language for the OS at log-in time, seems like MSW ought to be able to at least switch on boot.) Question 3. How do I tell which charset MySQL is using, euc-jis or s-jis? It's Latin, unless you've set the language in my.cng/my.ini. It's in the manual, section 4.6.
Re: How to overwrite the /var/lib/mysql path during installation?
On Tue, 17 Sep 2002, Tam,Aaron wrote: I'm installing the mysql-max-3.23.52-pc-linux-gnu-i686 version. But I don't have the root permission, and don't have the /var/lib/ access permission. And I got the following error when I ran the ./configure commend. Do anyone know how to change the /var/lib/mysql directory to something else? Regards. I saw no reply to your question so I decided to give my insight. I was in the same trouble with mysql 4.0.3 for HP-UX and had no success installing it into non default directory. I tried to compile source next but that failed misserably and I didnt get any help here either so I downgraded to 3.23.xx. Compilation went fine when I turned off InnoDB. The gig is that when compiling from source there is a --prefix=/path/to/installation_dir option to configure script. I guess you allready got that this makes mysql installation script put all the stuff in the directory you specify. In this way I have my mysql installed in /var/tmp/vsurlan and on mercy of the admin :)). Greetings to all, slow down and have a better day :)). - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Forgot mysql-root password
Hi! I am using SuSE7.3 and mysqld Ver 3.23.41 for suse-linux What i did (http://www.mysql.com/doc/en/Resetting_permissions.html): # rcmysql stop # mysqld --skip-grant-tables Fatal error: Please read Security section of the manual to find out how to run mysqld as root! 020918 12:42:39 Aborting 020918 12:42:39 mysqld: Shutdown Complete How can i solve this Problem? I have alread reinstalled mysql, but unforunatelly i keeps its password. Cheers, 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: Start mysqld-nt from command line with SPACES in the path, how?
But here you do not specify the --data c:\Program Files\ option. The space couldn't be handled by the mysqld-nt exe, I believe it could have something to do with the fact that it interprets the arguments as 3 strings instead of 2. Regards Tobias Tobias Eriksson ComOpt AB Michael Löfmans gata 6 254 38 Helsingborg, Sweden Direct: +46 42 389918 Phone: +46 42 389900 e-mail: [EMAIL PROTECTED] -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED]] Sent: 16 September 2002 15:59 To: [EMAIL PROTECTED] Subject: re: Start mysqld-nt from command line with SPACES in the path, how? Tobias, Monday, September 16, 2002, 2:33:10 PM, you wrote: TE I am trying to start up the database, mysql, on a windows machine. TE I installed it into a dir under c:\Program Files\ComOpt\CellOpt TE AFP\database\. As you can see there are SPACEs here, if I am using TE the config file; c:\winnt\my.ini everything is working just fine, TE however when I try to start the server from the command line it TE breaks. It can not work with spaces on the command line. The problem TE is you see that I have to get it wokring this way, as I would like TE to use, start up, mysql on the machine without beeing dependent on TE any other previous or current installations (no old my.ini for TE example). All the config files are located in any of three places, TE unfortunately that is rather difficult to handle with several mysql TE database running at the same time. So what I want is to be able to TE run several mysql servers completely independet from one another. TE Has anyone started the server without using the config files, TE straight from the command line using SPACES in the path to the main TE mysql directory. Yes, and it worked well: E:\ E:\Program Files\MySQL4.0.3\bin\mysqld-max-nt.exe --standalone --console 020916 15:57:47 InnoDB: Out of memory in additional memory pool. InnoDB: InnoDB will start allocating memory from the OS. InnoDB: You may get better performance if you configure a bigger InnoDB: value in the MySQL my.cnf file for InnoDB: innodb_additional_mem_pool_size. 020916 15:57:47 InnoDB: Started E:\Program Files\MySQL4.0.3\bin\mysqld-max-nt.exe: ready for connections -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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
Forgot Mysql-Root Password
Hi! I am using SuSE7.3 and mysqld Ver 3.23.41 for suse-linux What i did (http://www.mysql.com/doc/en/Resetting_permissions.html): # rcmysql stop # mysqld --skip-grant-tables Fatal error: Please read Security section of the manual to find out how to run mysqld as root! 020918 12:42:39 Aborting 020918 12:42:39 mysqld: Shutdown Complete How can i solve this Problem? I have alread reinstalled mysql, but unforunatelly i keeps its password. Cheers, 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
How to use Auto Increment
Hi All I am new to MY SQL . I am writing a script where I will have 2 insert statements The first insert is into a table which has an Auto_Increment field. I want to know the value which was inserted in this Auto_increment field and use it in the second INSERT statement. How can I do it in MySQL. Rajesh Kanade 8 Janapriya 34/1 Erandwane Pune 4 http://www.geocities.com/rrkanade - 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 is Crashing
Hi All I have written 2 scripts the first one which will ceate the schema and second one will insert some rows into it. The table type is BDB. Scripts are something like this SCRIPT 1 DROP TABLE IF EXISTS ROLE; DROP DATABASE IF EXISTS ERECRUITER; CREATE DATABASE ERECRUITER; #Start using eRecruiter database USE ERECRUITER; # Master table to hold all the roles and their descriptions CREATE TABLE ROLE ( ROLE_CODE VARCHAR(3) PRIMARY KEY, ROLE_DEFAULT_DESC VARCHAR( 100 ) NOT NULL, ROLE_DESC_KEY VARCHAR( 50 ) NULL ) TYPE=BDB ; SCRIPT 2 INSERT INTO ROLE( ROLE_CODE,ROLE_DEFAULT_DESC ,ROLE_DESC_KEY ) VALUES ( 'SPV','Supervisor' , NULL ); If I run these scripts together repeatedly everything seems to be fine. But after running these scripts If I goto mysql and then run a query like select * from role; then it shows me one row which is the right thing. I then exit from mysql and run my scripts one more time and this is when the mysqld-max-nt.exe crashes. The error message is C:\mysql\binmysql --host=localhost --user=erecruiter --password=erecruiter mysq l 0c:\eRecruiter\scripts\db.sql 1c:\temp\output.tab ERROR 1009 at line 28: Error dropping database (can't delete '.\erecruiter\address.db', errno: 4862976) I am using My SQL version 3.23.39 Max on Windows XP I have to reboot the machine to get MySQL running again. Please help. Rajesh Kanade 8 Janapriya 34/1 Erandwane Pune 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
Re: sum column in mysql
SELECT *,sum(Duration) as durationsum from table1 WHERE condition should work, Thomas On Wed, 18 Sep 2002 10:32:07 +0300 adi [EMAIL PROTECTED] wrote: Hi, I have a table table1, with a column Duration time type(ex 00:12:30) I want to make a sql selection: SELECT * from table1 WHERE condition, and after that, to make sum of values of column Duration and display it. Any Help? tx - 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 to use Auto Increment
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 | I am writing a script where I will have 2 insert statements | The first insert is into a table which has an Auto_Increment field. | I want to know the value which was inserted in this Auto_increment field and | use it in the second INSERT statement. | | How can I do it in MySQL. after inserting into the auto_increment table, do a 'SELECT LAST_INSERT_ID()' which will return the last autoincremented value. You can use this value in your second insert statement. danny - -- Danny Haworth =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Ge2 System Administrator Gas~Elec Safety Systems Tel : 01895 422 997 Email : [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED]) -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE9iGENUKf+497XC3QRAinfAJ0dgODNkRypaa/5D9R4VA8LAwoalQCfTwnm YOkwrvwm7ZWfvH8rwVhcDFc= =k+A3 -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL on Redhat 7.3
I followed the advice given but get these errors: If I use rpm -Uvh MySQL-3-23-52-1.i386 I get; error failed dependencies MySQL-server conflicts with mysql-server-3.23.49-3 followed by a list of dependencies on libmysqlclient.so.10 If I use rpm -Uvh MySQL*.rpm I get: error failed dependencies MySQL-server conflicts with mysql-server-3.23.49-3 MySQL-DBI-Perl-bin is needed by MySQL-bench-3.23.52-1 Do I need to deinstall all of the old rpms first or is there some form of force command I should use? Regards Peter Goggin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
urgent! connecton errors
We have build an ASP site in Delphi which heavy relay on a handfull of .dll files (Active Server Objects) Its actualy quite hard to define our problem, but I can say that our main problem is that on simultanius user-connections the dll's appeare to die, or they don't respond. This problem occours only when the application connects to MySql using the ZEOS components. Everthing runs on a win 2000 server, and we use the mysql components from Zeos Does anyone have a clue on what is happening ? Is mysql to blaim or perhaps i should look closer at the zeos components? Does anyone wanna share his/heres visdom ? thanks in advance KH - 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: determine value of auto-increment field after adding record - @ runtime
last_insert_id() - neal wrote: I have a table that will auto increment it's PK field upon adding a new record. I would like obtain that auto-increment value immedicately after the add of that record so that I may reference it within another table ... sort of an informal PK/FK relationship. In SQLServer I believe I recall there was a function something like @@ID to retrieve this value ... could be written directly into your SQL. What sort of function exists in mySQL for this purpose? Thanks. NEal - 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 has to know something on MySQLGUI?? - PLZ HLP!
hi ,if you're on windows I would use mysqlfront. It has been discontinued but you can still get it from: http://mysqlfront.sstienemann.de/ alternatively, you could use urSQL: http://www.urbanresearch.com/software/utils/urbsql/ cheers Rich David Kramer wrote: Can anyone point me in the direction of some good doc on MYSQLGUI for Win2K? Looking for Install/Setup notes.. Also is the Flash Light Tool Kit needed to run the GUI? Thanks, DK David Kramer Software Developer Reflect.com Direct: 415.369.4856 Cell: 650.302.7889 - 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 -- Richard Dobson Database Administrator MRC Bright Study Clinical Pharmacolgy St Bartholomew's and the Royal London School of Medicine and Dentistry Charterhouse Square London EC1M 6BQ Tel: 020-7882-5670 Mob: 07711-522926 Fax: 020-7882-5672 [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: Connect to Database over the Internet
Hi Bryan; First I would direct you to the MyODBC mailing list, as it is generally the place where we VB programmers converse. At any rate, you need MyODBC installed (check the products heading of the MySQL web site for the MyODBC download), and your connection string is wrong. I would detail it, but as I recently wrote an article that has an explanation of connection strings and a sample one, I will instead just make a shameless plug: check out www.dynamergy.com/mike/articles/blobaccessvb.html and you should find what you need. Mike Hillyer Dynamergy Software -Original Message- From: Bryan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 2:00 AM To: [EMAIL PROTECTED] Subject: Connect to Database over the Internet Hello All: I would appreciate some help on how to configure my application code or the computer which mysql resides on so it can be accesed over the intenet. Putting aside the obvious security concerns how can I achieve this. The application is written in VB using ADO to access the database. Currently this is the connect string I currently use to connect to the database. .ConnectionString = Data Source = REGIONAL;SERVER=xx.xx.xx.xxx;User ID = root; Password It works fine connecting to the database when run on the same computer which contains the MYSQL database. When I try the application from a remote computer configured it does not connect. No firewall is involved. I suspect I need to configure certain networking protocols on the host/ server machine, but am lost as to what I should be doing. The operating system is XP professional. Any suggestions. Thanks -=Bryan=- - 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: Forcing a sort order in a join
Did you try a straight join so MySQL won't swap the order of the tables? Philip Smolen wrote: Right. The simple example listed at the bottom of this message works great under version 4. Version 3 gave the right answer, but it was very slow. That made me upgrade to version 4. However, even with version 4, I run into the same problem as soon as I add a join. MySQL always wants to find an index to match the join conditions. If there isn't an appropriate index, it actually sorts the data to match join conditions! This is probably right in the general case, but it makes my query run very slowly. How can I make this run faster? SELECT * FROM huge_table,small_table WHERE huge_table.field2 = small_table.field2 ORDER BY huge_table.field1 DESC LIMIT 5; I want MySQL to use the index on huge_table.field1, just like it does when there is no join. - 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: Forgot Mysql-Root Password
On Wed, 18 Sep 2002, Mario Ohnewald wrote: Hi! I am using SuSE7.3 and mysqld Ver 3.23.41 for suse-linux What i did (http://www.mysql.com/doc/en/Resetting_permissions.html): # rcmysql stop # mysqld --skip-grant-tables Fatal error: Please read Security section of the manual to find out how to run mysqld as root! 020918 12:42:39 Aborting 020918 12:42:39 mysqld: Shutdown Complete How can i solve this Problem? I have alread reinstalled mysql, but unforunatelly i keeps its password. Cheers, Mario Mario, that error means that you cannot run the MySQL daemon/server AS root. It's a security issue, not a password issue. Try something like this: mysqld --skip-grant-tables --user=mysql or, if you don't have a user named mysql, create one and change the ownership of the mysql directory/files to mysql; OR, use the nobody user (a common replacement) mysqld --skip-grant-tables --user=nobody Regards, Neil Mansilla whatUseek.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: Japanese Characters in MySQL Win2k
Hi, I think Joel Rees wrote an interesting message as well. Hope you read it. I run MySQL on Windows, SuSE 7.3 (Linux) and FreeBSD. Access it through ASP/PHP/JSP/Perl DBI. There is no problem as far as I am concerned, it works without a hitch. If your default locale is EN, then you may see junk text in your MS DOS prompt but rest assured, it is most likely the correct data -- it just appears that way to you. Try dumping the same data onto a web page with the following META tags: %@ Language=VBScript % % ' Some OLEDB/ODBC code comes here ' to initialize a variable with your JP text % !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN html lang=ja head meta http-equiv=Content-Type content=text/html; charset=Shift_JIS /head body % Response.Write (-YOUR JP TEXT COMES HERE-) % /body /html That should do it. Cheers, Shanx Shashank Tripathi www.shanx.com | -Original Message- | From: Dawn Friedland [mailto:[EMAIL PROTECTED]] | Sent: Wednesday, September 18, 2002 7:46 AM | To: Shashank Tripathi; [EMAIL PROTECTED] | Subject: RE: Japanese Characters in MySQL Win2k | | | Thank you Thank you. | | Are you running MySQL on Windows and using ASP on the web | server? | | When I display the data after pulling it out, I use Shift_Jis. | | Yes, I mean the DOS prompt. My default language is | English. I fear changing my locale because I wouldn't be | able to change it back without a deepfry (I can't read | Japanese!) | | -Original Message- | From: Shashank Tripathi [mailto:[EMAIL PROTECTED]] | Sent: Tuesday, September 17, 2002 3:36 PM | To: Dawn Friedland; [EMAIL PROTECTED] | Subject: RE: Japanese Characters in MySQL Win2k | | | Storing JP and EN data in the same table has worked for | me ever since I started using MySQL. Unlike Oracle, you | don't need any specific charset configs (I may stand | corrected). The idea is to use the correct character | encodings when you *display* the data after pulling it | out. In your case, I'd think Shift_JIS. | | You mention displaying on the command line...u mean DOS | prompt? If not, and if you meant some software, it shd be | easy. If you meant DOS prompt, I guess it depends on what | the default language in your windows box is. Do you have | Japan set as your default locale and as the default | language (Regional Options in Control Panel)? If so, the | data shd display correctly without any additional effort. | | You can store EUC, Shift, ISO2022, and for that matter, | Chinese in the same table in diff rows as well. During | presentation time (display), just display using the | appropriate encoding and it shd be ok. | | Holler if you need more help. | | Cheers, | Shashank | | | | | | - 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: determine value of auto-increment field after adding record - @ runtime
neal, Wednesday, September 18, 2002, 11:17:49 AM, you wrote: n I have a table that will auto increment it's PK field upon adding a new n record. I would like obtain that auto-increment value immedicately after n the add of that record so that I may reference it within another table ... n sort of an informal PK/FK relationship. n In SQLServer I believe I recall there was a function something like @@ID to n retrieve this value ... could be written directly into your SQL. n What sort of function exists in mySQL for this purpose? Take a look at LAST_INSERT_ID(): http://www.mysql.com/doc/en/Miscellaneous_functions.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: date field - default value = current date
neal, Wednesday, September 18, 2002, 11:32:39 AM, you wrote: n Is there a wat to have mySQL auto fill in the current date into my n dateCreated field? n In SQLServer I would simply specify the getDate() method as a default value. n I presume I would use the analogous MySQL function curDate() but it does not n appear to work for me. You can't use function as a default value. May be TIMESTAMP column type is what you want, look at: http://www.mysql.com/doc/en/DATETIME.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Re: aggregate functions producing bad data
Jay, Tuesday, September 17, 2002, 10:45:51 PM, you wrote: J On my server the MySQL database decided to die on me. So I killed it and J restarted and that didn't work. So I just rebooted the machine. Now I'm J getting this error below. J Invalid SQL: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=1 J mysql error: Can't open file: 'privatemessage.MYD'. (errno: 145) J mysql error number: 1016 J Anyone know what is going on? 145 = Table was marked as crashed and should be repaired http://www.mysql.com/doc/en/Repair.html Repair table with myisamchk or REPAIR TABLE: http://www.mysql.com/doc/en/REPAIR_TABLE.html http://www.mysql.com/doc/en/myisamchk_repair_options.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: My Replication Story
Danny, Wednesday, September 18, 2002, 1:08:23 PM, you wrote: DH mysqld got signal 11; DH This could be because you hit a bug. It is also possible that this binary DH or one of the libraries it was linked against is corrupt, improperly built, DH or misconfigured. This error can also be caused by malfunctioning hardware. DH We will try our best to scrape up some info that will hopefully help DH diagnose DH the problem, but since we have already crashed, something is definitely DH wrong DH and this may fail. [skip] thd-query at 0x8728558 = SELECT DISTINCT job_headers.*, DH job_threads.access_timeslot, job_threads.access_c DH omments, job_threads.access_timeslot_details, DH job_threads.date_of_inspection, job_threads.access_type, job DH _threads.engineer_comments FROM job_headers, job_threads WHERE DH job_threads.jid_ptr=job_headers.jid AND cmp DH id=18874 thd-thread_id=1 [skip] As far as I remember there was found and fixed the similar bug in 4.0.3. Could you provide output of SHOW CREATE TABLE for testing? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Forgot mysql-root password
Mario, Wednesday, September 18, 2002, 1:50:25 PM, you wrote: MO I am using SuSE7.3 and mysqld Ver 3.23.41 for suse-linux MO What i did (http://www.mysql.com/doc/en/Resetting_permissions.html): MO # rcmysql stop MO # mysqld --skip-grant-tables MO Fatal error: Please read Security section of the manual to find out how to MO run mysqld as root! MO 020918 12:42:39 Aborting MO 020918 12:42:39 mysqld: Shutdown Complete MO How can i solve this Problem? I have alread reinstalled mysql, but MO unforunatelly i keeps its password. run safe_mysqld --skip-grant-tables instead of mysqld. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Forgot mysql-root password
mysqld --user=mysql --skip-grant-tables Mario Ohnewald wrote: Hi! I am using SuSE7.3 and mysqld Ver 3.23.41 for suse-linux What i did (http://www.mysql.com/doc/en/Resetting_permissions.html): # rcmysql stop # mysqld --skip-grant-tables Fatal error: Please read Security section of the manual to find out how to run mysqld as root! 020918 12:42:39 Aborting 020918 12:42:39 mysqld: Shutdown Complete How can i solve this Problem? I have alread reinstalled mysql, but unforunatelly i keeps its password. Cheers, 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 - 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: Marketing materials ??
Hi Yuri, Money talks. Point out that MySQL is an open source initiative and can save them money. As for knowing another product, such as MS-SQL, being a deciding factor; it really isn't an issue. All databases, at their core functionality, are the same. The same rules of database design apply to all databases. There is a SQL standard that all databases conform to (to varying degrees). All backups, etc. still need to done regardless of the database. In fact, the only real differentiator that management should worry about is scalability. If your management is worried about thousands of simultaneous requests (i.e. 25,000) than I would suggest you look at an Oracle solution. John -Original Message- From: Yuri [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 5:36 PM To: [EMAIL PROTECTED] Subject: Marketing materials ?? Hi, I may get in position to protect my choice of MySQL being confronted by completely non-technical management. Management is likely to argue in favor of MSSQL (nice GUI, many people who know it, they are used to it, you can do any project on any DB, blah blah blah). All this crap. Anyone has web references to different DB servers comparison (performance/feature-rich /other...)? Marketing materials/diagrams/tables that would be able to convince non-tech guys that MySQL is superior to MSSQL? Selling points (like ease of administration, high performance, robustness of SQL language, cross platform-nnes) ? Any other considerations. I mean I know by heart that MySQL is better but management has totally different mindset. So any such convincing information will be GREATLY appreciated )) Yuri. - 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: Forgot Mysql-Root Password
How can i solve this Problem? I have alread reinstalled mysql, but unforunatelly i keeps its password. Reinstall will only work if you remove the database containing the passwords and users (mysql). Personally I would prefer the way suggested in the manual. 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: Forgot mysql-root password
AH..thx a lot everybody! -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED]] Sent: Mittwoch, 18. September 2002 15:34 To: [EMAIL PROTECTED] Subject: re: Forgot mysql-root password Mario, Wednesday, September 18, 2002, 1:50:25 PM, you wrote: MO I am using SuSE7.3 and mysqld Ver 3.23.41 for suse-linux MO What i did (http://www.mysql.com/doc/en/Resetting_permissions.html): MO # rcmysql stop MO # mysqld --skip-grant-tables MO Fatal error: Please read Security section of the manual to find out how to MO run mysqld as root! MO 020918 12:42:39 Aborting MO 020918 12:42:39 mysqld: Shutdown Complete MO How can i solve this Problem? I have alread reinstalled mysql, but MO unforunatelly i keeps its password. run safe_mysqld --skip-grant-tables instead of mysqld. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 to use Auto Increment
On Wed, 18 Sep 2002, Rajesh Kanade wrote: Hi All I am new to MY SQL . I am writing a script where I will have 2 insert statements The first insert is into a table which has an Auto_Increment field. I want to know the value which was inserted in this Auto_increment field and use it in the second INSERT statement. How can I do it in MySQL. Rajesh, if you wish to pull the value of the last AUTO_INCREMENT issued, use this query: SELECT LAST_INSERT_ID(); The second INSERT statement really shouldn't need the value of the last AUTO_INCREMENT issued, since it should just get the next number in sequence, well, automatically. For example: Table schema: id INT UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(100) NOT NULL, primary key (id) INSERT INTO Table VALUES (null,'Neil'); INSERT INTO Table VALUES (null,'Rajesh'); If these were the first two records, the two rows would look like this: 1 | Neil 2 | Rajesh Regards, Neil Mansilla whatUseek.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
Output of DESCRIBE tbl_name wrong for unique key on NULL column
Description: The output of DESCRIBE tbl_name shows unique keys to be MUL for columns defined as NULL. The SQL shown is a minimal test case that creates a new database and two tables, both with a unique key on the column uni The first table is fine. The second table bug shows the wrong output for EXPLAIN bug, the index on the second column is shown to be non-unique. The only difference between the tables is whether the second column is defined to be NULL or NOT NULL. The result is exactly the same if the column type is VARCHAR, not INT. Version 3.23.32 shows UNI in both cases, as I expect to see. Version 3.23.49 shows the wrong output, as described in this bug report. If this is actually the correct output, because a NULL column with a UNIQUE key can contain multiple NULL values, then ignore this bug. Instead the manual needs to be fixed to explain the output of this command. Currently the manual contains circular references for EXPLAIN tbl_name, DESCRIBE tbl_name and SHOW COLUMNS FROM tbl_name, none of the relevant sections explain the output, they just refer you to one of the other sections (I'll be raising this as a separate issue anyway). How-To-Repeat: CREATE DATABASE test_bug; USE test_bug; CREATE TABLE `not_bug` ( `id` int NOT NULL default '0', `uni` int NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `uni` (`uni`) ) TYPE=MyISAM; CREATE TABLE `bug` ( `id` int NOT NULL default '0', `uni` int, PRIMARY KEY (`id`), UNIQUE KEY `uni` (`uni`) ) TYPE=MyISAM; EXPLAIN not_bug; EXPLAIN bug; Fix: Submitter-Id: submitter ID Originator:Jonathan Wakely Organization: Mintel International Group Ltd. MySQL support: none Synopsis: Output of DESCRIBE tbl_name wrong for unique key on NULL column Severity: non-critical Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.42 (Source distribution) Server: /usr/local/bin/mysqladmin Ver 8.21 Distrib 3.23.42, for -freebsd4.4 on i386 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.42 Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 20 hours 12 min 29 sec Threads: 129 Questions: 2394902 Slow queries: 18 Opens: 1701 Flush tables: 1 Open tables: 295 Queries per second avg: 32.920 Environment: System: FreeBSD juliet.mintel.co.uk 4.4-RELEASE FreeBSD 4.4-RELEASE #2: Fri Jan 11 11:38:03 GMT 2002 [EMAIL PROTECTED]:/usr/src/sys/compile/JULIET 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.3 20010315 (release) [FreeBSD] Compilation info: CC='cc' CFLAGS='-O -pipe ' CXX='c++' CXXFLAGS='-O -pipe -felide-constructors -fno-rtti -fno-exceptions' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1205382 Sep 18 2001 /usr/lib/libc.a lrwxrwxrwx 1 root wheel 9 Oct 4 2001 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 572876 Sep 18 2001 /usr/lib/libc.so.4 Configure command: ./configure --localstatedir=/var/db/mysql --without-perl --without-debug --without-readline --without-bench --with-mit-threads=no --with-libwrap --with-low-memory --enable-assembler --with-berkeley-db --prefix=/usr/local i386--freebsd4.4 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
Manual doesn't describe output of DESCRIBE tbl_name
Description: Currently the manual contains circular references for EXPLAIN tbl_name, DESCRIBE tbl_name and SHOW COLUMNS FROM tbl_name. None of the relevant sections explains the output, they just refer you to one of the other sections. If the output of this command *is* described somewhere, it's well hidden, as it can't easily be found from the TOC or by following the links in any of the related sections. How-To-Repeat: Look in the manual and try to find what MUL means in this table: +---+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-+---+ | id| int(11) | | PRI | 0 | | | variant_type_id | int(11) | YES | MUL | NULL| | | variant_type_name | varchar(64) | YES | MUL | NULL| | | sql_statement | mediumtext | YES | | NULL| | +---+-+--+-+-+---+ Fix: Submitter-Id: submitter ID Originator:Jonathan Wakely Organization: Mintel International Group Ltd. MySQL support: none Synopsis: Manual doesn't describe output of DESCRIBE tbl_name Severity: non-critical Priority: low Category: mysql Class: doc-bug Release: mysql-3.23.42 (Source distribution) Server: /usr/local/bin/mysqladmin Ver 8.21 Distrib 3.23.42, for -freebsd4.4 on i386 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.42 Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 21 hours 43 min 5 sec Threads: 130 Questions: 2398355 Slow queries: 18 Opens: 1838 Flush tables: 1 Open tables: 297 Queries per second avg: 30.675 Environment: System: FreeBSD juliet.mintel.co.uk 4.4-RELEASE FreeBSD 4.4-RELEASE #2: Fri Jan 11 11:38:03 GMT 2002 [EMAIL PROTECTED]:/usr/src/sys/compile/JULIET 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.3 20010315 (release) [FreeBSD] Compilation info: CC='cc' CFLAGS='-O -pipe ' CXX='c++' CXXFLAGS='-O -pipe -felide-constructors -fno-rtti -fno-exceptions' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1205382 Sep 18 2001 /usr/lib/libc.a lrwxrwxrwx 1 root wheel 9 Oct 4 2001 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 572876 Sep 18 2001 /usr/lib/libc.so.4 Configure command: ./configure --localstatedir=/var/db/mysql --without-perl --without-debug --without-readline --without-bench --with-mit-threads=no --with-libwrap --with-low-memory --enable-assembler --with-berkeley-db --prefix=/usr/local i386--freebsd4.4 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
win32 and security
Hah!! Wondering if anyone could tell me of any MySQL specific security vulnerabilities on win32? Thanks, 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
mysql LIKE number
I have a table with column1 text type. I want to make a sql query: SELECT * from table WHERE column1 LIKE condition, to select all record that contain numbers(0..9), and do not select records that contain only text. Any ideas? tx in advance - 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 LIKE number
adi wrote: I have a table with column1 text type. I want to make a sql query: SELECT * from table WHERE column1 LIKE condition, to select all record that contain numbers(0..9), and do not select records that contain only text. Any ideas? tx in advance column1 REGEXP [0-9] -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de - 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: My Replication Story
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Victoria Reznichenko wrote: | As far as I remember there was found and fixed the similar bug in | 4.0.3. Could you provide output of SHOW CREATE TABLE for testing? Hi Victoria, When you say 'SHOW CREATE TABLE' I assume you mean during the creation of the temporary table (SHOW CREATE TEMPORARY TABLE)? In which case mysql politely informs me that i have an error in my SQL syntax ;-) I cant afford to take down the master database since it is in use round the clock but i have upgraded the slave server to 4.0.3 with an identical copy of the data restored from dds. I was unable to reproduce the problem either, probably because the database wasn't under load just merely hosting my single connection. Strangely this is the same behaviour I got from the main database after its upgrade, worked fine with 2-3 connections but started jumpin' under real load. I know this probably isn't of much use to you, i'll try writing up a few perl scripts to create some virtual load and see what happens then. If there's anything else i can provide for you to help trace this bug down. let me know. danny - -- Danny Haworth =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Ge2 System Administrator Gas~Elec Safety Systems Tel : 01895 422 997 Email : [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED]) -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE9iJstUKf+497XC3QRAneNAJ996eZ7vYchyQ/VTffyvgPP4WZklACeOi6b o2M29ZjPj7bBHt0kC8amLQI= =aXgE -END PGP SIGNATURE- - 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
Update database from different hosts
I must update the same table in two databases from differents remote host es: DatabaseA:tableA DatabaseB:tableA how can do ? Without using mysqldump if possible... - 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: 4.6.3 Adding a New Character Set
Hi, Can anybody tell me source for getting information on 4.6.3 Adding a New Character Set in MySQL. I read the manual, it's not clear to me. The steps there does not give enough information to start. Thanks, Bhushan. - 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
optimizer bug in selecting fields that don´t belong to the index used by mysql/innodb
Hi! rafarife == rafarife [EMAIL PROTECTED] writes: rafarife Description: rafarife Hi Heikki, rafarife I'm Lourdes and I work with Rafa in the MySQL project. rafarife We have done what you have told us. We have run SHOW STATUS before rafarife the query and we have obtained the next result: cut Handler_read_next = 0 cut rafarife Handler_read_next = 1929 The above shows that MySQL had to read 1929 rows to satsify the query. rafarife After doing this, we decided to create a new table like in your example with rafarife the same records. Then, we execute the query: cut rafarife The table definition is: rafarife CREATE TABLE `clientes` ( cut In cases like this that are data dependent, it's not enough for us to have the create table definition, we also need the data itself. rafarife How-To-Repeat: rafarifeSelect Cod,Nom,Nif,Nombre_comercial from Clientes Where (Nom = 'GARCIA MANCILLA,S.L' And Cod'061642') rafarife Or Nom'GARCIA MANCILLA,S.L' Order by Nom ASC, Cod ASC Limit 50; To be able to find and fix the problem, we would need a copy the tables involved used by your query. Can you please do the following: - Make a mysqldump of your tables and make a README file of the above. - Tar and gzip or zip the files. - ftp the file to ftp://www.tcx.se/pub/mysql/secrent - Send an email to [EMAIL PROTECTED] that you have uploaded a test case. If you can do the above, we will try to fix the problem for next MySQL release. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ 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
Updating a slave db not within the firewall
Hello, I would like to update my slave mysql server which is not within the firewall, however, the master is. Is there anyway I can do it without opening mysql port in the firewall. In other words, is there anyway I can make my master update the slave without slave initiating the request? Thanks Akta - 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
user defined functions under windows
I am trying to create a user-defined function for mysql. I am using a windows binary version of mysql and visual c++ to compile the code. I have created a dummy function call func_test that just returns 1.0. I compile this within a win32 dll project and get a file called funcdll.dll. This is basically the contents of the file: double func_test() { return 1.0; } I have placed the dll the bin dir and call mysql create function func_test returns real soname funcdll.dll; ERROR 1127: Can't find function 'func_test' in library' I assume it can find the dll but cannot find the function. Any clues, examples for windows using visual c++. The examples in the manual all refer to linux and i presume versions of mysql compiled from source as they describe folders that i dont have in my version, and i am not making any progess. thanks Paul Paul Grimwood IT Innovation Centre 2 Venture Road Chilworth Science Park Southampton SO16 7NP Tel: +44 23 8076 0834 Fax: +44 23 8076 0833 mailto:[EMAIL PROTECTED] http://www.it-innovation.soton.ac.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
Problem with install on Sun sparc solaris OS 5.8
Installed version 3.23.45 from a package on sunfreeware.com Installation was successful. Having a problem creating the priv tables and starting the myslqd server. When I try to run ./scripts/mysql_install_db, the script prepares all the tables, then dies when it is in the process of installing the tables. Error ld.so.1: /usr/local/mysql/libexec/mysqld: fatal: libstdc++.so.3: open failed: no such file or directory Killed Installation of grant tables failed! -- Greg Johnston Office 612-313-1286 Cell 917-617-4278 -- - 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
anyone using OS X server and publishing mySQL?
I'm considering moving a mySQL dbase off an expensive ISP and in-house to host ourselves on OSX Server. Has anyone tried this? Any advice or warnings? Thanks! -Bill - 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: Output of DESCRIBE tbl_name wrong for unique key on NULL column
jwakely, Wednesday, September 18, 2002, 5:46:19 PM, you wrote: jamdc The output of DESCRIBE tbl_name shows unique keys to be MUL for columns jamdc defined as NULL. jamdc The SQL shown is a minimal test case that creates a new database and two jamdc tables, both with a unique key on the column uni jamdc The first table is fine. jamdc The second table bug shows the wrong output for EXPLAIN bug, jamdc the index on the second column is shown to be non-unique. jamdc The only difference between the tables is whether the second column jamdc is defined to be NULL or NOT NULL. jamdc The result is exactly the same if the column type is VARCHAR, not INT. jamdc Version 3.23.32 shows UNI in both cases, as I expect to see. jamdc Version 3.23.49 shows the wrong output, as described in this bug report. jamdc If this is actually the correct output, because a NULL column with a jamdc UNIQUE key can contain multiple NULL values, then ignore this bug. jamdc Instead the manual needs to be fixed to explain the output of this command. jamdc Currently the manual contains circular references for EXPLAIN tbl_name, jamdc DESCRIBE tbl_name and SHOW COLUMNS FROM tbl_name, none of the relevant jamdc sections explain the output, they just refer you to one of the other jamdc sections (I'll be raising this as a separate issue anyway). It's a correct output, bacause MUL means that column can contain same value(s) multiple times (in your case it's a NULL value). -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: MySQL is Crashing
Rajesh, Wednesday, September 18, 2002, 9:32:29 AM, you wrote: RK I have written 2 scripts the first one which will ceate the schema and RK second one will insert some rows into it. RK The table type is BDB. RK Scripts are something like this [skip] RK If I run these scripts together repeatedly everything seems to be fine. RK But after running these scripts If I goto mysql and then run a query like RK select * from role; RK then it shows me one row which is the right thing. I then exit from mysql RK and run my scripts one more time and this is when the mysqld-max-nt.exe RK crashes. RK The error message is C:\mysql\binmysql --host=localhost --user=erecruiter --password=erecruiter RK mysql RK 0c:\eRecruiter\scripts\db.sql 1c:\temp\output.tab RK ERROR 1009 at line 28: Error dropping database (can't delete RK '.\erecruiter\address.db', errno: 4862976) RK I am using My SQL version 3.23.39 Max on Windows XP RK I have to reboot the machine to get MySQL running again. I tested it on 3.23.52 and didn't get any error. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can't Connect From Script
I've got a weird conundrum here that I'm hoping I can get some help on. I'm attempting to install a chat board system called Ikonboard (www.ikonboard.com) with MySQL as the database; setup on it went smoothly until it tried to talk to the database. No matter what I do, I get: mySQL connection error: Access denied for user: 'alex@localhost' (Using password: YES) This is despite several things that would indicate I should have no trouble: 1. I can connect from a shell with the same username and password no problem. 2. I've quadruple-checked the spelling of the username and password, so it's not a typo. 3. I can connect to the database from a test script with the same username and password. The only reason I can think of that the installer program can't connect is because it's a web script (installer.cgi), and some sort of permissions might be wrong there. Any ideas? Alex Kirk - 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: 'strend' function in libmysql needs to be private
I was about to email bugs/lists back today to basically say I've found a reasonable workaround.. I'll respond to your message though in case you see something that needs attention ... strend() is a function we use a lot in the MySQL client code and is thus included in the libmysqlclient library. Yeah I've come to realize this .. the 'mysql' client binary started complaining about not finding strend :-) I can't see how csh could affect this in any way as csh doesn't have anything directly to do with shared libraries. (Except of course if you are trying to load a shared library inside csh).using a patched csh I'm writing an NSS library, so when csh does ~username expansion, calling getpwnam, the system automatically loads my library in order to find the user in MySQL. csh itself has nothing to do with loading the library. Which public library is it that has a conflicting function ? (I have used Solaris a lot and never seen this problem before) I don't know, actually. I haven't been able to find it since everything's stripped and whatnot. I may just not be using the right tools to find it. I tried running nm/ldd to find it to no avail. What is it that core dumps; csh or your application ? Does your application work if you are running 'sh' ? The error happens inside the MySQL client library (since the library starts using the wrong 'strend'), filtering back down to 'csh' which then dumps. tcsh, bash, etc work fine.. it's only csh. I've managed to get around the problem by linking my library with '-B group' in order to keep the symbols from leaking around where they shouldn't be. I found that there were other symbols being stomped on, too .. so it wasn't just 'strend' anymore .. so my workaround seems the best choice.. and I guess we can consider the matter resolved... Thanks! -=| Ben - 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
Server shutdown
Hi all, I am completely new to MySQL. I installed the source version of MySQL on Solaris 2.8. I did mysql_install_db. I started the server by saying bin/safe_mysqld --user=mysql . The server started my creating mysql.sock file in the /tmp directory. Now i want to stop the server. How should i do it? I did bin/mysqladmin -u mysql shutdown The error message that came up was: ** /home/shravan/extra/mysql/bin/mysqladmin: shutdown failed; error: 'Access denied for user: '@localhost' (Using password: NO)' ** I also tried bin/mysqladmin -u root shutdown and also bin/mysqladmin -u shravan shutdown. But i could not get the server down. Could anyone please help? Best Regards and thanks in advance, skd __ Do you Yahoo!? Yahoo! News - Today's headlines http://news.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
installin mysql on win 2000
I will begining to install mysql on my server in a few days. I have never done this before. Is there anything i need to know, any problems mysql has with 2000 server? Any help is appreciated. Ryan - 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: Server shutdown
if all fails try killall mysqld after that you can do an lsof -i :mysql_port to see if it is still running, you have to have lsof package installed dont know if you have it by default on solaris ..never used solaris b4 :) ma 2cents cheers David Ziggy Lubowa Network Administrator One2net (U) web: www.one2net.co.ug Tel: +256 41 345466 -Original Message- From: Shravan Durvasula [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 10:17 PM To: MySQL HELP Subject: Server shutdown Hi all, I am completely new to MySQL. I installed the source version of MySQL on Solaris 2.8. I did mysql_install_db. I started the server by saying bin/safe_mysqld --user=mysql . The server started my creating mysql.sock file in the /tmp directory. Now i want to stop the server. How should i do it? I did bin/mysqladmin -u mysql shutdown The error message that came up was: ** /home/shravan/extra/mysql/bin/mysqladmin: shutdown failed; error: 'Access denied for user: '@localhost' (Using password: NO)' ** I also tried bin/mysqladmin -u root shutdown and also bin/mysqladmin -u shravan shutdown. But i could not get the server down. Could anyone please help? Best Regards and thanks in advance, skd __ Do you Yahoo!? Yahoo! News - Today's headlines http://news.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Server shutdown
I tell you that there is a simple script under whatever/mysql/share/ that is called mysql.sever and it manages the mysql server in a very fashionable way: simply type mysql.server start or mysql.server stop. I use the script to launch the server when my linux box starts. Another posibility is to use the kill command: just type ps -aux | grep mysqld and then kill -TERM and the last of the processes ID I hope this can help you to get into the fascinating world of MySQL. Leonardo Javier Belen. AFIP-AR - Original Message - From: Shravan Durvasula [EMAIL PROTECTED] To: MySQL HELP [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 4:17 PM Subject: Server shutdown Hi all, I am completely new to MySQL. I installed the source version of MySQL on Solaris 2.8. I did mysql_install_db. I started the server by saying bin/safe_mysqld --user=mysql . The server started my creating mysql.sock file in the /tmp directory. Now i want to stop the server. How should i do it? I did bin/mysqladmin -u mysql shutdown The error message that came up was: ** /home/shravan/extra/mysql/bin/mysqladmin: shutdown failed; error: 'Access denied for user: '@localhost' (Using password: NO)' ** I also tried bin/mysqladmin -u root shutdown and also bin/mysqladmin -u shravan shutdown. But i could not get the server down. Could anyone please help? Best Regards and thanks in advance, skd __ Do you Yahoo!? Yahoo! News - Today's headlines http://news.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
About browscap
Hi, Finally, I installed mysql and php successfully. The mysql commands line run well and phpinfo(); gives me information. To do a test to run with php script, I wrote the following script in test.php: *** Beginning *** ?php #Le serveur auquel l'utilisateur peut accéder; $host=localhost; # Nom de l'utilisateur; $user=root; #Mot de passe de connexion; $password=; mysql_connect($host,$user,$password); mysql_select_db(mysql); $requete='select * from mysql.user'; $resultat=mysql_query($requete); mysql_fetch_row($resultat); ? *** End *** Can you help me resolve the error message below? Think you in advance! Error message after running test.php: PHP: Error parsing c:\inetpub\wwwroot\browscap.ini on line 8206 Cannot find module (IP-MIB): At line 0 in (none) Cannot find module (IF-MIB): At line 0 in (none) Cannot find module (TCP-MIB): At line 0 in (none) Cannot find module (UDP-MIB): At line 0 in (none) Cannot find module (SNMPv2-MIB): At line 0 in (none) Cannot find module (SNMPv2-SMI): At line 0 in (none) Cannot find module (UCD-SNMP-MIB): At line 0 in (none) Cannot find module (UCD-DEMO-MIB): At line 0 in (none) Cannot find module (SNMP-TARGET-MIB): At line 0 in (none) Cannot find module (SNMP-VIEW-BASED-ACM-MIB): At line 0 in (none) Cannot find module (SNMP-COMMUNITY-MIB): At line 0 in (none) Cannot find module (UCD-DLMOD-MIB): At line 0 in (none) Cannot find module (SNMP-FRAMEWORK-MIB): At line 0 in (none) Cannot find module (SNMP-MPD-MIB): At line 0 in (none) Cannot find module (SNMP-USER-BASED-SM-MIB): At line 0 in (none) Cannot find module (SNMP-NOTIFICATION-MIB): At line 0 in (none) Cannot find module (SNMPv2-TM): At line 0 in (none) - 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: installin mysql on win 2000
I have it installed on my w2k w/sp3 server and I don't have any problems with it. -Original Message- From: Ryan Cavanaugh [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 3:23 PM To: [EMAIL PROTECTED] Subject: installin mysql on win 2000 I will begining to install mysql on my server in a few days. I have never done this before. Is there anything i need to know, any problems mysql has with 2000 server? Any help is appreciated. Ryan - 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: installin mysql on win 2000
Hello Ryan, No real problems with Windows 2000 Server and Adv. Server. Install SP3 before MySQL as the SP installation might remove the MySQL service registration in some cases. The setup process itself is an extremely straightforward one, taking just two or three minutes. The manual has good information on how to install MySQL as a service and whether to choose MAX or normal version for regular use etc. etc. You might want to use phpMyAdmin to administer your MySQL server (if you have a PHP/Apache box available). Another good (although discontinued) frontend is MySQLFront. phpMyAdmin has the advantage that you don't need a Windows box to work with it, any computer with a browser is sufficient. Best regards, Iikka On Wed, 18 Sep 2002, Ryan Cavanaugh wrote: I will begining to install mysql on my server in a few days. I have never done this before. Is there anything i need to know, any problems mysql has with 2000 server? Any help is appreciated. Ryan - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: anyone using OS X server and publishing mySQL?
I'm not running on OSX Server, but I am running on regular OSX without any problems. I just downloaded v4 of MySQL and am trying to play with it on my laptop. I'm getting path errors when trying to run it, but I haven't played with it much yet. You can download v3 from www.entropy.ch, which has step by step instructions on setting it up. I don't have any advice or warnings since I didn't have any problems setting it up. On Wednesday, September 18, 2002, at 02:07 PM, Bill Reynolds wrote: I'm considering moving a mySQL dbase off an expensive ISP and in-house to host ourselves on OSX Server. Has anyone tried this? Any advice or warnings? Thanks! -Bill - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 - 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
Queries Per Second
Hi All; Is there any way to get a real time queries per second in MySQL as opposed to the average given when I request the server status? Mike - 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: Queries Per Second
At 14:00 -0600 9/18/02, Mike Hillyer wrote: Hi All; Is there any way to get a real time queries per second in MySQL as opposed to the average given when I request the server status? real time defined how, exactly? Mike - 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
myODBC 3.51 and OpenOffice1.0.0 doesn't work together.
I tried to use myODBC 3.51 to connect OpenOffice1.0.0 to my MySQL db on my 'Debian GNU/Linux Sarge' machine. I was able to view tables and addbut I wasn't able to add new records. I installed the 'stable' version of the myODBC driver and then it worked. (Same options/programs other myODBC version) Daniel van Eeden [EMAIL PROTECTED] -- +-+ | Daniel van Eeden [EMAIL PROTECTED] | | icq: 36952189 | | aim: Compukid128| | msn: [EMAIL PROTECTED]| | phone: +31 343 522622 | | http://www.driebergenweb.org/about_me.html | +-+ - 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: Queries Per Second
In the last episode (Sep 18), Mike Hillyer said: Hi All; Is there any way to get a real time queries per second in MySQL as opposed to the average given when I request the server status? Request status twice, with a 1-second delay in between. -- Dan Nelson [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: Queries Per Second
From: Mike Hillyer MH Is there any way to get a real time queries per second in MySQL as MH opposed to the average given when I request the server status? From: Dan Nelson DN Request status twice, with a 1-second delay in between. I think what Mike is looking for is an average across a time period when queries are actually being run. If we let the server sit idle all day, then the average isn't very useful. Mike, Are you looking for benchmark data, or statistics on your setup? --- Rodney Broom President, R.Broom Consulting http://www.rbroom.com/ - sql spam - 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: Thanks to MySql and it's Developers
I can only think that's because you haven't used a Windows system. My principal client's Windows system has been up for over a year. Win2K Server. I brought the server down a couple of times to update table structures etc., but the OS has never failed us. Not once. Arthur - Original Message - From: Terence [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, September 15, 2002 9:38 PM Subject: Thanks to MySql and it's Developers To MySql AB and it's developers, I am from Sunway College in Malaysia, and we implemented MySql about a year and a half ago. It was a shift from Access. Since then we have never looked back. MySql runs our intranet (4-5000 hits per day), our website (2000-6000 hits per day), our hostel booking and reservations system, HRMS systems and a host of others. Today we reached 100days uptime, thanks to your excellent product. Uptime: 8693908 Threads: 18 Questions: 102664100 Slow queries: 543 Opens: 110507 Flush tables: 1 Open tables: 64 Queries per second avg: 11.809 OS: Redhat Linux 7.3 (Couldn't imagine 100 days on a windblows system) MySql: 3.23.49a-log Thanks guys! Rgds Terence Web Developer Sunway College - Original Message - From: Miguel Angel Solórzano [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, September 16, 2002 7:07 AM Subject: Re: mysql-max-4.0.3beta on win98. mysqld-max.exe just hangs! At 21:56 15/9/2002 +0300, Heikki Tuuri wrote: Hi, Heikki, The problem here seem to me that the InnoDB keys set are under the Winmysqladmin section instead of [mysqld]!. Hi! - Original Message - From: [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Sunday, September 15, 2002 3:33 PM Subject: mysql-max-4.0.3beta on win98. mysqld-max.exe just hangs! Hi, I want to use InnoDB but on my win98 using binary mysql-max-4.0.3beta the mysqld-max.exe just hangs. no output. I have read the entire Manual for install InnoDB table type instructions. set up my.ini as follows.. #---start of my.ini [WinMySQLAdmin] Server=C:/MYSQL4/bin/mysqld-max.exe innodb_data_home_dir=C:/MYSQL4/data innodb_data_file_path=C:/MYSQL4/data/ibdata/ibdata1:100M:autoextend:max:100 0 M #---end on my.ini I have also tried with [mysqld] starting from the command promt. no use. but mysqld.exe as well as mysqld-opt.exe both work fine. Except that i want InoDB. any help is much appreciated. Thanks in advance. it would help if some Windows 98 user who has this problem would compile MySQL from source using the Microsoft Visual C++. It is relatively easy. The main thing is to got to the subdir \mysql\strings\noMASM and copy the files there to the parent directory \mysql\strings. Use the Developer Studio or whatever it is called nowadays and open the workspace mysql.dsw in the \mysql directory. Then build all. You will get dfifferent mysqld.exe's to \mysql\client_release and \mysql\client_debug. Run mysqld-max.exe inside the Dev Studio debugger and look where it hangs. A MySQL AB employee reported that SHOW INNODB STATUS crashed in 3.23.52 and Win 98 + Netware. When we find out what is the problem there, that might help other Win 98 users. I have the impression that Microsoft never got 95/98/ME very stable. Using NT/2000/XP is recommended. NT and XP are rock-solid in my own experience. Kale Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com sql query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ São Paulo - Brazil ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail
Creating new users
Hi all, I have MySQL server installed in Solaris 2.8. 1. How can i change the existing password for a user? 2. How can i delete an existing user? 3. How can i create a new user and associate a password for that new user? Could anyone please help? Best regards and thanks in advance, -skd __ Do you Yahoo!? Yahoo! News - Today's headlines http://news.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
OT? mysql_init error w/ perl
Hello, I'm sorry for posting this here. I tried the msql-mysql-modules list but mine was the only message posted within the past few days, so I doubt I'll be getting any help :) I am getting the following error while trying to run a perl script to access some information. DBD::mysql seems to have installed properly. The script is very simple, just to query for a COUNT in a small table. Can anyone tell me how to fix this? Thanks in advance, Bryan /usr/bin/perl: error while loading shared libraries: /usr/lib/perl5/site_perl/i386-linux/auto/DBD/mysql/mysql.so: undefined symbol: mysql_init - 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: Queries Per Second
On Wed, Sep 18, 2002 at 02:00:54PM -0600, Mike Hillyer wrote: Hi All; Is there any way to get a real time queries per second in MySQL as opposed to the average given when I request the server status? Use mytop: http://jeremy.zawodny.com/mysql/mytop/ That's partly what I wrote it to do. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 43 days, processed 914,065,893 queries (242/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Creating new users
On Wed, 18 Sep 2002, Shravan Durvasula wrote: |Hi all, |I have MySQL server installed in Solaris 2.8. |1. How can i change the existing password for a user? |2. How can i delete an existing user? |3. How can i create a new user and associate a |password for that new user? I believe the documentation (below the tutorial portion) tells exactly how to do all of this. I am new to MySQL, and use this all the time. Well, trying to use it less and less :) http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#User_Account_Management (watch the wrap) Bryan - 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: Marketing materials ??
On Wed, Sep 18, 2002 at 10:15:05AM -0400, John Griffin wrote: Hi Yuri, Money talks. Point out that MySQL is an open source initiative and can save them money. As for knowing another product, such as MS-SQL, being a deciding factor; it really isn't an issue. All databases, at their core functionality, are the same. The same rules of database design apply to all databases. There is a SQL standard that all databases conform to (to varying degrees). All backups, etc. still need to done regardless of the database. In fact, the only real differentiator that management should worry about is scalability. If your management is worried about thousands of simultaneous requests (i.e. 25,000) than I would suggest you look at an Oracle solution. You lost me on that last part. The hardware required to make Oracle handle 25,000 connections efficiently is FAR more expensive than for MySQL. Money talks, right? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 43 days, processed 914,113,484 queries (242/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
count function issue
Doing queries to determine the number of times search terms are used on a web site. Here is a sample sql query. SELECT terms, count(*) AS count FROM searches GROUP BY terms HAVING count(*)1 ORDER BY count DESC But the results seem to be inaccurate, by no more that 3. Anyone run into anything like this before? - 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: Connect to Database over the Internet
Thanks for the reply: The only entry in the .ini file is Server=C:/mysql/bin/mysqld-max-nt.exe I did a telnet xx.xx.xx.xxx 3306 from the remote computer and the conection went through so my computer is accepting from port 3306 This is a dump from SELECT * FROM mysql.user. Does it look right?. I really can't tell if only localhosts have access? Thanks again -+---++-++-- --+ | 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 | +---+--+--+-+-+- +-+-+---+-+---+- -+---++-++-- --+ | localhost | root | 03f2916825e4a59a | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | % | root | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | localhost | | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | % | | | N | N | N | N | N | N | N | N | N | N | N | N | N | N | +---+--+--+-+-+- +-+-+---+-+---+- -+---++-++-- --+ 4 rows in set (0.01 sec) -=Bryan=- -Original Message- From: Jindo [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 1:49 AM To: 'Bryan'; [EMAIL PROTECTED] Subject: RE: Connect to Database over the Internet Bryan, Hi! Did you specify --skip-networking in my.cnf? Check if MySQL is listening on port 3306 (or the port you specified) for TCP connections. Also, I highly suspect that you forgot to set the proper privilege for connections made from hosts other than localhost. SELECT * FROM mysql.user should give you the answer. Check if root is only allowed to connect from 127.0.0.1 (localhost) Hope this helps. SolNET Digital Jindo [EMAIL PROTECTED] Tel: +886 2 26547645 Fax:+886 2 26515005 Cell: 0922706509 -Original Message- From: Bryan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 4:00 PM To: [EMAIL PROTECTED] Subject: Connect to Database over the Internet Hello All: I would appreciate some help on how to configure my application code or the computer which mysql resides on so it can be accesed over the intenet. Putting aside the obvious security concerns how can I achieve this. The application is written in VB using ADO to access the database. Currently this is the connect string I currently use to connect to the database. .ConnectionString = Data Source = REGIONAL;SERVER=xx.xx.xx.xxx;User ID = root; Password It works fine connecting to the database when run on the same computer which contains the MYSQL database. When I try the application from a remote computer configured it does not connect. No firewall is involved. I suspect I need to configure certain networking protocols on the host/ server machine, but am lost as to what I should be doing. The operating system is XP professional. Any suggestions. Thanks -=Bryan=- - 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: count function issue
At 16:50 -0500 9/18/02, McIrvin wrote: Doing queries to determine the number of times search terms are used on a web site. Here is a sample sql query. SELECT terms, count(*) AS count FROM searches GROUP BY terms HAVING count(*)1 ORDER BY count DESC But the results seem to be inaccurate, by no more that 3. Sorry, it's difficult to parse that last sentence. Also, since you don't indicate what you expect and what you actually got, it's hard to say whether what you're seeing is to be expected. Anyone run into anything like this before? - 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
Upgrade from 3.23 to 4.03
I saw the information for upgrading MySQL 3.23 to 4.03 regarding altering table types, etc. If I am using the Windows release can I just install the binaries etc. over the existing installation? Will the new install wipe out the data directory? Thanks in advance! - 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: count function issue
OK,, I'll clarify: A query like: SELECT terms, count(*) AS count FROM searches GROUP BY terms HAVING count(*)1 ORDER BY count DESC Is run on a table built by users searches on a site, so there are lots of duplicate entries, were trying to count the duplicates to determine the most popular search terms. The problem arises where you do a query like SELECT * FROM 'terms' WHERE term='test' And count the number of rows returned (with php or whatever) the issue is that the result from the count() function ends up being a little higher sometimes but by no more than 3 instances. --=C - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: McIrvin [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 5:06 PM Subject: Re: count function issue At 16:50 -0500 9/18/02, McIrvin wrote: Doing queries to determine the number of times search terms are used on a web site. Here is a sample sql query. SELECT terms, count(*) AS count FROM searches GROUP BY terms HAVING count(*)1 ORDER BY count DESC But the results seem to be inaccurate, by no more that 3. Sorry, it's difficult to parse that last sentence. Also, since you don't indicate what you expect and what you actually got, it's hard to say whether what you're seeing is to be expected. Anyone run into anything like this before? - 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
Problem displaying results from MySQL database
Hi I have a php script that 'should' get data from a MySQL database and display it in a web page. When I test the script using 'zend development environment' the output appears fine, all the data records, html tags and all. When I try and run it from a browser I keep getting a parse error as follows: - 'Parse error: parse error in C:\apache\htdocs\searchform.php on line 22' php code follows- HTML BODY ?php // send username and password to mysql on server mysql_connect (localhost, username, password); // open register database mysql_select_db (register); if ($surname == ) {$surname = '%';} if ($forename == ) {$forename = '%';} // get data that matches search criteria from database $result = mysql_query (SELECT * FROM detail WHERE surname LIKE '$surname%' AND forename LIKE '$forename%' ); // Create html table print(TABLE BORDER=1 CELLSPACING=2 CELLPADDING=2 ALIGN=CENTER\n); print(TR ALIGN=CENTER VALIGN=TOP\n); print(TD ALIGN=CENTER VALIGN=TOPSurname/TD\n); print(TD ALIGN=CENTER VALIGN=TOPForename/TD\n); print(TD ALIGN=CENTER VALIGN=TOPCounty/TD\n); print(TD ALIGN=CENTER VALIGN=TOPRegister Number/TD\n); print(/TR\n); //Display Results from Database if ($row = mysql_fetch_array($result)) { do { print(TR\n); print(TD$row[surname]/td\n); print(TD$row[forename]/td\n); print(TD$row[county]/td\n); print(TD$row[code]/td\n); print(/TR\n); } while($row = mysql_fetch_array($result)); } else {print Sorry, no records were found!;} print (/TABLE\n); ? /BODY /HTML - 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: count function issue
At 17:26 -0500 9/18/02, McIrvin wrote: OK,, I'll clarify: A query like: SELECT terms, count(*) AS count FROM searches GROUP BY terms HAVING count(*)1 ORDER BY count DESC Is run on a table built by users searches on a site, so there are lots of duplicate entries, were trying to count the duplicates to determine the most popular search terms. The problem arises where you do a query like SELECT * FROM 'terms' WHERE term='test' And count the number of rows returned (with php or whatever) the issue is that the result from the count() function ends up being a little higher sometimes but by no more than 3 instances. What happens if you replace count(*) by count(terms) throughout the query? --=C - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: McIrvin [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 5:06 PM Subject: Re: count function issue At 16:50 -0500 9/18/02, McIrvin wrote: Doing queries to determine the number of times search terms are used on a web site. Here is a sample sql query. SELECT terms, count(*) AS count FROM searches GROUP BY terms HAVING count(*)1 ORDER BY count DESC But the results seem to be inaccurate, by no more that 3. Sorry, it's difficult to parse that last sentence. Also, since you don't indicate what you expect and what you actually got, it's hard to say whether what you're seeing is to be expected. Anyone run into anything like this before? - 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: count function issue
Thanks but no change. --=C - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: McIrvin [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 5:41 PM Subject: Re: count function issue At 17:26 -0500 9/18/02, McIrvin wrote: OK,, I'll clarify: A query like: SELECT terms, count(*) AS count FROM searches GROUP BY terms HAVING count(*)1 ORDER BY count DESC Is run on a table built by users searches on a site, so there are lots of duplicate entries, were trying to count the duplicates to determine the most popular search terms. The problem arises where you do a query like SELECT * FROM 'terms' WHERE term='test' And count the number of rows returned (with php or whatever) the issue is that the result from the count() function ends up being a little higher sometimes but by no more than 3 instances. What happens if you replace count(*) by count(terms) throughout the query? --=C - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: McIrvin [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 5:06 PM Subject: Re: count function issue At 16:50 -0500 9/18/02, McIrvin wrote: Doing queries to determine the number of times search terms are used on a web site. Here is a sample sql query. SELECT terms, count(*) AS count FROM searches GROUP BY terms HAVING count(*)1 ORDER BY count DESC But the results seem to be inaccurate, by no more that 3. Sorry, it's difficult to parse that last sentence. Also, since you don't indicate what you expect and what you actually got, it's hard to say whether what you're seeing is to be expected. Anyone run into anything like this before? - 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: auto Incerment
Hi Well... I tried all the methodes, tried inserting with out the id, with NULL id with 0 as id. No of them seems working :-( Any other ideas?? Thanks you Arjen van der Weijden wrote: Leave out the id column in your insert-statement vinita vigine Murugiah To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: .OZ.AU Subject: auto Incerment 18-09-02 08:25 HI I'm having problem with the AUTO_INCREMENT, we are using ver 3.23.33 This is the definition of table software_machineOSs ++--+--++-++ | Field | Type | Null | Key | Default | Extra | ++--+---+---+-++ | softwareID | char(20)| YES | MUL| NULL| | | id | int(2) || | NULL | auto_increment | | osName | char(20)| YES| | NULL || | osRevision | char(20)| YES| | NULL || ++--+---+---+---+--+ Adding an entry mysql insert into software_machineOSs (softwareID, id, osName, osRevision) - values (readline-4.3, NULL, test, test3); Selecting entries mysql select * from software_machineOSs where softwareid=readline-4.3; +--++---++ | softwareID | id | osName| osRevision | +--++---++ | readline-4.3 | 1 | Tru64 | 5.1| | readline-4.3 | 1 | Solaris/Sparc | 8 | | readline-4.3 | 1 | Solaris/x86 | 8 | | readline-4.3 | 1 | test | test | | readline-4.3 | 1 | test | test1 | | readline-4.3 | 1 | test | test1 | | readline-4.3 | 1 | test | test3 | +--++---++ 7 rows in set (0.00 sec) As you can see the ID did NOT increment, I'm not sure what I'm doing wrong. I tried with out giving any value for ID, 0 value for ID NULL for ID. Non of them seems working. Is this a bug in the version 3.23.33?? Appreciate your fast response Thank you for your time warm regards Vinita - 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: count function issue
No,, I dumped the table and put it on a different server and tried it there. - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: McIrvin [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 6:37 PM Subject: Re: count function issue Thanks but no change. --=C And the difference isn't accounted for just as a result of new records being added to the table between queries? - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: McIrvin [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 5:41 PM Subject: Re: count function issue At 17:26 -0500 9/18/02, McIrvin wrote: OK,, I'll clarify: A query like: SELECT terms, count(*) AS count FROM searches GROUP BY terms HAVING count(*)1 ORDER BY count DESC Is run on a table built by users searches on a site, so there are lots of duplicate entries, were trying to count the duplicates to determine the most popular search terms. The problem arises where you do a query like SELECT * FROM 'terms' WHERE term='test' And count the number of rows returned (with php or whatever) the issue is that the result from the count() function ends up being a little higher sometimes but by no more than 3 instances. What happens if you replace count(*) by count(terms) throughout the query? --=C - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: McIrvin [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 5:06 PM Subject: Re: count function issue At 16:50 -0500 9/18/02, McIrvin wrote: Doing queries to determine the number of times search terms are used on a web site. Here is a sample sql query. SELECT terms, count(*) AS count FROM searches GROUP BY terms HAVING count(*)1 ORDER BY count DESC But the results seem to be inaccurate, by no more that 3. Sorry, it's difficult to parse that last sentence. Also, since you don't indicate what you expect and what you actually got, it's hard to say whether what you're seeing is to be expected. Anyone run into anything like this before? - 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
Re: How to use Auto Increment
At 9:30 -0400 9/18/02, Neil Mansilla wrote: On Wed, 18 Sep 2002, Rajesh Kanade wrote: Hi All I am new to MY SQL . I am writing a script where I will have 2 insert statements The first insert is into a table which has an Auto_Increment field. I want to know the value which was inserted in this Auto_increment field and use it in the second INSERT statement. How can I do it in MySQL. Rajesh, if you wish to pull the value of the last AUTO_INCREMENT issued, use this query: SELECT LAST_INSERT_ID(); The second INSERT statement really shouldn't need the value of the last AUTO_INCREMENT issued, since it should just get the next number in sequence, well, automatically. That's assuming both INSERTs are into the same table. I got the idea that he wanted the AUTO_INCREMENT value for use in inserting a record into a different but related table. For example: Table schema: id INT UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(100) NOT NULL, primary key (id) INSERT INTO Table VALUES (null,'Neil'); INSERT INTO Table VALUES (null,'Rajesh'); If these were the first two records, the two rows would look like this: 1 | Neil 2 | Rajesh Regards, Neil Mansilla whatUseek.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: auto Incerment
At 16:25 +1000 9/18/02, vinita vigine Murugiah wrote: HI I'm having problem with the AUTO_INCREMENT, we are using ver 3.23.33 This is the definition of table software_machineOSs ++--+--++-++ | Field | Type | Null | Key | Default | Extra | ++--+---+---+-++ | softwareID | char(20)| YES | MUL| NULL| | | id | int(2) || | NULL | auto_increment | I assume that you have a PRIMARY KEY or UNIQUE index on (softwareID, id) here? What's the table type? Not all table types support composite keys with AUTO_INCREMENT this way. | osName | char(20)| YES| | NULL || | osRevision | char(20)| YES| | NULL || ++--+---+---+---+--+ Adding an entry mysql insert into software_machineOSs (softwareID, id, osName, osRevision) - values (readline-4.3, NULL, test, test3); Selecting entries mysql select * from software_machineOSs where softwareid=readline-4.3; +--++---++ | softwareID | id | osName| osRevision | +--++---++ | readline-4.3 | 1 | Tru64 | 5.1| | readline-4.3 | 1 | Solaris/Sparc | 8 | | readline-4.3 | 1 | Solaris/x86 | 8 | | readline-4.3 | 1 | test | test | | readline-4.3 | 1 | test | test1 | | readline-4.3 | 1 | test | test1 | | readline-4.3 | 1 | test | test3 | +--++---++ 7 rows in set (0.00 sec) As you can see the ID did NOT increment, I'm not sure what I'm doing wrong. I tried with out giving any value for ID, 0 value for ID NULL for ID. Non of them seems working. Is this a bug in the version 3.23.33?? Appreciate your fast response Thank you for your time warm regards Vinita - 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: sum column in mysql
At 10:32 +0300 9/18/02, adi wrote: Hi, I have a table table1, with a column Duration time type(ex 00:12:30) I want to make a sql selection: SELECT * from table1 WHERE condition, and after that, to make sum of values of column Duration and display it. Any Help? tx To display as seconds: SELECT SUM(TIME_TO_SEC(Duration)) FROM table1 ... To display as a TIME value: SELECT SEC_TO_TIME(SUM(TIME_TO_SEC(Duration))) FROM table1 ... - 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: tinyInt(7) - not limited to 7 digits???
At 1:41 -0700 9/18/02, neal wrote: If Tomcat is installed and pointing to JDK1.3 but one wants to point instead to JDK1.4, is there an easy way to do this? If so, I'm not finding it. Seems like one would need to completely uninstall and reinstall tomcat??? Naw, just redefine the JAVA_HOME environment variable to point to the new JDK and be sure to remember that a display width of 7 for tinyint has nothing to do with the range of values that the column type can display. :-) Thanks. Neal [sql,query] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: date field - default value = current date
At 1:32 -0700 9/18/02, neal wrote: Is there a wat to have mySQL auto fill in the current date into my dateCreated field? In SQLServer I would simply specify the getDate() method as a default value. I presume I would use the analogous MySQL function curDate() but it does not appear to work for me. It's better to read the manual than to presume. In this case, the presumption is incorrect. Default values in MySQL must be constants. However, you might find the TIMESTAMP column type helpful. I'll let you read about it in the manual. :-) http://www.mysql.com/doc/en/DATETIME.html Any suggestions? - 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 and VB.NET
At 15:39 -0400 9/16/02, Fengling_Li wrote: Hi, Our company will start a new project soon. We might want to use mysql database. Now I have a question, does mysql work with VB.NET? if it does, could you tell me how ? Here's some information that may be helpful: http://www.mysql.com/articles/dotnet/index.html It describes the .NET interfaces that MySQL supports. Thanks. Fengling Li Amatrol, Inc. Phone: (812)-288-8285 x271 - 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