my.cnf problems
hi there, my data directory is /var/lib/mysql . i have created a .my.cnf file here. i have restarted mysql and now i am not sure whether the entries are being read from the cnf file. can you tell me how to confirm this ?? thanks in advance bye Mathew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
A Beginner's Query
Hi All Actually I am Oracle Prgrammer novice to mysql We have installed Linux RH 6.2 in which we have installd mysql. Now he want me to create 3 tables in that. He has given me mysql prompt. However I dont know how exactly to go further. When I issue a select statement it says you have to connect to database Now I even dont know what are databases here and how to create a new database. I have downloaded the documentation but doesnt show how to go ahead. if I say create table ... after it says query processed . But how to view the structure of the table. I mean I am not able to do anything even after mysql prompt appears. I have the documentation. Can Anyone guide me on this Amol _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Non - Responding State of Mysql
It has been a few times when I bump into this situation, and I would like to know if anyone has solutions for this: When I "ALTER" a table that contains a lot of data, or enter a long long complex query by mistake, it seems like the query (or action) is taking up all that the server can handle. The server stop responding. no connection can be made to mysql server no query can be made. mysqladmin shutdown can't seem to reach the server mysqladmin processlist didn't respond and this will last about an hour or so untill the process is finally done. My questions is, many of times this happen by accident. Is there anyway to stop this process and let the server back to normal? thanks.. Terry
Re: A Beginner's Query
query processed . But how to view the structure of the table. I mean I am not able to do anything even after mysql prompt appears. I have the documentation. Can Anyone guide me on this I could write it all, I'm sure many on this list can. It's pretty useless though.. Checkout the manual at www.mysql.com if you did move over to www.devshed.com and go to the MySQL section.. Follow some links from the MySQL manual on www.mysql.com Next, go to a bookstore and buy the book MySQL from Paul DuBois.. this should help you.. Please, before posting: checkout the archive.. many many many questions are found there, with answers. Bye, B. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Perl script mysqlhotcopy error ... (errno: 24)
Hi, I got this error using mysqlhotcopy: DBD::mysql::db do failed: Can't find file: './Tecnowind/tqgrppia.frm' (errno: 24) at /usr/local/mysql/bin/mysqlhotcopy line 375. Issuing rollback() for database handle being DESTROY'd without explicit disconnect(). and perror 24 says: Error code 24: Too many open files Ok, the point is that the database has 865 tables: # ls -al /home3/Oasi/files/Tecnowind/*.MYI | wc -l 865 The mysqlhotcopy script at line 375 try to lock all tables at once. $dbh-do("LOCK TABLES $hc_locks"); I got this error with 3.23.34a and 3.23.36 mysql versions. Could someone give me a solution ? I think that some parameter should be tuned (open tables limit ???) Thanks in advance PS: Yesterday, I have completed an installation with 120 concurrent users, with OASI, our ERP based on mysql (OF COURSE) and it runs very very well ! The hardware is a bi-processor XEON 733 MHZ with 2GB of RAM and 60 gb HD (SCSI). There are 4 databases that shares some common tables ! marcello - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Platform Requirements
Hi all, I'm a newbie so be gentle. I've looked but unfortunately can't find any information on the minimum hardware specification for MqSQL 3.23. eg minimum recommended amount of RAM, Speed and number of Processors etc. I'd appreciate it if anybody could send any of this information for either a Unix platform (Solaris or Linux) or Windows (NT4 or Win2K) Thanks in advance Craig. [EMAIL PROTECTED] Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: fastest queries
On 04.04.2001 16:42:28 ?iso-8859-1?Q?Ren=E9_Tegel?= wrote: not for speed, but i defitively prefer your second query. Reason for this is simple: you name the field you want to insert. Yes, you are right. But I prefer a third way altogether: INSERT INTO Tbl SET Field=42; The reason for this is, that it is very easy to change this to an UPDATE query like: UPDATE TBL SET Field=42; While you may hardly ever need to change INSERT - UPDATE, I find it nice that both those statements which do similiar tasks have the same syntax. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 pictures in mySQL
On 05.04.2001 04:23:55 Taing Nguon wrote: I am not sure what you explained. You mean that place PATH/filename.jpg to picture field. isn't it? If yes, it is just a text. How can we explore that picture thru web browser such as IE or Netscape? Thanks for the answer Well, he said that he has his setup in such a way, that Aliases in the apache config are created automatically to point to the users dir. Next he stores, let's say "user23443/askwar.jpg" in his database. When somebody wanted to watch this picture, the browser would request "user23443/askwar.jpg" and would get it right away, as it is accessible via the filesystem. At least that's how I understood it. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 full-indexing
Hi, all. I'm a newbie so be gentle I have a quastion about new feature of MySQL - Full-text indexing (http://www.mysql.com/doc/M/y/MySQL_full-text_search.html). Cutting: "Since Version 3.23.23, MySQL has support for full-text indexing and searching. Full-text indexes in MySQL are an index of type FULLTEXT...". Well, when I trying to search in my tables (see example on url: http://www.mysql.com/doc/M/y/MySQL_full-text_search.html) some words such like these: "support", "vector" or else... I have find it... but when I'll trying to search words: "suppo" or "vect" - I can't find any of these words ("support", "vector"), i.e. relevance is zero. As I think I could use LIKE "%suppo%", but what about full-text searching? Could I use full-text indexing for search words like "supp"? SELECT *,MATCH a,b AGAINST ('$searching') as x FROM t; Please, help me. Digitally yours, Dennis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Platform Requirements
I've got MySQL 3.23.21 on a W98 box with a P90 and 32Mb RAM. And it works fine. It's a bit slower than a PIII 600 but it works great ;) Yoann - Original Message - From: "craig moffat" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 05, 2001 9:54 AM Subject: Platform Requirements Hi all, I'm a newbie so be gentle. I've looked but unfortunately can't find any information on the minimum hardware specification for MqSQL 3.23. eg minimum recommended amount of RAM, Speed and number of Processors etc. I'd appreciate it if anybody could send any of this information for either a Unix platform (Solaris or Linux) or Windows (NT4 or Win2K) Thanks in advance Craig. [EMAIL PROTECTED] Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
huidziekte
Vijf jaar voordat deze foto's werden genomen werd bij mij diagnose reumatische artritis gesteld en als zodanig ook behandeld. Niets hielp. Toen de ziekte zich zo manifesteerde zoals u hieronder kunt zien.. http://www.naardedokter.com/testimonials/sys_lup_eryth.htm - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: java.sql.SQLException *SOLVED*
At 15:35 30/03/2001 -0800, you wrote: HI I am using MySQL 3.23 on Windows 2000 and mm.mysql.jdbc-1.2c but when I run my servlet it gives me communication link failure error... please help in solving this error.. Thanks Update your Driver, This version has a bug (the exception is bad handshake, exact ?) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: huidziekte
Vijf jaar voordat deze foto's werden genomen werd bij mij diagnose reumatische artritis gesteld en als zodanig ook behandeld. Niets hielp. Toen de ziekte zich zo manifesteerde zoals u hieronder kunt zien.. THis message is send in Dutch, my native language. I'm not going to translate this for you guys.. it's about an illness, has absolutely nothing to do with MySQL. I'll reply to the sender to tell her about this list, target.. and hope she stops. Bye, B. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Visual Foxpro 6
I wish to use MySQL as a backend to a Visual Foxpro 6 client application, has anyone got any experience of this ? Does it work ? Regards Chris.br clear=allhrGet Your Private, Free E-mail from MSN Hotmail at a href="http://www.hotmail.com"http://www.hotmail.com/a.br/p
Re: Storing pictures in mySQL
I am not sure what you explained. You mean that place PATH/filename.jpg to picture field. isn't it? If yes, it is just a text. How can we explore that picture thru web browser such as IE or Netscape? Thanks for the answer Your image would be in, say /usr/local/apache/htmldoc/images/simpletons/12.jpg and the row in your table might be USER_ID NAMEIMAGE_PATH -- 12 TAING /usr/local/pache/htmldoc/images/simpletons/12.jpg Which could be accessed with http://www.simpletonsrus.com/images/simpletons/12.jpg regards, P Regards Taing Nguon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
YourName.BEST321.com FREE §K¶O°ì¦W !!!!!
Dear Webmaster, Does your homepage address look long and difficult to remember like this: http://www.myhomepage.com/entertainment/w/love/index.html? Wouldn't you like it better if it was like http://YOURNAME.best321.com In that case, Cool168 has the solution for you, and the best thing about it all is that it's totally free! JOIN IT NOW!!! http://best321.com/forward/script.pl?do=step1 §Ú̱À¥Xªº§K¶O°ì¦W¡A¬°±z´£¨ÑYourSiteName.BEST321.comªºÂà¦V°ì¦W¡A¨Ï±zªº¯¸ÂI§ó®e©ö³Q¤H°O¦í¡A¦}¥i¬°±z«Ø¥ß¤@©wªºÊI¯¸«~µP¡A¹ï±zªº¯¸ÂIªºµo®i¤j¦³À°§U¡C§Ú̪º§K¶O¤¤Âà°ì¦W¹ï±zªºÊI¯¸ªº¤º®e¤£°µ¯S§O¨î¡F§Ú̱o¨ì®ü¥~°Ó·~¶°¹Îªº¤ä«ù¡A¨Ï¥Î°ª³tªºªA°È¾¹¡Aéw©Ê¦n¡F§Ú̪º°ì¦Wµn°Oקﳣ«D±`¤è«K¡A¦b¤L¤ÀÄÁ¤º´N¥i±o¨ìÄݤ_±z¦Û¤vªºÂà¦V°ì¦W¡CBEST321.com§K¶O°ì¦W¡A¦b¦PÃþªA°È¤¤µ´¹ï¬O±zªºº¿ï¡I JOIN NOW! http://best321.com/forward/script.pl?do=step1 Yours, Water - To be removed from this mailing list click on the link below http://www.best321.com/mail/mail.cgi?[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: YourName.BEST321.com FREE §K¶O°ì¦W !!!!!
That's it! One more like this and I'm unsubscribing - this is driving me insane!! P On Thu, 5 Apr 2001, Water wrote: Dear Webmaster, Does your homepage address look long and difficult to remember like this: http://www.myhomepage.com/entertainment/w/love/index.html? Wouldn't you like it better if it was like http://YOURNAME.best321.com In that case, Cool168 has the solution for you, and the best thing about it all is that it's totally free! JOIN IT NOW!!! http://best321.com/forward/script.pl?do=step1 XKOWAzYourSiteName.BEST321.comVWAzIeQHOA}iz@wI~PAzIoijUCKOWzIeSOFo~~AtAAwnFWnOD`KAbLNio_zvVWCBEST321.comKOWAbPAOzI JOIN NOW! http://best321.com/forward/script.pl?do=step1 Yours, Water - To be removed from this mailing list click on the link below http://www.best321.com/mail/mail.cgi?[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
Re: Speed and Hardware
Andy Sharp wrote: Hi, I'm facing an issue with my primary mySQL server. It powers a web site, which loads almost 100% dynamic data. At peak times of the day, it seems to me that the Database is becomming maxxed. (Thus bogging the site) I'm aware that there are simply too many variables to completely answer this question - number of tables, size of tables, the queries themselves, system configuration, type of data, program code, etc.. but I'm hoping to get a ball park idea of the limitations of my current hardware. The system is a Pentium 850, 1Gb Ram, Ultra-II SCSI Disks, 256 Mb Cache, running FreeBSD 4.1 and the binary copy of Mysql for FreeBSD. (Had some unreleated problems with the thread libraries..) The system averages 550 Queries per second, over the course of a normal week. Most of these queries are what I'd describe as "average" joins on a table of 5000 records to two tables of about 30,000 records. If anything I've overindexed. the database is a total of 100Mb, and the system typically has 0 disk usage. During off peak times I'm getting great performance, Fast - responsive. During peak hours, the usage spikes to 700 to 900 Queries per second, the DB box doesn't thrash, it just slows down. Perviously fast indexed queries start getting logged as slow, and even a lookup by primary key id can take 2 or 3 seconds. I suspect the system is simply CPU bound. So, the question is this: Is the above usage, given an "average" database, ok code, and optimized queries, considered ok? Or should I be looking for some kind of configuration/query problem? Have I simply maxxed out my hardware? I'm sure that further tuning may be able to squeeze more speed out of the hardware, but I'm looking for a speed boost of double (new site coming on line shortly). Yet before throwing more money on hardware (and the time to setup replication), I'd like to get some kind of 3rd party information saying "Your system is performing well enough, more tweaks will only give you a 10 to 20 percent boost." You've not mentioned your my.cnf settings (which if you've tweaked then great). Also are thier concurrent inserts / updates going on ? Whats "maxing" out mysql / proccessor or Disks ? Would more memory help (bigger disk cache) ? Anyone given more info, and a few benchmarks, you may be able to increase performance - are your my.cnf settings ok ? What else is running on the box ? Is their a RAID array ? etc However on a side note you have a problem in that with a dynamic site your performance is ultimatley limited by the ammount of hardware you can throw at the problem. What about looking at caching any DB output locally on the webserver - in 90% of cases like this people claim thier sites are dynamic, yet very little is realtime, and alot can be cached locally. Can you cache any data locally, even if the cache is refreshed every minute or 5 minutes it may save alot of hits on the DB, yet your users may never know the difference. Obviously if your site needs to be realtime (games, financial etc ..) then the above is a load of rubbish and get ready to go buy a bigger box, or more boxes (and use replication). Greg For people running largish mySQL servers, what kind of hardware do you have to support a volume in the range of 2,000+ queries per second? Thanks, I appreciate any time taken in answers. --A Ps: If I've missed any good references to this in documentation, please let me know - I haven't found a good reference for "what is good performance" in any searching. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: [OT] ourName.BEST321.com FREE §K¶O°ì¦W !!!!!
Water wrote: Dear Webmaster, Ok, qhat i think is that son of a bitch is going to subscribe the list to any kind o maling lists. It is going to subscribe and unsubscribe only to joke Soem solutions need to be taken from the owner of the lists: A) DUL,RBL B) new subscriber will be moderated.. C) . Signal/noise ratio is going to zero. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 full-indexing
Hi! On Apr 05, Dennis S.Davidoff wrote: Hi, all. I'm a newbie so be gentle I have a quastion about new feature of MySQL - Full-text indexing (http://www.mysql.com/doc/M/y/MySQL_full-text_search.html). Cutting: "Since Version 3.23.23, MySQL has support for full-text indexing and searching. Full-text indexes in MySQL are an index of type FULLTEXT...". Well, when I trying to search in my tables (see example on url: http://www.mysql.com/doc/M/y/MySQL_full-text_search.html) some words such like these: "support", "vector" or else... I have find it... but when I'll trying to search words: "suppo" or "vect" - I can't find any of these words ("support", "vector"), i.e. relevance is zero. As I think I could use LIKE "%suppo%", but what about full-text searching? Could I use full-text indexing for search words like "supp"? Not before MySQL-4.0. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql++
Kevin Pratt writes: I am having a problem installing mysql++ on a freebsd 4.2 install.. I am wondering if there is anyone who has got it to work? thanks Kevin ps if I am in the wrong place please tell me where I should be. :) Hi! Just download source tarball for version 1.7.8, install gcc 2.95.2 (if you do not have it already) and run: automake autoconf ./configure make Then install it where you think it should be installed. You must have 3.23 client libs installed already too. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Visual Foxpro 6
Hi Christopher, I wish to use MySQL as a backend to a Visual Foxpro 6 client application, has anyone got any experience of this ? Does it work ? We're using MySQL as backend for our VFP6-Application. It's working with the MyODBC-Driver but you have to take care about memo-fields and boolean fields. We're no longer use boolean cause it isn't supported by MySQL. So we changed to the good old fashioned binary value (tinyint in MySQL) with 0 and 1. Using Memofields is a bit more tricky cause you have to use text or blob in MySQL to store their content. MySQL has no problems storing it but when you're trying to get the data back to VFP you can't use a passthrough select statement. If you do so VFP handles the content of the blob field as an object, not as text. For this reason you have to use a view. In the view definition you can change the type for the blob field from object to memo so it will be displayed right in VFP. Oh, I almost forgot the nastiest point up to now, the view definition: When you create a view with VFP the MyODBC-Driver loads down the complete table content before showing the dialog where you can choose the fields from the table structure. If you got a tabelle with a million rows (like we do) you can spend much time in drinking coffee and walking around before you get this dialog. So create the views on an empty table and fill them after creating the view. Greetings from cloudy Germany Lutz Maibach EasyCom GmbH - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Install and testing problem?
I have compiled and installed mysql 3.23.33 and now 3.23.36 on a MAC OS X machine.. uanme -a gives.. Rhapsody haarp 5.6 Kernel Release 5.6: Tue Nov 23 15:07:38 PST 1999; root(rcbuilder):Objects/kernel-187.obj~2/RELEASE_PPC Copyright (c) 1988-1995,1997-1999 Apple Computer, Inc. All Rights Reserved. Power Macintosh With the .33 version everything seemed ok until one of our developers tried to insert a BLOB into the database using WebObjects. He says he gets an error and all sort of strange ASCII characters? I saw someone suggest upgrading to at least .34a to fix this. I have now upgraded to .36 We haven't tried the BLOB insert yet but I was running the mysql-test-run program and got the following results. As you can see one test is skipped and another (binary) failed. Does anyone have an idea what the problem could be? Thanks. Pat. First results. ./mysql-test-run Installing Test Databases Removing Stale Files Installing Master Databases Installing Slave Databases Starting MySQL daemon Loading Standard Test Databases Starting Tests TEST USER SYSTEM ELAPSEDRESULT alias 0.06 0.13 0.32 [ pass ] alter_table 0.02 0.17 0.45 [ pass ] analyse 0.03 0.15 0.27 [ pass ] auto_increment0.03 0.16 0.46 [ pass ] backup0.01 0.18 0.39 [ pass ] bdb-crash 0.05 0.15 0.24 [ pass ] bdb [ skipped ] bigint0.04 0.15 0.27 [ pass ] binary [ fail ] lt-mysqltest: At line 34: Result length mismatch real 0.29 user 0.05 sys 0.14 Aborting. To continue, re-run with '--force'. Ending Tests Shutting-down MySQL daemon
Re: MySQL full-indexing
Hi Dennis, Yes, this is the way it works. You can do a match field against stringg on whole words only. If you want to search for 'support' match field against 'support' is ok, but match field against 'supp' will not work. In these cases your only choice is to use where field like '%supp%'. (As far as I know). In MySQL 4.0 the fulltext search function will be more sophisticated. Regards, Peter Szekszardi PortoLogic Ltd. Portal building, prime number generating, script hacking and more... The prime number of the day is 397097873 On Thu, 5 Apr 2001, Dennis S.Davidoff wrote: Hi, all. I'm a newbie so be gentle I have a quastion about new feature of MySQL - Full-text indexing (http://www.mysql.com/doc/M/y/MySQL_full-text_search.html). Cutting: "Since Version 3.23.23, MySQL has support for full-text indexing and searching. Full-text indexes in MySQL are an index of type FULLTEXT...". Well, when I trying to search in my tables (see example on url: http://www.mysql.com/doc/M/y/MySQL_full-text_search.html) some words such like these: "support", "vector" or else... I have find it... but when I'll trying to search words: "suppo" or "vect" - I can't find any of these words ("support", "vector"), i.e. relevance is zero. As I think I could use LIKE "%suppo%", but what about full-text searching? Could I use full-text indexing for search words like "supp"? SELECT *,MATCH a,b AGAINST ('$searching') as x FROM t; Please, help me. Digitally yours, Dennis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQLGUI strange behavior
It's me again. So I downloaded the statical compiled MysqlGGUI, and i can start it without problem. I can also connect to mysql server and change database. BUT: - When I try to create database the result is NULL :) - After entering the admin panel it usually crashes after another operation - It refuses to create a table (I'm a root of course) AND SO ONE ... May it be due to different libraries? I got standard libs from RH7.0; MySQL 3.23.35; and all packages required for MySQLGUI. Thanks. Malmo Malmo If I only got 20$ for evryone who's too lazy to configure his own comp. Bill Gates "Why not?" - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Provider claims 'it's normal that mysql crashes', is that true?
If its a hosting PROVIDER, the table locking issue should really only be a factor for your database. If your design is good, then the rest shouldn't matter. Machine memory and processing power are another issue entirely. Other users could drag the machine down with poor design issues. One issue that we encountered, due to our own ignorance of course, was not allowing enough swap space for our mysql installation. We had 64MB of swap on a machine with 64MB of RAM. When we tried to process large queries the machine ran out of memory and crashed hard. Our short term work around was to take another, unused, partition and reformat it as swap. With 1.5 GB of swap, we never saw another problem, but we don't let users build their own databases either. -Original Message- From: mysql-digest-help [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001 11:27 AM To: mysql Cc: gvb Subject: Provider claims 'it's normal that mysql crashes', is that true? Hello My provider 11-Puretec (www.puretec.de) hosting more than 1.000.000 domains runs about 14 Databaseserver with MySQL 3.22.32-log on Linux dual Penti-III 500Mhz machines. In the last 6 month the average uptime of the mysql-servers was around 8 hours. As I asked them why their mysql-server die so often, I got their standard problem email-answer that claims "mysql is scaling rather badly". After further asking I got a personal answer that says: "it's normal the mysql-servers die because of heavy load". "We can't help that the mysql task keeps crashing if to many users access it. That's totally normal for a mysql database" Is that true? regards Gunnar von Boehn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 migrating from 3.23.29 to 3.23.36
Hy! I have this odd problem. I upgraded my MySql from 3.23.29 to 3.23.36. It works fine with some databases I created with 36. But I copied some databases from 29 and I get this mysql use lumina; Didn't find any fields in table 'absences' Didn't find any fields in table 'admins' Didn't find any fields in table 'classes' Didn't find any fields in table 'marks' Didn't find any fields in table 'students' Didn't find any fields in table 'teachers' Didn't find any fields in table 'users' Didn't find any fields in table 'vars' Database changed mysql select * from users; ERROR 1017: Can't find file: './lumina/users.frm' (errno: 13) And the files exist and worked under 29. Tell what do I have to do. Thanx! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MySQLGUI strange behavior
Peter Adamka writes: It's me again. So I downloaded the statical compiled MysqlGGUI, and i can start it without problem. I can also connect to mysql server and change database. BUT: - When I try to create database the result is NULL :) - After entering the admin panel it usually crashes after another operation - It refuses to create a table (I'm a root of course) AND SO ONE ... May it be due to different libraries? I got standard libs from RH7.0; MySQL 3.23.35; and all packages required for MySQLGUI. Thanks. Malmo Hi! If you have statically built mysqlgui, you do not require any libraries. Please check out that it is not semi-static executable. What is the output from ldd on mysqlgui ?? If you can not create database, may be you do not have privileges, but the admin panel should not crash. Can you please tell me exactly what to do to crash admin panel. Also do not use MySQL binaries from RH 7.0, but use our binaries. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql++-1.7.8 building problem
Hi! I have just read your suggestion for building mysql++. Since I cannot build it successfully I have some more questions for you. I have installed fallowing software on Sun ULTRA 1 under Solaris 2.6: - gcc 2.95.3 - mysql 3.23.5 - fltk-1.0.10 My intention is to install mysqlgui-1.7.4, but I cannot compile mysql++-1.7.8 because the following error appeared while executing make ld: fatal error: no -lz library I checked for libz.a and libz.so but I can't find any of them. Please help! Best regards Goran - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
3.23.36 on Linux replication problem
After restarting a slave, I got the following error: 010405 11:07:28 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'xxx-bin.001' at position 289 010405 11:07:28 Error reading packet from server: log event entry exceeded max_allowed_packet - increase max_allowed_packet on master ( read_errno 0,server_errno=65535) 010405 11:07:28 Slave: Failed reading log event, reconnecting to retry, log 'xxx-bin.001' position 289 and it would not recover (max_allowed_packet on master is 1Mb so it should be enough). I am puzzled. Any ideas? -- Jean-Luc Fontaine - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 migrating from 3.23.29 to 3.23.36
MySQL Server wrote: Hy! I have this odd problem. I upgraded my MySql from 3.23.29 to 3.23.36. It works fine with some databases I created with 36. But I copied some databases from 29 and I get this mysql use lumina; Didn't find any fields in table 'absences' Didn't find any fields in table 'admins' Didn't find any fields in table 'classes' Didn't find any fields in table 'marks' Didn't find any fields in table 'students' Didn't find any fields in table 'teachers' Didn't find any fields in table 'users' Didn't find any fields in table 'vars' Database changed mysql select * from users; ERROR 1017: Can't find file: './lumina/users.frm' (errno: 13) And the files exist and worked under 29. Tell what do I have to do. Thanx! Change the ownership and permissions on the databases/files to allow mysqld to read them. When you copied them, you were not the user mysql. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Strange problem.
Hello , Few time ago I've started to get the following problems, which several times allready lead to data lost for me. Here is the example: I found the followings in my application error log: Query - #1017 [opal.local] - Can't find file: 'g04stat_languages.MYD' (errno: 2) select visitors,loads,id ,hits from layers_st45.g04stat_languages where layer_id=19573 05.Apr 16:30:28 : pid:5224 h -- 65972/0 AllInOne rec:0 l:0 tm:1627.20 # 05.Apr 16:30:28 : pid:5224 h 65972/0 [03.23 17:10] - [01.01 02:59] q:3.73 i:0.00 a:3.26 # So If I check mysql it's running quite well and long: opal:/spylog/layers # mysqladmin status Uptime: 255087 Threads: 74 Questions: 28129440 Slow queries: 1453 Opens: 225540 Flush tables: 1 Open tables: 1024 Queries per second avg: 110.274 opal:/spylog/layers # The logfile contains NO errors or snything about this I went to look what is wrong with the file: The problem is index file is gone. And there are MUCH such situations - I get several files lost each day. opal:/spylog/db/layers_st45 # ls -la g04stat_lang* -rw--- 1 mysqldaemon1473241 Mar 26 18:54 g04stat_languages.MYD -rw--- 1 mysqldaemon 8664 Jan 12 19:09 g04stat_languages.frm This is not the worst case - in several tables I had .MYD file to be not existant, but TMD file left - so I just rename it and it works find. One or two times I didn't find even TMD file so I had to look at my backups. Looking at the table I found They are usually distributed in one table group - for example I get many from layers_stXX.gXX* lost there no over tables lost, so I think this is related to my purge program (this is still mysql bug anyway :)) ). The thing is after deleting some data from table the program uses REPAIR table - this is from the times then optimize table was several times slower. I'm using mysql 3.23.36, and nothing is changed in system, only mysql, also I had this problem with mysql 3.23.32 if I'm not mistaken. I'll try to make an repeatable example but I'm not shure I'll be able to do so as this does not happens to all tables this program work with - this may happen only in some specific cases - may be then other program is working with the table or something. -- Best regards, Peter 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
Starting .36 with innobase failed on HPUX-11 / problem with my.cnf
Hi, after succesfully compiling mysql-3.23.36 on my HP-UX11 box (Heikki, thank you for your hints), I can't start start the DB with the start.server script. I created a /etc/my.cnf file with the following values: [mysqld] innobase_data_home_dir = /opt/mysql/var/ innobase_log_group_home_dir = /opt/mysql/var innobase_log_arch_dir = /opt/mysql/mysql/var innobase_data_file_path = ib_data1:10M set-variable = innobase_mirrored_log_groups=1 set-variable = innobase_log_files_in_group=3 set-variable = innobase_log_file_size=5M set-variable = innobase_log_buffer_size=8M innobase_flush_log_at_trx_commit=1 innobase_log_archive=0 set-variable = innobase_buffer_pool_size=16M set-variable = innobase_additional_mem_pool_size=2M set-variable = innobase_file_io_threads=4 set-variable = innobase_lock_wait_timeout=50 ~ After starting I found the following error in the .err file: 010405 14:30:32 mysqld started /opt/mysql/libexec/mysqld: unrecognized option `--~' /opt/mysql/libexec/mysqld Ver 3.23.36 for hp-hpux11.00 on hppa1.1 Copyright (C) 2000 MySQL AB MySQL Finland AB, by Monty and others This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Starts the MySQL server Usage: /opt/mysql/libexec/mysqld [OPTIONS] --ansiUse ANSI SQL s. snip After removing the /etc/my.cnf file the server starts sucessfully, but without initializing the innobase stuff because the necessary pathes/variables are not set. Okay, second I tried, sucessfully, to start mysqld manually with the following commandline /opt/mysql/libexec/mysqld --user=mysql --basedir=/opt/mysql \ --datadir=/opt/mysql/var --innobase_data_home_dir=/opt/mysql/var/ \ --innobase_data_file_path=ib_data1:10M I suppose that mysqld (on HP-UX11) doesn't handle the my.cnf options correctly??? By the way, I need to append a '/' at the end of the innobase_data_home_dir path in contrast to documentation. Greetings from Germany Andre -- E-Mail: [EMAIL PROTECTED] Date: 05-Apr-01 Time: 14:20:03 () Join the ASCII ribbon campaign against html email /\ and Microsoft attachments. "I heard if you play the NT-4.0-CD backwards, you get a satanic message" "That is nothing, if you play it forward, it installs NT-4.0" -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replication, problems with binlog-ignore-db
Hi, we use mysql with replication, all works fine. Now we wan't exclude some tables from the replication. I enter in my.cnf the line binlog-ignore-db = news (stop the master and restart the master after the change in my.cnf) After this, the master don't repliacted any databases, only the tables on the master db are updated. If i enter in mysql "show master status;" i get following result: +-+--+--+--+ | File| Position | Binlog_do_db | Binlog_ignore_db | +-+--+--+--+ | sumatra-bin.014 | 73 | | news | +-+--+--+--+ 1 row in set (0.01 sec) on thew slave i get: mysql show slave status; +-+-+-+---+-+-+---+-+-+++--+ | Master_Host | Master_User | Master_Port | Connect_retry | Log_File| Pos | Slave_Running | Replicate_do_db | Replicate_ignore_db | Last_errno | Last_error | Skip_counter | +-+-+-+---+-+-+---+-+-+++--+ | sumatra | blah| 3306| 60| sumatra-bin.014 | 73 | Yes | | news| 0 || 0 | +-+-+-+---+-+-+---+-+-+++--+ 1 row in set (0.00 sec) which each time has the same position number (on Master and SLave), when i enter the above statement I don't find something about souch a Problem in the manual. I use mysql Version 3.23.36 on Sun Solaris 2.6 Master configuration : log-bin server-id = 1 binlog-ignore-db = news Slave confguration: master-host=sumatra master-user=blah master-password=blah master-port=3306 server-id=2 Thank for your help Dani Daniel Tschanz Phone: +41 32 344 86 00 Rolotec AG Direct: +41 32 344 86 42 Gottstattstrasse 24, Postfach 8 Fax:+41 32 344 86 86 2500 Biel 8 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: Starting .36 with innobase failed on HPUX-11 / problem with my.cnf
[EMAIL PROTECTED] writes: Hi, after succesfully compiling mysql-3.23.36 on my HP-UX11 box (Heikki, thank you for your hints), I can't start start the DB with the start.server script. I created a /etc/my.cnf file with the following values: [mysqld] innobase_data_home_dir = /opt/mysql/var/ innobase_log_group_home_dir = /opt/mysql/var innobase_log_arch_dir = /opt/mysql/mysql/var innobase_data_file_path = ib_data1:10M set-variable = innobase_mirrored_log_groups=1 set-variable = innobase_log_files_in_group=3 set-variable = innobase_log_file_size=5M set-variable = innobase_log_buffer_size=8M innobase_flush_log_at_trx_commit=1 innobase_log_archive=0 set-variable = innobase_buffer_pool_size=16M set-variable = innobase_additional_mem_pool_size=2M set-variable = innobase_file_io_threads=4 set-variable = innobase_lock_wait_timeout=50 ~ After starting I found the following error in the .err file: 010405 14:30:32 mysqld started /opt/mysql/libexec/mysqld: unrecognized option `--~' /opt/mysql/libexec/mysqld Ver 3.23.36 for hp-hpux11.00 on hppa1.1 Copyright (C) 2000 MySQL AB MySQL Finland AB, by Monty and others This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Starts the MySQL server Usage: /opt/mysql/libexec/mysqld [OPTIONS] --ansiUse ANSI SQL s. snip After removing the /etc/my.cnf file the server starts sucessfully, but without initializing the innobase stuff because the necessary pathes/variables are not set. Okay, second I tried, sucessfully, to start mysqld manually with the following commandline /opt/mysql/libexec/mysqld --user=mysql --basedir=/opt/mysql \ --datadir=/opt/mysql/var --innobase_data_home_dir=/opt/mysql/var/ \ --innobase_data_file_path=ib_data1:10M I suppose that mysqld (on HP-UX11) doesn't handle the my.cnf options correctly??? By the way, I need to append a '/' at the end of the innobase_data_home_dir path in contrast to documentation. Greetings from Germany Andre -- E-Mail: [EMAIL PROTECTED] Date: 05-Apr-01 Time: 14:20:03 () Join the ASCII ribbon campaign against html email /\ and Microsoft attachments. "I heard if you play the NT-4.0-CD backwards, you get a satanic message" "That is nothing, if you play it forward, it installs NT-4.0" Hi! May be you have some weird characters in the file. I can see in your message ^[^[ at start and - at the end. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Speed and Hardware
We cache all of our output for 1 second. We have larger values for cache timeouts for pages that change less often (hourly / daily), but the 1 second cache allows the proxy web accelerator to serve content without re-requesting the same thing as two milliseconds ago (reducing concurrent MySQL accesses dramatically). - Original Message - What about looking at caching any DB output locally on the webserver - in 90% of cases like this people claim thier sites are dynamic, yet very little is realtime, and alot can be cached locally. Can you cache any data locally, even if the cache is refreshed every minute or 5 minutes it may save alot of hits on the DB, yet your users may never know the difference. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
python on windows / mysql on linux
Could someone explain to me *exactly* what I need to do to access a mysql server on my linux box from a python program on my windoz box? The python program works fine on the linux box and I think I should be able to run it on the windoz box simply by changing the connection parameters but I can't figure out how to install MySQLdb. I have the MySQL-python-0.3.5-win32-1.zip file but there are no instructions that explain what needs to go where. I've run the 'setup.py build' and 'setup.py install' but still get 'module not found' when I try to import MySQLdb. The python on the windoz box is a vanilla BeOpen 2.0. -- "Good intentions will always be pleaded for every assumption of authority. It is hardly too strong to say that the constitution was made to guard the people against the dangers of good intentions. There are men in all ages who mean to govern well, but they mean to govern. They promise to be good masters, but they mean to be masters." -- Noah Webster Rick Pasotto email: [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: Problem migrating from 3.23.29 to 3.23.36
On Thu, 5 Apr 2001, Gerald Clark wrote: I forgot to mention that the permisions are already set to mysql:mysql 660 MySQL Server wrote: Hy! I have this odd problem. I upgraded my MySql from 3.23.29 to 3.23.36. It works fine with some databases I created with 36. But I copied some databases from 29 and I get this mysql use lumina; Didn't find any fields in table 'absences' Didn't find any fields in table 'admins' Didn't find any fields in table 'classes' Didn't find any fields in table 'marks' Didn't find any fields in table 'students' Didn't find any fields in table 'teachers' Didn't find any fields in table 'users' Didn't find any fields in table 'vars' Database changed mysql select * from users; ERROR 1017: Can't find file: './lumina/users.frm' (errno: 13) And the files exist and worked under 29. Tell what do I have to do. Thanx! Change the ownership and permissions on the databases/files to allow mysqld to read them. When you copied them, you were not the user mysql. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
query problem with MySQL
hai friends, i am going to provide a query service. for that i am using a Mysql database server for mainting the databse.i will provide my user with a query form that contains several fields.the user is free at his selection of the fields of course atleast one.in case if he selects multiple fields, how could i provide my user with all set of records which contains what all data he placed in query form. thank u laxman __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: SELECT and ORDER OPTIONS
You could use Count(term) and GROUP BY term like SELECT COUNT(term) AS rank, term FROM table GROUP BY term ORDER BY rank or something like that, and that should return something like 4, a 3, z 2, i etc I'm new to MySQL, but that would work in SQL Server and Oracle, depends of mysql supports that stuff. Travis Reeder Chief Software Architect ThinkVirtual Original Message From: Ghetalion [EMAIL PROTECTED] Sent: 2001-04-04 23:33:37.0 To: [EMAIL PROTECTED] Subject: SELECT and ORDER OPTIONS I figure since there are various ways to sort information in SQL, there must be some way to sort the most frequent bit of information. Example: SELECT term FROM table ORDER BY mostfrequent(term) And say you had this as the table ID TERM 1 a 2 a 3 f 4 z 5 a 6 i 7 i 8 z 9 z 10 a It would return: a a a a z z z i i f It there a fuction like that availble built into 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 and ORDER OPTIONS
"Ghetalion" [EMAIL PROTECTED] wrote: I figure since there are various ways to sort information in SQL, there must be some way to sort the most frequent bit of information. Example: SELECT term FROM table ORDER BY mostfrequent(term) ID TERM 1 a 2 a 3 f 4 z 5 a 6 i 7 i 8 z 9 z 10 a It would return: a a a a z z z i i f It there a fuction like that availble built into MySQL? Not exactly. Look at the online manual for "aggregate" functions. The query below will calculate the totals. SELECT term, COUNT(term) AS occurrences FROM table GROUP BY term ORDER BY occurrences DESC However, you appear to want to show *all* of the records, but you want to show them in the order determined by the query above. I don't think this is possible in one step using MySQL since the way I know to do it would require a subselect, which is something MySQL doesn't yet support. A solution is to save the output of the above SQL statement into a table (or a temporary table using CREATE TEMPORARY TABLE) and then use SELECT LEFT JOIN to get what you want. -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.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
libncurses.so.5: open failed: No such file
I get the error "ld.so.1: ./mysql: fatal: libncurses.so.5: open failed: No such file or directory" when trying to run MySQL for the first time after installation and on all attempts since. I've install this under SunOS 5.8. There may or may not be related configuration error messages. In either case, where are the possible location for these header files? select.h is in /usr/include/sys but I still get the error regardless the that path has been added to my list of path's in my profile. And what does that first error mean? What library could be missing? It makes no sense to me. Thanks for any and all help, it is appreciated. Here's an exerp: configure:3889: checking for opendir in -ldir configure:3908: gcc -o conftest -O6conftest.c -ldir 15 ld: fatal: library -ldir: not found ld: fatal: File processing errors. No output written to conftest collect2: ld returned 1 exit status configure: failed program was: #line 3897 "configure" #include "confdefs.h" /* Override any gcc2 internal prototype to avoid an error. */ /* We use char because int might match the return type of a gcc2 builtin and then its argument prototype would still apply. */ char opendir(); int main() { opendir() ; return 0; } configure:4127: checking for select.h configure:4137: gcc -E conftest.c /dev/null 2conftest.out configure:4133: select.h: No such file or directory configure: failed program was: #line 4132 "configure" #include "confdefs.h" #include select.h configure:4127: checking for sys/vadvise.h configure:4137: gcc -E conftest.c /dev/null 2conftest.out configure:4133: sys/vadvise.h: No such file or directory configure: failed program was: #line 4132 "configure" #include "confdefs.h" #include sys/vadvise.h Nelson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 speed :)
Hello mysql, I've resenty tried to becnhmark mysql in really simple case. I need to select indexes really fast so I did "select * from pages where hash=11" there was a key on hash and the query returned only one row. The query was constant and server ad no other load. I've run this on 2CPU PIII-700 under 2.2.18aa2 and on one CPU PIII700 on 2.4.2 The results are about 3300 req/sec and the second one about 1800 req/sec. Unix domain sockets was used. I found the rather huge number of context swithches in first case: 2 0 0 3296 265244 104848 111472 0 0 0 0 103 27570 41 19 40 2 0 0 3296 265244 104848 111472 0 0 0 0 103 27690 38 21 41 0 0 0 3296 265344 104848 111472 0 0 0 0 104 26405 37 18 46 the second one looked better, but not much if you'll look at about 2 times speed difference: 1 0 0 24 58656 1480 298180 0 0 0 0 105 7946 84 16 0 1 0 0 24 58656 1480 298180 0 0 0 0 106 7942 88 12 0 2 0 0 24 58656 1480 298180 0 0 0 4 110 7968 82 18 0 1 0 0 24 58656 1480 298180 0 0 0 0 105 7966 81 19 0 1 0 0 24 58656 1480 298180 0 0 0 0 105 7965 81 19 0 1 0 0 24 58656 1480 298180 0 0 0 0 105 7948 83 17 0 1 0 0 24 58656 1480 298180 0 0 0 0 105 7964 85 15 0 I tried to run dumb query "select 10" and got about 7000 queries on second machine - which is 4 times faster then query which touches the table. Has anyone any ideas about if this speed is peek - I have heard people having 1 of inserts/sec into table with no indexes with mysql and so on so I was a bit surprised about this low perfomance, which is more likely to be not because of connection or pharsing speed as "select 10" works fast, and just the I/O needed should not take so much then everything should be in memory. The another story is - I've tried few time ago read speed of reiserfs - I created 100 of files, each ten bytes in size and I was able to read this file set in speed of 25000/sec - I mean open/read/close - so select speed of about 2K queries per second looks quite surprising, then most of this time is not because of communication but because of really accessing the table. -- Best regards, Peter 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 speed :)
Peter Zaitsev writes: Hello mysql, I've resenty tried to becnhmark mysql in really simple case. I need to select indexes really fast so I did "select * from pages where hash=11" there was a key on hash and the query returned only one row. The query was constant and server ad no other load. I've run this on 2CPU PIII-700 under 2.2.18aa2 and on one CPU PIII700 on 2.4.2 The results are about 3300 req/sec and the second one about 1800 req/sec. Unix domain sockets was used. I found the rather huge number of context swithches in first case: 2 0 0 3296 265244 104848 111472 0 0 0 0 103 27570 41 19 40 2 0 0 3296 265244 104848 111472 0 0 0 0 103 27690 38 21 41 0 0 0 3296 265344 104848 111472 0 0 0 0 104 26405 37 18 46 the second one looked better, but not much if you'll look at about 2 times speed difference: 1 0 0 24 58656 1480 298180 0 0 0 0 105 7946 84 16 0 1 0 0 24 58656 1480 298180 0 0 0 0 106 7942 88 12 0 2 0 0 24 58656 1480 298180 0 0 0 4 110 7968 82 18 0 1 0 0 24 58656 1480 298180 0 0 0 0 105 7966 81 19 0 1 0 0 24 58656 1480 298180 0 0 0 0 105 7965 81 19 0 1 0 0 24 58656 1480 298180 0 0 0 0 105 7948 83 17 0 1 0 0 24 58656 1480 298180 0 0 0 0 105 7964 85 15 0 I tried to run dumb query "select 10" and got about 7000 queries on second machine - which is 4 times faster then query which touches the table. Has anyone any ideas about if this speed is peek - I have heard people having 1 of inserts/sec into table with no indexes with mysql and so on so I was a bit surprised about this low perfomance, which is more likely to be not because of connection or pharsing speed as "select 10" works fast, and just the I/O needed should not take so much then everything should be in memory. The another story is - I've tried few time ago read speed of reiserfs - I created 100 of files, each ten bytes in size and I was able to read this file set in speed of 25000/sec - I mean open/read/close - so select speed of about 2K queries per second looks quite surprising, then most of this time is not because of communication but because of really accessing the table. -- Best regards, Peter mailto:[EMAIL PROTECTED] Hi! In order to increase speed you shuuld apply our glibc 2.2 patches and rebuild glibc and mysql. Our Sasha Pachev even has some new additions to glibc 2.2, which he will made available too.. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql speed :)
Are the Mysql supplied statically linked binaries built using these optimised glibc 2.2 libraries, or are they just the stock standard 2.1.3 libraries? -- Richard Ellerbrock [EMAIL PROTECTED] Sinisa Milivojevic [EMAIL PROTECTED] 2001/04/05 05:06:45 Peter Zaitsev writes: Hello mysql, I've resenty tried to becnhmark mysql in really simple case. I need to select indexes really fast so I did "select * from pages where hash=11" there was a key on hash and the query returned only one row. The query was constant and server ad no other load. I've run this on 2CPU PIII-700 under 2.2.18aa2 and on one CPU PIII700 on 2.4.2 The results are about 3300 req/sec and the second one about 1800 req/sec. Unix domain sockets was used. I found the rather huge number of context swithches in first case: 2 0 0 3296 265244 104848 111472 0 0 0 0 103 27570 41 19 40 2 0 0 3296 265244 104848 111472 0 0 0 0 103 27690 38 21 41 0 0 0 3296 265344 104848 111472 0 0 0 0 104 26405 37 18 46 the second one looked better, but not much if you'll look at about 2 times speed difference: 1 0 0 24 58656 1480 298180 0 0 0 0 105 7946 84 16 0 1 0 0 24 58656 1480 298180 0 0 0 0 106 7942 88 12 0 2 0 0 24 58656 1480 298180 0 0 0 4 110 7968 82 18 0 1 0 0 24 58656 1480 298180 0 0 0 0 105 7966 81 19 0 1 0 0 24 58656 1480 298180 0 0 0 0 105 7965 81 19 0 1 0 0 24 58656 1480 298180 0 0 0 0 105 7948 83 17 0 1 0 0 24 58656 1480 298180 0 0 0 0 105 7964 85 15 0 I tried to run dumb query "select 10" and got about 7000 queries on second machine - which is 4 times faster then query which touches the table. Has anyone any ideas about if this speed is peek - I have heard people having 1 of inserts/sec into table with no indexes with mysql and so on so I was a bit surprised about this low perfomance, which is more likely to be not because of connection or pharsing speed as "select 10" works fast, and just the I/O needed should not take so much then everything should be in memory. The another story is - I've tried few time ago read speed of reiserfs - I created 100 of files, each ten bytes in size and I was able to read this file set in speed of 25000/sec - I mean open/read/close - so select speed of about 2K queries per second looks quite surprising, then most of this time is not because of communication but because of really accessing the table. -- Best regards, Peter mailto:[EMAIL PROTECTED] Hi! In order to increase speed you shuuld apply our glibc 2.2 patches and rebuild glibc and mysql. Our Sasha Pachev even has some new additions to glibc 2.2, which he will made available too.. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SCRIPTS IN DIFFERENTS DATABASES
Hi,... We've got a MySQL server running with a lot of different databases that have the same table-structure. Does anybody knows how to make an SCRIPT that performs an administrative task (like ALTER TABLE 'table_name') in all the databases? Do I have to use a script like this ? USE database1; ALTER TABLE users . ; USE database2; ALTER TABLE users..; USE database3; . . . (Actually the USE command does not work) Thanks a lot to all the people in the list :-) Best regards,... Santiago LLobet - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: .36 memory fault with innobase on HP-UX11
Hi, I use the following my.cnf: [mysqld] innobase_data_home_dir = /opt/mysql/var/ innobase_data_file_path = ib_data1:10M innobase_log_group_home_dir = /opt/mysql/var/ innobase_log_arch_dir = /opt/mysql/mysql/var/ set-variable = innobase_mirrored_log_groups=1 set-variable = innobase_log_files_in_group=3 set-variable = innobase_log_file_size=5M set-variable = innobase_log_buffer_size=8M innobase_flush_log_at_trx_commit=1 innobase_log_archive=0 set-variable = innobase_buffer_pool_size=16M set-variable = innobase_additional_mem_pool_size=2M set-variable = innobase_file_io_threads=4 set-variable = innobase_lock_wait_timeout=50 After first starting mysql with the start.server script innobase create the necessary files in the /opt/mysql/var directory but than it ends up with a memory fault. .err: 010405 16:45:39 mysqld started Innobase: The first specified data file /opt/mysql/var/ib_data1 did not exist: Innobase: a new database to be created! Innobase: Log file /opt/mysql/var/ib_logfile0 did not exist: new to be created Innobase: Log file /opt/mysql/var/ib_logfile1 did not exist: new to be created 010405 16:45:44 mysqld ended Restarting mysql everytimes reproduces the memory fault. After some experiments I found that the line innobase_log_group_home_dir = /opt/mysql/var/ causes the problem If I start mysql (after removing all ib_files) with the following my.cnf everthing works fine: [mysqld] innobase_data_home_dir = /opt/mysql/var/ innobase_data_file_path = ib_data1:10M #innobase_log_group_home_dir = /opt/mysql/var/ #innobase_log_arch_dir = /opt/mysql/mysql/var/ #set-variable = innobase_mirrored_log_groups=1 #set-variable = innobase_log_files_in_group=3 #set-variable = innobase_log_file_size=5M #set-variable = innobase_log_buffer_size=8M #innobase_flush_log_at_trx_commit=1 #innobase_log_archive=0 #set-variable = innobase_buffer_pool_size=16M #set-variable = innobase_additional_mem_pool_size=2M #set-variable = innobase_file_io_threads=4 #set-variable = innobase_lock_wait_timeout=50 Now I again remove the ib_files and restarted mysqld with the following my.cnf file and mysql crashes with a memory fault again. [mysqld] innobase_data_home_dir = /opt/mysql/var/ innobase_data_file_path = ib_data1:10M innobase_log_group_home_dir = /opt/mysql/var/ The funny thing is, that if you initialize the innobase stuff with the '2 line' my.cnf you can afterwards enable 'innobase_log_group_home_dir = /opt/mysql/var/' and mysqld keeps on running. Any idea? Greetings from Germany Andre -- E-Mail: [EMAIL PROTECTED] Date: 05-Apr-01 Time: 17:17:27 () Join the ASCII ribbon campaign against html email /\ and Microsoft attachments. "I heard if you play the NT-4.0-CD backwards, you get a satanic message" "That is nothing, if you play it forward, it installs NT-4.0" -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Client running pSOS
Hi, I'd like to run a mysqlclient on a homemade communication hardware running pSOS operating system. Has somebody already ported the mysqlclient to pSOS ? If not, what should I begin with, and how difficult would it be ? Thanks Christophe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: .36 memory fault with innobase on HP-UX11
Andre, innobase_log_arch_dir should be the same as innobase_log_group_home_dir. Now there is an extra 'mysql' in the path. You probably do not have that directory existing, and Innobase asserts a failure. I am sorry, I will change the assert to an error message in the next release, but have been too busy lately. But you were able to compile on HP-UX? Regards, Heikki .. Hi, I use the following my.cnf: [mysqld] innobase_data_home_dir = /opt/mysql/var/ innobase_data_file_path = ib_data1:10M innobase_log_group_home_dir = /opt/mysql/var/ innobase_log_arch_dir = /opt/mysql/mysql/var/ set-variable = innobase_mirrored_log_groups=1 set-variable = innobase_log_files_in_group=3 set-variable = innobase_log_file_size=5M set-variable = innobase_log_buffer_size=8M innobase_flush_log_at_trx_commit=1 innobase_log_archive=0 set-variable = innobase_buffer_pool_size=16M set-variable = innobase_additional_mem_pool_size=2M set-variable = innobase_file_io_threads=4 set-variable = innobase_lock_wait_timeout=50 After first starting mysql with the start.server script innobase create the necessary files in the /opt/mysql/var directory but than it ends up with a memory fault..err:010405 16:45:39 mysqld started Innobase: The first specified data file /opt/mysql/var/ib_data1 did not exist: Innobase: a new database to be created! Innobase: Log file /opt/mysql/var/ib_logfile0 did not exist: new to be created Innobase: Log file /opt/mysql/var/ib_logfile1 did not exist: new to be created 010405 16:45:44 mysqld ended Restarting mysql everytimes reproduces the memory fault. After some experiments I found that the line innobase_log_group_home_dir = /opt/mysql/var/causes the problem If I start mysql (after removing all ib_files) with the following my.cnf everthing works fine:[mysqld]innobase_data_home_dir = /opt/mysql/var/ innobase_data_file_path = ib_data1:10M #innobase_log_group_home_dir = /opt/mysql/var/ #innobase_log_arch_dir = /opt/mysql/mysql/var/ #set-variable = innobase_mirrored_log_groups=1 #set-variable = innobase_log_files_in_group=3 #set-variable = innobase_log_file_size=5M #set-variable = innobase_log_buffer_size=8M#innobase_flush_log_at_trx_commit=1 #innobase_log_archive=0#set-variable = innobase_buffer_pool_size=16M #set-variable = innobase_additional_mem_pool_size=2M #set-variable = innobase_file_io_threads=4 #set-variable = innobase_lock_wait_timeout=50 Now I again remove the ib_files and restarted mysqld with the following my.cnf file and mysql crashes with a memory fault again.[mysqld] innobase_data_home_dir = /opt/mysql/var/innobase_data_file_path = ib_data1:10M innobase_log_group_home_dir = /opt/mysql/var/ The funny thing is, that if you initialize the innobase stuff with the '2 line' my.cnf you can afterwards enable 'innobase_log_group_home_dir = /opt/mysql/var/' and mysqld keeps on running.Any idea?Greetings from Germany Andre - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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] cant start mysqld process
Hello, I just finished moving my database to another machine. It was running fine and after I rebooted I now get an error when I try to run safe_mysqld . When I look in mysql/data/comproom.err file, I get a message about '... cant find file: './mysql/host.ISM' (errno: 13) thanks for any help kevin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Using Full-Text Query in the HAVING clause
Description: Pretty simple, just try to do a "match(column) against ('text') in the HAVING clause of a SELECT statement. Restarts my database server every time. How-To-Repeat: Above Fix: Restructure the query. The reason I want to do this is to run the Full-Text match AFTER I limit the result set with other criteria. It works, but I'm trying for better performance. Submitter-Id: submitter ID Originator:[EMAIL PROTECTED] Organization: CFOknows, LLC MySQL support: none Synopsis: Full-Text Query in HAVING clause crashes MySQL Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.36 (Official MySQL RPM) Environment: System: Linux jay 2.2.16-22 #1 Mon Oct 30 20:26:30 PST 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.0) Compilation info: CC='egcs' CFLAGS='-O6 -fomit-frame-pointer -mpentium' CXX='egcs' CXXFLAGS='-O6 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 11 Dec 1 16:30 /lib/libc.so.6 - libc-2.2.so -rwxr-xr-x1 root root 5155229 Jan 10 19:09 /lib/libc-2.2.so -rw-r--r--1 root root 24498288 Jan 10 18:35 /usr/lib/libc.a -rw-r--r--1 root root 178 Jan 10 18:35 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man --without-berkeley-db --without-innobase '--with-comment=Official MySQL RPM' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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] cant start mysqld process
In my mysql/data/mysq directory all the permissions are set to 660. Any ideas on what host.ISM file that it is looking for. I never seen it before and when I check the old server I can't find it. thanks kevin -- From: "Brian Warn" [EMAIL PROTECTED] To: "Kevin J. MacDonald" [EMAIL PROTECTED] Subject: Re: [mysql] cant start mysqld process Date: Thu, Apr 5, 2001, 12:53 PM Kevin, Make sure that the permissions on your mysql database are at least 660. I had the same problem. After fixing, the problems went away. - Original Message - From: "Kevin J. MacDonald" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 05, 2001 8:43 AM Subject: [mysql] cant start mysqld process Hello, I just finished moving my database to another machine. It was running fine and after I rebooted I now get an error when I try to run safe_mysqld . When I look in mysql/data/comproom.err file, I get a message about '... cant find file: './mysql/host.ISM' (errno: 13) thanks for any help kevin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Moving MySQL database(s)
Hi, I've developed my mysql databases/tables on a local intranet server. What's involved in correctly copying them to an online linux machine please? regards, Graham Nichols
SQL query question?
Hi there, So a question I have two tables. And i want to... (i just show you) Table 1. OwnerChar(30)Uniqe FileChar(80) OIDint(not in use yet) Table 2. IDintuniqe and so on OwnerChar NameChar adress etc So I want to give the OID in table 1 the corresponding ID from Table 2 so that I may remove The Owner Col. I can do it with using tmp tables and so on, ( my knowlage in SQL querys is wery limited), But I want to do it with Just ONE singel SQL line Any ideas? /roger
Hey MySQL
How do I add a user? P.S. ALL YOUR MySQL DATABASE ARE BELONG TO US!! --- Clinton Ecker http://www.phaedo.cx http://www.picabomb.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] cant start mysqld process
Another thought. These are isam tables, not myisam tables. Unless the two machines are the same hardware type and operating system, you can't just copy the files over. Use msqldump. "Kevin J. MacDonald" wrote: In my mysql/data/mysq directory all the permissions are set to 660. Any ideas on what host.ISM file that it is looking for. I never seen it before and when I check the old server I can't find it. thanks kevin -- From: "Brian Warn" [EMAIL PROTECTED] To: "Kevin J. MacDonald" [EMAIL PROTECTED] Subject: Re: [mysql] cant start mysqld process Date: Thu, Apr 5, 2001, 12:53 PM Kevin, Make sure that the permissions on your mysql database are at least 660. I had the same problem. After fixing, the problems went away. - Original Message - From: "Kevin J. MacDonald" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 05, 2001 8:43 AM Subject: [mysql] cant start mysqld process Hello, I just finished moving my database to another machine. It was running fine and after I rebooted I now get an error when I try to run safe_mysqld . When I look in mysql/data/comproom.err file, I get a message about '... cant find file: './mysql/host.ISM' (errno: 13) thanks for any help kevin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Avoiding roundtrips
Hi. I guess we all are waiting for subselects in Mysql...but can you do many sql-commands in a single execution, with a nice finally-result-select at the end? Many roundtrips feels bad... kind regards Tomas
turning logging on/off while server is running
Hi all, Is there a way to turn the query logging on and off while the database server is running? Right now I have a script that stops and restarts the database with loggin on or off depending on the parameters, but this is not so great; I was wondering if there is another way. Also, is there a way to query the server if logging is on or off? I'd like to write a nice gnome applet to start/stop logging but I'm not sure how to get this value. cheers, roel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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] cant start mysqld process
thanks, I'm going to give that a try kevin -- From: Gerald Clark [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: [mysql] cant start mysqld process Date: Thu, Apr 5, 2001, 1:21 PM Another thought. These are isam tables, not myisam tables. Unless the two machines are the same hardware type and operating system, you can't just copy the files over. Use msqldump. "Kevin J. MacDonald" wrote: In my mysql/data/mysq directory all the permissions are set to 660. Any ideas on what host.ISM file that it is looking for. I never seen it before and when I check the old server I can't find it. thanks kevin -- From: "Brian Warn" [EMAIL PROTECTED] To: "Kevin J. MacDonald" [EMAIL PROTECTED] Subject: Re: [mysql] cant start mysqld process Date: Thu, Apr 5, 2001, 12:53 PM Kevin, Make sure that the permissions on your mysql database are at least 660. I had the same problem. After fixing, the problems went away. - Original Message - From: "Kevin J. MacDonald" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 05, 2001 8:43 AM Subject: [mysql] cant start mysqld process Hello, I just finished moving my database to another machine. It was running fine and after I rebooted I now get an error when I try to run safe_mysqld . When I look in mysql/data/comproom.err file, I get a message about '... cant find file: './mysql/host.ISM' (errno: 13) thanks for any help kevin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 - maker
On Thu, Apr 05, 2001 at 06:42:25PM +0200, Leif Sundin wrote: I have problems with mySQL-maker, I can't connect to my mySQL database. I have a account at http://www.cihost.com At home we have a local network, and my friend have a mySQL database on his computer.. and that database I can connect to very easy. So why can't I connect to my mySQL database at www.cihost.com? I am behind a firewall, has Yes, the firewall is blocking that. Open up port 3306, or setup a port redirector on the remote host to listen on a port that your firewall allows. cheers, roel that something to do with it?... I'm confused! ... I love mySQL-maker and I want to use that. P.S I can connect to my mySQL database when I telnet to my account at cihost. That's works great. But I want to use mySQL-maker. Thanks! Best Regards / Ted - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Moving MySQL database(s)
"Graham Nichols" [EMAIL PROTECTED] wrote: I've developed my mysql databases/tables on a local intranet server. What's involved in correctly copying them to an online linux machine Stop the mysql server on the intranet and FTP the files in the MySQL data directory to the MySQL data directory on the destination machine. OR While the mysql server is still running, use "mysqldump" to create a dump file of SQL command that can be piped to MySQL to recreate the tables, then FTP them to the destination machine and pipe the dump files to MySQL. Search the list archives and manual for more info. This has been covered a lot. -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.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: query problem with MySQL
one.in case if he selects multiple fields, how could i provide my user with all set of records which contains what all data he placed in query form. I think you want to study a bit more on MySQL and PHP. If you take the time to go to sites like www.devshed.com you might get an idea of how MySQL works. If you feel you need to study more (and I think you do), buy a good book like MySQL written by Paul DuBois. After all this reading you know what you're up against, and you'll get an idea about how you can do what you want. Bye, B. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SQL query question?
It's not possible to do in one step in MySQL. -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.com/ "roger westin" [EMAIL PROTECTED] wrote: So a question I have two tables. And i want to... (i just show you) Table 1. OwnerChar(30)Uniqe FileChar(80) OIDint(not in use yet) Table 2. IDintuniqe and so on OwnerChar NameChar adress etc So I want to give the OID in table 1 the corresponding ID from Table 2 so that I may remove The Owner Col. I can do it with using tmp tables and so on, ( my knowlage in SQL querys is wery limited), But I want to do it with Just ONE singel SQL line Any ideas? /roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Running crash-me against remote M$ SQL Server
Dear Y'all - I've developed a diff-based testing framework in perl. It's used to qualify modifications we want to make to systems (i.e. applying patches, installing applications...) for deployment to a thousand some odd machines. The testing framework runs on linux and tests target machines that run linux, solaris and Windoze NT. One of the capabilities we test on those target machines is the DBMS. The test framework compares crash-me runs on the linux MySQL servers from before and after we make the change and highlights the changes which we then analyze. I also want to run crash-me on the linux box against M$ SQL Server on the NT boxes and see how the results change. It's proving to be difficult to do that. Finally we get to my question. Can anyone give me pointers on how to setup the linux box so that I can run crash-me against the remote NT box's SQL Servers. Crash-me is running fine on the linux test server and I've been experimenting with unixODBC and other utilities. Is there no other solution other than finding a M$ SQL Server ODBC driver that runs on linux and is there such a thing? Yours - Billy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to run two mysql servers on one machine(NT4.0 or Solaris 5.8)
Hi, guys, This is Jing. I need a favor. I am trying to run two mysql servers on one machine. But I do not know how to do it correctly. I created a database using mysql, the database is a part of our product. And meantime, we have another mysql with the third party software(AdventNet). My high designer wants that we run two servers together on one machine(NT or Sun Solaris 5.8). I read the mysql manual "11. Replication in mysql". But I am not sure if it is right way for this situation. And also I cannot understand well what it talked in the manual. Could you please give me some help? Where is the file that named my.cnf? Do I need to create it or does it already exist? Thank all of you, and have a good day, Jing Chen
Re: Running crash-me against remote M$ SQL Server
Perl/DBI, or any mysql client on Linux should connect to mysql on NT with no problem. Why would you need ODBC? William Goedicke wrote: Dear Y'all - I've developed a diff-based testing framework in perl. It's used to qualify modifications we want to make to systems (i.e. applying patches, installing applications...) for deployment to a thousand some odd machines. The testing framework runs on linux and tests target machines that run linux, solaris and Windoze NT. One of the capabilities we test on those target machines is the DBMS. The test framework compares crash-me runs on the linux MySQL servers from before and after we make the change and highlights the changes which we then analyze. I also want to run crash-me on the linux box against M$ SQL Server on the NT boxes and see how the results change. It's proving to be difficult to do that. Finally we get to my question. Can anyone give me pointers on how to setup the linux box so that I can run crash-me against the remote NT box's SQL Servers. Crash-me is running fine on the linux test server and I've been experimenting with unixODBC and other utilities. Is there no other solution other than finding a M$ SQL Server ODBC driver that runs on linux and is there such a thing? Yours - Billy - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Running crash-me against remote M$ SQL Server
I think William mentioned MS-SQL - as opposed to mysql - on the NT box... P On Thu, 5 Apr 2001, Gerald Clark wrote: Perl/DBI, or any mysql client on Linux should connect to mysql on NT with no problem. Why would you need ODBC? William Goedicke wrote: Dear Y'all - I've developed a diff-based testing framework in perl. It's used to qualify modifications we want to make to systems (i.e. applying patches, installing applications...) for deployment to a thousand some odd machines. The testing framework runs on linux and tests target machines that run linux, solaris and Windoze NT. One of the capabilities we test on those target machines is the DBMS. The test framework compares crash-me runs on the linux MySQL servers from before and after we make the change and highlights the changes which we then analyze. I also want to run crash-me on the linux box against M$ SQL Server on the NT boxes and see how the results change. It's proving to be difficult to do that. Finally we get to my question. Can anyone give me pointers on how to setup the linux box so that I can run crash-me against the remote NT box's SQL Servers. Crash-me is running fine on the linux test server and I've been experimenting with unixODBC and other utilities. Is there no other solution other than finding a M$ SQL Server ODBC driver that runs on linux and is there such a thing? Yours - Billy - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Running crash-me against remote M$ SQL Server
William Goedicke wrote: Finally we get to my question. Can anyone give me pointers on how to setup the linux box so that I can run crash-me against the remote NT box's SQL Servers. Crash-me is running fine on the linux test server and I've been experimenting with unixODBC and other utilities. Is there no other solution other than finding a M$ SQL Server ODBC driver that runs on linux and is there such a thing? I believe that perl's DBD::Sybase can be used to connect to MS SQL server. I've never done it myself mind you, but heard it to be true. -- Josh _ Joshua Chamas Chamas Enterprises Inc. NodeWorks free web link monitoring Huntington Beach, CA USA http://www.nodeworks.com1-714-625-4051 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MyAccess by Hubertus Hiden, [Slighlty OT]
Hi, Does anyone have any experience with MyAccess (http://www.accessmysql.com) by Hubertus Hiden? (This is an Access Addin which queries MySQL via ODBC for importing and exporting data and tables.) We have a client who uses Access and I'm determining if we should develop in Access and ASP rather than MySQL and PHP (which I'd prefer). I'm interested to hear any experiences with MyAccess. Anyone? Thanks! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Need offsite Web developer
We are looking for an offsite Web Developer to work on an upcoming project that will include MySQL programming. Please respond to [EMAIL PROTECTED] and we will give you the project details. Thank you, Maroa Gikuuri - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
subqueries
Howdy, all. I note that subqueries are in the "to be done real soon" list. Is anyone working on this for 4.0 or 4.1? I note that it did not seem to be in the 4.0 todo, but sometimes things make someone's hot project list without being reflected in the todo. Scott Scott Ellsworth [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
Visual Foxpro 6 (again)
Thanks for all the advice about using Visual Foxpro 6 with MySQL. I have started to create my application and have come across a strange problem. In MySQL i have a field in a table called Address1, it is VARCHAR(40) ... when i create my view i can run the sql and see the results no problem. As soon as I save the view and then try to browse the view I get a datatype is invalid error. Looking at the properties of Address1 it seems to have been bought into the fox view a CHAR(1) ... any ideas Regards Chris. I have the latest win32 version of mysql (binary) the latest mysqlodbc driver and visual fox 6 (sp5)br clear=allhrGet Your Private, Free E-mail from MSN Hotmail at a href="http://www.hotmail.com"http://www.hotmail.com/a.br/p
import - date format
Hi there, I have many files need import into mysql database. Unfortunately, the date format in my csv file is mm/dd/, so is there a wordaround that I don't need write another script to convert all my files? Thanks. Kevin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Running crash-me against remote M$ SQL Server
"GC" == Gerald Clark [EMAIL PROTECTED] writes: GC Perl/DBI, or any mysql client on Linux should connect to mysql on NT GC with no problem. Why would you need ODBC? Except that perl/DBI requires an underlying C library for the DBMS in question. I understand that the sybase libs might be able to talk to MS SQL server, so that may be an option. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: import - date format
Hi, If you use DBTools (http://dbtools.vila.bol.com.br), using the import text wizard you have a lot of parameters to set, including date format and separators. Unfortunatelly, runs only on windows platforms. []'s Crercio -Original Message- From: Kevin Xin Lin [mailto:[EMAIL PROTECTED]] Sent: quinta-feira, 5 de abril de 2001 17:12 To: [EMAIL PROTECTED] Subject: import - date format Hi there, I have many files need import into mysql database. Unfortunately, the date format in my csv file is mm/dd/, so is there a wordaround that I don't need write another script to convert all my files? Thanks. Kevin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
RAID stripping for MySQL
It was mentioned to me today that there are various RAID policies necessary for optimal performance for diffferent programs such as SQL, Oracle, etc. Are there any special or recommended policies (like stripe size, etc) for MySQL running under Solaris 8/i86 with a PERC2/DC configured for RAID 5 on the data drive? Thanks. -- Alan W. Rateliff, II - L.I.V.R. // Only Amiga Makes it Possible (Learned, Impartial and Very Relaxed) \X/ Power for Creative Minds... This signature looks great if you don't use proportional fonts! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Perl - DBD:DBI Errors
Gerald, I grabbed the correct rpm for zlib under RedHat/RPMS - but I still get the error message: rpm -ivh zlib-1.1.3-6.rpm Unable to open /usr/lib/rpm/rpmrc for reading: No such file or directory. I'm logged in as root. Any ideas? Thanks, Chris B -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gerald Clark Sent: Wednesday, April 04, 2001 10:23 AM To: Chris Becker Cc: [EMAIL PROTECTED] Subject: Re: Perl - DBD:DBI Errors Chris Becker wrote: I checked my RH6.2 install cd's and found zlib-1.1.3-6.src.rpm, I went to install the package with the following command and get the following error: rpm -ivh zlib-1.1.3-6.src.rpm Unable to open /usr/lib/rpm/rpmrc for reading: No such file or directory. When I originally installed the os I selected a custom install and checked every option provided. Why can I not use the rpm utility? Do I need to install that? I have an rpm entry in the man pages??? I am logged in as root. Please help, and... Thanks Again, ChrisB -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gerald Clark Sent: Wednesday, March 28, 2001 9:26 AM To: Chris Becker Cc: [EMAIL PROTECTED] Subject: Re: Perl - DBD:DBI Errors You don't have zlib on your machine. Check your 6.2 CD. Chris Becker wrote: I'm having trouble installing the perl module DBD specifically. I found on my CPAN cd the DBD module Msql-Mysql-modules-1.2208, tried to install it and got errors, I discovered I needed DBI installed first. So I found DBI-1.13 and did the following: perl Makefile.PL make make test Made 100 connections in 0 wallclock secs... test.pl done DBI seemed to install ok. Then I found DBD Msql-Mysql-modules-1.2210 and did the following: perl Makefile.PL select 1) MySQL only n - for install perl emulation then make make test then get output from make test: ...install_driver(mysql) failed: Can't load '../blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ../blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: uncompress at /usr/lib/perl5/5.00503/i386-linux/DynaLoader.pm line 169. at (eval 1) line 3 at t/00base.t line 38 dubious Test returned status 255 (wstat 65280, 0xff00) Undefined subroutine Test::Harness::WCOREDUMP called at /usr/lib/perl5/5.00503/ Test/Harness.pm line 288. make[1]: *** [test_dynamic] Error 255 make[1]: Leaving directory '/perlmods/Msql-Mysql-modules-1.2210/mysql' make: *** [test] Error\ 2 after the above errors even i tried executing the 'make install'. Then I tried a sample perl file using the 'use DBI' function to test the perl module install w/ MySQL, and when I execute I get the same error: undefined symbol: uncompress at blah blah blah... Please Help. What am I doing wrong? Do I need to do an un-install before trying to re-install DBD? Should I blow out Perl altogether and reinstall? Has anyone seen this before? Thanks in advance, Chris Becker That is a source RPM. Your looking in the wrong directory. look on RedHat/RPMS - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
free admin/client gui for win32
Can any one share with me a good free admin/client GUI for win32? Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Firewall logged probes on mysql port
My firewall has denied and logged several of the following messages: Packet log: input DENY eth0 PROTO=6 192.168.0.1:37656 66.31.176.185:3306 L=40 S=0x00 I=26581 F=0x T=39 (#2) As you can see, it is a spoofed IP trying to connect to the mysql port. I've looked around at basic security sites (sans.org, whitehats.com) and haven't found any documentation of specific exploits against MySQL. My questions are 1) do others typically see this? 2) what do you do? (my guess is, not much)3) Are there other security measures I should be taking? and finally 4) are there any documented MySQL exploits? (buffer overflows) Regards, Gary "SuperID" Huntress === FreeSQL.org offering free database hosting to developers Visit http://www.freesql.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
Foreign Keys
Are people using Mysql using foreign keys and how are they using them? It seems that the way to use them is with the scripting language used to access the 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: Firewall logged probes on mysql port
Gary Huntress wrote: My firewall has denied and logged several of the following messages: Packet log: input DENY eth0 PROTO=6 192.168.0.1:37656 66.31.176.185:3306 L=40 S=0x00 I=26581 F=0x T=39 (#2) As you can see, it is a spoofed IP trying to connect to the mysql port. I've looked around at basic security sites (sans.org, whitehats.com) and haven't found any documentation of specific exploits against MySQL. My questions are 1) do others typically see this? 2) what do you do? (my guess is, not much)3) Are there other security measures I should be taking? and finally 4) are there any documented MySQL exploits? (buffer overflows) Regards, Gary "SuperID" Huntress Gary: Firewalls are a great start. This is the first defence and it sounds like you're hitting all the useful places: sans.org, securityfocus.com, rootshell.org. An IDS is always a good call, too, but, it's tough to IDS your mysql database while keeping it useful, but, it can be done with portsentry (psionic.com). WRT looking for the probes, I run across them from time to time, but, since it's caught by the firewall, I don't really pay too much attention to it. They're not getting anywhere, anyway. They'd have better chances finding a way to break the web server. The biggest concerns are the lpd, named, ftp, rpc, and, now ntp daemons. If you don't need 'em don't use 'em. If you do, firewall them and restrict access to your own hosts/networks. Best Regards, Van -- = Linux rocks!!! http://www.dedserius.com = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Firewall logged probes on mysql port
It's late.. I want to catch some sleep.. but I found a few on the incidents list.. http://www.securityfocus.com/bid/926 http://www.securityfocus.com/bid/975 According to some people on the incidents lists there seems to be one or two probes going on for MySQL servers.. dunno what they're looking for. Bye, B. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Firewall logged probes on mysql port
Maybe they just seeing if MySQL is 'as open' as Interbase... http://www.securityfocus.com/frames/?content=/templates/advisory.html%3Fid%3D3152 There are a lot of 'robotic probes' going on out there (most commonly looking for FTP access). Just 'batten down the hatches' and keep monitoring... "B. van Ouwerkerk" wrote: It's late.. I want to catch some sleep.. but I found a few on the incidents list.. http://www.securityfocus.com/bid/926 http://www.securityfocus.com/bid/975 According to some people on the incidents lists there seems to be one or two probes going on for MySQL servers.. dunno what they're looking for. Bye, B. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Firewall logged probes on mysql port
One thing you should do to protect your MySQL 'instance' , is have it running on a system 'behind' your 'front line' defenses (i.e. Firewall) and not 'on it'. Setup MySQL to listen only on the interface that your webserver or other 'client' is communicating on (we have a 'private' network connecting the application webservers to the MySQL server via 2nd set of network cards, with the MySQL 'ports' only accessible via that network, which takes some "ipchains" configuration). Also, the user list, should have only the 'host names' (i.e. "web1_private") that are allocated via the 'private' net (so that users coming in from the regular network have no 'permissions' or login entries). NOTE: by only 'registering' the 'private' host names in the "/etc/hosts" files, you can use the 'underscore' ("_") character in the hostname, which is 'illegal' in the newer BIND (DNS) versions, protecting you from anyone trying to gain access by 'spoofing' the hostname... Gary Huntress wrote: My firewall has denied and logged several of the following messages: Packet log: input DENY eth0 PROTO=6 192.168.0.1:37656 66.31.176.185:3306 L=40 S=0x00 I=26581 F=0x T=39 (#2) As you can see, it is a spoofed IP trying to connect to the mysql port. I've looked around at basic security sites (sans.org, whitehats.com) and haven't found any documentation of specific exploits against MySQL. My questions are 1) do others typically see this? 2) what do you do? (my guess is, not much)3) Are there other security measures I should be taking? and finally 4) are there any documented MySQL exploits? (buffer overflows) Regards, Gary "SuperID" Huntress
Re: Visual Foxpro 6
Hi, it works very well via MyODBC with either SQLCONNECT(), SQLEXEC() into local cursors or Remote Views stored in a local VP database. From: "Christopher Davis" [EMAIL PROTECTED] To: "mysqllist" [EMAIL PROTECTED] Subject: Visual Foxpro 6 Date: Thu, 5 Apr 2001 10:01:57 +0100 I wish to use MySQL as a backend to a Visual Foxpro 6 client application, has anyone got any experience of this ? Does it work ?
date select question
Hi, I'm trying to figure out how to select records from an events database which (from today) will take place on next weekend. The table has a from_date and a to_date fields, among other. I've found a way mixing PHP with SQL, but I'm curious to know if is there a neat and pure SQL version using the built-in date functions in mySQL. TIA, Llorenc Sole Maresme Netcom, S.L. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Errant (Replication) error: ERROR 1200: The server is not configured as slave
Hi All, Sorry if I'm missing something totally daft here... I've got my master and slave hosts (both runng MySQL 3.23.36) configured roughly as-per the HOWTO, ( as follows ) to replicate the "test" database, but not the "mysql" database [btw. it's not clear from the docs that if you omit both binlog-ignore-db and binlog-do-db whether all, or none of the databases are replicated.. what is the actual case there? ] Now, I'm not sure I've got the 'master-port' setting on the slave right, infact I think it's wrong, because that's the client connection port, but netstat or the docs wouldn't tell me a more likely port number, so I guessed. (is that the wrong port?). So either I have the wrong port, or there's a bug, because (and nothing appears in the .err file on the slave or master about this) when I do a "SLAVE START" on the slave, it goes: "mysql slave start; ERROR 1200: The server is not configured as slave, fix in config file or with CHANGE MASTER TO" ... even when I've configured the slave just as it suggests... So, could someone please let me know if I'm being stupid, or if it's MySQL that's at fault here? Thanks in advance. Yours, Kev. Master: cat /etc/my.cnf [mysqld] log-bin=/var/lib/mysql/replication server-id=2 binlog-do-db=test binlog-ignore-db=mysql mysql show full processlist; +-+--+---+--+-+--+---+-- -+ | Id | User | Host | db | Command | Time | State | Info | +-+--+---+--+-+--+---+-- -+ | 117 | sendmail | localhost | sendmail | Sleep | 28 | | NULL | | 118 | sendmail | localhost | sendmail | Sleep | 28 | | NULL | | 121 | sendmail | localhost | sendmail | Sleep | 28 | | NULL | | 127 | root | localhost | NULL | Query | 0| NULL | show full pro cesslist | +-+--+---+--+-+--+---+-- -+ 4 rows in set (0.00 sec) mysql show master status; +-+--+--+--+ | File| Position | Binlog_do_db | Binlog_ignore_db | +-+--+--+--+ | replication.002 | 147 | test,test| mysql,mysql | +-+--+--+--+ 1 row in set (0.00 sec) mysql exit Bye Slave: [mysql] server-id=4 master-host=lestat.ore.org master-user=replicate master-password=splitter log-slave-updates=/var/lib/mysql/slave-updates.log master-port=3306 mysql show full processlist; ++--+---+--+-+--+---+--- + | Id | User | Host | db | Command | Time | State | Info | ++--+---+--+-+--+---+--- + | 1 | root | localhost | test | Query | 0| NULL | show full processlist | ++--+---+--+-+--+---+--- + 1 row in set (0.00 sec) mysql show slave status - ; ++-+-+---+-+ -+---+-+-++- ---+--+ | Master_Host| Master_User | Master_Port | Connect_retry | Log_File| Pos | Slave_Running | Replicate_do_db | Replicate_ignore_db | Last_errno | Last _error | Skip_counter | ++-+-+---+-+ -+---+-+-++- ---+--+ | lestat.ore.org | replicate | 3306| 60| replication.002 | 73 | No| | | 0 | | 0| ++-+-+---+-+ -+---+-+-++- ---+--+ 1 row in set (0.00 sec) mysql -- "Life is the sieve through which my anarchy strains, resolving itself into words" Kev Green, aka. Kyrianwww.ore.org -- Bad Religion - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Strange problem.
Hi! "Peter" == Peter Zaitsev [EMAIL PROTECTED] writes: Peter Hello , Peter Few time ago I've started to get the following problems, which several Peter times allready lead to data lost for me. Peter Here is the example: Peter I found the followings in my application error log: Peter Query - #1017 [opal.local] - Can't find file: 'g04stat_languages.MYD' (errno: 2) Peter select visitors,loads,id ,hits from layers_st45.g04stat_languages where layer_id=19573 Peter 05.Apr 16:30:28 : pid:5224 h -- 65972/0 AllInOne rec:0 l:0 tm:1627.20 # Peter 05.Apr 16:30:28 : pid:5224 h 65972/0 [03.23 17:10] - [01.01 02:59] q:3.73 i:0.00 a:3.26 # cut Peter This is not the worst case - in several tables I had .MYD file to be Peter not existant, but TMD file left - so I just rename it and it works Peter find. One or two times I didn't find even TMD file so I had to look Peter at my backups. This indicates that there is some bug when running with --myisam-recover The only way I can see that the above would happen is if MySQL got killed hard between 2 system calls (not likely) or if there is a bug in the function: mysys/my_redel.c The my_redel() functions should delete the .MYD file and then rename the .TMD file as the .MYD file. I can't however see how this could ever go wrong. There could of course be a bug where the rename system call fails We could fix this for system that has the rename call (like Linux) by doing the following change in my_redel.c: } else if (my_delete(org_name,MyFlags)) goto end; if (my_rename(tmp_name,org_name,MyFlags)) goto end; - #ifndef HAVE_RENAME else if (my_delete(org_name,MyFlags)) goto end; #endif if (my_rename(tmp_name,org_name,MyFlags)) goto end; Peter, could you try the above and check if this helps you solve this problem ? Peter Looking at the table I found They are usually distributed in one table Peter group - for example I get many from layers_stXX.gXX* lost there no Peter over tables lost, so I think this is related to my purge program (this Peter is still mysql bug anyway :)) ). The thing is after deleting some data Peter from table the program uses REPAIR table - this is from the times Peter then optimize table was several times slower. Peter I'm using mysql 3.23.36, and nothing is changed in system, only mysql, Peter also I had this problem with mysql 3.23.32 if I'm not mistaken. Peter I'll try to make an repeatable example but I'm not shure I'll be able Peter to do so as this does not happens to all tables this program work with Peter - this may happen only in some specific cases - may be then other Peter program is working with the table or something. Try using the following test program as a base for this: I have during the previous week run the above program for days without ANY problems in REPAIR; This probably only means that you are doing something different compared to this program. If we can find this out, we will know a lot more! Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Signal to Noise Ratio...
Hi! "Eric" == Eric Fitzgerald [EMAIL PROTECTED] writes: Eric This is an open plea to the MySQL team. The amount of spam and other noise Eric on the list has been growing more and more every day. I would like to make Eric a couple basic plea's. The first, is that you require a poster to the list Eric have an actual account on the list, that should help cut out some of the Eric general spam. Second, perhaps setup some basic moderation, I'll help if Eric need be :) Eric I think the last thing we all need is more spam coming down our pipes, so if Eric anything can be done to help prevent this, it would make everyone's lives Eric easier...except of coarse the low life scum that get's a rise out of farming Eric a list for E-Mails or even sending spam to the list. This thing has been up a couple of times over the years. The problem is that requiring people to be subscribers to the mailing list before posting will only confuse the poor people that don't expect to get 100 emails per day after subscribing. We need to come up with something better than the above. Here follows some suggestions: - Split the main (big) list into smaller, more specific lists. - Require the person to be either subscribed to the list or that the email should contain the word 'MySQL'. (Sasha, would it be easy to fix the last thing). - Add better spam filters; Matt, do you have any ideas for this? Erik do you have any additional suggestions? Regards. Monty PS: I did a quick scan of the [EMAIL PROTECTED] archive, but didn't see that many spams; Erik, what is your notion about this? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 functions crash
On Wednesday 04 April 2001 04:03, Max Hammond wrote: I'll just add that if anyone wants a dump of the data causing this, drop me a note at [EMAIL PROTECTED] and I'll mail it to you, it's about 2500 rows, and only that one field necessary to crash it. Cheers, Max Fix: --- 1.11/sql/time.ccWed Nov 15 13:59:54 2000 +++ edited/time.cc Thu Apr 5 17:48:04 2001 @@ -428,11 +428,15 @@ uint field_length,year_length,digits,i,number_of_fields,date[7]; bool date_used=0; const char *pos; - const char *end=str+length; DBUG_ENTER("str_to_TIME"); DBUG_PRINT("enter",("str: %.*s",length,str)); - for (; !isdigit(*str) str != end ; str++) ; // Skipp garbage + if(!str) +DBUG_RETURN(TIMESTAMP_NONE); + + const char *end=str+length; + + for (; !isdigit(*str) str != end ; str++) ; // Skip garbage if (str == end) DBUG_RETURN(TIMESTAMP_NONE); /* The problem was actually not in deally with invalid wannabe-fuzzy dates, but rather in converting an empty string text/blob field to a date. Monty - I have considered several ways to fix it, and decided that checking for the NULL pointer in str_to_TIME() was the safest - it would take care of other potential buggy calls, if there happen to be any. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
DSN
To whom it may concern, How can I set a datasource name (DSN) for a database in MySQL? Thank you, Ha - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: REPOST: SELECT syntax
On Wed, 4 Apr 2001, Ashley M. Kirchner wrote: Db - table1, table2 and table3 SELECT table1.task, table2.comment, table2.remarks, table3.history FROM table1 LEFT JOIN table2 ON table1.id=table2.todoid LEFT JOIN table3 ON table1.id=table3.todoid WHERE table1.id=10; Results (roughly) in: +--++--+-+ | task | comment |remarks | history | +--++--+-+ | task_1 | cmt_1| rmk_1| | | task_1 | cmt_2| | | | task_1 | cmt_3| |hst_1| | task_1 | cmt_4| rmk_2| | | task_1 | cmt_5| |hst_2| | task_1 | cmt_6| | | +--++--+-+ However, what I'd really like to have is the following: +--++--+-+ | task | comment |remarks | history | +--++--+-+ | task_1 | 6 | 2 | 2 | +--++--+-+ How do I change the select clause to have COUNT() in it instead? AMK4 You get your COUNT() by adding the corresponding GROUP BY clause. I assume something like the following should work: SELECT table1.task,COUNT(table2.comment),COUNT(table2.remarks),COUNT(table3.history) FROM table1 LEFT JOIN table2 ON table1.id=table2.todoid LEFT JOIN table3 ON table1.id=table3.todoid WHERE table1.id=10 GROUP BY table1.task; hope it works, thalis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: date select question
"Llorenc Sole" [EMAIL PROTECTED] wrote: I'm trying to figure out how to select records from an events database which (from today) will take place on next weekend. The table has a from_date and a to_date fields, among other. I've found a way mixing PHP with SQL, but I'm curious to know if is there a neat and pure SQL version using the built-in date functions in mySQL. Can you explain differently or give some more detail? Perhaps show some actual table data, show what output you want, state explicitly in words what you want to accomplish and explain what the problem is. I'm sure I (and any number of others can help), but I don't understand the problem based on what you've written. -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.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: REPOST: SELECT syntax
"Thalis A. Kalfigopoulos" wrote: +--++--+-+ | task | comment |remarks | history | +--++--+-+ | task_1 | cmt_1| rmk_1| | | task_1 | cmt_2| | | | task_1 | cmt_3| |hst_1| | task_1 | cmt_4| rmk_2| | | task_1 | cmt_5| |hst_2| | task_1 | cmt_6| | | +--++--+-+ SELECT table1.task,COUNT(table2.comment),COUNT(table2.remarks),COUNT(table3.history) FROM table1 LEFT JOIN table2 ON table1.id=table2.todoid LEFT JOIN table3 ON table1.id=table3.todoid WHERE table1.id=10 GROUP BY table1.task; Based on the above data, and the above select, I get the following: +--+-+-+---+ | task | comment | remarks | history | +--+-+-+---+ | task_1 | 6 | 6 | 2| +--+-+-+---+ Obviously there are not 6 remarks, but only 2. So why is it counting 6? Is it because it's in the same table as the comments, and there are 6 comments? Does this mean MySQL counts an empty cell as having data in it? -- H | Hi, I'm currently out of my mind. Please leave a message. BP! | ~ Ashley M. Kirchner mailto:[EMAIL PROTECTED] . 303.442.6410 x130 Director of Internet Operations / SysAdmin. 800.441.3873 x130 Photo Craft Laboratories, Inc. .eFax 248.671.0909 http://www.pcraft.com .3550 Arapahoe Ave, #6 .. . . . .Boulder, CO 80303, U.S.A. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MyAccess by Hubertus Hiden, [Slightly OT]
I installed it and got it up and running very quickly and easily. It is really a great product. Access2sql utility works great, as does the ODBC linking and the table create/modify utility. If you find out anything about how to get BLOBS to work with it, let me know. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Signal to Noise Ratio...
"Michael Widenius" [EMAIL PROTECTED] wrote: This thing has been up a couple of times over the years. The problem is that requiring people to be subscribers to the mailing list before posting will only confuse the poor people that don't expect to get 100 emails per day after subscribing. In that case, you may want to consider implementing a MLM (mailing list manager) that allows subscribers to disable mail delivery. I know Mailman and some others have that feature. What MLM is MySQL using? In conjunction with that feature you could have an autoreply that gives non-subscribers who attempt to post a canned message with info. on the lists and instructions on subscribing. We need to come up with something better than the above. Here follows some suggestions: - Split the main (big) list into smaller, more specific lists. I used to think that was a good idea on technical lists, but as more and more less-technical people subcribe to lists like this I don't think it's wise. It seems that a lot of these people want a quick fix and don't want to put in the time or energy reading through list archives (which in my opinion is a bigger problem than spam on these lists) or posting to a lower-traffic, less publicized alternate mailing list. - Require the person to be either subscribed to the list or that the email should contain the word 'MySQL'. I don't think this will be effective. I just checked the last 10 messages I posted to the list. 6 had 'mysql' in the body and 4 didn't...and I was surprised that many did. (Sasha, would it be easy to fix the last thing). - Add better spam filters; Matt, do you have any ideas for this? Yesterday in this thread I mentioned Spam Bouncer http://www.spambouncer.org/. It's a set of procmail recipes that are pretty powerful, easy to modify and are pretty effective. I especially like the ability to automatically notify senders of false positives and provide them a password to resend the message and bypass the filtering system (which conceptually a spammer wouldn't do). I'd be glad to help you find a solution. Look at it this way, if you try something and it doesn't work you can always go back to what you have in place now. BTW, I think your company has done a fine job with MySQL. I've been using it for a few years and recommending it to lots of people. -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.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
Search Query
Hello All, I have been trying to figure out why the below query doesn't quiet produce the results we are looking for. I was hoping some one maybe able to shed some lite on why QUERY #3 returns the wrong results. If addition information is needed, please feel free to respond privately, off the list. Appreciate any help! It's been driving me wack-o! ;) == 1) QUERY w/o KEYWORDS: SELECT bi.bus_name,bi.address,bl.city,bl.state, bl.zipcode,h.hr_descript,bi.phone,bi.comments,bi.unique_url, CONCAT(bi.contact_fname," ",bi.contact_lname) AS name FROM bus_info bi,bus_loc bl,hours h WHERE bi.category = 'VEAD' AND bi.info_id = bl.loc_id AND h.hr_code = bi.hrs_open GROUP BY bi.bus_name 4 results - Correct = 2) QUERY w/KEYWORDS SELECT bi.bus_name,bi.address,bl.city,bl.state, bl.zipcode,h.hr_descript,bi.phone,bi.comments,bi.unique_url, CONCAT(bi.contact_fname," ",bi.contact_lname) AS name FROM bus_info bi,bus_search bs,bus_loc bl,hours h WHERE MATCH bs.keywords AGAINST ('book') OR bi.category = 'VEAD' OR bs.cat_prefix = 'VE' AND bs.bus_id = bi.info_id AND bi.info_id = bl.loc_id AND h.hr_code = bi.hrs_open GROUP BY bi.bus_name 5 results Correct Keywords match agaisnt "book" 3) QUERY w/Keywords SELECT bi.bus_name,bi.address,bl.city,bl.state, bl.zipcode,h.hr_descript,bi.phone,bi.comments,bi.unique_url, CONCAT(bi.contact_fname," ",bi.contact_lname) AS name FROM bus_info bi,bus_search bs,bus_loc bl,hours h WHERE MATCH bs.keywords AGAINST ('brake repair') OR bi.category = 'VEAD' OR bs.cat_prefix = 'VE' AND bs.bus_id = bi.info_id AND bi.info_id = bl.loc_id AND h.hr_code = bi.hrs_open GROUP BY bi.bus_name 5 results Incorrect should only be 4 results "brake repair" is not in the column keywords so it should not return the results. In the table that it searches(bus_search) for the keywords, column name: keywords varchar(225) with a FULLTEXT index on keywords During a keyword search it also checks the column: cat_prefix The data record it should be checking has the following info. this is the only record in this table right now. columnvalue *|* bus_id |9 keywords |"Secrets to the Best Car Deals negotiating prices book with tips for buying" cat_prefix | VE Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Signal to Noise Ratio...
- Require the person to be either subscribed to the list or that the email should contain the word 'MySQL'. I don't think this will be effective. I just checked the last 10 messages I posted to the list. 6 had 'mysql' in the body and 4 didn't...and I was surprised that many did. First, we can somewhat expand the list - add the words "database", "sql", and "query" to the sentry list. Second, if you forget one of those words, you will get a reply from the bot that will say something like: Your message did not make it to the list because you forget to mention one of the following: MySQL, SQL, database, query. If your message really has to do something with MySQL, just reply to this without modifying the body at all and your post will pass our spam filters. If there are no vehement objections to this, I will go ahead and implement this part right away. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How well does MySQL handle Web Publishing?
On Thu, 5 Apr 2001, Pete Koning wrote: Greetings! Quick background: i have extensive RDBMS experience (sybase, progress) but have been "out of the loop" in this field for a few years working as a sys-admin for a linux/unix-based ISP in Canada. We want to host a web-based resource center powered on the backend by an RDBMS. Documents to be displayed on this web site may take many forms: adobe, text and word processing documents, digitized images, hyperlinks, video and audio clips, etc. Text-based documents must be indexed and searchable by keywords entered by users. I would be interested in your experiences with MySQL in this respect. Specifically I'm trying to determine the following: 1. would text (word, excell, adobe, etc) be stored directly in the database? If not, how would they referenced? You can have them in the DB as BLOBs, or you can have them as files on the fs, and have the pathname in the DB 2. what about other document types (mgp, jpg, streaming-video, audio). binary files, are binary files. I'd go for the fs solution for all binary data. Makes them accessible by other applications if they are on the fs. 3. can text-based documents be indexed directly for quick searches? If not, do i need to manually index them via descriptor fields of some sort? Lookup the FULLTEXT at: http://www.mysql.com/doc/M/y/MySQL_full-text_search.html 4. what 'connective' software could be used to create web-based forms that can both query the database to retrieve documents? I don't get exactly what 'connective software' means, but you can create your CGI sitting behind your forms with just about anything you like. Take you pick: Perl, PHP, C, C++, Python are ones I'm aware of. 5. what would be the best software to use to create "input" forms to allow documents to be added/updated/deleted? Again I'm not clear. See above. 6. Most importantly, how well does MySQL handle this kind of application, as opposed to proprietary DBs like Sybase, Oracle and Progress? It is a worthy competitor :-) Make what you want of it. regards, thalis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
rpm with php
Hello All, I'm trying to install MySQL RPM with php. Should I use: --with-mysql or --with-mysql=/usr/bin or --with-mysql=/path/to/mysql ? Thanks for any suggestion/comment in advance! -- Best regards, Kenneth 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