Re: MySQL 3.23.44 not using indexes
Steven Roussey wrote: Are the tables defined the same on both servers? Yes, the tables are defined exactly the same. Is the data the same? Just about. The data on the working server is a copy of the database on the broken server. For previous tests I used a several-weeks-old copy of the data, but for today's tests I re-copied the data over, so it represents almost the same exact data set. Is the query the same? Are both analyzed? Yes, I analyzed the tables on both databases before running the explain queries, and the explain queries are exactly the same. The only difference I can come up with is that the database on the working server was dumped from the broken server via mysqldump and then imported into the working server, while the database on the broken server was created via table creation statements years ago and has since been updated from the ISAM to the MyISAM table type and the database server from version 3.22.30 to 3.23.44. Is it possible that indexes were somehow corrupted in the process and need to be rebuilt from scratch? Does it make sense to dump the data on the broken server and re-import it into a different database on that server? -myk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Triggers
Hello All, Is Mysql supports sql triggers ...??.. Is anyone know this pls tell me.. Thanks in advance Uma - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Triggers
I think this is some thing that should be in on V4.1... Have a look at things to do on the site Simon -Original Message- From: Uma Shankari T. [mailto:[EMAIL PROTECTED]] Sent: 24 April 2002 08:28 To: [EMAIL PROTECTED] Subject: Triggers Hello All, Is Mysql supports sql triggers ...??.. Is anyone know this pls tell me.. Thanks in advance Uma - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Triggers
Uma I asked MySQL the same question earlier this week and got the following answer : Cameron, Actually Stored procedures and triggers will be in version 5.0, which is planned for release by end of year. Current development is underway. A stable version of 5.0 will likely be in Q1 of 2003, but stable means no known bugs, so our beta is closer to a GA version of typical commercial software. There is some documentation that suggests that it will be available in version 4.1, but I guess this response from MySQL supersedes this. Regards Cameron -Original Message- From: Uma Shankari T. [mailto:[EMAIL PROTECTED]] Sent: 24 April 2002 09:28 To: [EMAIL PROTECTED] Subject: Triggers Hello All, Is Mysql supports sql triggers ...??.. Is anyone know this pls tell me.. Thanks in advance Uma - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Slow Shutdown with NET STOP MYSQL
At 14:41 23/04/02 -0500, Dave Butler wrote: Hi! I have version 3.23.41-max-debug running on Windows 2000 SP2. I have MySQL installed as a service and can use NET START MYSQL and NET STOP MYSQL to start and stop the server. One unusual item is that it takes about 30 seconds Yes in this server release exists a wait timeout which makes the service shutdown takes this time. However this server has a bug with shutdown which was fixed starting from 3.23.48, you should notice that now the time for to make the shutdown depends of the clean up that the server needs to do. for the NET STOP to finish executing. The NET START is very fast as is MYSQLADMIN SHUTDOWN. Is this behavior typical? Anything to be concerned about? Please see above. Thanks, Dave PS - I don't know why the debug is part of the version (obtained from SELECT VERSION()). I installed as a service using mysqld-max --install. This is stranger, I will take a look in this issue. Regards, Miguel -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Bug MySQL?
Hi I'm trying to extract data from 2 tables (A and B) with a subquery A has the fields (ID_person, name) B has the fields (ID_person,ID_country) This is my query select * from A where A.id_person IN (select B.id from B where B.ID_country =7) But I receive a message error. If I try to run each single query separately they work. The subquery returns (for example) 1 and if I write select * from A where A.id_person IN (1) it works. The strange thing is that if I try to run the subquery with Access or SQL with SAS it works! It is a bug? I wait for your answer. Thanks Matteo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Bug MySQL?
Hi I'm trying to extract data from 2 tables (A and B) with a subquery A has the fields (ID_person, name) B has the fields (ID_person,ID_country) This is my query select * from A where A.id_person IN (select B.id from B where B.ID_country =7) Subqueries are not supported in mysql yet. Try this: select A.* from A,B where A.id_person=B.id_person and ID_country=7 -- _/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] - _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl _/_/_/_/ _/_/_/ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625 _/ _/ _/ ==* http://szukaj.wp.pl *==-- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem with libmysqlclient_r.so
Hi! Andrey Kotrekhov writes: my program crash in another plase (gdb) bt #0 _db_enter_ (_func_=0x280fe4dc mysql_ping, _file_=0x280fdd48 libmysql.c, _line_=2248, _sfunc_=0xbfa87d3c, _sfile_=0xbfa87d40, _slevel_=0xbfa87d44, _sframep_=0xbfa87d48) at dbug.c:712 #1 0x280eceae in mysql_ping (mysql=0x80c9c1c) at libmysql.c:2248 #2 0x80832d2 in QueueModule::Run (this=0x80c9c00) at /usr/local/mysql++/include/connection1.hh:80 #3 0x8068b2f in start_Module (ptr=0x80c9c00) at Module.cc:23 #4 0x282063af in _thread_start () from /usr/lib/libc_r.so.4 #5 0x0 in ?? () (gdb) p state $1 = (CODE_STATE *) 0x0 (gdb) why code_state() return NULL? Is this right? Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport ÔÅÌ. +380 562 34-00-44 Does not seem like our bug ! Because last time it crashed in a completely different place. Plus, it I change version MySQL, maybe this is the reason? is unlikely that it would crash in ping. Check out your compiler version and whether libstdc++ got linked into the binary. % g++ -v Using builtin specs. gcc version 2.95.3 20010315 (release) [FreeBSD] And libstdc++ is include in compiller How can I see version of libstdc++ ? In /usr/src/contrib/libstdc++/Makefile.in I see VERSION = 2.10.0 INTERFACE = 3 Is there right? Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport ÔÅÌ. +380 562 34-00-44 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 thread resource control?
Hello list, Is it possible to limit the mysql thread resource? Say, when there is a heavy-load query, it will not use 99% of the cpu time and afect other system processes. Idea? -- Patrick Hsieh [EMAIL PROTECTED] GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
USING INDEX
Hello mysql, Why sum() influences use of indexes for the table ac (tblAccountActivity) mysql EXPLAIN - SELECT - c.CustomerID, c.CompanyName, - c.ContactFirstName, c.ContactLastName, c.BillAddress1, - c.MobilPhone, c.WorkPhone, c.HomePhone, - sum(ac.Credit), sum(ac.Debit) - FROM tblCustomer c - INNER JOIN tblUser u ON u.CustomerID=c.CustomerID - INNER JOIN tblAccountActivity ac ON u.UserID=ac.UserID - WHERE c.Dealer=4 - GROUP BY c.CustomerID; +---+++-+-+--++-+ | table | type | possible_keys | key | key_len | ref | rows | |Extra | +---+++-+-+--++-+ | ac| ALL| UserID | NULL|NULL | NULL | 141800 | |Using temporary | | u | eq_ref | PRIMARY,CustomerID | PRIMARY | 4 | ac.UserID| 1 | | | | c | eq_ref | PRIMARY,K1,IDX2| PRIMARY | 4 | u.CustomerID | 1 | |where used | +---+++-+-+--++-+ mysql EXPLAIN - SELECT - c.CustomerID, c.CompanyName, - c.ContactFirstName, c.ContactLastName, c.BillAddress1, - c.MobilPhone, c.WorkPhone, c.HomePhone - FROM tblCustomer c, tblUser u, tblAccountActivity ac USE INDEX (UserID) - WHERE c.Dealer=4 AND u.CustomerID=c.CustomerID AND u.UserID=ac.UserID - GROUP BY c.CustomerID; +---+--+++-+--+--+-+ | table | type | possible_keys | key| key_len | ref | rows | |Extra | +---+--+++-+--+--+-+ | c | ref | PRIMARY,K1,IDX2| IDX2 | 2 | const| 407 | |where used; Using temporary | | u | ref | PRIMARY,CustomerID | CustomerID | 4 | c.CustomerID | 18 | || | ac| ref | UserID | UserID | 4 | u.UserID | 47 | |Using index | +---+--+++-+--+--+-+ Best regards, Andrew Sitnikov e-mail : [EMAIL PROTECTED] GSM: (+372) 56491109 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: New Setup
Hi, After installing mySQL, you ran mysql_install_db.sh script ? Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Ian Phillips [EMAIL PROTECTED] To: 'Mysql' [EMAIL PROTECTED] Sent: Wednesday, April 24, 2002 5:04 AM Subject: New Setup Using the commands you have offered... Egor Your 'root' user doesn't have GRANT privilege ... Egor Egor You should change Grant_priv to 'Y' Egor You can do this using UPDATE statement: Egor UPDATE user SET Grant_priv='Y' WHERE user='root'; I get this response.. ERROR 1017: Can't find file: 'user.frm' (errno: 2) --- Endeavouring to run mysqld as per... Egor or you run mysqld with --skip-grant-tables option and set Grant_priv Egor using GRANT statement: Egor GRANT ALL ON *.* to 'root'@'localhost' identified by Egor 'password_obscured' WITH GRANT OPTION; myslqd tells me it's it is ready for input. But I'm not sure what to input? Ian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql users setup.
Hello all! I am just starting out with learning mysql and I have run into some speed bumps that are mostly my configuration. I have set up mysql running on a Mac OS X box with php running a particular software package called phpESP. Works great (a bit slow, but great). Now, in order to have my system go live the head honchos decided that my department could not have the mysql database and the webserver on thes same machine (security reasons). Now I have read some of the docs regarding doing this, whatever user accesses the database has to have the IP that it will be coming from set up after the @ symbol. Well, can I change an existing user to have access from any location, and how would I see if that is already set up for this user? Sorry for the newbie questions, but docs, urls, or pretty much anything will get me started thanks so much! Terry. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: innodb problem (with JDBC/transactions)
Hi, We are currently facing the same problem (Deadlock found when trying to get lock; Try restarting transaction) in our production environnement. We are using InnoDB tables (mysqk 3.23.48-max) with Jboss 2.4.4 and JDBC driver mm.mysql-2.0.11-bin.jar / RedHat 7.1. Could you please tell me how to fix this ? Thanks, jb - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 users setup.
Look in db mysql.user to see what users can do what. GRANT ALL ON *.* TO user@% IDENTIFIED BY password; Simon -Original Message- From: Unix Newbie [mailto:[EMAIL PROTECTED]] Sent: 24 April 2002 10:15 To: [EMAIL PROTECTED] Subject: Mysql users setup. Hello all! I am just starting out with learning mysql and I have run into some speed bumps that are mostly my configuration. I have set up mysql running on a Mac OS X box with php running a particular software package called phpESP. Works great (a bit slow, but great). Now, in order to have my system go live the head honchos decided that my department could not have the mysql database and the webserver on thes same machine (security reasons). Now I have read some of the docs regarding doing this, whatever user accesses the database has to have the IP that it will be coming from set up after the @ symbol. Well, can I change an existing user to have access from any location, and how would I see if that is already set up for this user? Sorry for the newbie questions, but docs, urls, or pretty much anything will get me started thanks so much! Terry. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Max Numero de tablas.....
Hola y de antemano gracias. Bueno me es de suma importancia conocer el maximo numero de tablas que puede soportar mysql si lo tiene... Gracias William. _ MSN Photos es la manera más sencilla de compartir e imprimir sus fotos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 users setup.
Thanks for the quick reply Simon! I checked in the file, and just as you said the info was there. No, I actually solved the problem myself shortly after setting up phpMyAdmin from sourceforge.net Top notch little software package there(free too)! For newbies like me, it works out great, hopefully in a few weeks I'll be much more well versed. Again, really appreciate know the 'real way' to do it! Have a great one! Terry On Wed, 2002-04-24 at 03:18, Simon Green wrote: Look in db mysql.user to see what users can do what. GRANT ALL ON *.* TO user@% IDENTIFIED BY password; Simon -Original Message- From: Unix Newbie [mailto:[EMAIL PROTECTED]] Sent: 24 April 2002 10:15 To: [EMAIL PROTECTED] Subject: Mysql users setup. Hello all! I am just starting out with learning mysql and I have run into some speed bumps that are mostly my configuration. I have set up mysql running on a Mac OS X box with php running a particular software package called phpESP. Works great (a bit slow, but great). Now, in order to have my system go live the head honchos decided that my department could not have the mysql database and the webserver on thes same machine (security reasons). Now I have read some of the docs regarding doing this, whatever user accesses the database has to have the IP that it will be coming from set up after the @ symbol. Well, can I change an existing user to have access from any location, and how would I see if that is already set up for this user? Sorry for the newbie questions, but docs, urls, or pretty much anything will get me started thanks so much! Terry. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: table lock - which connection id own's it
Hi! Lopez == Lopez David E-r9374c [EMAIL PROTECTED] writes: cut Lopez If no row is returned, then the following happens: Lopez 1) lock table ... Lopez 2) select ... Lopez 3) if no row is returned, Lopez 4)insert ... Lopez 5)use LAST_INSERT_ID() to get the value of the key Lopez 6) else get the key-value pair Lopez 7) unlock table Lopez 8) put key-value pair in RAM hash Lopez 9) insert row in main table (using new key-value pair) Why not instead do as follows: (This assumes you have an unique index on the thing you are selecting on) select ... if no row is returned, insert ... if insert works without a duplicate key error: use LAST_INSERT_ID() to get the value of the key else select to find the row some other thread inserted put key-value pair in RAM hash insert row in main table (using new key-value pair) cut Lopez Hope that clears the insertion process on the hash tables. I'm Lopez glad that if a connection is lost in steps 2-6, mysql would Lopez automatically unlock the tables. That will satisfy the db Lopez specification nicely. The architecture for our db came Lopez from the optimization chapter in the manual. Thanks! If the connection dies on the client side, the server will notice it as once. The thing you will not notice if a client goes into an endless loop and will not release the connection to the MySQL server. I will add to our TODO to add to SHOW OPEN TABLES a list of threads that has locks on the table (or maybe a SHOW LOCKS command) to better cover this case in the future. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 3.23.50 client needs IP addresses
rob, Tuesday, April 23, 2002, 11:46:00 PM, you wrote: rDescription: r mysql client from 3.23.50 won't connect to older servers running on remote hosts unless you specify the host as an IP address: r ERROR 2005: Unknown MySQL Server Host 'xxx' (2) Submitter-Id: submitter ID Originator:Rob Steele Organization: FatKat, Inc. MySQL support: none Synopsis: 3.23.50 client needs IP addresses Severity: serious Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.50 (Official MySQL RPM) I tested your example on v3.23.50 and I got the same result ... We will check it ... -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: New Setup
Ian, Wednesday, April 24, 2002, 5:04:15 AM, you wrote: IP Using the commands you have offered... Egor Your 'root' user doesn't have GRANT privilege ... Egor Egor You should change Grant_priv to 'Y' Egor You can do this using UPDATE statement: Egor UPDATE user SET Grant_priv='Y' WHERE user='root'; IP I get this response.. IP ERROR 1017: Can't find file: 'user.frm' (errno: 2) The user, that MySQL is running as, doesn't have permissions on the MySQL data dir ... IP --- IP Endeavouring to run mysqld as per... Egor or you run mysqld with --skip-grant-tables option and set Grant_priv Egor using GRANT statement: Egor GRANT ALL ON *.* to 'root'@'localhost' identified by Egor 'password_obscured' WITH GRANT OPTION; IP myslqd tells me it's it is ready for input. IP But I'm not sure what to input? 1. Connect to the MySQL server. 2. Execute FLUSH PRIVILEGES. 3. GRANT ALL ON *.* to 'root'@'localhost' identified by 'password_obscured' WITH GRANT OPTION; 4. Disconnect from the MySQL server. 5. Shut down MySQL server and start it again in the normal mode (without the --skip-grant-tables option). IP Ian -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Deadlock errors with BDB tables
Hi, I'm trying to run two separate programs which connect to a single MySQL database and attempt to perform transactions on its BDB tables. I'm running MySQL 3.23.49a Max on Windows (NT4). The two programs in question are both Windows Services written in Perl (5.6.1), and they are using the Perl DBI (DBD::mysql, Version 2.1013) to perform the transactions. Both programs have the AutoCommit flag switched off so that nothing is committed until the whole transaction is complete. If anything goes wrong part-way through then the changes thus-far are rolled back and the program reports the error to the user. One program is running in a fairly tight loop in which it performs a transaction (which may involve INSERTs, UPDATEs and/or DELETEs) about once a second. The other program has smaller bursts of activity in which it may perform half a dozen similar transactions in rapid succession and then be inactive for a few minutes or more. Each program runs fine on its own, but when I try and run them both together I intermittently get the following error: [1213]: Deadlock found when trying to get lock; Try restarting transaction Firstly, I'm not certain what happens when I get this error. Whichever of the two programs gets the error does appear to carry on afterwards, so I'm assuming that MySQL/BerkeleyDB has detected the deadlock and rolled back one of the (partially-completed) transactions so that the other program can continue normally, hence the message that I need to restart the transaction in the program that got the error. Is this correct? Secondly, since I assume there is no way to completely stop this happening (?) what should I do when it does occur? The obvious thing to do seems to be to wrap the transaction in a loop like the following: do { transaction } while deadlock-error but this could potentially get stuck in the loop forevermore. If I add a threshold to limit the number of retries to some maximum limit then the transaction could still not get performed. It is also very tedious to have to wrap all my transactions in such a loop. I've tried setting berkeley_trans_retry to 10 in the file sql\ha_berkeley.cpp as described in previous postings on this subject, but I still get the same problem, proving that simply retrying is not really a solution. I've also tried all four settings of the --transaction-isolation command line option, but to no avail. (I don't know if that should have helped or not.) To make things worse I also intermittently get other strange errors like: [19]: fetch() without execute() [1062]: Duplicate entry '116' for key 1. There is nothing so fundamentally wrong with the programs that they do this every time, just once in a while when they're getting hammered hard. What on earth is going on? Help! Steve Hay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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.23.50 client needs IP addresses
[EMAIL PROTECTED] writes: Description: mysql client from 3.23.50 won't connect to older servers running on remote hosts unless you specify the host as an IP address: ERROR 2005: Unknown MySQL Server Host 'xxx' (2) Submitter-Id:submitter ID Originator: Rob Steele Organization: FatKat, Inc. MySQL support: none Synopsis:3.23.50 client needs IP addresses Severity:serious Priority:high Category:mysql Class: sw-bug Release: mysql-3.23.50 (Official MySQL RPM) Hi! The above problem is not caused by any changes in 3.23.50 source. It is caused by having glibc built statically with binaries. This solves many other problems, but may create DNS related problems. Solution to the above is to have all your hosts that access a server in hosts server and tune up name resolution on your Linux . -- 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: Max Numero de tablas.....
On Wed, 24 Apr 2002, Robinson Silva wrote: Bueno me es de suma importancia conocer el maximo numero de tablas que puede soportar mysql si lo tiene... William, assuming you use the MyIsam table type this depends of your operating system. A table consists of 3 files. When the number of your files grows very large (I mean 1) consider using ReiserFS. The number of concurrently used file handles may be an issue as well. Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: compile problem with 3.23.50
[EMAIL PROTECTED] writes: Description: I get the following error: c++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr\ - DDATADIR=\/var/lib/mysql\ -DSHAREDIR=\/usr/share/mysql\ -DHAVE_CONFIG_H -I../bdb/build_unix -I../innobase/includ e -I./../include -I./../regex - I. -I../include -I.. -I.-O3 -DDBUG_OFF -fno-implicit-templates -fno-except ions -fno-rtti -c mysqld.cc mysqld.cc: In function `void * handle_connections_sockets(void *)': /usr/include/tcpd.h:161: too few arguments to function `void sock_host(request_i nfo *)' mysqld.cc:2428: at this point in file /usr/include/tcpd.h:119: too few arguments to function `int hosts_access(request _info *)' mysqld.cc:2429: at this point in file /usr/include/tcpd.h:153: too few arguments to function `char * eval_client(reque st_info *)' mysqld.cc:2437: at this point in file make[4]: *** [mysqld.o] Error 1 make[4]: Leaving directory `/home/ch/debian/mysql-3.23.50/sql' make[3]: *** [all-recursive] Error 1 make[3]: Leaving directory `/home/ch/debian/mysql-3.23.50/sql' Hi! Problem that you are experiencing is caused by changes that were needed to solve problem building MySQL with libwrap on Linux. All Linux versions that we tested, had prototypes as in 3.23.50. Can you explain why is your Linux so different ?? -- 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: problem with libmysqlclient_r.so
Andrey Kotrekhov writes: Hi! % g++ -v Using builtin specs. gcc version 2.95.3 20010315 (release) [FreeBSD] And libstdc++ is include in compiller How can I see version of libstdc++ ? In /usr/src/contrib/libstdc++/Makefile.in I see VERSION = 2.10.0 INTERFACE = 3 Is there right? Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport ÔÅÌ. +380 562 34-00-44 - Compiler is OK. But your program is multithreaded, so check with `ldd` whether you have linked in libstdc++ ... -- 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
temporary tables...
Hello, Is there a way of checking if a temporary table exists? I've been using show tables like '%tablename%' to see if an ordinary table exists.. but show table wont display temporary tables so this wont work.. any suggestions? // Leif Högberg And so the spam filter will let this through: SQL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Erwin Vs Mysql ....
Try MyODBC from the downloads page at www.mysql.com. Erwin works fine for reverse engineering databases, on forward engineering I do have to make some patchs by hand to script before I can generate a model. Maybe I need to learn to use Erwin better. Also if you have a support contract please call and ask them to add mysql to the native supported databases they are supposed to do this but the more pressure they get the faster it will get done! Ken - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 23, 2002 5:32 PM Subject: Erwin Vs Mysql Has anyone got Erwin working with mysql. I guess all directly non-supported DBs by Erwin are suppose to work via ODBC but I have not been able to find ODBC driver (either generic or for mysql). thanks Vivek - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: compile problem with 3.23.50
On Wed, Apr 24, 2002 at 02:27:40PM +0300, Sinisa Milivojevic wrote: mysqld.cc:2428: at this point in file /usr/include/tcpd.h:119: too few arguments to function `int hosts_access(request _info *)' mysqld.cc:2429: at this point in file /usr/include/tcpd.h:153: too few arguments to function `char * eval_client(reque Problem that you are experiencing is caused by changes that were needed to solve problem building MySQL with libwrap on Linux. ... Can you explain why is your Linux so different ?? Hehe, it seems the Debian maintainer once applied some patches because mysqld.cc used arguments to the above functions: http://bugs.debian.org/100891 * tcpd.h: define __P() ourselves; sys/cdefs.h doesn't appear to be standard, and the glibc version adds __throw to the prototypes. mysqld.cc:1190:21: warning: multi-line string literals are deprecated /usr/include/tcpd.h: In function `void* handle_connections_sockets(void*)': /usr/include/tcpd.h:141: too many arguments to function `void sock_host()' I will ask him if these changes are obsolete now. MySQL seems to be right here. bye, -christian- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
uppercase for first letter
sql,query Hi, How could I turn the first letter of each entry to Uppercase letter? the UCASE turns each and every letter and all I need is the first one to be changed JAri Mäkelä - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Unable to get lock on tables for 4.0.1
I have encountered a problem with MySQL 4.0.0 and 4.0.1 in which I am unable to bet a lock on a table with any userid except root. Here is my environment: Sun 450 Solaris 2.8 MyISAM tables Any ideas on how this problem could be solved? Thanks, Nick Gilliam - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: REPLACE() wildcards
Gavin, Tuesday, April 23, 2002, 7:24:14 PM, you wrote: GM When using the REPLACE() function in a query, are there any wildcards GM allowed? If so what are they? Nope. GM Also are regular expressions only usable for matching or can one also do a GM regular expression substitute in some way? No, REGEXP is used only for pattern matching, look at: http://www.mysql.com/doc/R/e/Regexp.html GM Thanks GM Gavin -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: MySQL start
Samuel, Tuesday, April 23, 2002, 8:55:00 PM, you wrote: SM Victoria Reznichenko Samuel, Tuesday, April 23, 2002, 4:04:20 PM, you wrote: SM file serwer.err: SM 020422 19:16:29 mysqld started SM 020422 19:16:32 /usr/libexec/mysqld: Table 'mysql.host' doesn't exist SM 020422 19:16:32 /usr/libexec/mysqld: Normal shutdown SM 020422 19:16:32 mysqld ended Try to find file 'host.frm' in data dir. If file does exist, check your permissions on mysql data dir - it should belong to user and group mysql server is running from. If file doesn't exist, you should run mysql_install_db to re-create grant tables, look at: http://www.mysql.com/doc/m/y/mysql_install_db.html SM I found that file. If you can find that file, it means that privilege tables was created. SM Unfortunatelly, there is no databases after running SM mysql_install_db Did you check permissions on the MySQL data dir and files? MySQL should be owner of the MySQL database directory and all its files. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySql-PHP-Zlib-LIBJPEG-GD
Greetings all, Special greetings to Nathan,Andrew and Jan for previous help. I have some new problems ( big surprise! ) some of which will seem stupid for sure but i'm using the excuse of being a newbie..so i should be forgiven :-). 1.Like i said before I am running Apache,PHP and MySql on a win2k machine. i)How do i create a database called RyanTest with username Ryan and password Pass ii) how do i configure system DSN for this? I know some of you must be holding your stomachs and laughing as the above must be SIMPLE, but please, wipe the tears of laughter out of your eyes, have a heart and reply... 2)I already have PHP running without any problems with apache as a module, i) how do i add ZLIB,LIBPNG,LIBJPEG and GD? (I have already downloaded the required files but cant understand squat on how to add them, Remember guys, god is good and helping me will earn you brownie points and just MAY get you into heaven!) ANY help appreciated. Have a great day, Cheers, -Ryan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: uppercase for first letter
If you can't do it within MySQL (I don't know the answer to that one) you might be able to dump the information to a text file and process it using awk and then reload it. Awk is perfect for this kind of thing. There is a Windows version, if that is your OS. On Wednesday 24 April 2002 08:49 am, Jari Mäkelä wrote: sql,query Hi, How could I turn the first letter of each entry to Uppercase letter? the UCASE turns each and every letter and all I need is the first one to be changed JAri Mäkelä - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: uppercase for first letter
Use the application that you are using to save the information into the database to verify that the first letter of each entry is uppercase. I know for a fact that this can be done with perl, VB, c/c++, php, asp, javascript, and java. I have found that sometimes it is better to let the application do some of the legwork, instead of the db. - Original Message - From: Jim Philips [EMAIL PROTECTED] To: Jari Mäkelä [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, April 24, 2002 9:08 AM Subject: Re: uppercase for first letter If you can't do it within MySQL (I don't know the answer to that one) you might be able to dump the information to a text file and process it using awk and then reload it. Awk is perfect for this kind of thing. There is a Windows version, if that is your OS. On Wednesday 24 April 2002 08:49 am, Jari Mäkelä wrote: sql,query Hi, How could I turn the first letter of each entry to Uppercase letter? the UCASE turns each and every letter and all I need is the first one to be changed JAri Mäkelä - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
average function in mysql
hi, can any one tell me if there is any function to get the average of some values in the mysql database. tnx plz mail to [EMAIL PROTECTED] bobbie __ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: uppercase for first letter
* Jari Mäkelä How could I turn the first letter of each entry to Uppercase letter? the UCASE turns each and every letter and all I need is the first one to be changed You can use a combination of UCASE(), MID() and CONCAT(): SELECT CONCAT(UCASE(MID(name,1,1)),MID(name,2)) AS name FROM names; -- Roger query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySql-PHP-Zlib-LIBJPEG-GD
Hi Jumac, Jumac wrote: Greetings all, Special greetings to Nathan,Andrew and Jan for previous help. I have some new problems ( big surprise! ) some of which will seem stupid for sure but i'm using the excuse of being a newbie..so i should be forgiven :-). 1.Like i said before I am running Apache,PHP and MySql on a win2k machine. i)How do i create a database called RyanTest with username Ryan and password Pass You can use graphical clients: MyCC or MySQLFront. You can use mysql\bin\mysql.exe as textconsole on the mysqlserver (some SQL knowledge needed). ii) how do i configure system DSN for this? Why? Goto: Control Panel then administration or management (my German win2k says Verwaltung) open Datasources (ODBC) icon. I know some of you must be holding your stomachs and laughing as the above must be SIMPLE, but please, wipe the tears of laughter out of your eyes, have a heart and reply... just came back from toilet :-) 2)I already have PHP running without any problems with apache as a module, i) how do i add ZLIB,LIBPNG,LIBJPEG and GD? (I have already downloaded the required files but cant understand squat on how to add them, Remember guys, god is good and helping me will earn you brownie points and just MAY get you into heaven!) Ask the PHP guys. Adib. ANY help appreciated. Have a great day, Cheers, -Ryan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: average function in mysql
* bob nt can any one tell me if there is any function to get the average of some values in the mysql database. Yes, the AVG() function: URL: http://www.mysql.com/doc/G/r/Group_by_functions.html -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fw: MySql-PHP-Zlib-LIBJPEG-GD
Do you use phpadmin? If not download it. The first task is pretty simple with that. Download from www.phpwizard.net - Joseph Jude www.cephire.com - Original Message - From: Jumac To: [EMAIL PROTECTED] Sent: Thursday, April 25, 2002 3:36 AM Subject: MySql-PHP-Zlib-LIBJPEG-GD Greetings all, Special greetings to Nathan,Andrew and Jan for previous help. I have some new problems ( big surprise! ) some of which will seem stupid for sure but i'm using the excuse of being a newbie..so i should be forgiven :-). 1.Like i said before I am running Apache,PHP and MySql on a win2k machine. i)How do i create a database called RyanTest with username Ryan and password Pass ii) how do i configure system DSN for this? I know some of you must be holding your stomachs and laughing as the above must be SIMPLE, but please, wipe the tears of laughter out of your eyes, have a heart and reply... 2)I already have PHP running without any problems with apache as a module, i) how do i add ZLIB,LIBPNG,LIBJPEG and GD? (I have already downloaded the required files but cant understand squat on how to add them, Remember guys, god is good and helping me will earn you brownie points and just MAY get you into heaven!) ANY help appreciated. Have a great day, Cheers, -Ryan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
query returns a BLOB for no reason....
I am hoping someone can shed light on this for me. We have a fairly simple query that is pulling data from numeric fields and concatenating the field contents into a single results column. The problem is the resulting data is reported to be BLOB instead of the expected concatenated stringwhich in turn is causing our application to complain about an unsupported data type (our application is expecting a string value to be returned). It seems like an error in MySQL to us. If anyone is feeling adventurous, I can provide access to a data server to see the actual data and play with the query. this query returns BLOB's: SELECT CONCAT(tblSystemType_1.strDescription, '/', tblSystemType_2.strDescription, '/', tblSystemType_3.strDescription, '_', tblSystemType_1.intSystemTypeID, '/',tblSystemType_2.intSystemTypeID, '/',tblSystemType_3.intSystemTypeID) FROM tblSystemType AS tblSystemType_1, tblSystemType AS tblSystemType_2, tblSystemType AS tblSystemType_3 INNER JOIN tblLineItems ON tblSystemType_1.intSystemTypeID = tblLineItems.intSystemTypeID1 AND tblSystemType_2.intSystemTypeID = tblLineItems.intSystemTypeID2 AND tblSystemType_3.intSystemTypeID = tblLineItems.intSystemTypeID3 WHERE (((tblLineItems.varProjectID)=1) AND (tblLineItems.intLineItemTypeID = 5) AND booActive 0) ORDER BY tblSystemType_1.intSystemTypeID AND tblSystemType_2.intSystemTypeID AND tblSystemType_3.intSystemTypeID strangely enough, this one wroks as expected (has only 2 system types, rather than 3...): SELECT CONCAT(tblSystemType_1.strDescription, '/', tblSystemType_2.strDescription, '_', tblSystemType_1.intSystemTypeID, '/',tblSystemType_2.intSystemTypeID) FROM tblSystemType AS tblSystemType_1, tblSystemType AS tblSystemType_2 INNER JOIN tblLineItems ON tblSystemType_1.intSystemTypeID = tblLineItems.intSystemTypeID1 AND tblSystemType_2.intSystemTypeID = tblLineItems.intSystemTypeID2 WHERE (((tblLineItems.varProjectID)=4) AND (tblLineItems.intLineItemTypeID = 1) AND booActive 0) ORDER BY tblSystemType_1.intSystemTypeID AND tblSystemType_2.intSystemTypeID Thanks for any suggestions or answers anyone is kind enough to provide. - Jerry Jackson Director of Software Development BCA Technologies, Inc. (407) 659-0653 ext. 320 [EMAIL PROTECTED] - --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.350 / Virus Database: 196 - Release Date: 4/17/2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
last_insert_id() query
Hi, I have a big problem with last_insert_id() query. I am adding records to a table with about half a million records in it. The insert takes well under a second. I then call last_insert_id as I need to make a link to another table. The last_insert_id takes around 2 minutes!!! Yes *minutes*! Has anybody any idea what might be going wrong here. The auto increment field is definitely a primary key and any other searches on the table are quite quick. Cheers - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fw: user problem
I have mysql installed on a linux platform. I have no problem running every thing as root. When I try to run mysql as a user other than root, I entered command use mysql. I get error 1044:access denied for user:localhost to database 'mysql'. is there a file that I need to change the permissions on or change the group in a var or usr subdirectory. Thank you for your help on this matter. Kenn Ward
RE: user problem
If you are ruing as user mysql do chown -R root /usr/local/mysql chown -R mysql /usr/local/mysql/var chgrp -R mysql /usr/local/mysql Change to sute tast (or what you database is) Simon -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 24 April 2002 13:51 To: [EMAIL PROTECTED] Subject: Fw: user problem I have mysql installed on a linux platform. I have no problem running every thing as root. When I try to run mysql as a user other than root, I entered command use mysql. I get error 1044:access denied for user:@localhost to database 'mysql'. is there a file that I need to change the permissions on or change the group in a var or usr subdirectory. Thank you for your help on this matter. Kenn Ward - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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: user problem
Create a mysql user using phpMyAdmin or using the best way you find! I thing that using phpMyAdmin is the most user-friendly way to do it! mysql will ask you to give permisions on that user. Give any permission you would like and that's all! On Wed, 24 Apr 2002 [EMAIL PROTECTED] wrote: I have mysql installed on a linux platform. I have no problem running every thing as root. When I try to run mysql as a user other than root, I entered command use mysql. I get error 1044:access denied for user:@localhost to database 'mysql'. is there a file that I need to change the permissions on or change the group in a var or usr subdirectory. Thank you for your help on this matter. Kenn Ward - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: average function in mysql
bob, Wednesday, April 24, 2002, 4:28:12 PM, you wrote: bn can any one tell me if there is any function to get bn the average of some values in the mysql database. Sure, take a look at AVG() function: http://www.mysql.com/doc/G/r/Group_by_functions.html bn tnx bn plz mail to [EMAIL PROTECTED] bn bobbie -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Unable to get lock on tables for 4.0.1
Nick, Wednesday, April 24, 2002, 3:59:26 PM, you wrote: NG I have encountered a problem with MySQL 4.0.0 and 4.0.1 in which I am NG unable to bet a lock on a table with any userid except root. NG Here is my environment: NG Sun 450 NG Solaris 2.8 NG MyISAM tables NG Any ideas on how this problem could be solved? Since version 4.0 user must have SELECT, UPDATE, DELETE, INSERT privileges to lock tables. NG Thanks, NG Nick Gilliam -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem installing Msql-Mysql module
I've installed MySQL 2.23.49 on Solaris 2.7. I've downloaded the binary installation (mysql-3.23.49-sun-solaris2.7-sparc). I'm using gcc 2.95.3 and make 3.78.1, both downloaded from SunFreeware site (gcc-2.95.3-sol7-sparc-local and make-3.78.1-sol7-sparc-local). I've installed the modules Data-Dumper-2.101, Data-ShowTable-3.3 and DBI-1.18 without any problem. However when I was installing Msql-Mysql-modules-1.2218, I've got the following errors: ... PERL_DL_NONLAZY=1 /bin/perl -I../blib/arch -I../blib/lib -I/usr/local/lib/perl5/5.6.1/sun4-solaris -I/usr/local/lib/perl5/5.6.1 -e 'use Test::Harness qw(runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t t/00baseinstall_driver(mysql) failed: Can't load '../blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /bin/perl: fatal: libgcc_s.so.1: open failed: No such file or directory at /usr/local/lib/perl5/5.6.1/sun4-solaris/DynaLoader.pm line 206. at (eval 1) line 3 Compilation failed in require at (eval 1) line 3. Perhaps a required shared library or dll isn't installed where expected at t/00base.t line 38 t/00basedubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 4-5 Failed 2/5 tests, 60.00% okay t/10dsnlist.install_driver(mysql) failed: Can't load '../blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /bin/perl: fatal: libgcc_s.so.1: open failed: No such file or directory at /usr/local/lib/perl5/5.6.1/sun4-solaris/DynaLoader.pm line 206. at (eval 1) line 3 Compilation failed in require at (eval 1) line 3. Perhaps a required shared library or dll isn't installed where expected at t/10dsnlist.t line 45 t/10dsnlist.dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 1-3 Failed 3/3 tests, 0.00% okay ... - I follow all the suggestions on the manual, section 2.7.4 Problem Using the Perl DBI/DBD Interface, but I had no success. Please, can anyone help me? Thanks in advace, --- Rodney A. Ramos Tel.: (02121) 2519-3023 FAX: (02121) 2519-2728 Analista de Redes e Serviços VPR-55 (Centro de Gerência de Dados Comutados) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
temporary tables
Hi, Does it make sense to use temporary tables as a substitute for Views? Where do I look in the docs for info? Thanks. Mysql. Andrew Hazen, O.C.P. E-Commerce Developer Jatech Solutions Inc. www.jatech.ca Specializing in OSCOMMERCE applications and PHP/MySQL programming. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
connection delphi 6 / ADO with the mysql
I am needing to do a connection delphi 6 / ADO with the mysql that is in a linux Freebsd of the qmail. Does anybody know as I can make that? Thankful, Marcos Birro Calixto [EMAIL PROTECTED] Webmaster - WebDeveloper - Delphi UIN: 9151558 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
QUICK QUESTION: Referencing MySQL
What year was the web page http://www.mysql.com/doc/S/t/Standards.html created/updated. Exact month and day would be helpful if it is available. I am referencing this page in an assignment and a year would be useful. Your thoughts. Thanks lots David Ayliffe ICQ# 125646758 Query, table, 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
configure probleem
I try to install mysql on a sparc 250 / solaris 7. I have problem when I come at the configure step : I don't have a configure program on my computer. With a find, I find one on the /usr/local/share/libtool/libltdl directory but when I try to use it, I receive a message : can not find sources in . or .. What can I do ? Another problem is that I don't know from witch directory I have to do the make ? The contain of config.log is : This file contains any messages produced by compilers while running configure, to aid debugging if configure makes a mistakes. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 benchmark
There are tools for benchmark on win32 via ODBC ? I would like to test sql query in my VB6 application. Thank you. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 installation - DB dies
Having followed instructions from various sources and installed from source (twice) and binary (once), I still get the following problem. --- [root mysql]# /usr/local/mysql/bin/safe_mysqld [1] 16168 [root mysql]# Starting mysqld daemon with databases from /usr/local/mysql/var 020425 00:11:37 mysqld ended Please help! I am using Cobalt Linux release 6.0 (Carmel) Kernel 2.2.16C7 on an i586 Thank you in advance. Daniel. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
undefined function: mysql_connect()
Hello, i'm trying to use PHP4 and MySQL and i'm getting undefined function: mysql_connect() both PHP and MySQL are working on their own, but i have something missing form the PHP setup where it doesn't recognise MySQL. I'd really appreciate any 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
MySQL using Cygwin DLL on Windows?
Hi, all: I read the document, it says MySQL Server runs as a native Windows application and You will need VC++ 6.0 compiler for MySQL Windows source distribution. But we I try to download Windows binary package, it says Since mysqlc contains Cygwin runtime DLLs, we also offer you the Cygwin sourcecode for compliance with GPL. What does this mean? If I install MySQL as native application, Do I still need to use Cygwin DLL? Thanks! Zengfa __ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: undefined function: mysql_connect()
TK Hello, i'm trying to use PHP4 and MySQL and i'm getting undefined function: TK mysql_connect() This question belongs on a/the PHP mailing list, but the answer is that you need to compiled PHP --with-mysql. Please read the PHP installation instructions in the very handy manual at http://www.php.net/manual/ - Julie -- Julie Meloni -- [EMAIL PROTECTED] -- www.thickbook.com Find Sams Teach Yourself MySQL in 24 Hours at http://www.amazon.com/exec/obidos/ASIN/0672323494/thickbookcom-20 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 installation.
Hello: My name is Gerardo Hernandez, in last time I triying installation MySQL in one machine with IBM/AIX 4.3.3.10, but when running createUser.sh show me message below: Could not load program mysql: Dependent module libmysqlclient.a could not be loaded. Could not load module libmysqlclient.a. Error was: No such file or directory Why this error???, exist any solution or recomendation for this??? Regards Gerardo. PD: Sorry but my english is poor. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 installation - DB dies - SOLVED
Opps sorry. Found the problem. Not starting as proper user. Thanks. D. -- On Wed, 24 April 2002, D Okonkwo wrote: Having followed instructions from various sources and installed from source (twice) and binary (once), I still get the following problem. --- [root mysql]# /usr/local/mysql/bin/safe_mysqld [1] 16168 [root mysql]# Starting mysqld daemon with databases from /usr/local/mysql/var 020425 00:11:37 mysqld ended Please help! I am using Cobalt Linux release 6.0 (Carmel) Kernel 2.2.16C7 on an i586 Thank you in advance. Daniel. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 with Delphi 5.0
Hi, Did you use dbexpmysql.dll(not dbexpmys.dll) ? Alexander Burbello wrote: I tryed to use Delphi 6.0 and dbExpress, but I didn't got. What component and what property I have to set for use correct?? Regards Alexander -- Mensagem Original -- Hi, Haroldo Is it first time to develop Database Application with Delphi? Do you know how to use DataAccess Component(e.g., TDatabase) and BDE(or BDE Administrator)? I suggest to use Delphi6 Pro/Ent. It contains dbExpress Component which help you to develop Database Application very easily. (Note: dbExpress is able to connect to MySQL server directly, using Native Driver without ODBC Driver) Thanks. -- Borland Japan / Consulting Group TAKAHASHI, "KEN", Tomohiro José Haroldo Filho wrote: I've installed MyODBC and then I've set up ODBC and I saw the driver for MySQL DB, when I try to create a new alias wiht MySQL it does not apear to select the DB, acording a book wich is guiding it should has to appear. Can anybody help to set up the ALIAS with MySQL Thanks -- TAKAHASHI, "KEN", 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: MySql installation - DB dies
D, Wednesday, April 24, 2002, 6:16:31 PM, you wrote: DO Having followed instructions from various sources and installed from source (twice) and binary (once), I still get the following problem. DO --- DO [root mysql]# /usr/local/mysql/bin/safe_mysqld DO [1] 16168 DO [root mysql]# Starting mysqld daemon with databases from /usr/local/mysql/var DO 020425 00:11:37 mysqld ended Please, look in the your host_name.err file in the MySQL data dir and show me the contents of this file (but not the whole file! about last 20-40 rows ...) DO DO Please help! DO I am using Cobalt Linux release 6.0 (Carmel) Kernel 2.2.16C7 on an i586 DO Thank you in advance. DO Daniel. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: undefined function: mysql_connect()
Tewfic, Wednesday, April 24, 2002, 6:14:58 PM, you wrote: TK Hello, i'm trying to use PHP4 and MySQL and i'm getting undefined function: TK mysql_connect() TK both PHP and MySQL are working on their own, but i have something missing TK form the PHP setup where it doesn't recognise MySQL. It looks like your PHP version is compiled without support of MySQL. For more details look at: http://www.mysql.com/doc/P/H/PHP_problems.html and http://www.php.net/ TK I'd really appreciate any help. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
need help for REPLICATION
Hello, I am new in mysql, and I am trying to set an reclication. I followed the instruction in the manual but steel I have a problem. The problem is that even the replication thread works on my slave it is not doing eny updates. The master.info file is updating every minute and there is not errors in the error file. But I dont have any log file for the replication activities even I set log-slave-updates on my slave. Can some one felp me with that? Thanks in advance Vlady This is my my.cnf files on the master and the slave: On my master I have in my.cnf : [mysqld] port=3306 log-bin binlog-do-db=fdf server-id=1 On my slave I have in my.cnf : [mysqld] server-id=3 master-host=my.master master-user=replica master-password=the_passwd master-port=3306 replicate-do-db=fdf log-bin log-slave-updates - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Multiple MySQL servers same computer
Is there any way to be a slave to multiple masters from a single instance of a mysql server? If not, I suppose we can run multiple instances of mysql server, each with its own data directory and reading its own my.cnf file ( which I dont think would be too hard to do on a linux pc BUT) How would I get multiple instances of mysql running on a WinNT server. The install does all the work. Would I have to get into the nitty of services and do some playing? Can someone give me some pointers in doing this? Luc Foisy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlgui and DNS
I'm having a couple of problems running mysqlgui on Windows XP Pro. 1) Intermittent 1 - 2 second delays on connecting and executing queries 2) 30 second delay on connecting and occasionally when executing queries when a dial-up connection is present The problems appear to be related to DNS lookups. I'm not sure why mysqlgui needs any info other than what is present in the hosts file. In comparison, the console-based client, mysql.exe, suffers no delays with or without a dial-up connection. The second problem is also present on Win98 but the delays are much shorter. On my linux machine, mysqlgui has none of these problems even if a dial-up connection is active. Is anyone else having this problem? Is there a fix for it? Thanks in advance Environment: machine 1: red hat linux 7.2 - mysql server machine 2: windows xp - client machine 3: windows 98 - client - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqlgui and DNS
John Derrick writes: I'm having a couple of problems running mysqlgui on Windows XP Pro. 1) Intermittent 1 - 2 second delays on connecting and executing queries 2) 30 second delay on connecting and occasionally when executing queries when a dial-up connection is present [skip] Is anyone else having this problem? Is there a fix for it? Thanks in advance Environment: machine 1: red hat linux 7.2 - mysql server machine 2: windows xp - client machine 3: windows 98 - client A fix is to use IP address in the host field. -- 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
sql command to examine blob data?
What sql function can I use to examine blob in a table. I need to display part of the blob in hex values. Shouldn't the following sql command work : select hex(substring(col1,1,10)) from table tbl1; Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
question
Hello, I am trying to transfer tables/data from one server to another, say server A to B. mysqldmup helps me to dump table structure and data from server A. Wonder what command I should use to load those dump result into server B. Both server A and B are using the same version of MySQL. Any help is appreciated. Thanks. Andrew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: I thought MySQL Supported Relationships
At 06:04 PM 23/04/2002 -0700, you wrote: http://www.google.com/search?hl=enq=Views+Mysql ... MySQL Manual | 1.7.4.6 Views ... It is planned to implement views in MySQL Server around Version 4.1. Views are mostly useful for letting users access a set of relations as one table (in read ... www.mysql.com/doc/A/N/ANSI_diff_Views.html - 17k - Cached - Similar pages MySQL Manual | 1.7.3.7 Views ... One doesn't need views in MySQL to restrict access to columns as MySQL has a very sophisticated privilege system. See section 4.2 General Security Issues and ... www.mysql.com/doc/M/i/Missing_Views.html - 9k - Cached - Similar pages [ More results from www.mysql.com ] Views made it possible to implement one of the most ambitious projects at a company I worked for. The project involved a new methodology that I stole - er - developed. It used a modular data model that let us model the entire corporation in under a year when the original estimate was in excess of 5 years. We were able to bring SECTIONS of the system to production a blinding speed. As an example, we brought one section up and running a full year before we were scheduled to start. It seems that one of the programmers had a free weekend and did it all - instead of taking 3 programmers a year. None of it would have been possible if we had not had views (Oracle on the mainframe and on PCs) to isolate the inner complexity from the application. I'd love to try such a project with MySQL. Here's hoping that 4.1 isn't too far off. -Original Message- From: Arthur Fuller [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 5:57 PM To: Jonathan Hilgeman; [EMAIL PROTECTED] Subject: Re: I thought MySQL Supported Relationships Perhaps I fail to catch the humour in your response, or the flavour of this newsgroup, but I find your answer in no way helpful, and beyond that quite insulting to Access. 1. I have developed applications in Access comprising over 1000 tables, some of which contain millions of rows, with numerous complex relationships and C++ components that interfaced to instruments such as scales, scanners, etc. I am not the only one to push Access that far. 2. To answer Andrew's question, the answer is No. MySQL does not support defined relationships. The InnoDB extension provides this support. 3. Unfortunately, as of this writing neither MySQL nor InnoDB supports defined queries (Oracle and SQL Server call them Views). Allegedly, MySQL 4.1 will support stored procedures (and I for one hope that views make it into the build). Arthur - Original Message - From: Jonathan Hilgeman [EMAIL PROTECTED] To: 'Andrew Kuebler' [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, April 23, 2002 2:43 PM Subject: RE: I thought MySQL Supported Relationships Actually, no. The addiction to MySQL has caused many relationship break-ups. There's probably even a database with that information out there somewhere. Probably a MySQL database, too. Meanwhile Access supports relationships because it blows so hard that people can't wait to get away from it and home to their families. - Jonathan -Original Message- From: Andrew Kuebler [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 11:35 AM To: [EMAIL PROTECTED] Subject: I thought MySQL Supported Relationships Hello Everyone. I'm still fairly a newbie to MySQL, but I could have sworn I read somewhere that MySQL supported relationships just like Access. I've searched the entire manual, and cannot find anything on the subject. Does MySQL support relationships, and if so does anyone know where I can find any info on the topic? Thanks! Andrew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Unable to get lock on tables for 4.0.1
Egor Egorov wrote: Nick, Wednesday, April 24, 2002, 3:59:26 PM, you wrote: NG I have encountered a problem with MySQL 4.0.0 and 4.0.1 in which I am NG unable to bet a lock on a table with any userid except root. NG Here is my environment: NG Sun 450 NG Solaris 2.8 NG MyISAM tables NG Any ideas on how this problem could be solved? Since version 4.0 user must have SELECT, UPDATE, DELETE, INSERT privileges to lock tables. NG Thanks, NG Nick Gilliam Thanks for the reply. The user has the following privileges: SELECT, UPDATE, CREATE, INSERT, DELETE, DROP, INDEX, REFERENCES, ALTER. The user has these same privileges for every table in the database, but this is the only one he cannot lock. This was not an initial problem but occurred later. Any help is greatly appreciated. Thanks, Nick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: question
Easy, =) mysqldump database name -ppassword | mysql database name -h 192.168.1.1 -ppassword That will dump the database and remotely insert in to the other server. -Jason On Wed, 2002-04-24 at 13:46, Andrew Chan wrote: Hello, I am trying to transfer tables/data from one server to another, say server A to B. mysqldmup helps me to dump table structure and data from server A. Wonder what command I should use to load those dump result into server B. Both server A and B are using the same version of MySQL. Any help is appreciated. Thanks. Andrew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
mysqlgui
To whom it may concern, Where can i find the documentation for mysqlgui? thanks bd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqlgui and DNS
Thanks for the reply. Using the IP address in the host field does not fix the problem, however. The delay in problem 1 changes from 1 - 2 seconds to 10 seconds. No impact on problem 2. Do I need to change the parameters to the server? - Original Message - From: Sinisa Milivojevic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, April 24, 2002 1:08 PM Subject: Re: mysqlgui and DNS John Derrick writes: I'm having a couple of problems running mysqlgui on Windows XP Pro. 1) Intermittent 1 - 2 second delays on connecting and executing queries 2) 30 second delay on connecting and occasionally when executing queries when a dial-up connection is present [skip] Is anyone else having this problem? Is there a fix for it? Thanks in advance Environment: machine 1: red hat linux 7.2 - mysql server machine 2: windows xp - client machine 3: windows 98 - client A fix is to use IP address in the host field. -- 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: question
Basically these two servers are not connected to each other. Also I am using win2k. I believe the syntax that you give me is in Unix. So I am thinking I should use the dump text file sorry not providing enough info... Thanks thought. Andrew - Original Message - From: Jason Yates [EMAIL PROTECTED] To: Andrew Chan [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, April 24, 2002 1:04 PM Subject: Re: question Easy, =) mysqldump database name -ppassword | mysql database name -h 192.168.1.1 -ppassword That will dump the database and remotely insert in to the other server. -Jason On Wed, 2002-04-24 at 13:46, Andrew Chan wrote: Hello, I am trying to transfer tables/data from one server to another, say server A to B. mysqldmup helps me to dump table structure and data from server A. Wonder what command I should use to load those dump result into server B. Both server A and B are using the same version of MySQL. Any help is appreciated. Thanks. Andrew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
replication
Hi, Setting an replication for the first time, I get the following error message in my slave: 020424 13:59:28 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at position 4 020424 13:59:29 Slave: did not get the expected error running query from master - expected: 'Invalid error code' (256), got 'no error' (0) 020424 13:59:29 Slave: error running query '' 020424 13:59:29 Error running query, slave aborted. Fix the problem, and re-start the slave thread with mysqladmin start-slave. We stopped at log 'FIRST' position 31632 020424 13:59:29 Slave thread exiting, replication stopped in log 'FIRST' at position 31632 If some one knows what can be the reason? I have the following configuration on the master and the slave: On my master I have in my.cnf : [mysqld] port=3306 log-bin binlog-do-db=fdf server-id=1 On my slave I have in my.cnf : [mysqld] server-id=3 master-host=cc.uc.uni-sofia.bg master-user=replica master-password=the_passwd master-port=3306 log-slave-updates - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
OSX Mysqladmin and Cron
I set up a script to rotate my logs for mysql and cron fires it off perfectly the logs are rotated but when the shell script gets to the last line which is... mysqladmin -u usernam -pPassword flush-logs it will not execute it - my file that logs the execution of the cron script says it doesn't recognize the command mysqladmin any ideas??? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
character
Does anyone know if there is a way to preserve the trademark character when importing it into to MySQL? Using Lasso 5 I can add it through a form submission and retrieve it in tact, so there must be a way... I am using LOAD DATA to import my text file... -- - Alex Pilson FlagShip Interactive, Inc. [EMAIL PROTECTED] 404.728.4417 404.642.8225 CELL // Web Design // Lasso Application Development // Filemaker Pro / SQL Development // Sonic Solutions Creator Authoring // Apple DVD Studio Pro Authoring // Macromedia Director/Flash Authoring - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
delta between rows?
To Mysql Team how can I generate a list of deltas between columns in different rows for the entire table? what I need is an sql command that does something like this: for N =0 to i do : select colA of current rowN - colA of pervious row(N-1) from tab1; ColA = floating point number. Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Erwin Vs Mysql ....
Ken, Thanks for your help. I got it working. For now I needed to reverse engineer the database. The trickier part was the username and password. I initially gave mysql login name. But actually you have to give either DB owner or root. Unfortunately we do not have support contract. Somebody picked up this DB because it costs nothing. And now it has come on me to maintain it apart from maintaining Oracle, Informix, Ingres etc. once again thanks for your help. Vivek -Original Message- From: kenm [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 24, 2002 5:22 AM To: CHAUDHARY, Vivek; mysql Cc: kenm Subject: Re: Erwin Vs Mysql Try MyODBC from the downloads page at www.mysql.com. Erwin works fine for reverse engineering databases, on forward engineering I do have to make some patchs by hand to script before I can generate a model. Maybe I need to learn to use Erwin better. Also if you have a support contract please call and ask them to add mysql to the native supported databases they are supposed to do this but the more pressure they get the faster it will get done! Ken - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 23, 2002 5:32 PM Subject: Erwin Vs Mysql Has anyone got Erwin working with mysql. I guess all directly non-supported DBs by Erwin are suppose to work via ODBC but I have not been able to find ODBC driver (either generic or for mysql). thanks Vivek - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
C API Question
In the MYSQL struct in the C API, how does one access the MYSQL_FIELD data? for example, and MYSQL struct has MYSQL_FIELD *fields; as a member variable. However, when I try to access any of the variables within fields for example, mysql.fields[0].name, I get a segmentation fault. Does anyone know what I am doing wrong? Andrew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: last_insert_id() query
Don't include a from clause with the last_insert_id(), or you will get a full table scan. The last_insert_id will only give you the insert id for the last record inserted. mysql mailing list user wrote: Hi, I have a big problem with last_insert_id() query. I am adding records to a table with about half a million records in it. The insert takes well under a second. I then call last_insert_id as I need to make a link to another table. The last_insert_id takes around 2 minutes!!! Yes *minutes*! Has anybody any idea what might be going wrong here. The auto increment field is definitely a primary key and any other searches on the table are quite quick. Cheers - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: New Setup
At 12:04 PM 24/04/2002 +1000, you wrote: Using the commands you have offered... Egor Your 'root' user doesn't have GRANT privilege ... Egor Egor You should change Grant_priv to 'Y' Egor You can do this using UPDATE statement: Egor UPDATE user SET Grant_priv='Y' WHERE user='root'; I get this response.. ERROR 1017: Can't find file: 'user.frm' (errno: 2) He should check that the owner of user.frm is mysql. --- Endeavouring to run mysqld as per... Egor or you run mysqld with --skip-grant-tables option and set Grant_priv Egor using GRANT statement: Egor GRANT ALL ON *.* to 'root'@'localhost' identified by Egor 'password_obscured' WITH GRANT OPTION; myslqd tells me it's it is ready for input. But I'm not sure what to input? Ian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: OSX Mysqladmin and Cron
make sure the directory where mysqladmin lives is in your $PATH in that script, i.e. add $PATH=$PATH:/usr/local/bin (or where ever it is...) in the beginning of your script where environment variables are set. -Don -Original Message- From: Dion Wickander [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 24, 2002 2:50 PM To: MySQL Help Subject: OSX Mysqladmin and Cron I set up a script to rotate my logs for mysql and cron fires it off perfectly the logs are rotated but when the shell script gets to the last line which is... mysqladmin -u usernam -pPassword flush-logs it will not execute it - my file that logs the execution of the cron script says it doesn't recognize the command mysqladmin any ideas??? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: OSX Mysqladmin and Cron
Don't put quotes around your password. Dion Wickander wrote: I set up a script to rotate my logs for mysql and cron fires it off perfectly the logs are rotated but when the shell script gets to the last line which is... mysqladmin -u usernam -pPassword flush-logs it will not execute it - my file that logs the execution of the cron script says it doesn't recognize the command mysqladmin any ideas??? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: OSX Mysqladmin and Cron
Thanks!!! for the advice it works perfectly now on 4/24/02 2:19 PM, Don Vu at [EMAIL PROTECTED] wrote: make sure the directory where mysqladmin lives is in your $PATH in that script, i.e. add $PATH=$PATH:/usr/local/bin (or where ever it is...) in the beginning of your script where environment variables are set. -Don -Original Message- From: Dion Wickander [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 24, 2002 2:50 PM To: MySQL Help Subject: OSX Mysqladmin and Cron I set up a script to rotate my logs for mysql and cron fires it off perfectly the logs are rotated but when the shell script gets to the last line which is... mysqladmin -u usernam -pPassword flush-logs it will not execute it - my file that logs the execution of the cron script says it doesn't recognize the command mysqladmin any ideas??? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fw: user problem
Hi! kennonward == kennonward [EMAIL PROTECTED] writes: kennonward I have mysql installed on a linux platform. I have no problem running every thing as root. When I try to run mysql as a user other than root, I entered command use mysql. I get error 1044:access denied for user:@localhost to database 'mysql'. kennonward is there a file that I need to change the permissions on or change the group in a var or usr subdirectory. This is described in detail in the 'Access denied' section in the MySQL manual. You have to do a GRANT command to tell MySQL which other users you want to give access to the MySQL database. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysq[-Max] 3.23.50, .51 with autoextend.... where are they?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hey, At various places on the MySQL web site there's mention of 3.23.50 and 3.23.51, and the new autoextend feature. However, the most recent on the download page is 3.23.49a. Was .50/.51 not released because of bugs or something? - -- - Jonathan Wilson System Administrator Clickpatrol.com Cedar Creek Software http://www.cedarcreeksoftware.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE8xxpNQ5u80xXOLBcRAp7pAKCiWlx8zXy0KDZQ+KXXSP02juSJdgCgtkVg D+E9qbYmboMS8tV3bse0sh4= =WH2e -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 3.23.44 not using indexes
I haven't found the problem, but I seem to have found the solution. If I dump the data and re-import it (causing the index files to be re-created from scratch), the indexes work fine. I think this problem started when I upgraded from MySQL 3.22.30 to 3.23.44 and converted the tables from ISAM to MyISAM, so perhaps there is a corruption issue in this upgrade/conversion. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysq[-Max] 3.23.50, .51 with autoextend.... where are they?
On Wed, Apr 24, 2002 at 03:49:17PM -0500, JW wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hey, At various places on the MySQL web site there's mention of 3.23.50 and 3.23.51, and the new autoextend feature. However, the most recent on the download page is 3.23.49a. Was .50/.51 not released because of bugs or something? There's a pre-release of .50 available. Hopefully it'll be a real release by the end of the week. .51 will follow sometime after that (several weeks?). Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 76 days, processed 2,000,488,543 queries (303/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problem with max
i write a program using MyIsam,and i want uses Innodb. the query: select max(date_comp) as mdate from pieces on MyIsam mdate is a date. on InnoDB mdate is string. win2000 delphi6 zeosdbo it's normal? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: character
Hi, because you must use the optional command for fields or lines : Eg. load data infile 'yourfile' into table your_table fields terminated by '\your_delimiter_char_for_fields' lines terminated by '\r\n'; _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Alex Pilson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 24, 2002 9:56 PM Subject: character Does anyone know if there is a way to preserve the trademark character when importing it into to MySQL? Using Lasso 5 I can add it through a form submission and retrieve it in tact, so there must be a way... I am using LOAD DATA to import my text file... -- - Alex Pilson FlagShip Interactive, Inc. [EMAIL PROTECTED] 404.728.4417 404.642.8225 CELL // Web Design // Lasso Application Development // Filemaker Pro / SQL Development // Sonic Solutions Creator Authoring // Apple DVD Studio Pro Authoring // Macromedia Director/Flash Authoring - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: character
At 12:23 AM +0300 4/25/02, Gelu wrote: Hi, because you must use the optional command for fields or lines : Eg. load data infile 'yourfile' into table your_table fields terminated by '\your_delimiter_char_for_fields' lines terminated by '\r\n'; I do. So how does that have anything to do with the trademark character getting encoded correctly into a MySQL field? -- - Alex Pilson FlagShip Interactive, Inc. [EMAIL PROTECTED] 404.728.4417 404.642.8225 CELL // Web Design // Lasso Application Development // Filemaker Pro / SQL Development // Sonic Solutions Creator Authoring // Apple DVD Studio Pro Authoring // Macromedia Director/Flash Authoring - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
variant type
Subject: variant type From: deco [EMAIL PROTECTED] === i need to have a table column holding multiple numeric values (double, int, float, etc)... I was thinking of using a variant type for this. Does Mysql support this? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Multi Line SQL Statements
I have a dumb Question... When I try to enter a Multiple line SQL statement like: create table ZIPSTA2 (zip char(5), state char(2)) ; create table ZIPSTATES (state char(2), zip char(5)); I get this error: [root@localhost:3306] ERROR 1064: You have an error in your SQL syntax near '; create table ZIPSTATES (state char(2), zip char(5))' at line 1 What am I doing wrong? mike ps: I am using MySQL Control Center 0.8.2 alpha - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Multi Line SQL Statements
Michael ... Works for me ... at the console: mysql create table zipsta2 (zip char(5), state char(2)); Query OK, 0 rows affected (0.06 sec) mysql create table zipstates (state char(2), zip char (5)); Query OK, 0 rows affected (0.06 sec) Put the same query in a script piped into MySQL with same results. How are you entering a multiple SQL statement? Gerald Jensen - Original Message - From: Michael Grover [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 24, 2002 6:59 PM Subject: Multi Line SQL Statements I have a dumb Question... When I try to enter a Multiple line SQL statement like: create table ZIPSTA2 (zip char(5), state char(2)) ; create table ZIPSTATES (state char(2), zip char(5)); I get this error: [root@localhost:3306] ERROR 1064: You have an error in your SQL syntax near '; create table ZIPSTATES (state char(2), zip char(5))' at line 1 What am I doing wrong? mike ps: I am using MySQL Control Center 0.8.2 alpha - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: replication
On Wed, Apr 24, 2002 at 02:32:52PM -0400, vlady wrote: Hi, Setting an replication for the first time, I get the following error message in my slave: 020424 13:59:28 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at position 4 020424 13:59:29 Slave: did not get the expected error running query from master - expected: 'Invalid error code' (256), got 'no error' (0) 020424 13:59:29 Slave: error running query '' 020424 13:59:29 Error running query, slave aborted. Fix the problem, and re-start the slave thread with mysqladmin start-slave. We stopped at log 'FIRST' position 31632 020424 13:59:29 Slave thread exiting, replication stopped in log 'FIRST' at position 31632 If some one knows what can be the reason? When a MySQL server executes a query and stores a record of it in the replication log (binlog), it also records the result code (or error code) associated with running that query. This allows slaves to make sure that they have the same result (success or failure) when they run the same query. If they notice something wrong, they'll stop dead in their tracks until you have a chance to fix it. I can't say why it happened in your case, but it did. The master had a problem running the original query, but the slave did not. So the slave assumed something is wrong, since it is supposed to be identical to the master. Does that help? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 76 days, processed 2,001,903,357 queries (303/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Multi Line SQL Statements
It's The MySQL Control Center program. I can take and save the sql statements from Mycc to a text file and call MySql c:\sql.txt and it runs fine... wierd Gerald R. Jensen wrote: Michael ... Works for me ... at the console: mysql create table zipsta2 (zip char(5), state char(2)); Query OK, 0 rows affected (0.06 sec) mysql create table zipstates (state char(2), zip char (5)); Query OK, 0 rows affected (0.06 sec) Put the same query in a script piped into MySQL with same results. How are you entering a multiple SQL statement? Gerald Jensen - Original Message - From: Michael Grover [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 24, 2002 6:59 PM Subject: Multi Line SQL Statements I have a dumb Question... When I try to enter a Multiple line SQL statement like: create table ZIPSTA2 (zip char(5), state char(2)) ; create table ZIPSTATES (state char(2), zip char(5)); I get this error: [root@localhost:3306] ERROR 1064: You have an error in your SQL syntax near '; create table ZIPSTATES (state char(2), zip char(5))' at line 1 What am I doing wrong? mike ps: I am using MySQL Control Center 0.8.2 alpha - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: replication
oops I meant MySql c:\sql.txt Jeremy Zawodny wrote: On Wed, Apr 24, 2002 at 02:32:52PM -0400, vlady wrote: Hi, Setting an replication for the first time, I get the following error message in my slave: 020424 13:59:28 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at position 4 020424 13:59:29 Slave: did not get the expected error running query from master - expected: 'Invalid error code' (256), got 'no error' (0) 020424 13:59:29 Slave: error running query '' 020424 13:59:29 Error running query, slave aborted. Fix the problem, and re-start the slave thread with mysqladmin start-slave. We stopped at log 'FIRST' position 31632 020424 13:59:29 Slave thread exiting, replication stopped in log 'FIRST' at position 31632 If some one knows what can be the reason? When a MySQL server executes a query and stores a record of it in the replication log (binlog), it also records the result code (or error code) associated with running that query. This allows slaves to make sure that they have the same result (success or failure) when they run the same query. If they notice something wrong, they'll stop dead in their tracks until you have a chance to fix it. I can't say why it happened in your case, but it did. The master had a problem running the original query, but the slave did not. So the slave assumed something is wrong, since it is supposed to be identical to the master. Does that help? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 76 days, processed 2,001,903,357 queries (303/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Default current date
How can i set the default values of a datetime field in a mysql table as the current date. I am trying alter table copy_tbl add create_date datetime default now() but it does not work. Please help. Regards, Harpreet Kaur _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
PHP and MySQL help please !
+ PHP Installed and going - I can write to files, retrieve flatfiles + Apache running servers outpages nop probes Trying to talk to SQL using PHP. -- html body h1Go to SQL now/h1 ? echo looking; @ $db = mysql_pconnect(localhost, user, password); if (!$db); { echo Error: Could not connect to database. Please try again later.; exit; } mysql_select_db(test); $query = select * from logbook ; $result = mysql_query($query); $num_results = mysql_num_rows($result); echo pNumber of books found: .$num_results./p; ? /body /html - What gets me if I can do all this from the mysql prompt:- laptopmysql -u user -p (enterpassword gets me in) mysqluse test; OK mysqlselect * from logbook; OK (shows entries no probs); - What am I doing wrong ? It doesnt get past the @ $db = mysql_pconnect(localhost, user, password); in the code. ?? Andrew --- Andrew Rich Callsign: VK4TEC [EMAIL PROTECTED] www.users.bigpond.com/andrew.rich/vk4tec.htm --- Andrew Rich Callsign: VK4TEC [EMAIL PROTECTED] www.users.bigpond.com/andrew.rich/vk4tec.htm - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: PHP and MySQL help please !
Further to this, I removed the @ symbol and got:- Fatal Error: Call to undefined function: mysql_connect() in /var/www/html/results.php @ $db = mysql_pconnect(localhost, user, password); $db = mysql_pconnect(localhost, user, password); Ideas ? Why is it now a undefined function ? Andrew -Original Message- From: Andrew Rich [mailto:[EMAIL PROTECTED]] Sent: Thursday, 25 April 2002 11:14 AM To: [EMAIL PROTECTED] Subject: PHP and MySQL help please ! + PHP Installed and going - I can write to files, retrieve flatfiles + Apache running servers outpages nop probes Trying to talk to SQL using PHP. -- html body h1Go to SQL now/h1 ? echo looking; @ $db = mysql_pconnect(localhost, user, password); if (!$db); { echo Error: Could not connect to database. Please try again later.; exit; } mysql_select_db(test); $query = select * from logbook ; $result = mysql_query($query); $num_results = mysql_num_rows($result); echo pNumber of books found: .$num_results./p; ? /body /html - What gets me if I can do all this from the mysql prompt:- laptopmysql -u user -p (enterpassword gets me in) mysqluse test; OK mysqlselect * from logbook; OK (shows entries no probs); - What am I doing wrong ? It doesnt get past the @ $db = mysql_pconnect(localhost, user, password); in the code. ?? Andrew --- Andrew Rich Callsign: VK4TEC [EMAIL PROTECTED] www.users.bigpond.com/andrew.rich/vk4tec.htm --- Andrew Rich Callsign: VK4TEC [EMAIL PROTECTED] www.users.bigpond.com/andrew.rich/vk4tec.htm - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php