installation problems
I purchased a book entitled PHP3 programming browser-based Applications it came with a cd that contained a copy of MySql-3.22.16a-gamma for any linux distribution. Anyhow, I am having problems installing the software on my SuSe 7.1 linux box. Basically, there are eleven steps that the author david medinets requires in order to properly install the software, but of those eleven, I am having problems with step 8. From root directory linux: ~ # - 1 cd /usr/local/src/mysql-3.22.16a-gamma 2 ./configure --prefix=/usr/local/mysql 3 make 4 make install 5 echo /usr/local/mysql/lib/mysql /etc/ld.so.conf 6 ldconfig -v | grep libmysqlclient 7 echo /usr/local/mysql/bin/safe_mysqld /dev/null /etc/rc.d/rc.local 8 ./scripts/mysql_install_db 9 /usr/local/mysql/bin/safe_mysqld /dev/null 10 ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql 11 ln -s /usr/local/mysql/bin/mysql /usr/bin/mysqlshow after this, the author gives you a sample code to test the database. _ step 8 after entering this at the prompt: linux: usr/local/src/mysql-3.22.16a-gamma # ./scripts/mysql_install_db an error message ( did'nt find /usr/local/mysql/libexec/mysql ) ( You should do a make install before executing this script ) I tryed to run the sample code with out this being installed correctly, but no luck. I would really like any help from anyone on solving this problem. As far as libexec not be found, well there is a lib directory with a subdirectory of mysql. Why its looking for libexec? Well, I simply don't know. Thanks [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
mysqlbug
I purchased a book entitled PHP3 programming browser-based Applications it came with a cd that contained a copy of MySql-3.22.16a-gamma for any linux distribution. Anyhow, I am having problems installing the software on my SuSe 7.1 linux box. Basically, there are eleven steps that the author david medinets requires in order to properly install the software, but of those eleven, I am having problems with step 8. From root directory linux: ~ # - 1 cd /usr/local/src/mysql-3.22.16a-gamma 2 ./configure --prefix=/usr/local/mysql 3 make 4 make install 5 echo /usr/local/mysql/lib/mysql /etc/ld.so.conf 6 ldconfig -v | grep libmysqlclient 7 echo /usr/local/mysql/bin/safe_mysqld /dev/null /etc/rc.d/rc.local 8 ./scripts/mysql_install_db 9 /usr/local/mysql/bin/safe_mysqld /dev/null 10 ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql 11 ln -s /usr/local/mysql/bin/mysql /usr/bin/mysqlshow after this, the author gives you a sample code to test the database. _ step 8 after entering this at the prompt: linux: usr/local/src/mysql-3.22.16a-gamma # ./scripts/mysql_install_db an error message ( did'nt find /usr/local/mysql/libexec/mysql ) ( You should do a make install before executing this script ) I tryed to run the sample code with out this being installed correctly, but no luck. I would really like any help from anyone on solving this problem. As far as libexec not be found, well there is a lib directory with a subdirectory of mysql. Why its looking for libexec? Well, I simply don't know. Thanks [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
Char set Win1250
Hello, I have simple question.I have installed on my computer WinNT 4.0, Apache 1.3.14, PHP4 (4.0.4pl1), MySQL MAX 4.0.1. There's problem with char set win1250. I don't know how can I link this char set. Script with this row $spojeni = MySQL_Connect(localhost); sends an error Warning: MySQL Connection Failed: Can't initialize character set 26 (path: default) in c:/program files/apache group/apache/htdocs/tellib.php on line 84. (Char set 26 is Win1250). Does anybody know, how can I link char-set Win1250 in Win32 system to PHP4 and MySQL? In PHP3 works everything properly. Pavel Zaklasnik Czech Republic --- Odchoz zprva neobsahuje viry. Zkontrolovno antivirovm systmem AVG (http://www.grisoft.cz). Verze: 6.0.320 / Virov bze: 179 - datum vydn: 30.1.2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: storing files...
Nick, Tuesday, April 09, 2002, 5:21:00 PM, you wrote: NS Is there a way to store files in MySQL? Looking to store somthing like a NS zip file in the databaseand be able to retrieve/download it from something like ASP. Yes, you can store files in the BLOB fields. You can find some info about BLOB column types and storage requirements in the MySQL manual: http://www.mysql.com/doc/B/L/BLOB.html http://www.mysql.com/doc/n/o/node_368.html To put binary data in the database you can use LOAD_FILE() function. LOAD_FILE() function is described at: http://www.mysql.com/doc/S/t/String_functions.html If you don't use LOAD_FILE() - don't forget to escape chars. You can find the list of chars to escape and escape sequences at: http://www.mysql.com/doc/S/t/String_syntax.html To read binary data use the SELECT statement. NS Thanks NS -Nick -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Stored Procedures
hi, i've just started work with MySQL. Does anybody know how can i use stored procedures with MySQL? Is this capability supported? Thanks John Dimos - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqlimport problem
Scott, Tuesday, April 9, 2002, 6:20:38 PM, you wrote: SA I been using mysqlimport for a long time with no problems. SA But today when I try (as root) SA mysqlimport admin /usr/local/systems/admin/data/person.txt -p SA I get SA mysqlimport: Error: Can't get stat of SA '/usr/local/systems/admin/data/person.txt' (Errcode: 13), when using SA table: SA person SA even though stat /usr/local/systems/admin/data/person.txt SA File: /usr/local/systems/admin/data/person.txt SA Size: 1497 Blocks: 8 Regular File SA Access: (0444/-r--r--r--) Uid: (0/root) Gid: (0/ SA root) SA Device: 305Inode: 245470 Links: 1 SA Access: Tue Apr 9 15:54:34 2002 SA Modify: Tue Apr 9 01:00:01 2002 SA Change: Tue Apr 9 15:35:52 2002 SA What can cause it to stop working all of a sudden? [] Looks weird to me. Stat is ok, but mysqlimport can't get the file.. Maybe, try to take a look at the path to the file, maybe execute permission for a directory is missing? The other source of the problem could be that error 13 belongs to a table, not to a file. Check permissions for table files. SA Scott -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to check which version of mysql is installed
Jianping, Tuesday, April 09, 2002, 5:55:08 PM, you wrote: JZ I have a redhat 7.1 server, I want to get rid of the installed mysql JZ server. How can check which version is installed and how to get rid of it? You can indicate MySQL server version using SELECT VERSION() statement or run mysqld (mysqld-max) with -V option. If MySQL server is installed from RPM you can uninstall it by rpm --uninstall package_name The following command will show you what rpm packages are installed: rpm -qa| grep -i mysql If MySQL server is installed from source or binary - you can uninstall it only manually. JZ Thanks -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Stored Procedures
Yiannis, Wednesday, April 10, 2002, 10:17:03 AM, you wrote: YD i've just started work with MySQL. Does anybody know how can i YD use stored procedures with MySQL? Is this capability supported? MySQL doesn't have stored procedures yet, but it is in our plans to support them, look at: http://www.mysql.com/doc/A/N/ANSI_diff_Triggers.html YD Thanks YD John Dimos -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql japanese
Aravind NagaVenkata Gorthy repeated himself: Dear All Could any one tell me what all the chages I have to make in order to make my existing (english version) of MySQL database compatable to the Japanese language. So I repeat myself: Boy. That's a tough one. I'm really not sure what you want to know. Do you want to convert the whole thing to Japanese for a Japanese-only audience? Do you want to have a Japanese version of you database that is structured the same as your English version? Do you want to store both Japanese and English together? Do you want to be able to search and sort the Japanese data? Or would it be enough to store Japanese data? Or do you simply want to show the English data in Japanese web pages? Do you know which encoding your tools use? Do you know which encoding you'll be getting most of your data in? Do you need a discussion of what the web environment is like over here, so you can base your decision about character encoding on that? I can throw some random information at you. (You know, shot-in-the-dark.) The settings necessary to sort and search in a different language are explained in section 4.6 of the manual. Is there something there you don't understand? Let's see. If you plan to search and sort Japanese, you'll need extra pronunciation (kana) fields. Sorting on Kanji does not give results that the average Japanese person will think very useful. There are three families of character encoding in common use in Japan, JIS, euc-JIS (*NIX), and shift-JIS (PC/ClassicMac/etc.). Unicode is not (yet?) commonly used in Japan, but converters exist, and mostly give good results. MySQL seems to support euc-JIS best. It does not yet support Unicode or straight-JIS for searching and sorting, athough you would be able to store them okay. We are using MySQL with shift-JIS in house, but I'm not sure how well the searching and sorting work. Shift-JIS is a pain to parse, by the way, and I'm sure that's why MySQL doesn't fully support it yet. Incidentally, JIS includes a base Latin character set, but that character set can only be viewed with Japanese fonts. Shift-JIS and euc-JIS both include two Latin character sets, one of which is (almost) 7-bit ASCII. JIS is constant 16-bits wide, and shift-JIS and euc-JIS are both multi-byte, so you can actually (sort of) mix Japanese and English using shift-JIS or euc-JIS, and there is a moderate probability of the English being legible in an English font. But we don't know if any of that is meaningful to you, because we don't know what you want to do. We don't know what tools you have, what character sets they work with, etc. And we don't even know for sure if you are going to try to keep English and Japanese together in one database, or if you plan to separate the databases so you don't have to mess too much with keeping the browser environments and character encodings and database structure straight. So, please, ask us a question we can answer. Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Sage Line 50 and importing into MySQL with ODBC
Hi, cannot seem to sucessfully make a simply link between Sage Line 50 and MySQL. When accessing the tables the damn thing throws up errors and can import structure but fails to import data. I am using MySQL-Front to do this. Anyone have any idea where i am going wrong or something to try. BTW Sage imports into excel just fine so MS products may be more forgiving ? Cheers - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--Transactions
Hello , i've just started work with MySQL. Does anybody know how can i use transaction with MySQL? Is this capability supported? I write web-shop... Sory my eng is bed... -- Best regards, maxim mailto:[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: binlog and replication stuff
How about if master crashes?...is there anyway to recover?...aside from copying all stuff from slave to master... R.B.Roa PhilCom Corporation Tel. No. 858- Mobile No. (63) (919-xxx) -Original Message- From: Davide Giunchi [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 5:37 PM To: Marc Prewitt Cc: [EMAIL PROTECTED] Subject:Re: binlog and replication stuff You are right, but my master generate about 150Mb of binlog x day, i a slave fail after 4 day it will reexec a lot of query and take some time. how can i safely rotate the log in master+slaves without restarting them? The Mysql manual explain how to rotate from a `hostnmae`-bin`.002 (or 001) file, but what about if the binlog is always the same? I could do a FLUSH MASTER in the master and then FLUSH SLAVE in the slaves, it wouldn't loose the sync? Regards When a slave crashes or reboots, it should start replicating from where it left off--at least ours do work that way. The current replication state is saved in master.info on the slave and when it starts up again, it should read that file and resume reading the binlog on the master where it left off. The master.info file contains the binlog#, location, user, password, etc... neccessary to restart replication. In you case, does the slave give you any error messages in it's error log about why it couldn't resume replication? If it doesn't try to start replication, have you tried doing a 'slave start' on the slave after it reboots? -Marc -- Davide Giunchi. Membro del FoLUG (Forlí Linux User Group) - http://folug.linux.it GPG Key available on http://www.keyserver.net Fingerprint: 8075 363A B4FA 0196 FEEC AF9C 19A9 66C7 CDAB D0D5 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: --Transactions
On Wed, 10 Apr 2002 13:27:30 +0300 maxim [EMAIL PROTECTED] wrote: Hello , i've just started work with MySQL. Does anybody know how can i use transaction with MySQL? Is this capability supported? I write web-shop... Sory my eng is bed... what term do you mean with transaction ? if you mean ... you want to build web application using mysql, the answer is absolutely YES ! ;-) :D -- How should I know if it works? That's what beta testers are for. I only coded it. -- Attributed to Linus Torvalds, somewhere in a posting - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: TIMESTAMP(14) or Bigint ??
On Tue, 9 Apr 2002, David BORDAS wrote: Sent: Tuesday, April 09, 2002 2:14 PM Subject: Re: TIMESTAMP(14) or Bigint ?? TIMESTAMP is 4 Bytes and DATETIME is 8 Bytes. So, 4 Bytes difference per 5 Millions records = a 20 MB bigger table ... David If storage space is an issue you may want to use TIMESTAMP But i think the feature timestamp field of every row will automatically be timestamped ... will anoy me. You may assign explicit values to the timestamp column in INSERT and UPDATE commands. Thomas -- filter fodder: sql database - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: --Transactions
On Wed, 10 Apr 2002, maxim wrote: Hello , i've just started work with MySQL. Does anybody know how can i use transaction with MySQL? Is this capability supported? I write web-shop... Sory my eng is bed... Maxim, MySQL supports different table types. Some of them (BDB and InnoDB) support transactions. Others (like MyISAM) do not. Being new to MySQL is a good reason to study the manual. It's all there. Cheers, Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re[2]: --Transactions
Hello Dicky, Wednesday, April 10, 2002, 1:42:00 PM, you wrote: DWP On Wed, 10 Apr 2002 13:27:30 +0300 DWP maxim [EMAIL PROTECTED] wrote: Hello , i've just started work with MySQL. Does anybody know how can i use transaction with MySQL? Is this capability supported? I write web-shop... Sory my eng is bed... DWP what term do you mean with transaction ? DWP if you mean ... you want to build web application using mysql, the answer is absolutely YES ! ;-) DWP :D -- Best regards, maximmailto:[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
Fw: mysql_install_db still locking :-(
- Original Message - From: Chris Lamrock [EMAIL PROTECTED] To: Egor Egorov [EMAIL PROTECTED] Sent: Tuesday, April 09, 2002 10:21 AM Subject: Re: mysql_install_db still locking :-( Egor, I'm running : Red Hat Linux release 7.0 (Guinness) on a Pentium III 450 with 128 meg of Ram. Are you thinking I may need to run an older version of Mysql? Thanks for the reply! Chris - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 09, 2002 10:00 AM Subject: Re: mysql_install_db still locking :-( Chris, Tuesday, April 09, 2002, 3:22:00 PM, you wrote: CL Still having this trouble with mysql.. Running the mysql_install_db renders CL this... CL Preparing db table CL Preparing host table CL Preparing user table CL Preparing func table CL Preparing tables_priv table CL Preparing columns_priv table CL Installing all prepared tables CL At this point the script locks at this point won't go any further. CL This happens when the binary runs it automatically after running the RPM, or CL just trying to run it by hand. CL I am using CL MySQL-3.23.49a-1.i386.rpm CL MySQL-client-3.23.49a-1.i386.rpm CL Red Hat Linux version 2.2.16-22 CL I also pulled the sources down installed them, compiled ran them CL same thing! Chris, which version of RedHat do you use on what kind of hardware? CL Anybody have any ideas - I'm starting to loose hope! CL Thanks! CL Chris -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-- e-shop
Hi all! Problem. How to ensure(supply) reservation MySQL in a context of creation the Internet shop to raise(increase) his(its) reliability. -- Best regards, maxim mailto:[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: Re: gui
respected sir/madam, i installed the client and server files (rpm) of MYSql for linux , but failed to get the gui working. could you please help me in this regards. thanking you hitesh patel On Wed, 10 Apr 2002 [EMAIL PROTECTED] wrote : Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: respected sir/madam, i installed bith the client and server files (rpm) for linux , but failed to get the gui working. could you please help me in this regards. thanking you hitesh patel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: sql query alter HELP!!!
Aman, Tuesday, April 09, 2002, 5:24:49 PM, you wrote: AR Hello everyone AR I want to alter 50 tables, and for each the names start with the string AR 'mak' AR Is there an SQL query, so that I can do the change in one command. AR I have tried using wildcards - they don't seem to work in SQL. You can't using only MySQL ... You can pick up table names and then organize cycle for ALTER TABLE ... AR Thanks in advance. AR Aman -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re[2]: -- e-shop
Hello sean, Wednesday, April 10, 2002, 2:37:34 PM, you wrote: sosi Hi maxim, sosi I'm not sure what you mean, given your earlier posts you seem sosi to be talking about transactions in mysql. if thats the case sosi i recommend you take a look at innodb. its a table type for sosi mysql that supports full acid transactions. sosi Sean sosi -Original Message- sosi From: maxim [mailto:[EMAIL PROTECTED]] sosi Sent: 10 April 2002 04:27 sosi To: [EMAIL PROTECTED] sosi Subject: -- e-shop sosi Hi all! sosi Problem. How to ensure(supply) reservation MySQL in sosi a context of creation the Internet shop to raise(increase) sosi his(its) reliability. At me a problem with understanding how to ensure(supply) a high degree of readiness MySQL at realization of shop. Whether probably to organize reservation of the database, on a case of failure(refusal). If it is possible where to receive the recommendations for realization of the given structure. -- Best regards, maximmailto:[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[2]: --- MySQL
Hello Victoria, Wednesday, April 10, 2002, 3:07:01 PM, you wrote: VR Hello maxim, VR Wednesday, April 10, 2002, 2:14:54 PM, you wrote: m ñ ÐÉÛÕ ÄÉÐÌÏÍ, É-ÎÅÔ ÍÁÇÁÚÉÎ MySQL+php+Apache .. m ÷ÏÐÒÏÓ: ÇÄÅ ÍÏÖÎÏ ÎÁÊÔÉ ÐÏÄÒÏÂÎÕÀ ÄÏËÕÍÅÎÔÁÃÉÀ Ï ÏÓÏÂÅÎÎÏÓÔÑÈ m ÉÐÏÌØÚÏ×ÁÎÉÉ SQL × MySQL .. É ÒÁÓÛÉÆÒÏ×ËÕ ËÏÄÏ× ÏÛÉÂÏË ... VR íÁÎÕÁÌ Ó www.mysql.com ÜÔÏ ÎÁ ÄÁÎÎÙÊ ÍÏÍÅÎÔ ÓÁÍÁÑ ÐÏÌÎÁÑ ÄÏËÁ ÐÏ VR MySQL, ÉÚ ÄÏËÕÍÅÎÔÁÃÉÉ × ÂÕÍÁÖÎÏÍ ×ÉÄÅ ÓÏ×ÅÔÕÀ ÏÂÒÁÔÉÔØ ×ÎÉÍÁÎÉÅ ÎÁ VR ËÎÉÖËÕ Paul DuBois(ÐÏÄ ÒÅÄÁËÃÉÅÊ Monty) MySQL. VR ëÏÄÙ ÏÛÉÂÏË MySQL ÍÏÖÅÛØ ÐÏÓÍÏÔÒÅÔØ × ÁÒÈÉ×Å ÒÁÓÓÙÌËÉ VR http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:72230 m óÏÒÒÒÉ ÚÁ ÄÅÌÉÔÁÎÓËÉÅ ×ÏÐÒÏÓÙ . äÁÎÎÁÑ ËÎÉÇÁ ÕÖÅ ÉÍÅÅÔÓÑ ... ÷ÏÚÎÉËÁÅÔ ×ÏÐÒÏÓ ËÁË ÒÅÁÌÉÚÏ×ÁÔØ ×ÙÓÏËÕÀ ÓÔÅÐÅÎØ ÇÏÔÏ×ÎÏÓÔÉ MySQL × ËÏÎÔÅËÓÔÅ ÉÎÔÅÒÅÎÔ ÍÁÇÁÚÉÎÁ. ÷ÏÚÍÏÖÎÏ ÌÉ ÒÅÁÌÉÚÏ×ÁÔØ ÏÔÚÅÒËÁÌÉ×ÁÎÉÅ ÅÅ,... ÉÌÉ ÅÓÌÉ ÅÓÔØ ÄÒÕÇÉÅ ÓÐÏÓÏÂÙ ÐÏ×ÙÛÅÎÉÑ ÎÁÄÅÖÎÏÓÔÉ? çÄÅ ÍÏÖÎÏ ÐÏÞÅÒÐÎÕÔØ ÉÎÆÏÒÍÁÃÉÀ Ï ÎÉÈ. úÁÒÁÎÅÅ ÓÐÁÓÉÂÏ. -- Best regards, maximmailto:[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: --- MySQL
Very interesting conversation, ... íÙ ÎÅ ÇÏ×ÏÒÉÍ ÐÏ ÒÕÓÓÊÉ :-) Adib. maxim wrote: Hello Victoria, Wednesday, April 10, 2002, 3:07:01 PM, you wrote: VR Hello maxim, VR Wednesday, April 10, 2002, 2:14:54 PM, you wrote: m ñ ÐÉÛÕ ÄÉÐÌÏÍ, É-ÎÅÔ ÍÁÇÁÚÉÎ MySQL+php+Apache .. m ÷ÏÐÒÏÓ: ÇÄÅ ÍÏÖÎÏ ÎÁÊÔÉ ÐÏÄÒÏÂÎÕÀ ÄÏËÕÍÅÎÔÁÃÉÀ Ï ÏÓÏÂÅÎÎÏÓÔÑÈ m ÉÐÏÌØÚÏ×ÁÎÉÉ SQL × MySQL .. É ÒÁÓÛÉÆÒÏ×ËÕ ËÏÄÏ× ÏÛÉÂÏË ... VR íÁÎÕÁÌ Ó www.mysql.com ÜÔÏ ÎÁ ÄÁÎÎÙÊ ÍÏÍÅÎÔ ÓÁÍÁÑ ÐÏÌÎÁÑ ÄÏËÁ ÐÏ VR MySQL, ÉÚ ÄÏËÕÍÅÎÔÁÃÉÉ × ÂÕÍÁÖÎÏÍ ×ÉÄÅ ÓÏ×ÅÔÕÀ ÏÂÒÁÔÉÔØ ×ÎÉÍÁÎÉÅ ÎÁ VR ËÎÉÖËÕ Paul DuBois(ÐÏÄ ÒÅÄÁËÃÉÅÊ Monty) MySQL. VR ëÏÄÙ ÏÛÉÂÏË MySQL ÍÏÖÅÛØ ÐÏÓÍÏÔÒÅÔØ × ÁÒÈÉ×Å ÒÁÓÓÙÌËÉ VR http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:72230 m óÏÒÒÒÉ ÚÁ ÄÅÌÉÔÁÎÓËÉÅ ×ÏÐÒÏÓÙ . äÁÎÎÁÑ ËÎÉÇÁ ÕÖÅ ÉÍÅÅÔÓÑ ... ÷ÏÚÎÉËÁÅÔ ×ÏÐÒÏÓ ËÁË ÒÅÁÌÉÚÏ×ÁÔØ ×ÙÓÏËÕÀ ÓÔÅÐÅÎØ ÇÏÔÏ×ÎÏÓÔÉ MySQL × ËÏÎÔÅËÓÔÅ ÉÎÔÅÒÅÎÔ ÍÁÇÁÚÉÎÁ. ÷ÏÚÍÏÖÎÏ ÌÉ ÒÅÁÌÉÚÏ×ÁÔØ ÏÔÚÅÒËÁÌÉ×ÁÎÉÅ ÅÅ,... ÉÌÉ ÅÓÌÉ ÅÓÔØ ÄÒÕÇÉÅ ÓÐÏÓÏÂÙ ÐÏ×ÙÛÅÎÉÑ ÎÁÄÅÖÎÏÓÔÉ? çÄÅ ÍÏÖÎÏ ÐÏÞÅÒÐÎÕÔØ ÉÎÆÏÒÍÁÃÉÀ Ï ÎÉÈ. úÁÒÁÎÅÅ ÓÐÁÓÉÂÏ. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Difficulties between OS versions
Two of my co-workers attended the MySQL training in San Francisco last month. We have successfully installed 4.01 on a SUN Ultra 250 running Solaris 2.8. Four myisam tables were created and populated. When we tried to install the same software on a SUN Sparc 20 running Solaris 2.6 errors were encountered. Something about a missing file 'librt.so.1'. We thought the OS version was 2.7. Not correct! I downloaded the binary MySQL version 3.22.32 from the archive area on the website and it installed. However, the same 4 tables that are working under Solaris 2.8 are presenting errors under Solaris 2.6. The error message states that there is no field information available for any of the 4 tables. Am I doing something wrong. Next, does this older version have INNODB support available? Tom Lee Group Lead LM AERO - Field Information Network Software Development/Administration Group VOICE: 817-763-6541 FAX: 817-763-6548 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-- e-shop
Hello All, I am sorry for Russian. I shall mean. The question remains open. How to reach(achieve) a high degree of reliability of system the Internet of commerce on a basis MySQL. At the expense of that it is possible to raise(increase) reliability of system? -- Best regards, maxim mailto:[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: mysql_install_db still locking :-(
Egor, I'm using the following: Red Hat Linux release 7.0 (Guinness) on a Pentium III 450 with 128 meg of Ram. Are you thinking I may need to run an older version of Mysql? Thanks for the reply! Chris - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 09, 2002 10:00 AM Subject: Re: mysql_install_db still locking :-( Chris, Tuesday, April 09, 2002, 3:22:00 PM, you wrote: CL Still having this trouble with mysql.. Running the mysql_install_db renders CL this... CL Preparing db table CL Preparing host table CL Preparing user table CL Preparing func table CL Preparing tables_priv table CL Preparing columns_priv table CL Installing all prepared tables CL At this point the script locks at this point won't go any further. CL This happens when the binary runs it automatically after running the RPM, or CL just trying to run it by hand. CL I am using CL MySQL-3.23.49a-1.i386.rpm CL MySQL-client-3.23.49a-1.i386.rpm CL Red Hat Linux version 2.2.16-22 CL I also pulled the sources down installed them, compiled ran them CL same thing! Chris, which version of RedHat do you use on what kind of hardware? CL Anybody have any ideas - I'm starting to loose hope! CL Thanks! CL Chris -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Char set Win1250
Thank you for your help, but I know that I must compile kernel (mysqld) with this char set. But, this I can do with Unix (or Linux, etc.). What can I do with kernel for Win32? Is any mysqld with char set win1250 compiled in? Or must I download any other version of MySQL? And which version (where is win1250 compiled in)? Thank you Pavel Zaklasnik PS: Apologize me for my bad english. -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 1:50 PM To: [EMAIL PROTECTED] Subject: Re: Char set Win1250 Pavel, Wednesday, April 10, 2002, 9:48:18 AM, you wrote: PZ I have simple question.I have installed on my computer WinNT 4.0, Apache 1.3.14, PHP4 (4.0.4pl1), MySQL MAX 4.0.1. There's problem with char set win1250. I don't know how can I link this char PZ set. Script with this row $spojeni = MySQL_Connect(localhost); sends an error Warning: MySQL Connection Failed: Can't initialize character set 26 (path: default) in c:/program files/apache PZ group/apache/htdocs/tellib.php on line 84. (Char set 26 is Win1250). Does anybody know, how can I link char-set Win1250 in Win32 system to PHP4 and MySQL? In PHP3 works everything properly. This error occurs if mysqld is compiled without this character set. You can find descriptions of errors at: http://www.mysql.com/doc/C/a/Cannot_initialize_character_set.html PZ Pavel Zaklasnik PZ Czech Republic -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Odchoz zprva neobsahuje viry. Zkontrolovno antivirovm systmem AVG (http://www.grisoft.cz). Verze: 6.0.320 / Virov bze: 179 - datum vydn: 30.1.2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Difficulties between OS versions
At 07:55 10-04-02 -0500, Lee, Tom J wrote: When we tried to install the same software on a SUN Sparc 20 running Solaris 2.6 errors were encountered. Something about a missing file 'librt.so.1'. We thought the OS version was 2.7. Not correct! I downloaded the binary MySQL version 3.22.32 from the archive area on the website and it installed. However, the same 4 tables that are working under Solaris 2.8 are presenting errors under Solaris 2.6. The error message states that there is no field information available for any of the 4 tables. Am I doing something wrong. If I'm not mistaken, binaries are only available for Solaris 2.7 and up. If you want to run on Solaris 2.6, you'll need to compile from the sources. I've gone through several versions running on a Sparc 20 under Solaris 2.6 without any issues or problems building. Eugene -- - Eugene Mah, M.Sc., DABR [EMAIL PROTECTED] Medical Physicist/Misplaced Canuck[EMAIL PROTECTED] Department of Radiology For I am a Bear of Very Little Medical University of South Carolina Brain, and long words Bother Charleston, South Carolina me. Winnie the Pooh http://home.netcom.com/~eugenem/ PGP KeyID = 0x1F9779FD, 0x319393F4 PGP keys available on request ICQ 3113529 O- - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 with German umlauts
Today I have used MM.MySQL-2.0.12 and noticed, that German umlauts are represented as ?. In MM.MySQL-2.0.7 everything was all right there. Volker - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 and Mysql...
Hi again... When I felt proud because last week I had asked about how to use NOW(), and get answer that got me working, but now I have a strange problem. It listing dates, but it not listing like it should, when the web page is create it going 9, 8, 5, 10 on the dates. Here is the SQL statement I am using... SELECT DATE_FORMAT(DATE, '%M %D, %Y') AS DATE, Title, Links, Summary FROM news WHERE TO_DAYS(NOW()) - TO_DAYS(DATE) =5 ORDER BY DATE DESC Another problem I am having with another statement. The following statement should list birthdays that are 7 days out but it not... SELECT DATE_FORMAT(DOB, '%M %D, %Y') as DOB, Fname, Lname, Email FROM emply_info WHERE (TO_DAYS(DOB) - TO_DAYS(NOW())) =5 AND (TO_DAYS(DOB) = TO_DAYS(NOW())) and Tdate is NULL and DOB is not null ORDER BY DOB, Lname Any clue why my SQL statement worked once are now not working? Thanks a head of time. Chuck Payne Magi Design and Support - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Char vs Varchar field types
Hi everyone, When is it appropriate to use Char instead of Varchar and vice versa? Thanks Luke mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysqld as service
Hi How can i deinstall the mysqld as a service? Thx for help mfg Ely Van Kenobi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Char vs Varchar field types
[EMAIL PROTECTED] wrote: When is it appropriate to use Char instead of Varchar and vice versa? Use char when you expect the length of the field to always be the same. Use varchar when you're not sure. Basically, when you're using varchar you're assigning a limit to the size of the string that can be put into the field, whereas with char you're saying that the string will always be exactly X characters long. So, for instance, it would be appropriate to store serial numbers as char, since most likely they will include alphabetical characters and will always be exactly the same length. And it would be more appropriate to store the name of the hardware component as a varchar, since that would be a different length for each record. Also: query, query, sql. Blasted filter. -- John Klein, Database Applications Developer | Omnia Mutantur, Systems Group - Harvard Law School | Nihil Interit - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Char vs Varchar field types
Hi Luke, When is it appropriate to use Char instead of Varchar and vice versa? Use CHAR for when you know in advance how many characters are going to be in that field. A good example is for MD5 hashes: they are always 32 characters long, so you can use CHAR(32). Use VARCHAR for when you don't know - names, addresses, etc. Cheers Jon mysql aol / - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Mysqld as service
At 16:41 +0200 4/10/02, Elyasin Shaladi wrote: Hi How can i deinstall the mysqld as a service? Thx for help Shut down the server, then issue this command: mysqld --remove mfg Ely Van Kenobi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Char vs Varchar field types
Luke, Wednesday, April 10, 2002, 4:18:48 PM, you wrote: LvB When is it appropriate to use Char instead of Varchar and vice versa? CHAR column type has fixed length, VARCHAR is variable-length string. CHAR column type appropriate to use when you have data with the same length. Don't forget that in the some cases CHAR may be changed to VARCHAR, look at: http://www.mysql.com/doc/S/i/Silent_column_changes.html LvB Thanks LvB Luke -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Re: gui
HITESH, Wednesday, April 10, 2002, 2:29:23 PM, you wrote: HP i installed the client and server files (rpm) HP of MYSql for linux , but failed to get the gui working. HP could you please help me in this regards. What exactly doesn't work? Is it a failure to start MySQLGUI or to connect to the MySQL server or something else? HP thanking you HP hitesh patel -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Fw: mysql_install_db still locking :-(
Chris, Wednesday, April 10, 2002, 2:01:05 PM, you wrote: Egor, I'm running : Red Hat Linux release 7.0 (Guinness) on a Pentium III 450 with 128 meg of Ram. Are you thinking I may need to run an older version of Mysql? Well, this looks very weird to me. The configuation is plain and this is the most common situation, but I haven't heard of problems like this. Can you reinstall Red Hat from scratch and try again?.. Thanks for the reply! Chris Chris, Tuesday, April 09, 2002, 3:22:00 PM, you wrote: CL Still having this trouble with mysql.. Running the mysql_install_db renders CL this... CL Preparing db table CL Preparing host table CL Preparing user table CL Preparing func table CL Preparing tables_priv table CL Preparing columns_priv table CL Installing all prepared tables CL At this point the script locks at this point won't go any further. CL This happens when the binary runs it automatically after running the RPM, or CL just trying to run it by hand. CL I am using CL MySQL-3.23.49a-1.i386.rpm CL MySQL-client-3.23.49a-1.i386.rpm CL Red Hat Linux version 2.2.16-22 CL I also pulled the sources down installed them, compiled ran them CL same thing! Chris, which version of RedHat do you use on what kind of hardware? CL Anybody have any ideas - I'm starting to loose hope! CL Thanks! CL Chris -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
select query optimization
i have been working on getting this query as fast as possible and figured it was time to come to the mailing list. the below table currently holds about 43 thousand records with potential to grow to around 1,000,000 records. CREATE TABLE `RADPOOL` ( `id` int(11) NOT NULL auto_increment, `STATE` tinyint(4) default NULL, `TIME_STAMP` int(11) NOT NULL default '0', `EXPIRY` int(11) default NULL, `USERNAME` char(35) default NULL, `POOL` char(20) NOT NULL default '', `YIADDR` char(15) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `RADPOOL_I` (`YIADDR`), KEY `RADPOOL_I2` (`POOL`), KEY `RADPOOL_I3` (`STATE`), KEY `RADPOOL_I4` (`TIME_STAMP`) ); the query below becomes slow when I added the ORDER BY clause to it. select TIME_STAMP, YIADDR from RADPOOL where STATE=0 and POOL='GLOBAL-POOL-SJC' ORDER BY TIME_STAMP limit 1; the output received from the mysql client is 1 row in set (0.09 sec) is there a way to speed this query up when using the ORDER BY? thanks in advance, katen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Char vs Varchar field types
It depends on who you talk to and what you want to do. varchar will use less disk space, but char is faster to access (except for InnoDB tables, where varchar has the advantage). The benefit is using char is that the rows have a fixed length so MySQL knows exactly where each row starts and can find it easier when searching on an index. But, if you have just 1 dynamic field (like a varchar), then you might as well have them all varchars, because the row length is no longer fixed. On Wednesday, April 10, 2002, at 08:18 AM, Luke van Blerk wrote: Hi everyone, When is it appropriate to use Char instead of Varchar and vice versa? Thanks Luke David Felio Software Developer Information Network of Arkansas http://www.AccessArkansas.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Date and Mysql...
Hi again... Hi, When I felt proud because last week I had asked about how to use NOW(), and get answer that got me working, but now I have a strange problem. It listing dates, but it not listing like it should, when the web page is create it going 9, 8, 5, 10 on the dates. Here is the SQL statement I am using... SELECT DATE_FORMAT(DATE, '%M %D, %Y') AS DATE, Title, Links, Summary FROM news WHERE TO_DAYS(NOW()) - TO_DAYS(DATE) =5 ORDER BY DATE DESC Date_format returns a string, so 10 is indeed below 5. You could try something like Another problem I am having with another statement. The following statement should list birthdays that are 7 days out but it not... SELECT DATE_FORMAT(DOB, '%M %D, %Y') as DOB, Fname, Lname, Email FROM emply_info WHERE (TO_DAYS(DOB) - TO_DAYS(NOW())) =5 AND (TO_DAYS(DOB) = TO_DAYS(NOW())) and Tdate is NULL and DOB is not null ORDER BY DOB, Lname Any clue why my SQL statement worked once are now not working? Thanks a head of time. Chuck Payne Magi Design and Support - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Date and Mysql...
Your alias and column name are the same. Which one do you think is being tested? Also DATE is a reserved word. Chuck \PUP\ Payne wrote: Hi again... When I felt proud because last week I had asked about how to use NOW(), and get answer that got me working, but now I have a strange problem. It listing dates, but it not listing like it should, when the web page is create it going 9, 8, 5, 10 on the dates. Here is the SQL statement I am using... SELECT DATE_FORMAT(DATE, '%M %D, %Y') AS DATE, Title, Links, Summary FROM news WHERE TO_DAYS(NOW()) - TO_DAYS(DATE) =5 ORDER BY DATE DESC Another problem I am having with another statement. The following statement should list birthdays that are 7 days out but it not... SELECT DATE_FORMAT(DOB, '%M %D, %Y') as DOB, Fname, Lname, Email FROM emply_info WHERE (TO_DAYS(DOB) - TO_DAYS(NOW())) =5 AND (TO_DAYS(DOB) = TO_DAYS(NOW())) and Tdate is NULL and DOB is not null ORDER BY DOB, Lname Any clue why my SQL statement worked once are now not working? Thanks a head of time. Chuck Payne Magi Design and Support - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Char vs Varchar field types
also, note that char is changed to varchar in some cases, such as when there is a text field in the table. -Original Message- From: Jon Haworth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 10:40 AM To: 'Luke van Blerk'; [EMAIL PROTECTED] Subject: RE: Char vs Varchar field types Hi Luke, When is it appropriate to use Char instead of Varchar and vice versa? Use CHAR for when you know in advance how many characters are going to be in that field. A good example is for MD5 hashes: they are always 32 characters long, so you can use CHAR(32). Use VARCHAR for when you don't know - names, addresses, etc. Cheers Jon mysql aol / - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
FW: Date and Mysql... (now complete)
(one should not mess up strg and shift :-/) Hi again... Hi, When I felt proud because last week I had asked about how to use NOW(), and get answer that got me working, but now I have a strange problem. It listing dates, but it not listing like it should, when the web page is create it going 9, 8, 5, 10 on the dates. Here is the SQL statement I am using... SELECT DATE_FORMAT(DATE, '%M %D, %Y') AS DATE, Title, Links, Summary FROM news WHERE TO_DAYS(NOW()) - TO_DAYS(DATE) =5 ORDER BY DATE DESC Date_format returns a string, so 10 is indeed below 5. You could try something like SELECT DATE, DATE_FORMAT(DATE, '%M %D, %Y') AS DATE2, Title, Links, Summary FROM news WHERE TO_DAYS(NOW()) - TO_DAYS(DATE) =5 ORDER BY DATE DESC Another problem I am having with another statement. The following statement should list birthdays that are 7 days out but it not... SELECT DATE_FORMAT(DOB, '%M %D, %Y') as DOB, Fname, Lname, Email FROM emply_info WHERE (TO_DAYS(DOB) - TO_DAYS(NOW())) =5 AND (TO_DAYS(DOB) = TO_DAYS(NOW())) and Tdate is NULL and DOB is not null ORDER BY DOB, Lname Similar thing. Date_format(NULL, '%M %D, %Y') should return 00 00, 00, iirc, and thus is not NULL even if your date column is. SELECT DOB, DATE_FORMAT(DOB, '%M %D, %Y') as DOB2, Fname, Lname, Email FROM emply_info WHERE (TO_DAYS(DOB) - TO_DAYS(NOW())) =5 AND (TO_DAYS(DOB) = TO_DAYS(NOW())) and Tdate is NULL and DOB is not null ORDER BY DOB, Lname Any clue why my SQL statement worked once are now not working? Thanks a head of time. Chuck Payne Magi Design and Support HTH, Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: select query optimization
i made the change, but it looks like it didn't speed the query up at all. here are the results from the first explain: mysql explain select TIME_STAMP, YIADDR from RADPOOL where STATE=0 and POOL='GLOBAL-POOL-SJC' ORDER BY TIME_STAMP limit 1; +-+--+---++-+---+--++ | table | type | possible_keys | key| key_len | ref | rows | Extra | +-+--+---++-+---+--++ | RADPOOL | ref | RADPOOL_I2,RADPOOL_I3 | RADPOOL_I2 | 20 | const | 6893 | where used; Using filesort | +-+--+---++-+---+--++ 1 row in set (0.00 sec) i made the changes to acoomodate this create statement: CREATE TABLE `RADPOOL1` ( `id` int(11) NOT NULL auto_increment, `STATE` tinyint(4) default NULL, `TIME_STAMP` int(11) NOT NULL default '0', `EXPIRY` int(11) default NULL, `USERNAME` char(35) default NULL, `POOL` char(20) NOT NULL default '', `YIADDR` char(15) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `RADPOOL_I` (`YIADDR`), INDEX ipoolstate( POOL, STATE ) ); here are the new explain results: mysql explain select TIME_STAMP, YIADDR from RADPOOL1 where STATE=0 and POOL='GLOBAL-POOL-SJC' ORDER BY TIME_STAMP limit 1; +--+--+---++-+-+--++ | table| type | possible_keys | key| key_len | ref | rows | Extra | +--+--+---++-+-+--++ | RADPOOL1 | ref | ipoolstate| ipoolstate | 22 | const,const | 6011 | where used; Using filesort | +--+--+---++-+-+--++ 1 row in set (0.00 sec) katen At 08:35 AM 4/10/2002 -0700, Lopez David E-r9374c wrote: Katen Try using a compound index with STATE and POOL INDEX ipoolstate( POOL, STATE ) Use EXPLAIN SELECT to see what mysql thinks. David PS anybody know if KEY is the same as INDEX? -Original Message- From: Steve Katen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 8:07 AM To: [EMAIL PROTECTED] Subject: select query optimization i have been working on getting this query as fast as possible and figured it was time to come to the mailing list. the below table currently holds about 43 thousand records with potential to grow to around 1,000,000 records. CREATE TABLE `RADPOOL` ( `id` int(11) NOT NULL auto_increment, `STATE` tinyint(4) default NULL, `TIME_STAMP` int(11) NOT NULL default '0', `EXPIRY` int(11) default NULL, `USERNAME` char(35) default NULL, `POOL` char(20) NOT NULL default '', `YIADDR` char(15) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `RADPOOL_I` (`YIADDR`), KEY `RADPOOL_I2` (`POOL`), KEY `RADPOOL_I3` (`STATE`), KEY `RADPOOL_I4` (`TIME_STAMP`) ); the query below becomes slow when I added the ORDER BY clause to it. select TIME_STAMP, YIADDR from RADPOOL where STATE=0 and POOL='GLOBAL-POOL-SJC' ORDER BY TIME_STAMP limit 1; the output received from the mysql client is 1 row in set (0.09 sec) is there a way to speed this query up when using the ORDER BY? thanks in advance, katen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
mysqldump doesn't write data on subsequent calls (MySql 4.0.1)
Description: I'm using Mysql 4.0.1 with query caching: set-variable = query_cache_limit=10M set-variable = query_cache_size=10M set-variable = query_cache_startup_type=1 The Command: mysqldump -q -K -t --tab='.' \ --fields-optionally-enclosed-by='' \ --fields-terminated-by=',' sched oweek The first execution of the command writes the expected data to oweek.txt. Any subsequent executions do not. This is because of query caching. I can run -- mysql -e reset query cache -- which will enable the next call to mysqldump to write data. I believe that mysqldump should write data whether query caching is enabled/disabled or not-flushed/flushed. How-To-Repeat: Execute a mysqldump command more than once. Fix: Submitter-Id: submitter ID Originator:Nick Pasich Organization: MySQL support: email support Synopsis: Problem with mysqldump when using query caching Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-4.0.1-alpha (Source distribution) Server: /usr/local/MYSQL/bin/mysqladmin Ver 8.23 Distrib 4.0.1-alpha, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 4.0.1-alpha-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /usr/local/MYSQL/mysql.sock Uptime: 13 hours 49 min 48 sec Threads: 2 Questions: 1653 Slow queries: 2 Opens: 135 Flush tables: 15 Open tables: 3 Queries per second avg: 0.033 Environment: System: Linux NICK 2.4.18-ac3 #1 Mon Mar 4 12:38:33 PST 2002 i586 unknown Architecture: i586 Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/local/GCC/gcc-2.95.3/lib/gcc-lib/i586-pc-linux-gnulibc1/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='-O3 -march=i586' CXX='gcc' CXXFLAGS='-O3 -march=i586 -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Feb 24 20:49 /lib/libc.so.4 - libc.so.4.7.6 -rwxr-xr-x1 root root 623620 Feb 26 1996 /lib/libc.so.4.5.26 -rwxr-xr-x1 bin bin634880 Aug 13 1996 /lib/libc.so.4.7.5 -rwxr-xr-x1 root wheel 634880 Apr 29 1996 /lib/libc.so.4.7.6 lrwxrwxrwx1 root root 14 Feb 24 20:49 /lib/libc.so.5 - libc.so.5.4.46 -rwxr-xr-x1 bin bin562683 Aug 12 1996 /lib/libc.so.5.0.9 -rwxr-xr-x1 bin bin558615 Apr 12 1997 /lib/libc.so.5.2.18 -rwxr-xr-x1 bin bin 1816182 Dec 6 1996 /lib/libc.so.5.4.17 -rwxr-xr-x1 bin bin 1760718 Aug 13 1996 /lib/libc.so.5.4.2 -rwxr-xr-x1 bin bin 1861963 Apr 15 1997 /lib/libc.so.5.4.23 -rwxr-xr-x1 bin bin 1868689 May 30 1997 /lib/libc.so.5.4.33 -rwxr-xr-x1 bin bin 1760174 Aug 18 1996 /lib/libc.so.5.4.4 -rwxr-xr-x1 bin bin 1874736 Feb 1 1998 /lib/libc.so.5.4.44 -rwxr-xr-x1 bin bin 1427975 Jun 20 1998 /lib/libc.so.5.4.46 -rw-r--r--1 bin bin 1131866 Jun 20 1998 /usr/lib/libc.a lrwxrwxrwx1 bin bin19 Feb 24 13:36 /usr/lib/libc.so - /lib/libc.so.5.4.46 Configure command: ./configure --enable-shared --enable-assembler --without-debug --prefix=/usr/local/MYSQL --localstatedir=/usr/local/MYSQL/DB --with-unix-socket-path=/usr/local/MYSQL/mysql.sock --with-extra-charsets=none --without-innodb - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 and Mysql...
»Chuck PUP Payne« sagte am 2002-04-10 um 10:27:19 -0400 : going 9, 8, 5, 10 on the dates. Here is the SQL statement I am using... That's because your DATE which you've made with DATE_FORMAT is treated as string. To fix it, I'd write: SELECT DATE_FORMAT(DATE, '%M %D, %Y') AS DATE, Title, Links, Summary FROM news WHERE TO_DAYS(NOW()) - TO_DAYS(DATE) =5 ORDER BY DATE DESC SELECT DATE_FORMAT(DATE, '%M %D, %Y') AS DATE_DSP, DATE, Title, Links, Summary FROM news WHERE TO_DAYS(NOW()) - TO_DAYS(DATE) =5 ORDER BY DATE DESC This way, you can display the nicely formated date in DATE_DSP and still got a good copy of date around. Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.iso-top.de | Jabber: [EMAIL PROTECTED] iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 21 hours 52 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
a little help for a beginner
Hello, where can I find a simple php to generate a default html table from a MySql table ? thanks Luigi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Deleting Duplicated Records
I am new to MySQL and I have a test database that I am playing with. Through an accident while playing around, I ended up with two identicle records in the database. I did a filter to try and change just one of them but both would come up, so I couldn't see how I was supposed to delete just one of the two records. In the end, I deleted both records and re-input the one I needed but I know that there must be a better way of doing this. Perhaps having a column in my database with a serialized, unique record number would be a way to prevent this in the future? Thanks, Jeff Flowers - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
bulk copy
Hello- I am a Sybase user with a mysql question. Does mysql do bulk copy (bcp)? Bulk copy allows a mass copy from a file a database and vice versa. I know there is mysqldump but, i am not sure if that is what i am looking for. Can anyone explain? thanks, brian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Hi, I'm trying to use the old MS Visio Modeler with mysql. I have downloaded and installed the myODBC driver and set up a DNS. But I keep getting this connection error: Can't connect to MySQL server on 'www.jsicorp.com'(10060) I set the username and password the same as what works with phpMyAdmin. Any thoughts? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 mysqldump when using query caching
Description: I'm using Mysql 4.0.1 with query caching: set-variable = query_cache_limit=10M set-variable = query_cache_size=10M set-variable = query_cache_startup_type=1 The Command: mysqldump -q -K -t --tab='.' \ --fields-optionally-enclosed-by='' \ --fields-terminated-by=',' sched oweek The first execution of the command writes the expected data to oweek.txt. Any subsequent executions do not. This is because of query caching. I can run -- mysql -e reset query cache -- which will enable the next call to mysqldump to write data. I believe that mysqldump should write data whether query caching is enabled/disabled or not-flushed/flushed. How-To-Repeat: Execute a mysqldump command more than once. Fix: Submitter-Id: submitter ID Originator:Nick Pasich Organization: MySQL support: email support Synopsis: Problem with mysqldump when using query caching Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-4.0.1-alpha (Source distribution) Server: /usr/local/MYSQL/bin/mysqladmin Ver 8.23 Distrib 4.0.1-alpha, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 4.0.1-alpha-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /usr/local/MYSQL/mysql.sock Uptime: 13 hours 49 min 48 sec Threads: 2 Questions: 1653 Slow queries: 2 Opens: 135 Flush tables: 15 Open tables: 3 Queries per second avg: 0.033 Environment: System: Linux NICK 2.4.18-ac3 #1 Mon Mar 4 12:38:33 PST 2002 i586 unknown Architecture: i586 Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/local/GCC/gcc-2.95.3/lib/gcc-lib/i586-pc-linux-gnulibc1/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='-O3 -march=i586' CXX='gcc' CXXFLAGS='-O3 -march=i586 -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Feb 24 20:49 /lib/libc.so.4 - libc.so.4.7.6 -rwxr-xr-x1 root root 623620 Feb 26 1996 /lib/libc.so.4.5.26 -rwxr-xr-x1 bin bin634880 Aug 13 1996 /lib/libc.so.4.7.5 -rwxr-xr-x1 root wheel 634880 Apr 29 1996 /lib/libc.so.4.7.6 lrwxrwxrwx1 root root 14 Feb 24 20:49 /lib/libc.so.5 - libc.so.5.4.46 -rwxr - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Mysqld as service
mysqld --remove use mysqld --help for more info. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 3:41 PM To: MySQL-Mailingliste Subject: Mysqld as service Hi How can i deinstall the mysqld as a service? Thx for help mfg Ely Van Kenobi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Deleting Duplicated Records
You are 100% correct. Since MySQL does not support cursors, I always put an auto_increment column in my tables for just this purpose. (This is what other DBMS' do, they just do it behind your back) Unfortunately, the way MySQL really handles result sets doesn't lend itself to simply adding a hidden auto_increment field to each row to act as a cursor and allow updating of rows in result sets. If it did, then I'm sure they would have put cursor support in the product already. Ken -Original Message- From: Jeffrey Flowers [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 11:16 AM To: [EMAIL PROTECTED] Subject: Deleting Duplicated Records I am new to MySQL and I have a test database that I am playing with. Through an accident while playing around, I ended up with two identicle records in the database. I did a filter to try and change just one of them but both would come up, so I couldn't see how I was supposed to delete just one of the two records. In the end, I deleted both records and re-input the one I needed but I know that there must be a better way of doing this. Perhaps having a column in my database with a serialized, unique record number would be a way to prevent this in the future? Thanks, Jeff Flowers - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Mysqld as service
Try mysqld --remove From the MySQL\bin directory. I assume you mean a service on NT Alternatively you can just stop the service in MMC and set it to manual so it never starts. But I'm guessing this isn't what you want Let me know -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 10 April 2002 15:41 To: MySQL-Mailingliste Subject: Mysqld as service Hi How can i deinstall the mysqld as a service? Thx for help mfg Ely Van Kenobi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Deleting Duplicated Records
You are 100% correct. Since MySQL does not support cursors, I always put an auto_increment column in my tables for just this purpose. (This is what other DBMS' do, they just do it behind your back) You're right. I use DBase IV at work and every record has an internal record number. Unfortunately, the way MySQL really handles result sets doesn't lend itself to simply adding a hidden auto_increment field to each row to act as a cursor and allow updating of rows in result sets. If it did, then I'm sure they would have put cursor support in the product already. Ken Thanks for the help. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Stability of 4.0.1
Can anyone comment on the stability of the current 4.x MySQL release. I'd be using MyISAM tables and only features which are currently available in the 3.23.x series. -- do svidaniya, ~mitch - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: select query optimization
Katen The manual has a section on optimization. If you have done deletes on this table, the table may not be optimized. Try: OPTIMIZE TABLE RADPOOL1 It does lock the table while doing it. Other than that, I don't know what else to do. David -Original Message- From: Steve Katen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 8:47 AM To: Lopez David E-r9374c; [EMAIL PROTECTED] Subject: RE: select query optimization i made the change, but it looks like it didn't speed the query up at all. here are the results from the first explain: mysql explain select TIME_STAMP, YIADDR from RADPOOL where STATE=0 and POOL='GLOBAL-POOL-SJC' ORDER BY TIME_STAMP limit 1; +-+--+---++-+---+--++ | table | type | possible_keys | key| key_len | ref | rows | Extra | +-+--+---++-+---+--++ | RADPOOL | ref | RADPOOL_I2,RADPOOL_I3 | RADPOOL_I2 | 20 | const | 6893 | where used; Using filesort | +-+--+---++-+---+--++ 1 row in set (0.00 sec) i made the changes to acoomodate this create statement: CREATE TABLE `RADPOOL1` ( `id` int(11) NOT NULL auto_increment, `STATE` tinyint(4) default NULL, `TIME_STAMP` int(11) NOT NULL default '0', `EXPIRY` int(11) default NULL, `USERNAME` char(35) default NULL, `POOL` char(20) NOT NULL default '', `YIADDR` char(15) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `RADPOOL_I` (`YIADDR`), INDEX ipoolstate( POOL, STATE ) ); here are the new explain results: mysql explain select TIME_STAMP, YIADDR from RADPOOL1 where STATE=0 and POOL='GLOBAL-POOL-SJC' ORDER BY TIME_STAMP limit 1; +--+--+---++-+-+--++ | table| type | possible_keys | key| key_len | ref | rows | Extra | +--+--+---++-+-+--++ | RADPOOL1 | ref | ipoolstate| ipoolstate | 22 | const,const | 6011 | where used; Using filesort | +--+--+---++-+-+--++ 1 row in set (0.00 sec) katen At 08:35 AM 4/10/2002 -0700, Lopez David E-r9374c wrote: Katen Try using a compound index with STATE and POOL INDEX ipoolstate( POOL, STATE ) Use EXPLAIN SELECT to see what mysql thinks. David PS anybody know if KEY is the same as INDEX? -Original Message- From: Steve Katen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 8:07 AM To: [EMAIL PROTECTED] Subject: select query optimization i have been working on getting this query as fast as possible and figured it was time to come to the mailing list. the below table currently holds about 43 thousand records with potential to grow to around 1,000,000 records. CREATE TABLE `RADPOOL` ( `id` int(11) NOT NULL auto_increment, `STATE` tinyint(4) default NULL, `TIME_STAMP` int(11) NOT NULL default '0', `EXPIRY` int(11) default NULL, `USERNAME` char(35) default NULL, `POOL` char(20) NOT NULL default '', `YIADDR` char(15) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `RADPOOL_I` (`YIADDR`), KEY `RADPOOL_I2` (`POOL`), KEY `RADPOOL_I3` (`STATE`), KEY `RADPOOL_I4` (`TIME_STAMP`) ); the query below becomes slow when I added the ORDER BY clause to it. select TIME_STAMP, YIADDR from RADPOOL where STATE=0 and POOL='GLOBAL-POOL-SJC' ORDER BY TIME_STAMP limit 1; the output received from the mysql client is 1 row in set (0.09 sec) is there a way to speed this query up when using the ORDER BY? thanks in advance, katen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Lasso to mysql
I'm trying to connect to mysql using lasso but no success. The message I get is that there are no databases found. Our environment is mysql 3.23.49 on osx server 10.1.3 and lasso 5 What do I need to do to connect to mysql from lasso? Also, how do I start a deamon at boot? Thanks Juan M. Quiroz Oregon Department of Agriculture Systems Analyst [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
Core dump when execute safe_mysqld
Description: I have downloaded a binary version of mysql, perform all installations steps from the manual. As soon as I started to execute safe_mysqld --user=mysql I got a core dump and the program exited. Please help How-To-Repeat: Fix: Submitter-Id: Truc Tran Originator:[EMAIL PROTECTED] Organization: Salt Lake Community College MySQL support: [none | licence | email support | extended email support ] Synopsis: Can't start safe_mysqld Severity: Priority: Category: mysql Class: Release: mysql-3.23.39 (Official MySQL binary) Environment: System: SunOS Ereserve 5.8 Generic_108529-14 i86pc i386 i86pc Architecture: i86pc Some paths: /usr/bin/perl /usr/local/bin/gcc /usr/ucb/cc GCC: Reading specs from /usr/local/lib/gcc-lib/i386-pc-solaris2.8/3.0/specs Configured with: ../configure --disable-nls --disable-libgcj --enable-languages=c++,f77,objc --with-gnu-as --with-gnu-ld Thread model: posix gcc version 3.0 Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: -rw-r--r-- 1 root bin 1592140 Apr 3 12:14 /lib/libc.a lrwxrwxrwx 1 root root 11 Apr 4 09:13 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 944552 Apr 3 12:14 /lib/libc.so.1 -rw-r--r-- 1 root bin 1592140 Apr 3 12:14 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Apr 4 09:13 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 944552 Apr 3 12:14 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --disable-shared Perl: This is perl, version 5.005_03 built for i86pc-solaris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with mysqldump when using query caching
Hi Nick, I am seeing some rather strange problem here with mysqldump, after trying very hard to reproduce the problem on a test server, I gave up. Do the options make any difference when you run it? Can you send a trace of the actual dump? I was seeing mysqldump terminate in my case, now it just seems to loop, and I am not sure why the behavior changed. If we could reproduce this reliably maybe we could get a fix! Can you do this everytime? Ken - Original Message - From: Nick Pasich [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 10, 2002 12:27 PM Subject: Problem with mysqldump when using query caching Description: I'm using Mysql 4.0.1 with query caching: set-variable = query_cache_limit=10M set-variable = query_cache_size=10M set-variable = query_cache_startup_type=1 The Command: mysqldump -q -K -t --tab='.' \ --fields-optionally-enclosed-by='' \ --fields-terminated-by=',' sched oweek The first execution of the command writes the expected data to oweek.txt. Any subsequent executions do not. This is because of query caching. I can run -- mysql -e reset query cache -- which will enable the next call to mysqldump to write data. I believe that mysqldump should write data whether query caching is enabled/disabled or not-flushed/flushed. How-To-Repeat: Execute a mysqldump command more than once. Fix: Submitter-Id: submitter ID Originator: Nick Pasich Organization: MySQL support: email support Synopsis: Problem with mysqldump when using query caching Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-4.0.1-alpha (Source distribution) Server: /usr/local/MYSQL/bin/mysqladmin Ver 8.23 Distrib 4.0.1-alpha, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 4.0.1-alpha-log Protocol version 10 Connection Localhost via UNIX socket UNIX socket /usr/local/MYSQL/mysql.sock Uptime: 13 hours 49 min 48 sec Threads: 2 Questions: 1653 Slow queries: 2 Opens: 135 Flush tables: 15 Open tables: 3 Queries per second avg: 0.033 Environment: System: Linux NICK 2.4.18-ac3 #1 Mon Mar 4 12:38:33 PST 2002 i586 unknown Architecture: i586 Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/local/GCC/gcc-2.95.3/lib/gcc-lib/i586-pc-linux-gnulibc1/2.95.3/sp ecs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='-O3 -march=i586' CXX='gcc' CXXFLAGS='-O3 -march=i586 -felide-constructors -fno-exceptions -fno-rt ti' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Feb 24 20:49 /lib/libc.so.4 - libc.so.4.7.6 -rwxr-xr-x1 root root 623620 Feb 26 1996 /lib/libc.so.4.5.26 -rwxr-xr-x1 bin bin634880 Aug 13 1996 /lib/libc.so.4.7.5 -rwxr-xr-x1 root wheel 634880 Apr 29 1996 /lib/libc.so.4.7.6 lrwxrwxrwx1 root root 14 Feb 24 20:49 /lib/libc.so.5 - libc.so.5.4.46 -rwxr - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Home Uses
I have started using MySQL because I want to learn about something new and to keep a database of my growing comic book collection, which would be handy should something should ever happen to them. In doing this, I have started to think of other ways to use MySQL, such as managing my CD collection and other such things. What I would like to hear is how other people are putting MySQL to work in their home environment. I searched Google for this but turned up nothing, and hearing about what other people are doing often motivates me. If you don't want to reply on list, feel free to email me instead. Thanks in advance, Jeff Flowers [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: Deleting Duplicated Records
On 10 Apr 2002, at 12:16, Jeffrey Flowers wrote: Perhaps having a column in my database with a serialized, unique record number would be a way to prevent this in the future? That would allow you to delete just one of the duplicates (which you also do with LIMIT 1 on your DELETE query), but it might be better to avoid inserting the duplicates in the first place. You could define a unique index on whatever combination of columns must be unique for a record (which in most tables is not going to be all the columns). -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Home Uses
On Wed, Apr 10, 2002 at 01:41:30PM -0400, Jeffrey Flowers wrote: I have started using MySQL because I want to learn about something new and to keep a database of my growing comic book collection, which would be handy should something should ever happen to them. In doing this, I have started to think of other ways to use MySQL, such as managing my CD collection and other such things. What I would like to hear is how other people are putting MySQL to work in their home environment. I searched Google for this but turned up nothing, and hearing about what other people are doing often motivates me. If you don't want to reply on list, feel free to email me instead. Here's one use I have at home: http://jeremy.zawodny.com/music/ As you can see, it's pretty similar to one of your ideas. :-) I also use MySQL to store the data for: http://jeremy.zawodny.com/journal/ Which is also pretty common, I guess. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 62 days, processed 1,680,279,226 queries (312/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: Stability of 4.0.1
On Wed, Apr 10, 2002 at 10:06:47AM -0700, [EMAIL PROTECTED] wrote: Can anyone comment on the stability of the current 4.x MySQL release. I'd be using MyISAM tables and only features which are currently available in the 3.23.x series. For my purposes, the 4.0.x builds I've used are just as stable as 3.23.xx if you ignore replication. 4.0.x replication has been a little funky but appears to have improved in the latest builds. So if you need replication, I'd recommend building your own 4.0.x from MySQL's BitKeeper tree. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 62 days, processed 1,680,304,183 queries (312/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
Mysql and Quoted Identifiers
Hi, I'm using MySQL version 3.23.37 which works fine. However I am currently trying to convert a MS Access database to MySQL and some of the column names have embedded spaces i.e. First Name. Now according to the manual MySQL supports quoting of identifiers (for the above reason), I cannot get it to work though. MySQL is installed on Linux, and if I try to enter the following create table statement to the MySQL client, it objects to the first quote (either double or single quotes). CREATE TABLE TEST ('ID' INTEGER); while CREATE TABLE TEST (ID INTEGER); works as expected. I must be doing something stupid :), but I can't see it. Nick Read - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: slow to a crawl
Hi. Well, your are right, indexes are not used at all, so ignore everything about key_buffer and indexes I said, regarding this issue (but key_buffer=16MG seems small with 1GB anyhow ;-) Depending on how often you need the query, and how much columns are involved, you may want to consider to add a key over all involved columns, which would avoid reading the data file, but read the smaller key only, instead (if it's not clear why that would help, see the EXPLAIN link below and search for the explanation of using index). Hm. From vmstat output it looks like the second query is disk-bound on writing. Most probably writing temporary table(s) as EXPLAIN tells so (compare http://www.mysql.com/doc/E/X/EXPLAIN.html). http://www.mysql.com/doc/T/e/Temporary_files.html tells, for sorting in GROUP BY, the maximum needed disk space is: (length of what is sorted + sizeof(database pointer)) * number of matched rows * 2 So if the first query needs about 5MB (~31000 rows), the second one needs about 30 times of that, namely 150MB (~100 rows). If your columns are larger (I presumed about 20 bytes above), it gets worse. From the vmstat output I guess this is rather ~25MB resp. ~650MB for your case (of course, that is only a very rough guess). tmp_table_size determines the maximum size of an in-memory temporary table. If a table gets bigger, it automatically converts it to a disk table. I don't know whether the sorting table for GROUP BY qualifies for an in-memory table, but how about setting (at least temporarily) tmp_table_size to a real huge value (say 500MB) and re-run the queries and look at the vmstat output. bo should be real small at least for the first query, if in-memory tables are used. Well, to sum up: Your first query mainly seems to be bound on disk read speed (your table is about 1GB?). The second one needs a much larger tmp table (which it also has to sort!) and trashes your disk, that's probably why the machine feels unresponsive. For now, I have no further ideas than playing with tmp_table_size and trying to use an index over all column. Anybody else? Bye, Benjamin. On Tue, Apr 09, 2002 at 09:09:30PM -0400, [EMAIL PROTECTED] wrote: Benjamin Pflugmann [EMAIL PROTECTED] writes: [...] 1 gig, plenty free. If I am not mistaken, sort_buffer/tmp_table_size are the one mostly needed for this query, I think. Btw, you can get more info about the query with EXPLAIN. Please post the result of it (for both SELECTs), if you answer. Query 1, works: group by bayid, ds1 table typepossible_keys key key_len ref rowsExtra detail_20020408 ALL NULLNULLNULLNULL13083666Using temporary Query 2, bad: group by bayid, ds1, scid table typepossible_keys key key_len ref rowsExtra detail_20020408 ALL NULLNULLNULLNULL13083666Using temporary [...] Btw, please always post what you observe, e.g. the vmstat output. Maybe someone on the list can see something you didn't. Query 1: procs memoryswap io system cpu r b w swpd free buff cache si sobibo incs us sy id 2 0 0492 5096 91104 836764 0 0 10472 714 1729 3297 40 6 54 1 0 0492 5096 91104 836744 0 0 11220 0 1220 2609 49 5 46 0 1 0492 5096 91104 836728 0 0 10392 736 1599 3259 42 7 50 [...] Query 2: procs memoryswap io system cpu r b w swpd free buff cache si sobibo incs us sy id 0 2 1492 5092 91168 834420 0 0 9734 8382 1950 3270 60 15 25 2 1 1492 5092 91168 833448 0 0 10476 164 1705 2571 45 7 47 2 1 1492 5092 91172 833172 0 0 13100 6382 1536 2897 78 18 3 [...] -- [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: prefix
I guess make install prefix=/home/turner/mysql/test just isn't an option. How would I request this functionality be provided in the make file? Thanks, Dave Turner On Tue, Apr 09, 2002 at 05:45:04PM -0700, David Turner wrote: Thanks, but what I need to do is have make install install everything into /home/turner/mysql/test then I'll check everything out to make sure it is how I want it and last I'll copy it all to /usr/local. Any way to do this ./configure --prefix=/usr/local (default) make make install prefix=/home/turner/mysql/test Thanks, Dave On Tue, Apr 09, 2002 at 05:41:08PM -0700, Jeremy Zawodny wrote: On Tue, Apr 09, 2002 at 05:30:06PM -0700, David Turner wrote: I would like to make install to my home directory but can't seem to get it to work. make install prefix=/home/turner/mysql/test It keeps wanting to install to /usr/local even though I pass the prefix parm. ./configure --prefix=/home/turner/mysql/test make make install Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 61 days, processed 1,654,532,924 queries (311/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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Quoted Identifiers
ANSI92 states that quoted identifiers are delimited by double quotes -Original Message- From: Nicholas A Read [EMAIL PROTECTED] To: [EMAIL PROTECTED] Date: Wed, 10 Apr 2002 19:39:52 +0100 Subject: Mysql and Quoted Identifiers Hi, I'm using MySQL version 3.23.37 which works fine. However I am currently trying to convert a MS Access database to MySQL and some of the column names have embedded spaces i.e. First Name. Now according to the manual MySQL supports quoting of identifiers (for the above reason), I cannot get it to work though. MySQL is installed on Linux, and if I try to enter the following create table statement to the MySQL client, it objects to the first quote (either double or single quotes). CREATE TABLE TEST ('ID' INTEGER); while CREATE TABLE TEST (ID INTEGER); works as expected. I must be doing something stupid :), but I can't see it. Nick Read - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: select query optimization
Hi. (I am replying to the wrong mail, because I already delete the one from Steve...) The slow part is probably the using filesort. I am not sure, if it will work, but try a key over all used column, i.e. INDEX ( POOL, STATE, TIMESTAMP ) If it works (i.e. if MySQL correctly sees that it can skip the filesort), EXPLAIN should show something like using index instead of using filesort and the query run a lot faster again. Bye, Benjamin. PS: And to answer the other question, yes INDEX and KEY are synonyms in MySQL (see http://www.mysql.com/doc/C/R/CREATE_TABLE.html). [...] -Original Message- From: Steve Katen [mailto:[EMAIL PROTECTED]] [...] i made the change, but it looks like it didn't speed the query up at all. [...] here are the new explain results: mysql explain select TIME_STAMP, YIADDR from RADPOOL1 where STATE=0 and POOL='GLOBAL-POOL-SJC' ORDER BY TIME_STAMP limit 1; +--+--+---++-+-+--++ | table| type | possible_keys | key| key_len | ref | rows | Extra | +--+--+---++-+-+--++ | RADPOOL1 | ref | ipoolstate| ipoolstate | 22 | const,const | 6011 | where used; Using filesort | +--+--+---++-+-+--++ 1 row in set (0.00 sec) At 08:35 AM 4/10/2002 -0700, Lopez David E-r9374c wrote: Katen Try using a compound index with STATE and POOL INDEX ipoolstate( POOL, STATE ) Use EXPLAIN SELECT to see what mysql thinks. David PS anybody know if KEY is the same as INDEX? [...] -- [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: a little help for a beginner
http://www.php.net/links.php Mike - Original Message - From: Luigi Stefano Sona [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 10, 2002 12:12 PM Subject: a little help for a beginner Hello, where can I find a simple php to generate a default html table from a MySql table ? thanks Luigi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: select query optimization
ben, I did that about three minutes after I got Davids email. Things seem to be working a lot faster now, and the using filesort is gone. i am assuming there isn't much more i can do to make this thing faster, but anything else i can do would be awesome! heres is the explain: mysql explain select TIME_STAMP, YIADDR from RADPOOL where STATE=0 and POOL='GLOBAL-POOL-SMF' order by TIME_STAMP limit 1; +-+--+---++-+-+--++ | table | type | possible_keys | key| key_len | ref | rows | Extra | +-+--+---++-+-+--++ | RADPOOL | ref | ipoolstate| ipoolstate | 22 | const,const | 9416 | where used | +-+--+---++-+-+--++ 1 row in set (0.00 sec) thanks for your response! =) katen At 08:48 PM 4/10/2002 +0200, Benjamin Pflugmann wrote: Hi. (I am replying to the wrong mail, because I already delete the one from Steve...) The slow part is probably the using filesort. I am not sure, if it will work, but try a key over all used column, i.e. INDEX ( POOL, STATE, TIMESTAMP ) If it works (i.e. if MySQL correctly sees that it can skip the filesort), EXPLAIN should show something like using index instead of using filesort and the query run a lot faster again. Bye, Benjamin. PS: And to answer the other question, yes INDEX and KEY are synonyms in MySQL (see http://www.mysql.com/doc/C/R/CREATE_TABLE.html). [...] -Original Message- From: Steve Katen [mailto:[EMAIL PROTECTED]] [...] i made the change, but it looks like it didn't speed the query up at all. [...] here are the new explain results: mysql explain select TIME_STAMP, YIADDR from RADPOOL1 where STATE=0 and POOL='GLOBAL-POOL-SJC' ORDER BY TIME_STAMP limit 1; +--+--+---++-+-+--++ | table| type | possible_keys | key| key_len | ref | rows | Extra | +--+--+---++-+-+--++ | RADPOOL1 | ref | ipoolstate| ipoolstate | 22 | const,const | 6011 | where used; Using filesort | +--+--+---++-+-+--++ 1 row in set (0.00 sec) At 08:35 AM 4/10/2002 -0700, Lopez David E-r9374c wrote: Katen Try using a compound index with STATE and POOL INDEX ipoolstate( POOL, STATE ) Use EXPLAIN SELECT to see what mysql thinks. David PS anybody know if KEY is the same as INDEX? [...] -- [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: Mysql and Quoted Identifiers
Hi. You have to use backticks (`) instead of single quotes (') as in CREATE TABLE TEST (`ID` INTEGER) When MySQL has been started with --ansi, double quotes () will have the same meaning. See http://www.mysql.com/doc/L/e/Legal_names.html for more info. Bye, Benjamin. On Wed, Apr 10, 2002 at 07:39:52PM +0100, [EMAIL PROTECTED] wrote: Hi, I'm using MySQL version 3.23.37 which works fine. However I am currently trying to convert a MS Access database to MySQL and some of the column names have embedded spaces i.e. First Name. Now according to the manual MySQL supports quoting of identifiers (for the above reason), I cannot get it to work though. MySQL is installed on Linux, and if I try to enter the following create table statement to the MySQL client, it objects to the first quote (either double or single quotes). CREATE TABLE TEST ('ID' INTEGER); while CREATE TABLE TEST (ID INTEGER); works as expected. I must be doing something stupid :), but I can't see it. [...] -- [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
mysql Ver 3.23.49 installation issues with binary
Hi, I downloaded mysql Ver 3.23.49 binary to a local directory. other than (/usr/local) I changed ./bin/mysqlaccess for MySQL location, etc. but for some reason it dies as sooon as starts. I notice that some scripts and files in bin directory are pointing to /usr/local and /tmp paths. Also perl pointer is default. Please advice how I can fix these... thanks, ./bin/safe_mysqld Starting mysqld daemon with databases from /home/../mydir/ 020410 11:50:47 mysqld ended ./bin/mysqld ./bin/mysqld: Fatal error: Can't find messagefile '/usr/local/mysql/share/mysql/english/errmsg.sys' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: select statement problem
Hi, If I have two MYSQL tables with two columns for email addresses respectively: csc_teammembers.tes_email AND cscflash_mb.email Now, what I want to do is query only those email addresses in cscflash_mb that DO NOT have a match in the csc-teammembers dbtable. Can I just do a select statement in phpmyadmin to pull up these addresses? And, how should it read? Thanks to anyone who responds - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Cobalt Raq2
Well, I haven't kept up on the Cobalt product line, but, I wasn't aware that they had intel based offerings. I thought they were all RISC chip based. That probably explains why I86 binaries won;t install.. If they don't have a binary for Cobalt Cube/RaQ systems, it's compile time. Ken -Original Message- From: Richard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 2:04 PM To: [EMAIL PROTECTED] Subject: MySQL on Cobalt Raq2 Trying to install version mysql version 3.23.49a rpm. This is the Linux OS on my Cobalt. Kernel 2.0.34C2_SK. I have been trying to install the rpm for intel, but it says that the package is for a different architecture. Should I try the tar package or is this hardware a Sparc platform? RPM is on the box and other packages from the Cobalt site that are rpm's have worked. Cobalt OS Release 4.0 RaQ2-All-Security Release 4.0.1-10750 RaQ2-All-Security Release 4.0.1-13453 RaQ2-All-Security Release 4.0.1-9769 RaQ2-All-System Release 4.0.1-7-9925 RaQ2-en-OSUpdate Release 4.0 Thanks in advance, Richard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: select query optimization
Hi. As I said, or at least, tried to say, a key over all used columns should help. Adding the column from ORDER BY avoids the using filesort. Adding YIADDR (which I simply overlooked last time) should add using index, as I mentioned. This means, that the data file is not touched at all, but only the index file. I.e. INDEX ( POOL, STATE, TIME_STAMP, YIADDR ) Of course you have to pay off a bit with disk usage and insert speed. But if select speed is that important, that's usually a good trade off. Bye, Benjamin. On Wed, Apr 10, 2002 at 11:52:03AM -0700, [EMAIL PROTECTED] wrote: ben, I did that about three minutes after I got Davids email. Things seem to be working a lot faster now, and the using filesort is gone. i am assuming there isn't much more i can do to make this thing faster, but anything else i can do would be awesome! heres is the explain: mysql explain select TIME_STAMP, YIADDR from RADPOOL where STATE=0 and POOL='GLOBAL-POOL-SMF' order by TIME_STAMP limit 1; +-+--+---++-+-+--++ | table | type | possible_keys | key| key_len | ref | rows | Extra | +-+--+---++-+-+--++ | RADPOOL | ref | ipoolstate| ipoolstate | 22 | const,const | 9416 | where used | +-+--+---++-+-+--++ 1 row in set (0.00 sec) thanks for your response! =) katen At 08:48 PM 4/10/2002 +0200, Benjamin Pflugmann wrote: [...] The slow part is probably the using filesort. I am not sure, if it will work, but try a key over all used column, i.e. INDEX ( POOL, STATE, TIMESTAMP ) If it works (i.e. if MySQL correctly sees that it can skip the filesort), EXPLAIN should show something like using index instead of using filesort and the query run a lot faster again. [...] -- [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
find non-matching rows
Hi, If I have two mysql tables with two columns for email addresses respectively: csc_teammembers.tes_email AND cscflash_mb.email Now, what I want to do is only query those email addresses in cscflash_mb that DO NOT have a match in the csc-teammembers dbtable. Can I just do a select statement in phpmyadmin to pull up these addresses? And, how should it read? Thanks to anyone who responds - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Beta release of MYSQL4.0
Hi, We want to use only MYSQL4.0 for our production database. Please let us know when the Beta release is scheduled. Regards See Dave Matthews Band live or win a signed guitar http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_020201/splash.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Lasso to mysql
At 10:17 AM -0700 4/10/02, Juan M. Quiroz wrote: I'm trying to connect to mysql using lasso but no success. The message I get is that there are no databases found. Our environment is mysql 3.23.49 on osx server 10.1.3 and lasso 5 What do I need to do to connect to mysql from lasso? Hi Juan: I assume you've properly set up the host to MySQL in Lasso Administration (e.g. set the correct IP and port). I also assume you've performed a Refresh after the host is set up so that Lasso can get the latest listing of available databases. Do any of your databases have default usernames/passwords? CC -- - Cathy Cunningham [EMAIL PROTECTED] Lasso Evangelist Blue World Communications, Inc. http://www.blueworld.com/ - Lasso Studio is the easiest way to create a database-driven Web site - Macworld Magazine - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
- character in table name
Hello, I probably installed a PHP script that created a table with a - in its name. I can't figure out how to even touch this table. If I try: mysql describe A-14c; ERROR 1064: You have an error in your SQL syntax near '-14c' at line 1 This table exists for sure though: | Tables_in_blesysdb | +-+ | A-14c | | allvisitors | | articlepages| | articles| ... I played around, and I can't create a table with - either: mysql create table d-test; ERROR 1064: You have an error in your SQL syntax near '-test' at line 1 Any help is appreciated. Thanks. Sincerely, David Chen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Web based search
Hi, We are developing a webbased serch application on MYSQL and PHP. I am sure most of you must have already implemented such application. Could you share with me the logic of such application. We were planning to keep a keyword search and my people feel that that will require additional load of keeping track of keyword and they are not interested in that. The other option is fulltext serch on all the data for one table, but concern about of the performance issue. Wondering how you guys are doing out there ? Which is the best way ? Any suggesstion appreciated . See Dave Matthews Band live or win a signed guitar http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_020201/splash.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: - character in table name
Try enclosing it: describe `A-14c`; nickg -Original Message- From: David Chen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 2:05 PM To: [EMAIL PROTECTED] Subject: - character in table name Hello, I probably installed a PHP script that created a table with a - in its name. I can't figure out how to even touch this table. If I try: mysql describe A-14c; ERROR 1064: You have an error in your SQL syntax near '-14c' at line 1 This table exists for sure though: | Tables_in_blesysdb | +-+ | A-14c | | allvisitors | | articlepages| | articles| I played around, and I can't create a table with - either: mysql create table d-test; ERROR 1064: You have an error in your SQL syntax near '-test' at line 1 Any help is appreciated. Thanks. Sincerely, David Chen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: - character in table name
Have you tried delimiting the table name with some form of quotes? -Original Message- From: David Chen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 4:05 PM To: [EMAIL PROTECTED] Subject: - character in table name Hello, I probably installed a PHP script that created a table with a - in its name. I can't figure out how to even touch this table. If I try: mysql describe A-14c; ERROR 1064: You have an error in your SQL syntax near '-14c' at line 1 This table exists for sure though: | Tables_in_blesysdb | +-+ | A-14c | | allvisitors | | articlepages| | articles| ... I played around, and I can't create a table with - either: mysql create table d-test; ERROR 1064: You have an error in your SQL syntax near '-test' at line 1 Any help is appreciated. Thanks. Sincerely, David Chen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: - character in table name
mysql describe 'A-14c'; ERROR 1064: You have an error in your SQL syntax near ''A-14c'' at line 1 It's not working... - Original Message - From: nickg [EMAIL PROTECTED] To: David Chen [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, April 10, 2002 2:13 PM Subject: RE: - character in table name Try enclosing it: describe `A-14c`; nickg -Original Message- From: David Chen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 2:05 PM To: [EMAIL PROTECTED] Subject: - character in table name Hello, I probably installed a PHP script that created a table with a - in its name. I can't figure out how to even touch this table. If I try: mysql describe A-14c; ERROR 1064: You have an error in your SQL syntax near '-14c' at line 1 This table exists for sure though: | Tables_in_blesysdb | +-+ | A-14c | | allvisitors | | articlepages| | articles| I played around, and I can't create a table with - either: mysql create table d-test; ERROR 1064: You have an error in your SQL syntax near '-test' at line 1 Any help is appreciated. Thanks. Sincerely, David Chen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MySQL on Cobalt Raq2
Hi Installation packages for the Raq range can be found at http://pkgmaster.com/packages/raq/ From the main control panel go to 'Control Panel' and 'Install Software' MySql for Raq2 is not there, though it is for Raq3 and above, so perhaps worth a try. I installed it and it was almost 'hands free' HTH Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- -Original Message- From: Kenneth Hylton [mailto:[EMAIL PROTECTED]] Sent: 10 April 2002 20:24 To: 'Richard'; [EMAIL PROTECTED] Subject: RE: MySQL on Cobalt Raq2 Well, I haven't kept up on the Cobalt product line, but, I wasn't aware that they had intel based offerings. I thought they were all RISC chip based. That probably explains why I86 binaries won;t install.. If they don't have a binary for Cobalt Cube/RaQ systems, it's compile time. Ken -Original Message- From: Richard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 2:04 PM To: [EMAIL PROTECTED] Subject: MySQL on Cobalt Raq2 Trying to install version mysql version 3.23.49a rpm. This is the Linux OS on my Cobalt. Kernel 2.0.34C2_SK. I have been trying to install the rpm for intel, but it says that the package is for a different architecture. Should I try the tar package or is this hardware a Sparc platform? RPM is on the box and other packages from the Cobalt site that are rpm's have worked. Cobalt OS Release 4.0 RaQ2-All-Security Release 4.0.1-10750 RaQ2-All-Security Release 4.0.1-13453 RaQ2-All-Security Release 4.0.1-9769 RaQ2-All-System Release 4.0.1-7-9925 RaQ2-en-OSUpdate Release 4.0 Thanks in advance, Richard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Announcing native .NET provider to MySQL
Hello, This is an announcement of a new product that will interest some of you. I have completed work for the first Beta release of a native ADO.NET provider to MySQL. You can find the details at http://www.mattculbreth.com/eidmysql. Thank you, Matt Culbreth - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Header file to be included for making a thread safe library
I'm trying to compile my program using libmysqlclient_r --enable-thread-safe-client. Would using mysql.h suffice or is there any specific header file to be included. I'm asking this because mysql_thread_init() call is not being recognized when I'm trying to compile the program regards - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
regarding libmysqlclient and libmysqlclient_r
Hi, I have written the following test case in which I'm trying to access the database using differant threads each thread calls this function test2(), access to which is protected by a pthread_mutex_lock() at the beginning of the test and pthread_mutex_unlock() at the end of the test. The same code when it is compiled using libmysqlclient works and doesn't work while using libmysqlclient_r Can anyone help me out on this . I'm including mysql.h as the header file The platform I'm using is Linux 2.4.4-4 Suse Linux . I'm also using InnoDB tables for the same. regards, void test2(int l = 0 ){ pthread_mutex_lock(lockmutex); FASDBConnection conn1; conn1.Connect(lithium.ini.cmu.edu,shivam_test,shivam,shivam_pass); if(conn1.isConnected()) cout Success Connection endl; else cout Failed Connection endl; for(int i = 0; i 1000; i++){ string query = SELECT * from STUDENTS ; FASDBStatement *r = conn1.createStatement(); FASDBResult rr; rr = r-ExecuteQuery(query); int num = rr.getNumRows(); if(num == 0){ cout Query failed number: (i+1); if(l != 0){ //FAILURE_QUERY[l-1]++; cout Failure Thread Num: l; } cout endl; delete r; continue; } // SUCCESS_QUERY[l-1]++; cout QUERY NO. i endl; while(rr.nextRow()){ FASDBRow row = rr.getCurrentRow(); cout setw(10) row.getString(0); cout setw(10) row.getString(1); cout setw(10) row.getInteger(2) endl; } cout Index :(i+1) ThreadID:l endl; delete r; } conn1.Close(); pthread_mutex_unlock(lockmutex); } - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: -- e-shop
Hi We are in the process of developing Ultra High Availability ecommerce sites based on php and MySql. 1. The software itself is well tested 2. The site is duplicated on two or more servers in separate data centres, with live replication. 3. Nameservers for the domain are on the same servers as the site. 4. Primary and Secondary nameservers are under a different domain 4. Nameserver refresh times are short. If there is a server or network failure the whole site, including DNS, fails, so the browser looks to the secondary (backup) site. In theory only simultaneous failure of both servers will stop the site being available. A DoS attack aimed at the domain itself could also bring it down. The live replication is the hardest bit, but it all looks OK. We are testing at the moment but are hoping for 100% uptime or very close. Contact me off list if you would like more info Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- -Original Message- From: maxim [mailto:[EMAIL PROTECTED]] Sent: 10 April 2002 13:55 To: [EMAIL PROTECTED] Subject: -- e-shop Hello All, I am sorry for Russian. I shall mean. The question remains open. How to reach(achieve) a high degree of reliability of system the Internet of commerce on a basis MySQL. At the expense of that it is possible to raise(increase) reliability of system? -- Best regards, maxim mailto:[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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help w/Query
Hi, I've been trying to find some info on running a select statement that would return a few rows and leave out one specific row. Here is my select statement: $result = mysql_query(SELECT ent_nws_id,img_path,substring_index(ent_body, \.\ ,1) AS ent_body FROM stns,images INNER JOIN ent_nws ON stns.stns_id=ent_nws.stns_id and images.img_id=ent_nws.img_id WHERE stns.stns_id=1,$db); I'd like to leave out say row ent_nws_id=3. I didn't see any function like EXCEPT in the manual and I'm not sure if NOT is the right function to use because haven't been able to get it to work. Any help would be greatly appreciated. Thanks in advance, Mike --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: regarding libmysqlclient and libmysqlclient_r
Try building libmysqlclient_r with your local pthreads, the same ones you're using in the application it self. ie --with-pthraed=-pthread or --with-pthread=-lpthread Shivam K Shah wrote: Hi, I have written the following test case in which I'm trying to access the database using differant threads each thread calls this function test2(), access to which is protected by a pthread_mutex_lock() at the beginning of the test and pthread_mutex_unlock() at the end of the test. The same code when it is compiled using libmysqlclient works and doesn't work while using libmysqlclient_r Can anyone help me out on this . I'm including mysql.h as the header file The platform I'm using is Linux 2.4.4-4 Suse Linux . I'm also using InnoDB tables for the same. regards, void test2(int l = 0 ){ pthread_mutex_lock(lockmutex); FASDBConnection conn1; conn1.Connect(lithium.ini.cmu.edu,shivam_test,shivam,shivam_pass); if(conn1.isConnected()) cout Success Connection endl; else cout Failed Connection endl; for(int i = 0; i 1000; i++){ string query = SELECT * from STUDENTS ; FASDBStatement *r = conn1.createStatement(); FASDBResult rr; rr = r-ExecuteQuery(query); int num = rr.getNumRows(); if(num == 0){ cout Query failed number: (i+1); if(l != 0){ //FAILURE_QUERY[l-1]++; cout Failure Thread Num: l; } cout endl; delete r; continue; } // SUCCESS_QUERY[l-1]++; cout QUERY NO. i endl; while(rr.nextRow()){ FASDBRow row = rr.getCurrentRow(); cout setw(10) row.getString(0); cout setw(10) row.getString(1); cout setw(10) row.getInteger(2) endl; } cout Index :(i+1) ThreadID:l endl; delete r; } conn1.Close(); pthread_mutex_unlock(lockmutex); } - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help w/Query
On 10 Apr 2002, at 17:23, Mike wrote: $result = mysql_query(SELECT ent_nws_id,img_path,substring_index(ent_body, \.\ ,1) AS ent_body FROM stns,images INNER JOIN ent_nws ON stns.stns_id=ent_nws.stns_id and images.img_id=ent_nws.img_id WHERE stns.stns_id=1,$db); I'd like to leave out say row ent_nws_id=3. I didn't see any function like EXCEPT in the manual and I'm not sure if NOT is the right function to use because haven't been able to get it to work. Don't you just want to add AND ent_nws.ent_nws_id 3 to the end of your query? -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Help w/Query
Hi Change your WHERE statement to WHERE stns.stns_id=1 AND table.ent_nws_id 3 ' HTH Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- -Original Message- From: Mike [mailto:[EMAIL PROTECTED]] Sent: 10 April 2002 22:24 To: mysql list Subject: Help w/Query Hi, I've been trying to find some info on running a select statement that would return a few rows and leave out one specific row. Here is my select statement: $result = mysql_query(SELECT ent_nws_id,img_path,substring_index(ent_body, \.\ ,1) AS ent_body FROM stns,images INNER JOIN ent_nws ON stns.stns_id=ent_nws.stns_id and images.img_id=ent_nws.img_id WHERE stns.stns_id=1,$db); I'd like to leave out say row ent_nws_id=3. I didn't see any function like EXCEPT in the manual and I'm not sure if NOT is the right function to use because haven't been able to get it to work. Any help would be greatly appreciated. Thanks in advance, Mike --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
loading data with sub-categories
Many thanks for any assistance: I have data (classified ads) in a text file that I would like to load into a table. The problem is that, as classifieds, they are broken down by class and sub-class. For instance: 0031 - Announcements - Notices One ad Two ad - Tickets Three ad Four ad Five ad 0035 - Help Wanted - Professional Six ad Seven ad - Dishwashers Eight ad And so on. The problem I have is how can I indicate in the load data infile that '0031 - Announcements' is a class and to assume everything below it flow into the database (not putting anything in the 'class' field or repeating the same class in the class field) until the next class is reached. The same would be the case for the sub-class, with numerous ads under a sub-class. Does this require a separate table for each class? Or should there just be more preparation of the text file to make it conform? Point me toward something similar someone else has done and I'll pursue it. for filter: MySql, database, query, Mephistopheles -- Greg Peretti web developer www.abqjournal.com (505) 823-3888 --- The web of our life is of a mingled yarn, good and ill together. - William Shakespeare The more I know, the less I understand. - Don Henley - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
search pattern matching
In MySQL it says that adding the following to a where clause: like %$somestring%; should select matches that contain $somestring in them anywhere. However when I use it I find that if e.g. I have an entry dog in the database, if I search for dogs, it doesn't come up. Also if I search for dog house it doesn't come up. How come? Thanks, SW - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Innobase UPDATE ... LIMIT x;
Does anyone know how Innobase would handle this query? If it would lock all of the rows within the table, or attempt to find all of the rows within the table instead of just finding the first X in my LIMIT and locking those and updating those? I have a table with 1 million rows as my example WHERE c1 is equal to 5 (c1 = 5) and when I run this query, it takes roughly 16 seconds, which it should not because of the index: UPDATE t1 SET c1 = 1 WHERE c1 = 5 LIMIT 5; This should go rather fast, because SELECT * from t1 WHERE c1 = 5 LIMIT 5 returns the 5 rows in 0.x seconds, however when I update it takes an extended period of time. Creation Statement: CREATE TABLE `t1` ( `id` int(11) unsigned NOT NULL default '0', `c1` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `c1` (`c1`) ) TYPE=InnoDB Example select mysql select id, c1 from t1 where c1 = 5 limit 5; +--+-+ | id | c1 | +--+-+ | 1433 | 5 | | 1434 | 5 | | 1435 | 5 | | 1436 | 5 | | 1437 | 5 | +--+-+ 5 rows in set (0.00 sec) Example update: mysql update t1 set c1 = 1 where c1 = 5 LIMIT 5; Query OK, 5 rows affected (15.69 sec) Rows matched: 5 Changed: 5 Warnings: 0 Example count: mysql select count(*) from t1; +--+ | count(*) | +--+ | 100 | +--+ 1 row in set (0.90 sec) Version: mysql show variables like 'version'; +---+--+ | Variable_name | Value| +---+--+ | version | 3.23.49a-max | +---+--+ 1 row in set (0.01 sec) database, mysql, query, update, select, filter nickg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Web based search
At 1:08 PM -0700 4/10/02, va ku wrote: We are developing a webbased serch application on MYSQL and PHP. I am sure most of you must have already implemented such application. Could you share with me the logic of such application. We were planning to keep a keyword search and my people feel that that will require additional load of keeping track of keyword and they are not interested in that. The other option is fulltext serch on all the data for one table, but concern about of the performance issue. Wondering how you guys are doing out there ? Which is the best way ? Any suggesstion appreciated . We need some more details to provide meaningful assistance. That having been said, if you're going to be doing a project with massive amounts of text and want to provide full text searching capabilities, definitely take a look at MySQL v4 which provides some great enhancements along the lines of full text indexing/searching. Indexing is purportedly 100x faster and full text searching is purportedly 2x faster. There's also a wealth of new search operators planned (I don't know yet it they're implemented) which help with defining the search. HTH CC -- - Cathy Cunningham [EMAIL PROTECTED] Lasso Evangelist Blue World Communications, Inc. http://www.blueworld.com/ - Lasso Studio is the easiest way to create a database-driven Web site - Macworld Magazine - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: bulk copy
On Wed, Apr 10, 2002 at 11:18:14AM -0500, Henning, Brian wrote: Hello- I am a Sybase user with a mysql question. Does mysql do bulk copy (bcp)? Bulk copy allows a mass copy from a file a database and vice versa. I know there is mysqldump but, i am not sure if that is what i am looking for. Can anyone explain? Have a look at mysqlimport for importing bulk data. To export, mysqldump will work, as will SELECT ... INTO OUTFILE ... syntax. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 62 days, processed 1,686,109,171 queries (313/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: search pattern matching
You are searching for the word dogs...that word is not contained in the word 'dog' or the phrase 'dog house.' If you searched for '%dog%' you would get both of those results. The wildcard character allows any other character in it's place...hence '%dog%' finds 'mydog', 'mydogs', etc, etc...it does not lop of part of your search word in the effort to find something else. -- Jason On Wed, 2002-04-10 at 17:58, Scott wrote: In MySQL it says that adding the following to a where clause: like %$somestring%; should select matches that contain $somestring in them anywhere. However when I use it I find that if e.g. I have an entry dog in the database, if I search for dogs, it doesn't come up. Also if I search for dog house it doesn't come up. How come? Thanks, SW - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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