Re: MySQL on HP/UX 10.20 problem
Installing all prepared tables 010423 11:09:07 Warning: setrlimit couldn't increase number of open files to more than 200 010423 11:09:07 Warning: Changed limits: max_connections: 100 table_cache: 64 scripts/mysql_install_db[284]: 15102 Memory fault(coredump) Installation of grant tables failed! Having searched for other solutions, one recommendation from a MySQL developer was to look at the MySQL Manual for HP/UX and install all necessary patches. My questions/comments are: 1) How many open files does MySQL require? Different people have reported different numbers where MySQL doesn't work. I don't know how much open files are needed. If finally depends on your usage. I have long since increased the number of open files allowed from the system default, so I really cannot say. (Note that for each connection you will need file descriptors, so when you intend to use a lot of parallel connections, you can expect to run into trouble, if you do not increase the limit. I your usage is low, it may work well for you.) 2) Which patches do I need? The person mention DCE but nothing else. I have not found anything on the HP/UX pages saying which patches are required for MySQL. If it is missing in the documentation, it should be corrected. If you check out the mailing list archive, you will see the requirement to install the DCE patches: PHSS_19739 (required), PHSS_20608 (not sure if required, but at least recommended.) Your memory fault problem above is caused by the misssing patches. Best regards, Lutz -- Lutz Jaenicke [EMAIL PROTECTED] BTU Cottbus http://www.aet.TU-Cottbus.DE/personen/jaenicke/ Lehrstuhl Allgemeine Elektrotechnik Tel. +49 355 69-4129 Universitaetsplatz 3-4, D-03044 Cottbus Fax. +49 355 69-4153 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: min () - sql troubles
Hi SQL troubles: I have a table containing 4 columns: name - string, distance- double, speed - time and id - AUTO_INCREMENT (Primery key) I want a list of the fastest (speed) runner (name) of each distance and the speed. I use: select name, distance, min(speed) from table1 group by distance; I get a list where the speed and the distyance are always correct but the name is not always. Why is that? What should I do? Thanks, // Chris - Copenhagen Sir, try SELECT t1.name, t1. distance, Min(t1.speed) FROM table1 t1, table1 t2 WHERE p1.name = p2.name GROUP BY t1.distance HAVING Min(t1.speed) = Min(t2.speed); I haven't run this, but I think it's correct. Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak MySQL list magic words: sql query database - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with mysql query
Barry, I suspect you might have more luck sending your question to a PowerBuilder list (what is it anyway ? A Borland product ?), althought you might have some luck here... regards, P On Tue, 24 Apr 2001, Barry Reynolds wrote: I am having a problem with setting up a query in using MySql. The query uses a user-defined parameter and searches the table against it. e.g. int search//user peramater select * from table where member_id = :search; When trying to run this query (using powerbuilder) it doesnt return the desired row. However if i use the following query (using a hard-coded member_id), it does work, select * from table where member_id = 0001; I have feeling it is a problem with one of the ODBC options in the database profile. If anyone could help me i would be really thankfull, Thanking you in advance, Barry. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- --- Peter Skipworth Perl Developer/Unix Systems Administrator [EMAIL PROTECTED] +44 795 055 0029 --- 4c 61 20 6c 6f 79 52 75 62 20 73 41 20 65 52 61 20 45 65 62 4f 4c 47 6e 74 20 20 4f 53 75 00 0a - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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... concat group by?
If there is a function to sum values, why there isn't one to sum strings i.e. concat strings. Or how should i use it? You use concat to put two strings together. I know, i have read the manual. /concat('string1','string2')/, but it doesn't works with group by. I would like to get this: 1user1'50 - twenty-three - the reason of life' 2user2'twenty-three - 303 rulz' 3user3'' I tried: SQLSELECT Table1.name, ???(Table3.txt) FROM Table1 left join Table2 on Table1.uid=Table2.uid left join Table3 on Table2.c=Table3.c group by Table1.name; 1user1'50' 2user2'twenty-three' 3user3NULL What function should i use? Z - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Periodical recieving of signal 11
Description: We have a production server with mysql as db server. Currently we are using 1 server for only processing a mysql queries and ther is 4 mysql servers running on it each using diiferent IP. When I try to make 1 common mysql server it just recieving signal 11 after some time. It seems it hangs under heavy load(right before hang I saw statistics and it told me 170 queries/second).Here what I got from logs: mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died. Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, ebp=0xb9fff8b8, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x813744a 0x8137ed0 0x813465d 0x807c2ec 0x8080306 0x8135846 0x815d60a New value of ebp failed sanity check, terminating backtrace! First it hangs at 12:06:23 and totally hanged 8 times till 12:17:43 always with the same backtrace. I compiled mysqld without debug and with maximum perfomance boost options that I could get from manual(I think that is why backtrace cannot determine thread number). When working on 4 mysqld servers which are servicing the same databases they are working much more stable-1 of them never hanged(it has the most databases),2 of them hanged 1 time each, and last one hanged 7 times for all the time, having latest a week ago. This one also hangs with the same backtrace. It has only 2 databases but one of them is accessed viry intensively. Maybe this is a bug, maybe it is my incorrect adjustment of mysql. However I think this is more right to write here than any other place. I can't do full debug on our servers because my boss don't like when something doesn't work, but if I can give you more information you are welcome. BTW, this hangs become to appear when I upgraded from 3.23.29a-gamma to 3.23.33, and exists through 3.23.34a,3.23.36 and 3.23.37. How-To-Repeat: Don't know, just wait for midday when there is heaviest load. Fix: Maybe downgrade, which I don't like Submitter-Id: submitter ID Originator:root Organization: MySQL support: [none] Synopsis: Signal 11 Severity: Priority: Category: mysql Class: Release: mysql-3.23.37 (Source distribution) Environment: System: Linux xeon.tr155m.krystech.ru 2.4.2-4 #9 SMP Mon Mar 5 12:19:58 MSK 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Feb 22 21:52 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x1 root root 4101324 Mar 1 2000 /lib/libc-2.1.3.so -rw-r--r--1 root root 20272704 Mar 1 2000 /usr/lib/libc.a -rw-r--r--1 root root 178 Mar 1 2000 /usr/lib/libc.so Configure command: ./configure --prefix=/opt/local/mysql --with-charset=cp1251 --with-extra-charsets=koi8_ru --enable-assembler --enable-large-files --without-debug --with-mysqld-ldflags=-all-static --with-pthread --without-debug --with-raid --with-gnu-ld --with-mysqld-user=mysql --with-port=3306 --with-unix-socket-path=/tmp/mysql.sock --with-client-ldflags=-all-static Perl: This is perl, version 5.005_03 built for i386-linux - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 myodbc
My application is written in .asp and the database is mysql. do i need myodbc to set the DSN/connection? (running in linux box) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Need help with 23.36
mysql use lum Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Didn't find any fields in table 'users' Database changed mysql select * from users; ERROR 1017: Can't find file: './lum/users.frm' (errno: 13) Please anyone. I really need some ideas. I copied my database files made with 23.29 to 23.26 and now I get this. I chowned mysql.mysql and chmoded 660. The location of the databases is good because I have some other databases created with 36 and they work fine. I copied ALL the database's files to /var/lib/mysql where the others are and I get this error. Any idea? Error code 13 means permission denied. How come your database is named 'lumina' and the directory it resides in (or at least the dir that mysql tries to find the tables in) is ./lum/ ? Shouldn't it be looking under lumina? Check that you don't have your database directories messed up under ~mysql/var/ The files are in the right directory with the right permissions and still I get the errors from above. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Log the connections
hi All, I have in Tomcat JDBCRealms, A broken pipe SQLException, So I wonder what is wrong in my code. This exception occur only after a long period of time, while sessions should be dead long times ago. So I wonder if the connection Pool I use ( org.ewin packadge ), released correctly the connections. So I like to monitor the connection process. I have be through the doc (22 The MySQL log files) In order to see how many connections to my database I have. And I could not find where the connection are logged (or how to set is up). Could someone give me a hint ? -- System Info : Red Hat Linux release 6.2 (Zoot) Kernel 2.2.14-5.0 on an i686 Mysql Ver 11.12 Distrib 3.23.32 java version 1.3.0 Java(TM) 2 Runtime Environment, Standard Edition (build 1.3.0) Java HotSpot(TM) Client VM (build 1.3.0, mixed mode) JDBC Driver : mm.mysql-2.0.4-bin.jar Tomcat 3.2 beta 3 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: fulltext bug(?)
Hi! On Apr 24, Scott Vanderweyst wrote: I know that the web-page says it may return bizzare results in small cases, but I would have expected it to return consistant results though. I came across this due to an inconsistancy that I ran across in an application that I've been working on. One of the fields I have defined as a tinytext, and the data in there is a set of identifiers which are comma seperated.(each identifier is 4 characters long) ~68000 records in the table, there are 64 different identifiers so I assume that I can't use a set. So the crux of the problem is that when the identifiers are all the same, they become 'stop-words' and nothing is returned from the queries. Is there a way to disable the stop-words in the fulltext indexing? If there isn't a way to disable the stop-words, is doing a 'LIKE' or 'RLIKE' even moderately compariable speed-wise, my quick tests show that it isn't even close (1.32 and 1.57 sec vs 0.11 sec), but if it's going to start ignoring the most common identifiers in the database, it's unacceptable, and I'll need to live with the slowdown. Thanks for any advice Scott V See http://www.mysql.com/doc/F/u/Fulltext_Fine-tuning.html 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
accessing mysql remotely
I have mysql installed on two linux boxes. How can i access one system's mysql db from the other system thanks Harish
Re: [PHP-INST] tforum
COME ON This_is_not_a_MySQL_issue.. It has everything to do with PHP.. please keep this discussion in the PHP lists.. By the way, crossposting isn't the way to make friends.. Looking for more info on PHP and MySQL go to some URL's mentions a million times in several PHP lists. Bye, B. At 12:23 24-4-01 +0100, Rob Wilks wrote: I'm probably out of my depth here, but please have a look at my forum at http://forum.celinestar.org.uk. The error messages are like this: Warning: 0 is not a MySQL result index in functions.php on line 16 Warning: 0 is not a MySQL result index in functions.php on line 21 Warning: Oops, php3_SetCookie called after header has been sent in functions.php on line 556 Warning: Oops, php3_SetCookie called after header has been sent in functions.php on line 562 Warning: Oops, php3_SetCookie called after header has been sent in functions.php on line 581 Warning: Oops, php3_SetCookie called after header has been sent in functions.php on line 584 There are errors like this throughout the forum. I was using it to post messages one day and refreshed it and it came out with all the error messages. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: accessing mysql remotely
I have mysql installed on two linux boxes. How can i access one system's mysql db from the other system grant access to the user on the other system. COnnect to the remote system just like you would on the local. Bye, B. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
tforum
I'm probably out of my depth here, but please have a look at my forum at http://forum.celinestar.org.uk. The error messages are like this: Warning: 0 is not a MySQL result index in functions.php on line 16 Warning: 0 is not a MySQL result index in functions.php on line 21 Warning: Oops, php3_SetCookie called after header has been sent in functions.php on line 556 Warning: Oops, php3_SetCookie called after header has been sent in functions.php on line 562 Warning: Oops, php3_SetCookie called after header has been sent in functions.php on line 581 Warning: Oops, php3_SetCookie called after header has been sent in functions.php on line 584 There are errors like this throughout the forum. I was using it to post messages one day and refreshed it and it came out with all the error messages. I have no idea what to do with this. Any help would be appreciated. Please note that I do not have much experience in mySQL/PHP. Sn|-|op mailto:[EMAIL PROTECTED] http://www.robwilks.co.uk ICQ#:3229926 AIM:ExhibitQRob - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: delete in mysql
At 10:56 AM +0200 4/24/01, Sven Heising wrote: Hi list When posting help requests, it's always helpful to include the error message you get. You can check quickly this via something like: mysql_query(DELETE FROM $dtable where loginid = '$userto' ) or mysql_error(); One possible problem is that $dbuser doesn't have delete privileges on $dbase on host $host. See the manual: http://www.mysql.com/doc/P/r/Privilege_system.html got a problem againcan't delete : $db=mysql_pconnect($host,$dbuser,$pass) or die($dbfehler); echo $userto; mysql_query(use $dbase;); mysql_query(DELETE FROM $dtable where loginid = '$userto' ); what is wrong with this? thanx in advance sven The above might not be an actual snippet of your program, but it's always good to check a query's success. For example: function your_database_error_function() { echo 'Database error: '.mysql_error(); exit; } ... $ResultId = mysql_query(DELETE FROM $dtable where loginid = '$userto' ); if (!$ResultId) { your_database_error_function(); } ... -steve -- +-- KDVS 90.3fm Annual Fundraiser : 16 - 22 April 2001 --+ | Steve Edberg University of California, Davis | | [EMAIL PROTECTED] Computer Consultant | | http://aesric.ucdavis.edu/ http://pgfsun.ucdavis.edu/ | +- www.kdvs.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
Please Problem : French accetual caracters (like è, à) in html
Hello, I have a problem in writing a servlets which access to mysql database, that can generate a french caracters like é, à Can some Help me. ___ Do You Yahoo!? -- Pour faire vos courses sur le Net, Yahoo! Shopping : http://fr.shopping.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: MySQL++ ./configure error
James Bonham writes: Help ! Does anyone have a clue ? tried to run configure on Ultra SPARC/Solaris 2.7 GNU binutils and libtool latest version, gcc 2.95.2 environment variables: CC=gcc CFLAGS=-O6 CXX=gcc CXXFLAGS=-O6 -felide -constructors -fno-exceptions -fno-rtti at the command line:./configure --prefix=myprefix --enable-assembler -- with-mysql=MySQL prefix Any suggestions ? What error message do you get ?? There is no --enable-assembler in MySQL++. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQLGUI
Michael Zielinski writes: Hi, I've tried to install MySQLGUI 1.7.5 on my system. I',ve followed the instructions on the webpage and it seems to compile nicely, but when I try to start it, I get the following error : ./mysqlgui: error while loading shared libraries: libsqlplus.so.1: cannot open shared object file: No such file and directory. The file exists in /usr/local/lib/ Any idea what might be wrong? Thanks Michael Just make /usr/local/lib visible by your dynamic linker. If on Linux, that is in /etc/ld.so.conf, after which ldconfig should be run. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql problem
Dear Sir/Madam and mysql users, I have a mysql database which i can fill with phpadmin, everything is going fine, but when I want to fill the database with php and a form. I got the following problem. I don't know what to do anymore? Can anyone help me? I have made a form, which visitors can fill in, with a php-script I send the information to the database. There is a database connection, but the information isn't put in the database. When I try to this with phpadmin everything is going fine, but with the user form not. I have put the code under this message, if anyone can help me, I hope to hear from him or her by e-mail: [EMAIL PROTECTED] Thanks, Johan ? Require ('connect2.php'); $sqlquery=INSERT INTO Lid (Achternaam, Voornaam, Adres, Postcode, Woonplaats, Telefoonnummer, Emailadres, Geslacht, Geboortedatum, Studentennummer, Hogeschool, Opleiding, Studiejaar, Soortlid, Vereniging, Stage, Stageplaats, Stageduur, Gratissport1, Gratissport2, Gratissport3, Extrasport1, Extrasport2, Extrasport3) VALUES('$Achternaam','$Voornaam','$Adres','$Postcode','$Woonplaats','$Gebdatum','$Soortlid','$Hogeschool','$Collegekaart','$Studierichting','$Studiejaar','$stage','$Stageplaats','$Stageduur','$Keuze1','$Keuze2','$Keuze3','$Keuze4','$Keuze5','$Keuze6'); mysql_close(); print HTMLTITLE HBOSPORT Inschrijving /TITLE BODY BGCOLOR=\#FF\centertable border=\0\width=\500\trtd; print pfont face=\verdana\ size=\+0\ centerYou Just send This Information to HBOSPORTpblockquote; print Naam : $Achternaamp Voornaam : $Voornaamp Adres :$Adres br Postcode :$Postcode br Woonplaats :$Woonplaats br Gebdatum :$Gebdatum br Soort Lid :$Soortlid br Hogeschool :$Hogeschool br Collegekaart :$Collegekaart br Studierichting :$Studierichting br Studiejaar :$Studiejaar br Stage JA/NEE :$Stage br Stageplaats :$Stageplaats br Stageduur :$Stageduur br h3Gratis sport/h3 br hr Belangstelling voor: :$Keuze1 br Belangstelling voor: :$Keuze2 br Belangstelling voor: :$Keuze3 br h3Betaalde sport/h3 br hr br Belangstelling voor: :$Keuze4 br Belangstelling voor: :$Keuze5 br Belangstelling voor: :$Keuze6 br /blockquote /td/tr/table /center /BODY /HTML; ?
Re: 2 errrors while executing make
Steven P. Kerscher wrote: I have installed mysql 3.23.36 for the first time ever I did the test (ok) I ran the bench mark and could not load DBI I installed DBI 1.14 And Data Showtable 3.3 Then tried to install (Msql-Mysql-modules-1.2215) Perl Makefile.pl worked fine I run make and this is what it ends with: make[1]: Entering directory `/usr/lib/perl5/Msql-Mysql-modules-1.2215/mysql' LD_RUN_PATH=/usr/local/mysql/lib/mysql:/lib:/usr/lib:/usr/lib/gcc-lib/i486- linux/2.7.2.3 gcc -o ../blib/arch/auto/DBD/mysql/mysql.so -shared dbdimp.o mysql.o -L/usr/local/mysql/lib/mysql-L/usr/local/mysql/lib/mysql -lmysql client -lm -lz -L/usr/lib/gcc-lib/i486-linux/2.7.2.3 -lgcc /usr/i486-linux/bin/ld: cannot open -lz: No such file or directory make[1]: *** [../blib/arch/auto/DBD/mysql/mysql.so] Error 1 make[1]: Leaving directory `/usr/lib/perl5/Msql-Mysql-modules-1.2215/mysql' make: *** [subdirs] Error 2 I could use any help possible. I?m new to this entire thing Thanks Load your libz or zlib RPM or whatever. You weren't much help in identifying your system. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: HELP! error compiling program using C API
jgw wrote: I'm trying to compile a program using C API. I get the following errors: /usr/lib/mysql/libmysqlclient.a(my_open.o): In function `my_open': my_open.o(.text+0x14): undefined reference to `open64' /usr/lib/mysql/libmysqlclient.a(mf_format.o): In function `fn_format': mf_format.o(.text+0x208): undefined reference to `__lxstat64' /usr/lib/mysql/libmysqlclient.a(my_fopen.o): In function `my_fopen': my_fopen.o(.text+0x21): undefined reference to `fopen64' I don't want to hurt your feelings, but is this some kind of a joke? You don't tell us what kine of machine you are using. You don't identify your operating system, or the compiler you are using. You don't even tell us what version MySQL you are using. Let me guess Red Hat 5.2 ? Upgrade or at least get a newer clib. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Debian - mySQL - php3
I have a system built up with Debian potato and apache. I have to install (to copy) a database from a Mandrake system - so I installed the php3 modules for apache (restarted the apache) and the Debian package of mysql-server and mysql-client. Can you help me, why I get the following error message? Fatal error: Call to unsupported or undefined function mysql_connect() in /var/web/webspace/cie/roster/passwd.php3 on line 9 - Jnos Zana, Budapest Key fingerprint = C4 F1 E6 BD BD 77 D8 C4 22 54 B6 1E E5 53 FF A8 - - - Good rest to all that keeps the Jungle Law! (Kipling) - - - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Query Copying to Temp Table
Scott wrote: I am running into a problem here with a general query that is essential to the vitality of a website that I run. The problem is that every time this query is executed, it is being copied to a temporary table on the hard disk, causing an extreme slowdown. In some instances it takes up to 5 minutes for the query to execute. Here is the basic structure of the databases involved: skins: +-+--+--+-+-+--- -+ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-+--- -+ | id | int(11) | | PRI | NULL| auto_increment | | catid | int(11) | | MUL | 0 | | | userid | int(11) | | MUL | 0 | | | name| varchar(30) | | | | | | filesize| varchar(5) | | | | | | added | datetime | | MUL | -00-00 00:00:00 | | | widths | varchar(4) | | | | | | heights | varchar(4) | | | | | | widthl | varchar(4) | | | | | | heightl | varchar(4) | | | | | | comments| int(11) | | | 0 | | | imagesmall | varchar(50) | | | | | | imagelarge | varchar(50) | | | | | | filename| varchar(100) | | | | | | voteorig| int(11) | | | 0 | | | votetech| int(11) | | | 0 | | | voteoverall | int(11) | | | 0 | | | votecount | int(11) | | MUL | 0 | | | lastviewed | int(11) | | | 0 | | | host| varchar(30) | | | | | +-+--+--+-+-+--- -+ indexes on id, added, userid, votecount, catid skindex: +--+--+--+-+-+-- --+ | Field| Type | Null | Key | Default | Extra | +--+--+--+-+-+-- --+ | id | int(11) | | PRI | NULL| auto_increment | | category | int(11) | | MUL | 0 | | | name | char(30) | | UNI | | | | title| char(30) | | | | | | total| int(11) | | | 0 | | | added| datetime | | | -00-00 00:00:00 | | | softid | int(11) | | | 0 | | +--+--+--+-+-+-- --+ indexes on id, name, category index: +---+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-++ | id| int(11) | | PRI | NULL| auto_increment | | name | char(40) | | UNI | || | total | int(11) | | | 0 || | added | datetime | | | -00-00 00:00:00 || | title | char(20) | | | || +---+--+--+-+-++ indexes on id, name skin_descs: +-+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +-+-+--+-+-+---+ | id | int(11) | | PRI | 0 | | | description | text| | MUL | | | +-+-+--+-+-+---+ indexes on id skin_stats: ++-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | ++-+--+-+-+---+ | id | int(11) | | PRI | 0 | | | views | int(11) | | MUL | 0 | | | viewstoday | int(11) | | | 0 | | | dltotal| int(11) | | MUL | 0 | | | dltoday| int(11) | | | 0 | | | dluserid1 | int(11) | | | 0 | | | dluserid2 | int(11) | | | 0 | | | dluserid3 | int(11) | | | 0 | | | dluserid4 | int(11) | | | 0 | | | dluserid5 | int(11) | | | 0 | | ++-+--+-+-+---+ indexes on id, views, dltotal users:
Re: Debian - mySQL - php3
Once again.. a PHP issue.. You might want to try with PHP4.. latest release. If that doesn't help go the archives @php.net.. Bye, B. mysql, query At 15:16 24-4-01 +0200, [EMAIL PROTECTED] wrote: I have a system built up with Debian potato and apache. I have to install (to copy) a database from a Mandrake system - so I installed the php3 modules for apache (restarted the apache) and the Debian package of mysql-server and mysql-client. Can you help me, why I get the following error message? Fatal error: Call to unsupported or undefined function mysql_connect() in /var/web/webspace/cie/roster/passwd.php3 on line 9 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How To Port MS SQL Database to MySQL
Dear Friends , One of our clients wants to port the Database which was originally in MS SQL , to MY SQL . he main problem we are facing is that how to make previous stored procedures run . There are a lot in the application . Front end was in VB . We are now into feasibility study . Please give information on that . Bablu __ Ayna, The Arabic Internet Starts Here. http://www.ayna.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: how force mysql to use certain indexes
PJM == Patrick J Militzer [EMAIL PROTECTED] writes: PJM I'm using mysql 3.22.27. How can I force mysql to use index's in PJM my select statement? You don't. SQL is a 4GL and you only describe what you want, and it is up to the language interpreter and optimizer to do it efficiently. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Question about MySQL GUI on Win32
This is probably something I'll smack my head about afterward, but here goes: is it possible to execute multiple queries in the MySQL client GUI on Win32? What's accepted on the command line or in a .sql script doesn't work when pasted into it. Thanks in advance! -Jason - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replication pause?
Hello, I set up a bi-directional binary replication with mysql. It is very nice: some tables go one direction, some in the other direction. Everything over a ssh tunnel (stunnel). But: It seems that the slave thread is pausing, without reason. SHOW SLAVE STATUS shows normal: no error, slave is running. But it is still behind the master. I changed connect-retry to 5 sec and I monitored the connection. Everything looks normal. The server is not very loaded. The only solution is to do SLAVE STOP; SLAVE START. After that, in one second they are in sync. For the moment I set a cron job to do this. But I really don't like it. Can anyone tell me something about it? Thanks, Gabriel Corneanu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Port MS SQL Database to MySQL
I believe that stored procedures are still on the TODO list, but that might not fit into your client's plans. Recall that stored procedures are a form of compiled SQL code. Therefore, if you want, you could take that SQL code, in the stored procedure, and put it into your VB application and execute the SQL statement (with a VB connection object) in place of calling the stored procedure. While this does negate the advantage of having a stored procedure, it is one of the few (if not the only) work-arounds for this problem. Good Luck, Dennis ** Beridney Computer Services [EMAIL PROTECTED] http://www.beridney.com - Original Message - From: Istiaque Hussain [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 24, 2001 11:39 AM Subject: How To Port MS SQL Database to MySQL Dear Friends , One of our clients wants to port the Database which was originally in MS SQL , to MY SQL . he main problem we are facing is that how to make previous stored procedures run . There are a lot in the application . Front end was in VB . We are now into feasibility study . Please give information on that . Bablu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
No results from query on merge table
Hi all, I recently had cause to drop and re-create a merge table that maps 80 or so tables (I'd added an index to all the tables whilst they were mapped, so causing me to get incorrect results. Duh!). However, upon re-creating it, I find that I'm now not getting any results back (or only one or two rows) from any queries I'm doing on the merge table that use indexes from the mapped tables. Queries on columns without an index give correct results. Below is an example that shows where it's going wrong: mysql select count(*) from eventlog_36; +--+ | count(*) | +--+ | 389959 | +--+ 1 row in set (0.00 sec) mysql select count(*) from eventlog_all where bannerid = 36; +--+ | count(*) | +--+ |1 | +--+ 1 row in set (0.01 sec) (The table 'eventlog_36' is one of the tables mapped to 'eventlog_all' which holds only records with a 'bannerid' column value of 36.) They don't match, so it's clearly not correct! It seems as though it's not looking at the indexes of the mapped tables correctly, although I have no idea why! If it helps, below is what I'm using to create the merge table. All the field and key declarations are exactly the same, apart from not declaring 'eventid' as a primary key like in the mapped tables (because there will be clashes otherwise). CREATE TABLE eventlog_all ( eventid int unsigned NOT NULL, bannerid int unsigned NOT NULL, impression datetime NOT NULL, click datetime, ipaddr int unsigned NOT NULL, browser char(255) NOT NULL, KEY (bannerid), KEY (impression) ) TYPE=MERGE UNION=(eventlog_11, ...many other tables..., eventlog_81); Can anyone help me figure out what's going on here? Regards, Basil Hussain ([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: Question about MySQL GUI on Win32
It depends on the gui you're using. Get the one at my.anse.de At 07:49 AM 4/24/2001 -0700, Jason Holliston wrote: This is probably something I'll smack my head about afterward, but here goes: is it possible to execute multiple queries in the MySQL client GUI on Win32? What's accepted on the command line or in a .sql script doesn't work when pasted into it. Thanks in advance! -Jason - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Scott Baker - Webster Internet - Network Technician 503.266.8253 - [EMAIL PROTECTED] If it is not right do not do it; if it is not true do not say it. - Marcus Aurelius - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Installation of grant tables failed!?
I need help with this issue. We decompressed a mysql archive on a Solaris box with gnu tar and tried to run this script ./configure --prefix=/usr/local/mysql but was unsuccessful and received this error. Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables ld.so.1: ./bin/mysqld: fatal: libcrypt_i.so.1: open failed: No such file or dire ctory Killed Installation of grant tables failed! Examine the logs in ./data for more information. You can also try to start the mysqld daemon with: ./bin/mysqld --skip-grant You can use the command line tool ./bin/mysql to connect to the mysql database and look at the grant tables: shell ./bin/mysql -u root mysql mysql show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in ./data that may be helpful. The latest information about MySQL is available on the web at http://www.mysql.com Please consult the MySQL manual section: 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source is the MySQL email archive. Please check all of the above before mailing us! And if you do mail us, you MUST use the ./bin/mysqlbug script! your help would greatly be appreciated, John
Re: Debian - mySQL - php3
Janos, You need to install the php3-mysql package, which allows PHP3 to access MySQL databases. Although, you should think about compiling PHP4 or downloading the .debs for it. It's better than PHP3. Oliver - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 24, 2001 2:16 PM Subject: Debian - mySQL - php3 I have a system built up with Debian potato and apache. I have to install (to copy) a database from a Mandrake system - so I installed the php3 modules for apache (restarted the apache) and the Debian package of mysql-server and mysql-client. Can you help me, why I get the following error message? Fatal error: Call to unsupported or undefined function mysql_connect() in /var/web/webspace/cie/roster/passwd.php3 on line 9 - Jnos Zana, Budapest Key fingerprint = C4 F1 E6 BD BD 77 D8 C4 22 54 B6 1E E5 53 FF A8 - - - Good rest to all that keeps the Jungle Law! (Kipling) - - - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how force mysql to use certain indexes
Hi, On Tue, Apr 24, 2001 at 10:44:59AM -0400, Vivek Khera wrote: PJM == Patrick J Militzer [EMAIL PROTECTED] writes: PJM I'm using mysql 3.22.27. How can I force mysql to use index's in PJM my select statement? You don't. SQL is a 4GL and you only describe what you want, and it is up to the language interpreter and optimizer to do it efficiently. Maybe it isn't the right thing to do usually, but you *can* do it: SELECT field1, field2 FROM mytable use index ( myindex ) WHERE test = 'test'; I use it to specify an index to use for MERGE tables, because the optimizer is less efficient on MERGE tables than on other tables. The feature is documented in some text in the manual about JOIN syntax. An 'ignore index' can be used as well. Regards, Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqld sits with 'D' status
I have several mysqld processes that have 'D' status as shown by ps aux. From my limited understanding, that means they are waiting for disk and are uninterruptible? How do they get this way and what can I do to fix this? Hunter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Question about MySQL GUI on Win32
Yes, MySQLFront works much better with multiple queries at once. Nice, quick, simple Win32 UI. I was originally using MySQL GUI that's downloadable from http://www.mysql.com/. Oh, and for everyone's information, http://my.anse.de/ does not appear to work, at least for this morning. http://www.anse.de/ does, however. Thanks for the information. -Jason -Original Message- From: Scott Baker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 8:12 AM To: Jason Holliston; [EMAIL PROTECTED] Subject: Re: Question about MySQL GUI on Win32 It depends on the gui you're using. Get the one at my.anse.de At 07:49 AM 4/24/2001 -0700, Jason Holliston wrote: This is probably something I'll smack my head about afterward, but here goes: is it possible to execute multiple queries in the MySQL client GUI on Win32? What's accepted on the command line or in a .sql script doesn't work when pasted into it. Thanks in advance! -Jason - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Scott Baker - Webster Internet - Network Technician 503.266.8253 - [EMAIL PROTECTED] If it is not right do not do it; if it is not true do not say it. - Marcus Aurelius - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with corrupted System (internal error 1030:Got error 127 from table handler)
Hi again, I've sorted this problem out by rtfm. Used 'REPAIR TABLE tablename' and got most of the records back. regards, Dave database,sql,query -- Don't hit me!! I'm in the Twilight Zone!!! email: [EMAIL PROTECTED] web: www.largesalad.co.uk/DJMsoft - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 anyone help with a search?
Hi, Ok, it is a little off the Mysql topic but I need to know something and I know someone out there can help. I need to do a search on a UNIX box using either egrep or another command that will search for all occurances of a link. we have updated part of our website and want to make sure there are no dead links, a worthy goal don't you think. We need to do a text-based search that includes sub-directories. Anyone know the command? Alan Halls Adoption.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: mysqld sits with 'D' status
How is disk space when this happens? Hunter Hillegas wrote: I have several mysqld processes that have 'D' status as shown by ps aux. From my limited understanding, that means they are waiting for disk and are uninterruptible? How do they get this way and what can I do to fix this? Hunter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can anyone help with a search?
grep -ir href http_dir |grep -v # |grep -v good links I use somthing like this. Best Regards On Tue, 24 Apr 2001, Alan Halls wrote: Hi, Ok, it is a little off the Mysql topic but I need to know something and I know someone out there can help. I need to do a search on a UNIX box using either egrep or another command that will search for all occurances of a link. we have updated part of our website and want to make sure there are no dead links, a worthy goal don't you think. We need to do a text-based search that includes sub-directories. Anyone know the command? Alan Halls Adoption.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Periodical recieving of signal 11
First, make sure to follow the instructuctions in the manual on symbolic resolve of the stack trace. Without it, numeric trace is not much help, especially when you built your own binary and we do not have a symbol table. This is output of resolve_stack_dump 0x813744a pthread_sighandler + 150 0x8137ed0 __pthread_lock + 32 0x813465d pthread_cond_broadcast + 17 0x807c2ec close_connections__Fv + 460 0x8080306 kill_server_thread__FPv + 78 0x8135846 pthread_start_thread + 182 0x815d60a thread_start + 4 This is interesting - the backtrace indicates that we either hit some bug/inconsistency inside thread library or the mutex structure is invalidated when we call pthread_cond_broadcast() which could be some rare, very hard to repeat bug. Do you often shut your server down? The trace indicates that the bug was hit while you were shutting down the server. Another possibility is that you have bad RAM segment or that there is some corruption in your libc. It is possible for many applications to run just fine on bad RAM if they never hit the bad area, but a small, normally insignficant change could alter the code in such a way that it starts using bad RAM and crashes. So the suggested plan of action is: * double-check your hardware, especially RAM * use our binary If the above does not fix it, keep track of all the traces, and keep sending us their symbolic resolutions. If there is indeed a pattern that the crash always happens on shutdown, have all of your shutdown scripts run show processlist before issuing shutdown command. As you can imagine, shutdown code is not something that gets tested as thoroughly as the rest of the code - part of the problem is the difficulty in testing it, and difficulty for the user to create a repeatable bug report. At the same time, there is a lot of potential for bugs in that code, as the system could be in a various number of states when shutdown begins, and it is very possible that we have overlooked some condition that turns out fatal in your case. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Can anyone help with a search?
if you are using tcsh: set docroot='path to your html root directory' find $docroot -name *.html allhtml.list foreach FILE (`cat allhtml.list`) echo $FILE outhtml.list grep 'link' $FILE outhtml.list end you can get more sophisticated than this, but this will work. then look through outhtml.list, which will show all html files and the lines in those files matching your link. alternatively, you can do it in one line: grep 'link' `find $docroot -name *.html` outhtml.list so long as you don't have too many html files. -Original Message- From: Alan Halls [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 1:02 PM To: [EMAIL PROTECTED] Subject: Can anyone help with a search? Hi, Ok, it is a little off the Mysql topic but I need to know something and I know someone out there can help. I need to do a search on a UNIX box using either egrep or another command that will search for all occurances of a link. we have updated part of our website and want to make sure there are no dead links, a worthy goal don't you think. We need to do a text-based search that includes sub-directories. Anyone know the command? Alan Halls Adoption.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can anyone help me.. for install on a Freebsd 4.2 box..
On Thursday 19 April 2001 21:54, Ken Menzel wrote: cd /usr/ports/databases/mysql323-server make make install reboot this aint windows ya know skip the reboot /sbin/ldconfig -m /usr/local/lib/mysql /usr/local/bin/safe_mysqld --user=mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
duplicate key error on autoincrement field while inserting
I have a weird one here. I have an application that inserts records into one of 2 different tables. The other day, an insert attempt on one of the tables failed with a duplicate key error on key 1, an autoincrement field. About a minute later, an insert attempt on the other table failed similarly. But, when a SELECT was done on each table for the key value in question, no record was found. The autoincrement values in question were 16288908 for the first table, and 11339940 for the second table. These tables handle thousands of inserts per day, and all other table activity is read-only via SELECT statements. Does anyone have any idea what may have caused this and what can be done to prevent it? It is as if MySQL built the record with key value 16288908, placed it in the table cache, built another record with the same key, tried to place that in the table cache and failed, reported the error, and then deleted the record from the table cache before it was written into the actual table. I did a myisamchk -i on the first table, which generated the following: Checking MyISAM file: attempt.MYI Data records: 16288907 Deleted blocks: 0 /usr/local/bin/myisamchk: warning: Table is marked as crashed /usr/local/bin/myisamchk: warning: 1 clients is using or hasn't closed the table properly - check file-size - check key delete-chain - check record delete-chain - check index reference - check data record references index: 1 /usr/local/bin/myisamchk: error: Found key at page 280732672 that points to record outside datafile - check record links /usr/local/bin/myisamchk: error: Checksum for key: 1 doesn't match checksum for records /usr/local/bin/myisamchk: error: Checksum for key: 2 doesn't match checksum for records Record blocks:16288907Delete blocks: 0 Record data:1829202488Deleted data: 0 Lost space: 12006835Linkdata: 61081997 MyISAM-table 'attempt.MYI' is corrupted Fix it using switch -r or -o Any suggestions would be greatly appreciated. Thanks! _ Get your FREE download of MSN Explorer at http://explorer.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Can anyone help with a search? (Thanks)
Thanks everyone for the help, you are an awesome crowd. We got it :) Alan -Original Message- From: Peter Pentchev [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 10:19 AM To: Alan Halls Cc: [EMAIL PROTECTED] Subject: Re: Can anyone help with a search? On Tue, Apr 24, 2001 at 10:01:50AM -0700, Alan Halls wrote: Hi, Ok, it is a little off the Mysql topic but I need to know something and I know someone out there can help. I need to do a search on a UNIX box using either egrep or another command that will search for all occurances of a link. we have updated part of our website and want to make sure there are no dead links, a worthy goal don't you think. We need to do a text-based search that includes sub-directories. Anyone know the command? As another poster pointed out, some versions of grep have the -r option to grep recursively in subdirs. More portable, however, is the following: find /path/to/your/directory -type f | xargs grep -i 'your pattern' See the manpages for 'find' and 'xargs' or the info page on 'findutils' for more information. G'luck, Peter -- I've heard that this sentence is a rumor. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Question about MySQL GUI on Win32
It depends on the gui you're using. Get the one at my.anse.de At 07:49 AM 4/24/2001 -0700, Jason Holliston wrote: This is probably something I'll smack my head about afterward, but here goes: is it possible to execute multiple queries in the MySQL client GUI on Win32? What's accepted on the command line or in a .sql script doesn't work when pasted into it. Thanks in advance! The old subdomain my.anse.de is no longer working, because I switched to another provider, which doesn't support subdomains. ;/ But he's giving me much more traffic for all you guys downloading MySQL-Front - 6000 downloads last month = about 3 GB !! ;) . I'm currently working on the next version 1.18, which comes with ODBC-Import, partial SQL-execution, table-diagnostics and the option to export tables directly from one database to another. Get the actual version at http://www.mysqlfront.de/ or http://www.anse.de/mysqlfront/ Greetings, Ansgar Becker [EMAIL PROTECTED] | http://www.anse.de AB7670-RIPE - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL 3.23.38
MySQL 3.23.38 is already in the change log. Is there a proposed release date? I don't want to install 3.23.37 just to have to install 3.23.38 tomorrow. Thanks. j-k - -- Joshua Kugler Associated Students of the University of Alaska Fairbanks Information Services Director [EMAIL PROTECTED] 907-474-7601 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RPM dependency on MySQL-DBI-perl-bin
Hi - Im installing the MySQL-bench-3.23.37-1.i386.rpm, cant install because of a MySQL-DBI-perl-bin dependency. Does anyone know what this is(RPM?or Perl Mod?), and where i can find it?Ive been looking, but no luck yet. Thanks!jason _ Get your FREE download of MSN Explorer at http://explorer.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: duplicate key error on autoincrement field while inserting
What operating system are you running, and how big are these files and indicies? Is this a 2 Gig file size limit problem? You are getting near the limit to the size of an unsigned mediumint. Dan Shapella wrote: I have a weird one here. I have an application that inserts records into one of 2 different tables. The other day, an insert attempt on one of the tables failed with a duplicate key error on key 1, an autoincrement field. About a minute later, an insert attempt on the other table failed similarly. But, when a SELECT was done on each table for the key value in question, no record was found. The autoincrement values in question were 16288908 for the first table, and 11339940 for the second table. These tables handle thousands of inserts per day, and all other table activity is read-only via SELECT statements. Does anyone have any idea what may have caused this and what can be done to prevent it? It is as if MySQL built the record with key value 16288908, placed it in the table cache, built another record with the same key, tried to place that in the table cache and failed, reported the error, and then deleted the record from the table cache before it was written into the actual table. I did a myisamchk -i on the first table, which generated the following: Checking MyISAM file: attempt.MYI Data records: 16288907 Deleted blocks: 0 /usr/local/bin/myisamchk: warning: Table is marked as crashed /usr/local/bin/myisamchk: warning: 1 clients is using or hasn't closed the table properly - check file-size - check key delete-chain - check record delete-chain - check index reference - check data record references index: 1 /usr/local/bin/myisamchk: error: Found key at page 280732672 that points to record outside datafile - check record links /usr/local/bin/myisamchk: error: Checksum for key: 1 doesn't match checksum for records /usr/local/bin/myisamchk: error: Checksum for key: 2 doesn't match checksum for records Record blocks:16288907Delete blocks: 0 Record data:1829202488Deleted data: 0 Lost space: 12006835Linkdata: 61081997 MyISAM-table 'attempt.MYI' is corrupted Fix it using switch -r or -o Any suggestions would be greatly appreciated. Thanks! _ Get your FREE download of MSN Explorer at http://explorer.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Got an error reading communication packets...
I am using 3.23.36 in conjunction with PHP 4.0.4pl1. When I compiled PHP, I used --with-mysql and let it use it's own mySQL library, not compiling against anything build under 3.23.36 (I tried the other way but the configure failed, never finding mysqlclient libraries, even though they were right there)... Anyway, I'm getting the Got an error reading communication packets in my log files... What can I do to solve this? Hunter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Possible bug with InnoDB table
I am running MySQL 3.23.37 compiled by myself on Linux platform. Here is a repeatable example: mysql create table test (id int not null, - KEY id (id)) type=InnoDB; mysql SELECT id FROM test WHERE id1; ERROR 1032: Can't find record in 'test' I am expecting something like the following: Empty set (0.00 sec) You need the following combination to repeat this bug: (1) InnoDB table (MyISAM works OK) (2) where clause (without WHERE clause works OK) (3) or = comparison operator (= or or = work OK) (4) NOT NULL in column definition(wothout NOT NULL works OK) (5) KEY id (id) in column definition (otherwise it works OK) I also noticed that in C API, mysql_store_result() fails with query ELECT id FROM test WHERE id1. Regards, Tianlin WANG - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Got an error reading communication packets...
Make sure you don't have concurrent accesses to the mysql.sock, for example the apache authentication module (we had that). docs say you should build php with shared mysql support, so i guess you'll still just have to do so... On Tue, 24 Apr 2001 11:06:33 -0700 Hunter Hillegas [EMAIL PROTECTED] wrote: I am using 3.23.36 in conjunction with PHP 4.0.4pl1. When I compiled PHP, I used --with-mysql and let it use it's own mySQL library, not compiling against anything build under 3.23.36 (I tried the other way but the configure failed, never finding mysqlclient libraries, even though they were right there)... Anyway, I'm getting the Got an error reading communication packets in my log files... What can I do to solve this? Hunter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: duplicate key error on autoincrement field while inserting
OS Is Linux. The autoincrement key is defined as INT, so plenty of room there. Table sizes are getting up there: attempt.MYD 1,902,291,232inrec.MYD 1,979,795,600 attempt.MYI 280,733,696inrec.MYI 240,460,800 After doing a myisamchk -r on the attempt table, inserts appear to be working again, so I would't think the huge file sizes are the problem (yet). No recovery was done on the inrec table, but after doing a FLUSH-TABLE, an insert worked on that table as well. Don't understand that one. I still point back to the fact that 2 different tables had autoincrement problems at virtually the same time. And this is the only app running on this system. Why did MySql decide these 2 keys already exist when in fact they don't? From: Gerald Clark [EMAIL PROTECTED] To: Dan Shapella [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: duplicate key error on autoincrement field while inserting Date: Tue, 24 Apr 2001 13:08:47 -0500 What operating system are you running, and how big are these files and indicies? Is this a 2 Gig file size limit problem? You are getting near the limit to the size of an unsigned mediumint. Dan Shapella wrote: I have a weird one here. I have an application that inserts records into one of 2 different tables. The other day, an insert attempt on one of the tables failed with a duplicate key error on key 1, an autoincrement field. About a minute later, an insert attempt on the other table failed similarly. But, when a SELECT was done on each table for the key value in question, no record was found. The autoincrement values in question were 16288908 for the first table, and 11339940 for the second table. These tables handle thousands of inserts per day, and all other table activity is read-only via SELECT statements. Does anyone have any idea what may have caused this and what can be done to prevent it? It is as if MySQL built the record with key value 16288908, placed it in the table cache, built another record with the same key, tried to place that in the table cache and failed, reported the error, and then deleted the record from the table cache before it was written into the actual table. I did a myisamchk -i on the first table, which generated the following: Checking MyISAM file: attempt.MYI Data records: 16288907 Deleted blocks: 0 /usr/local/bin/myisamchk: warning: Table is marked as crashed /usr/local/bin/myisamchk: warning: 1 clients is using or hasn't closed the table properly - check file-size - check key delete-chain - check record delete-chain - check index reference - check data record references index: 1 /usr/local/bin/myisamchk: error: Found key at page 280732672 that points to record outside datafile - check record links /usr/local/bin/myisamchk: error: Checksum for key: 1 doesn't match checksum for records /usr/local/bin/myisamchk: error: Checksum for key: 2 doesn't match checksum for records Record blocks:16288907Delete blocks: 0 Record data:1829202488Deleted data: 0 Lost space: 12006835Linkdata: 61081997 MyISAM-table 'attempt.MYI' is corrupted Fix it using switch -r or -o Any suggestions would be greatly appreciated. Thanks! _ Get your FREE download of MSN Explorer at http://explorer.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get your FREE download of MSN Explorer at http://explorer.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Copying to tmp table order by, group by
Hi, Running 3.23.37 on freebsd We are making about 200-250 requetes per second on a server with 1Go RAM. We have lot of problems with the requetes which use order by, group by. It seems mysqld copies the data to a tmp table to make sort. The problem is it takes a while to be done. How to make it quicker ? -O long_query_time=10 -O wait_timeout=10 -O interactive_timeout=60 -O max_connect_errors=1 -O key_buffer=384M -O table_cache=1000 -O sort_buffer=15M -O record_buffer=15M -O max_connections=200 -O thread_cache_size=250 -O max_user_connections=10 -O tmp_table_size=100M -O max_tmp_tables=100 kind of the requets which takes more than 10sec. | Query | 13 | Copying to tmp table | SELECT medias.idmedia, medias.titre, |medias.note, medias.idtype, categ.nomcat FROM medias, medias_de | Query | 11 | Copying to tmp table | select products.products_id, |products.products_name, products.products_price, products.products_imag | Query | 11 | Copying to tmp table | SELECT distinct(gallerie.id) as |id,gallerie.titre as titre,count(wall.id) as galtaille,gallerie.wall thanks for help Octave - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Port MS SQL Database to MySQL
We encountered no real problems when converting a database from Interbase, with some stored procedures and triggers as well, to mysql. Most stored procedures were for things like generating a unique key, getting the server date/time/year, etc. Triggers are imho just application _unfriendly_, since the programmer has no influence on triggers in the database, unless he/her alters them, which can be quite annoying. Maybe your application(s) need some extra lines of code, but personally i do not see this as a limition. Our app was in fact, with some minor issues, fully compatible with mysql (it's a compiler switch now :)). regards, rene On Tue, 24 Apr 2001 11:39:55 -0400 (EDT) Istiaque Hussain [EMAIL PROTECTED] wrote: Dear Friends , One of our clients wants to port the Database which was originally in MS SQL , to MY SQL . he main problem we are facing is that how to make previous stored procedures run . There are a lot in the application . Front end was in VB . We are now into feasibility study . Please give information on that . Bablu __ Ayna, The Arabic Internet Starts Here. http://www.ayna.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
mySql and trigger/transaction support
does mySql support triggers or transactions Matthew Hafner Web Applications Engineer The Ohana Foundation 1099 Alakea st 22nd floor Honolulu, HI, 96813 1-877-61-ohana [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 and trigger/transaction support
Matthew Hafner wrote: does mySql support triggers or transactions Matthew Hafner Web Applications Engineer The Ohana Foundation 1099 Alakea st 22nd floor Honolulu, HI, 96813 1-877-61-ohana [EMAIL PROTECTED] RTFM www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Info on using MySQL with Java
Hi all, I'm looking for some pointers towards some good information on accessing and using MySQL with Java/Javascript. Can anyone point me towards a book you like, or some good web resources? Thanks much, /Rob - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 trigger/transaction support
MySQL supports transactions in beta form if you use a Berkley table. Check the homepage for more information. Triggers are in the todo pile though. At 09:44 AM 4/24/2001 -1000, Matthew Hafner wrote: does mySql support triggers or transactions Matthew Hafner Web Applications Engineer The Ohana Foundation 1099 Alakea st 22nd floor Honolulu, HI, 96813 1-877-61-ohana [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 - Scott Baker - Webster Internet - Network Technician 503.266.8253 - [EMAIL PROTECTED] If it is not right do not do it; if it is not true do not say it. - Marcus Aurelius - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 compile error
Help me please ! installing MySQL 3.23.36 on Ultra SPARC/Solaris 2.7 GNU make 3.79.1, binutils, and libtool latest version, gcc 2.95.2 environment variables: CC=gcc CFLAGS=-O6 CXX=gcc CXXFLAGS=-O6 -felide -constructors -fno-exceptions -fno-rtti at the command line: ./configure --prefix=myprefix --with-low-memory --enable-assembler# configure completed OK make After entering make, it ran for awhile and then I got the following error: . . . gcc -O6 -DDBUG_OFF -O6 -DHAVE_CURSES_H -I/vendors/wwsoft/software/opensource/mysql/src/3.23.36/include -DHAVE_RWLOCK_T -o resolveip resolveip.o ../mysys/libmysys.a ../dbug/libdbug.a ../strings/libmystrings.a -ldl -lz -lcrypt -lgen -lsocket -lnsl -lm -lpthread -lthread Undefined first referenced symbol in file __h_errno resolveip.o ld: fatal: Symbol referencing errors. No output written to resolveip collect2: ld returned 1 exit status make[2]: *** [resolveip] Error 1 make[2]: Leaving directory `/vendors/wwsoft/software/opensource/mysql/src/3.23.36/extra' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/vendors/wwsoft/software/opensource/mysql/src/3.23.36' make: *** [all-recursive-am] Error 2 . . . Is there anything I can do ?
Re: MySQL compile error
You might want to try downloading binutils from the GNU web site. It has a modified version of the linker libraries (ld). I still wasn't able to get past the yacc compile even with 512MB RAM. Let me know how you make out. I ended up using the binary distribution. James Bonham wrote: Help me please ! installing MySQL 3.23.36 on Ultra SPARC/Solaris 2.7 GNU make 3.79.1, binutils, and libtool latest version, gcc 2.95.2 environment variables: CC=gcc CFLAGS=-O6 CXX=gcc CXXFLAGS=-O6 -felide -constructors -fno-exceptions -fno-rtti at the command line: ./configure --prefix=myprefix --with-low-memory --enable-assembler# configure completed OK make After entering make, it ran for awhile and then I got the following error: . . . gcc -O6 -DDBUG_OFF -O6 -DHAVE_CURSES_H -I/vendors/wwsoft/software/opensource/mysql/src/3.23.36/include -DHAVE_RWLOCK_T -o resolveip resolveip.o ../mysys/libmysys.a ../dbug/libdbug.a ../strings/libmystrings.a -ldl -lz -lcrypt -lgen -lsocket -lnsl -lm -lpthread -lthread Undefined first referenced symbol in file __h_errno resolveip.o ld: fatal: Symbol referencing errors. No output written to resolveip collect2: ld returned 1 exit status make[2]: *** [resolveip] Error 1 make[2]: Leaving directory `/vendors/wwsoft/software/opensource/mysql/src/3.23.36/extra' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/vendors/wwsoft/software/opensource/mysql/src/3.23.36' make: *** [all-recursive-am] Error 2 . . . Is there anything I can do ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
changing permissions
Hi All - I just set up MySQL for the first time and cannot seem to change the user 'root' password using mysqladmin. I must be geting the sytax wrong. Im typing 'bin/mysqladmin -u root -p password', then it prompts me for a password, i type one in, then it gives me an error as shown below: [root@24-168-90-77 mysql]# bin/mysqladmin -u root -p password Enter password: bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' Not sure if i should be actually typing in the word 'password' or not, dont believe there is one set already since i just installed. Using binary for i386Linux on RH7.1, tared version 3.23.37. I sincerely appreciate any help.jason _ Get your FREE download of MSN Explorer at http://explorer.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Need help with 23.36
COuld try a mysqldump to backup and restore the tables on the new/other machine. This should get you past the problems you found earlier. Remember to add the propriate users to the new machine.. Bye, B. mysql use lum Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Didn't find any fields in table 'users' Database changed mysql select * from users; ERROR 1017: Can't find file: './lum/users.frm' (errno: 13) Please anyone. I really need some ideas. I copied my database files made with 23.29 to 23.26 and now I get this. I chowned mysql.mysql and chmoded 660. The location of the databases is good because I have some other databases created with 36 and they work fine. I copied ALL the database's files to /var/lib/mysql where the others are and I get this error. Any idea? Error code 13 means permission denied. How come your database is named 'lumina' and the directory it resides in (or at least the dir that mysql tries to find the tables in) is ./lum/ ? Shouldn't it be looking under lumina? Check that you don't have your database directories messed up under ~mysql/var/ The files are in the right directory with the right permissions and still I get the errors from above. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: RPM dependency on MySQL-DBI-perl-bin
Hi: I believe MySQL-bench uses Perl program to benchmark databases so that it requires Perl-DBI. DBI is a Perl module that provides API for database connection. I have never installed Perl modules in RPM format but you should be able to find it on RedHat ftp server. And I think the name 'MySQL-DBI-perl-bin' is somewhat misleading because DBI is not tied to any specific databse. DBI module provides general API for databse handling and for MySQL, you also need DBD-MySQL module. Anyway, unless you have a real need of benchmarking MySQL, why bother installing it? Seung-woo Nam Jason Feingold wrote: Hi - Im installing the MySQL-bench-3.23.37-1.i386.rpm, cant install because of a MySQL-DBI-perl-bin dependency. Does anyone know what this is(RPM?or Perl Mod?), and where i can find it?Ive been looking, but no luck yet. Thanks!jason _ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 trigger/transaction support
RTFM=Read The Fucking Manual now you know. On Tue, 24 Apr 2001 21:37:44 +0100 (BST) Peter Skipworth [EMAIL PROTECTED] wrote: I for one vote to not bother with abbreviations from now on - let's just spell it out loud and clear ;) *grin* P On Tue, 24 Apr 2001, Steve Ruby wrote: Matthew Hafner wrote: does mySql support triggers or transactions Matthew Hafner Web Applications Engineer The Ohana Foundation 1099 Alakea st 22nd floor Honolulu, HI, 96813 1-877-61-ohana [EMAIL PROTECTED] RTFM www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- --- Peter Skipworth Perl Developer/Unix Systems Administrator [EMAIL PROTECTED] +44 795 055 0029 --- 4c 61 20 6c 6f 79 52 75 62 20 73 41 20 65 52 61 20 45 65 62 4f 4c 47 6e 74 20 20 4f 53 75 00 0a - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: largest timestamp value
Did you try to put (-1) in it? Bye! Facundo Batista Gestión de Red [EMAIL PROTECTED] (5411) 4819-4358 #---Mensaje original- #--De: Ashley M. Kirchner [mailto:[EMAIL PROTECTED]] #--Enviado el: Viernes 20 de Abril de 2001 8:15 PM #--Para: MySQL Mailing List #--Asunto: largest timestamp value #-- #-- #-- #--What's the largest possible timestamp value before it rolls over? #--I'm trying to figure out what's the best way to do the following. I #--have a table that has these three fields in it: #-- #--priority int(3) #--end_time timestamp(14) #--start_time timestamp(14) #-- #--NOTE: only start_time gets inserted as Now() (or NULL so it #--automatically gets set) end_time is a variable that gets #--set depending #--on what the user picks for time period. #-- #--And I'd like to select and order like: #-- #--select * from table order by priority, end_time, start_time; #-- #-- #--Now, some rows will have a valid start, and end times. #--Others will #--have only a valid start time, and an undefined end time, or #--infinite if #--you will. However, if I don't fill in a value for that field, MySQL #--dutifully puts in 00 for me, and when I perform the above #--query, I get something like this: #-- #--+--+++ #--| priority | end_time | start_time | #--+--+++ #--|0 | 00 | 20010329023143 | #--|0 | 20010330231405 | 20010329021805 | #--|0 | 20010331012712 | 20010330162312 | #--| 10 | 20010422051135 | 20010419161205 | #--| 10 | 20010422051135 | 20010419162335 | #--| 50 | 20010330131222 | 20010329015222 | #--| 50 | 20010330131703 | 20010329015703 | #--| 100 | 20010331192630 | 20010329014630 | #--| 100 | 20010401211100 | 20010330023100 | #--+--+++ #-- #--However, I want that first row, to end up last within #--that priority #--level (so drop it to line 3). The only thing I can think of #--is to put #--in some insanely large value for that timestamp, so that the select #--clause works. #-- #--So, I need to figure out what's the largest possible #--amount of time #--I can put in, and make it like a 'dead end' value. Anything that has #--that value is considered infinite. I suppose I can put in #--2038010100...but is that the ceiling of MySQL? #-- #--Unless there's another way? #-- # #--W | #-- | I haven't lost my mind; it's backed up on tape somewhere. #-- #--| #-- #--~ #-- Ashley M. Kirchner mailto:[EMAIL PROTECTED] . #--303.442.6410 x130 #-- SysAdmin / Websmith . #--800.441.3873 x130 #-- Photo Craft Laboratories, Inc. .eFax #--248.671.0909 #-- http://www.pcraft.com . 3550 #--Arapahoe Ave #6 #-- .. . . . . Boulder, CO #--80303, USA #-- #-- #-- #--- #--Before posting, please check: #-- http://www.mysql.com/manual.php (the manual) #-- http://lists.mysql.com/ (the list archive) #-- #--To request this thread, e-mail [EMAIL PROTECTED] #--To unsubscribe, e-mail #--[EMAIL PROTECTED] #--Trouble unsubscribing? Try: #--http://lists.mysql.com/php/unsubscribe.php #--
Re: Info on using MySQL with Java
Professional JSP, by Wrox Press Ltd, is a quite good book. Matt - Original Message - From: Robert Alexander [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 24, 2001 2:48 PM Subject: Info on using MySQL with Java Hi all, I'm looking for some pointers towards some good information on accessing and using MySQL with Java/Javascript. Can anyone point me towards a book you like, or some good web resources? Thanks much, /Rob - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 trigger/transaction support
Now gentlemen please let's use appropriate language when posting to the list, after all it is a public list and we don't want to offend anybody At 22:04 24/04/2001 +0100, Peter Skipworth wrote: Like duh! =) On Tue, 24 Apr 2001, Rene Tegel wrote: RTFM=Read The Fucking Manual now you know. On Tue, 24 Apr 2001 21:37:44 +0100 (BST) Peter Skipworth [EMAIL PROTECTED] wrote: I for one vote to not bother with abbreviations from now on - let's just spell it out loud and clear ;) *grin* P On Tue, 24 Apr 2001, Steve Ruby wrote: Matthew Hafner wrote: does mySql support triggers or transactions Matthew Hafner Web Applications Engineer The Ohana Foundation 1099 Alakea st 22nd floor Honolulu, HI, 96813 1-877-61-ohana [EMAIL PROTECTED] RTFM www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- --- Peter Skipworth Perl Developer/Unix Systems Administrator [EMAIL PROTECTED] +44 795 055 0029 --- 4c 61 20 6c 6f 79 52 75 62 20 73 41 20 65 52 61 20 45 65 62 4f 4c 47 6e 74 20 20 4f 53 75 00 0a - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- --- Peter Skipworth Perl Developer/Unix Systems Administrator [EMAIL PROTECTED] +44 795 055 0029 --- 4c 61 20 6c 6f 79 52 75 62 20 73 41 20 65 52 61 20 45 65 62 4f 4c 47 6e 74 20 20 4f 53 75 00 0a - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Regards John -- MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / John Dean [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mansfield, England, UK ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RPM dependency on MySQL-DBI-perl-bin
Dear Jason - Jason Feingold writes: Hi - Im installing the MySQL-bench-3.23.37-1.i386.rpm, cant install because of a MySQL-DBI-perl-bin dependency. Using the RPM mechanism to install perl modules is fraught with problems. Don't use it; you'll be sorry you did in the long run. But, fear not there is a good solution to your problem. The perl community has developed a solution analogous to RPM called cpan. There is a cpan module that is most likely already installed on your system. You can confirm that by typing 'perl -e use CPAN; ' (without the single quotes) at the command line. If you don't get any wierd error messages you already have the cpan module. (If you don't have it you can download it, and zillions of others, at www.cpan.org. Now that you've got CPAN.pm you can type 'perl -MCPAN -e shell' and follow the reasonably intuitive interactive prompts. There's also documentation available by typing 'perldoc CPAN'. The commands you're going to end up typing in the end are: cpan i /mysql/ cpan install Bundle::DBD::mysql cpan i /dbi/ cpan install Bundle::DBI The cpan tool is built specifically for perl and you will get a more robust install by using it for perl modules. Let me warn you that I haven't installed these modules in a while and you may find that there are C dependencies that I'm forgetting that aren't handled well. If you have problems just write again and I or someone else will be happy to help. Yours - Billy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Query Copying to Temp Table
That ORDER by a calculated_field DESC is killing you. It needs to go to a temporary table for sorting. The problem, though, is that even if I leave the ORDER clause out, or ORDER BY any other field, the same thing happens. I initially thought the same thing, but it happens with or without the ORDER BY clause. Scott -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Gerald Clark Sent: Tuesday, April 24, 2001 10:33 PM To: Scott Cc: [EMAIL PROTECTED] Subject: Re: Query Copying to Temp Table Scott wrote: I am running into a problem here with a general query that is essential to the vitality of a website that I run. The problem is that every time this query is executed, it is being copied to a temporary table on the hard disk, causing an extreme slowdown. In some instances it takes up to 5 minutes for the query to execute. Here is the basic structure of the databases involved: skins: +-+--+--+-+-+- +-+--+--+-+-+-- -+ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-+- +-+--+--+-+-+-- -+ | id | int(11) | | PRI | NULL| auto_increment | | catid | int(11) | | MUL | 0 | | | userid | int(11) | | MUL | 0 | | | name| varchar(30) | | | | | | filesize| varchar(5) | | | | | | added | datetime | | MUL | -00-00 00:00:00 | | | widths | varchar(4) | | | | | | heights | varchar(4) | | | | | | widthl | varchar(4) | | | | | | heightl | varchar(4) | | | | | | comments| int(11) | | | 0 | | | imagesmall | varchar(50) | | | | | | imagelarge | varchar(50) | | | | | | filename| varchar(100) | | | | | | voteorig| int(11) | | | 0 | | | votetech| int(11) | | | 0 | | | voteoverall | int(11) | | | 0 | | | votecount | int(11) | | MUL | 0 | | | lastviewed | int(11) | | | 0 | | | host| varchar(30) | | | | | +-+--+--+-+-+- +-+--+--+-+-+-- -+ indexes on id, added, userid, votecount, catid skindex: +--+--+--+-+-+ +--+--+--+-+-+-- --+ | Field| Type | Null | Key | Default | Extra | +--+--+--+-+-+ +--+--+--+-+-+-- --+ | id | int(11) | | PRI | NULL| auto_increment | | category | int(11) | | MUL | 0 | | | name | char(30) | | UNI | | | | title| char(30) | | | | | | total| int(11) | | | 0 | | | added| datetime | | | -00-00 00:00:00 | | | softid | int(11) | | | 0 | | +--+--+--+-+-+ +--+--+--+-+-+-- --+ indexes on id, name, category index: +---+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-++ | id| int(11) | | PRI | NULL| auto_increment | | name | char(40) | | UNI | | | | total | int(11) | | | 0 | | | added | datetime | | | -00-00 00:00:00 | | | title | char(20) | | | | | +---+--+--+-+-++ indexes on id, name skin_descs: +-+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +-+-+--+-+-+---+ | id | int(11) | | PRI | 0 | | | description | text| | MUL | | | +-+-+--+-+-+---+ indexes on id skin_stats:
Re: Query Copying to Temp Table
I don't think you can avoid having those temporary tables in executing any kind of SELECT queries since the retrieved information should be stored somewhere (whether you have ORDER BY or not). I would suggest that if you have a large database, you should considering putting the temporary space on a separate hard drive. Seung-woo Nam Scott wrote: That ORDER by a calculated_field DESC is killing you. It needs to go to a temporary table for sorting. The problem, though, is that even if I leave the ORDER clause out, or ORDER BY any other field, the same thing happens. I initially thought the same thing, but it happens with or without the ORDER BY clause. Scott snip - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Joining tables
Hello, I'm a newbie with MySQL, so don't apologize me when I post a stupid question. Is it only possible to join tables 2 by 2 or is it possible to join 4 tables in only one request? Thanks Marc Raeymaekers Belgium - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
multiple selects
Hi I am using an application (excel) that sends sql requests and fills the excel sheet. When i issue an update statements, the update doesnt return data to my program (*.vba) in excel, so it hangs. To bypass the problem I was told to use the following ansi compliant sql statement SET NOCOUNT ON This way i can execute several select and update statements in the query and get one result back. The problem is that SET NOCOUNT ON is a mssql server command and not mysql. What should i do in mysql.. Please advise! Regards Geir - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problems compiling on solaris 2.7
I'm having problems compiling mysql 3.23.37 on Solaris 2.7. It gets to the final linking stage and I get the following error: /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.95.1/libgcc.a: could not read symbols: Bad value Anyone have this happen to them before and/or have a fix? I've also compiled it on Linux with no problems. I followed the recommended configure line in the README. Thanks in advance Jeff Shipman E-Mail: [EMAIL PROTECTED] Systems Programmer Phone: (505) 835-5748 NMIMT Computer Center http://www.nmt.edu/~jeff - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Upgrade...
Hi, I tried to upgrade a 3.22.32 source install of MySQL to the latest 3.23 source from the MySQL Web site on my RedHat 6.1 box and ended up breaking Apache and PHP (which were also compiled by source). Being relatively new to Linux and having gotten it working originally via a handy how-to at www.devshed.com, I'm a bit lost as to the best way to perform these upgrades. Does anyone have a resource for beginners they could share? It almost looks as though I'd need to rebuild Apache, PHP, and MySQL from source again to get it working with the new versions, and that seems a bit extreme just to get at FULLTEXT indexes I want... 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
error 2013 and 2002 when i install the mysql database
Dear Sir, My Linux is RedHat Linux 6.0 I follow the below step to install the mysql version 3.23.37 database : 1. tar ¡Vzxvf mysql-3.23.37.tar.gz 2. ./configure ¡Vprefix/usr/local/mysql 3. make 4. make install 5. echo ¡§/usr/local/mysql/lib/mysql¡¨ /etc/ld.so.conf 6. ldconfig ¡Vv |grep libmysqlclient 7. echo ¡§/usr/local/msyql/bin/safe_mysqld /dev/null ¡¨ /etc/rc.d/rc.local 8. ./scripts/mysql_install_db 9. /usr/local/mysql/bin/safe_mysqld /dev/null 10. PATH=¡¨$PATH:/usr/local/mysql/bin¡¨ 11. mysqladmin version (The screen show out that : mysqladmin : connect to server at ¡¥localhost¡¦ failed Lost connection to Mysql Server during query) I check the file /etc/resolv.conf and I change the content from Search Servername To Search localhost Servername 127.0.0.1 I also check the file /etc/hosts and the content is 127.0.0.1 localhost localhost.localdomain After I prepare this two file, I input the command mysqladmin version It also not improve the situation. Then, I check the file /tmp/mysql.sock and /etc/my.cnf but this two files have not exist Can you ask me what¡¦s happen and how can I do ? This problem is very urgent for me. I attach the mysqlbug file to you From the very worry programmer RTO mysqlbug - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Info on using MySQL with Java
Hi all, I'm looking for some pointers towards some good information on accessing and using MySQL with Java/Javascript. Can anyone point me towards a book you like, or some good web resources? Thanks much, /Rob You'll need a servlet and/or JSP engine such as listed here http://www.servlets.com/engines/ I've used tomcat, resin and jetty with no problems with mysql, obviously you will need a JDBC driver, the mm one seems to be the best available see www.mysql.com and then downloads and follow the links for JDBC. You'll have to decide on JSP or servlets or some like template systems best see: www.webmacro.org jakarta.apache.com/turbine jakarta.apache.org/velocity jakarta.apache.org/struts - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Why MySQL db will only allow 127 records imported?
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 25 April 2001 2:31 PM To: Howard Picken Subject: Why MySQL db will only allow 127 records imported? 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 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. You have written the following: I'm trying to import a csv file into a db. all text fields are enclosed and all fields are , delimited. the file is 900 records long. The error I'm getting is.. ERROR 1062 at line 1: Duplicate entry '127' for key 1 I'm importing an id field (incrementing from 1-900) which is the main index (I've tried importing without it). If I delete the first 200 lines from the import file. It won't import anything and I get the same error. If I remove all data from the table then try again I get the same problem. id is set to tinyint(5) I'm stumped... anyone have any ideas? Thanks Howard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Joining tables
Marc Raeymaekers [EMAIL PROTECTED] wrote: I'm a newbie with MySQL, so don't apologize me when I post a stupid question. Is it only possible to join tables 2 by 2 or is it possible to join 4 tables in only one request? Yes, you can join 4 tables in one SQL statement. -- 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
Re: Why MySQL db will only allow 127 records imported?
Tinyint will only go up to 127 when it is signed. Try INT. Also, please read the Docs section about data types and their sizes. It will save you more embarassing questions like these. :) j- k- On Tuesday 24 April 2001 20:39, Howard Picken wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 25 April 2001 2:31 PM To: Howard Picken Subject: Why MySQL db will only allow 127 records imported? 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 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. You have written the following: I'm trying to import a csv file into a db. all text fields are enclosed and all fields are , delimited. the file is 900 records long. The error I'm getting is.. ERROR 1062 at line 1: Duplicate entry '127' for key 1 I'm importing an id field (incrementing from 1-900) which is the main index (I've tried importing without it). If I delete the first 200 lines from the import file. It won't import anything and I get the same error. If I remove all data from the table then try again I get the same problem. id is set to tinyint(5) I'm stumped... anyone have any ideas? Thanks Howard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Joshua Kugler Associated Students of the University of Alaska Fairbanks Information Services Director [EMAIL PROTECTED] 907-474-7601 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with mysql query
I am having a problem with setting up a query in using MySql. The query uses a user-defined parameter and searches the table against it. e.g. int search//user peramater select * from table where member_id = :search; When trying to run this query (using powerbuilder) it doesnt return the desired row. However if i use the following query (using a hard-coded member_id), it does work, select * from table where member_id = 0001; I have feeling it is a problem with one of the ODBC options in the database profile. If anyone could help me i would be really thankfull, Thanking you in advance, Barry. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 trigger/transaction support
Like duh! =) On Tue, 24 Apr 2001, Rene Tegel wrote: RTFM=Read The Fucking Manual now you know. On Tue, 24 Apr 2001 21:37:44 +0100 (BST) Peter Skipworth [EMAIL PROTECTED] wrote: I for one vote to not bother with abbreviations from now on - let's just spell it out loud and clear ;) *grin* P On Tue, 24 Apr 2001, Steve Ruby wrote: Matthew Hafner wrote: does mySql support triggers or transactions Matthew Hafner Web Applications Engineer The Ohana Foundation 1099 Alakea st 22nd floor Honolulu, HI, 96813 1-877-61-ohana [EMAIL PROTECTED] RTFM www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- --- Peter Skipworth Perl Developer/Unix Systems Administrator [EMAIL PROTECTED] +44 795 055 0029 --- 4c 61 20 6c 6f 79 52 75 62 20 73 41 20 65 52 61 20 45 65 62 4f 4c 47 6e 74 20 20 4f 53 75 00 0a - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- --- Peter Skipworth Perl Developer/Unix Systems Administrator [EMAIL PROTECTED] +44 795 055 0029 --- 4c 61 20 6c 6f 79 52 75 62 20 73 41 20 65 52 61 20 45 65 62 4f 4c 47 6e 74 20 20 4f 53 75 00 0a - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php