unknown data base
I'm new to mysql, but going on ... I've set up user jupshoes to the data base phpbook with the GRANT command: GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON phpbook.* TO jupshoes@localhost IDENTIFIED BY 'jupshoes'; GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON phpbook.* TO jupshoes@panera IDENTIFIED BY 'jupshoes'; After that I've checked there are the related entries in to the user and the database tables. And now I want to populate the database, but the user jupshoes can't even see the database: (The user jupshoes connects to the host panera via TELNET) $ mysql -ujupshoes -pjupshoes phpbook unknown database or mysqlselect* from phpbook; No data base selected or $ mysql -ujupshoes -pjupshoes phpbookphpbook.sql(to populate the table) Unknown database What is going wrong? Thanks in advance! Josep - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't import dump file OS X
Thanks Brent, Yes, I too can import with LOAD DATA and mysqlimport, but the thing that's irritating is that I have to create the tables first in order to import the data in either case. With a 'regular' import from a dumped table, mysql should be able to read the SQL statements within the dump file to create the table(s) AND then populate them with the data. Job done in one hit! I'd appreciate if you could try this on your system and let me know how you get on! I've successfully imported a very small dataset (about 10k records) into MySQL under OSX. I'm just getting started in MySQL, so I'm afraid I don't have much to offer except to say it can be done. I'm not sure what syntax you are using in your example. All examples I've seen use the LOAD DATA ... INFILE ... INTO TABLE ... command to get a text file into a database. The alternative is to use the mysqlimport utility if everything that is needed is contained in the text file. Perhaps that points you in the right direction??? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Stange Bug or Table corruption ... but strange.
Bonjour, I have a table : [11:09am] mysqldump -d cotations historique_AMS # MySQL dump 8.16 # # Host: localhostDatabase: cotations # # Server version3.23.45 # # Table structure for table 'historique_AMS' # CREATE TABLE historique_AMS ( symbole char(20) NOT NULL default '', date date NOT NULL default '-00-00', ouverture double(17,5) NOT NULL default '0.0', haut double(17,5) NOT NULL default '0.0', bas double(17,5) NOT NULL default '0.0', cloture double(17,5) NOT NULL default '0.0', volume int(10) unsigned NOT NULL default '0', UNIQUE KEY symbole (symbole,date) ) TYPE=MyISAM PACK_KEYS=1; There are about 700.000 lines in it : mysql select count(*) from historique_AMS; +--+ | count(*) | +--+ | 685536 | +--+ 1 row in set (0.02 sec) The problem is that when I ask for all lines for a given symbol, it does not return all the lines : mysql select * from historique_AMS where symbole='1rAUNIA'; +-++---+--+--+--++ | symbole | date | ouverture | haut | bas | cloture | volume | +-++---+--+--+--++ | 1rAUNIA | 2001-10-29 | 58.5 | 58.8 | 56.15000 | 56.55000 | 2710 | | 1rAUNIA | 2001-10-30 | 56.55000 | 57.25000 | 55.5 | 56.9 | 4566 | | 1rAUNIA | 2001-10-31 | 55.0 | 58.95000 | 55.0 | 58.95000 | 5166 | ... ... | 1rAUNIA | 2001-12-07 | 62.6 | 63.1 | 61.55000 | 63.1 | 7076 | | 1rAUNIA | 2001-12-10 | 62.0 | 63.15000 | 60.0 | 62.95000 | 2724 | +-++---+--+--+--++ 31 rows in set (0.12 sec) And if I do the same query but with ORDER BY date DESC : mysql select * from historique_AMS_bak where symbole='1rAUNIA' order by date desc; +--++---+--+--+--++ | symbole | date | ouverture | haut | bas | cloture | volume | +--++---+--+--+--++ | 1rAUNIA | 2001-12-10 | 62.0 | 63.15000 | 60.0 | 62.95000 | 2724 | | 1rAUNIA | 2001-12-07 | 62.6 | 63.1 | 61.55000 | 63.1 | 7076 | | 1rAUNIA | 2001-12-06 | 62.8 | 63.1 | 62.8 | 63.1 |661 | | 1rAUNIA | 2001-12-05 | 60.9 | 62.95000 | 60.65000 | 62.95000 | 1266 | | 1rAUNIA | 2001-12-04 | 60.55000 | 63.2 | 60.55000 | 63.15000 | 2054 | ... ... | 1rAUNIA | 2001-10-31 | 55.0 | 58.95000 | 55.0 | 58.95000 | 5166 | | 1rAUNIA | 2001-10-30 | 56.55000 | 57.25000 | 55.5 | 56.9 | 4566 | | 1rAUNIA | 2001-10-29 | 58.5 | 58.8 | 56.15000 | 56.55000 | 2710 | | 2001-10-26 | 55.5 | 58.05000 | 55.5 | 57.95000 | 3230 | | 2001-10-25 | 56.4 | 58.3 | 53.8 | 55.9 | 3297 | | 2001-10-24 | 57.3 | 57.65000 | 56.4 | 56.4 | 2253 | | 2001-10-23 | 59.55000 | 59.55000 | 57.7 | 57.7 | 2533 | | 2001-10-22 | 58.6 | 59.5 | 56.0 | 59.4 | 15464 | | 2001-10-19 | 57.0 | 57.5 | 56.5 | 56.8 | 1378 | | 2001-10-18 | 58.9 | 58.9 | 57.05000 | 57.05000 |843 | | 2001-10-17 | 59.2 | 59.2 | 57.1 | 58.5 | 1485 | ... ... | 2000-10-09 | 56.85000 | 57.45000 | 55.55000 | 57.05000 | 12041 | | 2000-10-06 | 55.0 | 57.4 | 55.0 | 56.85000 | 22097 | | 2000-10-05 | 53.6 | 55.15000 | 53.6 | 54.2 | 8455 | | 2000-10-04 | 54.95000 | 55.1 | 54.5 | 55.0 | 4315 | | 2000-10-03 | 55.0 | 55.0 | 53.6 | 55.0 | 9578 | | 2000-10-02 | 54.0 | 55.75000 | 53.15000 | 54.6 | 12922 | | 2000-09-29 | 53.85000 | 54.05000 | 52.1 | 53.6 | 5133 | | 2000-09-28 | 53.0 | 53.8 | 52.05000 | 52.05000 | 1445 | | 2000-09-27 | 52.95000 | 53.9 | 52.05000 | 53.85000 | 20901 | +--++---+--+--+--++ 306 rows in set (0.05 sec) As you can see, in this case it returns 306 lines while it returned only 31 from the previous query. But the most strange thing is that after the first 31 lines, the column symbol is empty ... While in the same time the data are good (these are historical data for stock exchange symbol '1rAUNIA' and the chart is ok with these data). I did a lot of things to try to correct that : mysql check table historique_AMS; +--+---+--+--+ | Table| Op| Msg_type | Msg_text | +--+---+--+--+ | cotations.historique_AMS | check | status | OK | +--+---+--+--+ 1 row in set (15.27 sec) mysql repair table historique_AMS; +--++--+--+ | Table
Re: unknown data base
josep writes: mysqlselect* from phpbook; No data base selected Hmm.. unless you typed that in rather than copied pasted, there's something really odd going on. Anyway, it looks like you're trying to select stuff from the table phpbook, but you haven't selected a database yet. Maybe you're intending to do a SHOW TABLES? Unknown database Just a hunch: Have you actually CREATEd the database? That is, have you done a CREATE DATABASE phpbook? Note that it's legal to grant permissions on databases that haven't been created yet. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: unknown data base
Hello Josep Your command seems to be wrong in accessing the db $mysql -u jupshoes -p phpbook Password: What you actually are doing is trying to access the jupshoes database;^) which infact is your password. HTH Norman -Original Message- From: josep [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Tuesday, December 11, 2001 9:23 AM Subject: unknown data base I'm new to mysql, but going on ... I've set up user jupshoes to the data base phpbook with the GRANT command: GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON phpbook.* TO jupshoes@localhost IDENTIFIED BY 'jupshoes'; GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON phpbook.* TO jupshoes@panera IDENTIFIED BY 'jupshoes'; After that I've checked there are the related entries in to the user and the database tables. And now I want to populate the database, but the user jupshoes can't even see the database: (The user jupshoes connects to the host panera via TELNET) $ mysql -ujupshoes -pjupshoes phpbook unknown database or mysqlselect* from phpbook; No data base selected or $ mysql -ujupshoes -pjupshoes phpbookphpbook.sql(to populate the table) Unknown database What is going wrong? Thanks in advance! Josep - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: unknown data base
Try doing this mysql use databasename mysql select * from tablename; You haven't selected any database from which to retrieve info. -Original Message- From: Carl Troein [mailto:[EMAIL PROTECTED]] Sent: 11 December 2001 10:26 To: [EMAIL PROTECTED] Subject: Re: unknown data base josep writes: mysqlselect* from phpbook; No data base selected Hmm.. unless you typed that in rather than copied pasted, there's something really odd going on. Anyway, it looks like you're trying to select stuff from the table phpbook, but you haven't selected a database yet. Maybe you're intending to do a SHOW TABLES? Unknown database Just a hunch: Have you actually CREATEd the database? That is, have you done a CREATE DATABASE phpbook? Note that it's legal to grant permissions on databases that haven't been created yet. //C -- Carl Troein - Cmrdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fw: PHP+MYSQL: unable to select database
- Original Message - From: Kevin Donnelly [EMAIL PROTECTED] To: josep [EMAIL PROTECTED] Sent: Tuesday, December 11, 2001 11:27 AM Subject: Re: PHP+MYSQL: unable to select database Hi Josep It is a php guestbook (called phpBook) with mysql downloaded from www.netone.at OK - I've had a look at their install file. * creating a db: mysqladmin -uroot -p create mydatabase; I've done instead (as of phpBook documentation tells): # mysqladmin -u jupshoes -pjupshoes -p create phpbook Database phpbook created. (before I've added the user jupshoes in the mysql.user table with create_priv) OK. Can I suggest that you take things one step at a time here? Instead of using your new user jupshoes, just use the root one, then you can move on from that afterwards. If you were able to create user jupshoes, then that means you must have MySQL root privileges at least within your FTP area. This is the way that MySQL is usually set up on a hoster, although you may need to use your FTP username instead of the name root. So I would delete the db phpbook (log into mysql, and then: drop database phpbook). Then use the line I gave you to recreate the db, using your FTP username if root is not appropriate. * logging onto MySQL and populating the database from the supplied script: mysql -uroot -p mydatabase /path/to/database.sql. NOW!!! (via telnet as jupshoes) # mysql -ujupshoes -p phpbookMYPATH/phpBook.sql Enter password: (I've do it) ERROR 1050 at line 11: Table 'badwords' already exists This error is because you previously tried to create the db, and it has an entry for the table. Deleting the db and recreating it will get around this (although you could also just delete the table:-)). Then try the line I gave you again, but again using root/FTPuser instead of jupshoes. Comments: * after all phpbook isn't in the mysql.db file (It doesn't appear when doing SELECT* FROM mysql.db) Not all dbs will appear in this table. I THINK only dbs that have been set up to allow access by users other than root appear here. * should the jupshoes user have any other privs in the mysql users table (now only has create priv) Yes, eventually. But I strongly suggest taking things one step at a time. Get it set up by root first, and show that it is working, and then set up the user jupshoes, and get it working with him. That way, you can track down problems easier. It may seem slower, but believe me, it's faster! The phpBook install file also says you could run install.php to do this all automatically. Since you've started with the manual route, though, perhaps you should stick to it. Just remember that in any case install.php must be deleted from the live site. * Should I reply messages to people helping me or to the mailing list? You should reply to the mailing list normally. However, no-one had answered your question, and I don't visit the list regularly, so I thought if you re-posted with difficulties I might not see them. Hence the suggestion you contact me direct. It's usual, though, even if you do things offline, to repost the topic with SOLVED in the subject line if you get things working, so that others may be helped if they have a similar problem. You're welcome to copy this to the list if you want. Best wishes 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
SUCCESS!! unknown data base
OK! Now it works. I've just didn't create the database. I thought tha it was created automatically by the GRANT command, but in fact it sets up the user and the privileges but don't create the database. So only thing left was: CREATE DATABASE phpbook; and after that populate it with tables, etc. Sorry my newbie errors! Thank's to everybody in the mailing lists arround the net! Bye. Josep. My problem was: I'm new to mysql, but going on ... I've set up user jupshoes to the data base phpbook with the GRANT command: GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON phpbook.* TO jupshoes@localhost IDENTIFIED BY 'jupshoes'; GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON phpbook.* TO jupshoes@panera IDENTIFIED BY 'jupshoes'; After that I've checked there are the related entries in to the user and the database tables. And now I want to populate the database, but the user jupshoes can't even see the database: (The user jupshoes connects to the host panera via TELNET) $ mysql -ujupshoes -pjupshoes phpbook unknown database or mysqlselect* from phpbook; No data base selected or $ mysql -ujupshoes -pjupshoes phpbookphpbook.sql(to populate the table) Unknown database What is going wrong? Thanks in advance! Josep OK! Now it works. I've just didn't create the database. I thought tha it was created automatically by the GRANT command, but in fact it sets up the user and the privileges but don't create the database. So only thing left was: CREATE DATABASE phpbook; and after that populate it with tables, etc. Sorry my newbie errors! Thank's to everybody in the mailing lists arround the net! Bye. Josep. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connection Pool
Hi, Please tell about your environment. What is MySQL(-max) version? What is PoolMan version? Thanks. GABRIELMORENO wrote: My problem was the next: I'm using Poolman to create a conecction pool in Tomcat 4 to access a MySql database, the driver that I'm using is org.gjt.mm.mysql.Driver, JDBC throws this exception: java.sql.SQLException: Transaction Isolation Levels are not supported. params: org.gjt.mm.mysql.Driver, jdbc:mysql://localhost/myDataBase. Please check your username, password and other connectivity info. java.sql.SQLException: Transaction Isolation Levels are not supported. My solution is the next: the problem is the MySql driver, I get a new version and the problem is over. The new version is 2.0.8. Gabriel -- TAKAHASHI, Tomohiro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: compile errors
Gill, Vern writes: Still need help with this one Anyone, anyone? trying to compile mysql-3.23.46, getting this error. Can't find any reference to it anywhere. Please help; kgcc -O3 -DDBUG_OFF -O9 -rdynamic -o isamchk isamchk.o sort.o libnisam.a ../mysys/libmysys.a ../dbug/libdbug.a ../strings/libmystrings.a -lpthread -lz -lcrypt -lnsl -lm -lpthread ../mysys/libmysys.a(mf_tempfile.o): In function `create_temp_file': mf_tempfile.o(.text+0xcd): undefined reference to `mkstemp64' collect2: ld returned 1 exit status make[2]: *** [isamchk] Error 1 make[2]: Leaving directory `/src/mysql-3.23.46/isam' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/src/mysql-3.23.46' make: *** [all-recursive-am] Error 2 Vern H. Gill State Director Director of Marketing Conejo Valley Jaycees http://www.conejovalleyjaycees.org What is compiler version and what OS and version. Seems like Linux, in which case you have improper installation with glibc missing the above symbol. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Stange Bug or Table corruption ... but strange.
BAUMEISTER Alexandre writes: Bonjour, I have a table : [skip] Any idea ? Regards, Alex. There were some bug fixes with packed keys. 3.23.47 will soon be out and it would be fine if you could test your case with it again. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Sudden Mysql 3.23.43 crash w/stack trace.
On Monday 10 December 2001 07:00 pm, Petro wrote: ?On Monday 10 December 2001 05:45 pm, you wrote: ? root@dbacp01d-red:/usr/local/mysql/bin# ./resolve_stack_dump -s /tmp/a ? -n /tmp/b ? 0x807b75f handle_segfault__Fi + 383 ? 0x812bcaa pthread_sighandler + 154 ? 0x815059c chunk_free + 596 ? 0x8152573 free + 155 ? 0x811579c my_no_flags_free + 16 ? 0x8077284 net_end__FP6st_net + 16 ? 0x8073acc _._3THD + 36 ? 0x807b48d end_thread__FP3THDb + 53 ? 0x80809cc handle_one_connection__FPv + 996 ? ?Petro: ? ?Are you using our binary or did you compile your own? ? ? It's yours. ?Send the output of mysqlbug... ? ? I ran mysqlbug and let it send the output to the default addr, and ? ? cc'd myself. Here's a copy: Description: Mysql crashed on this machine, stack trace already submitted via email. Please see previous email for details. How-To-Repeat: If I knew how to repeat it, I'd make sure that didn't happen. : Fix: Submitter-Id: [EMAIL PROTECTED] Originator: ? [EMAIL PROTECTED] Organization: Auctionwatch.com Inc., Operations Department. MySQL support: We've got some level of support, I don't know what level. Synopsis:??Mysql go bang and fall down. Severity:??critical Priority:??high Category:??mysql Class:?sw-bug Release:???mysql-3.23.43 (Official MySQL binary) Environment: VAlinux Full-on 2230, 2x650 Intel PIII, 2 gig ram, 1x34 gig scsi (IBM, not seagate as previously stated) on internal adaptec scsi buss, 4x75 gig IDE drives attached to a 3Ware 64xx series RAID controller. OS is debian Unstable snapshot as of about 4 months ago. System: Linux dbrctr01-red.auctionwatch.com 2.4.13-ac7 #1 SMP Sun Nov 18 23:20:03 PST 2001 i686 unknown Architecture: i686 Some paths: ?/usr/bin/perl /usr/bin/make Compilation info: CC='gcc' ?CFLAGS='-O3 -mpentium ' ?CXX='gcc' ? CXXFLAGS='-O3 -mpentium ?-felide-constructors' ?LDFLAGS='-static' LIBC: lrwxrwxrwx ? ?1 root ? ? root ? ? ? ? ? 13 Dec ?6 23:04 /lib/libc.so.6 - libc-2.2.3.so -rwxr-xr-x ? ?1 root ? ? root ? ? ?1155720 Jul 27 13:42 /lib/libc-2.2.3.so -rw-r--r-- ? ?1 root ? ? root ? ? ?2579358 Jul 25 08:15 /usr/lib/libc.a -rw-r--r-- ? ?1 root ? ? root ? ? ? ? ?178 Jul 25 08:15 /usr/lib/libc.so Configure command: ./configure ?--prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-assembler --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared At this point, I am inclined to blame this on a kernel bug that somehow zeroed out a valid page. My recommendation is to upgrade to 2.4.16 kernel. If crashes continue after that, let's investigate some more. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / 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: Fw: PHP+MYSQL: unable to select database
If you plan on using MySQL a lot I suggest you buy the book MySQL written by Paul DuBois. You might start by reading information on www.devshed.com (click on MySQL, click on PHP) and www.php.net (click links) 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[2]: Stange Bug or Table corruption ... but strange.
Bonjour Richard, RE Have you checked your table with myisamchk? Sounds like a corrupt RE index to me. I did check and repair table from mysql console. And from the documentation : CHECK TABLE only works on MyISAM tables. On MyISAM tables it's the same thing as running myisamchk -m table_name on the table. REPAIR TABLE only works on MyISAM tables and is the same as running myisamchk -r table_name on the table. ... But as I copied it in my original email : mysql check table historique_AMS; +--+---+--+--+ | Table| Op| Msg_type | Msg_text | +--+---+--+--+ | cotations.historique_AMS | check | status | OK | +--+---+--+--+ 1 row in set (15.27 sec) mysql repair table historique_AMS; +--++--+--+ | Table| Op | Msg_type | Msg_text | +--++--+--+ | cotations.historique_AMS | repair | status | OK | +--++--+--+ 1 row in set (27.02 sec) Regards, Alex. == RE BAUMEISTER Alexandre wrote: Bonjour, I have a table : [11:09am] mysqldump -d cotations historique_AMS # MySQL dump 8.16 # # Host: localhostDatabase: cotations # # Server version3.23.45 # # Table structure for table 'historique_AMS' # CREATE TABLE historique_AMS ( symbole char(20) NOT NULL default '', date date NOT NULL default '-00-00', ouverture double(17,5) NOT NULL default '0.0', haut double(17,5) NOT NULL default '0.0', bas double(17,5) NOT NULL default '0.0', cloture double(17,5) NOT NULL default '0.0', volume int(10) unsigned NOT NULL default '0', UNIQUE KEY symbole (symbole,date) ) TYPE=MyISAM PACK_KEYS=1; There are about 700.000 lines in it : mysql select count(*) from historique_AMS; +--+ | count(*) | +--+ | 685536 | +--+ 1 row in set (0.02 sec) The problem is that when I ask for all lines for a given symbol, it does not return all the lines : mysql select * from historique_AMS where symbole='1rAUNIA'; +-++---+--+--+--++ | symbole | date | ouverture | haut | bas | cloture | volume | +-++---+--+--+--++ | 1rAUNIA | 2001-10-29 | 58.5 | 58.8 | 56.15000 | 56.55000 | 2710 | | 1rAUNIA | 2001-10-30 | 56.55000 | 57.25000 | 55.5 | 56.9 | 4566 | | 1rAUNIA | 2001-10-31 | 55.0 | 58.95000 | 55.0 | 58.95000 | 5166 | ... ... | 1rAUNIA | 2001-12-07 | 62.6 | 63.1 | 61.55000 | 63.1 | 7076 | | 1rAUNIA | 2001-12-10 | 62.0 | 63.15000 | 60.0 | 62.95000 | 2724 | +-++---+--+--+--++ 31 rows in set (0.12 sec) And if I do the same query but with ORDER BY date DESC : mysql select * from historique_AMS_bak where symbole='1rAUNIA' order by date desc; +--++---+--+--+--++ | symbole | date | ouverture | haut | bas | cloture | volume | +--++---+--+--+--++ | 1rAUNIA | 2001-12-10 | 62.0 | 63.15000 | 60.0 | 62.95000 | 2724 | | 1rAUNIA | 2001-12-07 | 62.6 | 63.1 | 61.55000 | 63.1 | 7076 | | 1rAUNIA | 2001-12-06 | 62.8 | 63.1 | 62.8 | 63.1 |661 | | 1rAUNIA | 2001-12-05 | 60.9 | 62.95000 | 60.65000 | 62.95000 | 1266 | | 1rAUNIA | 2001-12-04 | 60.55000 | 63.2 | 60.55000 | 63.15000 | 2054 | ... ... | 1rAUNIA | 2001-10-31 | 55.0 | 58.95000 | 55.0 | 58.95000 | 5166 | | 1rAUNIA | 2001-10-30 | 56.55000 | 57.25000 | 55.5 | 56.9 | 4566 | | 1rAUNIA | 2001-10-29 | 58.5 | 58.8 | 56.15000 | 56.55000 | 2710 | | 2001-10-26 | 55.5 | 58.05000 | 55.5 | 57.95000 | 3230 | | 2001-10-25 | 56.4 | 58.3 | 53.8 | 55.9 | 3297 | | 2001-10-24 | 57.3 | 57.65000 | 56.4 | 56.4 | 2253 | | 2001-10-23 | 59.55000 | 59.55000 | 57.7 | 57.7 | 2533 | | 2001-10-22 | 58.6 | 59.5 | 56.0 | 59.4 | 15464 | | 2001-10-19 | 57.0 | 57.5 | 56.5 | 56.8 | 1378 | | 2001-10-18 | 58.9 | 58.9 | 57.05000 | 57.05000 |843 | | 2001-10-17 | 59.2 | 59.2 | 57.1 | 58.5 | 1485 | ... ... | 2000-10-09 | 56.85000 | 57.45000 | 55.55000 | 57.05000 | 12041 | | 2000-10-06 | 55.0 | 57.4 | 55.0 | 56.85000 | 22097 | | 2000-10-05 | 53.6 | 55.15000 | 53.6 | 54.2 |
Re: Connection Pool
Hi,
My environmment is next
WindowsNT 4.0(SP5)
Tomcat 3.2.3
MySql-max 3.23.46
Driver MySql: mm.mysql-2.0.8-bin.jar or gweMysql.jar
Poolman 2.0.4
It works fine.
I will attach my SimpleServet and poolman.xml for testing connection
to Database below.
I think PoolMan2.1.-b1 does not work fine.
poolman.xml ---
?xml version="1.0" encoding="UTF-8"?
poolman
management-modelocal/management-mode
datasource
dbnametestdb/dbname
jndiNamejndi-testdb/jndiName
driverorg.gjt.mm.mysql.Driver/driver
!-- drivergwe.sql.gweMysqlDriver/driver --
urljdbc:mysql://:3306/x/url
usernamex/username
password/password
/datasource
/poolman
PoolmanDriverTest.java -
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class PoolmanDriverTest extends HttpServlet{
static String db_url = "jdbc:poolman://testdb"; // Virtual URL
static String driver = "com.codestudio.sql.PoolMan"; // PoolMan Driver
public void init() throws ServletException {
try{
Class.forName(driver).newInstance();
}
catch(Exception e){
e.printStackTrace();
}
}
public void doGet(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException {
res.setContentType("text/html; charset=Shift_JIS");
PrintWriter pw = res.getWriter();
pw.println("htmlbody");
pw.println("h2PoolmanDriverTest/h2");
Connection conn = null;
try{
conn = DriverManager.getConnection(db_url);
System.out.println("OK!");
}
catch (Exception e){
e.printStackTrace();
}
finally{
if( conn != null )
{
try {
conn.close();
}
catch(Exception e){}
conn = null;
}
}
pw.println("/body/html");
}
}
--
--
TAKAHASHI, Tomohiro
GABRIELMORENO wrote:
Hi, Takahshi
My environmment is the next:
Windows 2000 Advanced Server
Tomcat 4.0
MySql 3.23.44
Driver MySql: mm.mysql-2.0.8-bin.jar
Poolman 2.1.-b1
Regards
Gabriel
Subject: Re: Connection Pool
Date: Tue, 11 Dec 2001 20:28:53 +0900
From: "TAKAHASHI, Tomohiro" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
References: [EMAIL PROTECTED]
Hi,
Please tell about your environment.
What is MySQL(-max) version?
What is PoolMan version?
Thanks.
GABRIELMORENO wrote:
My problem was the next:
I'm using Poolman to create a conecction pool in Tomcat 4 to access a
MySql database, the driver that I'm using is org.gjt.mm.mysql.Driver,
JDBC throws this exception:
java.sql.SQLException: Transaction Isolation Levels are not supported.
params: org.gjt.mm.mysql.Driver, jdbc:mysql://localhost/myDataBase.
Please check your username, password and other connectivity info.
java.sql.SQLException: Transaction Isolation Levels are not supported.
My solution is the next: the problem is the MySql driver, I get a new
version and the problem is over. The new version is 2.0.8.
Gabriel
--
TAKAHASHI, Tomohiro
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
synopsis of the problem (one line)
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator: Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.23.44 (Source distribution) Server: /usr/local/bin/mysqladmin Ver 8.22 Distrib 3.23.44, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.44 Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 3 min 11 sec Threads: 1 Questions: 1 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.005 Environment: System: Linux mars 2.4.7 #3 SMP Fri Jul 27 11:38:56 JST 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-slackware-linux/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Jul 27 12:26 /lib/libc.so.6 - libc-2.2.3.so -rwxr-xr-x1 root root 4783716 May 26 2001 /lib/libc-2.2.3.so -rw-r--r--1 root root 24721042 May 26 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 May 26 2001 /usr/lib/libc.so Configure command: ./configure --sysconfdir=/etc --with-charset=ujis --with-raid --with-libwrap --with-extra-charsets=all --with-mysqld-user=mysql --datadir=/home/mysql Perl: This is perl, version 5.005_03 built for i386-linux EUC version - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re[2]: Stange Bug or Table corruption ... but strange.
Bonjour Sinisa,
SM There were some bug fixes with packed keys.
SM 3.23.47 will soon be out and it would be fine if you could test your
SM case with it again.
I tried to do
alter table historique_AMS PACK_KEYS=0;
But it did not correct the problem.
Then I wanted check if the PACK_KEYS was equal to 0 when I do a
mysqldump -d of the table.
But I forgot the -d ... and here is what I found : There are some
\r at the end of some symbols ! (see below)
I don't know yet if this is a bug from my programs, but I don't
think so.
Any idea of how these \r appeared ? Could these have been added by
Mysql ?
Does it explain to you why the following query returns 31 rows
mysql select * from historique_AMS where symbole='1rAUNIA';
while the following returns 306 rows ?
mysql select * from historique_AMS_bak where symbole='1rAUNIA' order by date desc;
Regards,
Alex.
INSERT INTO historique_AMS VALUES
('1aA13456\r','2000-09-28',104.4,104.4,104.4,104.4,0);
INSERT INTO historique_AMS VALUES
('1aA850737','2000-09-28',8.0,8.0,8.0,8.0,0);
INSERT INTO historique_AMS VALUES
('1aA716338','2000-09-28',101.8,101.8,101.8,101.8,0);
INSERT INTO historique_AMS VALUES
('1aAAABTE','2001-11-06',138.5,141.0,137.2,140.0,7280);
INSERT INTO historique_AMS VALUES
('1aAFINTO','2000-09-28',36.0,36.0,36.0,36.0,0);
INSERT INTO historique_AMS VALUES
('1aAFTUSF','2000-09-28',23.45000,23.45000,23.45000,23.45000,0);
INSERT INTO historique_AMS VALUES
('1aA12283','2000-09-28',104.0,104.0,104.0,104.0,25);
INSERT INTO historique_AMS VALUES
('1aA12299','2000-09-28',99.75000,99.75000,98.75000,98.75000,19000);
INSERT INTO historique_AMS VALUES
('1aA148140\r','2000-09-28',101.5,101.5,101.5,101.5,0);
INSERT INTO historique_AMS VALUES
('1rAOPG','2001-11-08',37.7,37.9,37.15000,37.45000,10317);
INSERT INTO historique_AMS VALUES
('1rAFOBRA\r','2000-09-28',27.5,27.5,27.5,27.5,0);
INSERT INTO historique_AMS VALUES
('1rAFOBR\r','2000-09-28',24.0,24.0,24.0,24.0,0);
INSERT INTO historique_AMS VALUES
('1aAFEF\r','2000-09-28',36.95000,36.95000,36.05000,36.95000,5006);
INSERT INTO historique_AMS VALUES
('1aAFEFSC\r','2000-09-28',68.25000,68.25000,68.25000,68.25000,0);
INSERT INTO historique_AMS VALUES
('1aAFORJA\r','2000-09-28',34.95000,35.0,34.65000,35.0,2064);
INSERT INTO historique_AMS VALUES
('1aAFRODF\r','2000-09-28',49.3,49.3,49.3,49.3,8528);
INSERT INTO historique_AMS VALUES
('1aAFRNX\r','2000-09-28',25.82000,25.82000,25.82000,25.82000,38920);
INSERT INTO historique_AMS VALUES
('1aAFRNI\r','2000-09-28',24.25000,24.3,24.25000,24.25000,61900);
INSERT INTO historique_AMS VALUES
('1aAFRNV\r','2000-09-28',25.12000,25.12000,25.12000,25.12000,41454);
INSERT INTO historique_AMS VALUES
('1rAFOCCA\r','2000-09-28',914.0,914.0,914.0,914.0,0);
INSERT INTO historique_AMS VALUES
('1aAFBAMF\r','2000-09-28',33.25000,33.75000,33.25000,33.75000,1438);
INSERT INTO historique_AMS VALUES
('1rAFOCCB\r','2000-09-28',25.15000,25.15000,25.15000,25.15000,14250);
INSERT INTO historique_AMS VALUES
('1rAFORDA','2000-09-28',27.0,27.0,27.0,27.0,0);
INSERT INTO historique_AMS VALUES
('1aAFRNAF\r','2000-09-28',66.2,66.2,66.2,66.2,78);
INSERT INTO historique_AMS VALUES
('1aAFBNAS','2000-09-28',51.9,51.9,51.0,51.0,9447);
INSERT INTO historique_AMS VALUES
('1aAFRNUI\r','2000-09-28',52.98000,52.98000,52.98000,52.98000,760);
INSERT INTO historique_AMS VALUES
('1aAFOWMF\r','2000-09-28',53.5,53.5,53.0,53.0,18889);
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re[3]: Stange Bug or Table corruption ... but strange.
Bonjour, BA But I forgot the -d ... and here is what I found : There are some BA \r at the end of some symbols ! I corrected everything with one query : mysql UPDATE historique_AMS set symbole=TRIM(TRAILING '\r' FROM symbole); These '\r' may come from a program a colleague did. Sorry for the disturb. Regards, Alex. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Repost: Show slave status permissions
What permissions do you need to have to issue a show slave status command? Thanks, database,sql,query,table -- Michael Eklund System Administrator Netmechanic, Inc. [EMAIL PROTECTED] http://www.netmechanic.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: Problem
Define unusable. Did you copy them as root so 'mysql' no longer owns them? Did you copy them while the server was running? Michael Migal wrote: Hi, I have a little problem, and hope that someone can help me with it. I am trying to copy MySQL data files for a certain database from one Linux box to the other. Copying works just fine, but then some of the tables become unusable. Any suggestions? mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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-based commerce packages
Have you had a look at The Exchange Project? www.theexchangeproject.org Kevin On Wednesday 05 December 2001 22:07, rory o'connor wrote: I'm looking for a new commerce package, something run of a MySQL database. it's gotta have bulletproof (well, as close as you can get) session management. I wonder what others on the list are using and like? input is appreciated! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: connecting to mysql from different computer
At 03:23 PM 12/10/01 -0700, you wrote: From: Dan [EMAIL PROTECTED] I can connect... on the same computer ...different machine it won't work. I have a similar problem but let explain better may be i don't get what Dan was talking about. From my local computer i can use LOAD command to store values into tables on the same machine. Now I want to be able to do the samething on mysql server at the remote site if i can successful connected to Mysql server on the remote machine. Can this sovle my sleeplessness problem? if not is there any assist you can render to me. Any support will be highly appreciated. Thanks in anticipation for your reply. Best regards. Kamal I suspect that you need to add an entry at the MySQL host for the machine that you are connecting from. This can be done with a GRANT statement: - Format: grant all privileges on databaseName.tableName to 'userName'@'hostName' identified by 'somePassword'; - Example: grant all privileges on myDB.* to 'clyde'@'coolPlace.org' identified by 'secretPass'; Then you'll need to reload the access privileges. It can be done at the command line like this: % mysqladmin -u rootUserName reload Remember, you may need to add the -p switch and suply a password for this command. Is this enough info? --- Rodney Broom Programmer: Desert.Net Spam filter: sql database - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL General Questions
I have read the documentation thoroughly, however there are still some things unclear to me, and others that I want opinions on. I am dismayed at what I see as a fundamental lack of server administration documentation. Much of the docs focus on the SQL aspects of MySQL. There is only a minor portion dealing with server administration. Most of which deals with installation, starting/stopping MySQL, and minor database administration. I would like to see more from a true System Administrators point of view. I am still unclear as to how MySQL utilizes memory. I believe that for each client thread, there is a portion of memory only for that client, and then there is some memory that is shared between all clients. Is this correct? How can I tell how much memory is being used by a single client? What is the difference, if any, in MySQL parlance between a thread, and a connection? I want to be able to look at my server and see if the physical system is giving good performance, or if I need to provide more resources. I don't really know how to do this for MySQL though. I have written some applications to use data from various MySQL databases on my server. However, I am trying to find the best way to write these applications. If a client has a (thread/connection) to the MySQL server, can that thread support multiple simultaneous queries? Obviously this question is loaded, but lets say I am using Sendmail tied to MySQL. Would it be better to write a sendmail that for each daemon running, has a persistent connection to the MySQL database, and uses that connection to query for each piece of mail it delivers. Or would it be better for my Sendmail to open a new connection for each piece of mail? I have seen the max_connections variable, and have adjusted this at least once. However, what does MySQL consider a connection? Backups, backups, backups? What is the best way to do a backup? What about table maintennance? If I use myisamchk or another command line tool, do those lock the tables? If so, what kind of lock? If I run a CHECK table from using the interactive mysql, do I need to lock the tables first? I know these are a lot of questions, if you have an answer to all or any part, email me directly please. Also, if you would like to include additional information please do so. I am not really a DBA, and am looking for more information from an SA point of view. Thanks, Shon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: connecting to mysql from different computer
From: [EMAIL PROTECTED] I have a similar problem... Just to be sure, it's helpful if you could send us the message that your getting when you see the connection problem, but this sounds like the same thing. Can this sovle my sleeplessness problem? Probably. Anytime I can't sleep, I just look for some sound advice. If that doesn't work, then I like to try some warm milk and a couple of my wife's chocolate chip cookies. --- Rodney Broom Programmer: Desert.Net Spam Filter: sql database - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: compile errors
# uname -a Linux linuxbox 2.4.16 #2 Wed Nov 28 12:24:51 PST 2001 i586 unknown # rpm -qa | grep -i libc glibc-2.2.4-20 glibc-devel-2.2.4-20 compat-glibc-6.2-2.1.3.2 glibc-common-2.2.4-20 # /usr/bin/gcc -v Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.1/specs Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --host=i386-redhat-linux --with-system-zlib Thread model: posix gcc version 3.1 20011127 (Red Hat Linux Rawhide 3.1-0.10) -Original Message- From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 3:57 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: compile errors Gill, Vern writes: Still need help with this one Anyone, anyone? trying to compile mysql-3.23.46, getting this error. Can't find any reference to it anywhere. Please help; gcc -O3 -DDBUG_OFF -O9 -rdynamic -o isamchk isamchk.o sort.o libnisam.a ../mysys/libmysys.a ../dbug/libdbug.a ../strings/libmystrings.a -lpthread -lz -lcrypt -lnsl -lm -lpthread ../mysys/libmysys.a(mf_tempfile.o): In function `create_temp_file': mf_tempfile.o(.text+0xcd): undefined reference to `mkstemp64' collect2: ld returned 1 exit status make[2]: *** [isamchk] Error 1 make[2]: Leaving directory `/src/mysql-3.23.46/isam' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/src/mysql-3.23.46' make: *** [all-recursive-am] Error 2 Vern H. Gill State Director Director of Marketing Conejo Valley Jaycees http://www.conejovalleyjaycees.org What is compiler version and what OS and version. Seems like Linux, in which case you have improper installation with glibc missing the above symbol. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: compile errors
Gill, Vern writes: # uname -a Linux linuxbox 2.4.16 #2 Wed Nov 28 12:24:51 PST 2001 i586 unknown # rpm -qa | grep -i libc glibc-2.2.4-20 glibc-devel-2.2.4-20 compat-glibc-6.2-2.1.3.2 glibc-common-2.2.4-20 # /usr/bin/gcc -v Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.1/specs Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --host=i386-redhat-linux --with-system-zlib Thread model: posix gcc version 3.1 20011127 (Red Hat Linux Rawhide 3.1-0.10) The above glibc and especially compiler are prectically experimental, so you are very much on your own. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql rounding problem
[ob. filter faker: mysql] For what it's worth, here's an algorithm I use to write my own rounding function. To round to the nearest N number of places. 1) divide the number by N 2) add .5 (for negative numbers subtract .5) 3) truncate the result (take integer part) 4) multiply result by N Example: To round 758.43 to nearest 10's 1) 758.43 / 10 = 75.843 2) 75.843 + .5 = 76.343 3) int(76.343) = 76 4) 76 * 10 = 760 Example: To round 758.437 to nearest 1/100th 1) 758.437 / 1/100 = 75843.7 2) 75843.7 + .5 = 75844.2 3) int(75844.2) = 75844 4) 75844 * 1/100 = 758.44 Example: To round -758.437 to nearest 1/100th 1) -758.437 / 1/100 = -75843.7 2) -75843.7 - .5 = -75844.2 3) int(-75844.2) = -75844 4) -75844 * 1/100 = -758.44 -- Amer Neely [EMAIL PROTECTED] Softouch Information Services: www.softouch.on.ca/ Perl / PHP / CGI programming for shopping carts, data entry forms. We make web sites work! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
find_in_set syntax
Hi Can anyone tell me what is wrong with the MySQL FIND_IN_SET function? Well, I'm using the following: ELECT * FROM gd_records WHERE res_skills 3 AND res_skills_ma 3; And it returns the most weird results. It completely ignores the AND statement, and returns results even if the second statement is true or not? Why is this? Is this a major bug or is there a problem with my query? Thanks Wiliam Stephens Web Developer http://www.fbagroup.co.uk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: find_in_set syntax
At 17:23 11/12/01, you wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: SLECT * FROM gd_records WHERE res_skills 3 AND res_skills_ma 3; That should of been SELECT. Typo, sorry. Still problem persisting, though. How do others overcome this? Wil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Upgrading from MySQL to MySQL max on a production server
At 08:27 AM 12/11/2001 +0200, you wrote: Hi! I do not understand how replacing just the executable mysqld can make your 'mysql start' (or is it 'mysql.server start'?) script or safe_mysqld script to search the executable from a different directory than it did before. I do not understand it either, but I have done exactly that on both a SuSE 7.1 server and a RedHat server, and in both cases it then started looking in /usr/local/mysql for things. Neither the SuSE box nor the RedHat box had a /usr/local/mysql directory before. Are you sure you did not change anything else in the system? I strongly assure you that I did not change the path, nor the my.cnf nor the init script nor any other thing on the whole system. Additionally, as soon as I run mv mysqld mysqld_inno ; mv mysqld_redhat mysqld I can call the init script restart and it immediately works fine again. What ever the problem is, it's hard-coded inside the mysql-max binary. I will say that I did not use the rpm, I used the tarball and copied mysqld out of the tarball's bin/ directory. Anyway, it is best that you make a new installation of MySQL-Max. The version 3.23.38 is very old and many bugs have been fixed to .46. From the manual I found a useful page: http://www.mysql.com/doc/A/u/Automatic_start.html There has been no change in MySQL table formats since .38, hence your database should run ok with .46 -Max too. For MyISAM type tables MySQL and MySQL -Max are equivalent. But if you have somehow a nonstandard installation, The SuSE installation is 100% standard SuSE, the RedHat installation is MySQL from an RPM from mysql.com, nothing edited or customized. Thanks. or have edited the startup scripts, better be prepared for some problems in starting up mysqld. Regards, Heikki http://www.innodb.com -- Order commercial MySQL/InnoDB support at https://order.mysql.com/ Hello, We're needing to use MySQL-Max because we need the functionality provided by InnoDB. According to InnoDB's web site, all I have to do is download the tarball and replace the /usr/sbin/mysqld with the mysqld in the tarball. I tried that on SuSE and I had to install a few other things and make a few symlinks too, but it did eventually work quite fine. However I was just trying that method on a redhat 7.0 production box and it doesn't work because when I call /etc/init.d/mysql start it says it can't find /usr/local/mysql/libexec/mysqld which is interesting, because I can't find any libexec directories associated with mysql on any of my linux boxes, no matter what distro. Anyway (unless someone has an answer to the libexec problem), I think I'm going to need to upgrade my whole MySQL version to a full MySQL-Max installation. Currently we're running MySQL-3.23.38-1 from an RPM from mysql.com. Our problem is that we are already using quite a few databases in our current mysql and we need to know _before_ we upgrade exactly what's going to happen to the databases we already have. Will MySQL-Max just start working with them without a hitch, or do we need to go through some sort of initialization routine? (note: we're not trying to convert our current DBs to InnoDB that is a whole separate issue. We just want to know what we'll need to to be able to continue accessing the data once we install MySQL-Max. Is it perfectly compatible with MySQL(non-max)? Just backup, install and /etc/init.d/mysql start? Or is there more to it then that? Thanks a lot. Jonathan Wilson System Administrator Cedar Creek Software http://www.cedarcreeksoftware.com Central Texas IT http://www.centraltexasit.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 Jonathan Wilson System Administrator Cedar Creek Software http://www.cedarcreeksoftware.com Central Texas IT http://www.centraltexasit.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: find_in_set syntax
Can you provide your table description? You have two set colums? One called res_skills and one called res_skills_ma ? Etienne Wiliam Stephens wrote: Hi Can anyone tell me what is wrong with the MySQL FIND_IN_SET function? Well, I'm using the following: ELECT * FROM gd_records WHERE res_skills 3 AND res_skills_ma 3; And it returns the most weird results. It completely ignores the AND statement, and returns results even if the second statement is true or not? Why is this? Is this a major bug or is there a problem with my query? Thanks Wiliam Stephens Web Developer http://www.fbagroup.co.uk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL 3.23.32 way faster than 3.23.46
Hi. I've been testing some querys with this two versions of mysql and found weird results. First we try with 3.23.32: (foo)-/usr/local/mysql_3.23.32/bin# ./mysql -uroot publish Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 3.23.32-log mysql SELECT DISTINCT Article.ID as ArticleID FROM eZArticle_Article AS Article, eZArticle_ArticleCategoryLink as Link, eZArticle_ArticlePermission AS Permission, eZArticle_Category AS Category WHERE ( ( ( ( ( Permission.GroupID='-1' ) AND Permission.ReadPermission='1') ) AND ( Permission.GroupID='-1') AND Permission.ReadPermission='1' ) ) AND Article.IsPublished = 'true' AND Permission.ObjectID=Article.ID AND Link.ArticleID=Article.ID AND Category.ID=Link.CategoryID AND Category.ExcludeFromSearch = 'false' ORDER BY Article.Published DESC, Article.Puntos DESC LIMIT 220,10; +---+ | ArticleID | +---+ | 5665 | [...] | 7311 | +---+ 10 rows in set (54.19 sec) And then with 3.23.46: (foo)-/usr/local/mysql_3.23.46/bin# mysql -uroot publish Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.23.46-log mysql SELECT DISTINCT Article.ID as ArticleID FROM eZArticle_Article AS Article, eZArticle_ArticleCategoryLink as Link, eZArticle_ArticlePermission AS Permission, eZArticle_Category AS Category WHERE ( ( ( ( ( Permission.GroupID='-1' ) AND Permission.ReadPermission='1') ) AND ( Permission.GroupID='-1') AND Permission.ReadPermission='1' ) ) AND Article.IsPublished = 'true' AND Permission.ObjectID=Article.ID AND Link.ArticleID=Article.ID AND Category.ID=Link.CategoryID AND Category.ExcludeFromSearch = 'false' ORDER BY Article.Published DESC, Article.Puntos DESC LIMIT 220,10; +---+ | ArticleID | +---+ | 5665 | [...] | 7311 | +---+ 10 rows in set (1 min 26.06 sec) Almost 30 seconds more with the same query!! We've found out that the main problem are the Permission checks in the WHERE clause, because taking them out makes the query execution down to 0.30 secs, but why the older version takes much less time? (I've tried this with 3.23.42 with the same results). Any way one of the tables has around 1 elements and the other ones around 5000, isn't 1 minute too much time? Any hints to optmize the query? FYI it's running on a dedicated Dual 800Mhz, Linux server w/ 1Gb RAM. Thanks in advance. Cheers. -- Luis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Failure to enforce length of fields to index corrupts tables -- fully resolved in BK
In article [EMAIL PROTECTED], Sinisa Milivojevic [EMAIL PROTECTED] writes MattJ wrote: It's still possible in the mysql client to request the creation of an index with indexlength NULL on TEXT fields. This apparently works okay on creation of the index, insert and select operations, but breaks horribly (marks table as crashed with corrupted indexes) on update or delete operations. Hi! I have tested your case. The above bug was already fixed in our BK repository. Fix will come up in 4.0.1, that is scheduled to come out soon. Just as a followup to this, this past weekend I installed the BK head version of mysql-4.0.1-alpha (last changeset 1.980) on the server with the table-marked-as-crashed problems, and since then, having performed operations which would have caused a crashed table on the previous server, the tables have remained clean and functioning -- looks like the bug is fixed. :-) It's now been up for just over 75 hours, and it's a fairly busy server: Uptime: 272983 Threads: 6 Questions: 53688790 Slow queries: 505 Opens: 180 Flush tables: 1 Open tables: 174 Queries per second avg: 196.674 ...so the 4.0.1 in BK is looking good! Thanks for your help! :-) Regards, -- Matt Johnson [EMAIL PROTECTED] AVSIM Online! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Failure to enforce length of fields to index corrupts tables -- fully resolved in BK
Dear Dose anyone know, if i install MySql in NFS, are there any problem? and is that a good idea? why? lei shen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Default 1 == Default 16777216 ?
On Mon, Dec 10, 2001 at 02:55:04PM -0700, Nathan wrote: : Dave Burgess had a good suggestion; I suppose you could specify the default in :hex... : (default = 0x1) - as long as this is NOT in quotes it will input the hex value 1. I compiled a 3.23.46 last night and I have the same problem. I tried using 0x1, and the default is still set to 16777216 (and values get input with that value as well). Can anyone else verify that this is the case? I'm seeing it both with MyISAM tables and InnoDB tables, so I doubt it's a table handler. * Philip Molter * Texas.net Internet * http://www.texas.net/ * [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
binding a domain name to a MySQL instance
Is there any way to bind something other than the hostname to a MySQL instance? I'm going to be moving a database from one server to another, and would like the scripts that reference that data to simply talk to db.mydomain.com, rather than have to reconfigure things during launch. Is this possible? ari -- Ari Davidow Applications Administrator, Web Central Tufts University 617-627-4291 [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: binding a domain name to a MySQL instance
The solution we took was to write a global configuration file and share connection data as need. This way it only needs to be changed in one place. Furthermore, if you connect as follows: dbi:mysql:host=db_01;database=database_name and then on your client machine, either via bind or the /etc/hosts file, point the db_01 host name to the IP of your database server. I've been doing this for some time, works very well. Hope this helps, -Bart -Original Message- From: ari davidow [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 3:23 PM To: [EMAIL PROTECTED] Subject: binding a domain name to a MySQL instance Is there any way to bind something other than the hostname to a MySQL instance? I'm going to be moving a database from one server to another, and would like the scripts that reference that data to simply talk to db.mydomain.com, rather than have to reconfigure things during launch. Is this possible? ari -- Ari Davidow Applications Administrator, Web Central Tufts University 617-627-4291 [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: is type casting available
Hi. On Mon, Dec 10, 2001 at 06:30:47PM +0530, [EMAIL PROTECTED] wrote: [...] here shortname is varchar and pcallid is integer. i need shortname and pcallid as ' callno' of length 6. pcallid starts from 1 .. 999. to get effect like for callnumber 'xxx001' i plan to add pcallid by 1000 and pick last 3 characters and concat with shortname. If you always want pcallid to have always leading zeros, you can declared it like PCallID SMALLINT(3) ZEROFILL concat(ShortName , substring(Cast( (.PCallID + 1000) as varchar(10) ),2 3) ) as 'Call No' here i would like to cast (.PCallID + 1000) as varchar As I said, in such situations MySQL will perform an implicit cast, so simply write: SELECT CONCAT(ShortName, SUBSTRING(PCallID + 1000, 2, 3)) AS 'Call No' Btw, alternatives to that would be SELECT CONCAT(ShortName, RIGHT(PCallID + 1000, 3) AS 'Call No' SELECT CONCAT(ShortName, LPAD(PCallID, 3, '0') AS 'Call No' or, if the column is declared with ZEROFILL, as explained above SELECT CONCAT(ShortName, PCallID) AS 'Call No' Bye, Benjamin. [...] how can i cast a variable either from integer to varchar or varchar to integer in mysql. That's not possible in the way you ask for. Values will get automatically converted to the column type in question. In expressions, MySQL doesn't use varchar, but simply string, integer and floating point. You can force a string to an integer by adding 0 (like 'SELECT 1234+0') and an number to a string by some string functions (like 'SELECT CONCAT(10)'). I assume, there are no explicit casts, because if you want to add some number, you get the conversion implicitly by using '+'. If you could provide an example why you need explicit casts, maybe we could give a more precise answer. -- [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: HELP... lot of Load !
Hi. On Mon, Dec 10, 2001 at 02:06:41PM +0100, [EMAIL PROTECTED] wrote: --- [...] # Time: 011210 13:40:23 # User@Host: eff21[eff21] @ localhost [] # Query_time: 25 Lock_time: 0 Rows_sent: 20 Rows_examined: 596309 SELECT SQL_BIG_RESULT Locations.Location_ID, Locations.Neu, Locations.Sichtbar, Locations.Location_Name, Locations.PLZ, Locations.Ort, Locations.Strasse, COUNT(Termine.Location_ID) AS Count_Termine FROM Locations LEFT JOIN Termine ON Locations.Location_ID = Termine.Location_ID WHERE Locations.Kino != '1' AND (Locations.Location_Name LIKE '%%' OR Locations.Ort LIKE '%%' OR Locations.PLZ LIKE '%' OR Locations.Kategorien_Locations1_Name LIKE '%%' OR Locations.Kategorien_Locations2_Name LIKE '%%' ) GROUP BY Locations.Location_ID ORDER BY Locations.Location_Name LIMIT 0,20 --- Did this say anything to you advertently my high load ? [...] Not directly. But it is a *possible* reason. To see if these queries are the reason, run such a query by hand and watch the load (note that OS caching may influence the result for subsequent runs) and the result of 'mysqladmin processlist'. If the query is to blame, there should be a lot of LOCKED processes. The query needed 25 seconds and had to scan a major part of the table (596309 rows). MySQL is not good in optimizing OR expression. Note, that the OR expressions above are redundant, as they will always match. If you can get rid of them (I assume the query is build automatically), the query will run faster. Btw, one of the queries returned thousand of rows. Does that make really sense (looks like a search engine to me). If not, don't allow such queries, or use LIMIT shorten the search to a reasonable size. Unfortunately you did not quote the result of EXPLAIN as I asked for, so I cannot say more. But simply start with what I have told and see how far you get. Bye, Benjamin. -- [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
Feature Requests
Hi, I would like to request the addition of the following features to the command line client: Shell escape mysql !rm /tmp/data.txt mysql select col into outfile '/tmp/data.txt' from table; The command is run on the client. It would all SQL scripts to be run more simply that constructing a shell script with the same function. Maybe there would need to be an extra user permission to avoid abuse (like FILE)? Because the command is run on the client, this leads to the second feature request: mysql select col into local outfile '/tmp/data.txt' from table Before submitting to the server, the client checks, with the server, that the user has FILE privileges, and that the user has OS level permission to create the file. The results of the query are then put in to the file in the same format as they would have been in the existing select .. into outfile command - if that is too difficult, because the client then needs all the separator and terminator options, then simply tab separated using the platform's standard end of line would be fine for me! Would these options prove useful to others? Regards Quentin Bennett Transport Systems Division Infinity Solutions web http:\\www.infinity.co.nz mailto:[EMAIL PROTECTED] Phone : +64 9 358 9720 Fax : +64 9 309 4142 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Default 1 == Default 16777216 ?
Hi, The output of mysqlbug might be useful, so we can see what platform etc you are on. Quentin -Original Message- From: Philip Molter [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 12 December 2001 9:08 a.m. To: Nathan Cc: [EMAIL PROTECTED] Subject: Re: Default 1 == Default 16777216 ? On Mon, Dec 10, 2001 at 02:55:04PM -0700, Nathan wrote: : Dave Burgess had a good suggestion; I suppose you could specify the default in hex... : (default = 0x1) - as long as this is NOT in quotes it will input the hex value 1. I compiled a 3.23.46 last night and I have the same problem. I tried using 0x1, and the default is still set to 16777216 (and values get input with that value as well). Can anyone else verify that this is the case? I'm seeing it both with MyISAM tables and InnoDB tables, so I doubt it's a table handler. * Philip Molter * Texas.net Internet * http://www.texas.net/ * [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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Feature Requests
Quentin Bennett wrote: Shell escape mysql !rm /tmp/data.txt mysql select col into outfile '/tmp/data.txt' from table; mysql select col into local outfile '/tmp/data.txt' from table Would these options prove useful to others? Yes. Especially the local outfile. Regards Quentin Bennett Transport Systems Division Infinity Solutions web http:\\www.infinity.co.nz mailto:[EMAIL PROTECTED] Phone : +64 9 358 9720 Fax : +64 9 309 4142 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Select and Update logjam
Hi, I seem to be experiencing similair problems to what Sam Lam reported earlier this month (Subject: tables locked during long compound INSERT/DELETE?). What I've observed is that when I'm issuing an UPDATE on a table that also has SELECT queries being executed on it, everything seems to clog up. The UPDATE seems to me to take longer than usual and the SELECTs linger around and pile up and sit in the ``Copying to tmp table'' state until the UPDATE completes. Sometimes this clog lasts for so long that it's better just to kill a bunch of the threads. A quick excerpt from a ``show processlist'' when this happened: ... *** Command: Query Time: 0 State: updating Info: UPDATE ... SET ... WHERE ... AND ... AND ... *** Command: Query Time: 922 State: Copying to tmp table Info: SELECT DISTINCT(...), ... FROM ... JOIN ... WHERE ... *** Command: Query Time: 915 State: Copying to tmp table Info: SELECT DISTINCT(...), ... FROM ... JOIN ... WHERE ... *** ... There's ~115 more of those SELECTs hanging around, too. This is under Linux 2.2.19 and MySQL 3.23.41 (yes, we'll update soon, but the ChangeLog doesn't seem to say anything relevant to this problem). Is this a likely a MySQL bug or a configuration error or ...? Thanks. P.S. It appears that the SELECTs don't have to be against the same table that's being UPDATEd, but I haven't pinned that down so it's mere speculation. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Default 1 == Default 16777216?
Description: When I do this: mysqlcreate table test_default ( testint int not null default 1 ); mysqldesc test_default; I get: +-+-+--+-+--+---+ | Field | Type| Null | Key | Default | Extra | +-+-+--+-+--+---+ | testint | int(11) | | | 16777216 | | +-+-+--+-+--+---+ 1 row in set (0.00 sec) Why does my default not go in as '1'. I've tried it with and without quotes. This is vexing. Is there something obvious that I'm just not doing correctly? How-To-Repeat: See above Fix: Don't know. I'm looking for verification that the problem exists. Submitter-Id: submitter ID Originator: Philip Molter Organization: Texas.Net MySQL support: none Synopsis: Default 1 == Default 16777216 Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.46 (Source distribution) Environment: System: SunOS 5.8 Generic_108528-12 sun4u sparc SUNW,Ultra-80 Architecture: sun4 Some paths: /usr/bin/perl /usr/ccs/bin/make /usr/local/bin/gcc /usr/ucb/cc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' This build was compiled with the specs used on MySQL's web site for Solaris (SunOS, actually) builds. LIBC: -rw-r--r-- 1 root bin 1763908 Nov 16 16:42 /lib/libc.a lrwxrwxrwx 1 root root 11 Nov 20 13:29 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1136748 Nov 16 16:42 /lib/libc.so.1 -rw-r--r-- 1 root bin 1763908 Nov 16 16:42 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Nov 20 13:29 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1136748 Nov 16 16:42 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/mysql-3.23.46 --with-low-memory --enable-assembler --enable-assembler --with-innodb - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: median function?
Hello, The original question from Michael is: Is there a SQL function available for finding the median value from a column of numbers? I see AVG() but no reference to medians. Thanks. Does the sql AVG() skip ruled out values by some non-parametric test? Every SQL description of AVG() at my disposal does not discuss non-paramteric tests or ruled out values. Can we assume that if sql had a MEDIAN() it would not be any more conditioned than the AVG() function? Is the column of numbers a series of samples? If so is the median of these samples what you want? What is your goal? What is the situation of your data? Are you comparing medians from different number series where the populations have different shapes? Then neither means nor variances nor medians may provide the proper comparative measures; and then nonparametric methods come into play. But if the shapes of the populations are similar why complicate matters and make your data analysis operation system dependent? On the other hand, from rereading our discussion I believe Sinisa (and he may confirm this) is correct in cautioning against implementing a median based on its definition(which is correct) as I suggested and not regard what you want to do with the median in context of the condition of your data. It can happen where statistical analysis is intended to work for a particular condition but eventually a user may stuff in data where the analysis will give them answers which they will use for years not knowing the underlying analysis is not using comparative measures intended for their data's condition. Eventually everybody may forget how the analysis works but use it blindly. Regards, Roger - Original Message - From: Sinisa Milivojevic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, December 01, 2001 9:36 AM Subject: Re: median function? Michael writes: Umm does this mean there is no way to do what I need? Is it inappropiate to ask if it'd be difficult for such a function to be added into MySQL if it is the case that this is an impossible thing to do (or even just very challenging)? A median is a very common function to need in accounting I think. Thanks. *^*^*^* Michael McGlothlin [EMAIL PROTECTED] http://mlug.missouri.edu/~mogmios/projects/ No, it is very easy to do. Add it as an UDF. This will not work on server running on Windows, though. Take a look at udf_example.cc in sql/ subdir of the source. Most notably, analyse : CREATE AGGREGATE FUNCTION avgcost RETURNS REAL SONAME udf_example.so; -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Default 1 == Default 16777216?
Obvious stupid question: What happens when you specify the value as 16777216? Since you are running on a SPARC, I'm sure you will end up with the correct value (1) in the space. If that works, there is definitely an endism problem. Dave Philip Molter wrote: Description: When I do this: mysqlcreate table test_default ( testint int not null default 1 ); mysqldesc test_default; I get: +-+-+--+-+--+---+ | Field | Type| Null | Key | Default | Extra | +-+-+--+-+--+---+ | testint | int(11) | | | 16777216 | | +-+-+--+-+--+---+ 1 row in set (0.00 sec) Why does my default not go in as '1'. I've tried it with and without quotes. This is vexing. Is there something obvious that I'm just not doing correctly? How-To-Repeat: See above Fix: Don't know. I'm looking for verification that the problem exists. Submitter-Id: submitter ID Originator: Philip Molter Organization: Texas.Net MySQL support: none Synopsis: Default 1 == Default 16777216 Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.46 (Source distribution) Environment: System: SunOS 5.8 Generic_108528-12 sun4u sparc SUNW,Ultra-80 Architecture: sun4 Some paths: /usr/bin/perl /usr/ccs/bin/make /usr/local/bin/gcc /usr/ucb/cc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' This build was compiled with the specs used on MySQL's web site for Solaris (SunOS, actually) builds. LIBC: -rw-r--r-- 1 root bin 1763908 Nov 16 16:42 /lib/libc.a lrwxrwxrwx 1 root root 11 Nov 20 13:29 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1136748 Nov 16 16:42 /lib/libc.so.1 -rw-r--r-- 1 root bin 1763908 Nov 16 16:42 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Nov 20 13:29 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1136748 Nov 16 16:42 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/mysql-3.23.46 --with-low-memory --enable-assembler --enable-assembler --with-innodb - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Default 1 == Default 16777216?
On Tue, Dec 11, 2001 at 04:24:40PM -0600, Dave Burgess wrote: : Obvious stupid question: : : What happens when you specify the value as 16777216? Since you : are running on a SPARC, I'm sure you will end up with : the correct value (1) in the space. If that works, there is : definitely an endism problem. You are correct, sir. It's an endian issue. Hopefully, that can get fixed in either the next release or in my build process somewhere. MySQL, database, and other spam-detection words. * Philip Molter * Texas.net Internet * http://www.texas.net/ * [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
Peculiar update irregularity
This is a peculiar thing that I've seen before on this machine. The update doesn't work always (from mysql, I hope this isn't happening from the perl scripts as well). mysql select iHasPhoto,iNumPhotos from tblListing where iListingID = 10014061; +---++ | iHasPhoto | iNumPhotos | +---++ | 1 | 0 | +---++ 1 row in set (0.27 sec) mysql update tblListing set iNumPhotos = 1 where iListingID = 10014061; Query OK, 0 rows affected (0.01 sec) mysql select iHasPhoto,iNumPhotos from tblListing where iListingID = 10014061; +---++ | iHasPhoto | iNumPhotos | +---++ | 1 | 0 | +---++ 1 row in set (0.00 sec) mysql update tblListing set iNumPhotos = 1 where iListingID = 10014061; Query OK, 1 row affected (0.00 sec) mysql select iHasPhoto,iNumPhotos from tblListing where iListingID = 10014061; +---++ | iHasPhoto | iNumPhotos | +---++ | 1 | 1 | +---++ 1 row in set (0.14 sec) The system: 4.2-20010320-STABLE FreeBSD The mysql version: 3.23.35 using myIsam tables The table in question (don't mind the lack of indices, this is the test DB): mysql describe tblListing; +---+--+--+-++-- --+ | Field | Type | Null | Key | Default| Extra | +---+--+--+-++-- --+ | iListingID| int(11) | | PRI | NULL | auto_increment | | szPassword| varchar(20) | | || | | szOwnerName | varchar(50) | | || | | szPhone1 | varchar(20) | | || | | szPhone2 | varchar(20) | | || | | szEmailAddress| varchar(90) | | || | | szAddress | varchar(100) | | || | | szAptNumber | varchar(10) | | || | | szCity| varchar(50) | | || | | szStateCode | char(2) | | || | | szPostalCode | varchar(15) | | || | | iPropTypeCode | tinyint(4) | | | 0 | | | iSqFootage| int(11) | | | 0 | | | iNumFloors| tinyint(4) | | | 0 | | | iNumBedrooms | tinyint(4) | | | 0 | | | fNumBathrooms | float(10,2) | | | 0.00 | | | szLotSize | varchar(10) | | || | | iGarageSize | tinyint(4) | | | 0 | | | bDescription | blob | | || | | iAskingPrice | int(11) | | | 0 | | | iFlexTypeCode | tinyint(4) | | | 0 | | | iLoanTypeCode | tinyint(4) | | | 0 | | | iHasPhoto | tinyint(4) | | | 0 | | | dPosted | date | | | -00-00 | | | iActive | tinyint(4) | | | 0 | | | szTransactionCode | varchar(10) | | || | | szRebillCode | varchar(10) | | || | | iHits | int(11) | | | 0 | | | iNumPhotos| tinyint(4) | | | 0 | | | szVirtualTour | varchar(255) | YES | | NULL | | | iShowEmail| tinyint(1) | | | 1 | | | dDeleted | date | | | -00-00 | | | szCounty | varchar(50) | | || | | dEndRun | date | YES | | NULL | | | iAccountNum | int(11) | YES | | NULL | | | szURL | char(3) | YES | | NULL | | +---+--+--+-++-- --+ 36 rows in set (0.00 sec) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
question
Does MySQL support Db2 Version 5.0 Kumud Advani Sears Canada Inc Architect Council - Corporate Data WareHouse Tel : (416) 510 - 6217 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
myodbc
Greetings, We modified our db, host, and user tables (in mysql db) in order to have bigger db names, users... Just 16 characters is really not enough for us. Now the problem: Some of our users use myODBC to connect to their databases. And that driver does not accept db names with more than 16 characters. Does, anyone have any work around for that? Any ideas will be greatly apreciated. Best Regards, Gustavo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ADV: Dear Future Millionaire:
I'll make you a promise. READ THIS E-MAIL TO THE END! - follow what it says to the letter and you will not worry whether a RECESSION is coming or not, who is President, or whether you keep your current job or not. Yes, I know what you are thinking. I never responded to one of these before either. One day though, something just said you throw away $25.00 going to a movie for 2 hours with your wife. What the heck. Believe me, no matter where you believethose feelings come from, I thank goodness every day that I had that feeling.I cannot imagine where I would be or what I would be doing had I not. Read on. It's true. Every word of it. It is legal. I checked. Simply because you are buying and selling something of value. AS SEEN ON NATIONAL TV: Making over half million dollars every 4 to 5 months from your home.THANK'S TO THE COMPUTER AGE AND THE INTERNET ! == BE AN INTERNET MILLIONAIRE LIKE OTHERS WITHIN A YEAR!!! Before you say ''Bull'', please read the following. This is the letter you have been hearing about on the news lately. Due to the popularity of this letter on the Internet, a national weekly news program recently devoted an entire show to the investigation of this program described below, to see if it really can make people money. The show also investigated whether or not the program was legal. Their findings proved once and for all that there are ''absolutely NO Laws prohibiting the participation in the program and if people canfollow the simple instruction they are bound to make some mega bucks with only $25 out of pocket cost''. DUE TO THE RECENT INCREASE OF POPULARITY RESPECT THIS PROGRAM HAS ATTAINED, IT IS CURRENTLY WORKING BETTER THAN EVER. This is what one had to say: '' Thanks to this profitable opportunity. I was approached many times before but each time I passed on it. I am so glad I finally joined just to see what one could expect in return for the minimal effort and money required. To my astonishment, I received a total $ 610,470.00 in 21 weeks, with money still coming in''. Pam Hedland,Fort Lee, New Jersey. == Another said: this program has been around for a long time but I never believed in it. But one day when I received this again in the mail I decided to gamble my $25 on it. I followed the simple instructions and walaa . 3 weeks later the money started to come in. First month I only made $240.00 but the next 2 months after that I made a total of $290,000.00. So far, in the past 8 months by re-entering the program, I have made over $710,000.00 and I am playing it again. The key to success in this program is to follow the simple steps and NOT change anything.'' More testimonials later but first, PRINT THIS NOW FOR YOUR FUTURE REFERENCE If you would like to make at least $500,000 every 4 to 5 months easily and comfortably, please read the following...THEN READ IT AGAIN and AGAIN !!! FOLLOW THE SIMPLE INSTRUCTION BELOW AND YOUR FINANCIAL DREAMS WILL COME TRUE, GUARANTEED! INSTRUCTIONS: =Order all 5 reports shown on the list below = For each report, send $5 CASH, THE NAME NUMBER OF THE REPORT YOU ARE ORDERING and YOUR E-MAIL ADDRESS to the person whose name appears ON THAT LIST next to the report. MAKE SURE YOUR RETURN ADDRESS IS ON YOUR ENVELOPE TOP LEFT CORNER in case of any mail problems. ===WHEN YOU PLACE YOUR ORDER, MAKE SURE ==YOU ORDER EACH OF THE 5 REPORTS! === You will need all 5 reports so that you can save them on your computer and resell them. YOUR TOTAL COST $5 X 5 = $25.00. Within a few days you will receive, via e-mail, each of the 5 reports Save them on your computer so they will be accessible for you to send to the 1,000's of people who will order them from you. Also make a floppy of these reports and keep it on your desk in case something happens to your computer. IMPORTANT - DO NOT alter the names of the people who are listed next to each report, or their sequence on the list, in any way other than what is instructed below in step '' 1 through 6 '' or you will loose out on the majority of your profits. Once you understand the way this works, you will also see how it does not work if you change it. Remember, this method has been tested, and if you alter it, it will NOT work !!! People have tried to put their friends/relatives names on all five thinking they could get all the money. But it does not work this way. Believe us, some have tried to be greedy and then nothing happened. So Do Not try to change anything other than what is instructed. Because if you do, it will not work for you. Remember, honesty reaps the reward!!! This IS a legitimate BUSINESS. You are offering a product for sale and getting paid for it. Treat it as such and you will
Mysql Support Rated !
I had to post this short note of Thank You to Monty Widenius.. I had struggled for over 6 months and several versions of MySQL trying to get the source to compile without errors on Caldera 2.3 or 2.4. I continued to fail. I upgraded Libc libraries and gcc makes but still failed. Yeah, I got a compile and the Mysql engines ran but the make test errors haunted me.. After a number of postings on the list, Monty finally took pity on me. A number of emails and suggested fixes, still no cure. Monty then offered to telnet to the offending machine. A couple phome calls later, Sweden to New York the telnet was set up. Monty worked on my hard drive and compiled a few version with various make switches. In the end a source fix in the ha_myisammrg.cc and all compiled and passes all tests. I am more than happy! Monty, THank You! The support at MySQL AB is great! The support is worth the price of admission. Bob T - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MS Access and mysql databases
Is it possible to export a database from mysql so MS Access can read it as its own? I am not able to install MyODBC on the windows box (not admin) -- Sincerely, Rosyna Keller Technical Support/Holy Knight/Always needs a hug Unsanity: Unsane Tools for Insane People - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 in using in keyword
Hi, I use the MySQLManager and enter a SQL statement with a in keyword, but an error message of syntax error occurs, I verify the SQL by plugging it to MS SQL Server 2000, it works without error, so I would like to know if the in keyword only functions on the Linux platform but not on the Windows platform? The MySQL version I am now using is 4.0-Max alpha and the MyODBC version is 2.5. Moreover, currently I come across another problem of using MySQL on Windows platform. The MySQL database contains several tables which have Chinese (BIG5) characters as data value, and I have constructed some programs in PowerBuilder to capture these Chinese data. The programs seem function normally and the data is really captured into the tables. However, when I try to use the mysqlcheck or myisamchk on these tables, a message saying that the XXX.MYD needs to be recreate is appeared. I think the indexes of these tables are corrupted. So, do you have any experiences that can share with me in capturing Chinese data? Thank you very much for your help. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Problem in using in keyword
Hi, It would help if you can post the statement and the error message that you get. Regards Quentin -Original Message- From: TH Leung [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 12 December 2001 4:26 p.m. To: '[EMAIL PROTECTED]' Subject: Problem in using in keyword Hi, I use the MySQLManager and enter a SQL statement with a in keyword, but an error message of syntax error occurs, I verify the SQL by plugging it to MS SQL Server 2000, it works without error, so I would like to know if the in keyword only functions on the Linux platform but not on the Windows platform? The MySQL version I am now using is 4.0-Max alpha and the MyODBC version is 2.5. Moreover, currently I come across another problem of using MySQL on Windows platform. The MySQL database contains several tables which have Chinese (BIG5) characters as data value, and I have constructed some programs in PowerBuilder to capture these Chinese data. The programs seem function normally and the data is really captured into the tables. However, when I try to use the mysqlcheck or myisamchk on these tables, a message saying that the XXX.MYD needs to be recreate is appeared. I think the indexes of these tables are corrupted. So, do you have any experiences that can share with me in capturing Chinese data? Thank you very much for your help. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 in using in keyword
On Wed, Dec 12, 2001 at 11:26:05AM +0800, TH Leung wrote: Hi, I use the MySQLManager and enter a SQL statement with a in keyword, but an error message of syntax error occurs, I verify the SQL by plugging it to MS SQL Server 2000, it works without error, so I would like to know if the in keyword only functions on the Linux platform but not on the Windows platform? The MySQL version I am now using is 4.0-Max alpha and the MyODBC version is 2.5. Verifying a SQL statement by sending it a different database engine than MySQL will only tell you that it works with that engine. It won't tell you anything about possible differences between the Linux and Windows versions of MySQL. Probably you're using IN in query that uses a sub-select. If that's true, the answer to your question can be found in the MySQL manual: http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Nested Inner Joins
I am having problems with this nested inner join statement: SELECT tblMethodType.MethodType, tblMethodParm.MethodName, tblParm.ParmName, tblParm.Label, tblParm.Value, tblParm.Unit, tblParm.Tip FROM tblMethodType INNER JOIN (tblMethod INNER JOIN (tblParm INNER JOIN tblMethodParm ON tblParm.idParm = tblMethodParm.idParm) ON tblMethod.MethodName = tblMethodParm.MethodName) ON tblMethodType.MethodType = tblMethod.MethodType; I have not had much experience with INNER JOINS, and I read one website that said the MySql can't support grouped inner joins... If this is true, how do I get this type of command to execute under MySql (I inherited this code but the statement apparently worked with Microsoft Access) You may respond directly to me, if possible. Thank you. Kendra Knudtzon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqldump is not generating references
hi all, mysqldump is not generating references. how can i get it. regards, sreedhar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Each user have only see databases they have access too
Im running MySQL on my Win98 Desktop and Ive created a new user and only granted access to one database, but when I use myPhpAdmin the user can still see all the databases. What can I do so that each user only see the databases they have access too. Always an Email Away Kevin Campbell Chief Executive Officer The Club Mix, Inc. http://www.theclubmix.com
MySQL problem
I am running MySQL (version 3.23.46a)on a Windows 2000 server. The server has suddenly stopped serving out requests. It appears that localhost is refusing connections, even though the passwords appear to be correct. I am pretty new to MySQL so any suggestions of where to look are appreciated. Thanks! - Ken - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Feature Requests
I'll add my voice especially on the local file. many times I have wanted to be able to skip creating the file on the server, then having to scp it to my local box. On Tuesday 11 December 2001 02:09 pm, you wrote: Hi, I would like to request the addition of the following features to the command line client: Shell escape mysql !rm /tmp/data.txt mysql select col into outfile '/tmp/data.txt' from table; The command is run on the client. It would all SQL scripts to be run more simply that constructing a shell script with the same function. Maybe there would need to be an extra user permission to avoid abuse (like FILE)? Because the command is run on the client, this leads to the second feature request: mysql select col into local outfile '/tmp/data.txt' from table Before submitting to the server, the client checks, with the server, that the user has FILE privileges, and that the user has OS level permission to create the file. The results of the query are then put in to the file in the same format as they would have been in the existing select .. into outfile command - if that is too difficult, because the client then needs all the separator and terminator options, then simply tab separated using the platform's standard end of line would be fine for me! Would these options prove useful to others? Regards Quentin Bennett Transport Systems Division Infinity Solutions web http:\\www.infinity.co.nz mailto:[EMAIL PROTECTED] Phone : +64 9 358 9720 Fax : +64 9 309 4142 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Jayce^ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AW: HELP... lot of Load !
Hello Benjamin. Thanks a lot. Yes, you are right. It is a search engine. But I can?t get rid of the OR expressions, cause it is implemented in the search formular mask. So the User can choose any search criteria, which he wants. Neverthe- less I will follow your hint and check out these queries manually to view the load gage. Greetz Daniel -Ursprungliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Im Auftrag von Benjamin Pflugmann Gesendet: Dienstag, 11. Dezember 2001 22:04 An: Daniel Backhausen Cc: mySQL Mailingliste Betreff: Re: HELP... lot of Load ! Hi. On Mon, Dec 10, 2001 at 02:06:41PM +0100, [EMAIL PROTECTED] wrote: --- [...] # Time: 011210 13:40:23 # User@Host: eff21[eff21] @ localhost [] # Query_time: 25 Lock_time: 0 Rows_sent: 20 Rows_examined: 596309 SELECT SQL_BIG_RESULT Locations.Location_ID, Locations.Neu, Locations.Sichtbar, Locations.Location_Name, Locations.PLZ, Locations.Ort, Locations.Strasse, COUNT(Termine.Location_ID) AS Count_Termine FROM Locations LEFT JOIN Termine ON Locations.Location_ID = Termine.Location_ID WHERE Locations.Kino != '1' AND (Locations.Location_Name LIKE '%%' OR Locations.Ort LIKE '%%' OR Locations.PLZ LIKE '%' OR Locations.Kategorien_Locations1_Name LIKE '%%' OR Locations.Kategorien_Locations2_Name LIKE '%%' ) GROUP BY Locations.Location_ID ORDER BY Locations.Location_Name LIMIT 0,20 --- Did this say anything to you advertently my high load ? [...] Not directly. But it is a *possible* reason. To see if these queries are the reason, run such a query by hand and watch the load (note that OS caching may influence the result for subsequent runs) and the result of 'mysqladmin processlist'. If the query is to blame, there should be a lot of LOCKED processes. The query needed 25 seconds and had to scan a major part of the table (596309 rows). MySQL is not good in optimizing OR expression. Note, that the OR expressions above are redundant, as they will always match. If you can get rid of them (I assume the query is build automatically), the query will run faster. Btw, one of the queries returned thousand of rows. Does that make really sense (looks like a search engine to me). If not, don't allow such queries, or use LIMIT shorten the search to a reasonable size. Unfortunately you did not quote the result of EXPLAIN as I asked for, so I cannot say more. But simply start with what I have told and see how far you get. Bye, Benjamin. -- [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
