RE: Error code 28: No space left on device
What will happen on Error code 28: No space left on device? Will mysql crash down?... Will there be posibility of reading data from tables? I saw this error on one of my servers not too long ago. MySQL keeps running but seemingly refuses to do SELECTs on any tables. Upon freeing some space those same SELECTs went through fine without a restart of mysqld. I believe the default my.cnf uses /tmp for its temporary files. If this partition is full you may either free some space within it or alternatively specify a different location for MySQL's temporary files. See the tmpdir setting in my.cnf. e.g.: tmpdir = /usr/tmp/ Ron Jamison - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 same table twice for different rows -- possible?
Hi, Consider the following schema: Database.Users: id username Database.Log: id userid1 userid2 entry If I'm SELECT'ing on the Log table and I want to pull usernames out of Users table for both users (which will most likely be unique) is there a specific JOIN for this? Forgive me if I've missed something in the manual pages; I've always had to do two SELECTs and thus have been looking for a quick[er] solution to this for some time now. Thank you in advance! Ron Jamison (moderators: although I've looked at the manual page plenty of times before, http://www.mysql.com/doc/manual.php?search_query=join today produced the following: Search results Did you mean jan? The search for 'join' produced no results -- kind of ironic) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Alter table and add cell at a time.
You have a different row for each answer because each answer has its own INSERT. A solution would be to do a single INSERT (with quiz question or some other data) and then for each answer do an: UPDATE $table SET $value2='$value' WHERE id='$question_id' You'd just have to keep track of the row ID (which would be the primary key in this example). Nice to see quiz software being built by an .EDU! Ron Jamison -Original Message- From: Jule [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 5:27 PM To: [EMAIL PROTECTED] Subject: Alter table and add cell at a time. Quick little followup question: if i have this: for ($n = 1; $n = $quiz[number_answers]; $n++) { $table = $qcode._answers; $value = $answers[answer.$n]; $value2 = answer.$n; $query_alter_table = ALTER TABLE $table ADD $value2 TEXT NOT NULL; $query_add_answers = INSERT INTO $table ($value2) VALUES('$value'); if (mysql_db_query($database_glob, $query_alter_table, $link_glob)) { if (mysql_db_query($database_glob, $query_add_answers, $link_glob)) { echo Answer $n: $value has successfully been added to the Quizbr\n; } else { echo mysql_error() . 1br; } } else { echo mysql_error(). 2br; } } How do I get the $value to be in the same row as the preceding one? now it comes like this: ++-+-+-+-+ | id | answer1 | answer2 | answer3 | answer4 | ++-+-+-+-+ | 1 | answer1 | | | | | 2 | | answer2 | | | | 3 | | | answer3 | | | 4 | | | | answer4 | ++-+-+-+-+ so it's like this? ++-+-+-+-+ | id | answer1 | answer2 | answer3 | answer4 | ++-+-+-+-+ | 1 | answer1 | answer2 | answer3 | answer4 | ++-+-+-+-+ thanks, Jule On Friday 17 May 2002 19:17, you wrote: Hello, Try using NOT NULL. As weird as MySQL can be, don't think it is that NUTty. =) Harrison - Original Message - From: Jule [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, May 17, 2002 7:00 PM Subject: ALTER TABLE $table ADD $value2 TEXT NUT NULL Hey i'm getting this error: You have an error in your SQL syntax near 'NUT NULL' at line 1 when i run this query, ALTER TABLE $table ADD $value2 TEXT NUT NULL from the documentation i understood that this was the correct notation. any ideas? thanks Jule -- |\/\__/\/| | Jule Slootbeek | | [EMAIL PROTECTED] | | http://blindtheory.cjb.net | | __ | |/\/ \/\| - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- |\/\__/\/| | Jule Slootbeek | | [EMAIL PROTECTED]| | http://blindtheory.cjb.net | | __ | |/\/ \/\| - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 EV56 binary?
Hi, I've an AlphaServer 1200 with dual EV56 533MHz processors and I'm looking for a precompiled MySQL binary (any of the four release trees, I don't mind which). In running the benchmark tests distributed with MySQL on the source distribution of 3.23 I found the results were worse than that of a dual intel 500MHz machine with 2GB less memory. If a person on this list has had success in compiling an efficient binary on this architecture please drop me a note. I have followed the instructions on the manual page for Linux Alpha Notes (http://www.mysql.com/doc/L/i/Linux-Alpha.html), using Compaq's compilers, but as those instructions are optimized for the EV6 I am left thinking there are better/different optimizations for the EV56. Thanks in advance! Ron Jamison - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 on a Cobalt RaQ4
I have a Raq4 running with MySQL + php no problem. Save yourself a great deal of time by loading the packages available from: http://pkgmaster.com/ These Cobalt support team guys maintain security update and misc. packages which, for the Raq 3 and above, happen to include PHP and MySQL. I highly suggest loading these packages from the control panel instead of doing source installations. -Original Message- From: Denis Croombs [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 6:30 AM To: Mysql (E-mail) Subject: MYSQL on a Cobalt RaQ4 Hi Will MySQL run on a Cobalt RaQ4 server ? Denis Croombs - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: SELECT frmo two tables
If you need to do a join: http://www.mysql.com/doc/J/O/JOIN.html However I don't see much logic in what you're doing. Stats should not include information that exists in another table, such as name and team. You need to decide what information will be unique (such as player number) or come up with a new field such as player ID to be used in associating tables with one another. E.g., associating by player number: Database.players: player_name, player_number, team, position Database.stats: player_number, penalty, groundballs, shots, faceoffs_won, faceoffs_lost, date SQL:SELECT SUM(stats.groundballs) AS grounders FROM players LEFT JOIN stats ON stats.player_number=players.player_number WHERE players.player_name='$name' -Original Message- From: Alex Behrens [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 4:00 PM To: [EMAIL PROTECTED] Subject: SELECT frmo two tables Hey All, I am having problems working on a script and need some advise. Here's my problem. I have two tables with teh following variables: rahs table: name, number, team, position stats table: name, team, penalty, groundballs, shots, faceoffs_won, faceoffs_lost, date and I need to make it so using a pulldown menu I can select player stats by their position but since the position variable isnt in both tables is it possbile to do a select command using a variable from one table for another table? Here's my syntax, but i dont know if it works: $groundballsquery = mysql_query(SELECT SUM(groundballs) AS grouders FROM stats WHERE (position = '$position') FROM rahs); is it possible to do a WHERE command with a FROM command? Thanks! -Alex Big Al Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.com Send News: [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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Trapping for no user input in a query
Kim, See the Pattern Matching section of the manual at: http://www.mysql.com/doc/P/a/Pattern_matching.html A _ matches any single character, while a % acts as a wildcard match. -Original Message- From: Kim Kohen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 2:36 AM To: [EMAIL PROTECTED] Subject: Re: Trapping for no user input in a query G'day Ron, all Tailor your query to the request of your user(s). if ($param1) $sql .= (ad_copy) against ('$param1'); if ($param1 $param2) Thank you for your reply. If at all possible though, I'd like to do it from the mysql side rather than the php side of things. Is there such a thing as a wildcard character that can be used with a fulltext index that will return all rows? cheers kim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Thanks to whomever... for the tip on mySQLMan...
I agree; theres no reason to use anything but phpMyAdmin for database maintenance over the web. The guys at phpwizard.net keep adding more and more features which strengthen its position as THE package to use for this application. I wouldn't use anything else. $0.02 -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 12:52 PM To: Andrew Lietzow; [EMAIL PROTECTED] Subject: RE: Thanks to whomever... for the tip on mySQLMan... I just went in looked at mySQLMan, and I must say, I'm not very impressed with it. If you like that package, you should really try out phpMyAdmin. You can download it at http://phpmyadmin.sourceforge.net. It's completely free, quite secure, and very easy to use. Matthew Walker Ecommerce Project Manager Mountain Top Herbs -Original Message- From: Andrew Lietzow [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 11:28 AM To: [EMAIL PROTECTED] Subject: Thanks to whomever... for the tip on mySQLMan... Helo list, I don't recall if it was here that I heard of this mySQLMan package. I think so. http://www.gossamer-threads.com/scripts/mysqlman/index.htm has quickly saved me lots of hair, and will soon enable me to go live with mySQL... My use and interest in mySQL has just taken a quantum leap forward. I have known for a long time that I would eventually want to run mySQL but the inability to use a web browser to access and manipulate data was a show-stopper for me. I just could not see myself getting all that excited by a character-based interface. It works for some things but not for serious database development, IMO. Last time I checked, Oracle wanted about 1,000,000 US dollars for their front-end gizmo (Oracle Forms?). I'm sure it has come down some since I checked. And maybe there is an X-Windows GUI interface available, but I am not aware of it. I have worked with 3-GL's in character based mode for over a decade; I like being spoiled by a browser and a GUI. So, I waited and waited, and voila, someone finally invented the wheel. The only thing I KNEW for sure during this time was that I was not going to give in and begin to use a MS product like Access; one that runs only on Windoze based O/S's. There are lots of great products for Windoze and I have to hand it to MS for marketing, but I'm not interested in having to reboot and reboot just to regain resources with a production system. While there are lots of users of MS-Access, it doesn't come in a Linux flavor so I could not devote much of my mindshare to it. It is an unfortunate reality because I really need a good database but it had to run on Linux to get my attention. So, now that I have found mySQLMan, I owe someone a huge Thank you!. I got it up and running in a day, or so, and I'm excited to be moving on with my little project. I do get the impression that mySQL is compatible with RH Interchange as the install asks this question during setup. Hope that proves to be true. If there is a better way to go for an ecommerce server than Interchange, I have not seen it--but I'm all ears! Any caveats or alternative recommendations would be considered but only for a short time...I'm about to attain lift off! Personally, I do think the security issues on mySQL take up an inordinate amount of time (from what I can see on this list, it's a major issue that needs revisited from a development point of view). Thankfully, by seeing that there is more than one table involved with the mySQL database, I poked at it long enough that I finally got the remote login to work. Geepers, what a nightmare... Wouldn't it just be easier to hang all of the illegally intruding b*$#(@+s until we eradicated them from the planet? Andrew Lietzow The ACL Group, Inc. alias Number 1 Plantsman at http://hostahaven.com - Original Message - From: Brian Bray [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 25, 2002 11:35 AM Subject: fulltext server as replication client? Here is a though: I know that replication requires identical table definitions, but does that also include identical indexes? So, could I setup a master database without a fulltext index on a particularly large table I have and then setup a slave server with the fulltext index and then do all the fulltext queries on the slave server? Thanks, Brian Bray [for the filter: sql,query] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To
RE: Impact of Free ORACLE
To answer your question I don't think the fabled price slash of Oracle will have any impact on MySQL or its community. Surely you can understand that since this is a mailing list, any posts of such titillating rumors will get a large response. I'd also like to add that after having used MySQL for two years and corresponding with the very helpful people behind MySQL AB, I'd be hard pressed to find a better, more stable database with the wonderful support that comes from the whole community. Oracle will continue to be slowly abandoned as the decision makers choose open source and low (no) cost over proprietary and stupendous costs. Larry has enough cash to hold him over for the rest of his life, but even so I'm sure he could get his hands in the mix with the soon to be developing third world corporations who will need ways to manage their livestock. I for one will be glad to see those inflated price tags go. THBBTHT! -Original Message- From: MadProfessor [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 8:11 PM To: [EMAIL PROTECTED]; 'Charles McGrotty' Cc: [EMAIL PROTECTED] Subject: RE: Impact of Free ORACLE Ok, Ok, KIDZ, I get it. I had just heard from a rather reliable pair of sources that the oracle system was free, so I thought I'd ask you cats if you had any thoughts Now I get endless buillshit sarcasm, instead of the simple 1 or 2 people pointing out that I'm wrong. The rest of you guys who thought you were being original by giving me shit as if we were on slashdot need to realize there's no call for all that. I was trying to find out more about how everyone felt. I still run MySQL on my servers, and while I was interested in how Oracle works, I wasn't about to switch, so don't feel like you need to be questioning my geekiness, nor my interest in free software or open source. End fucking rant, have a nice day. VJ MadProfessor - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Trapping for no user input in a query
Tailor your query to the request of your user(s). I.e. if only one parameter was passed from the form only match against one field. E.g.: $sql = SELECT ID, publication,run_date,left(ad_copy,40) as Advertisement FROM classifieds WHERE MATCH ; if ($param1) $sql .= (ad_copy) against ('$param1'); if ($param1 $param2) $sql .= AND MATCH ; if ($param2) $sql .= (long_group) against ('$param2'); /* query */ -Original Message- From: Kim Kohen [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 10:47 PM To: [EMAIL PROTECTED] Subject: Trapping for no user input in a query Hello all I am trying to query two columns in mysql which have fulltext indexes using the following: SELECT ID,publication,run_date,left(ad_copy,40) as Advertisement FROM classifieds WHERE MATCH (long_group) against ('\$param2\') AND MATCH (ad_copy) against ('\$param1\') As you can probably guess, the $params are coming from a form via php. The above query works fine when the user submits both parameters but I can't work out how to trap for the user only entering a single parameter (which causes the query to always return an empty set)? Cheers and thanks kim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: datafile.MYI has been destroyed can't recover
First make a backup of your MYD file if you haven't already done so. Then delete the useless index file (MYI) and run myisamchk with the --quick flag which will hopefully recreate the index file. Also consult the chapter on crash recovery with myisamchk at http://www.mysql.com/doc/T/a/Table_maintenance.html as it has saved my own data numerous times. Good luck, Ron Jamison -Original Message- From: Andy Woolley [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 23, 2002 2:44 AM To: [EMAIL PROTECTED] Subject: datafile.MYI has been destroyed can't recover Hi, I've got a 300 MB database file with a useless MYI file and I cant seem to reconstruct it. Anyone know how I can get the data back. if I use myisamchk -o it destroys all the data in the file so I'm kinda stumped. Cheers Andy PS I need to enter SQL and Query cos this mail bouced at first. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Post installation problems in MySQL
Or simply create a symbolic link as suggested in the documentation: ln -s /usr/local/mysql-3.23.49a-pc-linux-gnu-i686 /usr/local/mysql cd /usr/local/mysql ./bin/safe_mysqld -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 23, 2002 2:46 AM To: [EMAIL PROTECTED] Subject: Post installation problems in MySQL srividya, Friday, March 22, 2002, 9:55:50 PM, you wrote: ss I installed the binary version of (MySQL) ss mysql-3.23.49a-pc-linux-gnu-i686.tar.gz. ss The steps followed to install are: ss tar xvzf mysql-3.23.49a-pc-linux-gnu-i686.tar.gz. ss cd mysql-3.23.49a-pc-linux-gnu-i686 ss ./configure ss scripts/mysql_install_db ss cp support-files/my_medium.cnf/etc/my.cnf ss ./bin/safe_mysqld ss After installing, I tried to start mysqld daemon using the command ss ./bin/safe_mysqld. The message obtained is given below. ss Starting mysqld daemon with the databases from ss /usr/local/mysql-3.23.49a-pc-linux-gnu-i686/data ss 020322 13:31:50 mysqld ended ss Then directly I tried to start the mysqld with the command ss ./bin/mysqld In this case the error message obtained is: ss ./bin/mysqld: Fatal error: Can't find message file ss '/usr/local/mysql/share/mysql/english/errmsg.sys' ss Actually the errmsg.sys file is located in the path ss '/usr/local/mysql-3.23.49a-pc-linux-gnu-i686/share/mysql/english/err ss msg.sys' ss and not in '/usr/local/mysql/share/mysql/english/errmsg.sys'. You should specify path to your message file using '--language' option of mysqld: safe_mysqld --language=/usr/local/mysql-3.23.49a-pc-linux-gnu-i686/share/mysql/engli sh ss I need help to resolve this problem ss Thanks ss -Sri -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL Alpha Linux binary distribution: Core dumped on AlphaServer 1200
After doing some more research I found out that the chip in the AS 1200 is an EV56, and made the connection between that and the EV6 binary dumping on me. Following the advice of 2.6.1.4 Linux Alpha Notes at: http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Li nux-Alpha I installed the Compaq Linux Alpha compiler (ccc and cxx) and built the latest MySQL source with configure flags: CC=ccc CFLAGS=-fast CXX=cxx CXXFLAGS=-fast -noexceptions -nortti ./configure --prefix=/usr/local/mysql --disable-shared --with-extra-charsets =complex --enable-thread-safe-client --with-mysqld-ldflags=-non_shared --wit h-client-ldflags=-non_shared Yay, it works! However I cannot benchmark it using sql-bench: [root@jive mysql]# make test PERL_DL_NONLAZY=1 /usr/bin/perl -I../blib/arch -I../blib/lib -I/usr/lib/perl5/5.6.0/alpha-linu x -I/usr/lib/perl5/5.6.0 -e 'use Test::Harness qw(runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t t/00baseinstall_driver(mysql) failed: Can't load '../blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ../blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: _OtsMove at /usr/lib/perl5/5.6.0/alpha-linux/DynaLoader.pm line 200. at (eval 1) line 3 Compilation failed in require at (eval 1) line 3. Perhaps a required shared library or dll isn't installed where expected at t/00base.t line 38 I've tried using Msql-Mysql-modules version 1.2216 and version 1.2218. For the latter version I've tried compiling using the ccc compaq compiler with success. However it is failing in DynaLoader.pm which to my knowledge is a module for loading C libraries into perl. So my question now is.. do I need to recompile Perl with the CCC compiler? What steps did the MySQL team take to get sql-bench running on the alpha EV6 machine? I'd prefer to continue using sql-bench as its easier imho than installing a 3rd party benchmark app. Thanks, Ron Jamison -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Trond Eivind Glomsrød Sent: Thursday, December 13, 2001 9:39 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: MySQL Alpha Linux binary distribution: Core dumped on AlphaServer 1200 Sinisa Milivojevic [EMAIL PROTECTED] writes: Ron Jamison writes: Hi, I'm trying to use the available MySQL Linux Alpha binary distribution on this AlphaServer: Linux jive.shadowtrance.com 2.4.9-12smp #1 SMP Tue Oct 30 17:54:45 EST 2001 alpha unknown Running RedHat 7.1 Alpha Deluxe, Using MySQL 3.23.46 from: http://prdownloads.sourceforge.net/mysql/mysql-3.23.46-unknown-linux-gnu-alp haev6.tar.gz Thanks in advance! Ron Jamison Hi! Try a binary from our site. The above one _is_ your site, isn't it? -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: SELECT'ing only 1st matching row
Tack on a LIMIT 1 on the end of your query to limit the returned rows to 1. Reference: http://www.mysql.com/doc/S/E/SELECT.html -Original Message- From: Steve Osborne [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 12:47 PM To: MySQL (E-mail) Subject: SELECT'ing only 1st matching row Is there a way to SELECT only the first matching row of a query? I would like to allow the registration of identical products (unique serial numbers / owned by one user), without the user having to re-enter all their data. I've set up a page that allows them to just enter their login info (username and password) and the serial number of the product they want to register. What I need to do is grab their product preferences to be duplicated in the new record, however is they have more than one registered product, it throws off my plan. I only need one record to get the values that I need. (I know that duplicating values is not proper database form, however I need to allow the user to change their preferences on each owned product.) Any advice, Steve Osborne Database Programmer Chinook Multimedia Inc. [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Alpha Linux binary distribution: Core dumped on AlphaServer 1200
SourceForge is indeed one of their mirrors. Robert if you look you'll see Monty listed as a project admin. I find it easier to download direct from the sourceforge mirror than to navigate through the new download system on mysql.com. I hate it when I wget an html file instead of the tarball I'm seeking. Sorry if this message gets to you twice, Trond. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Trond Eivind Glomsrød Sent: Thursday, December 13, 2001 11:51 AM To: Robert Alexander Cc: [EMAIL PROTECTED] Subject: Re: MySQL Alpha Linux binary distribution: Core dumped on AlphaServer 1200 Robert Alexander [EMAIL PROTECTED] writes: Sinisa Milivojevic [EMAIL PROTECTED] writes: Ron Jamison writes: Using MySQL 3.23.46 from: http://prdownloads.sourceforge.net/mysql/mysql-3.23.46-unknown-linux-gnu-alp Try a binary from our site. The above one _is_ your site, isn't it? The actual MySQL site is, predictably enough, www.mysql.com. For downloads, try: http://www.mysql.com/downloads/ I know that, but I'm pretty sure sourceforge is one of their mirrors. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: [PHP] Performance
I'm fairly sure there's no difference in performance when using PHP tags mixed with HTML blocks as you are doing. Think of it as PHP knowing that it should send everything not in ? ? tags directly to the browser. Like an echo or a print, but without needing to specify calls to those functions. HTML ? echo $PHP_SELF ? /HTML HTML ?=$PHP_SELF? /HTML -Original Message- From: markus|lervik [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 11:47 AM To: [EMAIL PROTECTED] Subject: Re: [PHP] Performance On Thu, 2001-12-13 at 19:18, Prottoss wrote: Actually unless this has been changed, when your php script terminates php automatically closes any mysql connections opened with mysql_connect(). I've noticed that, and up 'till now I haven't had a clue as to where the problem was. Thanks for that bit of information, but it raises another question, at least for me, namely: How would one go about doing, for instance, FORM ACTION=?php echo $PHP_SELF? METHOD=POST-tags in that case? Using echo bypasses the PHP-preprocessor and just simply prints out the FORM tag. I really wouldn't want to use FORM ACTION=blah.php, as I have this FORM tag in a nifty function that is called from a bunch of scripts. Cheers, Markus -- Markus Lervik Linux administrator with a kungfoo grip Vasa City Library - Public Library - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Count occurrence of word in a column
I don't think theres a MySQL function to return the number of times a phrase appears inside a field. Another way you could achieve the same goal: SELECT field FROM table WHERE field LIKE '%word%word%word%' ^-- would match on three occurences of 'word' If you need a count of the number of times 'word' appears in that field you're out of luck so far as the MySQL SELECT() is concerned. You'll have to select those rows and then count the # of times 'word' appears in the returned data. -Original Message- From: Michael Collins [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 12:22 PM To: [EMAIL PROTECTED] Subject: Count occurrence of word in a column How can I most efficiently return just the count of some word in a large text field in a MySQL db, without returning the actual text field contents. I am looking for the number of times the word appears with a specific column, not count() of all columns that have that word. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.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: [PHP] Performance
When working with normal connections i.e. non-persistent months ago, using what must've been PHP 4.0.1 or .2, I had some similar experiences. In a number of my more lengthy scripts I was seeing MySQL connections closing on me before the script was done executing. Thus PHP would spit out errors about not having a connection and to ensure it worked I was having to repeatedly call mysql_connect(). I wouldn't doubt the same thing is what Markus is seeing. In these cases, using persistent connections solved the problem for me. -Original Message- From: markus|lervik [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 2:16 PM To: Fournier Jocelyn [Presence-PC] Cc: [EMAIL PROTECTED] Subject: Re: [PHP] Performance On Thu, 2001-12-13 at 23:56, Fournier Jocelyn [Presence-PC] wrote: Hi, You absolutely don't have to reconnect to the database each time a PHP-block ends ! (it would be completely awfull !!). Don't you forget to specify the mysql link in you 'mysql_query' ?? Nope, I always specify the mysql link in my queries. But the problem remains. As I'm at home for the moment, I can't try out all the suggestions, but I have tried the p_connect, and it most certanly didn't work. I'll have to try to pinpoint the problem more closely tomorrow at work. It just might be (came to think of it now), that php closes the connection every time I use a submit-button and it reloads the page. Technically speaking, that would be ending a script, right? -Markus -- Markus Lervik Linux administrator with a kungfoo grip Vasa City Library - Public Library - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Alpha Linux binary distribution: Core dumped on AlphaServer 1200
Hi, I'm trying to use the available MySQL Linux Alpha binary distribution on this AlphaServer: Linux jive.shadowtrance.com 2.4.9-12smp #1 SMP Tue Oct 30 17:54:45 EST 2001 alpha unknown Running RedHat 7.1 Alpha Deluxe, Using MySQL 3.23.46 from: http://prdownloads.sourceforge.net/mysql/mysql-3.23.46-unknown-linux-gnu-alp haev6.tar.gz [root@jive mysql]# ./scripts/mysql_install_db Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables ./scripts/mysql_install_db: line 1: 1008 Illegal instruction (core dumped) ./bin/mysqld --bootstrap --skip-grant-tables --basedir=. --datadir=./data -- skip-innodb --skip-gemini --skip-bdb Installation of grant tables failed! [root@jive mysql]# ./bin/safe_mysqld [1] 3062 [root@jive mysql]# Starting mysqld daemon with databases from /usr/local/mysql/data ./bin/safe_mysqld: line 273: 3080 Illegal instruction (core dumped) $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21 491213 04:08:37 mysqld ended I have tried compiling from source however the benchmark results after doing so are worse than an intel 500mhz box thats running a binary installation. You would think that a 5/533 dual processor alpha box with 3 GB memory would beat out a 500 MHz dual processor intel box with 512 MB any day of the week no matter what compile flags you used ;). Any and all suggestions are welcome. Thanks in advance! Ron Jamison - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php