mysql 3.22 for solaris 2.6
Hi, I need a version of mysql that is 3.22 or higher for solaris 2.6. On your download site, you only have support for solaris 2.5, 2.7, and 2.8. Can you help me out? 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: Problem installing MySQL-3.23.45-1.i386.rpm
Brian French wrote: hey, i'm having trouble installing MySQL-3.23.45-1.i386.rpm already installed MySQL-client-3.23.45-1.i386.rpm MySQL-devel-3.23.45-1.i386.rpm when i try to install MySQL-3.23.45-1.i386.rpm i get the following: [root@localhost rpms]#rpm -U --force --replacefiles MySQL-3.23.45-1.i386.rpm error: failed dependencies: libmysqlclient.so.10 is needed by php-mysql-4.0.4pl1-9 could you tell me how to get around this problem? Have you tried installing MySQL-shared? Jean-Luc - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
HANDLER question
Before I start, I know that HANDLER (ie, HANDLER table OPEN, HANDLER table READ, etc) are low level and the use is pretty hairy! However, the following is a fairly basic problem, and if it cannot be overcome, one would question the validity of having HANDLER at all. (read that with a smile please). My problem, I believe, is to do with table flushing. Any suggestions on how to overcome this gratefully received. (For the purposes of brevity in these tests, I do a TRUNCATE TABLE mytable before all tests) If I do an insert to a table from within my application, and then, from another mysql session, do HANDLER mytable OPEN; HANDLER mytable READ FIRST; then I get, ERROR 1030: Got error 1 from table handler However, if I do a select * from mytable; then I (as one would hope!) see my new data. Further: If I try this on a table with just one column, then it works (i.e, HANDLER can read it seemingly immediately). But if the table has a number of columns (as below) then I see the above problem. mysql describe mytable; (output modified for brevity) id int(11) status char(2) binary lang_number int(11) source_file char(20) binary text_type char(10) binary system char(4) binary maximum_length smallint(6) text char(132) binary key_characters char(15) binary first_revision int(11) security_lock smallint(6) default_option smallint(6) ++--+--+-+-+ + 12 rows in set (0.00 sec) As mentioned above, this feels like a flushing problem. So - how come select can see the data? If HANDLER not reading the cache? Is this fixable? I look forward to a response, Many regards, Ian Collins. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: error log
please, if somebody knows about this problem, help me regards alemo - Original Message - Hello, I've updated my mySQL from version 3.21 to 3.23, and (after this change) all of my perl programs which use mysql, prints to STDERR, a debug (?) message like this: SV = RV(0x84ec388) at 0xb2f0 REFCNT = 1 FLAGS = (ROK,READONLY) RV = 0x8552d3c Then, I updated the mySQL version to 4.0 (alpha) and the programs keep printing these messages to the STDERR. I have installed: DBD::mysql 2.0902 DBI 1.20 DBI::DBD 11.02 I've verified that the trace level is 0, and the PrintError attribute is set to 0, when I make the connection, between the program and the server. Do you know why these errors are printed? Thanks, alemo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
html ina text feild
I've set up a database with a text feild and want to call that information with html code embeded into the text( eg. br). Do I need to change the type of field ?. At the moment the html code is being returned as plain text. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: HANDLER question
Hi! On Nov 30, Ian Collins wrote: Before I start, I know that HANDLER (ie, HANDLER table OPEN, HANDLER table READ, etc) are low level and the use is pretty hairy! However, the following is a fairly basic problem, and if it cannot be overcome, one would question the validity of having HANDLER at all. (read that with a smile please). If I do an insert to a table from within my application, and then, from another mysql session, do HANDLER mytable OPEN; HANDLER mytable READ FIRST; then I get, ERROR 1030: Got error 1 from table handler However, if I do a select * from mytable; then I (as one would hope!) see my new data. Could you, please, create a testcase for that ? Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: html ina text feild
No, you don't have to change the type of field. If you want more HTML embedded, you could save those HTMLs together w/ the text in your database, or... if you just want the br / tags, then, assuming your text has a new line character (\n), you have to do some sort of substitution. Forexample, in Perl you could do the following: my $text = $dbh-selectrow_array(SELECT text_field FROM table_name WHERE id=?, undef, $id); $text =~ /\n/br/g; Webmaster wrote: W: I've set up a database with a text feild and want to call that W: information with html code embeded into the text( eg. br). Do I need W: to change the type of field ?. At the moment the html code is being W: returned as plain text. W: W: W: W: - W: Before posting, please check: W:http://www.mysql.com/manual.php (the manual) W:http://lists.mysql.com/ (the list archive) W: W: To request this thread, e-mail [EMAIL PROTECTED] W: To unsubscribe, e-mail [EMAIL PROTECTED] W: Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php W: -- sherzodR [EMAIL PROTECTED] use CGI::Session; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
to many connections, how to optimize them?
Hi! I have a problem! Too many connections error in myODBC. I am wondering now how to optimize the code... What is better, to make 14 open.comm and close.conn on a web page or to open once and close once? Asked differently, is it better to connect to database one and be connected until all code is generated or is it better to connect for every piece of information that is needed? What should I also be looking for in optimizing my pages? I don't have near 100 users simultaniously accessing database! Yours Jerry - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqldump: problem/question
So what was the problem? Weaver, Walt wrote: WW: Okay, I know you guys have been wracking your brains for the last two days WW: trying to solve my problem of mysqldump running out of memory while dumping WW: a large table. WW: WW: I figured it out, so you can all go on with your lives. WW: WW: My copy of Paul DuBois' MySQL book came today and immediately solved my WW: problem. WW: WW: Cool book. Now I have something to do this weekend. WW: WW: Thanks, WW: --Walt Weaver WW: Bozeman, Montana WW: Oracle smart, MySQL dumb (for now) WW: WW: - WW: Before posting, please check: WW:http://www.mysql.com/manual.php (the manual) WW:http://lists.mysql.com/ (the list archive) WW: WW: To request this thread, e-mail [EMAIL PROTECTED] WW: To unsubscribe, e-mail [EMAIL PROTECTED] WW: Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php WW: -- sherzodR [EMAIL PROTECTED] use CGI::Session; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: html ina text feild
Webmaster writes: I've set up a database with a text feild and want to call that information with html code embeded into the text( eg. br). Do I need to change the type of field ?. At the moment the html code is being returned as plain text. An HTML document is just a sequence of bytes, as is any other data that a computer handles. A TEXT field holds such a sequence and does absolutely no conversion of it. You're not giving a lot of information on what you're trying to do and what goes wrong, but most likely what you get out is exactly what you put in. Could it be that you've done some unwanted pre- or postprocessing of your data, such as escaping some HTML entities? //C - vague -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: to many connections, how to optimize them?
Every connection will carry some overhead cost. So you'll have to connect as few times as possible. Jerry wrote: J: Hi! J: J: I have a problem! Too many connections error in myODBC. J: J: I am wondering now how to optimize the code... J: J: What is better, to make 14 open.comm and close.conn on a web page or to open J: once and close once? J: J: Asked differently, is it better to connect to database one and be connected J: until all code is generated or is it better to connect for every piece of J: information that is needed? J: J: What should I also be looking for in optimizing my pages? I don't have near J: 100 users simultaniously accessing database! J: J: Yours J: J: Jerry J: J: J: - J: Before posting, please check: J:http://www.mysql.com/manual.php (the manual) J:http://lists.mysql.com/ (the list archive) J: J: To request this thread, e-mail [EMAIL PROTECTED] J: To unsubscribe, e-mail [EMAIL PROTECTED] J: Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php J: -- sherzodR [EMAIL PROTECTED] use CGI::Session; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 date problem
On Thu, 29 Nov 2001, nut sss wrote: can i do this? content in field=aaa,bbb,ccc,hhh new content=aaa,bbb,ccc,hhh,fff can i append new word fff into the old field .by use update command in 1 query :) it's like UPDATE persondata SET age=age+1 but i want to append new value into old field... what should i do . First of all: Read The very Fine Manual, especially the section on String Functions where you might find something about `CONCAT(str1,str2,...)' and CONCAT_WS(separator, str1, str2,...). Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: html ina text feild
sherzodR writes: No, you don't have to change the type of field. If you want more HTML embedded, you could save those HTMLs together w/ the text in your database, or... if you just want the br / tags, then, assuming your text has a new line character (\n), you have to do some sort of substitution. Ah, the joys of communication. This was probably closer to what it was he wanted to know than my reply. In PHP, there's htmlentities() and nl2br() which are useful in various situation. Or... one could just allow users to type in any html and see what happens. :-o //C - doesn't trust users. -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: html ina text feild
Sorry should of given more infromation. I'm using Roxen 2.1 as my web server and am using the roxen emit tag to call the information. -Original Message- From: Carl Troein [EMAIL PROTECTED] To: [EMAIL PROTECTED] Date: Fri, 30 Nov 2001 10:22:34 GMT Subject: Re: html ina text feild sherzodR writes: No, you don't have to change the type of field. If you want more HTML embedded, you could save those HTMLs together w/ the text in your database, or... if you just want the br / tags, then, assuming your text has a new line character (\n), you have to do some sort of substitution. Ah, the joys of communication. This was probably closer to what it was he wanted to know than my reply. In PHP, there's htmlentities() and nl2br() which are useful in various situation. Or... one could just allow users to type in any html and see what happens. :-o //C - doesn't trust users. -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 installing MySQL-3.23.45-1.i386.rpm
Brian French wrote: hey, i'm having trouble installing MySQL-3.23.45-1.i386.rpm already installed MySQL-client-3.23.45-1.i386.rpm MySQL-devel-3.23.45-1.i386.rpm when i try to install MySQL-3.23.45-1.i386.rpm i get the following: [root@localhost rpms]#rpm -U --force --replacefiles MySQL-3.23.45-1.i386.rpm error: failed dependencies: libmysqlclient.so.10 is needed by php-mysql-4.0.4pl1-9 could you tell me how to get around this problem? Hello, What is your system ? Edward. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 date problem
UPDATE your_table SET your_col = CONCAT(your_col, fff); nut sss wrote: ns: can i do this? ns:content in field=aaa,bbb,ccc,hhh ns:new content=aaa,bbb,ccc,hhh,fff ns:can i append new word fff into the old field .by ns: use update command in 1 query :) ns: it's like ns: UPDATE persondata SET age=age+1 ns: but i want to append new value into old field... ns: what should i do . ns: help me help me plsss ^_^ ns: ns: ns: __ ns: Do You Yahoo!? ns: Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. ns: http://geocities.yahoo.com/ps/info1 ns: ns: - ns: Before posting, please check: ns:http://www.mysql.com/manual.php (the manual) ns:http://lists.mysql.com/ (the list archive) ns: ns: To request this thread, e-mail [EMAIL PROTECTED] ns: To unsubscribe, e-mail [EMAIL PROTECTED] ns: Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ns: -- sherzodR [EMAIL PROTECTED] use CGI::Session; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Getting id asignet to an insert
Hi everybody: Can anybody tellme how can y get the id asigned to a record in the moment i insert data in the database? I need to storage transaction requests, the mysql database assigns an unique id (auto increment) to that record, and i need it to continue saving data in another table. Is there a method for doing this whitou problems of concurrent users in the database??? Tahnk a lot - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Getting id asignet to an insert
I am not quite sure, but the only I could think of is the table locking. Just lock those two tables at the time of transaction, and release the lock as soon as you're done. I am sure people out here might have more sophisticated solutions... in which case i'd like to be aware of that too ( I believe LAST_INSERT_ID() of table A will not be available in table B, will it?) Javier Armendáriz wrote: JA: Hi everybody: JA: JA: Can anybody tellme how can y get the id asigned to a record in the moment i JA: insert data in the database? JA: JA: I need to storage transaction requests, the mysql database assigns an unique JA: id (auto increment) to that record, and i need it to continue saving data in JA: another table. JA: JA: Is there a method for doing this whitou problems of concurrent users in the JA: database??? JA: JA: Tahnk a lot JA: JA: JA: - JA: Before posting, please check: JA:http://www.mysql.com/manual.php (the manual) JA:http://lists.mysql.com/ (the list archive) JA: JA: To request this thread, e-mail [EMAIL PROTECTED] JA: To unsubscribe, e-mail [EMAIL PROTECTED] JA: Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php JA: -- sherzodR [EMAIL PROTECTED] use CGI::Session; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
updates with threads
Can someone perhaps tell me why the following pseudo-code blocks at time 4, when transaction isolation is set to READ_COMMITTED. Table A is a BDB table, records 1 and 400 both exist. To me it seems that both updates don't have anything to do with eachother. Does this perhaps has anything to do with, and i quote from the MYSQL manual: MYSQL will issue an internal multiple-write lock on the table to ensure that the table will be properly locked if another thread issues a table lock. ??. If so, then i think this is a strange approach, because then concurrent reads/writes aren't allowed at all. Or is it perhaps the page locking mechanism which is used in the BDB tables that causes this behavior? time statement - 1: | thread1.SQL(BEGIN) 2: | thread2.SQL(BEGIN) 3: | thread1.SQL(update record 1 in table A) 4: | thread2.SQL(update record 400 in table A) 5: | thread1.SQL(COMMIT) 6: | thread2.SQL(COMMIT) N.B: Suppose i want to switch to InnoDB tables, then what exactly is the meaning of setting the transaction isolation. The locking mechanism actually used is determined by the special InnoDB select statements according to the MYSQL manual. I quote: `SELECT ... FROM ... FOR UPDATE' : sets exclusive next-key locks on all index records the read encounters. In fact is the meaning of setting the transaction isolation even defined for BDB tables?? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
InnoDB inserts: HELP! :-)
Okay, second time of asking, does anyone know why InnoDB inserts are an order of magnitude slower than BDB inserts? Is this true only for me? If so, what am I doing wrong? Is it a FAQ? If so, where can I find the answer? Are InnoDB tables supposed to behave like this? If so, why? I know I'm new here so I might be missing something, please let me know what it is! cheers, Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Can't make after ./configure
Hi! Chang-Ping == Chang-Ping Hsiao [EMAIL PROTECTED] writes: The problem with gcc 3.0.x, as I have understood it, is that for this to work you must also have libstdc++v3 installed. I have now updated our documentation about this. Chang-Ping According to the web page Chang-Ping (http://gcc.gnu.org/libstdc++/status.html), gcc 3.0 should already have Chang-Ping libstdc++-v3, and I did compile and install gcc 3.0.2 successfully. Any Chang-Ping idea? What is your exact configure line? Note that you should NOT have CXX=gcc on this command line! If you have configured MySQL before, you should do: make clean rm config.cache ./configure You know that things goes right if configure says that it's using 'g++' as the C++ compiler; If it's reporting 'gcc' then something is wrong! Have you checked that you have a file named libstdc++.a and that 'nm libstdc++.a' | grep __cxa_pure_virtual' returns a string that contains __cxa_pure_virtual ? The link line your compilation used: gcc -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_RWLOCK_T -o .libs/mysqlbinlog mysqlbinlog.o ../libmysql/.libs/libmysqlclient.so -lcrypt -lgen -lsocket -lnsl -lm -lcrypt -lgen -lsocket -lnsl -lm -R/usr/local/lib/mysql Is wrong. It should be: g++ -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_RWLOCK_T -o .libs/mysqlbinlog mysqlbinlog.o ../libmysql/.libs/libmysqlclient.so -lcrypt -lgen -lsocket -lnsl -lm -lcrypt -lgen -lsocket -lnsl -lm -R/usr/local/lib/mysql Can you check if this works ? Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Comparing an alias ...
Hi ... I am need the following query to work : SELECT min(my_colum) as MINIMAL_VALUE WHERE MINIMAL_VALUE 10 The query is not EXACTLY as this one, but i think it is enough to get you the idea of my problem... Thnx for any help ! []~S julio - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: InnoDB inserts: HELP! :-)
Hi Chris, Welcome to the MySQL list;^) good to see you here... Any way I found a link which might explain why your InnoDB inserts take longer, perhaps this may be the reason... http://www.mysql.com/doc/S/E/SEC418.html In inserts InnoDB uses the insert buffer to merge secondary index records to indexes in batches. That saves a lot of disk i/o. In rollback no such mechanism is used, and the rollback can take 30 times longer than the insertion. hth Norman -Original Message- From: Chris Withers [mailto:[EMAIL PROTECTED]] Sent: Friday, November 30, 2001 12:42 PM To: [EMAIL PROTECTED] Subject: InnoDB inserts: HELP! :-) Okay, second time of asking, does anyone know why InnoDB inserts are an order of magnitude slower than BDB inserts? Is this true only for me? If so, what am I doing wrong? Is it a FAQ? If so, where can I find the answer? Are InnoDB tables supposed to behave like this? If so, why? I know I'm new here so I might be missing something, please let me know what it is! cheers, Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Solaris, JDBC and MySQL
A quick search on Google gives some places here is the search URL: http://www.google.com/search?hl=enq=libodbcinst.so.1spell=1 HTH At 01:46 PM 11/30/2001 +1300, Quentin Bennett wrote: Hi, Can anyone point me, a humble C programmer, to a tutorial for setting up and using JDBC and MySQL. We are having the following problem, which boils down to libobdcinst.so.1 not being found - where can I find it? SKYROAD#mercury1:/mercury/home/morgan/javatrial:java SimpleSelect DriverManager.getConnection(jdbc:odbc:mercury1) trying driver[className=sun.jdbc.odbc.JdbcOdbcDriver,context=null,sun.jdbc.odbc.Jdb cOdbcDriver@1bccd4ba] *Driver.connect (jdbc:odbc:mercury1) JDBC to ODBC Bridge: Checking security No SecurityManager present, assuming trusted application/applet JDBC to ODBC Bridge 1.1001 Current Date/Time: Fri Nov 30 12:30:09 GMT+12:00 2001 Loading JdbcOdbc library ld.so.1: /usr/bin/../java/bin/../bin/i386/native_threads/java: fatal: libodbcinst.so.1: open failed: No such file or directory (/usr/bin/../java/bin/../lib/i386/native_threads/libJdbcOdbc.so) ld.so.1: /usr/bin/../java/bin/../bin/i386/native_threads/java: fatal: libodbcinst.so.1: open failed: No such file or directory (/usr/bin/../java/bin/../lib/libJdbcOdbc.so) Unable to load JdbcOdbc library java.sql.SQLException: Unable to load JdbcOdbc library at java.lang.Throwable.init(Compiled Code) at java.lang.Exception.init(Compiled Code) at java.sql.SQLException.init(Compiled Code) at sun.jdbc.odbc.JdbcOdbc.init(Compiled Code) at sun.jdbc.odbc.JdbcOdbcDriver.initialize(Compiled Code) at sun.jdbc.odbc.JdbcOdbcDriver.connect(Compiled Code) at java.sql.DriverManager.getConnection(Compiled Code) at java.sql.DriverManager.getConnection(Compiled Code) at SimpleSelect.main(Compiled Code) Unable to load JdbcOdbc library Unable to allocate environment getConnection: no suitable driver java.sql.SQLException: No suitable driver at java.lang.Throwable.init(Compiled Code) at java.lang.Exception.init(Compiled Code) at java.sql.SQLException.init(Compiled Code) at java.sql.DriverManager.getConnection(Compiled Code) at java.sql.DriverManager.getConnection(Compiled Code) at SimpleSelect.main(Compiled Code) SQLException: SQLState(08001) *** SSQLException caught *** SQLState: 08001 Message : No suitable driver Vendor : 0 Thanks in advance Quentin Bennett Transport Systems Division Infinity Solutions web http:\\www.infinity.co.nz mailto:[EMAIL PROTECTED] Phone : +64 9 358 9720 Fax : +64 9 309 4142 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Joseph Roth [EMAIL PROTECTED] _ 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: please help me
Hi try http://www.devshed.com/Server_Side/PHP/SoothinglySeamless/page1.html for good tutorials on PHP and MySQL, although biased toward Unix, I suppose it should work in a similar way on IIS. Maybe wrong?! snip ? $dbuser = 'root'; $dbhost = 'localhost'; $dbpass = 'password'; $dbname = 'test2'; $dbtble = 'books'; $mysql_link = mysql_connect($dbhost,$dbuser,$dbpass); $column = mysql_list_fields($dbname,$dbtble,$mysql_link); for($i=0; $i mysql_num_fields($column); $i++ ) { print mysql_field_name($column,$i ).br; } ? -Original Message- From: anandakkumar araskumar [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 12:37 PM To: [EMAIL PROTECTED] Subject: please help me Hi all Iam new to php and iam learning that from scratch.I came across a problem in connecting mysql from php script.I run php in windows2000 under IIS configured to personal web server.I have installed mysql with server and client and both are running in the same machine(ofcourse, i can you use the ipaddress of localhost).I didn't set any username or password with mysql. This is my php script: $link=mysql_connect(localhost); if($link) die(Couldn't connect to mysql.mysql_error() ); print Successfully connected to server; when i execute this program iam getting the following message: Couldn't connect to mysql Anyone please help me as this is very urgent. thanks in advance Regards shahjahan __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Comparing an alias ...
Try to use HAVING instead of WHERE. I hope that will help. Julio Faerman wrote: JF: Hi ... I am need the following query to work : JF: SELECT JF: min(my_colum) as MINIMAL_VALUE JF: WHERE JF: MINIMAL_VALUE 10 JF: JF: The query is not EXACTLY as this one, but i think it is enough to get you JF: the idea of my problem... JF: JF: Thnx for any help ! JF: []~S JF: julio JF: JF: JF: - JF: Before posting, please check: JF:http://www.mysql.com/manual.php (the manual) JF:http://lists.mysql.com/ (the list archive) JF: JF: To request this thread, e-mail [EMAIL PROTECTED] JF: To unsubscribe, e-mail [EMAIL PROTECTED] JF: Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php JF: -- sherzodR [EMAIL PROTECTED] use CGI::Session; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB inserts: HELP! :-)
Norman Khine wrote: Welcome to the MySQL list;^) good to see you here... *grinz* It's weird being a newbie again :-P In inserts InnoDB uses the insert buffer to merge secondary index records to indexes in batches. That saves a lot of disk i/o. In rollback no such mechanism is used, and the rollback can take 30 times longer than the insertion. Well, I'm not doing any rollbacks, just groups of inserts followed by a commit. Changing the number of inserts per commit doesn't seem to have an effect one way or another. Are InnoDB tables dog slow on inserts and lightning quick on selects or am I bashing my head against something silly? If it helps, this is currently on Win2K, 3.23.44-max-nt. The machine has about 600Mb RAM and a 20GB Ultra80 SCSI drive, along with two PIII 500Mhz processors. Any ideas still greatfully received ;-) Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Comparing an alias ...
It won't work this way. SELECT min(my_column) as MINIMAL_VALUE will give you ONE record only. Therefore, an additional condition (which you can get with HAVING, not WHERE) will be meaningless. e.g: SELECT min(my_column) as MINIMAL_VALUE FROM mytable HAVING MINIMAL_VALUE 10 will return an empty set if the minimal value is = 10. This one, will give you some more: SELECT other_column, min(my_column) as MINIMAL_VALUE FROM mytable GROUP BY other_column HAVING MINIMAL_VALUE 10 Here you will get one line for each distinct value of other_column, provided that the minimimum value is bigger than 10. Bye Giuseppe Maxia Hi ... I am need the following query to work : SELECT min(my_colum) as MINIMAL_VALUE WHERE MINIMAL_VALUE 10 The query is not EXACTLY as this one, but i think it is enough to get you the idea of my problem... Thnx for any help ! []~S julio - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Solaris, JDBC and MySQL
A good book is JSP, Servlets, and mySQL by David Harms. -- original Message- From: Quentin Bennett [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 6:47 PM To: MySQL (E-mail); '[EMAIL PROTECTED]' Subject: Solaris, JDBC and MySQL Hi, Can anyone point me, a humble C programmer, to a tutorial for setting up and using JDBC and MySQL. We are having the following problem, which boils down to libobdcinst.so.1 not being found - where can I find it? SKYROAD#mercury1:/mercury/home/morgan/javatrial:java SimpleSelect DriverManager.getConnection(jdbc:odbc:mercury1) trying driver[className=sun.jdbc.odbc.JdbcOdbcDriver,context=null,sun.jdbc.odbc.Jdb cOdbcDriver@1bccd4ba] *Driver.connect (jdbc:odbc:mercury1) JDBC to ODBC Bridge: Checking security No SecurityManager present, assuming trusted application/applet JDBC to ODBC Bridge 1.1001 Current Date/Time: Fri Nov 30 12:30:09 GMT+12:00 2001 Loading JdbcOdbc library ld.so.1: /usr/bin/../java/bin/../bin/i386/native_threads/java: fatal: libodbcinst.so.1: open failed: No such file or directory (/usr/bin/../java/bin/../lib/i386/native_threads/libJdbcOdbc.so) ld.so.1: /usr/bin/../java/bin/../bin/i386/native_threads/java: fatal: libodbcinst.so.1: open failed: No such file or directory (/usr/bin/../java/bin/../lib/libJdbcOdbc.so) Unable to load JdbcOdbc library java.sql.SQLException: Unable to load JdbcOdbc library at java.lang.Throwable.init(Compiled Code) at java.lang.Exception.init(Compiled Code) at java.sql.SQLException.init(Compiled Code) at sun.jdbc.odbc.JdbcOdbc.init(Compiled Code) at sun.jdbc.odbc.JdbcOdbcDriver.initialize(Compiled Code) at sun.jdbc.odbc.JdbcOdbcDriver.connect(Compiled Code) at java.sql.DriverManager.getConnection(Compiled Code) at java.sql.DriverManager.getConnection(Compiled Code) at SimpleSelect.main(Compiled Code) Unable to load JdbcOdbc library Unable to allocate environment getConnection: no suitable driver java.sql.SQLException: No suitable driver at java.lang.Throwable.init(Compiled Code) at java.lang.Exception.init(Compiled Code) at java.sql.SQLException.init(Compiled Code) at java.sql.DriverManager.getConnection(Compiled Code) at java.sql.DriverManager.getConnection(Compiled Code) at SimpleSelect.main(Compiled Code) SQLException: SQLState(08001) *** SSQLException caught *** SQLState: 08001 Message : No suitable driver Vendor : 0 Thanks in advance Quentin Bennett Transport Systems Division Infinity Solutions web http:\\www.infinity.co.nz mailto:[EMAIL PROTECTED] Phone : +64 9 358 9720 Fax : +64 9 309 4142 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB inserts: HELP! :-)
Just For My Info: does it take long for one insert. if so, what does the insert statement look like. the reason i ask is becuase i use InnoDB and inserted a few records and it was pretty quick. but maybe thats becuase my statement was: insert into table (user,email,firstname,lastname) values ('bob','[EMAIL PROTECTED]','Bob','Cornelious'); it also autoincrements the uid column automatically. it's pretty simple and quick. Chris Withers wrote: Norman Khine wrote: Welcome to the MySQL list;^) good to see you here... *grinz* It's weird being a newbie again :-P In inserts InnoDB uses the insert buffer to merge secondary index records to indexes in batches. That saves a lot of disk i/o. In rollback no such mechanism is used, and the rollback can take 30 times longer than the insertion. Well, I'm not doing any rollbacks, just groups of inserts followed by a commit. Changing the number of inserts per commit doesn't seem to have an effect one way or another. Are InnoDB tables dog slow on inserts and lightning quick on selects or am I bashing my head against something silly? If it helps, this is currently on Win2K, 3.23.44-max-nt. The machine has about 600Mb RAM and a 20GB Ultra80 SCSI drive, along with two PIII 500Mhz processors. Any ideas still greatfully received ;-) Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Joe Ellis http://www.lithodyne.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mySql vs Interbase
At 15.40 29/11/01 -0500, Raymond Abel wrote: At 16:44 2001-11-29 +, you wrote: On Thursday 29 Nov 2001 16:18, Fabien R. wrote: I saw somewhere that this comparaison existed but I can't remember where. Does it talk to anyone ? i used interbase to develop an application with delphi. The first problem has been documentation: not comparable to mySQL manual. Interbase support stored procedure and transaction, but mySQL seems to have better support for text fields (interbase ha only blobs and varchar) and consequently interbase has stronger limitations with row max length. I read somewhere that interbase is slow with many records in one table. I think mysql it's more easy to use. just my 2 cents == dott. Ivano Mario Luberti Archimede Informatica societa' cooperativa a r. l. Via G. Ferraris 12 - 56121- Ospedaletto- Pisa tel.: +39-050-3132300 fax: +39-050-3132301 e-mail: [EMAIL PROTECTED] web: http://www.archicoop.it - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: compile problems on Solaris8
This didn't seem to make it to the list the first time so let's try again. BTW is anybody else receiving each mail twice from the list? I am getting the same error message configure: error: cannot run test program while cross compiling. I think this a simple PATH issue where basic functions such as sprintf are not found. I was able to compile mysql on solaris 7 without any problems but having trouble compiling ANYTHING on solaris 8 therefore it doesn't look like a mysql issue. Everything seems to fail with basic C functions not being found. I tried various things to solve this with no avail: 1 moving the path to gcc in front of /usr/ccs/bin thinking it may be a conflict between the two compilers. 2 set LD_LIBRARY_PATH to various things. 3 make LD_LIBRARY_PATH part of PATH in hopes it would help configure find what it's looking for. I'm doing this on a new Netra X1 box with the pre installed Solaris 8 version on top of which I installed gcc-2.95.3-sol8-sparc-local and make-3.79.1-sol8-sparc-local builds. I'm thinking of compiling gcc with the native compiler but I don't know where to tell configure which compiler to use (I attempted this by trying to change $PATH) and I don't want to uninstall the native one before I have success with gcc. The development packages installed are: SUNWarc SUNWbtool SUNWhea SUNWsprot SUNWlibm. Is something missing here? It would be helpful to hear from someone who has successfully compiled on solaris8 or how to modify configure. Sorry about the lengthy post but I wanted to include all pertinent info. I'm cross posting this to both mysql lists to reach a wider audience. Thanks in advance. George P.S. The solaris8 build of mysql works fine. Robert Alexander wrote: http://www.mysql.com/doc/S/o/Solaris.html Why not just download the binary from the MySQL site? http://www.mysql.com HTH, /Rob At 06:03 -0800 2001/11/14, Geoff Reed wrote: I've been banging my head against the wall for 2 days over this :( I have the 3.23.40 source and i'm trying to get it to compile. I'm running Sun Solaris 8 Sparc on a Ultra 1-170E with 128 MB ram and ~ 27 gig HD space. GCC 2.95.3, freshly compiled and functioning well. the ./configure script gets to ... checking return type of sprintfconfigure: error: cannot run test program while cross compiling pouf - that's all she wrote - :( I'd like to compile a fresh install since the binary distro available on mysql.org does not have all the directories it is supposed to... after moving a handful of things around i was finally able to get it to work -- Robert Alexander, Alpha Geek, Workmate.ca WWW Database Applications and Web Hosting http://www.workmate.ca 416-823-6599 mailto:[EMAIL PROTECTED] Life's unfair - but root password helps! ___ To unsubscribe yourself from this list please go to http://www.mysql.org/mailman/listinfo/support and read the unsubscription information. support mailing list [EMAIL PROTECTED] http://www.mysql.org/mailman/listinfo/support -- George Horvath Scotia Capital Markets ISS - Technology Application Group Tel: 416-945-4204 Fax: 416-945-4002 E-mail: [EMAIL PROTECTED] ___ To unsubscribe yourself from this list please go to http://www.mysql.org/mailman/listinfo/support and read the unsubscription information. support mailing list [EMAIL PROTECTED] http://www.mysql.org/mailman/listinfo/support -- George Horvath Scotia Capital Markets ISS - Technology Application Group Tel: 416-945-4204 Fax: 416-945-4002 E-mail: [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: InnoDB inserts: HELP! :-)
Joe Ellis wrote: Just For My Info: does it take long for one insert. if so, what does the insert statement look like. the reason i ask is becuase i use InnoDB and inserted a few records and it was pretty quick. but maybe thats becuase my statement was: insert into table (user,email,firstname,lastname) values ('bob','[EMAIL PROTECTED]','Bob','Cornelious'); Well, it's full text idnexing, so it goes roughly like this: -start transaction repeat for each word in document to be indexed: select wordid for dictionary if no wordid found: insert word into dictionary, make note of wordid then, for each wordid from the above list: insert (word_id,document_id,pos) into another table -end transaction All pretty simple too... cheers, Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
help with load data infile
Hello, I've got a bunch of tables from MS Excel that I've exported to tab delimited files that I'm trying to load into mySQL. I'm having problems getting the data in properly though. For instance, I have set up the ids so that they are incremented automatically. I have the initial records in my text file with ids already. Should I take out the ones that I have assigned and let mySQL assign new ids? Also, in another table, I have primary keys that are not incremented automatically. Yet when I try to insert the data, I get errors saying that there are duplicate values in my file. That cannot be since I the data in my file is unique. It would be greatly appreciated if anyone can help with this. Mark Ward - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
When will Stable version 4.0 be released ?
Hi! I'll be happy if I know that when Stable version 4.0 will be released. Thanks! Homepage = http://www.nnr.or.kr/inos/ ICQ # = 123534385 Member of DSN(database.sarang.net), NNR(nnr.or.kr) --MIME Multi-part separator-- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySql and replication
Hello, I have 2 application running in a master/slave mode. - Application A linked to a database D - Application A' linked to a database D' While A is master, A' is in standby mode and D' replicates D. If a problem occurs on A, A' becomes master and D must replicate D'. 1) Is it possible for a master MySql database to become slave ? 2) Is it possible for A' to tell D' to become master (by lauching a script for instance) ? Thanks in advance, Fabien - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
many connection errors
MySQL 3.23.39 RH6.2 Apache 1.3.12 2 weeks ago mysql stopped with the following example error.(repeated on other sites that use mysql on my server) Warning: Host 'localhost' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' in /home/domain/domain42/web/drwho/php/common.php on line 18 Warning: MySQL Connection Failed: Host 'localhost' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' in /home/domain/domain42/web/drwho/php/common.php on line 18 Couldn't Connect To Database Server This effected all users since they all use 'localhost' I ran 'mysqladmin flush-hosts'. Looking at the logs i see quite a few errors sample 011130 6:08:54 Aborted connection 58760 to db: 'modderz_db1' user: 'modderz' host: `localhost' (Got timeout reading communication packets) 011130 6:18:20 Aborted connection 56028 to db: 'modderz_db1' user: 'modderz' host: `localhost' (Got timeout reading communication packets) 011130 9:06:12 Aborted connection 71509 to db: 'modderz_db1' user: 'modderz' host: `localhost' (Got timeout reading communication packets) 011130 9:12:56 Aborted connection 66603 to db: 'modderz_db1' user: 'modderz' host: `localhost' (Got timeout reading communication packets) ends I did a search and found the info to clear the error but i am not sure what causes it. Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
can't connect to server
I'm running MySQL on Windows2k. The service is installed and I can start it with the WinMySQLAdmin Tool, but I have trouble to shutdown the server on a DOScommand window with 'mysqladmin shutdown'. I also can't connect to the server at localhost, and I can't start MySQL as a service with 'mysqld -l' - only as standalone. What is wrong with it? Any help is appreciated. Nils -- GMX - Die Kommunikationsplattform im Internet. http://www.gmx.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: compile problems on Solaris8
Hi. This didn't seem to make it to the list the first time so let's try again. BTW is anybody else receiving each mail twice from the list? It did, it's just that no one answered it. :] Not me, the last time I thought that was happening, it had to do with my mail sorting rules in Outlook. I am getting the same error message configure: error: cannot run test program while cross compiling. I think this a simple PATH issue where basic functions such as sprintf are not found. It's been a while since I tried to compile mysql on a Solaris box, but that error most like likely indicates a compiler-related issue...I don't know how much help I can be with this, but one thing missing from your earlier post is what arguments (if any) you passed to ./configure. I'd be interested to see those if you could post them. I was just about to hit send, when I got curious and found something: This page (http://www.mysql.com/doc/S/o/Solaris.html) says to add a line to your config.cache, and also has recommended configure arguments. hth. -ravi. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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, Red Hat Linux and php
If you are using the MySQL RPMS for RedHat, They install in the /usr directory. (Redhat dows things differently) So it would be ./configure --with-mysql=/usr for PHP compilation. as far as upgrading... I have used RedHat for a long time, and have found that in their newest distos, it is extremely difficult to customize your computer. Escpecially with adding your own Kernel. I have stayed with 6.2 because for the most part, the directory structures comply with the source packages most people make available. As long as you keep current with important packages, there really isn't much difference in the newer versions, other than a new GLIBC, but you can add that to a 6.2 distro easily. Hope that helps Brian Austin Neil Zanella wrote: If I were you I would simply upgrade to Red Hat 7.1 or better 7.2. It probably takes just as much time to install a whole distro than having to worry about installing apache, then mysql, then php, all over again, and most likely getting something wrong and having to go back. Also there may be problems with compatibility etc... I remember having some problem compiling php with mysql support when mysql was not installed under /usr/local (something like the php configure option did not allow to specify a directory for the mysql installation). But perhaps this has changed in php 4.0.6. Regards, Neil On Thu, 29 Nov 2001 [EMAIL PROTECTED] wrote: Hello, Which version of MySQL ( RPM packages ) is good for work with php 4.0.6 and Linux Red Hat 6.2 ? Thank for your help ! Edward. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: many connection errors
Support wrote: MySQL 3.23.39 RH6.2 Apache 1.3.12 2 weeks ago mysql stopped with the following example error.(repeated on other sites that use mysql on my server) Warning: Host 'localhost' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' in /home/domain/domain42/web/drwho/php/common.php on line 18 Warning: MySQL Connection Failed: Host 'localhost' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' in /home/domain/domain42/web/drwho/php/common.php on line 18 Couldn't Connect To Database Server This effected all users since they all use 'localhost' I ran 'mysqladmin flush-hosts'. Looking at the logs i see quite a few errors sample 011130 6:08:54 Aborted connection 58760 to db: 'modderz_db1' user: 'modderz' host: `localhost' (Got timeout reading communication packets) 011130 6:18:20 Aborted connection 56028 to db: 'modderz_db1' user: 'modderz' host: `localhost' (Got timeout reading communication packets) 011130 9:06:12 Aborted connection 71509 to db: 'modderz_db1' user: 'modderz' host: `localhost' (Got timeout reading communication packets) 011130 9:12:56 Aborted connection 66603 to db: 'modderz_db1' user: 'modderz' host: `localhost' (Got timeout reading communication packets) ends I did a search and found the info to clear the error but i am not sure what causes it. Mark Hello, Have you ever tried MySQL 3.23.45, php 4.0.6 and Apache 1.3.20 ? Edward. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
reset table w auto increment
I'm using a table joiner tabel with a auto-incrementing key field, and I would like to empty the table, and start fresh from key 1 (as compared to the next auto-incremented key). Can anyone tell me how to do this (in mysql or in php)? Steve Osborne Database Programmer Chinook Multimedia Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: compile problems on Solaris8
On 30-Nov-01, Ravi Raman said something totally profound about RE: compile problems on Solaris8 that made me ponder... RR It's been a while since I tried to compile mysql on a Solaris box, but RR that error most like likely indicates a compiler-related issue...I don't RR know how much help I can be with this, but one thing missing from your RR earlier post is what arguments (if any) you passed to ./configure. I'd be RR interested to see those if you could post them. RR RR I was just about to hit send, when I got curious and found something: This RR page (http://www.mysql.com/doc/S/o/Solaris.html) says to add a line to RR your config.cache, and also has recommended configure arguments. I've got a solid mini-HOWTO on compiling MySQL on Solaris. http://users.talstar.com/forager/MySQL-HOWTO.html This is what we use internally. I have successfully compiled and installed MySQL on Solaris 2.4, 2.5.1, 2.6, 7, and 8. Normally, I get my packages from SunFreeware. As of 07/01, the Solaris 8 Companion CD comes with the latest versions of bison and flex, as well as gcc 2.95.3. Most programs I compile will not compile with gcc3.0.x from SunFreeware. You should have, at least, bison, flex, and gcc installed. I also recommend using tcp-wrappers. Package v7.6 is included in the companion CD, but I haven't tried them. I used the source to compile two versions: auth and non-auth. Your PATH should be at least: /usr/bin:/usr/sbin:/usr/local/bin:/usr/xpg4/bin:/usr/ccs/bin If you use any of the companion CD packages, you should have /opt/sfw/bin directly after /usr/local/bin. That should be enough to get you going. I have tested this time and time again and various right-off-the-CD Solaris installations. Don't forget to check the MySQl on-line documentation for performance information. Could save you a few headaches on slower boxes (I have MySQL running on a 40MHz Sparc with Solaris 7.) Now if I can just port this over to Amiga :) -- Alan W. Rateliff, II: YourVillage.com Assistant Systems Administrator : 2700 Apalachee Pkwy [EMAIL PROTECTED] : Tallahassee, FL 32301 (850) 942-7021--- [EMAIL PROTECTED] http://support.yourvillage.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL, Red Hat Linux and php
Brian P. Austin wrote: If you are using the MySQL RPMS for RedHat, They install in the /usr directory. (Redhat dows things differently) So it would be ./configure --with-mysql=/usr for PHP compilation. as far as upgrading... I have used RedHat for a long time, and have found that in their newest distos, it is extremely difficult to customize your computer. Escpecially with adding your own Kernel. I have stayed with 6.2 because for the most part, the directory structures comply with the source packages most people make available. As long as you keep current with important packages, there really isn't much difference in the newer versions, other than a new GLIBC, but you can add that to a 6.2 distro easily. Hope that helps Brian Austin Hello, So, what do you suggest me to do ? Thank for your help ! Edward. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: many connection errors
Hi i have php4.0.6 Can't see why i should change apache as i don't see that as the problem. is it a know issue in MySQL that 3.23.45 fixes? if not i don't upgrade everytime there is a new release. The server has been up since april this year and this is first time the error has happened. It is prob caused by more of my users having php forums. What i need to find out is root of the cause Mark - Original Message - From: [EMAIL PROTECTED] To: Support [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, November 30, 2001 3:50 PM Subject: Re: many connection errors Support wrote: MySQL 3.23.39 RH6.2 Apache 1.3.12 2 weeks ago mysql stopped with the following example error.(repeated on other sites that use mysql on my server) Warning: Host 'localhost' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' in /home/domain/domain42/web/drwho/php/common.php on line 18 Warning: MySQL Connection Failed: Host 'localhost' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' in /home/domain/domain42/web/drwho/php/common.php on line 18 Couldn't Connect To Database Server This effected all users since they all use 'localhost' I ran 'mysqladmin flush-hosts'. Looking at the logs i see quite a few errors sample 011130 6:08:54 Aborted connection 58760 to db: 'modderz_db1' user: 'modderz' host: `localhost' (Got timeout reading communication packets) 011130 6:18:20 Aborted connection 56028 to db: 'modderz_db1' user: 'modderz' host: `localhost' (Got timeout reading communication packets) 011130 9:06:12 Aborted connection 71509 to db: 'modderz_db1' user: 'modderz' host: `localhost' (Got timeout reading communication packets) 011130 9:12:56 Aborted connection 66603 to db: 'modderz_db1' user: 'modderz' host: `localhost' (Got timeout reading communication packets) ends I did a search and found the info to clear the error but i am not sure what causes it. Mark Hello, Have you ever tried MySQL 3.23.45, php 4.0.6 and Apache 1.3.20 ? Edward. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Problems - Still Rebooting
Hi Johnathon, There are several problems with threads and the C++ compiler on FreeBSD 4.2. If you can please update to FreeBSD 4.4, or for performance enhancements go to 4.4-stable. If you have to stay on 4.2 I can send you a patch that should work on 4.2, but you will have to recompile MySQL because part of the patch pathes the compiler. The patch was posted on the freebsd-stable mailing list on 12/6/00 by Max Khon. But there are many nice enhancements you get going to 4.4 and 4.5 will be even better! Hope this helps. Ken - Original Message - From: Jonathan Hilgeman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 2:47 PM Subject: MySQL Problems - Still Rebooting Please please please take the time to look at this problem. I'm running MySQL 3.23.36 on FreeBSD 4.2. The only application that connects and manipulates MySQL is a single PHP application running on PHP 4.0.3. I've eliminated all the errors I can think of and tried to optimize all queries. CPU usage never goes about 10-20% tops. However, MySQL continues to restart randomly and I cannot detect a pattern. And each time it restarts, it appears as though it doesn't close the socket or something. If I run netstat on my machine, I see this near the bottom: Address Type Recv-Q Send-QInode Conn Refs Nextref Addr d56998c0 stream 0 0 d5a12d40000 /tmp/mysql.sock d5888680 stream 0 0 d5695900000 /var/run/ndc d5920f40 stream 0 00000 /tmp/mysql.sock d5699e80 stream 0 00000 /tmp/mysql.sock d5888f80 stream 0 00000 /tmp/mysql.sock d5699880 stream 0 00000 /tmp/mysql.sock d5920e00 stream 0 00000 /tmp/mysql.sock d5920340 stream 0 00000 /tmp/mysql.sock d5699280 stream 0 00000 /tmp/mysql.sock d5888280 stream 0 00000 /tmp/mysql.sock d5920b40 stream 0 00000 /tmp/mysql.sock That list of mysql.sock entries continues to grow slowly until I start getting errors about sockets. I can't JUST shut down MySQL and start it up again - the sockets stay there. I have to reboot the whole server to make the socket entries go away. There are no specific errors in the error log file - only mysql got signal 11 and it says something about checking the backtrace but it doesn't give me the actual backtrace data - just a message saying that I should check it. The binary logs don't hold any clues either. There's no pattern in the last queries before or beginning queries after the mySQL server restarts. They change each time. Help help help help help. - Jonathan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
3.22.32-log Hang when unable to create log files
If the MySQL server is unable to create the mysql.log log file, then the server hangs in an undeterminate state. No children are forked, and clients can connect, however are not serviced at all. I know there is an error in the log , or when mysqld is ran with STDERR logging, however in my humble opinion it is more appropriate that the server exits immediately so that the various monitoring facilities can detect the problem. Right now the mysql TCP port remains open and the parent process continues to run and this may fool monitoring software. This was observed on a 3.22.32-log under Debian 2.2 (Linux server 2.2.18pre21 #1 Sat Nov 18 18:47:15 EST 2000 i686 unknown) Sorry if this is known or has been fixed. I did not have the opportunity to test or follow appropriate procedures. Philip - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Title counter
I'm using roxen 2.1 as my web server and have set up a form page which querys the database and returns the stories to a new page. How do I set up a counter to record how many times that story has been read.All stories are loaded into the database and the new page is the results of the query. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Graphical Database Information
Is there a utility that will allow me to view a mysql database that is similar to an Access 2000 relationship diagram? Steve Osborne Database Programmer Chinook Multimedia Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 and RAID question
David, I currently run a system with Raid 5. I have had one disk drop, however, no data was lost. That is one of the beauties of RAID 5, you have a spare disk that takes over. I too had heard originally that running MySQL on a RAID 5 was a bad idea (this, after I already had it running...), however, I have not had any problems at all. -- Jason On Thu, 2001-11-29 at 17:34, Lionlike MySQL Email List wrote: Just one quick question... I've heard that running a database in a system using RAID isn't a good idea on RAID 5, but works fine with mirroring (0, 0/1, 0/5). Does anyone out there have experience with MySQL on RAID 5, or know how MySQL performs in a RAID 5 environment? My concern is loss of data due to a drive going bad. At least that what I've heard could happen. Thanks, David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Title counter
B: querys the database and returns the stories to a new page. How do I set B: up a counter to record how many times that story has been read.All B: stories are loaded into the database and the new page is the results of B: the query. B: First off, what programming API are u using? Perl, C, PHP? Anyways, whenever the query to retrieve the content is passed, along w/ that query pass the following: update cnt_table set count=count+1 where story_id=1341234 Good luck -- sherzodR [EMAIL PROTECTED] use CGI::Session; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Under MacOS X?
Also, although the standard groupadd command doesn't work for adding groups, you can use NetInfo Manager to add a group. This gives you a GUI interface to managing your groups and users. If you don't like GUI, use the command line tool niutil, which has its own man page. You would probably like this link, because it's the Apple-sanctioned way to install MySQL onto OS X. It includes a brief description of how to use NetInfo, as well, so you will find it useful even if you don't care about installing MySQL. The only problem is that it does not mention that 3.23.44 has a problem shutting down properly on Mac OS X (just use 3.23.45 because all the steps are the exact same and it doesn't have this problem). http://developer.apple.com/internet/macosx/osdb.html BTW, don't be intimidated by the prospect of compiling source code. I used to think that was hard core, but now I prefer it over the GUI or binary installs. Feel free to contact me directly if you have a problem, I just got MySQL up and running on Mac OS X the other day. --Erik On Thursday, November 29, 2001, at 08:29 PM, Kundan Kumar wrote: Try installing by fink.. http://fink.sourceforge.net/ If you have worked on debian, you will appreciate it. Regards, Kundan On 11/30/01 12:13 AM, Kurt Tappe [EMAIL PROTECTED] wrote: I'm stuck trying to figure out how to install this thing. What I've tried: * The download doesn't contain a standard MacOS .pkg so I can't do a GUI install. * The command-line instructions require the groupadd command in step #1, but MacOS doesn't support this due to the existence of the NetInfo system. * Turning to the manual.html included in the MacOS X build, only Linux and Windows are mentioned. Can anyone who has successfully installed MySQL under MacOS X tell me how they did so?? Thanks, -Kurt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [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: Graphical Database Information
We use this: http://www.datanamic.com/dezign/ Try the demo before buying it, it's not quite as good as it looks (unfortunately). Along with the ImportER MySQL you can just set it loose on your DDLs and it will generate a semi-complete ER diagram of your database. It helps if your foreign keys are named the same, i.e. Customer.customerID = Invoice.customerID so that it can generate those relationships too. With a bit of manual tweaking, it works well enough for us. hth. -ravi. -Original Message- From: Steve Osborne [mailto:[EMAIL PROTECTED]] Sent: November 30, 2001 12:29 PM To: MySQL (E-mail) Subject: Graphical Database Information Is there a utility that will allow me to view a mysql database that is similar to an Access 2000 relationship diagram? Steve Osborne Database Programmer Chinook Multimedia Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Title counter
Roxen 2.1 uses pike -Original Message- From: sherzodR [EMAIL PROTECTED] To: B.J.Rumsey [EMAIL PROTECTED] Date: Fri, 30 Nov 2001 10:36:47 -0600 (CST) Subject: Re: Title counter B: querys the database and returns the stories to a new page. How do I set B: up a counter to record how many times that story has been read.All B: stories are loaded into the database and the new page is the results of B: the query. B: First off, what programming API are u using? Perl, C, PHP? Anyways, whenever the query to retrieve the content is passed, along w/ that query pass the following: update cnt_table set count=count+1 where story_id=1341234 Good luck -- sherzodR [EMAIL PROTECTED] use CGI::Session; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Graphical Database Information
I use visio professional... But it's home made, not auto made like with an access DB. Plus since there are not a lot of types from visio, I prefered to make my own drawing, using cool functions like the snapping (so when I move tables they stay linked). Plus the relationship from visio are pretty neat, you can choose One, one (optional), many, many (optional) so ti draws the correct ends: ---||- or ---o|- or ---| or ---o But if you already have a complex DB in mySQl and want to have the graphical equivalent from a click, then I don't know and I'm curious if there is such app. Etienne Steve Osborne wrote: Is there a utility that will allow me to view a mysql database that is similar to an Access 2000 relationship diagram? Steve Osborne Database Programmer Chinook Multimedia Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: compile problems on Solaris8
This keeps coming up. So far (in my reading of this list since spring, and searches on Google), * everyone who has reported this was using the precompiled binary of gcc (either 2.95.2 or 2.95.3) from Sunfreeware to build MySQL for Solaris 8 sparc. * No one has spoken up to report success with this combination. * No one who built gcc from source has reported this problem. Unless a new piece of information comes in, it seems clear to me that configure doesn't like sunfreeware's pre-compiled copy of gcc for Solaris 8 sparc. It would be nice if someone from MySQL would tell us just what configure is doing when it declares sunfreeware's gcc a cross-compiler, and could confirm whether this is a configure problem or a gcc problem. That said, I recommend you build gcc from source. Sunfreeware's pre-compiled binary of gcc 2.95.3 works perfectly to compile gcc 2.95.3 from source. Once you've compiled and installed gcc from source, you should find that MySQL builds cleanly with the command recommended in the manual http://www.mysql.com/doc/S/o/Solaris.html: CC=gcc CFLAGS=-O3 \ CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti \ ./configure --prefix=/usr/local/mysql --with-low-memory --enable-assembler This worked for me on an E450 running Solaris 8. My path begins with: /usr/local/bin:/usr/ccs/bin (gcc is in /usr/local/bin, in my case). Don't bother with LD_LIBRARY_PATH unless you need it for something specific. Michael On Fri, 30 Nov 2001, George Horvath wrote: This didn't seem to make it to the list the first time so let's try again. BTW is anybody else receiving each mail twice from the list? I am getting the same error message configure: error: cannot run test program while cross compiling. I think this a simple PATH issue where basic functions such as sprintf are not found. I was able to compile mysql on solaris 7 without any problems but having trouble compiling ANYTHING on solaris 8 therefore it doesn't look like a mysql issue. Everything seems to fail with basic C functions not being found. I tried various things to solve this with no avail: 1 moving the path to gcc in front of /usr/ccs/bin thinking it may be a conflict between the two compilers. 2 set LD_LIBRARY_PATH to various things. 3 make LD_LIBRARY_PATH part of PATH in hopes it would help configure find what it's looking for. I'm doing this on a new Netra X1 box with the pre installed Solaris 8 version on top of which I installed gcc-2.95.3-sol8-sparc-local and make-3.79.1-sol8-sparc-local builds. I'm thinking of compiling gcc with the native compiler but I don't know where to tell configure which compiler to use (I attempted this by trying to change $PATH) and I don't want to uninstall the native one before I have success with gcc. The development packages installed are: SUNWarc SUNWbtool SUNWhea SUNWsprot SUNWlibm. Is something missing here? It would be helpful to hear from someone who has successfully compiled on solaris8 or how to modify configure. Sorry about the lengthy post but I wanted to include all pertinent info. I'm cross posting this to both mysql lists to reach a wider audience. Thanks in advance. George P.S. The solaris8 build of mysql works fine. Robert Alexander wrote: http://www.mysql.com/doc/S/o/Solaris.html Why not just download the binary from the MySQL site? http://www.mysql.com HTH, /Rob At 06:03 -0800 2001/11/14, Geoff Reed wrote: I've been banging my head against the wall for 2 days over this :( I have the 3.23.40 source and i'm trying to get it to compile. I'm running Sun Solaris 8 Sparc on a Ultra 1-170E with 128 MB ram and ~ 27 gig HD space. GCC 2.95.3, freshly compiled and functioning well. the ./configure script gets to ... checking return type of sprintfconfigure: error: cannot run test program while cross compiling pouf - that's all she wrote - :( I'd like to compile a fresh install since the binary distro available on mysql.org does not have all the directories it is supposed to... after moving a handful of things around i was finally able to get it to work -- Robert Alexander, Alpha Geek, Workmate.ca WWW Database Applications and Web Hosting http://www.workmate.ca 416-823-6599 mailto:[EMAIL PROTECTED] Life's unfair - but root password helps! ___ To unsubscribe yourself from this list please go to http://www.mysql.org/mailman/listinfo/support and read the unsubscription information. support mailing list [EMAIL PROTECTED] http://www.mysql.org/mailman/listinfo/support -- George Horvath Scotia Capital Markets ISS - Technology Application Group Tel: 416-945-4204 Fax: 416-945-4002 E-mail: [EMAIL PROTECTED] ___ To unsubscribe
Re: compile problems on Solaris8
On Fri, Nov 30, 2001 at 11:56:05AM -0500, Michael Stassen wrote: : : This keeps coming up. So far (in my reading of this list since spring, : and searches on Google), : : * everyone who has reported this was using the precompiled binary of gcc : (either 2.95.2 or 2.95.3) from Sunfreeware to build MySQL for Solaris 8 : sparc. : : * No one has spoken up to report success with this combination. : : * No one who built gcc from source has reported this problem. I will say that I have built MySQL 3.23.x several times on Solaris 8 sparc machines with gcc-2.95.2 and gcc-2.95.3 from sunfreeware.com with absolutely no problems. I use the same options that AB uses to compile their binary distributions, and I make test every time with no issues. From the configure file: cat conftest.$ac_ext EOF #line 1460 configure #include confdefs.h main(){return(0);} EOF if { (eval echo configure:1465: \$ac_link\) 15; (eval $ac_link) 25; } test -s conftest${ac_exeext}; then ac_cv_prog_cc_works=yes # If we can't run a trivial program, we are probably using a cross compiler. if (./conftest; exit) 2/dev/null; then ac_cv_prog_cc_cross=no else ac_cv_prog_cc_cross=yes fi else echo configure: failed program was: 5 cat conftest.$ac_ext 5 ac_cv_prog_cc_works=no fi It looks like the test to determine whether a cross-compiler is being dealt with is very simple. Perhaps, for some reason, that simple program isn't being compiled correctly. Test and see. That would be where I would start. * Philip Molter * Texas.net Internet * http://www.texas.net/ * [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem making myodbc on Solaris 8]
make fails with mksh: Fatal error in reader: = missing from replacement macro reference Current working directory /opt/perlModules/MyODBC-2.50.37 I have ODBC working for SQL Server. If I do a make -V is leads me to a bad set of lines in Makefile: DEPS_MAGIC := $(shell mkdir .deps /dev/null 21 ||:) -include $(DEP_FILES) If I take out the colon on the :=, I don't get an error. Is the -include a typo? I don't see a matching subroutine in Makefile. If I change it to include $(DEP_FILES) it can't find the files. DEP_FILES is previously defined as a list of files in .deps. I am running as root using GCC 2.95. I have a separate build of perl that I am using instead of /usr/bin/perl on Solaris 8. The PATH is set to /usr/local/bin:/usr/local/mysql/bin:/usr/bin:/usr/sbin:/usr/ccs/bin I am using the make in /usr/ccs/bin. The LD_LIBRARY_PATH is set to /usr/local/lib:/usr/local/mysq:/usr/lib The configure command is as follows: ./configure --with-odbc-ini=/etc/odbc.ini --with-iodbc-includes=/usr/local/openlink/w3configu/include --with-iodbc-libs=/usr/local/openlink/lib --with-mysql-dirs=/usr/local/mysql/lib/mysql --with-mysql-includes=/usr/local/mysql/include/mysql Matthew Dougherty [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
Designing a database to track files
Hello, I'm designing a database, and of course I have no formal training in this area (I'm learning from DuBois's book). It's designed to keep track of files. In my organization, we have a small design studio, and the designers save their image files to CD-ROMs. As you can imagine, the stacks of CDs have gotten so high that we now have invested in a large CD-storage cabinet. Needing a way to organize these files somehow, I was assigned the job of finding a database and setting it up. Having always wanted to get some experience in database-driven web-applications, I have decided to take advantage of this opportunity and learn PHP and MySQL. Those of you who have seen me post to this list with installation questions and have helped me, I thank you. Now it's time to design the database. I have come up with a few tables and am going to create them, but I can't help but feel like my setup is flawed somehow. We don't have very high standards for this project, but I would like it to be the best possible and it is a learning exercise for me, so I want to use the best possible design from the very beginning. Instead of just listing my whole table setup and asking for input (which seems kind of presumptious, though I wouldn't mind any advice), I'll describe my specific situation: I have two separate tables. One of them is called files and the other is called divisions. There are more tables, of course, but these are the only ones that matter in this case. My organization is divided into twelve divisions at this time, and I have assigned the name of a division to each row in the divisions table, along with some other irrelevant information like contact info, et cetera. divisions has an AUTO_INCREMENT PRIMARY KEY TINYINT column as well, so that I can refer to these entries by their identification number instead of by name. The column is called div_id, and can be referred to as divisions.div_id. In the files table, each row corresponds to a separate file. There's all sorts of additional criteria, but the only one that matters to my question is the column called div_id. That's right, the number in files.div_id must always correspond to the number in divisions.div_id. You might ask why I don't just use the division name in the files.div_id column -- it would seem to make more sense to have the column set up as div_id ENUM(division1, division2, division3, etc...) The reason why I am hesitant to do this is because I don't want someone to have to use MySQL to do this: ALTER TABLE files CHANGE div_id div_id ENUM(division1, division2, division3, ... new_division) I would like to make this database as self-maintaining as possible. If files.div_id is an INTEGER, rather than an ENUMERATION, then the user only has to use a new number that is one number higher than the old highest number, if we were to create add a new division to the organization. So does this setup seem to make sense? I mean, all I'm doing is using an INTEGER rather than an actual name to identify a division. That seems like it would make sense. Here's the problem: no one wants to identify the divisions by numbers. If they are to perform a search of files that were created by a specific division, then they want to input the division's name, not a number. Is there a way to use MySQL to translate the integer divisions.div_id to divisions.div_name ? I guess what I'm asking is if this query is possible: SELECT files.file_name FROM files WHERE files.file_id = divisions.div_id AND divisions.div_name = division1 ; I don't think this is a real SQL query, but I think it describes what I'm trying to do here, I made a little diagram (this isn't output from mysql): +--+ | files| +-+---++ | file_id | file_name | div_id | +-+---++ | 32 | picture1 | 08 | | | || | | || | | || | | || +--+ ++ | divisions | ++---+---+ | div_id | div_name | contact info, etc | ++---+---+ | 08 | division1 | 123 Main St, etc | || | | || | | || | | || | | ++---+---+ I'm trying to give the name division1 and get the name picture1 back. Will this work? If so, that is heartening, because I plan to have several other tables in the database (for other criteria) which will work in the same fashion (by assigning each entry an INTEGER rather than a name). Thanks, -- Erik the office temp who was told to design a database and write a web front-end, with no experience in
Storing groups of groups
Hi, I am planning an authentication system that is structured much like the system Windows uses: I have users and groups. Groups can either contain users directly or can contain other groups (which can again contain groups etc). Now I am thinking on how to store and efficiently read those definitions. At first, I thought about the this table structure (leaving out the users table, which at the moment contains nothing but a userid): CREATE TABLE groups ( id_group INT UNSIGNED NOT NULL, id_target INT UNSIGNED NOT NULL, is_group ENUM('yes', 'no') ) Note that id_target may both reference a user or a group, as determined by the setting of is_group. I don't think I can work very efficiently with this mixed storage, but I haven't come up with something better yet. Also, how would I write a query that gets me all users contained in a given group, while at the same time dereferencing groups to the user ids contained in them. An example to make myself more clear: - User ids are 1, 2, 3, 4 - Group 1 contains users 1, 2 and 3 - Group 2 contains user 4 and group 1 When I now query for group 2, I want just the user ids, i.e. 1,2,3,4 returned. Any ideas? Jens - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Not able to compile mysql-test
Hi, I have been working with mySQL and Apache for years on linux servers. But recently I purchased Solaris machine, and I am have problems compiling mySQL on it. I have - SunOS machine1 5.8 Generic_108528-10 sun4u sparc SUNW,Sun-Blade-100 - with gcc 2.95.3 20010315 And I am getting the following errors when I run the make command. And I am not using any weird option with configure. I m just using --prefix=/usr/local/mysql Making all in tests make[2]: Entering directory `/download/mysql-3.23.43/tests' make[2]: Nothing to be done for `all'. make[2]: Leaving directory `/download/mysql-3.23.43/tests' Making all in man make[2]: Entering directory `/download/mysql-3.23.43/man' make[2]: Nothing to be done for `all'. make[2]: Leaving directory `/download/mysql-3.23.43/man' Making all in sql-bench make[2]: Entering directory `/download/mysql-3.23.43/sql-bench' make[2]: Nothing to be done for `all'. make[2]: Leaving directory `/download/mysql-3.23.43/sql-bench' Making all in mysql-test make[2]: Entering directory `/download/mysql-3.23.43/mysql-test' make[2]: *** No rule to make target `all'. Stop. make[2]: Leaving directory `/download/mysql-3.23.43/mysql-test' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/download/mysql-3.23.43' make: *** [all-recursive-am] Error 2 Any help would be highly appreciated. Thanks Saqib Ali - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: compile problems on Solaris8
I don't think the manual page at http://www.mysql.com/doc/S/o/Solaris.html is much help here. It mentions setting ac_cv_sys_restartable_syscalls=${ac_cv_sys_restartable_syscalls='no'} in your config.cache in case of a particular error, not the one reported here. I think I remember reading somewhere that configure was updated at some point to take care of this, but I couldn't find it mentioned in the Change Log, so maybe that's just my imagination. In any case, configure took care of this for me in 3.23.44. There is also a comment at the bottom of the page which says Solaris 8 doesn't seem to have an automatic LD_LIBRARY_PATH environment variable defined... This could also be said of Solaris 2.6 and 7, and seems unlikely to be relevant, since the problem only occurs on 8. LD_LIBRARY_PATH isn't the Solaris way of doing things. Michael On Fri, 30 Nov 2001, Ravi Raman wrote: Hi. This didn't seem to make it to the list the first time so let's try again. BTW is anybody else receiving each mail twice from the list? It did, it's just that no one answered it. :] Not me, the last time I thought that was happening, it had to do with my mail sorting rules in Outlook. I am getting the same error message configure: error: cannot run test program while cross compiling. I think this a simple PATH issue where basic functions such as sprintf are not found. It's been a while since I tried to compile mysql on a Solaris box, but that error most like likely indicates a compiler-related issue...I don't know how much help I can be with this, but one thing missing from your earlier post is what arguments (if any) you passed to ./configure. I'd be interested to see those if you could post them. I was just about to hit send, when I got curious and found something: This page (http://www.mysql.com/doc/S/o/Solaris.html) says to add a line to your config.cache, and also has recommended configure arguments. hth. -ravi. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 and RAID question
On Friday 30 Nov 2001 16:33, Jason Burfield wrote: First of all, the idea of data loss because one disk has gone bad on RAID-5 is not possible. RAID-5 specifically allows you to loose up to 1 disk at any one time, and stay active. The reason why RAID-5 is not recommended for MySQL is speed. RAID-5 requires parity bits to be calculated and spread across all your disks for every write you do. For every read, this all has to be decoded. This means that the file system is slower, which is not very helpful for a database. I am running SCSI RAID-5 (Linux - software only), and I have had no problems. I have lost a disk from a stripe before, and no data was ever corrupted. You just put in a new disk and rebuild the data on it. It's as simple as that. RAID tends not to mess up the performance too much is you are running SMP (if you've got multiple CPUs, it is easier to find time on them to do the RAID-5 checksumming) and you have lots of RAM to keep things nicely cached. Regard. Gordan I currently run a system with Raid 5. I have had one disk drop, however, no data was lost. That is one of the beauties of RAID 5, you have a spare disk that takes over. I too had heard originally that running MySQL on a RAID 5 was a bad idea (this, after I already had it running...), however, I have not had any problems at all. On Thu, 2001-11-29 at 17:34, Lionlike MySQL Email List wrote: Just one quick question... I've heard that running a database in a system using RAID isn't a good idea on RAID 5, but works fine with mirroring (0, 0/1, 0/5). Does anyone out there have experience with MySQL on RAID 5, or know how MySQL performs in a RAID 5 environment? My concern is loss of data due to a drive going bad. At least that what I've heard could happen. 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
PACK_KEYS error
I appreciate all the help that you all have provided I've got another one for you all. I am receiving the following error when I try to restore a database backup from an .sql file: ERROR 1064 at line 12: You have an error in your SQL syntax near 'PACK_KEYS=1' at line 11 Code used: DROP TABLE IF EXISTS Advertisers; CREATE TABLE Advertisers ( AdvertisersKey smallint(5) unsigned NOT NULL auto_increment, AdvertiserID int(11) NOT NULL default '0', Advertiser char(50) NOT NULL default '', AdvertiserFr char(50) default NULL, AdvertDescr char(250) default NULL, PRIMARY KEY (AdvertisersKey), UNIQUE KEY AdvertiserID (AdvertiserID), KEY IdxAdvert (Advertiser(10)), UNIQUE KEY Advertiser (Advertiser) ) TYPE=ISAM PACK_KEYS=1; Cmd used to create sql: mysqldump --user=username --add-drop-table -pblahblah dbdatabasenamefilename.sql Cmd used to restore from sql: mysql --user=root -p backupdatabasenamefilename.sql Can anybody help me? Steve Osborne Database Programmer Chinook Multimedia Inc. [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
ERD
Anyone know a good ERD program that will also interact with MySQL to write the CREATE scripts? As usual open source would be nice, also running on a win2k workstation. I used to use PowerDesigner. Nice software but too expensive. Won = Not being a materialist in the U.S. is kind of like not appreciating opera if you live in Milan or art if you live in Paris. We support materialism better than any other culture. Because retailing and distribution are so efficient here, stuff is cheaper than anywhere else in the world. And then we have huge houses in which to archive our stuff. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: compile problems on Solaris8
Well, this changes things (in my mind, anyway). Now that we know it can be done, the likely explanation is that something is wrong with the gcc installation for people who report this. It's strange though, since a few people who've reported this have claimed to be able to successfully build other programs with the same gcc. Perhaps the problem lies in the command line they've used to invoke configure... In any case, the error meesage from configure is misleading and unhelpful. It is hard to imagine any way to install sunfreeware's pre-compiled gcc that would turn it into a cross-compiler. Certainly, the test you show here could not show more than whether or not the compiler works. Perhaps the next release of mysql could have a better error message from configure. Michael On Fri, 30 Nov 2001, Philip Molter wrote: On Fri, Nov 30, 2001 at 11:56:05AM -0500, Michael Stassen wrote: : : This keeps coming up. So far (in my reading of this list since spring, : and searches on Google), : : * everyone who has reported this was using the precompiled binary of gcc : (either 2.95.2 or 2.95.3) from Sunfreeware to build MySQL for Solaris 8 : sparc. : : * No one has spoken up to report success with this combination. : : * No one who built gcc from source has reported this problem. I will say that I have built MySQL 3.23.x several times on Solaris 8 sparc machines with gcc-2.95.2 and gcc-2.95.3 from sunfreeware.com with absolutely no problems. I use the same options that AB uses to compile their binary distributions, and I make test every time with no issues. From the configure file: cat conftest.$ac_ext EOF #line 1460 configure #include confdefs.h main(){return(0);} EOF if { (eval echo configure:1465: \$ac_link\) 15; (eval $ac_link) 25; } test -s conftest${ac_exeext}; then ac_cv_prog_cc_works=yes # If we can't run a trivial program, we are probably using a cross compiler. if (./conftest; exit) 2/dev/null; then ac_cv_prog_cc_cross=no else ac_cv_prog_cc_cross=yes fi else echo configure: failed program was: 5 cat conftest.$ac_ext 5 ac_cv_prog_cc_works=no fi It looks like the test to determine whether a cross-compiler is being dealt with is very simple. Perhaps, for some reason, that simple program isn't being compiled correctly. Test and see. That would be where I would start. * Philip Molter * Texas.net Internet * http://www.texas.net/ * [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERD
On Fri, Nov 30, 2001 at 12:15:26PM -0500, Won Lee wrote: Anyone know a good ERD program that will also interact with MySQL to write the CREATE scripts? As usual open source would be nice, also running on a win2k workstation. I used to use PowerDesigner. Nice software but too expensive. Just saw announcement for Data Architect from www.thekompany.com Check it out... -- Regards, Doug - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERD
I've not used it yet, but I saw this on freshmeat: Data Architect from the Kompany http://www.thekompany.com/products/dataarchitect/ Won Lee wrote: Anyone know a good ERD program that will also interact with MySQL to write the CREATE scripts? As usual open source would be nice, also running on a win2k workstation. I used to use PowerDesigner. Nice software but too expensive. Won - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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:Another Lack of InnoDB ...... comparing to MyISAM
Ady, what version of MySQL you are running? In 3.23.44 there was a bug which could cause an assertion failure in trx0trx.c, line 178. Please test with 3.23.45 or .46. Regards, Heikki http://www.innodb.com -- Order commercial MySQL/InnoDB support at https://order.mysql.com/ After having experience with InnoDB and MyISAM.. There's lack in MySQL engine with InnoDB comparing to MySQL with MyISAM the problem exists when you do wrong with my.cnf configuration file for example do wrong in max_connections, table_cache Using MyISAM although with configuration key_buffer_size + (record_buffer + sort_buffer)*max_connections is greater than existing physical memory, MySQL server never crash BUT using InnoDB when you do key_buffer_size + (record_buffer + sort_buffer)*max_connections greater than memory could use by MySQL, it will crash in very heavy load for example here. RAM 256 Mbyte, Swap 512 Mbyte with the same configuration using MyISAM, never crash, but with InnoDB crashed 011127 21:09:51 InnoDB: Started /usr/sbin/mysqld-max: ready for connections A mysqld process already exists at Wed Nov 28 13:45:03 EST 2001 InnoDB: Assertion failure in thread 2096211 in file trx0trx.c line 178 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [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: Designing a database to track files
Hi Erik, In the files table, each row corresponds to a separate file. There's all sorts of additional criteria, but the only one that matters to my question is the column called div_id. That's right, the number in That's exactly what I would recommend you to do. As you wrote, you can easily add more divisions or change division names without affecting the data stored in files or modifying the table structure. SELECT files.file_name FROM files WHERE files.file_id = divisions.div_id AND divisions.div_name = division1 ; That's nearly correct. You could use SELECT files.file_name FROM files, divisions WHERE files.file_id = divisions.div_id AND divisions.div_name = 'divisions1'; Note that both tables you wish to include in the query need to be written after the FROM command. This type of query is called a JOIN. You can find more information on that in the MySQL manual and at http://www.devshed.com/Server_Side/MySQL/Join. At devshed, they have some other interesting material on MySQL as well. Additionally, you should always use single ticks (') around strings. Double ticks work with MySQL, but since this violates the ANSI SQL standards, you will run into problems if you ever decide to port your application to another database system. Jens - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB select slow too
Chris, what is your my.cnf or my.ini like? Do you have a big enough innodb_buffer_pool_size? Regards, Heikki http://www.innodb.com -- Order commercial MySQL/InnoDB support at https://order.mysql.com/ [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Just to followup on my comment about InnoDB inserts, it appears the selects are an order of magnitude slower than on BDB too... This is crazy! I know I must be doing something wrong, but what? What magick twidley bit do i need to run? hopeingly... Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERD
Anyone know a good ERD program that will also interact with MySQL to write the CREATE scripts? As usual open source would be nice, also running on a win2k workstation. I used to use PowerDesigner. Nice software but too expensive. I have used PowerDesigner for years and have found it to be a great tool. But it has always been very expensive. So I created DataArchitect. Data Architect is ERD centric, works on Win2K and Linux (has been ported to others such as OSX but not availible on those platforms yet). Its file format is XML and it works with MySQL and PostgreSQL... as well as others via the SQL92 model. I encourage you to check it out at... http://www.codebydesign.com/DataArchitect OR http://www.thekompany.com/products/dataarchitect/ Buying a copy will allow us to get more resources on this, and at least two Open Source projects (unixODBC and FreeTDS). Suffice to say we are not out to make a bucket load of cash we just want to fund our development. Some people buy Data Architect just to encourage the development. Of course; it is already very useful. Peter BTW: I am currently working on a Report Builder which is inspired by Crystal Reports. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SQL syntax error
Sorry for the repost of this problem, but I can't find the answer anywhere, and I'm stuck here until I solve this. I am receiving the following error when I try to restore a database backup from an .sql file: ERROR 1064 at line 12: You have an error in your SQL syntax near 'PACK_KEYS=1' at line 11 Code used: DROP TABLE IF EXISTS Advertisers; CREATE TABLE Advertisers ( AdvertisersKey smallint(5) unsigned NOT NULL auto_increment, AdvertiserID int(11) NOT NULL default '0', Advertiser char(50) NOT NULL default '', AdvertiserFr char(50) default NULL, AdvertDescr char(250) default NULL, PRIMARY KEY (AdvertisersKey), UNIQUE KEY AdvertiserID (AdvertiserID), KEY IdxAdvert (Advertiser(10)), UNIQUE KEY Advertiser (Advertiser) ) TYPE=ISAM PACK_KEYS=1; Cmd used to create sql: mysqldump --user=username --add-drop-table -pblahblah dbdatabasenamefilename.sql Cmd used to restore from sql: mysql --user=root -p backupdatabasenamefilename.sql Can anybody help me? Steve Osborne Database Programmer Chinook Multimedia Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB select slow too
Heikki Tuuri wrote: Chris, what is your my.cnf or my.ini like? Do you have a big enough innodb_buffer_pool_size? set-variable = innodb_buffer_pool_size=300M big enough? Chris database, sql, query, table (just to keep the stoopid list software from whinging..) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Designing a database to track files
Jens, That is great news! You've made my day -- that means that the rest of my tables should work with JOIN queries, as I am building them along the same model -- using ID numbers instead of actual names to connect to the main files table. Thanks for clearing that up for me. And also for the tip about using single ticks. Sincerely, Erik On Friday, November 30, 2001, at 01:53 PM, Jens Vonderheide wrote: That's nearly correct. You could use SELECT files.file_name FROM files, divisions WHERE files.file_id = divisions.div_id AND divisions.div_name = 'divisions1'; Note that both tables you wish to include in the query need to be written after the FROM command. This type of query is called a JOIN. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: compile problems on Solaris8
OK I managed to get passed the cross compiler error. Thanks for the links Ravi and Alan. I included /usr/local/lib in my LD_LIBRARY_PATH and that seemed to do the trick and allowed configure to finish however I am still concerned about certain things not being found among others: checking for working aclocal... missing checking for working autoconf... missing checking for working automake... missing checking for working autoheader... missing checking for working makeinfo... missing Now make dies on the following error: # make make all-recursive make[1]: Entering directory `/usr/local/mysql-3.23.44' Making all in include make[2]: Entering directory `/usr/local/mysql-3.23.44/include' make[2]: Nothing to be done for `all'. make[2]: Leaving directory `/usr/local/mysql-3.23.44/include' Making all in Docs make[2]: Entering directory `/usr/local/mysql-3.23.44/Docs' make[2]: Nothing to be done for `all'. make[2]: Leaving directory `/usr/local/mysql-3.23.44/Docs' Making all in readline make[2]: Entering directory `/usr/local/mysql-3.23.44/readline' gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -I./../include -I./.. -I..-O3 -DDBUG_OFF -O6 -DHAVE_CURSES_H -I/usr/local/mysql-3.23.44/include -DHAVE_RWLOCK_T -c bind.c /usr/ccs/bin/as: /var/tmp/ccfZvbWR.s, line 413: error: unknown opcode .subsection /usr/ccs/bin/as: /var/tmp/ccfZvbWR.s, line 413: error: statement syntax /usr/ccs/bin/as: /var/tmp/ccfZvbWR.s, line 489: error: unknown opcode .previous /usr/ccs/bin/as: /var/tmp/ccfZvbWR.s, line 489: error: statement syntax make[2]: *** [bind.o] Error 1 make[2]: Leaving directory `/usr/local/mysql-3.23.44/readline' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/local/mysql-3.23.44' make: *** [all-recursive-am] Error 2 so I comented out the two lines in configure.h re HAVE_CURESES_H then make got a bit further: # make make all-recursive make[1]: Entering directory `/usr/local/mysql-3.23.44' Making all in include make[2]: Entering directory `/usr/local/mysql-3.23.44/include' /usr/bin/cp ../config.h my_config.h make[2]: Leaving directory `/usr/local/mysql-3.23.44/include' Making all in Docs make[2]: Entering directory `/usr/local/mysql-3.23.44/Docs' make[2]: Nothing to be done for `all'. make[2]: Leaving directory `/usr/local/mysql-3.23.44/Docs' Making all in readline make[2]: Entering directory `/usr/local/mysql-3.23.44/readline' gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -I./../include -I./.. -I..-O3 -DDBUG_OFF -DHAVE_CURSES_H -I/usr/local/mysql-3.23.44/include -DHAVE_RWLOCK_T -c readline.c gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -I./../include -I./.. -I..-O3 -DDBUG_OFF -DHAVE_CURSES_H -I/usr/local/mysql-3.23.44/include -DHAVE_RWLOCK_T -c funmap.c gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -I./../include -I./.. -I..-O3 -DDBUG_OFF -DHAVE_CURSES_H -I/usr/local/mysql-3.23.44/include -DHAVE_RWLOCK_T -c keymaps.c gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -I./../include -I./.. -I..-O3 -DDBUG_OFF -DHAVE_CURSES_H -I/usr/local/mysql-3.23.44/include -DHAVE_RWLOCK_T -c vi_mode.c gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -I./../include -I./.. -I..-O3 -DDBUG_OFF -DHAVE_CURSES_H -I/usr/local/mysql-3.23.44/include -DHAVE_RWLOCK_T -c rltty.c gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -I./../include -I./.. -I..-O3 -DDBUG_OFF -DHAVE_CURSES_H -I/usr/local/mysql-3.23.44/include -DHAVE_RWLOCK_T -c complete.c gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -I./../include -I./.. -I..-O3 -DDBUG_OFF -DHAVE_CURSES_H -I/usr/local/mysql-3.23.44/include -DHAVE_RWLOCK_T -c bind.c /usr/ccs/bin/as: /var/tmp/cc7dTZhq.s, line 413: error: unknown opcode .subsection /usr/ccs/bin/as: /var/tmp/cc7dTZhq.s, line 413: error: statement syntax /usr/ccs/bin/as: /var/tmp/cc7dTZhq.s, line 489: error: unknown opcode .previous /usr/ccs/bin/as: /var/tmp/cc7dTZhq.s, line 489: error: statement syntax make[2]: *** [bind.o] Error 1 make[2]: Leaving directory `/usr/local/mysql-3.23.44/readline' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/local/mysql-3.23.44' make: *** [all-recursive-am] Error 2 Now I'm stuck again. HELP! George -- George Horvath Scotia Capital Markets ISS - Technology Application Group Tel: 416-945-4204 Fax: 416-945-4002 E-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: ERD
yeah, but the http://www.thekompany.com/products/dataarchitect/ link to buy the dl version just shows that you have nothing in your cart, and doesn't give you dl options. I recommend not using that site. I wonder how many more errors are in their software, if they cannot even make an html link work properly. I wouldn't trust anything their program would produce to be solid, without verifying every field. ...and what a waste of time that would be. For that just stick to MySQL, it works and it's not too hard to understand. Just the overwhelming use of that darn _. For the http://www.codebydesign.com/DataArchitect link to work you will have to scroll down the header if using ie5/6. john -Original Message- From: Peter Harvey [mailto:[EMAIL PROTECTED]] Sent: Friday, November 30, 2001 1:01 PM To: Won Lee; mysqlList Subject: Re: ERD Anyone know a good ERD program that will also interact with MySQL to write the CREATE scripts? As usual open source would be nice, also running on a win2k workstation. I used to use PowerDesigner. Nice software but too expensive. I have used PowerDesigner for years and have found it to be a great tool. But it has always been very expensive. So I created DataArchitect. Data Architect is ERD centric, works on Win2K and Linux (has been ported to others such as OSX but not availible on those platforms yet). Its file format is XML and it works with MySQL and PostgreSQL... as well as others via the SQL92 model. I encourage you to check it out at... http://www.codebydesign.com/DataArchitect OR http://www.thekompany.com/products/dataarchitect/ Buying a copy will allow us to get more resources on this, and at least two Open Source projects (unixODBC and FreeTDS). Suffice to say we are not out to make a bucket load of cash we just want to fund our development. Some people buy Data Architect just to encourage the development. Of course; it is already very useful. Peter BTW: I am currently working on a Report Builder which is inspired by Crystal Reports. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
outer join question
I'm having difficulty doing a LEFT OUTER JOIN, and was hoping someone could shed a little light on what I'm doing: Table A has one column, val, that's an integer. There are 90 records, with values of val from 1-90. Looks like this: val --- 1 2 . . . 90 Table B is more sparse, with 2 columns: id status -- -- 2Good 4Bad I've joined them an SQL statement that looks like this: select val, status from A left outer join B on val=id; What I'd LIKE is a 90-row result set, with the status field from table B when there was data available. What I'm getting is essentially an INNER join, only returning me 2 rows. What am I doing wrong? --Harlan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqldump: problem/question
I knew it. Nobody bothered to read my post. The original problem involved running a lightweight version of mysqldump in a simulated nanokernel environment with reduced power resources. The ultimate result, we hope, is to use it to record Quidditch matches being played in Afghanistan. Thanks, --Walt Weaver Bozeman, Montana, USA -Original Message- From: sherzodR To: Weaver, Walt Cc: [EMAIL PROTECTED] Sent: 11/30/2001 3:14 AM Subject: re: mysqldump: problem/question So what was the problem? Weaver, Walt wrote: WW: Okay, I know you guys have been wracking your brains for the last two days WW: trying to solve my problem of mysqldump running out of memory while dumping WW: a large table. WW: WW: I figured it out, so you can all go on with your lives. WW: WW: My copy of Paul DuBois' MySQL book came today and immediately solved my WW: problem. WW: WW: Cool book. Now I have something to do this weekend. WW: WW: Thanks, WW: --Walt Weaver WW: Bozeman, Montana WW: Oracle smart, MySQL dumb (for now) WW: WW: - WW: Before posting, please check: WW:http://www.mysql.com/manual.php (the manual) WW:http://lists.mysql.com/ (the list archive) WW: WW: To request this thread, e-mail [EMAIL PROTECTED] WW: To unsubscribe, e-mail [EMAIL PROTECTED] WW: Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php WW: -- sherzodR [EMAIL PROTECTED] use CGI::Session; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql Book
Are there anyone from Auckland , New Zealand that can tell me where I can get a good book on mysql? 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
connection problem with timeouts in error logs
Hi, I've got a *BIG* problem here... I have a mysql database with some big tables (50,000 - 80,000 records and above) running on a netbsd machine. Users run queries from their windoze machines through a delphi program via myodbc. I didn't write that application so I can only guess the queries that are made... (judging the load -- SELECT * from...???) As long as there is only *one* user doing his queries mysql is running just as smooth as a melting piece of butter in the hot frying pan BUT when more users try to do so things are getting *real* slow - people told me they had to wait ten minutes for the return of 26 records which took 10-15 seconds at most some time before (assuming there was only one user querying..). Besides that my log files fill up with messages of the following kind: Aborted connection 103 to db: 'XXX' user: 'XXX' host: `XXX.XXX.XXX.XXX' (Got timeout reading communication packets) I've already browsed through different forums and lists and all the issues and solutions did not help a bit: TCP config issues: nope, 'cause I can use telnet or the mysql client through port 3306... Ethernet Full duplex bug (??? what the #+*%$§ ???): nope again, ftping big files working ok - no errors safe_mysqld: the ulimit fix for bsd systems is active. I raised the variable values (key_buffer, max_allowed_packets..., ya know) for the mysql daemon in my.cnf, restarted and mysqladmin variables returned proper values. finally some more system info: PIII 933 512MB RAM OS: NetBSD 1.5.2 MySQL 2.23.35 no other application is running on the system Oh - I forgot: because of file system issues (NetBSD users might know what I'm talking about - mysql package standard install path... I should have compiled from source...) the database is symbolically linked... A very nice guy named Mike (thx again) mailed me that the prob might be improperly formatted records, but I wasn't able to contact the app programmer for debugging issues yet... Any other ideas are most welcome, 'cause this is getting *really* hot for me, as the system should be going productive next week - :^(--moan--sweat--groan--:^( thanx in advance marc - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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:Another Lack of InnoDB ...... comparing to MyISAM
On Saturday 01 December 2001 01:49, Heikki Tuuri wrote: Ady, what version of MySQL you are running? In 3.23.44 there was a bug which could cause an assertion failure in trx0trx.c, line 178. I use MySQL 3.23.44, i try to download mysql 3.23.45 from Mysql.com but it always fail, any mirror Please test with 3.23.45 or .46. Regards, Heikki http://www.innodb.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: outer join question
Harlan Feinstein [EMAIL PROTECTED] wrote: I've joined them an SQL statement that looks like this: select val, status from A left outer join B on val=id; What I'd LIKE is a 90-row result set, with the status field from table B when there was data available. What I'm getting is essentially an INNER join, only returning me 2 rows. The following should work (and is probably the same as the syntax you used). If the datatype of id is numeric and that of val is character then it might not work. I believe the joined fields will need to be of the same type. Are they? SELECT val, status FROM A LEFT JOIN B ON val=id -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fwd: ERD
the problem John is experiencing is because he didn't actually select a product to purchase. It is hard to add nothing to your shopping cart, so that is exactly what we do. There are two purchase options, one is CD and one is Download, and you must choose one before you add it to your cart. Shawn Gordon President theKompany.com -- Forwarded Message -- Subject: RE: ERD Date: Fri, 30 Nov 2001 14:09:50 -0600 From: john [EMAIL PROTECTED] To: Peter Harvey [EMAIL PROTECTED], Won Lee [EMAIL PROTECTED], mysqlList [EMAIL PROTECTED] yeah, but the http://www.thekompany.com/products/dataarchitect/ link to buy the dl version just shows that you have nothing in your cart, and doesn't give you dl options. I recommend not using that site. I wonder how many more errors are in their software, if they cannot even make an html link work properly. I wouldn't trust anything their program would produce to be solid, without verifying every field. ...and what a waste of time that would be. For that just stick to MySQL, it works and it's not too hard to understand. Just the overwhelming use of that darn _. For the http://www.codebydesign.com/DataArchitect link to work you will have to scroll down the header if using ie5/6. john -Original Message- From: Peter Harvey [mailto:[EMAIL PROTECTED]] Sent: Friday, November 30, 2001 1:01 PM To: Won Lee; mysqlList Subject: Re: ERD Anyone know a good ERD program that will also interact with MySQL to write the CREATE scripts? As usual open source would be nice, also running on a win2k workstation. I used to use PowerDesigner. Nice software but too expensive. I have used PowerDesigner for years and have found it to be a great tool. But it has always been very expensive. So I created DataArchitect. Data Architect is ERD centric, works on Win2K and Linux (has been ported to others such as OSX but not availible on those platforms yet). Its file format is XML and it works with MySQL and PostgreSQL... as well as others via the SQL92 model. I encourage you to check it out at... http://www.codebydesign.com/DataArchitect OR http://www.thekompany.com/products/dataarchitect/ Buying a copy will allow us to get more resources on this, and at least two Open Source projects (unixODBC and FreeTDS). Suffice to say we are not out to make a bucket load of cash we just want to fund our development. Some people buy Data Architect just to encourage the development. Of course; it is already very useful. Peter BTW: I am currently working on a Report Builder which is inspired by Crystal Reports. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [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: Re: ERD
database,sql,query,table yeah, but the http://www.thekompany.com/products/dataarchitect/ link to buy the dl version just shows that you have nothing in your cart, and doesn't give you dl options. I recommend not using that site. I have forwarded your comments to the CEO of theKompany. I am sure that it will get addressed promptly. Thanks for pointing it out. For the http://www.codebydesign.com/DataArchitect link to work you will have to scroll down the header if using ie5/6. Yup; looks fine in konqueror and Netscape (Linux). Sorry; I am too busy coding to worry much about this grin Thanks for the feedback. Peter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: ERD
Thanks Peter, I have already addressed the issue with sales/webmaster, and they are updating the page. Now, that's a Kompany. -Original Message- From: Peter Harvey [mailto:[EMAIL PROTECTED]] Sent: Friday, November 30, 2001 3:25 PM To: john; Won Lee; mysqlList Subject: Re: ERD yeah, but the http://www.thekompany.com/products/dataarchitect/ link to buy the dl version just shows that you have nothing in your cart, and doesn't give you dl options. I recommend not using that site. I have forwarded your comments to the CEO of theKompany. I am sure that it will get addressed promptly. Thanks for pointing it out. For the http://www.codebydesign.com/DataArchitect link to work you will have to scroll down the header if using ie5/6. Yup; looks fine in konqueror and Netscape (Linux). Sorry; I am too busy coding to worry much about this grin Thanks for the feedback. Peter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Running queries while queries are still running
I have a query. It (should) return one row. It normally does, except when I do something like this: (query) (loop through results) (update table that was in the first query) When I do this logic in Perl/DBI, it seems to restart the loop, returning the same row, over and over again. Can this be right? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Running queries while queries are still running
On Fri, 30 Nov 2001 15:25:18 -0700, Ken Kinder [EMAIL PROTECTED] wrote: I have a query. It (should) return one row. It normally does, except when I do something like this: (query) (loop through results) (update table that was in the first query) When I do this logic in Perl/DBI, it seems to restart the loop, returning the same row, over and over again. Can this be right? It helps to post part of the code your using to better understand the problem. :) Altho this more of DBI/Perl question then MySQL.. ;) Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Running queries while queries are still running
Please show us your Perl code and then we can have a look and try to find what is wrong, Cheers Karl. - Original Message - From: Ken Kinder [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 30, 2001 10:25 PM Subject: Running queries while queries are still running I have a query. It (should) return one row. It normally does, except when I do something like this: (query) (loop through results) (update table that was in the first query) When I do this logic in Perl/DBI, it seems to restart the loop, returning the same row, over and over again. Can this be right? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: SQL syntax error
I created the file with ver 3.23.43, tried to recreate database on 3.22.32. I administer 2 other databases the same commands and they work fine. I looked at the difference in the sql files, and those ones don't contain the PACK_KEYS statement...just TYPE=myISAM. The command used to create the sql files hasn't changed, and the databases are hosted by the same ISP. It's a confusing situation. I don't want to have to go back and manually change each .sql file each day to complete the backup process. I wouldn't get any other work done. Any other suggestions? Steve [EMAIL PROTECTED] - Original Message - From: Steve Werby [EMAIL PROTECTED] To: Steve Osborne [EMAIL PROTECTED]; MySQL (E-mail) [EMAIL PROTECTED] Sent: Friday, November 30, 2001 2:58 PM Subject: Re: SQL syntax error Steve Osborne [EMAIL PROTECTED] wrote: I am receiving the following error when I try to restore a database backup from an .sql file: ERROR 1064 at line 12: You have an error in your SQL syntax near 'PACK_KEYS=1' at line 11 snip ) TYPE=ISAM PACK_KEYS=1; /snip Cmd used to create sql: mysqldump --user=username --add-drop-table -pblahblah dbdatabasenamefilename.sql Cmd used to restore from sql: mysql --user=root -p backupdatabasenamefilename.sql You didn't mention your version of MySQL, but I suspect it's old. Remove the PACK_KEYS=1 text and it should work fine. I also suggest upgrading to a more recent MySQL if in fact you're running an older version. -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
question about temp tables
Hi While tuning the system to minimize locking, I added SQL_BUFFER_RESULT to some of my select statements. Since then have been seeing a lot of created_tmp_disk_tables e.g. below is what I see after restarting the system for less than an hour. | Created_tmp_disk_tables | 515 | | Created_tmp_tables | 717 | | Created_tmp_files| 0 | I have my temp table variables set to quite high and are fairly certain that my queries are less than 64M (any way to tell?). set-variable= tmp_table_size=64M set-variable= max_tmp_tables=100 set-variable= max_heap_table_size=64M Anything I have done wrong or should look into? Anyway to see what temp tables are being created and what for? regards, Teck Lee - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
descending keys
Why doesn't MySQL support descending keys in indexes? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql_insert_id and transactions
allrighty, for you perl/mysql folks here is the trouble I'm having. I'm tyring to do a transaction in mysql/innodb in perl with the following basic flow eval{ Insert my first record get the insert_id (using $sth-{mysql_insert_id}) now perform other inserts that need that key commit; }; if($@) { rollback; and other logic } the only problem is the {mysql_insert_id} doesn't give me anything back. NADA... Is this a bug only in transactions or innodb? since I know the function is working in autocommit / MyIsam tables. Do I have to do the select last_insert_id ? Because that IS working (and consequently what I am doing now). using .43 on linux RH7.1 compiled from source -- Jayce^ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SQL syntax error
In the last episode (Nov 30), Steve Osborne said: I created the file with ver 3.23.43, tried to recreate database on 3.22.32. I administer 2 other databases the same commands and they work fine. I looked at the difference in the sql files, and those ones don't contain the PACK_KEYS statement...just TYPE=myISAM. The command used to create the sql files hasn't changed, and the databases are hosted by the same ISP. It's a confusing situation. I don't want to have to go back and manually change each .sql file each day to complete the backup process. I wouldn't get any other work done. Any other suggestions? * Upgrade the 2nd server to mysql 3.23 (preferable). It's really old. * Remove the PACK_KEYS flag from the 1st server's tables. mysql ALTER TABLE mytable PACK_KEYS=0; * Parse the mysqldump output to remove the PACK_KEYS flag before loading: mysqldump -h oldhost db | sed -e 's/ PACK_KEYS=1//' | mysql -h newhost db -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL, Red Hat Linux and php
Hi, As always, the best version of MySQL to work with is the latest stable release 3.23.46 :) Regards, Jorge -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico ___/ www.mysql.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 6:03 AM To: [EMAIL PROTECTED] Subject: MySQL, Red Hat Linux and php Hello, Which version of MySQL ( RPM packages ) is good for work with php 4.0.6 and Linux Red Hat 6.2 ? Thank for your help ! Edward. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: descending keys
Try giving a range in the where clause, I have the latest source (from bit keeper and it seems to alway use the index here) there is lots of good things coming in 4.0.1. Here I've provide some examples from my test system. Using a date field. Forcing both a sorted response and an unsorted response. I think there will be improvements in 4.0.1, and more in 4.0.2! Best of luck again, I am goin home soon! Ken Here are my examples (this is a fairly slow old system): mysql select count(*) from sali; +--+ | count(*) | +--+ |11534 | +--+ 1 row in set (0.02 sec) mysql select saliDate,saliRef from sali order by saliDate desc limit 10; +-+-+ | saliDate| saliRef | +-+-+ | 2001-08-07 15:22:19 |1779 | | 2001-08-07 13:04:18 | 1 | | 2001-06-22 10:01:55 |1777 | | 2001-06-22 09:58:30 |1776 | | 2001-06-22 09:55:36 |1775 | | 2001-06-19 13:33:41 | 1 | | 2001-06-09 11:07:38 | 3 | | 2001-06-09 11:07:38 | 3 | | 2001-06-09 11:07:38 | 3 | | 2001-05-29 19:32:43 | 52 | +-+-+ 10 rows in set (0.02 sec) mysql explain select saliDate,saliRef from sali order by saliDate desc limit 10; +---+---+---+--+-+--+---+- --+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---+---+---+--+-+--+---+- --+ | sali | index | NULL | saliDate | 10 | NULL | 11534 | | +---+---+---+--+-+--+---+- --+ 1 row in set (0.02 sec) Another explain (without saliRef in the response): mysql explain select saliDate from sali order by saliDate desc limit 10; +---+---+---+--+-+--+---+- + | table | type | possible_keys | key | key_len | ref | rows | Extra | +---+---+---+--+-+--+---+- + | sali | index | NULL | saliDate | 10 | NULL | 11534 | Using index | +---+---+---+--+-+--+---+- + 1 row in set (0.02 sec) mysql And here I force it to sort, by not using an index in the order by: mysql select saliDate,saliRef from sali order by saliRef desc limit 10;+-+-+ | saliDate| saliRef | +-+-+ | 2001-08-07 15:22:19 |1779 | | 2001-06-22 10:01:55 |1777 | | 2001-06-22 09:58:30 |1776 | | 2001-06-22 09:55:36 |1775 | | 2001-05-29 19:14:29 |1774 | | 2001-05-29 18:02:58 |1773 | | 2001-05-29 16:23:08 |1772 | | 2001-05-29 14:51:48 |1771 | | 2001-05-29 14:45:16 |1770 | | 2001-05-29 14:44:27 |1769 | +-+-+ 10 rows in set (0.23 sec) +---+---+---+-+-+--+---+-- ---+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---+---+---+-+-+--+---+-- ---+ | sali | index | NULL | PRIMARY | 20 | NULL | 11534 | Using index; Using filesort | +---+---+---+-+-+--+---+-- ---+ 1 row in set (0.01 sec) mys - Original Message - From: Franklin Schmidt [EMAIL PROTECTED] To: Ken Menzel [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, November 30, 2001 7:50 PM Subject: Re: descending keys Ken Menzel wrote: Actually it MySQL 4 does. There is a small bug in it right now where it won't use the descending index witout a range in the where clause, but this is supposed to be fixed in 4.0.2. Thanks, I am using MySQL 4. I actually want this for order by. When I do create index idx on t (i1, i2 desc, i3) and then do show index from t, I only see A in the Collation column. When I do explain select * from t order by i1, i2 desc, i3, I see that it does a filesort. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
table full
DBD::mysql::st execute failed: The table 'ip_src' is full at /usr/local/lib/perl5/site_perl/5.005/i386-freebsd/Mysql.pm line 172. I get this error when running a query on my database. According to the documentation, in later versions of mysql this problem should be bypassed due to the automatic disk-based query if the tmp table becomes to too big. I don't really understand what is wrong. Is it to due to me using innodb tables? Does it mean the innodb data file has become full? Rich - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
compile errors
trying to compile mysql-3.23.46, getting this error. Can't find any reference to it anywhere. Please help; kgcc -O3 -DDBUG_OFF -O9 -rdynamic -o isamchk isamchk.o sort.o libnisam.a ../mysys/libmysys.a ../dbug/libdbug.a ../strings/libmystrings.a -lpthread -lz -lcrypt -lnsl -lm -lpthread ../mysys/libmysys.a(mf_tempfile.o): In function `create_temp_file': mf_tempfile.o(.text+0xcd): undefined reference to `mkstemp64' collect2: ld returned 1 exit status make[2]: *** [isamchk] Error 1 make[2]: Leaving directory `/src/mysql-3.23.46/isam' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/src/mysql-3.23.46' make: *** [all-recursive-am] Error 2 Vern H. Gill State Director Director of Marketing Conejo Valley Jaycees http://www.conejovalleyjaycees.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
lower_case_table_names not working?
OK, so I'm on a slightly older version for this experiment (3.23.36).. I tried restarting mysqld with the line set=lower_case_table_names=1 in my my.cnf (on RedHat 7.1), and have a table called ipaddr in my database (the files are ipaddr.frm, ipaddr.MYD and ipaddr.MYI). (I have verified with show variables that this setting has been accepted). However, the following query still fails: select * from IpAddr; (says ERROR 1146: Table 'test.IpAddr' doesn't exist). Am I misunderstanding what this option does? I'm trying to port some code from Oracle that's very careless about the case of table names, and I need it to work in MySQL on Linux.. Thanks in advance, -- Shankar. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: many connection errors
Support wrote: Hi i have php4.0.6 Can't see why i should change apache as i don't see that as the problem. is it a know issue in MySQL that 3.23.45 fixes? if not i don't upgrade everytime there is a new release. The server has been up since april this year and this is first time the error has happened. It is prob caused by more of my users having php forums. What i need to find out is root of the cause Mark Hello, I have ever installed Linux Red Hat 7.0 , there is no any problem about apache, php and MySQL... So, what do you want me to help you ? Edward. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php