Re: sth-execute - screen/file output
this one really works, thank you so much to all who responded... At 11:49 PM 2/4/01 -0700, Colin Faber wrote: [EMAIL PROTECTED] wrote: hi list, im trying to write a perl srcipt that will connect to a mysql database server, do some queries and print the output on the screen (or maybe append the output to a file), that would look something like this. +--+---+--+-+ | tnum | user | cust | area| +--+---+--+-+ | 22 | nivra | testing | isdn | | 23 | nivra | testing1 | ddu | | 24 | nivra | testing1 | ddu | +--+---+--+-+ below is my perl script. #!/usr/bin/perl use DBI; $dbname= "dbname"; $dbuser = "dbuser"; $dbpass = "dbpass"; $dbhost = "localhost"; $dbport = "3306"; $dsn = "DBI:mysql:database=$dbname;host=$dbhost;port=$dbport"; $condition = " where date = '2001/01/27' and petsa = '2001/01/31' and user = 'user'"; # Connect to the database $dbh = DBI-connect($dsn, $dbuser, $dbpass); # if needed and execute the SELECT $sth = $dbh-prepare("SELECT tnum, user, type, area, stat FROM tickets$where ") || die $dbh-errstr; $sth-execute; while(my $ref = $sth-fetchrow_hashref()){ print "$ref-{tnum}|$ref-{user}|$ref-{type}|$ref-{area}|$ref-{stat}\n"; } # or something along those lines # clean up disconnect from the DB $sth-finish; $dbh-disconnect; but it doesn't give me any output at all. i'd like to know if there is any special parameter to use with sth-execute to do this. did i miss anything here? thanks for your time. - Before posting, please check: http://www.mysql.com/manual.phphttp://www.mysql.com/manual.php (the manual) http://lists.mysql.com/http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.phphttp://lists.mysql.com/php/unsubscribe.php
AW: Newbie question
Wolfgang Arendt Vodafone TeleCommerce GmbH SW Test Config. Management Wolfgang Arendt Daniel-Goldbach-Str. 17-19 40880 Ratingen Tel. +49 (0) 21 02 / 97 2492 Fax +49 (0) 21 02 / 97 2453 mailto:[EMAIL PROTECTED] www.vodafone-telecommerce.de So how do I create /tmp/mysqld.sock??? A socket is created using the 'mknod' command. The command should read something like this: mknod /tmp/mysql.sock p In addition to that you can determine, where the socket should go using the option --with-unix-socket-path= when configuring mysql for compiling. If you did this, the socket will be created upon server start. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can anyone do this ?
Hi Rus, I'm not sure I follow, but the DATE column represents the dates at which I have a certain item in stock. ie (. for from 2001-02-04 - 2001-02-06 I have Item1 in stock. However I only have Item2 in stock on 2001-02-04 AND 2001-02-06). A typical application would be a car hire company: where the Items represent a particular car model. My user requests a list of all cars available from 2001-02-04 to 2001-02-06. I can therefor only return Item1 as Item2 is not available on 2001-02-05. I hope this answers your question. Thanks, -- Frank --- Rus [EMAIL PROTECTED] wrote: Can you explain what difference between dates 2001-02-04 and 2001-02-06 for item2 and 2001-02-04 and 2001-02-06 for item1? - Original Message - From: Web Depressed [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, February 04, 2001 11:41 PM Subject: Can anyone do this ? Hi, I've been trying for a while now and I can't figure out how to do the following: In regular English, I wish to show all items for which I have allocations greater than one for all days encapsulated between the user input range. User Input: --- Date_from (ie. 2001-02-04) Date_to (ie. 2001-02-06) My Tables: -- Table1 +++ | id | name | +++ | 1 | Item1 | | 2 | Item2 | +++ Table2 ++-+---+ | date | no_of_items | table1_id | ++-+---+ | 2001-02-04 | 3 | 1 | | 2001-02-05 | 2 | 1 | | 2001-02-06 | 2 | 1 | | 2001-02-04 | 2 | 2 | | 2001-02-06 | 1 | 2 | ++-+---+ Basically my user says he/she needs a list of what items are available FROM a certain date TO a certain date. I therefor need to return all items which I have at least 1 of for EACH of the dates within my users range: I have tried using BETWEEN but it fails (ie. If my user says: from 2001-02-04 to 2001-02-06, using BETWEEN MySQL returns Item2 even though I do not have Item 2 listed for 2001-02-05. Here is where I'm at: mysql SELECT t1.*, t2.* - FROM Table1 t1, Table2 t2 - WHERE t2.date BETWEEN "2001-02-04" AND "2001-02-06" - AND t1.id=t2.table1_id - AND t2.no_of_Items =1; ++---++-+---+ | id | Item | date | no_of_items | table1_id | ++---++-+---+ | 1 | Item1 | 2001-02-04 | 3 | 1 | | 1 | Item1 | 2001-02-05 | 2 | 1 | | 1 | Item1 | 2001-02-06 | 2 | 1 | | 2 | Item2 | 2001-02-04 | 2 | 2 | | 2 | Item2 | 2001-02-06 | 1 | 2 | ++---++-+---+ What I need is a query which will generate the following result: ++---++-+---+ | id | Item | date | no_of_items | table1_id | ++---++-+---+ | 1 | Item1 | 2001-02-04 | 3 | 1 | | 1 | Item1 | 2001-02-05 | 2 | 1 | | 1 | Item1 | 2001-02-06 | 2 | 1 | ++---++-+---+ Forgive me if this is actually simple and/or I haven't explained clearly. Many thanks in advance for your help. -- Frank __ Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
DB link with MySQL and Oracle
Can MySQL make DB link connection to Oracle such that MySQL can directly access tables in Oracle and vice versa? Since I am doing a project with 2 databases: MySQL and Oracle, and have to link them up. Thank you very much. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can anyone do this ?
Hi Bob, Many thanks for that. I was hoping (through absolute naiveity) not to have to go and calculate the number of days with the specified range. Unless, of course I could have mysql do this for me. Can anyone tell me how I could generate such a list. (ie something like: SELECT BETWEEN "2001-02-04" AND "2001-02-06" ? ) Thanks again, -- Frank Hi, I've been trying for a while now and I can't figure out how to do the following: In regular English, I wish to show all items for which I have allocations greater than one for all days encapsulated between the user input range. User Input: --- Date_from(ie. 2001-02-04) Date_to (ie. 2001-02-06) My Tables: -- Table1 +++ | id | name | +++ | 1 | Item1 | | 2 | Item2 | +++ Table2 ++-+---+ | date | no_of_items | table1_id | ++-+---+ | 2001-02-04 | 3 | 1 | | 2001-02-05 | 2 | 1 | | 2001-02-06 | 2 | 1 | | 2001-02-04 | 2 | 2 | | 2001-02-06 | 1 | 2 | ++-+---+ Basically my user says he/she needs a list of what items are available FROM a certain date TO a certain date. I therefor need to return all items which I have at least 1 of for EACH of the dates within my users range: I have tried using BETWEEN but it fails (ie. If my user says: from 2001-02-04 to 2001-02-06, using BETWEEN MySQL returns Item2 even though I do not have Item 2 listed for 2001-02-05. Here is where I'm at: mysql SELECT t1.*, t2.* - FROM Table1 t1, Table2 t2 - WHERE t2.date BETWEEN "2001-02-04" AND "2001-02-06" - AND t1.id=t2.table1_id - AND t2.no_of_Items =1; ++---++-+---+ | id | Item | date | no_of_items | table1_id | ++---++-+---+ | 1 | Item1 | 2001-02-04 | 3 | 1 | | 1 | Item1 | 2001-02-05 | 2 | 1 | | 1 | Item1 | 2001-02-06 | 2 | 1 | | 2 | Item2 | 2001-02-04 | 2 | 2 | | 2 | Item2 | 2001-02-06 | 1 | 2 | ++---++-+---+ What I need is a query which will generate the following result: ++---++-+---+ | id | Item | date | no_of_items | table1_id | ++---++-+---+ | 1 | Item1 | 2001-02-04 | 3 | 1 | | 1 | Item1 | 2001-02-05 | 2 | 1 | | 1 | Item1 | 2001-02-06 | 2 | 1 | ++---++-+---+ Forgive me if this is actually simple and/or I haven't explained clearly. Many thanks in advance for your help. -- Frank Sir, create a variable day_count with the count of days in the user-supplied range. Then set up the following temp table. CREATE TEMPORARY TABLE counts SELECT table1_id, Count(DISTINCT date_field) as cnt WHERE data_field BETWEEN min AND max GROUP BY id HAVING cnt = day_count; Now you have a table with the IDs of items that occur at least once each day in the user-supplied range. You don't need the DISTINCT if each item can only have one record per day. Now some inner joins should get the results you want. SELECT table1.*, table2.* FROM table1, table2, counts WHERE table1.id = table2.table1_id AND table1.id = counts.table1_id AND date_field BETWEEN min AND max; I haven't actually run this, which means that there's probably a mistake or three. Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem using COUNT DISTINCT together
Hi, Woh ! This is very strange. Any ideas ? mysql SELECT * FROM Table2; ++-+---+ | date | no_of_items | table1_id | ++-+---+ | 2001-02-04 | 3 | 1 | | 2001-02-05 | 2 | 1 | | 2001-02-06 | 2 | 1 | | 2001-02-04 | 2 | 2 | | 2001-02-06 | 1 | 2 | ++-+---+ 5 rows in set (0.04 sec) mysql SELECT COUNT(date) FROM Table2; +-+ | COUNT(date) | +-+ | 5 | +-+ 1 row in set (0.02 sec) mysql SELECT DISTINCT date FROM Table2; ++ | date | ++ | 2001-02-04 | | 2001-02-05 | | 2001-02-06 | ++ 3 rows in set (0.03 sec) mysql SELECT COUNT(DISTINCT date) FROM Table2; ERROR 1064: You have an error in your SQL syntax near 'DISTINCT date) FROM Table2' at line 1 mysql SELECT COUNT (DISTINCT date) FROM Table2; ERROR 1064: You have an error in your SQL syntax near '(DISTINCT date) FROM Table2' at line 1 mysql SELECT COUNT(DISTINCT 'date') FROM Table2; ERROR 1064: You have an error in your SQL syntax near 'DISTINCT 'date') FROM Table2' at line 1 FYI: ./mysql Ver 9.38 Distrib 3.22.32, for sun-solaris2.7 (sparc) Kind Regards, -- Frank __ Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Increasing queries speed?
Hello I wondered if there was a way to increase the speed of the query and bring it to 2 or 3 seconds? Have you tried optimization hints from the chapter 12 of the manual? http://mysql.com/doc/P/e/Performance.html cheers -- TS - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 3.23.31 gives FULLTEXT problems on sparc64 Linux
Hello The error says: "Can't read indexpage from filepos: -1". [...] Thank you for reporting this. This will be fixed in a next release. But it was really not a big problem - the table was not really corrupted. [...] Thanks for the fix and the explanation! cheers -- TS - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Arabic character set
I have too this problem with cp1251 and write 3 time about this, but nobody don't know correct answer :-( BY - Original Message - From: "medianova" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 05, 2001 1:51 PM Subject: Arabic character set Hi, we are setting up an Arabic web site using PHP with MySQL 3.23.22. Our problem is that we can not sort data correctly when retreiving it from Arabic text fields. This seems to be a character set problem. Has anyone any idea about using the Arabic character set with MySQL? Many thanks. Ghaleb - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 -u root WITHOUT password !
RENAULT Laurent a crit : I don't have mySQL root password ! Is the solution do a backup of databases and cleanup mysql install and re-install it ? If you have Unix root access, you can edit the table where is stored the encrypted password, and put a new one ... You can too re-install MySQL Nicob - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Update: Status of MySQL 4.0/Innobase/trx row level locks
I'm confused. Am I right in thinking that the Nusphere Gemini project and this announcment are linked? Is the Innobase code going to provide the transactional support for MySQL v.4? If not, whats the difference between this and Nuspheres work? My company will definitely need transactions soon, and the more information I have, the more of a case I can make for sticking with MySQL. Can someone please clarify the situation for me. Thanks Robin -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: 02 February 2001 16:14 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Update: Status of MySQL 4.0/Innobase/trx row level locks Hi, readers of the mailing list! I promised to report to the mailing list how the interfacing of MySQL and Innobase engine progresses. Innobase will provide transactions, rollback, row level locking, and Oracle-style non-locking consistent read to MySQL. It currently runs on Intel Linux and NT. Regards, --snip Heikki Tuuri Innobase Oy Helsinki, Finland - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 using mysql++-1.7.8.tar.gz
Hi all, What's wrong with this Updating makefiles Considering target file 'Makefile'. Considering target file 'Makefile.in'. Considering target file 'Makefile.am'. Looking for an explicit rule for 'Makefile.am'. Trying pattern rule with stem 'Makefile.am'. Trying implicit prerequisite 'Makefile.am'. ... . No implicit rule for 'makefile.am' Finished prerequisites of target file 'Makefile.am' No need to remake target file 'Makefile.am' Considering target file 'Makefile.am'. . .. I only add this row before int main() #include sqlplus.hh I am using kdevelop 1.3 MYSQL 3.23.32 and Linux Suse 7.0 I add too these lines in Project/option: -I/usr/include/mysql (compile option) and /usr/local/lib/libsqlplus.a (linking option) Thanks Patrick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Not Urgent . Please Don't care. (Can't Connect to Mysql Server on 192.9.200.2 (10055))
Hello. On Sat, Feb 03, 2001 at 01:54:14AM +0200, [EMAIL PROTECTED] wrote: Dear Benjamin. I firstly very very thanks for your interest. This is my 3'rd mail with same question and you 're the first one who reply. Well, it might be due to the fact that you have a rather unusual use pattern. [...] Description: I am connecting from Visual Basic 6 to Mysql via ODBC DSN. When i made 94 sleeped connection after 94 can't connect to a server. It says : [TCX][MYODBC]Can't Connect to Mysql Server on 192.9.200.2 (10055) Is it fault of myodbc or mysql server? Is it normal. If there a maximum connection limit for process ? No. Your process is only limited by your OS. E.g. Linux defaults to a limit of 256 sockets per process. I don't know about Windows. I know but i tried it on 1 GB RAM and dual processor PIII 700 MHZ on winnt 4 with service pack 6 a. Well, your resources (e.g. memory) normally don't influence the default configuration automatically. That means, you should consult the usual Window NT resources (web pages, mailing lists?) how to change the process limit. [...] I think it is abnormal cause everyone is talking about 10.000 Web Hit. Sorry? You can handle 10.000 web hits with only one connection. i am not interested about web. it works. no problem. Well, it was your example. ;-) [...] Think a scenario : You connect via ODBC or Data Environment from VB then you get a recordset. You will show this recordset on a grid. (excel style spreadsheet.) if you use additem method , you can loop recordset and manually add rows into grid then close recordset no problem. but if you bound grid into that dao object then until program or form close it run as a sleep process. Well, that's the problem. It is usually (not only with MySQL) a good idea to block resources as short as possible. The suggested program doesn't do that. Even if the connection is idle, it blocks a connection. and if you even use 3 connection for program , if max sleep process is limited to 90 (due to your hardware configuration , but even if you use 1 gb ram it is limited to max 120) that means maximum 30 user will be execute your program. I assume that is only a parameter you have to change within NT. [...] i have a critical product(which is written in vb for end users) that needs at least 150 concurrent sleeped process to run. Well, but 150 concurrent connections may not be a problem even for NT *eg*. So, as said above, I suggest you check out the appropriate NT resources how to change the process limit (in hope that this is really the wall you hit, but it sounds so). Bye, Benjamin. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem using mysql++-1.7.8.tar.gz
Patrick Vogel writes: Hi all, What's wrong with this Updating makefiles Considering target file 'Makefile'. Considering target file 'Makefile.in'. Considering target file 'Makefile.am'. Looking for an explicit rule for 'Makefile.am'. Trying pattern rule with stem 'Makefile.am'. Trying implicit prerequisite 'Makefile.am'. ... . No implicit rule for 'makefile.am' Finished prerequisites of target file 'Makefile.am' No need to remake target file 'Makefile.am' Considering target file 'Makefile.am'. . .. I only add this row before int main() #include sqlplus.hh I am using kdevelop 1.3 MYSQL 3.23.32 and Linux Suse 7.0 I add too these lines in Project/option: -I/usr/include/mysql (compile option) and /usr/local/lib/libsqlplus.a (linking option) Thanks Patrick Hi! You should run: automake autoconf ./configure (with options of your choice) make You should use all latest GNU tools for the above, including GNU make, GNU libtool etc .. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Asking help about SQL(Select)
Dear All, Sorry for bothering everyone. I am just working with MySQL but I have faced a problem: I have a table with following problems: TableA with following columns: NameCashincome transaction_income I cannot change the form of table. If i wanna to have such output: (either cashincome or transaction_income will be filled, they will not be filled at the same time) Name Incomes which contain all data. How can I do this? e.g. Name CashincomeTransaction_income RecordA1234.00 RecordB2230.00 Output NameIncome RecordA1234.00 RecordB2230.00 Sorry for any incovenience caused. Thanks anyway. Yours sincerely, Jason Chan (Please reply to [EMAIL PROTECTED] or [EMAIL PROTECTED])
Re: Web Interface
Thanks to everyone who replied. I got a lot of people who said I should either use phpMyAdmin or webadmin. It turns out that neither will quite do what I need it to, and I just wanted to try to get any other suggestions. In particular, the former doesn't allow one to put any kind of good security on the pages s.t. a user needs a password to do things, w/o a good deal of recoding. The latter requires root access on a server, which I don't have. Does anyone have any other suggestions? There's something written in Perl called "MysqlTool". It looks good. Haven't really used it seriously yet. You can find it at: http://www.dajoba.com/projects/mysqltool/index.html Adam -- Adam Stein @ Xerox Corporation Email: [EMAIL PROTECTED] Disclaimer: All views expressed here have been proved to be my own. [http://www.csh.rit.edu/~adam/] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 constantly crash on BLOB insertions...
Huang-Ming writes: Hi! I just saw this question un-answered, so in case you already got a private answer, please just ignore. hi Tim, thanks for the prompt response which is hard to be seen with Oracle and Microsoft. sorry, i should have had studied hard the manual a year ago. regarding the error, however, would the error message be better to tell users to adjust relevant configuration than only to say "MySQL gone away"? it's misleading to some serious fault in MySQL which actually is not therein, isn't it? There is nothing serious around; it just means that the server has closed the connection to the client because the server assumes that something had gone wrong. This happens, for example, when the server notices that a client is sending packets that are out of order, or too large. Nothing crashes (the server is still running), but the connection was just closed. So actually it is very much true what the server says to the client (the error message). The problem is that there are already some situations when this error can happen, so we thought that it is better to give a short error message than give a long list of possible reasons for the error. One just needs to consult the manual in order to find out a verbose explanation for the happening and the solution. Regards, - Jani __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Jani Tolonen [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ Development Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
blob and replication questions
hi list, i am new to mysql. i have read through the reference-manual but still there are some things i could not answer myself. please help, many thanks in advance. --- mysql-reference-manual describes longblob as a blob column with a maximum length of 4294967295 characters but also says that one cant use this whole range yet. what exactly does this mean? how much can i use? --- chapter 11: "replication" doesnt mention any way of scheduling replication. it says after one configured and restarted the slave server it will connect to the master and then start replication. is there a way to schedule replication? can i start replication at specific times only? --- in chapter 11: "replication" i cannot find any information about replicating blob data (ok: is doesnt say it is NOT possible). can this be done? does anybody have experience in replicatin blob-data (largeblobs)? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
download 3.23.32
Hi we are having problem downloading MySQL 3.23.32 from your site. the error that we constantly get when trying to open the file is unable to unzip does not appear to be a valid archive. any suggestions. Kind regards Alan Ronald - This email (and any attachments) are strictly private and confidential and is intended solely for the person or organisation to whom it is addressed. It may contain legally privileged and confidential information and if you are not the intended recipient, you must not copy, disclose, distribute or take any action in reliance on it. If you are not the intended recipient please immediately delete it from your computer and notify our email Systems Administrator on 0141 400 2636 (UK) or +441414002636 (International) quoting the name of the sender and the intended recipient. It is the responsibility of the recipient to ensure that the following, opening or use of the email (and attachments) will not adversely affect the system or data. Please carry out the appropriate virus checks. All Rights Reserved. The intellectual property in this email and any attachments vest solely in The Zen Agency. The Zen Agency 151 Bath Street Glasgow 0141 400 2636 0141 400 2635
Re: About reserved words: mySQL's dirty little secret
At 7:39 PM -0700 2/4/01, Colin Faber wrote: Paul I expect to see documentation append to the copy of your book I bought 8 months ago ;-) Do you prefer tape or staples? Paul DuBois wrote: On Sun, Feb 04, 2001 at 11:32:42PM -0200, Fbio Ottolini wrote: Paul, Tomorrow they are going to add a new feature named "over the air select". Why this is not on your book? :) Ag! :-) BR, Fbio Ottolini snip -- Paul DuBois, [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: About reserved words: mySQL's dirty little secret
At 9:25 AM -0500 2/5/01, Ken Menzel wrote: Hi Paul, Will we see a new version of your VERY excellent book with MySQL 4.0? Ken I hope so, but I need to finish the projects I'm working on now, and I'm also waiting until 4.0 becomes more mature. Right now it's still in the very early stages. - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] - Original Message - From: "Paul DuBois" [EMAIL PROTECTED] To: "Rick Pasotto" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, February 04, 2001 6:49 PM Subject: Re: About reserved words: mySQL's dirty little secret At 5:45 PM -0500 2/4/01, Rick Pasotto wrote: If reserved words are such a big deal why are they not even mentioned in the DuBois book? Or if they are I haven't come across it. Certainly 'reserved' does not appear in the index. Guilty as charged. With reference to the use of `` to quote reserved words so that you can use them as identifiers, it's not mentioned because that was an addition that occurred as the book was going to press. -- Paul DuBois, [EMAIL PROTECTED] -- Paul DuBois, [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: [OFF] URL of e-business websites that use MySQL/PHP4/Apache
I've some troubles with a competitor that says to my client that an Apache/PHP4/MySQL solution on Linux is unable to produce an e-commerce website. This person proposal is ASP/M$ SQLServer on an NT 4 Server... Can you send me some URLs that illustrate the ability to an Apache/PHP4/MySQL platform to manage a simple e-commerce website: - Products Catalog - Billing system - Connection to a secure cr.card payment process Thanks in advance. -- -- Stphane Pinel Stphane, You might point out that IBM is investing US $1 billion in Linux this year, that NASA uses Linux on notebooks on the space shuttle for flexibility and stability (I lost the reference some time ago), that recently NASA switched from Oracle (far better reputation than MS-SQL already) to MySQL because they believe that "open-source software will give agencies the opportunity to get better software at a lower cost" (http://www.fcw.com/fcw/articles/2000/1204/pol-nasa-12-04-00.asp), that Apache is used on 60% of the world's web servers, and that IIS, which is used on only 20% of them, has not increased market share in three years (see http://www.netcraft.com/survey/), and that PHP has grown from one user (Rasmus Lerdorf, the inventor) to being used on over five million web sites (over half of the Apache sites) in the six years since it's birth, which implies 30% of the sites on the internet are using it (http://www.WebDevelopersJournal.com/articles/why_php.html). There's a small sample (a few hundred of the sites using PHP) listing, *including e-commerce sites*, at http://www.php.net/sites.php . Billy http://RhinoComputing.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
a user feedback about WinMySQLadmin 1.0
To whom it mat concern, Because the address ([EMAIL PROTECTED]) has a problem, i had to send this mail to you. The message turning back to me with my mail is; Subject: Returned mail: Service unavailable Date: Tue, 30 Jan 2001 23:36:27 +0100 From: Mail Delivery Subsystem [EMAIL PROTECTED] To: [EMAIL PROTECTED] The original message was received at Tue, 30 Jan 2001 23:36:24 +0100 from [212.29.65.203] - The following addresses had permanent fatal errors - "| /usr/bin/vacation -j -t0 mdomo" (expanded from: [EMAIL PROTECTED]) - Transcript of session follows - sh: vacation not available for sendmail programs 554 "| /usr/bin/vacation -j -t0 mdomo" ... Service unavailable Reporting-MTA: dns; work.mysql.com Received-From-MTA: DNS; [212.29.65.203] Arrival-Date: Tue, 30 Jan 2001 23:36:24 +0100 Final-Recipient: RFC822; [EMAIL PROTECTED] X-Actual-Recipient: RFC822; | /usr/bin/vacation -j -t0 [EMAIL PROTECTED] Action: failed Status: 5.5.0 Last-Attempt-Date: Tue, 30 Jan 2001 23:36:27 +0100 _ I hope you can understand the problem. And if you let me know the most proper mail-address for such feedback mails, i will use that address with pleasure. Now lets turn back to the point; The Winmysqladmin was active and the server was started. Then I wrote a pgm thats creating a database (CREATE DATABASE ...). As a checkpoint i put the error messages statement in my program and i saw that its created and when i try to run the pgm again, i saw the error message saying its already created. Also i created a table in this db and its ok, its created and when i try to run the same pgm, again i took the same message about my re-creation attemp. BUT at the same time i was checking (many times)the Winmysqladmin's databases tab and i couldnt see neither the db i created nor the table naturally. Coincidentially, it appeared later; I wanted to create a db not by sql statement in pgm, but explicitly at the databases page of Winmysqladmin. I tried to create a db with the same name i have created before (and couldnt see on the db page of Winmysqladmin but took the message in my pgm about its existance). Surely i couldnt create and i tried another not-existing db name, it was ok, its created and appeared on the db page of Winmysqladmin. Right at that time i saw that the former one appeared as well! Great! :) Also when i shut down the both server and service and restart them, i saw it appeared. Another point; when i want to shut down both the server and the service, server led(or lamp) is turning to red immediately, its ok...but the administrator icon doesnt disappear for a couple of minutes (in general around 3 minutes), sometimes never disappears. I found out the solution coincidentially: when i get my mouse over the icon, then it disappears immediately! If its a bug, its a very cute one! :) Maybe a little feedback , but maybe useful as well... By the way, thank you for this product. Best regards, Gulsum Ramazanoglu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 do I Move Directories
dbshare is owned by mysql with group deamon and I have run install_db "Gerald L. Clark" wrote: kentj wrote: Platform Suse 7.0, AMD 450 KIII+, 128MB Ram Linux on 10 Gig system harddrive with 45 Gig additional drive mounted as /dbshare. I have created a symbolic link in /var/lib of mysql- /dbshare. then RPM -Uhv --force MySQL*-3.23.32-1.i386.rpm to install the files from MySQL-3.23.32-1.i386.rpm MySQL-client-3.23.32-1.i386.rpm MySQL-shared-3.23.32-1.i386.rpm The folders mysql and test are placed in /dbshare and mysql.sock is also created in /dbshare along with the following error message. 010202 13:31:48 mysqld started 010202 13:31:48 /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010202 13:31:48 mysqld ended What am I missing to make this work? Privileges for the mysql user to access these directories. Who owns /dbshare? The privileges that count are the privileges of the real directory, not the symbolic link. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: a user feedback about WinMySQLadmin 1.0
bozo writes: To whom it mat concern, Because the address ([EMAIL PROTECTED]) has a problem, i had to send this mail to you. The message turning back to me with my mail is; Subject: Returned mail: Service unavailable Date: Tue, 30 Jan 2001 23:36:27 +0100 From: Mail Delivery Subsystem [EMAIL PROTECTED] To: [EMAIL PROTECTED] Hi! A valid address is : [EMAIL PROTECTED] Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How do I Move Directories
dbshare is owned by mysql with group deamon and I have run install_db "Gerald L. Clark" wrote: kentj wrote: Platform Suse 7.0, AMD 450 KIII+, 128MB Ram Linux on 10 Gig system harddrive with 45 Gig additional drive mounted as /dbshare. I have created a symbolic link in /var/lib of mysql- /dbshare. then RPM -Uhv --force MySQL*-3.23.32-1.i386.rpm to install the files from MySQL-3.23.32-1.i386.rpm MySQL-client-3.23.32-1.i386.rpm MySQL-shared-3.23.32-1.i386.rpm The folders mysql and test are placed in /dbshare and mysql.sock is also created in /dbshare along with the following error message. 010202 13:31:48 mysqld started 010202 13:31:48 /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010202 13:31:48 mysqld ended What am I missing to make this work? Privileges for the mysql user to access these directories. Who owns /dbshare? The privileges that count are the privileges of the real directory, not the symbolic link. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 do I Move Directories
You should have run install_db --user=mysql Is the mysql directory in /dbshare owned by mysql ? Are the permissions 775 ? Does mysql own the files in /dbshare/mysql ? kentj wrote: dbshare is owned by mysql with group deamon and I have run install_db "Gerald L. Clark" wrote: kentj wrote: Platform Suse 7.0, AMD 450 KIII+, 128MB Ram Linux on 10 Gig system harddrive with 45 Gig additional drive mounted as /dbshare. I have created a symbolic link in /var/lib of mysql- /dbshare. then RPM -Uhv --force MySQL*-3.23.32-1.i386.rpm to install the files from MySQL-3.23.32-1.i386.rpm MySQL-client-3.23.32-1.i386.rpm MySQL-shared-3.23.32-1.i386.rpm The folders mysql and test are placed in /dbshare and mysql.sock is also created in /dbshare along with the following error message. 010202 13:31:48 mysqld started 010202 13:31:48 /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010202 13:31:48 mysqld ended What am I missing to make this work? Privileges for the mysql user to access these directories. Who owns /dbshare? The privileges that count are the privileges of the real directory, not the symbolic link. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
need some help here...
I'm having a extremely hard time grasping the concept of multiple tables. So far, I've been using just one table when designing a database. But now I have to design a database for a trouble-ticket system for our department. I've written out the design of the tables, but the part I don't understand is how the tables relate to each other. Do I need to use foreign keys? But if I do, I thought MySQL didn't support foreign keys? BTW, I've read most of the O'rielly mSQL/MySQL book and couldn't find my answers. Just in case it matters, I'm going to have one table full of faculty info, one of staff info, one for the trouble ticket itself, and possibly one for actions performed on the trouble ticket.
One connection between Mod_Perl Mysql
Hi, am running Apache 1.3.14 on RedHat 6.2. I've also installed the most recent Mod_Perl and I'm wokring on MySQL 3.23.29a. For some reason, I can't create one stable connection between the Perl session and the MySQL. I read it is possible, and tried following instructions, but alas, nothing seems to work. Can anybody explain the steps of creating such a connection, to avoid great quantity of running MySQL processes? Thanks in advance, -Eran Boudjnah D-Net Ltd. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
character sets error
I work under WinNT with MySQLODBC cilent, and the mySQL server is installed to the linux server. I receive an error message: 'can't initialize character set 21 (path: c:\mysql\\share\charsets)'. I use the hungarian character set, and I try to put in the showed location the hungarian.conf file but the error message still appear. What have I do to solve this problem? Thanks! Leo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: need some help here...
MySQl does not support FK relationship constraints. meaning that if you put a value in a FK, it won't automatically check to make sure it's a valid value in the related table. You can, however use FK's. That is how you should related your tables. It is up to you, the developer, to make sure that no bad data gets put in them though. Cal http://www.calevans.com -Original Message- From: Chris Toth [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 9:56 AM To: MySQL List Subject: need some help here... I'm having a extremely hard time grasping the concept of multiple tables. So far, I've been using just one table when designing a database. But now I have to design a database for a trouble-ticket system for our department. I've written out the design of the tables, but the part I don't understand is how the tables relate to each other. Do I need to use foreign keys? But if I do, I thought MySQL didn't support foreign keys? BTW, I've read most of the O'rielly mSQL/MySQL book and couldn't find my answers. Just in case it matters, I'm going to have one table full of faculty info, one of staff info, one for the trouble ticket itself, and possibly one for actions performed on the trouble ticket. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: usage of distinct in a table join query?
Have you try GROUP BY? - Original Message - From: Marc Swanson [EMAIL PROTECTED] To: mysql list [EMAIL PROTECTED] Sent: Monday, February 05, 2001 9:32 AM Subject: usage of "distinct" in a table join query? Hello, I am trying to craft a query that will allow me to retrieve truly unique result elements. Here's my setup: table_1 link_field varchar(20) field1 varchar(20) field2 varchar(20) table_2 -- link_field varchar(20) field3 varchar(20) Here's what I've been trying to do (unsuccessfully): "SELECT DISTINCT t1.*,t2.field3 FROM table_1 AS t1, table_2 AS t2 WHERE t1.link_field = t2.link_field ORDER BY t2.field3" imagine these contents of the two tables: table_1 --- record 1: link_foo1 foo1 foo2 record 2: link_foo2 foo3 foo4 table_2 --- record 1: link_foo1 bar1 record 2: link_foo1 bar2 record 3: link_foo2 bar1 What I want is a query that will return only 1 entry for each "link_foo" encountered in table #2 but order the result based on the contents of "field3" from table #2 and also return the corresponding data from table #1. The query I'm running shows a number of records returned equal to the number of records in table #2... although they ARE ordered correctly. What am I doing wrong? If there's no way to do what I want I suppose I could keep a list of each item encountered and skip over the next element if it has already been encountered but that seems like a lot of extra unneccessary code. Thanks -Marc- #/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/# #Marc Swanson | \|||/ # #MSwanson Consulting | /o o\ # #Phone: (603)868-1721|-oooOooo-# #Fax:(603)868-1730| Solutions in: # #[EMAIL PROTECTED] | 'PHP'Perl # # | 'SQL'C++ # # | 'HTML 'Sh/Csh# # http://www.mswanson.com | 'Javascript# #/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/# - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Can anyone do this ?
Hi. Ok, i get it. Here is one method, but i'm afraid it may not work in mysql. select t1.name,count(*) as nb from Table1 t1, Table2 t2 WHERE t2.date BETWEEN "2001-02-04" AND "2001-02-06" AND t1.id=t2.table1_id AND t2.no_of_Items =1 AND nb = (DAYOFYEAR("2001-02-06")-DAYOFYEAR("2001-02-04")) GROUP BY t1.id; - Original Message - From: Web Depressed [EMAIL PROTECTED] To: Rus [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, February 05, 2001 12:39 PM Subject: Re: Can anyone do this ? Hi Rus, I'm not sure I follow, but the DATE column represents the dates at which I have a certain item in stock. ie (. for from 2001-02-04 - 2001-02-06 I have Item1 in stock. However I only have Item2 in stock on 2001-02-04 AND 2001-02-06). A typical application would be a car hire company: where the Items represent a particular car model. My user requests a list of all cars available from 2001-02-04 to 2001-02-06. I can therefor only return Item1 as Item2 is not available on 2001-02-05. I hope this answers your question. Thanks, -- Frank --- Rus [EMAIL PROTECTED] wrote: Can you explain what difference between dates 2001-02-04 and 2001-02-06 for item2 and 2001-02-04 and 2001-02-06 for item1? - Original Message - From: Web Depressed [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, February 04, 2001 11:41 PM Subject: Can anyone do this ? Hi, I've been trying for a while now and I can't figure out how to do the following: In regular English, I wish to show all items for which I have allocations greater than one for all days encapsulated between the user input range. User Input: --- Date_from (ie. 2001-02-04) Date_to (ie. 2001-02-06) My Tables: -- Table1 +++ | id | name | +++ | 1 | Item1 | | 2 | Item2 | +++ Table2 ++-+---+ | date | no_of_items | table1_id | ++-+---+ | 2001-02-04 | 3 | 1 | | 2001-02-05 | 2 | 1 | | 2001-02-06 | 2 | 1 | | 2001-02-04 | 2 | 2 | | 2001-02-06 | 1 | 2 | ++-+---+ Basically my user says he/she needs a list of what items are available FROM a certain date TO a certain date. I therefor need to return all items which I have at least 1 of for EACH of the dates within my users range: I have tried using BETWEEN but it fails (ie. If my user says: from 2001-02-04 to 2001-02-06, using BETWEEN MySQL returns Item2 even though I do not have Item 2 listed for 2001-02-05. Here is where I'm at: mysql SELECT t1.*, t2.* - FROM Table1 t1, Table2 t2 - WHERE t2.date BETWEEN "2001-02-04" AND "2001-02-06" - AND t1.id=t2.table1_id - AND t2.no_of_Items =1; ++---++-+---+ | id | Item | date | no_of_items | table1_id | ++---++-+---+ | 1 | Item1 | 2001-02-04 | 3 | 1 | | 1 | Item1 | 2001-02-05 | 2 | 1 | | 1 | Item1 | 2001-02-06 | 2 | 1 | | 2 | Item2 | 2001-02-04 | 2 | 2 | | 2 | Item2 | 2001-02-06 | 1 | 2 | ++---++-+---+ What I need is a query which will generate the following result: ++---++-+---+ | id | Item | date | no_of_items | table1_id | ++---++-+---+ | 1 | Item1 | 2001-02-04 | 3 | 1 | | 1 | Item1 | 2001-02-05 | 2 | 1 | | 1 | Item1 | 2001-02-06 | 2 | 1 | ++---++-+---+ Forgive me if this is actually simple and/or I haven't explained clearly. Many thanks in advance for your help. -- Frank __ Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED]
character sets error
Hi, I work under WinNT with MySQLODBC cilent, and the mySQL server is installed to the linux server. I receive an error message: 'can't initialize character set 21 (path: c:\mysql\\share\charsets)'. I use the hungarian character set, and I try to put in the showed location the hungarian.conf file but the error message still appear. What have I do to solve this problem? Thanks! Leo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
System Requirements...
What are the system requirements for installing mysql? Anand Vangipuram 414-566-6701 This message has been scanned for viruses with Trend Micro's Interscan VirusWall. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Asking help about SQL(Select)
select name,(Cashincome+transaction_income) as Income from TableA; - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 05, 2001 5:04 PM Subject: Asking help about SQL(Select) Dear All, Sorry for bothering everyone. I am just working with MySQL but I have faced a problem: I have a table with following problems: TableA with following columns: NameCashincome transaction_income I cannot change the form of table. If i wanna to have such output: (either cashincome or transaction_income will be filled, they will not be filled at the same time) Name Incomes which contain all data. How can I do this? e.g. Name CashincomeTransaction_income RecordA1234.00 RecordB2230.00 Output NameIncome RecordA1234.00 RecordB2230.00 Sorry for any incovenience caused. Thanks anyway. Yours sincerely, Jason Chan (Please reply to [EMAIL PROTECTED] or [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
Installing binary distributions in non- standard locations.
I have been trying to install 1.3.23.29-solaris 2.6 binary distribution. But as a neophyte to MySQL I cannot seem to start the client software. I have varied from the standard procedure (By necessity) to install it to a non-standard directory (/ss/mysql) so I have had to add the --defaults-file=/ss/mysql/data/my.cnf flag to the various commands. so I have successfully started the safe_mysql command with the defaults-file flag. When I type the suggested mysqladmin --defaults-file=/ss/mysql/data/my.cnf -u root -p 'password' I get an access error: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' I am confounded by this, since the same procedure for linux worked perfectly. (differing directory root.) Does this look familiar to anyone? thank you, Jack Summanen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: blob and replication questions
On Mon, Feb 05, 2001 at 03:58:37PM +0100, Lukas Gruber wrote: chapter 11: "replication" doesnt mention any way of scheduling replication. it says after one configured and restarted the slave server it will connect to the master and then start replication. is there a way to schedule replication? can i start replication at specific times only? You can't schedule it, but you could schedule a process to issue "SLAVE STOP" and "SLAVE START" commands on your slave(s). in chapter 11: "replication" i cannot find any information about replicating blob data (ok: is doesnt say it is NOT possible). can this be done? does anybody have experience in replicatin blob-data (largeblobs)? BLOB fields replicate just fine in my experience. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Newbit: ADO and MySQL/MyODBC
Hi there I use ASP and ADO 2.5 to access the data in my MySQL RDBMS. I get an error "Multiple-step error" when I try to update a recordset like the following: with rs .fields("date") = null 'timestamp datatype .fields("nOnline") = .fields("nOnline") + 1 'int datatype .update end with Any ideas?? Kind regards, Henrik Mohr - Denmark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 up data model
If you mean you link table techadress to table domains, and then billing admin adress to techadress, then i think you'r odd.. You should learn some about 'normalization', look for it on the web or in a book. I'd suggest something like this: Customer client_id clientaddr_id ..details... Domains domain_id client_id//references customer techaddr_id//references addresses billaddr_id// " adminaddr_id// " name type ...info... Adresses address_id type name addr city country .etc... If you'd like to have more than three addresses, you just add an extra table, and skip the '..addr_id' 's from domains: domainaddresses da_id domain_id address_id type This table then links the domain to n addresses. good luck, rene - Original Message - From: "Kevin O" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 05, 2001 6:31 PM Subject: Setting up data model Hello all, I've got a few questions about setting up a data model for a database I'm creating. I want to set it up to be most efficient and would like input from anyone that has the time. I'm setting up your basic customer database, except I'd like to allow for a customer within a customer option. Not everyone will have this, but for those that choose to, it will be available. Here is basically what I have: 1) I'm a web hosting company and would like for each customer to have the ability to have multiple domains under their account. (this is the easy part, just a basic customer database) 2) Each domain however will need the ability to have up to 3 addresses associated with it. For example, Administrative, Technical and Billing Contacts. Now, the question is how do I set this up to be the most efficient storage of the data? My thought is Main Customer Table | | Domain Table | | TechAddress Table-- --AdminAddress Table | | BillingAddress Table Am I way off here? I will be checking for things like if each of the addresses being entered are the same as the main address in the main customer table. I know this is very confusing. Can someone please help? Thanks, Kevin [EMAIL PROTECTED] _ Get your FREE download of MSN Explorer at http://explorer.msn.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
Install of mysql on AIX fails due to missing member shr.o in module libz.a
-Original Message- From: NELSON, GLEN Sent: Tuesday, January 30, 2001 2:10 PM To: '[EMAIL PROTECTED]' Subject: Install of mysql on AIX fails due to missing member shr.o in module libz.a From: t199k01 To: [EMAIL PROTECTED] Subject: Install of mysql on AIX fails due to missing member shr.o in module libz.a Description: I apologize for resubmitting this report, but I had sent the original last week and had not received a reply. I am trying to test mysql for my company, but can't get it installed. -- --- Previously, I was failing because module libz.a didn't exist. Per your advice, I installed zlib from gnu. Now, the module appears to be found, but it cannot locate member shr.o. The following is the screen output of the installation: Executing /fmcusr/shared/kshrc ... exec(): 0509-036 Cannot load program ./bin/my_print_defaults because of the following errors: 0509-150 Dependent module /usr/local/lib/libz.a(shr.o) could not be loaded. 0509-152 Member shr.o is not found in archive WARNING: The host 'ddcux6' could not be looked up with resolveip. This probably means that your libc libraries are not 100 % compatible with this binary MySQL version. The MySQL deamon, mysqld, should work normally with the exception that host name resolving will not work. This means that you should use IP addresses instead of hostnames when specifying MySQL privileges ! Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables exec(): 0509-036 Cannot load program ./bin/mysqld because of the following errors: 0509-150 Dependent module /usr/local/lib/libz.a(shr.o) could not be loaded. 0509-152 Member shr.o is not found in archive Installation of grant tables failed! How-To-Repeat: run mysql_install_db Fix: unknown Submitter-Id:[EMAIL PROTECTED] Originator: Glen Nelson Organization: FMC Corporation MySQL support: none Synopsis: Install of mysql on AIX fails due to missing member shr.o Severity:non-critical Priority:medium Category:mysql Class:sw-bug Release:mysql-3.23.31 (Official MySQL binary) Environment: System: AIX ddcux6 3 4 000D36AD4C00 AIX version 4.3.3.0 Some paths: /usr/bin/perl /usr/bin/make Compilation info: CC='gcc' CFLAGS='-O3 -mcpu=powerpc -Wa,-many -fomit-frame-pointer' CXX='c++' CXXFLAGS='-O3 -mcpu=powerpc -Wa,-many -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx 1 bin bin 19 Sep 14 17:04 /lib/libc.a - /usr/ccs/lib/libc.a lrwxrwxrwx 1 bin bin 19 Sep 14 17:04 /usr/lib/libc.a - /usr/ccs/lib/libc.a Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --disable-shared Perl: This is perl, version 5.005_03 built for aix - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
newbie: problem with select in (select)
Hi again If I try the following on my MySQL DB, I get an error: select user_id from tblUser where user_id in (select user_id from tblUserLink where group_id = xx) xx is an integer defining which group_id we want info on (mediumint(9)) user_id in tblUser and tblUserLink is also defined as mediumint(9). tblUserLink is used to connect tblUser with tblGroup in a many-to-many relationship. Why doesn't it work? Please help. Thanks in advance, and kind regards, /Henrik Mohr - Denmark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Can anyone do this ?
Ooops, I forgot to notice that you required consequetive days. This query works for me: select T1.*, T2.*, count(T2.id) as c, concat(T2.id,T2.d) as x from table1 as T1, table2 as T2, table 2 as T3 where T1.id=T2.id and T2.id=T3.id and T2.d='2001-02-04' and T2.d='2001-02-06' and T3.d='2001-02-04' and T3.d='2001-02-06' group by x having c=3; Uglier, but seems to work ok. Of course, you'll have to change the having c=3 part to refect the number of days in the interval. Or maybe there is a mysql date subtraction routine for that... What I need is a query which will generate the following result: ++---++-+---+ | id | Item | date | no_of_items | table1_id | ++---++-+---+ | 1 | Item1 | 2001-02-04 | 3 | 1 | | 1 | Item1 | 2001-02-05 | 2 | 1 | | 1 | Item1 | 2001-02-06 | 2 | 1 | ++---++-+---+ _ 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: Setting up data model
If you mean you link table techadress to table domains, and then billing admin adress to techadress, then i think you'r odd.. You should learn some about 'normalization', look for it on the web or in a book. No, I did not mean to link the tables like that. I simply wanted the Domain table to be linked to each address table. But, thanks to your example below, I see that my solution was wrong. I do have a few questions about it though' How would I insert data into all of the tables from one SQL statement? Or would I have to have separate statements to insert data into each individual table? Thanks, Kevin _ Get your FREE download of MSN Explorer at http://explorer.msn.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: newbie: problem with select in (select)
go to www.codecity.com mysql just does not support in :((( it's good, but far for 'sql compliant'... gl rene - Original Message - From: "Henrik Lebtien Mohr" [EMAIL PROTECTED] To: "MySQL List" [EMAIL PROTECTED] Sent: Monday, February 05, 2001 7:46 PM Subject: newbie: problem with "select in (select)" Hi again If I try the following on my MySQL DB, I get an error: select user_id from tblUser where user_id in (select user_id from tblUserLink where group_id = xx) xx is an integer defining which group_id we want info on (mediumint(9)) user_id in tblUser and tblUserLink is also defined as mediumint(9). tblUserLink is used to connect tblUser with tblGroup in a many-to-many relationship. Why doesn't it work? Please help. Thanks in advance, and kind regards, /Henrik Mohr - Denmark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Suggestion for new linux box
Chuck Carson [EMAIL PROTECTED] wrote: Without a doubt SuSE linux. I'd second that. 7.1 is either out or due out any day now with a choice of kernels (I'd be inclined to put 2.4 on a development box). I've found that the (free for 90 days) support simply gets better, as does the documentation. Simply stunning. -- ** Marx: "Why do Anarchists only drink herbal tea?" Proudhon: "Because all proper tea is theft." ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[What is the password for standard/gerneric install]
Description: Trying to determine the default password(s) for user= root and user - mysql this is a generic install i.e. following the instructions in the mysql/INSTALL-BINARY...it states to be certain to change the root password using the commands ./bin/mysqladmin -u root -p password 'new-password' ./bin/mysqladmin -u root -h genie -p password 'new-password' what "password" are they asking for? since i never entered in one. How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:[EMAIL PROTECTED] Organization: MySQL support: [none ] Synopsis: password Severity: Priority: Category: mysql Class: Release: mysql-3.23.29a-gamma (Source distribution) Environment: System: SunOS genie 5.8 Generic_108528-04 sun4u sparc SUNW,Ultra-1 Architecture: sun4 Some paths: /opt/local/bin/perl /usr/ccs/bin/make /usr/ncbi/bin/gmake /netopt/GNU/compilers/bin/gcc /netopt/forte6/bin/cc GCC: Reading specs from /netopt/GNU/compilers/lib/gcc-lib/sparc-sun-solaris2.8/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='-O6 -fomit-frame-pointer -mcpu=v8 -Wa,-xarch=v8plusa' CXX='gcc' CXXFLAGS='-O6 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mcpu=v8 -Wa,-xarch=v8plusa' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 11 Jan 31 15:58 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1126652 Mar 9 2000 /lib/libc.so.1 lrwxrwxrwx 1 root root 11 Jan 31 15:58 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1126652 Mar 9 2000 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/mysql --with-extra-charsets=complex --disable-shared --enable-assembler Perl: This is perl, version 5.005_03 built for sun4-solaris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Restarting a slave didn't work
Description: Restarting doesn't connect to the master. How-To-Repeat: mysql restart. show slave status. Read server log. Fix: The master's file name still had a newline. Index: noris.38/sql/slave.cc --- noris.38/sql/slave.cc Thu, 25 Jan 2001 07:35:47 +0100 smurf (database_mysql/O/b/39_slave.cc 1.9.1.2.1.1.1.1.1.2 664) +++ noris.38(w)/sql/slave.cc Mon, 05 Feb 2001 21:16:57 +0100 smurf +(database_mysql/O/b/39_slave.cc 1.9.1.2.1.1.1.1.1.2 664) @@ -513,7 +513,7 @@ goto error; } -mi-log_file_name[length]= 0; // kill \n +mi-log_file_name[length-1]= 0; // kill \n char buf[FN_REFLEN]; if(!my_b_gets(mi-file, buf, sizeof(buf))) { Submitter-Id: submitter ID Originator:Matthias Urlichs Organization: MySQL support: licence Synopsis: Restarting a slave didn't work Severity: serious Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.32 (noris network MySQL) Environment: System: Linux play.smurf.noris.de 2.4.0s-noris-t5-2 #58 SMP Wed Jul 19 10:24:19 CEST 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i686-pc-linux-gnu/2.95.3/specs gcc version 2.95.3 19991030 (prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='-DTHREAD_SAFE_CLIENT -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Jun 8 2000 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x 1 root root 4118299 Sep 20 1999 /lib/libc-2.1.2.so -rwxr-xr-x 1 root root 4123003 Jun 8 2000 /lib/libc-2.1.3.so -rw-r--r-- 1 root root 19203634 Jun 8 2000 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Jun 8 2000 /usr/lib/libc.so -rwxr-xr-x 1 root root 2042654 Oct 27 17:09 /usr/lib/libc-client.a Configure command: ./configure --prefix=/usr --with-debug --enable-shared --without-mit-threads --libexecdir=/usr/sbin --localstatedir=/var/mysql --enable-thread-safe-client --sysconfdir=/etc --datadir=/usr/share --enable-large-files --without-readline --with-mysqld-user=mysql --with-unix-socket-path=/var/run/mysql.socket --enable-strcoll '--with-comment=noris network MySQL' --with-docs --with-bench --without-berkeley-db --without-bench - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Newbit: ADO and MySQL/MyODBC
Henrik Lebtien Mohr wrote: Hi there I use ASP and ADO 2.5 to access the data in my MySQL RDBMS. I get an error "Multiple-step error" when I try to update a recordset like the following: with rs .fields("date") = null 'timestamp datatype .fields("nOnline") = .fields("nOnline") + 1 'int datatype .update end with Any ideas?? Kind regards, Henrik Mohr - Denmark There is no server-side cursor handling on mysql so unless you are using something other than MyODBC to emulate cursors you must treat all recordsets as static. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 install mysql on Linux(debian) (fwd)
this came up on the lists a while ago. Asked our sysadmin to answer it so it took a while sorry. Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 -- Forwarded message -- Date: Mon, 5 Feb 2001 11:26:57 -0800 From: Michael J. Micek [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: how to install mysql on Linux(debian) On Fri, Feb 02, 2001 at 02:45:40PM +0100, DESERT Anthony wrote: HI! I'm new on the mailing list and I would to know how install mysql on Linux. Moreover, if someone could explain me how to recognize this package by php4, I would be the most happy boy in the world. Excuse my english but I'm french and I'm 19 years old. You imply in the subject that you are using Debian. Try: apt-get install mysql-server php4-mysql If it doesn't work, ask on the debian-user (or debian-french, if English is painful) mailing list. Or report it as a bug, see: http://www.debian.org/Bugs/Reporting -- Michael J. Micek, CyberStrategies, Inc. sysadmin. [EMAIL PROTECTED] PGP signature
Port 3306
I'm new to MySQL, this may be a simple question; How do I turn off listen on port 3306?, I don't want to serve MySQL on the net, I only need it for local (server side) access. Can someone point to docs or notes dealing with this issue. thanks, Gus Constan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Port 3306
What OS? If Linux or *BSD, they have firewall software (ipchains on linux, don't recall what it is on BSD) I'm new to MySQL, this may be a simple question; How do I turn off listen on port 3306?, I don't want to serve MySQL on the net, I only need it for local (server side) access. Can someone point to docs or notes dealing with this issue. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
UPDATE using other table
Is there a way to update a column of a table using values from other tables something like update table1 set table1.column1=table2.column1 where table1.column2=table2.column1 -- Laurent Oget, Ph.D. [EMAIL PROTECTED] Senior Engineer Zvolve Systems Inc http://zvolve.com Chercheur Associ Liafa http://liafa.jussieu.fr - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
query questions
Hi all, I have a few questions about query structure. 1. COUNT(*) Is there anything wrong with using SELECT COUNT(*) FROM bleah or should I be using SELECT COUNT(someField) FROM bleah 2. Is two queries a lot less efficient than one? Background: I have a table with about 20 fields of business Information. How much information needs to be displayed depends on what "packageID" the business has. So, if I look at all the business is one category, I may get 20,000 records returned. However, only 10 of those may need all twenty fields returned. Currently I'm using one query, SELECT * FROM business WHERE categoryID='$categoryID' LIMIT $pageStart, $pageEnd //this is to only return five records per page But in one case, where I have to join two tables, the temporary table it creates is too big. Would it be a lot slower to say: SELECT * FROM business WHERE categoryID='$categoryID' packageID='1' LIMIT $pageStart, $pageEnd Display these results, using a counter to keep track of how many are returned (in case less than 5 are) Then do another query SELECT (here list the fields necessary) FROM business WHERE categoryID='$categoryID' packageID='2' LIMIT $counter+$pageStart, $pageEnd Hope this makes sense. Anna
Re: Port 3306
fwcmd=/sbin/ipfw... on BSD usage like so ${FWCMD} add deny all from any to any via ${oif} Have to make a new kernel to support ipfw though cheers, mikel [EMAIL PROTECTED] wrote: What OS? If Linux or *BSD, they have firewall software (ipchains on linux, don't recall what it is on BSD) I'm new to MySQL, this may be a simple question; How do I turn off listen on port 3306?, I don't want to serve MySQL on the net, I only need it for local (server side) access. Can someone point to docs or notes dealing with this issue. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Port 3306
Anyone know a good ipchains rule to close this port to the outside world? I haven't dabbled in forewalling yet... i use Immunix, a RedHat 6.2 derivative. I recommend it if you like RedHat: www.immunix.org. Has stack overflow protection so those pesky overflow bugs in wu-ftp no longer affect your system... johnny p. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 2:46 PM To: Gus Constan Cc: [EMAIL PROTECTED] Subject: Re: Port 3306 What OS? If Linux or *BSD, they have firewall software (ipchains on linux, don't recall what it is on BSD) I'm new to MySQL, this may be a simple question; How do I turn off listen on port 3306?, I don't want to serve MySQL on the net, I only need it for local (server side) access. Can someone point to docs or notes dealing with this issue. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
update log sequence
I'm running mysql with --log-update=update_log with no extension, so every time I flush the logs I get the next sequential number appended as an extension to the new update_log file. If I flush the logs regularly every day, that sequence number will continue to grow - is there any way to reset the update_log sequence number back to .000? How big will it grow? Will it ever recycle itself? TIA. Hardy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Simple question
Hello, I always wanted a gui interface to use on my win 98 pc to connect to mysql, and create/edit tables. However, i always get an access denied error, saying I'm not allowed to connect to the mysql server. However, via telnet, I am fine. The support for the software sucks, and all the other programs I have tried suck, don't work, or are in german. What gui interface is good to connect to a mysql server to create/edit db's/tables, and if you use it, how in the world do you connect? I can connect to the server via telnet. Just fine. But via the software, I get permission denied. Any way I can set it up on my server to allow such a connection out of telnet? Thanks Joel
Re: Multiple AND on many-many-table.
Steve Ruby wrote: Does anybody know what is the fastest way to run a large multiple AND type query on a many-many table and the least memory hungry. For example if I have create table test (id int, value int); which has many-to-many on id, and value I want to do a select like select id from test where id in (select id from test where value in (1,2,3) and id in (select id from test where value in (4,6,7) and id in (select id from test where value in (1,6,25) So I must return users that qualify for at least one value in several lists, obviously this is somewhat easy with subselects... Without subselects I'm doing this, can anybody tell me of a better way? create table temp (id int not null, key (id)) type=heap; insert into temp select id from test where value in (1,2,3); insert into temp select id form test where value in (4,6,7); insert inot temp select id from test where value in (1,6,25); select id from temp, count(*) as numlines from temp group by id having numlines = 3; drop table temp; there will be anywhere between 1 and 10 of the above lists for this query so then I return the qulified useres by doing this on the heap table where the having part is equal to the number of lists that were checked. Obviously the temp table can get very large depending the query, currently this seems pretty fast, but I'm concerned that it will blow up on me as I get more id values anybody know a better way? A self join comes to mind but if there are many users and say 10 questions then the length of the self join result before the WHERE is userlines^10 which can be a very big number. Not knowing how HAVING is optimized i've decided for now to go with one table per question (each of the ANDs) and do a join (max of 10way) against a temp table for each question... still doesn't sound like the best route but it will have the same amount of data in it as if I did one big table and seems like it would be quicker to update the keys on the smaller tables better ideas appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Port 3306
Would be easier to play with the grant tables and allow access from localhost only... Best regards, -Eran "johnny p." wrote: Anyone know a good ipchains rule to close this port to the outside world? I haven't dabbled in forewalling yet... i use Immunix, a RedHat 6.2 derivative. I recommend it if you like RedHat: www.immunix.org. Has stack overflow protection so those pesky overflow bugs in wu-ftp no longer affect your system... johnny p. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 2:46 PM To: Gus Constan Cc: [EMAIL PROTECTED] Subject: Re: Port 3306 What OS? If Linux or *BSD, they have firewall software (ipchains on linux, don't recall what it is on BSD) I'm new to MySQL, this may be a simple question; How do I turn off listen on port 3306?, I don't want to serve MySQL on the net, I only need it for local (server side) access. Can someone point to docs or notes dealing with this issue. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Problem with update logging under Solaris
That log rotation script smells like the culprit to me. Exactly what is it doing? If it is clipping the file in a way that doesn't let MySQL reset the file pointer when you do the flush logs command, you could be max-ing the file out to its ulimit. Cheers, Kent - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
16 Index Table Limit
Is there a way to define more than 16 btrees per table? Can this index limit be increased to 32 or more? It's a static database that is massively updated once or twice a year so update performance is not the issue, rather speed of queries. Please respond to [EMAIL PROTECTED] because I am not subscribed to the list. 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: need some help here...
Just my opinion, but I prefer numeric keys that the users *can't* see, to alpha keys that the users can see: 1. numeric keys are faster 2. using numeric keys that the user can't see allows you to open up(for UPDATE) ALL the fields that the user can see including a field like School Name. Problem with alpha School Name: If you allow the users to change the school name, you'd have to change *ALL* occurrences of the old school name to the new school name - in all tables/rows that reference the old school name - could be a big programming effort. If you don't allow the users to change the school name, they might be unhappy - or maybe you allow users to submit a form saying they want to change school name from a to b, and you write a program which goes through the database changing every occurrence of a to b. Again, a lot of work, and users who are probably unhappy. Solution: Instead of having the School Name be your primary key, have a field called school_id that the users can't see or update - once assigned to a school, that school_id is the primary key to that school's info forever. If another table/record needs to refer to a particular school, you store the school_id in that table/record, instead of storing the school name. Since the users can never update the school_id, you don't have to worry about writing extra code to update all the occurrences of a to b - you can then allow users to update the school name field without affecting the key - the school name is just another data field. This may not be the best example for me to demonstrate why I think numeric keys are better - maybe in this case the School Name never changes for any of the schools. But if it could change, then numeric keys could be the answer. MySQL auto-increment fields are great for this, and Oracle has a similar type of field called a "sequence". Where it makes sense, my preference is to use an auto-increment INTEGER field as the primary key to a table. Keeping the numeric keys used for basic retrieval separate from the user viewable/updatable fields makes for a smaller, less-complex, and more flexible program. Again, just my opinion. HTH. -- Hardy Merrill Mission Critical Linux, Inc. http://www.missioncriticallinux.com John Jensen [[EMAIL PROTECTED]] wrote: Think of the tables in your database as linked sets. I have a college database where school description as info associated in three other tables, allowing one school description, one or more contacts, requirements for one or more programs, and each program has one or more degrees associated, in the last table. In each table, the School name is replicated, serving as the primary key in only the first. The primary key of the second is replicated in the third, and so on. Only degrees have a number as the key, with School name and the key of the previous table entered as fields, to link everything together. How you use tables will be defined by how your data needs to be organized. Understanding your data needs is your first step. On 5 Feb 2001, at 10:55, Chris Toth wrote: I'm having a extremely hard time grasping the concept of multiple tables. So far, I've been using just one table when designing a database. But now I have to design a database for a trouble-ticket system for our department. I've written out the design of the tables, but the part I don't understand is how the tables relate to each other. Do I need to use foreign keys? But if I do, I thought MySQL didn't support foreign keys? BTW, I've read most of the O'rielly mSQL/MySQL book and couldn't find my answers. Just in case it matters, I'm going to have one table full of faculty info, one of staff info, one for the trouble ticket itself, and possibly one for actions performed on the trouble ticket. John Jensen 520 Goshawk Court Bakersfield, CA 93309 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Hardy Merrill Mission Critical Linux, Inc. http://www.missioncriticallinux.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: Arabic character set
Hi, am having the exact same problem with Hebrew... Best regards, -Eran medianova wrote: Hi, we are setting up an Arabic web site using PHP with MySQL 3.23.22. Our problem is that we can not sort data correctly when retreiving it from Arabic text fields. This seems to be a character set problem. Has anyone any idea about using the Arabic character set with MySQL? Many thanks. Ghaleb - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Simple question
Joel Holtzman wrote: Hello, I always wanted a gui interface to use on my win 98 pc to connect to mysql, and create/edit tables. However, i always get an access denied error, saying I'm not allowed to connect to the mysql server. However, via telnet, I am fine. By default MySQL server allows only connections from localhost. This is prorably what you do: use telnet to login into unix box and then use mysql command line client there. If you try to connect from some other computer you of course SHOULD get access denied error. This is security. To allow this other computer to connect read the manual and especially about command "GRANT". -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Newbit: ADO and MySQL/MyODBC
On Mon, Feb 05, 2001 at 01:36:50PM -0700, Steve Ruby wrote: Henrik Lebtien Mohr wrote: Hi there I use ASP and ADO 2.5 to access the data in my MySQL RDBMS. I get an error "Multiple-step error" when I try to update a recordset like the following: with rs .fields("date") = null 'timestamp datatype .fields("nOnline") = .fields("nOnline") + 1 'int datatype .update end with There is no server-side cursor handling on mysql so unless you are using something other than MyODBC to emulate cursors you must treat all recordsets as static. It _ought_ to be possible to persuade ADO to persaude the ODBC driver manager to enable the use of the standard ODBC cursor library for that connection. No idea how though. Tim. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Query Help
Hello, I have a table of 26 million rows that I need to query. The table is a keywords database with the keyword and a pointer to what page it came off of. (pageid|keyword) The problem is that when I use the following query is the group by make the query take about 14 seconds to do. However, if I remove the group by portion it finishes the query in less then .10. Here is the query: SELECT count(pageid) as n, pageid FROM keywords left join deleted_keywords on keywords.keyid = deleted_keywords.keyid where deleted_keywords.keyid is null and (keyword = 'Big' OR keyword = 'Brown') group by pageid having n = 2 limit 100; I need to be able to query the database and only return pageid's of pages that have every word on it. The left join is used so that I do not have to delete from the database all day, I just do a flush once a day in the wee morning hours. This table gets queried about 600 times a second, so having a 14 second query creates such a backlog that the system becomes unusable. Any help would be really appreciated. Thanks PS - keyword is an indexed feild. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
query over CD-ROMs?
Hi, Can MySQL do the queries on the databases stored in the CD-ROM? For example, when switching data CD-ROMs, is it necessary to shutdown mysql server, and restarting server after mounting another CD-ROM? Thanks in advance. Sincerely, Kuokai - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: query over CD-ROMs?
Kuokai Shyu wrote: Hi, Can MySQL do the queries on the databases stored in the CD-ROM? For example, when switching data CD-ROMs, is it necessary to shutdown mysql server, and restarting server after mounting another CD-ROM? Thanks in advance. Sincerely, Kuokai I assume if you issue "flush tables;" or "mysqladmin flush-tables" between CD's you should be okay as long as nothing tries to run a query while you have no CD mounted. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Insert into blob
Hi, I am having some problems inserting data into a blob field, everything works fine but if I use any HTML and try to insert it, it doesn`t work. So in short is there something I should be doing to allow HTML to go into a text blob? I am using PHP if that helps. TIA Ade - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re[2]: Serious MySQL internal deadlock
Hi, unfortunately I can't set up a scenario that easily reproduces the problem. The last lockups happened on saturday and today (monday). What I can confirm is: 1. It doesn't seem to be a slave related problem. During the last two lockups I checked the master as well as the slave statuses, all were in sync. I then issued 'slave stop' on both slaves, killed the master (TERM), restarted it and then issued 'slave start' on both slaves then continued syncing just fine. 2. The lockup always happens when there's a concurrent insert and a query. Today I just looked at some performance statiststics (a web page with 6 generated performance graphics) when the lockup occured. 5 of the 6 graphics were complete, the last one didn't complete and the database lockup was back again. What I could do would be to send you the database schema and some of the php report scripts. Fortunately I managed today to react fast to retrieve the process list (attached). Looking at it, could it be that the problem occurs when a query is processed on a table and more than one insert to the same table is pending? The termination of id 584 didn't help. All further inserts were stuck in state 'System lock' (all but 1) or 'Opening table' (1, this was the successor of id 2 which I killed to test what would happen after a reconnect) and all further queries were stuck in state 'Opening tables'. As a remainder: I already tried mandatory write locks for the inserters and mandatory read locks for the queriers which didn't help. I didn't check, if more than one database is affected by the lockup. On 04-Feb-2001 Sinisa Milivojevic wrote: Peter Zaitsev writes: Hello Andreas, Thursday, February 01, 2001, 7:42:31 PM, you wrote: I must confirm the problem with table locks. Mysql realy may deadlock sometimes, and the funny thing is the solution to this case is to kill the oldest locked thread waiting this condition - afterwards everything resolves. So this may mean something like broadcast is lost sometimes (?) Hi! I guess we may sound to be obnoxious, but can you make a repeatable case out of it ?? d Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team Andreas Steinmetz D.O.M. Datenverarbeitung GmbH +-+---+---++-++- ---+ --+ | Id | User | Host | db | Command | Time | State | Info | +-+---+---++-++- ---+ --+ | 1 | logdaemon | localhost | syslog | Sleep | 17 | | NULL | | 2 | logdaemon | 10.1.1.3 | syslog | Query | 54 | System lock | INSERT INTO pcp (time,host,cpu_user,cpu_nice,cpu_sys,cpu_idle,mem_used,mem_ free,mem_shared,mem_cache | | 3 | logdaemon | 10.1.1.6 | syslog | Query | 43 | Opening table | INSERT INTO pcp (time,host,cpu_user,cpu_nice,cpu_sys,cpu_idle,mem_used,mem_ free,mem_shared,mem_cache | | 4 | logdaemon | 10.1.1.4 | syslog | Sleep | 16 | | NULL | | 5 | logdaemon | 10.1.1.7 | syslog | Sleep | 17 | | NULL | | 7 | logdaemon | 10.1.1.2 | syslog | Sleep | 17 | | NULL | | 14 | replicate | 10.1.1.2 | NULL | Binlog Dump | 176368 | Waiting for upda te | NULL | | 15 | replicate | 10.1.1.6 | NULL | Binlog Dump | 176358 | Waiting for upda te | NULL | | 519 | dbmaster | 10.1.1.4 | syslog | Query | 0 | NULL | show processlist | | 584 | logreader | 10.1.1.4 | syslog | Query | 54 | Sending data | select
Replication info in master.info corrupted in database startup
Description: Replication master info seems to get corrupted when the database is restarted after a shutdown master.info after shutdown master-bin.001 25699 master username password 3306 60 master.info after startup - note the blank line master-bin.001 25699 master username password 3306 60 slave my.cnf [mysqld] master-host=master master-user=username master-password=password replicate-do-db=testdb server-id=16 master my.cnf [mysqld] log-bin server-id=8 binlog-do-db=testdb hopefully I'm not doing something wrong :) How-To-Repeat: shutdown database - start database - check var/slave.err and it says 010206 10:10:02 Slave: reconnected to master 'username@master:3306',replication resumed in log 'master-bin.001 ' at position 0 010206 10:10:02 Error reading packet from server: Could not find first log (read_errno 0,server_errno=65535) there is a new line after 'master-bin.001 but before the closing ' Fix: Submitter-Id: submitter ID Originator:Michael Dean Organization: MySQL support: none Synopsis: Replication info in master.info corrupted in database startup Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.32 (Source distribution) Server: /usr/local/bin/mysqladmin Ver 8.14 Distrib 3.23.32, for sun-solaris2.6 on sparc Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.32 Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 8 hours 33 min 56 sec Threads: 2 Questions: 62 Slow queries: 0 Opens: 26 Flush tables: 1 Open tables: 20 Queries per second avg: 0.002 Environment: System: SunOS pegasus 5.6 Generic_105181-15 sun4m sparc SUNW,SPARCstation-10 Architecture: sun4 Some paths: /usr/local/bin/perl /usr/ccs/bin/make /usr/local/bin/gmake /usr/local/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.6/2.7.2.3/specs gcc version 2.7.2.3 Compilation info: CC='gcc' CFLAGS='-O6' CXX='gcc' CXXFLAGS='-O6 -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: -rw-r--r-- 1 bin bin 1607628 Jun 28 1999 /lib/libc.a lrwxrwxrwx 1 root root 11 Jun 10 1995 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 1014020 Jun 28 1999 /lib/libc.so.1 -rw-r--r-- 1 bin bin 1607628 Jun 28 1999 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Jun 10 1995 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 1014020 Jun 28 1999 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/web/server/mysql --with-low-memory --enable-assembler Perl: This is perl, version 5.004_04 built for sun4-solaris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
any recommendations
any recommendations for jdbc drivers running red hat? which version of red hat should i install - 6.2 or 7? thx for advice dan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 it a bug???
I have been using MySQL for ecommerce work for quite some time. One problem that just recently arose was a duplicate key error during db restoration. The culprit lies in a table which has an auto_incremented, not null defined integer field called "id". There is an entry which was adjusted, by me, to have an "id" of 0 (instead of 1). When mysql attempts to restore this table, after a backup, it complains that the entry (which previously had the "id" of 0) now has an "id" of 72, and is invalid as there already is an entry with an id of 72. Basically it seems that restore cannot allow for a zero value, if the field is an auto_incremented, not null primary key. This seems like a serious problem, since many ecommerce table designs use a zero value in such a table to represent a catalog base. Is there any solution in mysql? Michael SCWD - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
slow queries with BLOBS
Description: Queries to a table with BLOBs are very slow. I query select id,name,lator,lonor,latpp,lonpp,width,height from segments order by name The table is defined as: create table segments ( id int not null auto_increment primary key, name char(100) unique, scale int not null, dpi int not null, width int not null, height int not null, lator double, lonor double, map mediumblob, latpp double, lonpp double, index(id), index(name)); How-To-Repeat: try the select statement Fix: ? Submitter-Id: submitter ID Originator:Andrej Andrejko [EMAIL PROTECTED] Organization: MySQL support: none Synopsis: slow queries with BLOBS Severity: Priority: Category: mysql Class: Release: mysql-3.23.21-beta (Source distribution) Server: /usr/bin/mysqladmin Ver 8.7 Distrib 3.23.21-beta, for redhat-linux-gnu on i386 TCX Datakonsult AB, by Monty Server version 3.23.21-beta-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 2 days 9 hours 37 min 8 sec Threads: 2 Questions: 5700 Slow queries: 98 Opens: 22 Flush tables: 1 Open tables: 8 Queries per second avg: 0.027 Environment: System: Linux andrej 2.2.16-17smp #1 SMP Wed Jul 26 15:53:36 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 2724 (experimental) Compilation info: CC='gcc' CFLAGS='-O2 -march=i386 -mcpu=i686' CXX='c++' CXXFLAGS='-O2 -march=i386 -mcpu=i686' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 14 Aug 5 2000 /lib/libc.so.6 - libc-2.1.91.so -rwxr-xr-x1 root root 4615653 Jul 25 2000 /lib/libc-2.1.91.so -rw-r--r--1 root root 22294328 Jul 25 2000 /usr/lib/libc.a -rw-r--r--1 root root 178 Jul 25 2000 /usr/lib/libc.so Configure command: ./configure i386-redhat-linux --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --includedir=/usr/include --libdir=/usr/lib --libexecdir=/usr/libexec --localstatedir=/var --sharedstatedir=/usr/com --mandir=/usr/share/man --infodir=/usr/share/info --without-debug --without-readline --enable-shared --with-extra-charsets=complex --without-bench --localstatedir=/var/lib/mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --enable-assembler --with-mysqld-user=mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Get 'yes', 'no', or 'either' query ?
Hi. Hey I have been using a query in a search with prioritized criteria. In five different qualification fields, the first one filled in would produce the specific search. Name, City, Zip, (C)enter or (I)ndividual... If name city empty and zip filled in, all that zip would appear. No problem. Now I have a situation where I do not want *all* zips to appear but only those belonging to either (C)enter *or* (I)ndividual. That is still no problem. That is simple 'zip' *and* 'type'. But now, if 'type' can be *either* (C) or (I), and we want to see *all* the zips, I get lost. It seems like it should be simple but I cannot make a third option of the input form to look for *either* in the same query. This is to be done for 3 out of the 5 fields in the same input form. I could probably do it with *lots* of if/thens but I'd rather not if possible otherwise. Can someone suggest something. Thanks much, in advance. Floyd Baker -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 -u root WITHOUT password !
No! Check out skip grants in the manual. - Original Message - From: "Nicolas GREGOIRE" [EMAIL PROTECTED] To: "RENAULT Laurent" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, February 05, 2001 19:19 Subject: Re: mysql -u root WITHOUT password ! RENAULT Laurent a crit : I don't have mySQL root password ! Is the solution do a backup of databases and cleanup mysql install and re-install it ? If you have Unix root access, you can edit the table where is stored the encrypted password, and put a new one ... You can too re-install MySQL Nicob - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Insert into blob
There's a function in php that allows you to escape strings before it is submitted to mysql. Check it out in the PHP manual. - Original Message - From: "Rus" [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, February 06, 2001 7:48 Subject: Re: Insert into blob Check text for special symbols and use " in your query (f.e. ... blobfield="text") - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 06, 2001 2:14 AM Subject: Insert into blob Hi, I am having some problems inserting data into a blob field, everything works fine but if I use any HTML and try to insert it, it doesn`t work. So in short is there something I should be doing to allow HTML to go into a text blob? I am using PHP if that helps. TIA Ade - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: System Requirements...
It will run on most computers of today. Question is what system have you got/want, what are you going to use it for and what is the expected volume of information? - Original Message - From: "Vangipuram, Anand" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 06, 2001 0:31 Subject: System Requirements... What are the system requirements for installing mysql? Anand Vangipuram 414-566-6701 This message has been scanned for viruses with Trend Micro's Interscan VirusWall. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
WEB to remote MySql server
Hello, I would just like to ask the list's members of this setup: We have rented a Win2000 web server in the US with a 50GB transfer/month in the internet. The server currently holds our site's asp web files, SMTP/POP server and MS Access database files. The Access files holds the list of users of our asp pages and allowed email users. Our web application presents a login form which is checked against the list of users in the database. Everytime a member logs in or signup, the Access database will be used. Over here in the Philippines, I have several servers each more powerful than the one in the US except that our internet connection is only 128kbps with burst of up to 256kbps. I plan to distribute the load of the US server by moving some of the services to our local facilites. Will there be connection problems if I move the database to a MySql server to our local site an still retain the web server in the US? Or is it better to have MySql running in the US server and have a duplicate or slave MySql server here in our local site. I also plan to move the email servers here and email users will also be checked against the database. Thanks in advance. * Jonor Lacuesta Systems Administrator Philippinemail.com "Send free postal letters to the Philippines FREE" http://www.philippinemail.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: why mysql eat my memory over 1G?
olivefan wrote: why mysql eat my memory over 1G?Please help me!Thank you!!! server1:DELL6300,4cpu,4G memory.solaris5.7 for X86 . mysql start command:nohup /usr/local/bin/safe_mysqld -O key_buffer=128M -O table_cache=512 -O sort_buffer=128M -O record_buffer=128M -O max_connections=999 -O wait_timeout=5000 use "top" show: last pid: 26041; load averages: 6.89, 9.39, 10.01 13:27:36 64 processes: 59 sleeping, 2 running, 3 on cpu CPU states: 0.8% idle, 68.1% user, 31.1% kernel, 0.0% iowait, 0.0% swap Memory: 4032M real, 557M free, 1787M swap in use, 3602M swap free PID USERNAME THR PRI NICE SIZE RES STATE TIMECPU COMMAND 2838 root 147 200 1432M 1317M cpu1 62.1H 53.15% mysqld 3057 publish1 52 18M 12M sleep 67:32 2.08% perl 23734 publish1 220 17M 14M run 0:32 5.10% httpd 16703 publish1 580 17M 11M sleep 0:38 0.00% httpd server2:SunUltra-4,1cpu,1G memory,solaris5.7. mysql start command:nohup /usr/local/bin/safe_mysqld -O key_buffer=128M -O table_cache=512 -O sort_buffer=128M -O record_buffer=128M -O max_connections=999 -O wait_timeout=5000 use "top" show: load averages: 0.98, 1.09, 1.17 13:32:41 159 processes: 157 sleeping, 1 running, 1 on cpu CPU states: 0.0% idle, 57.3% user, 42.7% kernel, 0.0% iowait, 0.0% swap Memory: 1024M real, 16M free, 870M swap in use, 894M swap free PID USERNAME THR PRI NICE SIZE RES STATE TIMECPU COMMAND 332 root 9 200 779M 400M run80.6H 89.60% mysqld 370 root 1 590 18M 13M sleep 0:15 0.00% Xsun 392 root 1 590 7136K 1248K sleep 0:09 0.00% dtgreet __ Olivefan: Looks like the Intel box is a little i/o starved. The Sun seems to be getting along fine, but, still a pretty high load. Not sure why the memory usage discrepancy, but, a mysqladmin extended might be more helpful. I'm assuming you're running the solaris on the Dell for filesystem size reasons. Must be a pretty big and busy dbase. That load's gonna kill the machine over time. What's the temperature on that thing? Van -- = Linux rocks!!! http://www.dedserius.com = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Adding the offset to mysqlbinlog
Description: Sometimes, when you get a resync error, you need to skip a particular update and restart with the next bit. How-To-Repeat: Insert conflicting records and try to re-sync without deleting one. Fix: Apply this patch. Index: noris.38/sql/mysqlbinlog.cc --- noris.38/sql/mysqlbinlog.cc Wed, 24 Jan 2001 21:35:51 +0100 smurf (database_mysql/N/b/20_mysqlbinlo 1.12 664) +++ noris.39/sql/mysqlbinlog.cc Mon, 05 Feb 2001 22:00:12 +0100 smurf +(database_mysql/N/b/20_mysqlbinlo 1.13 664) @@ -355,18 +355,25 @@ while(1) { char llbuff[21]; +my_off_t old_off = my_b_tell(file); + Log_event* ev = Log_event::read_log_event(file, 0); if (!ev) { if (file-error) die("\ Could not read entry at offset %s : Error in log format or read error", - llstr(my_b_tell(file),llbuff)); + llstr(old_off,llbuff)); // file-error == 0 means EOF, that's OK, we break in this case break; } if (rec_count = offset) +{ + if (!short_form) +printf("# at %s\n",llstr(old_off,llbuff)); + ev-print(stdout, short_form); +} rec_count++; delete ev; } Submitter-Id: submitter ID Originator:Matthias Urlichs Organization: MySQL support: licence Synopsis: mysqlbinlog doesn't print the offset Severity: non-critical Priority: medium Category: mysql Class: change-request Release: mysql-3.23.32 (noris network MySQL) Environment: System: Linux play.smurf.noris.de 2.4.0s-noris-t5-2 #58 SMP Wed Jul 19 10:24:19 CEST 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i686-pc-linux-gnu/2.95.3/specs gcc version 2.95.3 19991030 (prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='-DTHREAD_SAFE_CLIENT -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Jun 8 2000 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x 1 root root 4118299 Sep 20 1999 /lib/libc-2.1.2.so -rwxr-xr-x 1 root root 4123003 Jun 8 2000 /lib/libc-2.1.3.so -rw-r--r-- 1 root root 19203634 Jun 8 2000 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Jun 8 2000 /usr/lib/libc.so -rwxr-xr-x 1 root root 2042654 Oct 27 17:09 /usr/lib/libc-client.a Configure command: ./configure --prefix=/usr --with-debug --enable-shared --without-mit-threads --libexecdir=/usr/sbin --localstatedir=/var/mysql --enable-thread-safe-client --sysconfdir=/etc --datadir=/usr/share --enable-large-files --without-readline --with-mysqld-user=mysql --with-unix-socket-path=/var/run/mysql.socket --enable-strcoll '--with-comment=noris network MySQL' --with-docs --with-bench --without-berkeley-db --without-bench - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Support request from Progetto 2000 ID support 4300
Hi, I installed PHPMyAdmin to manage MySQL but when I try to run the script, after insert user and password, the error message below displayed: Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) in /home/sites/site2/web/phpadmin/lib.inc.php3 on line 170 Error I supposed that PHP is not well compiled with MySQL (In telnet MySQL works fine...) can you help me to verify PHP/MySQL config and to configure them properly (if required) ? Thanks Carlo Carlini [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