Order of input into db
Hallo Is there a way to set the order in which data gets placed into the db? I have a form with ten rows (input fields) they are labeled name[1], name[2],name[3],name[4] I then use a for statement incrementing $i up to 10 i.e name[$1] this loop contains my query (INSERT INTO DB...) but if I check my database I see that for example row 3 is at the top, followed by 1 then 2 and then 4 - this makes no sense to me , should it not go from 1 - insert it - go to the next row 2 - insert it, and so on. This might be more a PHP thing but is there any way to order inputs into a DB from a list of records ? Anton - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 4.x Timeline
Is there a timeline/status for 4.x functionality available? I would like to use MySQL 4.x, however, I'm looking for some of the highly requested functionality (ie; subselects, SP's, triggers and Views) and would like to know where/when in the sequence of things todo does everything fall into place. This will help me plan my development effort as well since I don't need everything at once. I would like to second this request. I *really* want the replication failover functionality targeted for 4.x. In fact, if it isn't going to arrive by, say, midsummer, I will have to develop my own failover solutions. Which, obviously, I don't want to do - I have this aversion to reinventing wheels, and I have this nasty feeling that the MySQL teams wheels would be rounder than mine. So some indication of the timescales would be really useful. I certainly don't need exact dates, and I know all about the delays in development - but some indiciation would be really helpful and could save me a lot of work. Alec Cawley - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Source code documentation
HI I am new to this forum. Can anybody tell me where can I find documentation of mysql source code and the Architecure diagrams of mysql ? Thanks to all for getting me in :) -shrikant Shrikant Gundapwar -- A ship in harbour is safe,but that is not what ships are built for. -John A. Shedd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Order of input into db
Hi. On Fri, Feb 22, 2002 at 10:54:55AM +0200, [EMAIL PROTECTED] wrote: Hallo Is there a way to set the order in which data gets placed into the db? No. With SQL you specify the order not on insertion but on seletion time. I have a form with ten rows (input fields) they are labeled name[1], name[2],name[3],name[4] I then use a for statement incrementing $i up to 10 i.e name[$1] this loop contains my query (INSERT INTO DB...) but if I check my database I see that for example row 3 is at the top, followed by 1 then 2 and then 4 - this makes no sense to me , should it not go from 1 - insert it - go to the next row 2 - insert it, and so on. That's how the standard specifies it: The internal order of the DBMS is undefined (i.e. abitrary) and you may not rely on it. To get them in order, simply insert the value of $i or something similar into an extra column and specify it at retrieval time (with the ORDER BY clause). Bye, Benjamin. -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERD for MySQL?
Its not open source, but I think theKompany.com has a good one. Am Fre, 2002-02-22 um 04.55 schrieb Jeff Kilbride: Are there any open source ERD programs for MySQL for doing basic data modelling? I tried myERD at sourceforge and it couldn't parse the sql dump from my database. It died with a parse exception on the unsigned attribute for my int columns. Any other choices out there? Thanks, --jeff - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Setting net_buffer_length
Hi, we have 3.23.42 official binaries running on Linux 2.4.17. It seems mysqld does not read in from /etc/my.cnf the value for net_buffer_length. When having in the config file: [mysqld] set-variable= net_buffer_length=16M set-variable= max_allowed_packet=16M [...] I get | net_buffer_length | 1047552 | max_allowed_packet | 16776192 Another approach: [mysqld] set-variable= net_buffer_length=16776176 set-variable= max_allowed_packet=16776192 show variables reports: | max_allowed_packet | 16775168 | net_buffer_length | 1047552 It seems mysqld manipulates the numbers set in the config file and ignores somehow the net_buffer_length settings? I started to be curious, if we have to set the net_buffer_length before setting the max_allowed_packet, because of The maximum size of one packet. The message buffer is initialised to net_buffer_length bytes, but can grow up to at http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html But as you see, I already tried this but no luck. Also, the above page shows: | net_buffer_length| 16384 is that in kB ? Or was the number that low in 3.23.29a ? When trying to hope that I can first set the net_buffer_length huge and then set max_allowed_packet to it's maximum: [mysqld] set-variable= net_buffer_length=18M set-variable= max_allowed_packet=16M | net_buffer_length | 1047552 | max_allowed_packet | 16776192 So far, I'm not able to raise the net_buffer_length value in server at all. -- Regarding the client side, when I have in /etc/my.cnf or ~/.my.cnf: [client] port= 3306 socket = /tmp/mysql.sock set-variable= net_buffer_length=16M set-variable= max_allowed_packet=16M I get: $ mysqladmin variables | grep buffer No variable match for: -O 'net_buffer_length=16M' $ Any ideas what I'm doing wrong? Please Cc: me in replies. Thanks. -- Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs MIPS / Institute for Bioinformatics http://mips.gsf.de GSF - National Research Center for Environment and Health Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany tel.: +49-89-3187 3616 , fax:+49-89-3187 3585 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Source code documentation
Shrikant, Friday, February 22, 2002, 11:06:09 AM, you wrote: SG HI SG I am new to this forum. Can anybody tell me where can I find documentation of SG mysql source code and the Architecure diagrams of mysql ? You can find info about installation of MySQL at: http://www.mysql.com/doc/I/n/Installing_source.html All other questions concerning mysql source and architecture diagrams can be directly answered by the developers. SG Thanks to all for getting me in :) SG -shrikant -- 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
Problem with SCO and mysql_options() api
We have a SCO Unix Open Server Ver. 5.0.5 with MySQL 3.23.43 x SCO 3.2 V5 (Intel) installed and we want set a connect timeout using the following syntax: timeout = 10; /* sec */ mysql_init(mysql); mysql_options(mysql, MYSQL_OPT_CONNECT_TIMEOUT, (char*) timeout); if (!mysql_real_connect(mysql, host, user, password, database, 0, NULL, 0)) { printf(Failed to connect to database. Error: %s\n, mysql_error(mysql)); } Unfortunately it doesn't work!! (Failed to connect to database. Error: can't connect to MySQL server on '195.62.231.55') The same example works correctly in a Linux environment or under SCO without mysql_options instruction. Are there problems under SCO?? Could you help us? Thanks a lot. Regards, Federico - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 BDB table, error -30996
Hi, Has anyone got the following error on a BDB table : read_const: Got error -30996 when reading table We did some load testing on a particular BDB table and got this when we tried to run 20 concurrent queries on the table. The query in question works fine when the database instance is not loaded. Does anyone have a list of BDB error codes handy? I've searched the web and the mailing list archives and seems like no one ever responded to the same question about what this error means in previous postings :( Any help appreciated. Thanks! Cheers, Geoffrey __ Geoffrey Soh, Software Architect Ufinity - http://www.ufinity.com Leading Enterprise Access Management Software! 9 Scotts Road, Pacific Plaza, #06-01, Singapore 228210 Tel : +65 830-0341 Fax : +65 737-0213 __ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Paul DuBois Book
When the Next Edition of MySQL By Paul Dubois is coming? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Paul DuBois Book
It would be nice to see some thing for V4. PS Paul...its only because we liked the first one so much. -Original Message- From: D Bamud [mailto:[EMAIL PROTECTED]] Sent: 22 February 2002 10:47 To: [EMAIL PROTECTED] Subject: Paul DuBois Book When the Next Edition of MySQL By Paul Dubois is coming? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Got error 124 from table handler.
Hi list - Is there a list off MySQL error-codes avalible? Something like Oracle's oerr. program? We are having trouble with one of our MySQL databases. The error is: Got error 124 from table handler. We get this error randomly on some of our MyISAM tables. Optimize table seems to fix the problem temporary. MySQL: Server version 4.0.1-alpha OS: Splack Linux (Slackware port for sparc) running on a Sun Enterprise 4500. Best regards, -- Christian M. Stamgren Senior System Developer Cention Group AB Lästmakargatan 15 Box 7494 SE-103 92 Stockholm +46 (0)8 578 420 86 | direct +46 (0)8 578 420 99 | fax +46 (0)703 41 44 27 | mobile [EMAIL PROTECTED] www.centiongroup.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
Delete Query Question
Hope somebody can help me on this one At present I have two tables in my database. The data in question is built around credit card transactions. Tables Structure Headers Table ID (Primary Key used by the TRANSACTIONID field in the Transaction table) HEADERDETAILS blah, blah Transaction Table ID (Primary Key) TRANSACTIONID (Foreign Key into the Headers table) TRANSACTIONDETAILS blah,blah TRANSACTIONDATE I wish to delete all records from the headers table for a given date AND the associated records in the transaction table. After looking through the MySQL manual I discovered that deleting from multiple tables using a join is not supported. Has anybody any ideas I can use to remove the data ??? (and some REAL life queries cause I`m still just a beginner :)) p.s. If this is not clear please say so and I will elaborate :) This message contains information that may be privileged or confidential and is the property of the Cap Gemini Ernst Young Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message . - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Setting net_buffer_length
On Fri, Feb 22, 2002 at 10:52:14AM +0100, Martin MOKREJ? wrote: Hi, we have 3.23.42 official binaries running on Linux 2.4.17. It seems mysqld does not read in from /etc/my.cnf the value for net_buffer_length. When having in the config file: [mysqld] set-variable= net_buffer_length=16M set-variable= max_allowed_packet=16M [...] I get | net_buffer_length | 1047552 | max_allowed_packet | 16776192 I'm using 3.23.36 on Linux and posted a question yesterday about configuration parsing, in particular the way MySQL seems to parse (or not) the my.cnf file (I can't get it to recognise a 'log=' line in my.cnf, to log elsewhere). I tried doing the same as you ... Before ; net_buffer_length | 16384 Add to /etc/my.cnf (in [mysqld] section) ; set-variable = net_buffer_length=3M After (stop/start server) ; net_buffer_length | 1047552 So ... at least in my version here there some difference being made. I was expecting a figure of roughly 3Mb and not 1Mb though! Something's flaky with configuration. Cheers, -- Alastair | | [EMAIL PROTECTED]| | http://www.nucoda.com | | - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 4.x Timeline
Hi Alec, On Fri, 2002-02-22 at 18:59, [EMAIL PROTECTED] wrote: Is there a timeline/status for 4.x functionality available? I would like to use MySQL 4.x, however, I'm looking for some of the highly requested functionality (ie; subselects, SP's, triggers and Views) and would like to know where/when in the sequence of things todo does everything fall into place. This will help me plan my development effort as well since I don't need everything at once. There certainly is a general timeline... have a look at various points in the online manual (http://www.mysql.com/doc/) to see what the priorities are and will be. As for exact dates: it will be ready when it's ready. Some may not like that response, but it's honest. As you know, with MySQL we prefer to do a solid implementation rather than a quick hack. I would like to second this request. I *really* want the replication failover functionality targeted for 4.x. In fact, if it isn't going to arrive by, say, midsummer, I will have to develop my own failover solutions. Which, obviously, I don't want to do - I have this aversion to reinventing wheels, and I have this nasty feeling that the MySQL teams wheels would be rounder than mine. So some indication of the timescales would be really useful. I certainly don't need exact dates, and I know all about the delays in development - but some indiciation would be really helpful and could save me a lot of work. If you have a commercial interest in speeding up a particular part of our planned development, this is certainly something that can be talked about. As you may know, the original replication was done as a 'sponsored' project. One company needed it, and provided the funds to allow us to allocate manpower for doing it. Now, it benefits many more! MySQL's development path is not for sale, but like any company we have to accept certains limit in our human and financial resources. Sponsoring a particular part can in cases such as these allow for faster development, provided of course that technical prerequisites are met; naturally the rule about solid implementations still applies. To get you (and others) thinking along an interesting track sponsoring need not be limited to a single company making a large targeted contribution. It could very well be multiple small(er) companies that have a similar need. The question is simply how fast you need a certain feature, and what it will save you to have it that fast, and/or gain you by having it help your business. That knowledge would allow you to invest (part of) those savings into making sure that it does happen. Regards, Arjen. -- MySQL Training in Brisbane: 18-22 March, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia ___/ 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
Question about SQL...
Hi all, i'm a newbie on this Mailing-list and i'm French. So, sorry for my POOR english... I try to execute an SQL Command but i have a syntax error : SELECT Id_Game FROM game WHERE Id_Game NOT IN ( SELECT Id_Game FROM member_game a WHERE Id_Member = 4 ) I don't know waht happend.. Help me.. Thks a lot.. BABIK Guillaume Développeur Web [ http://www.absolut.fr/ ]ABSOLUT Reality - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Delete Query Question
Edwards, Friday, February 22, 2002, 12:58:23 PM, you wrote: Eeoen Hope somebody can help me on this one Eeoen At present I have two tables in my database. The data in question is built Eeoen around credit card transactions. Eeoen Tables Structure Eeoen Headers Table Eeoen ID (Primary Key used by the TRANSACTIONID field in the Transaction table) Eeoen HEADERDETAILS blah, blah Eeoen Transaction Table Eeoen ID (Primary Key) Eeoen TRANSACTIONID (Foreign Key into the Headers table) Eeoen TRANSACTIONDETAILS blah,blah Eeoen TRANSACTIONDATE Eeoen I wish to delete all records from the headers table for a given date AND the Eeoen associated records in the transaction table. After looking through the Eeoen MySQL manual I discovered that deleting from multiple tables using a join is Eeoen not supported. Has anybody any ideas I can use to remove the data ??? Eeoen (and some REAL life queries cause I`m still just a beginner :)) Eeoen p.s. If this is not clear please say so and I will elaborate :) Try to use CONCAT() function in SELECT statement. Look comments in the manual at: http://www.mysql.com/doc/D/E/DELETE.html -- 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
Tuning production MySQL server
Hiya forum.. I have my site powered by MySQL server running on FreeBSD. The site is facing problems when the traffic increases.Database connectivity is through JDBC.My poolman is managing the database connections with 30 connections set, and is growable.People have started getting error when the rush increases... Error : Communication failure : Bad Handshake. Is there a MySQL server running on the port connectivity error. I suspect the max_connection variable which is default set to 100 reaches and the server refuses further connection.We have probed for any unused database connections hold by the Java.But we have religiously returned the connection back to the poolmanager after its used... I am running my development MySQL server on windows NT. Having gone thru the MySQL manual..for performance tuning the server,we came across many variables which can affect the server performance. So i issue the following commands: c:\ cd mysql\bin start the serverc:\mysqld set the variablec:\mysqld -O back_log=200 --help Looks like it updates the server..but when i see it thru the WinMySQLAdmin ,after restarting the server again ,it does not reflect there and displays the default settings. We have a production server runningCan any experienced people guide me how to update this server variable onto my remote server. Thanx. Vijay Khanna System Analyst www.spsoftware.com Ph: 09120 - 4006154 INDIA _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Question about SQL...
Hi Subselects doesn't work at time. Am Fre, 2002-02-22 um 12.47 schrieb Guillaume BABIK: Hi all, i'm a newbie on this Mailing-list and i'm French. So, sorry for my POOR english... I try to execute an SQL Command but i have a syntax error : SELECT Id_Game FROM game WHERE Id_Game NOT IN ( SELECT Id_Game FROM member_game a WHERE Id_Member = 4 ) I don't know waht happend.. Help me.. Thks a lot.. BABIK Guillaume Développeur Web [ http://www.absolut.fr/ ]ABSOLUT Reality - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with MySQL, ODBC, MS Access
Hello. I have a problem with auto_increment and primary key. I use MySQL 3.23.41-17 as backend and Access 2000 as frontend which is connected with MyODBC 2.50.39. I have created several tables like this: create table tPruefBesch (fTimestamp timestamp(14), fPruefbeschNr int auto_increment not null, fPlanNr int, primary key (fPruefbeschNr)); Here is my problem. If I insert some records in this tables the auto_increment will run, but when I delete some records something strange happens. After deletion of eg. 30 records I tried to append some new records then the auto_increment has shown 30 times the same number and then was going on counting correctly. After closing and reopening the table, the auto_increment numbers are written correctly counted. I hope someone can help me - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 about SQL...
Hi, I guess what you're trying to do is a kind of Sub-selectnot yet supported by MySQL (see http://www.mysql.org/products for exact version : I guess it is supposed to be done in 4.1, but not sure!) However, for example, you can rewrite this query : SELECT * FROM table1 WHERE id IN (SELECT id FROM table2); by writing this : SELECT table1.* FROM table1,table2 WHERE table1.id=table2.id; Hope it helps.. Cheers. Xavier Xavier Prélat CTO Webcenbtric 25 rue de Ponthieu 75008 PARIS -Message d'origine- De : Guillaume BABIK [mailto:[EMAIL PROTECTED]] Envoyé : vendredi 22 février 2002 12:47 À : [EMAIL PROTECTED] Objet : Question about SQL... Hi all, i'm a newbie on this Mailing-list and i'm French. So, sorry for my POOR english... I try to execute an SQL Command but i have a syntax error : SELECT Id_Game FROM game WHERE Id_Game NOT IN ( SELECT Id_Game FROM member_game a WHERE Id_Member = 4 ) I don't know waht happend.. Help me.. Thks a lot.. BABIK Guillaume Développeur Web [ http://www.absolut.fr/ ]ABSOLUT Reality - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Question about SQL...
Guillaume, Friday, February 22, 2002, 1:47:09 PM, you wrote: GB Hi all, GB i'm a newbie on this Mailing-list and i'm French. GB So, sorry for my POOR english... GB I try to execute an SQL Command but i have a syntax error : GB SELECT Id_Game GB FROM game GB WHERE Id_Game NOT IN ( GB SELECT Id_Game GB FROM member_game a GB WHERE Id_Member = 4 ) GB I don't know waht happend.. MySQL doesn't support subselects, check the following link: http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html You can also try to use temporary tables. See at: http://www.mysql.com/doc/C/R/CREATE_TABLE.html It is in our plans to support sub-selects in future: http://www.mysql.com/doc/T/O/TODO_MySQL_4.1.html GB Help me.. GB Thks a lot.. -- 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: MySQL 4.x Timeline
On Friday 22 February 2002 02:15 am, Jeremy Zawodny wrote: On Thu, Feb 21, 2002 at 08:07:39PM -0500, Anthony W. Marino wrote: Is there a timeline/status for 4.x functionality available? No. It'll be ready when it's ready. :-) There are folks using 4.0.x in production and/or testing now. This helps test the code and get folks comfortable enough with it to go from alpha to beta to gamma to stable. Well, any idea on a date for beta? I would like to use MySQL 4.x, however, I'm looking for some of the highly requested functionality (ie; subselects, SP's, triggers and Views) and would like to know where/when in the sequence of things todo does everything fall into place. This will help me plan my development effort as well since I don't need everything at once. I've heard that there's now a developer working on sub-selects. But I've not heard the same triggers and stored procedures. That doesn't mean a whole lot, since I have no claim to know what's going on at MySQL central... Jeremy Any advantages, featurewise, to using MySQL 3.x at this point? Thanks, Anthony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Paul DuBois Book
On Friday 22 February 2002 05:48 am, Simon Green wrote: It would be nice to see some thing for V4. PS Paul...its only because we liked the first one so much. -Original Message- From: D Bamud [mailto:[EMAIL PROTECTED]] Sent: 22 February 2002 10:47 To: [EMAIL PROTECTED] Subject: Paul DuBois Book When the Next Edition of MySQL By Paul Dubois is coming? +1 with my vote. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
multiple character sets in one database
Hello I would like to know how to use different languages in different tables (one language/character set per table). The idea being users can view web page data in their own language. Some of this content will need to be sortable. For example: - english - french - russian - japanese I am new to MySQL and am using a pre-packed MySQL 3.23.46 install on Solaris. So I do not now how (or if I can) to do recompiles if that is necessary. Could some please give me advice if this is possible? And if so how? Many Thanks. Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 4.x Timeline
On Friday 22 February 2002 06:26 am, Arjen Lentz wrote: Hi Alec, On Fri, 2002-02-22 at 18:59, [EMAIL PROTECTED] wrote: Is there a timeline/status for 4.x functionality available? I would like to use MySQL 4.x, however, I'm looking for some of the highly requested functionality (ie; subselects, SP's, triggers and Views) and would like to know where/when in the sequence of things todo does everything fall into place. This will help me plan my development effort as well since I don't need everything at once. There certainly is a general timeline... have a look at various points in the online manual (http://www.mysql.com/doc/) to see what the priorities are and will be. As for exact dates: it will be ready when it's ready. Some may not like that response, but it's honest. As you know, with MySQL we prefer to do a solid implementation rather than a quick hack. This is the excerpt I found from the docs and Im having difficulty trying to figure out what within a couple of months is relative to. I was wondering if there is some clearer date with regards to the upcoming beta: The rollout of MySQL Server 4.0 will come in several steps, with the first version labelled 4.0.0 already containing most of the new features. Additional features will be incorporated into MySQL 4.0.1, 4.0.2 onwards; very probably within a couple of months, MySQL 4.0 will be labelled beta. Further new features will then be added in MySQL 4.1, which is targeted for alpha release in early 2002. I would like to second this request. I *really* want the replication failover functionality targeted for 4.x. In fact, if it isn't going to arrive by, say, midsummer, I will have to develop my own failover solutions. Which, obviously, I don't want to do - I have this aversion to reinventing wheels, and I have this nasty feeling that the MySQL teams wheels would be rounder than mine. So some indication of the timescales would be really useful. I certainly don't need exact dates, and I know all about the delays in development - but some indiciation would be really helpful and could save me a lot of work. If you have a commercial interest in speeding up a particular part of our planned development, this is certainly something that can be talked about. As you may know, the original replication was done as a 'sponsored' project. One company needed it, and provided the funds to allow us to allocate manpower for doing it. Now, it benefits many more! MySQL's development path is not for sale, but like any company we have to accept certains limit in our human and financial resources. Sponsoring a particular part can in cases such as these allow for faster development, provided of course that technical prerequisites are met; naturally the rule about solid implementations still applies. To get you (and others) thinking along an interesting track sponsoring need not be limited to a single company making a large targeted contribution. It could very well be multiple small(er) companies that have a similar need. The question is simply how fast you need a certain feature, and what it will save you to have it that fast, and/or gain you by having it help your business. That knowledge would allow you to invest (part of) those savings into making sure that it does happen. Regards, Arjen. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Transaction Enhanced Formats
Can anyone point me to a comparison of +'s and -'s with each Transaction enhanced formats (ie; InnoDb, SleepyCat and others) for MySQL. Thanks, Anthony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Paul DuBois Book
My vote is have the 'mySQL Cookbook' get out the door first, give Paul a quick respite, and then put his nose to the grind stone for 'mySQL version 4'. 8-) -Original Message- From: Anthony W. Marino [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 7:30 AM To: Simon Green; [EMAIL PROTECTED] Subject: Re: Paul DuBois Book On Friday 22 February 2002 05:48 am, Simon Green wrote: It would be nice to see some thing for V4. PS Paul...its only because we liked the first one so much. -Original Message- From: D Bamud [mailto:[EMAIL PROTECTED]] Sent: 22 February 2002 10:47 To: [EMAIL PROTECTED] Subject: Paul DuBois Book When the Next Edition of MySQL By Paul Dubois is coming? +1 with my vote. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
MysqlReplication
query Is it possible to set one SLAVE to handle two or multiple MASTERS??? For example if I want to replicate one table from one MASTER and second table from another. Thanx a lot - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 error
Hi, I've got this problem when i try to connect to a mysql server with a PHP code Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) hope you can help me regards theotherone - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MysqlReplication
It can be done. The slave server needs to hold mutiple slave databases corresponding to the masters. Each slave instance needs to be start separately. For example, each database wil need it's own my.cnf file holding with port the master is connecting to. I have seen this done with full databases, I am not to sure about selecting tables from MAsters to replicate hope that helps. -chad On Fri, 22 Feb 2002 15:20:52 +0100 [EMAIL PROTECTED] wrote: query Is it possible to set one SLAVE to handle two or multiple MASTERS??? For example if I want to replicate one table from one MASTER and second table from another. Thanx a lot - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
multiple character sets in one database
Chris, Friday, February 22, 2002, 3:51:39 PM, you wrote: CG Hello CG I would like to know how to use different languages in different tables (one CG language/character set per table). The idea being users can view web page CG data in their own language. Some of this content will need to be sortable. CG For example: CG - english CG - french CG - russian CG - japanese CG I am new to MySQL and am using a pre-packed MySQL 3.23.46 install on CG Solaris. So I do not now how (or if I can) to do recompiles if that is CG necessary. CG Could some please give me advice if this is possible? And if so how? MySQL doesn't support it now, but it is in plans to do full support to the table and query level. You can only use one character set at a time for one instance of mysqld. You need to restart, or start another instance of mysqld if you want to use two character sets. For manading multiple MySQL server look at: http://www.mysql.com/doc/m/y/mysqld_multi.html When a character set is changed, any tables involved should be reindexed with myisamchk -q -r, like you said you've done. CG Many Thanks. CG Chris -- 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: Finding overlapping intervals efficiently
On Friday 22 February 2002 00:03, Colin Dewey wrote: This is an example of a class of problem that crops up in a lot of applications, like GIS systems all the time. Unfortunately B-Tree type indexes, like RDBMS systems generally use are just not well adapted to this type of query. I know Informix had a Data Blade for Universal Server that provided some indexing strategies for this type of thing, but that is a pretty expensive solution... There are several ways to build indexes for this sort of stuff, but in MySQL you would essentially have to design a new table handler. Given MySQL's flexibility in that respect it is conceivable that someone will provide products like that in the future. For now I think you have the best solution you can get. The next best in theory I guess would be a table that was a cross join on t1 and t2 holding every possible t1.start - t2.end and t1.end - t2.start value. I suspect it would be HUGE! You might however construct such a table and then reduce it to only a few records of interest, but if your record set is being updated often that won't do you a lot of good either. Another possibility would be to try to use other criteria to reduce the work the slow query needs to do. Maybe there are entire sets of t1's such that they cannot possibly overlap a t2 (for instance any t1 who's start is greater than max(t2.end)). Those need not be considered at all. Depending on your data, that may eliminate a lot of work. Given two tables (t1 and t2) with fields start and end, what is the most efficient method of finding the all the intervals in the first table that overlap any interval in the second table? Right now, I use a query like: SELECT t1.name, t2.name FROM t1, t2 WHERE t1.start = t2.end AND t1.end = t2.start; I use a key (start, end) in each table. Is there anything else that I can do to optimize this type of query (i.e. add keys, change the select statement)? The tables typically have thousands of records, so optimizing this query is very important. Thanks in advance for any help you can give me, Colin _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 error
theOtherOne, Saturday, February 23, 2002, 1:52:20 AM, you wrote: t Hi, t I've got this problem when i try to connect to a mysql server with a PHP t code t Warning: MySQL Connection Failed: Can't connect to local MySQL server t through socket '/tmp/mysql.sock' (111) It means that you are using wrong socket file or TCP/IP port, or MySQL server is not running. Look at: http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html t regards t theotherone -- 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
mysql: how to copy table with varchar datatype?
Hi, Does anybody know how to copy an existing mySQL table schema with varchar datatype my sql statement is: CREATE TABLE new_table AS SELECT * FROM old_table where 1=0; All the text columns in the old_table are in VARCHAR datatype, however, after I copy to a new_table, all columns change to CHAR format. Please help! Thanks, Wai - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: multiple character sets in one database
Thank you for your very detailed reply. This was my understanding of it too. I guess I was hoping that I had missed something! Do you know when will this happen? (I hate to ask but since I know I will be asked this, I feel I should ask you. My crystal ball is broken!) Is it going to be in 4.x? Or is there another timeframe? Thanks again. Chris -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 10:16 AM To: [EMAIL PROTECTED] Subject: multiple character sets in one database Chris, Friday, February 22, 2002, 3:51:39 PM, you wrote: CG Hello CG I would like to know how to use different languages in different tables (one CG language/character set per table). The idea being users can view web page CG data in their own language. Some of this content will need to be sortable. CG For example: CG - english CG - french CG - russian CG - japanese CG I am new to MySQL and am using a pre-packed MySQL 3.23.46 install on CG Solaris. So I do not now how (or if I can) to do recompiles if that is CG necessary. CG Could some please give me advice if this is possible? And if so how? MySQL doesn't support it now, but it is in plans to do full support to the table and query level. You can only use one character set at a time for one instance of mysqld. You need to restart, or start another instance of mysqld if you want to use two character sets. For manading multiple MySQL server look at: http://www.mysql.com/doc/m/y/mysqld_multi.html When a character set is changed, any tables involved should be reindexed with myisamchk -q -r, like you said you've done. CG Many Thanks. CG Chris -- 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 error
On Sat, 2002-02-23 at 01:52, theOtherOne wrote: Hi, I've got this problem when i try to connect to a mysql server with a PHP code Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) [mle@hal9000 data]$ perror 111 Error code 111: Connection refused That would indicate that you haven't got a mysql-server running. If it is running, check that /tmp/ actually is where the socket-file is, and check your my.cnf-file in case the [mysqld] section contains skip-networking. If it does, remove it (naturally). Cheers, Markus -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PROTECTED] +358-6-325 3589 / +358-40-832 6709 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Book
At 04:38 PM 2/21/2002 , you wrote: At 22:15 + 2/21/02, DL Neil wrote: MySQL by Paul DuBoise Paul monitors this mailing list, so if you have questions concerning what you've read, he may answer. You added an e to my name deliberately just to see if I'd reply, didn't you! :-) Not really, but because he thinks you are Paul of Idaho! =dn I ain't ne'er been to Idaho even once! I guess Paul doesn't like potatoes. lol Brent - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Next and Preview Row
* Mark Lo Row 10ID00010need this value Row 11ID00025have this value on hand Row 12ID00063need this value The questions is how do I find out the values in Row 10 and Row 12, if and only if I only have one data that is ID00025 (select * from table where field=ID00025) . But, the questions is How do I find out the data in Row 10 and Row 12 which is ID00010 and ID00063 assume I don't know the values of ID00025 is in Row 11. previous: select * from table where field ID00025 order by id desc limit 1 next: select * from table where field ID00025 order by id limit 1 It is even possible to do this with one select statement and four left joins to the same table, but it is a bit complicated: select table.*,next.id as next,prev.id as prev from table left join table as prev on prev.id table.id left join table as prev2 on prev2.id prev.id left join table as next on next.id table.id left join table as next2 on next2.id next.id where table1.id=ID00025 and not isnull(prev2.id) and not isnull(next2.id) -- 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 error
thx - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 22, 2002 7:30 AM Subject: mysql error theOtherOne, Saturday, February 23, 2002, 1:52:20 AM, you wrote: t Hi, t I've got this problem when i try to connect to a mysql server with a PHP t code t Warning: MySQL Connection Failed: Can't connect to local MySQL server t through socket '/tmp/mysql.sock' (111) It means that you are using wrong socket file or TCP/IP port, or MySQL server is not running. Look at: http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html t regards t theotherone -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL replication error
Chad, this did not work. Though it did do something, the Position jumped ahead mysql show slave status\G *** 1. row *** Master_Host: 209.217.92.34 Master_User: repslave2 Master_Port: 3306 Connect_retry: 60 Log_File: QBSLXDB1-bin.029 Pos: 2596608 Slave_Running: No Replicate_do_db: qbslive Replicate_ignore_db: Last_errno: 1062 Last_error: error 'Duplicate entry '1376034' for key 1' on query 'INSERT INTO DISPATCHLOG (CreateStamp) VALUES (NOW())' Skip_counter: 1 1 row in set (0.00 sec) mysql set sql_slave_skip_counter = 1; Query OK, 0 rows affected (0.01 sec) mysql slave start; Query OK, 0 rows affected (0.00 sec) mysql show slave status\G *** 1. row *** Master_Host: 209.217.92.34 Master_User: repslave2 Master_Port: 3306 Connect_retry: 60 Log_File: QBSLXDB1-bin.029 Pos: 2596630 Slave_Running: No Replicate_do_db: qbslive Replicate_ignore_db: Last_errno: 1062 Last_error: error 'Duplicate entry '1376034' for key 1' on query 'INSERT INTO DISPATCHLOG (CreateStamp) VALUES (NOW())' Skip_counter: 0 1 row in set (0.00 sec) -Original Message- From: chad kellerman [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 5:18 PM To: Luc Foisy Cc: [EMAIL PROTECTED] Subject: Re: MySQL replication error Luc, I new to this mailinglist ( this is my first posting) But I have worked a little with replication. Try if the replicator is still down. set sql_slave_skip_counter = 1; slave start on the slave as long as you are sure the master is ok. Let me know is this worked. -chad On Thu, 21 Feb 2002 15:48:08 -0500 Luc Foisy [EMAIL PROTECTED] wrote: Would anyone be able to tell me why this happened, and how I could fix it? mysql show slave status\G *** 1. row *** Master_Host: 209.217.92.34 Master_User: repslave2 Master_Port: 3306 Connect_retry: 60 Log_File: QBSLXDB1-bin.029 Pos: 2596608 Slave_Running: No Replicate_do_db: qbslive Replicate_ignore_db: Last_errno: 1062 Last_error: error 'Duplicate entry '1376034' for key 1' on query 'INSERT INTO DISPATCHLOG (CreateStamp) VALUES (NOW())' Skip_counter: 0 err_log 020221 14:21:12 mysqld started /usr/local/libexec/mysqld: ready for connections 020221 14:21:14 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'QBSLXDB1-bin.029' at position 2596608 ERROR: 1062 Duplicate entry '1376034' for key 1 020221 14:21:14 Slave: error running query 'INSERT INTO DISPATCHLOG (CreateStamp) VALUES (NOW())' 020221 14:21:14 Error running query, slave aborted. Fix the problem, and re-start the slave thread with mysqladmin start-slave. We s topped at log 'QBSLXDB1-bin.029' position 2596608 020221 14:21:14 Slave thread exiting, replication stopped in log 'QBSLXDB1-bin.029' at position 2596608 Luc Foisy Technical Magic - www.technical-magic.com 1 Stafford Road, Suite 325, Nepean, Ontario, K2H 1B9 Phone: (613) 829-7117 Fax: (613) 596-5096 E-Mail: [EMAIL PROTECTED] Fulfilling the Promise of Technology - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
3.22.32: max table size
As show table status doesn't appear to be supported in this older version I'm using, how did you who used this version get max table size information? I haven't been to find anything from the list archives/manual about this. Brian sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MAX Key Limit
So it appears there is a maximum of 32 keys (indexes) that can be created on a table. Is there any way to increase this? If so how? -Tim sql,query?? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL replication error
Luc, The problem is that in the replication somewhere an update was taken twice. Adjust the skip to according to the position of the duplicate entry. I have had to skip 100 before in order to get the slave started. First check the binary log and see how many insert statements after the error path to mysql/bin/mysqlbinlog QBSLIXDB1-bin.log. There had to be a reason why the rep stop syncing ( did you run a myisam check on the master and it removed something??). Check the log to see what transaction failed or duplicated itself. Normally you can skip that transaction on the slave and start up the slave. But if therea are other transaction out of sync after the first failed transaction you will have to keep skipping the transactions. Until the slave kicks up. It kinda hard to tell with out seeing the binary log file as to how many you have to skip or even which one to skip. But as soon as you hit the duplicate transaction witht he skip, the slave will start. Let me know the scoop... -chad On Fri, 22 Feb 2002 11:29:41 -0500 Luc Foisy [EMAIL PROTECTED] wrote: Chad, this did not work. Though it did do something, the Position jumped ahead mysql show slave status\G *** 1. row *** Master_Host: 209.217.92.34 Master_User: repslave2 Master_Port: 3306 Connect_retry: 60 Log_File: QBSLXDB1-bin.029 Pos: 2596608 Slave_Running: No Replicate_do_db: qbslive Replicate_ignore_db: Last_errno: 1062 Last_error: error 'Duplicate entry '1376034' for key 1' on query 'INSERT INTO DISPATCHLOG (CreateStamp) VALUES (NOW())' Skip_counter: 1 1 row in set (0.00 sec) mysql set sql_slave_skip_counter = 1; Query OK, 0 rows affected (0.01 sec) mysql slave start; Query OK, 0 rows affected (0.00 sec) mysql show slave status\G *** 1. row *** Master_Host: 209.217.92.34 Master_User: repslave2 Master_Port: 3306 Connect_retry: 60 Log_File: QBSLXDB1-bin.029 Pos: 2596630 Slave_Running: No Replicate_do_db: qbslive Replicate_ignore_db: Last_errno: 1062 Last_error: error 'Duplicate entry '1376034' for key 1' on query 'INSERT INTO DISPATCHLOG (CreateStamp) VALUES (NOW())' Skip_counter: 0 1 row in set (0.00 sec) -Original Message- From: chad kellerman [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 5:18 PM To: Luc Foisy Cc: [EMAIL PROTECTED] Subject: Re: MySQL replication error Luc, I new to this mailinglist ( this is my first posting) But I have worked a little with replication. Try if the replicator is still down. set sql_slave_skip_counter = 1; slave start on the slave as long as you are sure the master is ok. Let me know is this worked. -chad On Thu, 21 Feb 2002 15:48:08 -0500 Luc Foisy [EMAIL PROTECTED] wrote: Would anyone be able to tell me why this happened, and how I could fix it? mysql show slave status\G *** 1. row *** Master_Host: 209.217.92.34 Master_User: repslave2 Master_Port: 3306 Connect_retry: 60 Log_File: QBSLXDB1-bin.029 Pos: 2596608 Slave_Running: No Replicate_do_db: qbslive Replicate_ignore_db: Last_errno: 1062 Last_error: error 'Duplicate entry '1376034' for key 1' on query 'INSERT INTO DISPATCHLOG (CreateStamp) VALUES (NOW())' Skip_counter: 0 err_log 020221 14:21:12 mysqld started /usr/local/libexec/mysqld: ready for connections 020221 14:21:14 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'QBSLXDB1-bin.029' at position 2596608 ERROR: 1062 Duplicate entry '1376034' for key 1 020221 14:21:14 Slave: error running query 'INSERT INTO DISPATCHLOG (CreateStamp) VALUES (NOW())' 020221 14:21:14 Error running query, slave aborted. Fix the problem, and re-start the slave thread with mysqladmin start-slave. We s topped at log 'QBSLXDB1-bin.029' position 2596608 020221 14:21:14 Slave thread exiting, replication stopped in log 'QBSLXDB1-bin.029' at position 2596608 Luc Foisy Technical Magic - www.technical-magic.com 1 Stafford Road, Suite 325, Nepean, Ontario, K2H 1B9 Phone: (613) 829-7117 Fax: (613) 596-5096 E-Mail: [EMAIL PROTECTED] Fulfilling the Promise of Technology - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try:
RE: 3.22.32: max table size
Quoted from http://www.mysql.com/doc/T/a/Table_size.html is: By default, MySQL tables have a maximum size of about 4G. You can check the maximum table size for a table with the SHOW TABLE STATUS command or with the myisamchk -dv table_name. See section 4.5.6 SHOW Syntax. Gurhan -Original Message- From: Brian Warn [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 11:28 AM To: 'MySQL List' Subject: 3.22.32: max table size As show table status doesn't appear to be supported in this older version I'm using, how did you who used this version get max table size information? I haven't been to find anything from the list archives/manual about this. Brian sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 upgrade problem
Hello all. I'm using Debian 2.4.x I was trying to upgrade mysql.3.22 to 23 by removing default packages and after debianizeing rpm's with alien I installed them with dpkg. After I did upgrade (as I assume ;-))) somewhere my.cnf file disappeared Do someone know how to properly upgrade 22 to 23 ? (http://www.mysql.com/doc/U/p/Upgrade.html - there is no information enough) Marek Wysmulek - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.22.32: max table size
I did see that reference, but found that myisamchk wasn't an option either. I did find isamchk is available and have been seeing what information it is able to provide. I'm wondering now whether summing the table.ISD, table.ISM, and table.frm filesizes that I get from a simple ls -l output will give me the total diskspace occupied by the table? Brian sql,query -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 8:58 AM To: Brian Warn; 'MySQL List' Subject: RE: 3.22.32: max table size Quoted from http://www.mysql.com/doc/T/a/Table_size.html is: By default, MySQL tables have a maximum size of about 4G. You can check the maximum table size for a table with the SHOW TABLE STATUS command or with the myisamchk -dv table_name. See section 4.5.6 SHOW Syntax. Gurhan -Original Message- From: Brian Warn [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 11:28 AM To: 'MySQL List' Subject: 3.22.32: max table size As show table status doesn't appear to be supported in this older version I'm using, how did you who used this version get max table size information? I haven't been to find anything from the list archives/manual about this. Brian sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MAX Key Limit
On Fri, Feb 22, 2002 at 08:46:37AM -0800, Tim Allwine wrote: So it appears there is a maximum of 32 keys (indexes) that can be created on a table. Is there any way to increase this? If so how? I seem to remember it being a simple soure code change. Check the mail archives (if you haven't already). I know it's come up here before. 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 15 days, processed 482,574,717 queries (369/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: MySQL replication error
That's pretty strange in this situation, we have three slaves being updated from the master, the other two are moving along just fine. This one however can't seem to get past these duplicate entries. I tried skip_counter=2 and got a different duplicate entry, the possition moving forward again. Incresed skip_counter again... Now the slave is running, but not going anywhere, slave position is like 2.5 million where the master is at about 17 million. Bah, I think i'll just start this slave over again from the base, unfortunately there is a great deal of catching up to do So in skipping these transactions, am I losing data? -Original Message- From: chad kellerman [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 11:57 AM To: Luc Foisy Cc: [EMAIL PROTECTED] Subject: Re: MySQL replication error Luc, The problem is that in the replication somewhere an update was taken twice. Adjust the skip to according to the position of the duplicate entry. I have had to skip 100 before in order to get the slave started. First check the binary log and see how many insert statements after the error path to mysql/bin/mysqlbinlog QBSLIXDB1-bin.log. There had to be a reason why the rep stop syncing ( did you run a myisam check on the master and it removed something??). Check the log to see what transaction failed or duplicated itself. Normally you can skip that transaction on the slave and start up the slave. But if therea are other transaction out of sync after the first failed transaction you will have to keep skipping the transactions. Until the slave kicks up. It kinda hard to tell with out seeing the binary log file as to how many you have to skip or even which one to skip. But as soon as you hit the duplicate transaction witht he skip, the slave will start. Let me know the scoop... -chad On Fri, 22 Feb 2002 11:29:41 -0500 Luc Foisy [EMAIL PROTECTED] wrote: Chad, this did not work. Though it did do something, the Position jumped ahead mysql show slave status\G *** 1. row *** Master_Host: 209.217.92.34 Master_User: repslave2 Master_Port: 3306 Connect_retry: 60 Log_File: QBSLXDB1-bin.029 Pos: 2596608 Slave_Running: No Replicate_do_db: qbslive Replicate_ignore_db: Last_errno: 1062 Last_error: error 'Duplicate entry '1376034' for key 1' on query 'INSERT INTO DISPATCHLOG (CreateStamp) VALUES (NOW())' Skip_counter: 1 1 row in set (0.00 sec) mysql set sql_slave_skip_counter = 1; Query OK, 0 rows affected (0.01 sec) mysql slave start; Query OK, 0 rows affected (0.00 sec) mysql show slave status\G *** 1. row *** Master_Host: 209.217.92.34 Master_User: repslave2 Master_Port: 3306 Connect_retry: 60 Log_File: QBSLXDB1-bin.029 Pos: 2596630 Slave_Running: No Replicate_do_db: qbslive Replicate_ignore_db: Last_errno: 1062 Last_error: error 'Duplicate entry '1376034' for key 1' on query 'INSERT INTO DISPATCHLOG (CreateStamp) VALUES (NOW())' Skip_counter: 0 1 row in set (0.00 sec) -Original Message- From: chad kellerman [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 5:18 PM To: Luc Foisy Cc: [EMAIL PROTECTED] Subject: Re: MySQL replication error Luc, I new to this mailinglist ( this is my first posting) But I have worked a little with replication. Try if the replicator is still down. set sql_slave_skip_counter = 1; slave start on the slave as long as you are sure the master is ok. Let me know is this worked. -chad On Thu, 21 Feb 2002 15:48:08 -0500 Luc Foisy [EMAIL PROTECTED] wrote: Would anyone be able to tell me why this happened, and how I could fix it? mysql show slave status\G *** 1. row *** Master_Host: 209.217.92.34 Master_User: repslave2 Master_Port: 3306 Connect_retry: 60 Log_File: QBSLXDB1-bin.029 Pos: 2596608 Slave_Running: No Replicate_do_db: qbslive Replicate_ignore_db: Last_errno: 1062 Last_error: error 'Duplicate entry '1376034' for key 1' on query 'INSERT INTO DISPATCHLOG (CreateStamp) VALUES (NOW())' Skip_counter: 0 err_log 020221 14:21:12 mysqld started /usr/local/libexec/mysqld: ready for connections 020221 14:21:14 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'QBSLXDB1-bin.029' at position 2596608 ERROR: 1062 Duplicate entry '1376034' for key 1 020221 14:21:14 Slave: error running query 'INSERT INTO DISPATCHLOG (CreateStamp) VALUES (NOW())' 020221 14:21:14 Error running query, slave aborted. Fix the problem, and re-start the slave
RE: 3.22.32: max table size
You, like me, are using 3.22 which does not have the myisam table type (or others for that matter). ISAM I believe, has a lower limit. They do support sizes less that 4GB (up to the OS file size limits). The three file extentions total do constitute the total table size, but I believe that each file must fall under the 4GB limit, not the total. isamchk is the equivalent to myisamchk for ISAM table types. On Fri, 22 Feb 2002, Brian Warn wrote: Date: Fri, 22 Feb 2002 09:11:07 -0800 From: Brian Warn [EMAIL PROTECTED] To: 'Gurhan Ozen' [EMAIL PROTECTED], 'MySQL List' [EMAIL PROTECTED] Subject: RE: 3.22.32: max table size I did see that reference, but found that myisamchk wasn't an option either. I did find isamchk is available and have been seeing what information it is able to provide. I'm wondering now whether summing the table.ISD, table.ISM, and table.frm filesizes that I get from a simple ls -l output will give me the total diskspace occupied by the table? Brian sql,query -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 8:58 AM To: Brian Warn; 'MySQL List' Subject: RE: 3.22.32: max table size Quoted from http://www.mysql.com/doc/T/a/Table_size.html is: By default, MySQL tables have a maximum size of about 4G. You can check the maximum table size for a table with the SHOW TABLE STATUS command or with the myisamchk -dv table_name. See section 4.5.6 SHOW Syntax. Gurhan -Original Message- From: Brian Warn [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 11:28 AM To: 'MySQL List' Subject: 3.22.32: max table size As show table status doesn't appear to be supported in this older version I'm using, how did you who used this version get max table size information? I haven't been to find anything from the list archives/manual about this. Brian sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.22.32: max table size
Fromt the mysql.com site: http://www.mysql.com/doc/I/S/ISAM.html for all the limits.. Remember that your files sizes may be smaller because of your OS. On Fri, 22 Feb 2002, Brian Warn wrote: Date: Fri, 22 Feb 2002 09:11:07 -0800 From: Brian Warn [EMAIL PROTECTED] To: 'Gurhan Ozen' [EMAIL PROTECTED], 'MySQL List' [EMAIL PROTECTED] Subject: RE: 3.22.32: max table size I did see that reference, but found that myisamchk wasn't an option either. I did find isamchk is available and have been seeing what information it is able to provide. I'm wondering now whether summing the table.ISD, table.ISM, and table.frm filesizes that I get from a simple ls -l output will give me the total diskspace occupied by the table? Brian sql,query -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 8:58 AM To: Brian Warn; 'MySQL List' Subject: RE: 3.22.32: max table size Quoted from http://www.mysql.com/doc/T/a/Table_size.html is: By default, MySQL tables have a maximum size of about 4G. You can check the maximum table size for a table with the SHOW TABLE STATUS command or with the myisamchk -dv table_name. See section 4.5.6 SHOW Syntax. Gurhan -Original Message- From: Brian Warn [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 11:28 AM To: 'MySQL List' Subject: 3.22.32: max table size As show table status doesn't appear to be supported in this older version I'm using, how did you who used this version get max table size information? I haven't been to find anything from the list archives/manual about this. Brian sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Running Without TCP Port
Is it possible to run mysqld without binding to a TCP port? As in run using only unix sockets? - Jonathan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Next and Preview Row
* Roger Baklund It is even possible to do this with one select statement and four left joins to the same table, but it is a bit complicated: select table.*,next.id as next,prev.id as prev from table left join table as prev on prev.id table.id left join table as prev2 on prev2.id prev.id left join table as next on next.id table.id left join table as next2 on next2.id next.id where table1.id=ID00025 and not isnull(prev2.id) and not isnull(next2.id) Nope, this won't work on a big table... it works fine on smaller tables, but not at all on big tables, the server needs to scan recordcount^4 rows to calculate the result... even with only 1000 rows this is a disaster for the server. I have used this on bigger tables, but only when there are some other leftmost key part, so that the number of rows traversed is relatively low. -- 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
GUI Tools for courier-imap user management
Hello good people, Okay I don't mean to offend anyone. I'm a newbie but I have managed to do courier-imap-authmysql today. I can add/remove/changepasswd for users comfortably. Command line is no problem. However, this is a bit slow and I was wondering if anyone out there already invented the GUI wheel to do that stuff. I am especially concerned is some user asks me that he wants to be able to change password. Adding/deleting them is not a problem ;-) I believe the gurus her have perl/php utils that are accessible via a browser that can handle such tasks, no? Last question: I use set crypt=ENCRYPT('passwd_text_here') but can I generate MD5 passwords this way (I mean a simpler method)?? Pointers, and even flames are okay. Much thanks in advance. -Wash S y s t e m s A d m i n. -- Odhiambo Washington [EMAIL PROTECTED]The box said 'Requires Wananchi Online Ltd. www.wananchi.com Windows 95, NT, or better,' Tel: 254 2 313985-9 Fax: 254 2 313922 so I installed FreeBSD. GSM: 254 72 743 223 GSM: 254 733 744 121 This sig is McQ! :-) ++ Eat drink and be merry, for tomorrow they may make it illegal. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Running Without TCP Port
On Fri, 2002-02-22 at 11:09, havoc wrote: Is it possible to run mysqld without binding to a TCP port? As in run using only unix sockets? Start with --skip-networking: http://www.mysql.com/doc/C/o/Command-line_options.html or put skip-networking into your my.cnf file. -- Guy Davis Phone: (403) 301-3426 Pason Systems Fax: (403) 301-3499 PGP: 65BA 484B 0B96 5F3B 4D40 DCA2 B2AE 6B5A F52B 1445 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Running Without TCP Port
Just for my clarification, --skip-networking will disable TCP/IP, but still allow mysqld to use a unix socket as specified by --socket=PATH, correct? On 22 Feb 2002, Guy Davis wrote: Date: 22 Feb 2002 11:28:35 -0700 From: Guy Davis [EMAIL PROTECTED] To: havoc [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Running Without TCP Port On Fri, 2002-02-22 at 11:09, havoc wrote: Is it possible to run mysqld without binding to a TCP port? As in run using only unix sockets? Start with --skip-networking: http://www.mysql.com/doc/C/o/Command-line_options.html or put skip-networking into your my.cnf file. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Running Without TCP Port
DoH! I'm bein a moron here :) Guy, thanx :) On Fri, 22 Feb 2002, havoc wrote: Date: Fri, 22 Feb 2002 12:32:10 -0600 (CST) From: havoc [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Running Without TCP Port Just for my clarification, --skip-networking will disable TCP/IP, but still allow mysqld to use a unix socket as specified by --socket=PATH, correct? On 22 Feb 2002, Guy Davis wrote: Date: 22 Feb 2002 11:28:35 -0700 From: Guy Davis [EMAIL PROTECTED] To: havoc [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Running Without TCP Port On Fri, 2002-02-22 at 11:09, havoc wrote: Is it possible to run mysqld without binding to a TCP port? As in run using only unix sockets? Start with --skip-networking: http://www.mysql.com/doc/C/o/Command-line_options.html or put skip-networking into your my.cnf file. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
How to rewrite this statement.
I have this query that works just fine in msacess agains some linked mysql tables, but if I run this statement in php or in mysqlfront it doesn't work. I belive it's because there is two joins in it but i'm not sure. If that is the problem then what is the work around? Here is the statement: SELECT FORUMCAT1.LASTPOST, USERS.USERNAME, FORUMCAT1.ID, FORUMCAT1.TOPIC, FORUMCAT1.REPLIES, FORUMCAT1.ORIGINATOR, FORUMCAT1.STATUS FROM USERS INNER JOIN (FORUMCAT1 INNER JOIN FORUMMSG1 ON FORUMCAT1.ID = FORUMMSG1.POSTNUMBER) ON USERS.ID = FORUMMSG1.AUTHORID WHERE (((FORUMCAT1.STATUS)2) AND ((FORUMMSG1.MESSAGE) Like *java*)) ORDER BY FORUMCAT1.LASTPOST DESC; Thanks ahead of time! Mat - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to rewrite this statement.
From: Mat Murdock [EMAIL PROTECTED] ... Like *java* Try: Like %java% I would bet the the aseriscs are some non-SQL extention of MS Access. --- Rodney Broom Programmer: Desert.Net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MysqlReplication
Each slave can only have one master. If you want to have one box be a slave to multiple masters, you have to set up a mysqld for each master on the slave box, each with a different port and socket. Now, if this is on Linux, you also can't have the multiple servers share data on this one box, since MySQL doesn't support file locking on Linux. The servers have to be completely independent from one another. james montebello On Fri, 22 Feb 2002 [EMAIL PROTECTED] wrote: query Is it possible to set one SLAVE to handle two or multiple MASTERS??? For example if I want to replicate one table from one MASTER and second table from another. Thanx a lot - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to rewrite this statement.
Ok, so I updated the statement like the past few posts have directed so the statement looks like this: SELECT FORUMCAT1.LASTPOST, USERS.USERNAME, FORUMCAT1.ID, FORUMCAT1.TOPIC, FORUMCAT1.REPLIES, FORUMCAT1.ORIGINATOR, FORUMCAT1.STATUS FROM USERS INNER JOIN (FORUMCAT1 INNER JOIN FORUMMSG1 ON FORUMCAT1.ID = FORUMMSG1.POSTNUMBER) ON USERS.ID = FORUMMSG1.AUTHORID WHERE ((FORUMCAT1.STATUS !=2) AND (FORUMMSG1.MESSAGE Like %java%)) ORDER BY FORUMCAT1.LASTPOST DESC; And this is the message that I get: You have an error in your SQL sytax near '(FORUMCAT1 INNER JOIN FORUMMSG1 ON FORUMCAT1.ID = FORUMMSG1.POSTNUMBER)ON USERS' at line 1. Thanks, Mat - Original Message - From: Nathan [EMAIL PROTECTED] To: Mat Murdock [EMAIL PROTECTED] Sent: Friday, February 22, 2002 12:03 PM Subject: Re: How to rewrite this statement. Where does mysql say there is a problem? By the by, your WHERE clause should read thusly: WHERE FORUMCAT1.STATUS != 2 AND FORUMMSG1.MESSAGE LIKE %java% MySQL does not use for not equal to AFAIK, and you don't need to enclose the clauses in parens. Also, the wildcards for LIKE are % for * and _ for ? if you get my meaning ;-) Let us know what the error is. # Nathan - Original Message - From: Mat Murdock [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 22, 2002 11:51 AM Subject: How to rewrite this statement. I have this query that works just fine in msacess agains some linked mysql tables, but if I run this statement in php or in mysqlfront it doesn't work. I belive it's because there is two joins in it but i'm not sure. If that is the problem then what is the work around? Here is the statement: SELECT FORUMCAT1.LASTPOST, USERS.USERNAME, FORUMCAT1.ID, FORUMCAT1.TOPIC, FORUMCAT1.REPLIES, FORUMCAT1.ORIGINATOR, FORUMCAT1.STATUS FROM USERS INNER JOIN (FORUMCAT1 INNER JOIN FORUMMSG1 ON FORUMCAT1.ID = FORUMMSG1.POSTNUMBER) ON USERS.ID = FORUMMSG1.AUTHORID WHERE (((FORUMCAT1.STATUS)2) AND ((FORUMMSG1.MESSAGE) Like *java*)) ORDER BY FORUMCAT1.LASTPOST DESC; Thanks ahead of time! Mat - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Load Data Infile
I have a table that has following fields id (auto increment) date appleprice orangeprice pearprice When I try to LOAD DATA INFILE with this file using comma as field delimiter and newline as end of row 2000-01-04,281.08,5.27,430.05 2000-01-05,280.06,5.14,421.98 2000-01-06,279.99,5.13,408.59 2000-01-07,281.72,5.14,415.79 2000-01-10,281.32,5.17,415.80 2000-01-11,282.83,5.16,416.36 2000-01-12,281.64,5.14,419.70 2000-01-13,283.27,5.11,421.50 2000-01-14,283.25,5.13,429.09 2000-01-17,284.99,5.10,430.91 2000-01-18,285.75,5.10,432.21 it only writes to one row in the table and seems to be adding the id fields and date fields. pearprice field is empty. This is result of the one row affected id date appleprice orangeprice pearprice 127 2028-01-08 5.27 430.05 Is my data formated incorrectly? Help! Can someone please show me example of their mysql data in a working situation? Thanks Craig - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: How to rewrite this statement.
http://www.mysql.com/doc/J/O/JOIN.html says that INNER JOIN and , (comma) are semantically equivalent. Both do a full join between the tables used. Normally, you specify how the tables should be linked in the WHERE condition. So you could use this instead: SELECT FORUMCAT1.LASTPOST, USERS.USERNAME, FORUMCAT1.ID, FORUMCAT1.TOPIC, FORUMCAT1.REPLIES, FORUMCAT1.ORIGINATOR, FORUMCAT1.STATUS FROM USERS,FORUMCAT1,FORUMMSG1 WHERE (USERS.ID = FORUMMSG1.AUTHORID AND FORUMCAT1.ID = FORUMMSG1.POSTNUMBER AND (FORUMCAT1.STATUS !=2) AND (FORUMMSG1.MESSAGE Like %java%)) ORDER BY FORUMCAT1.LASTPOST DESC; Duncan -- Duncan Salada | Titan | www.titan.com/validity Email: [EMAIL PROTECTED] | Voice: 301-925-3222x375 | Fax: 301-925-3216 -Original Message- From: Mat Murdock [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 2:12 PM To: [EMAIL PROTECTED] Subject: Re: How to rewrite this statement. Ok, so I updated the statement like the past few posts have directed so the statement looks like this: SELECT FORUMCAT1.LASTPOST, USERS.USERNAME, FORUMCAT1.ID, FORUMCAT1.TOPIC, FORUMCAT1.REPLIES, FORUMCAT1.ORIGINATOR, FORUMCAT1.STATUS FROM USERS INNER JOIN (FORUMCAT1 INNER JOIN FORUMMSG1 ON FORUMCAT1.ID = FORUMMSG1.POSTNUMBER) ON USERS.ID = FORUMMSG1.AUTHORID WHERE ((FORUMCAT1.STATUS !=2) AND (FORUMMSG1.MESSAGE Like %java%)) ORDER BY FORUMCAT1.LASTPOST DESC; And this is the message that I get: You have an error in your SQL sytax near '(FORUMCAT1 INNER JOIN FORUMMSG1 ON FORUMCAT1.ID = FORUMMSG1.POSTNUMBER)ON USERS' at line 1. Thanks, Mat - Original Message - From: Nathan [EMAIL PROTECTED] To: Mat Murdock [EMAIL PROTECTED] Sent: Friday, February 22, 2002 12:03 PM Subject: Re: How to rewrite this statement. Where does mysql say there is a problem? By the by, your WHERE clause should read thusly: WHERE FORUMCAT1.STATUS != 2 AND FORUMMSG1.MESSAGE LIKE %java% MySQL does not use for not equal to AFAIK, and you don't need to enclose the clauses in parens. Also, the wildcards for LIKE are % for * and _ for ? if you get my meaning ;-) Let us know what the error is. # Nathan - Original Message - From: Mat Murdock [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 22, 2002 11:51 AM Subject: How to rewrite this statement. I have this query that works just fine in msacess agains some linked mysql tables, but if I run this statement in php or in mysqlfront it doesn't work. I belive it's because there is two joins in it but i'm not sure. If that is the problem then what is the work around? Here is the statement: SELECT FORUMCAT1.LASTPOST, USERS.USERNAME, FORUMCAT1.ID, FORUMCAT1.TOPIC, FORUMCAT1.REPLIES, FORUMCAT1.ORIGINATOR, FORUMCAT1.STATUS FROM USERS INNER JOIN (FORUMCAT1 INNER JOIN FORUMMSG1 ON FORUMCAT1.ID = FORUMMSG1.POSTNUMBER) ON USERS.ID = FORUMMSG1.AUTHORID WHERE (((FORUMCAT1.STATUS)2) AND ((FORUMMSG1.MESSAGE) Like *java*)) ORDER BY FORUMCAT1.LASTPOST DESC; Thanks ahead of time! Mat - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Load Data Infile
You need to specify the columns you're loading, if they aren't all the columns in the table in the same order. So, you need to add (date, appleprice, orangeprice,pearprice) at the end of your LOAD DATA INFILE statement. As for only loading one row, I'd guess your input file line endings don't match what you specified. See http://www.mysql.com/doc/L/O/LOAD_DATA.html Michael On Fri, 22 Feb 2002, Craig Westerman wrote: I have a table that has following fields id (auto increment) date appleprice orangeprice pearprice When I try to LOAD DATA INFILE with this file using comma as field delimiter and newline as end of row 2000-01-04,281.08,5.27,430.05 2000-01-05,280.06,5.14,421.98 2000-01-06,279.99,5.13,408.59 2000-01-07,281.72,5.14,415.79 2000-01-10,281.32,5.17,415.80 2000-01-11,282.83,5.16,416.36 2000-01-12,281.64,5.14,419.70 2000-01-13,283.27,5.11,421.50 2000-01-14,283.25,5.13,429.09 2000-01-17,284.99,5.10,430.91 2000-01-18,285.75,5.10,432.21 it only writes to one row in the table and seems to be adding the id fields and date fields. pearprice field is empty. This is result of the one row affected id date appleprice orangeprice pearprice 127 2028-01-08 5.27 430.05 Is my data formated incorrectly? Help! Can someone please show me example of their mysql data in a working situation? Thanks Craig - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
a column of names
One thing that has always puzzled me is how poeple are gaurding against duplication in columns where people's names are stored. For example this table has a persons's first and last name. Stars: starID starFirstName starLastName 1 Vanna White 2 Bob Marley problems begin to arise when people begin adding new names to the table. I could make a unique key out of (starFirstName,starLastName) but what happens when someone enters ('Robert','Marley') or ('Vanna','Wihte'). I guess the solution is to force users to do a query for an existing name. Is there a way to do a more fuzzy search than using LIKE ? would soundex or something else be the way to go? -- Vincent Stoessel [EMAIL PROTECTED] Linux and Java Application Developer (301) 362-1750 AIM, MSN: xaymaca2020 , Yahoo Messenger: vks_jamaica - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Load Data Infile
At 13:13 -0600 2/22/02, Craig Westerman wrote: I have a table that has following fields id (auto increment) date appleprice orangeprice pearprice When I try to LOAD DATA INFILE with this file using comma as field delimiter and newline as end of row You need to add the column list: ... INTO TABLE tbl_name FIELDS TERMINATED BY ',' ENCLOSED BY '' (date, appleprice, orangeprice, pearprice) Otherwise, LOAD DATA has no idea the id column is not present in the data file. 2000-01-04,281.08,5.27,430.05 2000-01-05,280.06,5.14,421.98 2000-01-06,279.99,5.13,408.59 2000-01-07,281.72,5.14,415.79 2000-01-10,281.32,5.17,415.80 2000-01-11,282.83,5.16,416.36 2000-01-12,281.64,5.14,419.70 2000-01-13,283.27,5.11,421.50 2000-01-14,283.25,5.13,429.09 2000-01-17,284.99,5.10,430.91 2000-01-18,285.75,5.10,432.21 it only writes to one row in the table and seems to be adding the id fields and date fields. pearprice field is empty. This is result of the one row affected id date appleprice orangeprice pearprice 127 2028-01-08 5.27 430.05 Is my data formated incorrectly? Help! Can someone please show me example of their mysql data in a working situation? Thanks Craig - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
GRANT and overhead
What does this quote from the manual mean: If you do not have any GRANT statements done, MySQL will optimise the permission checking somewhat. So if you have a very high volume it may be worth the time to avoid grants. Otherwise more permission check results in a larger overhead. By not having any GRANT statements, does that mean all connections use the 'root' user with no password -- the default setup? That can't be good... Just how much does this affect performance? Thanks, --jeff sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Got error 124 from table handler.
Is there a list off MySQL error-codes avalible? Something like Oracle's oerr. program? perror We are having trouble with one of our MySQL databases. The error is: Got error 124 from table handler. chris@entropy:~$ perror 124 Error code 124: Wrong medium type 124 = Wrong index given to function - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Got error 124 from table handler.
Hi, Yes, just write : perror 124 perror 124 Error code 124: Wrong medium type 124 = Wrong index given to function Regards, Jocelyn Fournier Presence-PC - Original Message - From: Christian M. Stamgren [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 22, 2002 11:49 AM Subject: Got error 124 from table handler. Hi list - Is there a list off MySQL error-codes avalible? Something like Oracle's oerr. program? We are having trouble with one of our MySQL databases. The error is: Got error 124 from table handler. We get this error randomly on some of our MyISAM tables. Optimize table seems to fix the problem temporary. MySQL: Server version 4.0.1-alpha OS: Splack Linux (Slackware port for sparc) running on a Sun Enterprise 4500. Best regards, -- Christian M. Stamgren Senior System Developer Cention Group AB Lästmakargatan 15 Box 7494 SE-103 92 Stockholm +46 (0)8 578 420 86 | direct +46 (0)8 578 420 99 | fax +46 (0)703 41 44 27 | mobile [EMAIL PROTECTED] www.centiongroup.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
Indexing question...
Hi All, Let's say I'm creating an affiliate program to track surfer clicks to sales. I have a question on indexing that's always bothered me. I'm hoping an index guru can help me out. Here's an example click-recording table: CREATE TABLE clicks ( clickID int unsigned NOT NULL auto_increment, initDate datetime NOT NULL default '-00-00 00:00:00', siteID int unsigned NOT NULL default '0', ipAddress int NOT NULL default '0', webmasterID int NOT NULL default '0', optInfo varchar(16) NOT NULL default '', referer varchar(255) NOT NULL default '', PRIMARY KEY (clickID) ) TYPE=MyISAM; I'll set a cookie in the surfer's browser with clickID, so I can match clicks to sales at a later point. siteID is the destination site for the click, webmasterID is the referring webmaster who sent the click (may be blank, signified by '0'). In the reports I want to provide, I want to show how many clicks each site receives over certain time frames and also how many clicks each referring webmaster sent (over a time frame). My question is: would it be better to have a single wide index, like the following: KEY ix_clicks_initDate (initDate,siteID,webmasterID) or multiple indexes: KEY ix_clicks_site (initDate,siteID) KEY ix_clicks_webm (initDate,webmasterID) If I'm searching a date range looking for a particular webmasterID, or grouping by webmasterID's, is the wide index a good choice in this circumstance -- where the middle field of the index isn't referenced in the query? Or does it hurt, because I'm not using all the pieces of the index? I've tried wide indexes like this in the past for reporting purposes, but have always had nagging questions about their use. This is a simple example, but it applies to decisions I need to make about more complex indexing and whether to use wide indexes or not. Can somebody shed some light? Thanks, --jeff - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 server connection errors
Anyone seen this before? Server configuration denies access to data source I'm using the mm.mysql driver and attempting to connect from my java classes with the ip of the server (from the server) as root. The server itself only has two users, root mysql. _ The trouble with the rat-race is that even if you win you're still a rat. --Lily Tomlin _ Charles Harvey Developer http://www.philly.com Wk: 215 789 6057 Cell: 215 588 0851 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Please help newbie with installation. (I read the manual ;-p)
Sorry to double post to the list. Is there anybody out there using SuSE7.3 with the downloadable 4.0.1 max version of mysql? I truly want to start exploring mysql but I cannot get it to run (see below for first post). Thanks in advance for any advice G Hi, I am running SuSE 7.3 Professional and i downloaded the binary files for Max 4.0 version from here: http://www.mysql.com/downloads/mysql-max-4.0.html I followed the installation procudure to the letter from this file: /mysql-max-4.0.1-alpha-pc-linux-gnu-i686/INSTALL-BINARY in the archive. I ran: mysql_install_db without any problems. All the setting were kept exactly as stated in the INSTALL-BINARY file. However I can not run: bin/safe_mysqld --user=mysql as linux root or as any other user on the local host. As a matter of fact the file does not even exist... The closest I have to the above file is: :/usr/local/mysql/bin/mysqld_safe Now I also tried to run this scripts with all user linux accounts and by using the -u root option as oposed to --user=mysql (I also tried --user=root from within all linux accounts. I keep on getting this error: george@linux:/usr/local/mysql ./bin/mysqld_safe --user=root [2] 4727 [1] Exit 1 ./bin/mysqld_safe --user=root george@linux:/usr/local/mysql Starting mysqld daemon with databases from /usr/local/mysql/data ./bin/mysqld_safe: /usr/local/mysql/data/linux.err: Permission denied ./bin/mysqld_safe: /usr/local/mysql/data/linux.err: Permission denied tee: /usr/local/mysql/data/linux.err: Permission denied 020221 23:17:13 mysqld ended tee: /usr/local/mysql/data/linux.err: Permission denied [2]+ Exit 1 ./bin/mysqld_safe --user=root george@linux:/usr/local/mysql I logged in as linux root and gave all users full access to the /usr/local/mysql directory included files and directories below it. At present I do not know what else I could try. Was the file I downloaded corrupt? My .../mysql/bin/ directory size ATM is: 15,229,278 The mysql directory is a symlink to: /usr/local/mysql-max-4.0.1-alpha-pc-linux-gnu-i686 as described in the file INSTALL-BINARY, I gave all users full access to this directory and all its subdirectories as well (obviously this did not help and I will need to change the security back to where it was). If anybody could please assist me or point me to an URL I will apreciate it. G (mysql, 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
Is there a limit on the email size for this list?
I posted a question but received a message stating the file was to large? G (mysql, 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
pb with mysql client and ezmlm
Hi all, I try to compile ezmlm with mysql see what I have got with the compilation phase : www:~/qmailnco# rpm --rebuild --clean --target i686 ezmlm-idx-mysql-0.53.324-4md k.src.rpm here it crashs ./load ezmlm-gate subdb.a getconf.o slurpclose.o slurp.o \ getopt.a getln.a auto_bin.o env.a sig.a fs.a \ strerr.a substdio.a stralloc.a alloc.a error.a str.a case.a wait.a \ open.a lock.a seek.a `head -1 conf-sqlld` /usr/lib/mysql/libmysqlclient.a(my_compress.o): In function `my_uncompress': my_compress.o(.text+0x9a): undefined reference to `uncompress' /usr/lib/mysql/libmysqlclient.a(my_compress.o): In function `my_compress_alloc': my_compress.o(.text+0x12a): undefined reference to `compress' collect2: ld returned 1 exit status make: *** [ezmlm-gate] Erreur 1 error: Bad exit status from /var/tmp/rpm-tmp.99481 (%build) What can I do against this error ? RPM build errors: Bad exit status from /var/tmp/rpm-tmp.99481 (%build) see somethings about my conf : www:/usr/src/RPM/SPECS# ls /usr/lib/mysql/libmysqlclient.a /usr/lib/mysql/libmysqlclient.a* www:/usr/src/RPM/SPECS# rpm -qa | grep mysql php-mysql-4.0.6-3mdk www:/usr/src/RPM/SPECS# rpm -qa | grep MySQL MySQL-devel-4.0.1-2 MySQL-shared-3.23.41-5mdk MySQL-client-4.0.1-2 MySQL-4.0.1-2 www:/usr/src/RPM/SPECS# rpm -qf /usr/lib/mysql/libmysqlclient.a MySQL-devel-4.0.1-2 www:/usr/src/RPM/SPECS# the containt of the /var/tmp/rpm-tmp.99481 file : #!/bin/sh RPM_SOURCE_DIR=/usr/src/RPM/SOURCES RPM_BUILD_DIR=/usr/src/RPM/BUILD RPM_OPT_FLAGS=-O2 -march=i686 RPM_ARCH=i386 RPM_OS=linux export RPM_SOURCE_DIR RPM_BUILD_DIR RPM_OPT_FLAGS RPM_ARCH RPM_OS RPM_DOC_DIR=/usr/share/doc export RPM_DOC_DIR RPM_PACKAGE_NAME=ezmlm-idx-mysql RPM_PACKAGE_VERSION=0.53.324 RPM_PACKAGE_RELEASE=4mdk export RPM_PACKAGE_NAME RPM_PACKAGE_VERSION RPM_PACKAGE_RELEASE RPM_BUILD_ROOT=/var/tmp/ezmlm-idx-mysql-0.53.324-root export RPM_BUILD_ROOT set -x umask 022 cd /usr/src/RPM/BUILD cd ezmlm-0.53 echo /usr/bin conf-bin echo /usr/share/man conf-man echo gcc $RPM_OPT_FLAGS conf-cc echo gcc $RPM_OPT_FLAGS -s conf-ld make mysql make it install # provide ascii files as well if [ -x /usr/bin/lynx ]; then pushd ezman find * -name '*.html' | while read html; do lynx -dump -nolist $html ${html%.html}.txt done popd fi exit 0 /var/t 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: MySQL + Access + MyODBC + LARGE Tables
All, there were many emails posted about this on the MyODBC list which, of course, can be viewed via the archive on the mysql.com site. For the most part I will neither quote nor repeat the information from those emails here. The conclusion is that MySQL + Merge Tables is perfectly capable of being a data warehouse and is in fact better in most regards when compared to other RDMBS. One example: For similar record counts and identical index definitions, speed wise MySQL and the other rdbms are about the same when the query is disk bound (e.g. the index is not cached). MySQL is 5-10x faster than the other rdbms in the cached index case. There are many other benefits as well. (I will not name the other commercial RDBMS out of fear of lawyers, the DCMA, and posting unauthorized benchmarks. You will have to trust me that it is a major RDBMS, MySQL is /fast/ comparatively, and that I am not an idiot at setting up and optimizing databases.) Using MyODBC-3.51.01.01 works fine to access the MySQL database via MS Access. Venu (bless him for all of his help) is going to add information to the FAQ as such: In the large table case one needs to check off three options Return Matching Rows, Allow BIG Results, and Enable Dynamic Cursor. I needed to do one last truly terrible hack to MyODBC (patch below) so that if someone tries to open a very long table (43M rows in my test case) bad things don't happen as MySQL tries to copy the results to a temporary table/file. Perhaps there could be a config for Max Rows When There Is No Criteria in MyODBC? In the next month or two I will try to write an article describing what I did in more detail so that everyone may benefit. b. [bill@badams bill]$ cat myodbchack.patch --- ../myodbc-3.51.orig/execute.c Fri Feb 22 10:55:35 2002 +++ execute.c Fri Feb 22 10:53:48 2002 @@ -72,7 +72,26 @@ query=tmp_buffer; } } - } + } + /* Terrible hack by Bill Adams */ + else if( + !my_casecmp(query, select, 6) + my_casecmp(query, where, 5) + my_casecmp(query, limit , 7) + ){ +/* Limit the number of rows when someone does a query without + any criteria */ +char *tmp_buffer; +uint length=strlen(query); +if ((tmp_buffer=my_malloc(length+30,MYF(0 + { + memcpy(tmp_buffer,query,length); + sprintf(tmp_buffer+length, limit %lu, 2); /* Arbitrary */ + if (query != stmt-query) + my_free((gptr) query,MYF(0)); + query=tmp_buffer; + } + }/* End Terrible Hack */ pthread_mutex_lock(stmt-dbc-lock); if (check_if_server_is_alive(stmt-dbc) || mysql_query(stmt-dbc-mysql,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
::::::::::::::: Inserting BLOBs ::::::::::::::::::::::
I need to store large files in a MySQL database (in Windows). To do this, I have created a table that has a BLOB column. How can I insert the files into this table? Thanks, Ron - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Different indexes on slave -- replication
Can I have different indexes on the tables in my master and slave? I want to use the slave strictly for reporting and the master for inserts, so I'd like to index the crap out of the slave and leave the master relatively index free. Will that work? Thanks, --jeff P.S. -- how 'bout adding some words to the list the listserver checks for when rejecting posts?? index, slave, master, replication, etc... sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Next and Preview Row
Dear All, I am using PHP + MYSQL. I have a question that I need some expert to help. That is: How do I find out a next and preview row values by using PHP and MYSQL. For examples, Row 10ID00010need this value Row 11ID00025have this value on hand Row 12ID00063need this value The questions is how do I find out the values in Row 10 and Row 12, if and only if I only have one data that is ID00025 (select * from table where field=ID00025) . But, the questions is How do I find out the data in Row 10 and Row 12 which is ID00010 and ID00063 assume I don't know the values of ID00025 is in Row 11. Thank you so much for your help. Mark Lo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Next and Preview Row
Dear All, I am using PHP + MYSQL. I have a question that I need some expert to help. That is: How do I find out a next and preview row values by using PHP and MYSQL. For examples, Row 10ID00010need this value Row 11ID00025have this value on hand Row 12ID00063need this value The questions is how do I find out the values in Row 10 and Row 12, if and only if I only have one data that is ID00025 (select * from table where field=ID00025) . But, the questions is How do I find out the data in Row 10 and Row 12 which is ID00010 and ID00063 assume I don't know the values of ID00025 is in Row 11. Thank you so much for your help. Mark Lo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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] Next and Preview Row
How do I find out a next and preview row values by using PHP and MYSQL. For examples, Take a look at the function mysql_result(); Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [PHP] Next and Preview Row
The solution I have been using is to do three queries similar to the below SELECT * FROM table WHERE field='ID00025' SELECT * FROM table WHERE field'ID00025' ORDER BY field DESC LIMIT 0,1 SELECT * FROM table WHERE field'ID00025' ORDER BY field ASC LIMIT 0,1 If you whish more row returned change the number in the LIMIT Why bother with 3 queries? It's a waste of resources, especially if you are working with the same record set... Example (pseudo)code: ? $query = SELECT * FROM table; $result = mysql( $dbname, $query ); for( $i = 0; $i mysql_num_rows( $result ); $i++ ) { echo Previous field: . mysql_result( $result, ( $i - 1 ), field ); echo Current field: . mysql_result( $result, $i, field ); echo Next field: . mysql_result( $result, ( $i + 1 ), field ); } ? Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [PHP] Next and Preview Row
The solution I have been using is to do three queries similar to the below SELECT * FROM table WHERE field='ID00025' SELECT * FROM table WHERE field'ID00025' ORDER BY field DESC LIMIT 0,1 SELECT * FROM table WHERE field'ID00025' ORDER BY field ASC LIMIT 0,1 If you whish more row returned change the number in the LIMIT -- Raymond Gubala Program Coordinator Multimedia Design and Web Developer Durham College mailto:[EMAIL PROTECTED] From: Mark Lo [EMAIL PROTECTED] Date: Fri, 22 Feb 2002 23:15:18 +0800 To: [EMAIL PROTECTED], [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: [PHP] Next and Preview Row Dear All, I am using PHP + MYSQL. I have a question that I need some expert to help. That is: How do I find out a next and preview row values by using PHP and MYSQL. For examples, Row 10ID00010need this value Row 11ID00025have this value on hand Row 12ID00063need this value The questions is how do I find out the values in Row 10 and Row 12, if and only if I only have one data that is ID00025 (select * from table where field=ID00025) . But, the questions is How do I find out the data in Row 10 and Row 12 which is ID00010 and ID00063 assume I don't know the values of ID00025 is in Row 11. Thank you so much for your help. Mark Lo -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.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: [PHP] Next and Preview Row
Hi, It seems worst to me because in your case mysql has to retrieve all the rows. If it's a table with 1 million records or more, this should hurt ;) Regards, Jocelyn Fournier Presence-PC - Original Message - From: Chris Boget [EMAIL PROTECTED] To: Raymond Gubala [EMAIL PROTECTED]; Mark Lo [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, February 22, 2002 4:45 PM Subject: Re: [PHP] Next and Preview Row The solution I have been using is to do three queries similar to the below SELECT * FROM table WHERE field='ID00025' SELECT * FROM table WHERE field'ID00025' ORDER BY field DESC LIMIT 0,1 SELECT * FROM table WHERE field'ID00025' ORDER BY field ASC LIMIT 0,1 If you whish more row returned change the number in the LIMIT Why bother with 3 queries? It's a waste of resources, especially if you are working with the same record set... Example (pseudo)code: ? $query = SELECT * FROM table; $result = mysql( $dbname, $query ); for( $i = 0; $i mysql_num_rows( $result ); $i++ ) { echo Previous field: . mysql_result( $result, ( $i - 1 ), field ); echo Current field: . mysql_result( $result, $i, field ); echo Next field: . mysql_result( $result, ( $i + 1 ), field ); } ? Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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] Next and Preview Row
It seems worst to me because in your case mysql has to retrieve all the rows. If it's a table with 1 million records or more, this should hurt ;) As I said, it was pseudo code. Now, imagine that you were just getting the records for a particular user? a particular application? Where there won't be millions and millions of rows? Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [PHP] Next and Preview Row
Yes, but how to get ONLY the 3 records you need ? Because often in an application, you don't care about the other records. In this case AFAIK, there is no other solution than issuing at least two queries : SELECT * FROM table WHERE field='ID00025' ORDER BY field DESC LIMIT 2 SELECT * FROM table WHERE field'ID00025' ORDER BY field ASC LIMIT 1 - Original Message - From: Chris Boget [EMAIL PROTECTED] To: Fournier Jocelyn [Presence-PC] [EMAIL PROTECTED]; Raymond Gubala [EMAIL PROTECTED]; Mark Lo [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, February 22, 2002 9:17 PM Subject: Re: [PHP] Next and Preview Row It seems worst to me because in your case mysql has to retrieve all the rows. If it's a table with 1 million records or more, this should hurt ;) As I said, it was pseudo code. Now, imagine that you were just getting the records for a particular user? a particular application? Where there won't be millions and millions of rows? Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [PHP] Next and Preview Row
Yes, but how to get ONLY the 3 records you need ? Because often in an application, you don't care about the other records. In this case AFAIK, there is no other solution than issuing at least two queries : SELECT * FROM table WHERE field='ID00025' ORDER BY field DESC LIMIT 2 SELECT * FROM table WHERE field'ID00025' ORDER BY field ASC LIMIT 1 - Original Message - From: Chris Boget [EMAIL PROTECTED] To: Fournier Jocelyn [Presence-PC] [EMAIL PROTECTED]; Raymond Gubala [EMAIL PROTECTED]; Mark Lo [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, February 22, 2002 9:17 PM Subject: Re: [PHP] Next and Preview Row It seems worst to me because in your case mysql has to retrieve all the rows. If it's a table with 1 million records or more, this should hurt ;) As I said, it was pseudo code. Now, imagine that you were just getting the records for a particular user? a particular application? Where there won't be millions and millions of rows? Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Is there a limit on the email size for this list?
On Fri, Feb 22, 2002 at 11:21:23PM +0200, George Labuschagne wrote: I posted a question but received a message stating the file was to large? Look at the message. Some idiot's mailbox is over the limit. Anytime I post to this list I get 2 return mails bounced from lusers. With regards to your problem - 1) don't yopu really want to create a mysel user/group and use that as an arg to --user? 2) what are the exact permissions to your data dir? ls -l /usr/local ls -l /usr/local/mysql ls -l /usr/local/mysql/data Cheers, -- Alastair | | [EMAIL PROTECTED]| | http://www.nucoda.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: Is there a limit on the email size for this list?
Hi Alastair, Yip somebody pointed me towards the address from the returned mail ;-p. Now for the answers to your questions: 1. I did create a user and a group for mysql by using: shell chown -R root /usr/local/mysql shell chown -R mysql /usr/local/mysql/data shell chgrp -R mysql /usr/local/mysql shell chown -R root /usr/local/mysql/bin 2. Here is the output for the permissions: ls -l /usr/local = george@linux:~ ls -l /usr/local total 9163 drwxr-xr-x2 root root 35 Sep 22 15:08 bin drwxr-xr-x2 root root 35 Sep 22 15:08 etc drwxr-xr-x2 root root 35 Sep 22 15:08 ftp drwxr-xr-x2 root root 35 Sep 22 15:08 games drwxr-xr-x4 root root 80 Feb 21 10:18 httpd drwxr-xr-x2 root root 35 Sep 22 15:08 include drwxr-xr-x2 root root 35 Feb 21 10:25 info drwxr-xr-x2 root root 35 Sep 22 15:08 lib drwxr-xr-x 12 root root 257 Feb 21 08:45 man lrwxrwxrwx1 root mysql 39 Feb 21 10:35 mysql - mysql-max-4.0.1-alpha-pc-linux-gnu-i686 drwxrwxrwx 13 505 mysql 516 Dec 23 17:45 mysql-max-4.0.1-alpha-pc-linux-gnu-i686 -rwxr-xr-x1 root root 9372593 Feb 20 22:48 mysql-max-4.0.1-alpha-pc-linux-gnu-i686.tar.gz drwxr-xr-x2 root root 35 Sep 22 15:08 sbin drwxr-xr-x2 root root 35 Sep 22 15:08 share drwxr-xr-x2 root root 35 Sep 22 15:08 src ls -l /usr/local/mysql = ls -l /usr/local/mysql lrwxrwxrwx1 root mysql 39 Feb 21 10:35 /usr/local/mysql - mysql-max-4.0.1-alpha-pc-linux-gnu-i686 ls -l /usr/local/mysql/data = ls -l /usr/local/mysql/data total 13 -rw-r--r--1 mysqlroot 9900 Feb 21 11:34 linux.err drwxrwxrwx2 mysqlmysql 506 Feb 21 10:45 mysql drwxrwxrwx2 mysqlmysql 35 Dec 23 17:44 test Thanks, George (mysql, query) On Saturday 23 February 2002 00:50, alastair wrote: On Fri, Feb 22, 2002 at 11:21:23PM +0200, George Labuschagne wrote: I posted a question but received a message stating the file was to large? Look at the message. Some idiot's mailbox is over the limit. Anytime I post to this list I get 2 return mails bounced from lusers. With regards to your problem - 1) don't yopu really want to create a mysel user/group and use that as an arg to --user? 2) what are the exact permissions to your data dir? ls -l /usr/local ls -l /usr/local/mysql ls -l /usr/local/mysql/data 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
Bugs and more Bugs.
Hi, I installed the BD mysql and I am some problems. # /usr/local/mysql/bin/safe_mysqld It's ok. Here: # mysqladmin password my_password /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' And when I try do tables in mysql /usr/local/mysql/bin/mysql mysql_create.sql ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) What I do? Release: mysql-3.22.32 (Source distribution) Environment: System: Linux name_of_machine 2.2.16-22 #1 Tue Aug 22 16:49:06 EDT 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.0) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' Configure command: ./configure --prefix=/usr/local/mysql Thank you for you help. Joedilson - Um fracasso na vida nao representa o fim da utilidade - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Inserting BLOBs
I posted a problem I was having with this, but unfortunately nobody responded. Regardless, here are the methods I've used: 1) using LOAD_FILE(): INSERT INTO table_name (column_name) VALUES(LOAD_FILE('/absolute/path/to/file')); In windows, of course, the path to the file should probably follow the c:\path\to\file form. This will also only work from the server machine. 2) using a piece of middleware (PHP, Perl, etc.) to create a query that contains the contents of the file in the INSERT. In PHP, something like this suffices: $filename = '/absolute/path/to/file'; $fh = fopen($filename,'r'); $query = 'INSERT INTO table_name (column_name) VALUES('; $query .= addslashes(fread($fh,filesize($filename))); $query .= ')'; $res = mysql_query($query); With either method, the amount of memory you allocate for MySQL (in my.cnf) will determine how large of a file you can insert into your table (BLOB columns can contain 65535 bytes, MEDIUMBLOBs ~16MB, and LONGBLOBs ~4GB). I've had difficulty (out of memory errors, corrupted tables, NULL values) inserting values larger than 2MB in LONGBLOB columns, though, so be forewarned. -- shawn allen | [EMAIL PROTECTED] I need to store large files in a MySQL database (in Windows). To do this, I have created a table that has a BLOB column. How can I insert the files into this table? Thanks, Ron - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Bugs and more Bugs.
did you follow the instructions in the link below? http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.htm l#Post-installation -Original Message- From: Joedilson B. Azevedo [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 6:08 PM To: [EMAIL PROTECTED] Subject: Bugs and more Bugs. Hi, I installed the BD mysql and I am some problems. # /usr/local/mysql/bin/safe_mysqld It's ok. Here: # mysqladmin password my_password /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' And when I try do tables in mysql /usr/local/mysql/bin/mysql mysql_create.sql ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) What I do? Release: mysql-3.22.32 (Source distribution) Environment: System: Linux name_of_machine 2.2.16-22 #1 Tue Aug 22 16:49:06 EDT 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.0) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' Configure command:./configure --prefix=/usr/local/mysql Thank you for you help. Joedilson - Um fracasso na vida nao representa o fim da utilidade - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Frustrated Linux 7 sql installer seeks enlightenment
Hello SqlFolk ; I'm trying to install mysql the latest version of mysql (client, server, devel, bench, shared) on Red Hat Linux 7.0 (kernel = 2.2.16-22). After downloading the RPMs, I get a signal 4 error on the server install and notice complaints concerning threads. Perusing the mysql manuals seems to suggest that upgrading the kernel to 2.4.n.n would help. This is unfortunately a task which is at least as complicated as reloading the entire OS. There's very little that's not tied up with the Linux kernel in some way. Does anyone know of a less painful way to create an environment using mysql which will allow me to continue with the bit of perl/ CGI programming I set out to do in the first place ? If I go with some more antique version of sql to avoid the problem, do I stand any real chance of success ? I hope you've had a better day than I have. 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: Bugs and more Bugs.
apologies for the sorry mail formatting...the whole link should be http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.htm l#Post-installation -Original Message- From: Gregory Junker Sent: Friday, February 22, 2002 6:22 PM To: Joedilson B. Azevedo; [EMAIL PROTECTED] Subject: RE: Bugs and more Bugs. did you follow the instructions in the link below? http://www.mysql.com/documentation/mysql/bychapter/manual_Inst alling.htm l#Post-installation -Original Message- From: Joedilson B. Azevedo [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 6:08 PM To: [EMAIL PROTECTED] Subject: Bugs and more Bugs. Hi, I installed the BD mysql and I am some problems. # /usr/local/mysql/bin/safe_mysqld It's ok. Here: # mysqladmin password my_password /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' And when I try do tables in mysql /usr/local/mysql/bin/mysql mysql_create.sql ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) What I do? Release: mysql-3.22.32 (Source distribution) Environment: System: Linux name_of_machine 2.2.16-22 #1 Tue Aug 22 16:49:06 EDT 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.0) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' Configure command: ./configure --prefix=/usr/local/mysql Thank you for you help. Joedilson - Um fracasso na vida nao representa o fim da utilidade - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: max suffice
On Sat, Feb 23, 2002 at 12:39:43AM +0100, [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: I was curious. I thought you needed --with-server-suffix=-max to use innodb and berkeley db, but a friend of mine says he has been using those table types fine without them. If this is the case what does the flag do? Thanks, Dave - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
quick reference guide
hello all, anybody know where to find a quick reference guide for mysql commands/functions? TIA, luie __ www.edsamail.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 3.23.49 porting problem on POSIX 1003.1-2001 hosts
Description: The new POSIX standard is now official (IEEE Std 1003.1-2001), and it has removed support for some obsolete utility options that mysql uses in a few places. Basically, the new POSIX has removed digit-string options (e.g., tail -1) and options beginning with + (e.g., sort +1). I'm using an experimental environment that insists on the new standard, so I tend to run into these problems before other people do. How-To-Repeat: Build and run Mysql on a host that insists on POSIX 1003.1-2001 semantics. Fix: 2002-02-22 Paul Eggert [EMAIL PROTECTED] * bdb/dist/s_recover: Use the standard -k option if it works; otherwise fall back on the traditional notation. * bdb/dist/s_recover, mysql-test/mysql-test-run.sh, sql-bench/server-cfg.sh: Don't use head -1. * scripts/safe_mysqld.sh: Don't use tail -1. === RCS file: bdb/dist/s_recover,v retrieving revision 3.23.49.0 retrieving revision 3.23.49.1 diff -pu -r3.23.49.0 -r3.23.49.1 --- bdb/dist/s_recover 2001/04/18 08:45:53 3.23.49.0 +++ bdb/dist/s_recover 2002/02/22 23:56:22 3.23.49.1 @@ -12,6 +12,13 @@ rm -f $loglist trap 'rm -f $t; exit 1' 1 2 3 13 15 +# Use the standard -k option if it works; +# otherwise fall back on the traditional notation. +if sort -k 1,1 /dev/null +then sort_2_etc='-k 2' +else sort_2_etc='+1' +fi + # Check to make sure we haven't duplicated a log record entry, and build # the list of log record types that the test suite uses. for i in $DIR; do @@ -19,13 +26,14 @@ for i in $DIR; do for f in ../$i/*.src; do # Grab the PREFIX; there should only be one per file, and # so it's okay to just take the first. - grep '^PREFIX' $f | head -1 + grep '^PREFIX' $f | sed q egrep '^DEPRECATED[ ]|^BEGIN[ ]' $f | \ awk '{print $1 \t $2 \t $3}' done done $loglist -grep -v '^PREFIX' $loglist | awk '{print $2 \t $3}' | sort +1 -n | \ +grep -v '^PREFIX' $loglist | awk '{print $2 \t $3}' | \ +sort $sort_2_etc -n | \ uniq -d -f 1 $t [ -s $t ] { echo DUPLICATE LOG VALUES: === RCS file: mysql-test/mysql-test-run.sh,v retrieving revision 3.23.49.0 retrieving revision 3.23.49.1 diff -pu -r3.23.49.0 -r3.23.49.1 --- mysql-test/mysql-test-run.sh2002/02/14 17:30:24 3.23.49.0 +++ mysql-test/mysql-test-run.sh2002/02/22 23:56:22 3.23.49.1 @@ -44,21 +44,22 @@ which () # No paths below as we can't be sure where the program is! -BASENAME=`which basename | head -1` -DIFF=`which diff | head -1` +SED=sed + +BASENAME=`which basename | $SED q` +DIFF=`which diff | $SED q` CAT=cat CUT=cut TAIL=tail ECHO=echo # use internal echo if possible EXPR=expr # use internal if possible FIND=find -GCOV=`which gcov | head -1` +GCOV=`which gcov | $SED q` PRINTF=printf RM=rm TIME=time TR=tr -XARGS=`which xargs | head -1` -SED=sed +XARGS=`which xargs | $SED q` # Are we using a source or a binary distribution? === RCS file: scripts/safe_mysqld.sh,v retrieving revision 3.23.49.0 retrieving revision 3.23.49.1 diff -pu -r3.23.49.0 -r3.23.49.1 --- scripts/safe_mysqld.sh 2002/02/14 17:30:15 3.23.49.0 +++ scripts/safe_mysqld.sh 2002/02/22 23:56:22 3.23.49.1 @@ -253,7 +253,7 @@ do I=1 while test $I -le $numofproces do - PROC=`ps xa | grep $ledir/$MYSQLD | grep -v grep | tail -1` + PROC=`ps xa | grep $ledir/$MYSQLD | grep -v grep | sed -n '$p'` for T in $PROC do break === RCS file: sql-bench/server-cfg.sh,v retrieving revision 3.23.49.0 retrieving revision 3.23.49.1 diff -pu -r3.23.49.0 -r3.23.49.1 --- sql-bench/server-cfg.sh 2002/02/14 17:30:18 3.23.49.0 +++ sql-bench/server-cfg.sh 2002/02/22 23:56:22 3.23.49.1 @@ -932,7 +932,7 @@ sub version { if ($dir -e $dir/bin/solcon) { - $version=`$dir/bin/solcon -ever $main::opt_user $main::opt_password | grep Server | head -1`; + $version=`$dir/bin/solcon -ever $main::opt_user $main::opt_password | grep +Server | sed q`; if ($? == 0) { chomp($version); Submitter-Id: [EMAIL PROTECTED] Originator: Organization: Twin Sun, Inc. MySQL support: none Synopsis: mysql 3.23.49 porting problem on POSIX 1003.1-2001 hosts Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: mysql-3.23.49 (Source distribution) Environment: System: SunOS sic.twinsun.com 5.8 Generic_108528-13 sun4u sparc SUNW,UltraSPARC-IIi-Engine Architecture: sun4 Some paths: /usr/bin/perl /usr/ccs/bin/make
Re: quick reference guide
On Friday 22 February 2002 5:03 pm, Luie wrote: hello all, anybody know where to find a quick reference guide for mysql commands/functions? If you are looking for an SQL quick reference guide, check out SQL Instant Reference (2nd Edition) by Martin Gruber, published by Sybex. Very good book, though I wish they added more about DB normalisation. There are some very good books on MySQL specifically, Paul DuBois wrote one and I hope I got his name correct. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: quick reference guide
Try www.mysql.com/doc www.php.net/manual/en/ref.mysql.php Warren Stringham -Original Message- From: Luie [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 5:04 PM To: [EMAIL PROTECTED] Subject: quick reference guide hello all, anybody know where to find a quick reference guide for mysql commands/functions? TIA, luie __ www.edsamail.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: Bugs and more Bugs.
Joedilson, the syntax for specifying a password to mysqladmin is --password=my_password, or -p if you want it to prompt. (Notice that it says, Using password: NO .. thats because it doesn't realize you're trying to use a password). You also need to specify the password when you're using mysql .. so.. /usr/local/mysql/bin/mysql --password=my_password mysql_create.sql In general I suggest you take a look at mysqladmin --help | more and mysql --help | more Having the applications themselves answer your questions will be much faster than a mailing list. =) Eric Mayers Software Engineer I Captus Networks -Original Message- From: Joedilson B. Azevedo [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 3:08 PM To: [EMAIL PROTECTED] Subject: Bugs and more Bugs. Hi, I installed the BD mysql and I am some problems. # /usr/local/mysql/bin/safe_mysqld It's ok. Here: # mysqladmin password my_password /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' And when I try do tables in mysql /usr/local/mysql/bin/mysql mysql_create.sql ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) What I do? Release: mysql-3.22.32 (Source distribution) Environment: System: Linux name_of_machine 2.2.16-22 #1 Tue Aug 22 16:49:06 EDT 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.0) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' Configure command:./configure --prefix=/usr/local/mysql Thank you for you help. Joedilson - Um fracasso na vida nao representa o fim da utilidade - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Frustrated Linux 7 sql installer seeks enlightenment
Actually, upgrading the kernel is /not/ hard. Simply follow the instructions in the INSTALL file inside the tarball. Many people have a fear of doing this, but if you read the instructions, and know your machine, it's a simple matter. Matthew Walker Ecommerce Project Manager Mountain Top Herbs -Original Message- From: Sean Nelson [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 4:30 PM To: [EMAIL PROTECTED] Subject: Frustrated Linux 7 sql installer seeks enlightenment Hello SqlFolk ; I'm trying to install mysql the latest version of mysql (client, server, devel, bench, shared) on Red Hat Linux 7.0 (kernel = 2.2.16-22). After downloading the RPMs, I get a signal 4 error on the server install and notice complaints concerning threads. Perusing the mysql manuals seems to suggest that upgrading the kernel to 2.4.n.n would help. This is unfortunately a task which is at least as complicated as reloading the entire OS. There's very little that's not tied up with the Linux kernel in some way. Does anyone know of a less painful way to create an environment using mysql which will allow me to continue with the bit of perl/ CGI programming I set out to do in the first place ? If I go with some more antique version of sql to avoid the problem, do I stand any real chance of success ? I hope you've had a better day than I have. 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 --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.325 / Virus Database: 182 - Release Date: 2/19/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.325 / Virus Database: 182 - Release Date: 2/19/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