Mysql.sock ????
Hi all, I've installed mysql 3.23.42 on Freebsd system but when i launch mysql i said me can't connect to localhost /tmp/mysql.sock not found. How can i repair this error? Thanks Moreno - Moreno Riccardi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.sock ???
Hi all, I've installed mysql 3.23.42 on Freebsd system but when i launch mysql i said me can't connect to localhost /tmp/mysql.sock not found. How can i repair this error? Thanks Moreno - Moreno Riccardi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 I can do this
Using MySql. I can make this from another language iteranting for each one of the elements in the table, but in this form it is really very slow, because the real table is too big,. for that reason I would like to know if it is possible to make this using only MySql instructions. Sorry for my english, Javier - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Javier [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, October 28, 2001 5:13 AM Subject: Re: How I can do this On Fri, Oct 26, 2001 at 10:04:44AM +0100, Javier wrote: Hi, I need do the follow: Table 1. Field 1. Varchar (6) Field 2. Varchar (6) The data in this table are for example Field 1 Field 2 A TT A YY A RR B FF B KK I need to obtain a result in the following form: A TTYYRR B FFKK How can i do this? Using what programming language? This message has been scanned for all known viruses by MessageLabs. This message is intended for the stated recipients only and may be confidential. Opinions expressed in this email do not necessarily reflect the opinions of Globepost Travel or Travelselect.com. If you feel you received this email in error and would not like receive any further emails from travelselect.com, please reply to [EMAIL PROTECTED] *** So if I send an unsubscribe message, will you no longer mail me? That seems strange unless you're some kind of smart spam bot. Are you? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 52 days, processed 1,160,921,191 queries (258/sec. avg) *** This message has been virus scanned by Messagelabs *** *** This message has been scanned for all known viruses by MessageLabs. This message is intended for the stated recipients only and may be confidential. Opinions expressed in this email do not necessarily reflect the opinions of Globepost Travel or Travelselect.com. If you feel you received this email in error and would not like receive any further emails from travelselect.com, please reply to [EMAIL PROTECTED] *** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Simple problem: Blank search box returns all records
Hi, This is more of a jsp/html/javascript issue. It is relatively easy to create a small procedure/function in javascript/jsp which checks all the fields are not emtpy, and gives a warning message when you click on the submit button. Its much easier to run the validation before sending the requests off to mysql so the query will be simpler, and therefore execute much faster. Andrew Murphy -Original Message- From: BadgerBay [mailto:[EMAIL PROTECTED]] Sent: 27 October 2001 6:00 am To: [EMAIL PROTECTED] Subject: Simple problem: Blank search box returns all records How do I avoid search problems when a user leaves a search box empty on an Ultradev search page running jserv and attached to a MySQL database? I have three search boxes: Author, Title, and Keyword The user enters the search data into one, two, or all three of the fields, and presses SUBMIT (I use JSP), so the variables for the recordset are (ex. Author) : Name: varAuthor Default Value: % [I also tried 1 ] Run-Time Value: request.getParameter(txtAuthor) The search uses this SQL logic: SELECT Author, Title, Keyword FROM tbJose WHERE Author LIKE '%varAuthor%' OR Title LIKE '%varTitle%' OR Keyword LIKE '%varKeyword%'; The search works perfectly , UNLESS A USER LEAVES ONE BOX EMPTY, then the search RETURNS ALL RECORDS IN THE DATABASE, whether the default value is % or is 1. I do not want this to happen. How might I modify the code? I am a SQL beginner so I need explicit instructions. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: C API - mysql_store_result segfaulting
Hi Carsten, I have just had a similar experience, which Jorge from Mysql support helped me sort out (successfully) - here is his advice to me. Hi! Which compiler / version are you using ? If it is any from 2.96 series, you'd be better off using any in the 2.95 or 3 series, as 2.96 is still buggy. Another question, was the libmysqlclient you're using downloaded from us, or was it the one shipped with the Red Hat CD ? If it's the one from the Red Hat CD, then it's the same thing Buggy compiler ! Regards, Jorge Robin. -Original Message- From: Carsten H. Pedersen [mailto:[EMAIL PROTECTED]] Sent: 27 October 2001 23:07 To: mysql mailing list Subject: C API - mysql_store_result segfaulting I'm having some trouble moving a C application from a test machine to production. The program, which uses the small wrapper around mysql_query() shown below, runs flawlessly on the test machine (hours of runtime; tens of thousands if not a million+ queries). On the production machine, the program will execute exactly 10 queries, then segfault. The 10 queries which are executed before the fault are a mix of INSERT, DELETE, and SELECTs which return both empty and non-empty sets. The last query is a SELECT which returns (well -- is *supposed* to return) an empty set. The problem is twofold: The call to mysql_field_count() returns 1 (should be 0) and upon reaching the mysql_store_result() function call, the program segfaults. I have tried switching around the two statements (as per the examples in the docs), to no avail. Both machines run RH Linux 7.1, and use GCC 2.96-85 Test machine: - MySQL 3.23.39-1 RPM from mysql.com - glibc-2.2-12 - kernel v. 2.2 (as included in RH 7.1) Production machine: - MySQL 3.23.43-1 RPM from mysql.com - glibc-2.2.4-19 - updated kernel (2.4) I've been trying all kinds of up- and downgrades of gcc and the MySQL packages, different levels of compiler optimizations, etc., but can't seem to get around this problem. If anyone has any hint as to what is wrong, I would appreciate hearing from you. [code snippet below] / Carsten MYSQL_RES *mysql_query_e(char *query, char* message, int lineno) { int result; char *errmsg; MYSQL_RES *resultset; // Do the query if (mysql_query(mysql, query)) { printf(\n ERROR: Error when querying database on line %d.\n --\n%s\n\nQuery:\n %s\n\nError message:\n%d: %s\n, lineno, message, query, mysql_errno(mysql), mysql_error(mysql)); fflush(stdout); exit(2); } // Check whether we should expect any data if (mysql_field_count(mysql)) { // On the 11th query... // ... this line prints 1 where it should say 0: printf (%d fields in result\n, mysql_field_count(mysql)); // ... and the following line segfaults: resultset = mysql_store_result(mysql); if (NULL == resultset) { printf(Error: Could not get result for query on line %d\n --\nExpected %d columns\n %s\n\nQuery:\n %s\n\nError message:\n%d:\n%s\n, lineno, mysql_field_count(mysql), message, query, mysql_errno(mysql), mysql_error(mysql)); fflush(stdout); exit(2); } // yes, there is data. Return the the result to caller return resultset; } // No data, no columns. That's fine return NULL; } --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.282 / Virus Database: 150 - Release Date: 25/09/01 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.282 / Virus Database: 150 - Release Date: 25/09/01 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlbinlog
Hi, I have mysql - bin -log, but when i read this I can't find IP number from client who made connection to my server. How i find IP number in mysql - bin -log ? 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
General error: Can't lock file (errno: -1)
Hi, When I run my application I get java.sql.SQLException: General error: Can't lock file (errno: -1) at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java) at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java) at org.gjt.mm.mysql.Connection.execSQL(Connection.java) at org.gjt.mm.mysql.PreparedStatement.executeQuery(PreparedStatement.java) at What does it mean and how do i fix it? I run Mysql with the Gemini tables /Pelle E - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 query
Hi, Getting non-empty results when comparing something with NULL seems very odd to me too. Even if it is undefined, id expect to see an error message telling me i shouldnt compare an undefined variable rather than receiving results. Why not ask someone to change things so that WHERE xx=NULL gives the same results as WHERE xx IS NULL. Or would that be an unusual thing to request. Andrew Murphy -Original Message- From: jim barchuk [mailto:[EMAIL PROTECTED]] Sent: 27 October 2001 8:32 pm To: Paul DuBois Cc: [EMAIL PROTECTED] Subject: Re: Problem with query Hi Paul! On Sat, 27 Oct 2001, Paul DuBois wrote: At 9:38 -0400 10/27/01, jim barchuk wrote: Hi Carl! Paul DuBois writes: NULL basically means unknown value, so saying WHERE x = NULL cannot work, even if x is NULL. That means where one unknown value = another unknown value, which cannot be evaluated with any certainty. :-) It is sort of odd, though, that x = NULL returns something which appears to be undefined rather than something well-defined (such as false all the time) or an error (which could be said to be well-defined, if errors are considered to be valid responses to queries...). Well which would you prefer, false or error? Dealing with errors is annoying if not necessary. 'False' is incorrect -if- the field is allowed to contain 'nothing' because NULL means it does contain nothing. I think what Carl meant was that it was strange that the WHERE x = NULL query returned a non-empty result set. I noticed that in the original message, too. I don't know what accounts for it. I think WHERE x = NULL 'may' return non-empty results, or not, simply because NULL is undefined and most bets are off for that query. Undefined doesn't mean random. Yes, http://www.mysql.com/doc/W/o/Working_with_NULL.html does say In MySQL, 0 or NULL means false and anything else means true. In this case I take undefined to mean that what appears to work this time may not work next time, depending on the structure of the query, or even if it works consistently with one version of MySQL it may not with another. Quoting page 47 of your book, If you attempt to use NULL with the usual arithmetic comparison operators, the result is undefined. Similarly, quoting http://www.mysql.com/doc/P/r/Problems_with_NULL.html , To look for NULL values, you must use the IS NULL test. 'Must' is a very strong word and I take it as gospel. I think I have less problem with trying to understand what accounts for something that may appear odd to others is that I don't try to think about 'why' when given such clear instrutions. I had a -very- educational experience with NULL with my very first attempt at MySQL -- HTML rendering. TABLE cells that -appeared- to contain something but shouldn't have and really didn't. Had my head spinning for hours until I finally got a grip on the idea that NULL is a Very Strange Thing and that I *must* deal with it only in certain ways. NULL rocks. :) Have a :) day! jb -- jim barchuk [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
ODBC Call Fails
Hi all, Not sure if this is the right place to ask this one but here goes! I'm trying to export an Access 2000 database to MySQL and remain using Access as the front end. Everything seems to be working fine, except for this one line of code which is giving me and ODBC call failed error. CurrentDb.Execute DELETE * FROM SpecialismForContacts WHERE (SpecialismForContacts.ContactID= Forms!frmPhotographingContact!txtContactID ) AND (SpecialismForContacts.SpecialismID IN (SELECT SpecialismID FROM Specialisms WHERE Specialisms.AreaID= cboArea )), dbFailOnError Does anyone have any insights to why this is? Alex - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Binaries /Pictures in mysql
I have the same question but i want to store binaries in the database, but not sure how to go about it cheers Dave Siim Einfeldt aka Itpunk wrote: I know you most likely want to add the full source of teh pics to database, but this is nt a good idea. The best way would be to just write the picture location to the database. If you write the pictures itselves, then it will make the database rather big. I have one database over 45mb and all that only because of the pictures. Now making the backups, etc isnt too easy. Cheers S. Hello friends. I am a newbie in mysql and web programming. Can someone please tell me where I can find some info on putting pictures into mysql fields and also how I can use a web interface to add the pictures to the database. Thanks Denis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: make fails on AIX 4.3.3 using the IBM xlc/xlC compiler
Thank you for your report. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQLGUI hangs on certain commands
David Wolf writes: I've been trying to play with MySQLGUI lately (running the win32 version of the GUI, Linux version of the server). I can connect fine. Run queries fine. But, when I try to do any grants on a database or edit a table, the client connects to the server as many times as it can (before the server runs out of connections available) and hangs until I forcibly kill it. Does anyone know why that would happen?? Thanks, David Hi! Editing table in MySQLGUI should make no problems, since it does nothing. It has not been done yet. Regarding grants, GRANT / REVOKE dialogu does not connect to database until you click on 'Apply' button. Then a command is executed and connection is closed. Can you describe in more detail how you managed to run out of connections only with MySQLGUI, so that I might repeat a case. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Can not load database
Hello mysql I have been give the database files for a mysql database that I can not get to open and display records. I have run myisamchk, isamchk, mysqlcheck, mysqldump and all return the header does not support check/repair or cut Now I am using mysql 3.23 on win32 to view this and the possiblity of the database is a earlier version on linux is very high. Any Ideas on how to read the data? I really just need a mysqldump of the file, If you want to take a stab at it I will email you the isd,ism, frm files off list. 2.2megs I do not have any mdi, or mdy files for the database yet. Those are ISAM files. If they were created on another OS, you're out of luck. Only MyISAM files may be moved between different OS's. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: DATA DIRECTORY bug on Win32
Hi! Mike == Mike Blazer [EMAIL PROTECTED] writes: cut Mike Well, I'm sure there are some better ways too - it's a pity that it such Mike a useful feature fails on Win32. I have now changed MySQL 4.0.1 to ignore any DATA DIRECTORY directives, until we have come up with an acceptable workaround for windows. Mike Oops! Sorry, I hope you removed this feature for Win32 only, because on Mike *NIX it works perfectly. In fact we already started bulding the new Mike multi-drive database using this kind of symlinking (on Linux and Mike Solaris). Yes, we only removed this for windows. Mike Well, may be I'm missing something - I'm preparing such a huge base for Mike a 1st time - but except of DATA DIRECTORY it's only RAID mechanism that Mike lets you use few disks and not fail after OPTIMIZE TABLE. RAID can't help you to use many disks on windows, because you can't symlink directories on windows as you can on Unix. Mike But Raid has its unpleasant side - it puts all tables to the same Mike 00,01,02 not to tab1.00, tab2.00 etc. So, you can't actually split the Mike tables between disks. Parts of all tables will be on all disks. And you Mike can't move index files at all. And also, if your disks are not equal, Mike like 8GB and 18GB and all big tables are raid-ed seems like a big part Mike of the bigger drive will always be empty - beause Raid writes equal Mike portions of data. RAID was mainly designed to help overcome the 2G limit on old Linux filesystems, not to split things across many disks (even if it can be used for this on Linux). Mike So, Michael, please, please open the DATA DIRECTORY feature for the Mike systems that can handle it! It's a life-saving feature. Of course (I never intended to remove this for Unix). Mike Thanks a lot! Mike Mike Blazer Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re:difficulty compiling v4 --without-innodb
Hi Sommai! On Mon, 29 Oct 2001, Sommai Fongnamthip wrote: Did you mean V4 must ran with innodb? Oh! I have bad experience with innodb. It ate a lot my hard disk space. Oh no! Absolutely not required! I think V4 defaults to --with-innodb because './configure --help |grep -i inno' returns '--without-innodb Do not include the InnoDB table handler.' So it's easy to turn off. My problem was that Apachetoolbox created other config files for its own use that I was unable to figure out how to disable. Those other config files kept the default --with-innodb status. Doing a clean reinstall and -not- using Apachetoolbox made those other config files 'not appear' and my './configre --without-innodb' was able to 'hold it's ground.' :) I'm sure there's a way to set my preferences in toolbox but the docs are very thin, it's a pretty complex app, I'm not a shell-gooroo either, and I haven't bothered to try to figure out how to do that yet. Have a :) day! jb -- jim barchuk [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 Security w/ PHP
Hi! On Oct 28, Kevin Maynard wrote: I have been building an extensive dB with MySQL for a large Insurance Company and am nearing the completion stage. I have build several PHP forms to show the preliminary pages to the various groups who will be using this dB. I have created the sign-in page where each user has types in their ID and PW. From then on each query uses those variables for credentials. To avoid duplication, I would like to use the USER form from the MySQL dB. You shouldn't do it. These table is used by mysql server internally, and shouldn't be accessed directly. To modify this user table one should use GRANT and REVOKE statements. To read it - SHOW GRANTS. (actually, it can be accessed directly, but ONLY if you're know what you're doing. It looks like you aren't) Since that uses the Password(PW) function, I can't seem to get my validation query to work properly. For example: SELECT User,Password from user where (User=$ID AND Password=$PW); Result: Empty Set. SELECT User,Password from user where (User=$ID AND Password($PW)); Result: Will match User only, will accept ANY PW. SELECT User,Password from user where (User=$ID AND Password=PASSWORD($PW)); Does anyone know how to properly check off the PW from the User table in the MySQL db? The proper way is not to use system tables, and mysql db in general. Create your own database, and User table in it. And, the last, you'd better use MD5() instead of PASSWORD(). Another good reason not to do this: At startup, mysqld reads all privileges for all users into memory - and they stay there whether or not those people log in. Seems to be a pretty stupid way of using up your RAM. Add to that the time spent by MySQL checking permissions for one in thousands of users for every single query - ugh... / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RESOLVED: C API - mysql_store_result segfaulting
Thanks to the help of Sasha Pachev and Robin Keech, the problem has been resolved. The solution came in three stages: 1) Downgrading glibc and glibc-devel to non-RedHat 2.2.4-5 RPMs 2) Ditto for gcc - down to v. 2.95.3 3) And an error on my own: removing some extraneous mysql_free_result() which caused the next call to mysql_store_result() to segfault. Why these did not cause any problems on the test machine is beyond me. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq I'm having some trouble moving a C application from a test machine to production. The program, which uses the small wrapper around mysql_query() shown below, runs flawlessly on the test machine (hours of runtime; tens of thousands if not a million+ queries). On the production machine, the program will execute exactly 10 queries, then segfault. The 10 queries which are executed before the fault are a mix of INSERT, DELETE, and SELECTs which return both empty and non-empty sets. The last query is a SELECT which returns (well -- is *supposed* to return) an empty set. The problem is twofold: The call to mysql_field_count() returns 1 (should be 0) and upon reaching the mysql_store_result() function call, the program segfaults. I have tried switching around the two statements (as per the examples in the docs), to no avail. Both machines run RH Linux 7.1, and use GCC 2.96-85 Test machine: - MySQL 3.23.39-1 RPM from mysql.com - glibc-2.2-12 - kernel v. 2.2 (as included in RH 7.1) Production machine: - MySQL 3.23.43-1 RPM from mysql.com - glibc-2.2.4-19 - updated kernel (2.4) I've been trying all kinds of up- and downgrades of gcc and the MySQL packages, different levels of compiler optimizations, etc., but can't seem to get around this problem. If anyone has any hint as to what is wrong, I would appreciate hearing from you. [code snippet below] / Carsten MYSQL_RES *mysql_query_e(char *query, char* message, int lineno) { int result; char *errmsg; MYSQL_RES *resultset; // Do the query if (mysql_query(mysql, query)) { printf(\n ERROR: Error when querying database on line %d.\n --\n%s\n\nQuery:\n %s\n\nError message:\n%d: %s\n, lineno, message, query, mysql_errno(mysql), mysql_error(mysql)); fflush(stdout); exit(2); } // Check whether we should expect any data if (mysql_field_count(mysql)) { // On the 11th query... // ... this line prints 1 where it should say 0: printf (%d fields in result\n, mysql_field_count(mysql)); // ... and the following line segfaults: resultset = mysql_store_result(mysql); if (NULL == resultset) { printf(Error: Could not get result for query on line %d\n --\nExpected %d columns\n %s\n\nQuery:\n %s\n\nError message:\n%d:\n%s\n, lineno, mysql_field_count(mysql), message, query, mysql_errno(mysql), mysql_error(mysql)); fflush(stdout); exit(2); } // yes, there is data. Return the the result to caller return resultset; } // No data, no columns. That's fine return NULL; } - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [MySQL 4.0 compile fails on Linux]
Ed Carp writes: Description: make[3]: Entering directory `/usr/local/src/mysql-4.0.0-alpha/sql' gcc -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local\ - DDATADIR=\/usr/local/var\ -DSHAREDIR=\/usr/local/share/mysql \ -DHAVE_CONFIG_H -I../innobase/include -I./ ../include -I./../regex-I. -I../include -I. -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -c sql_lex.c c sql_lex.cc: In function `void lex_init()': sql_lex.cc:85: `symbols' undeclared (first use this function) sql_lex.cc:85: (Each undeclared identifier is reported only once sql_lex.cc:85: for each function it appears in.) sql_lex.cc:85: confused by earlier errors, bailing out make[3]: *** [sql_lex.o] Error 1 Hi! Do: bk -r edit The above is defined in lex.h -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: insert BLOB in perl
On Mon, 29 Oct 2001, Jindo Soul wrote: Why this error exists is beyond my knowledge though. I am guessing that Perl DBI escapes ' \ in bind_param call. And MySQL escapes the data again when using big5 charset, which ultimate causes an error because of double escaping. Well, its not that MySQL does any escaping but you're basically right. The DBD::mysql driver will escape all instances of the backslash. If the backslash is the last character in a string _and_ the last part of the string represents a multibyte big5 character, there's a problem. Perl turns 'A\' into 'A\\'. But MySQL will see that as 'A\' plus '\''. In other words, the second backslash is seen as escaping the single quote, leaving the quote not terminated. I tried patching the DBD::mysql code a year or so back but my C skills are very weak and I couldn't quite get it. I still have the patches somewhere if someone more skilled than me wants to take a crack at it. Basically, I was looking to add a 'mysql_wide_charset' option that could be passed to the driver. Nowadays, it might be better if instead it just checked with the server as soon as it connects (though that only works for newer MySQLs). -dave /*== www.urth.org We await the New Sun ==*/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 privileges
Hi! I'm working on a Linux Mandrake 8.1 station. I have installed MySQL. I have typed './mysql_install_db' When i type mysql, i have the prompt mysql But when i type create database phpdig i have the error message: ERROR 1044: Access denied for user: '@localhost' to database 'phpdig'. Can anybody help me ? Thanks Franck - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ODP: MySQL privileges
Hi Just type: mysql -u root Regards -Oryginalna wiadomoæ- Od: COLLINEAU Franck FTRD/DMI/TAM [mailto:[EMAIL PROTECTED]] Wys³ano: 29 padziernika 2001 15:05 Do: '[EMAIL PROTECTED]' Temat: MySQL privileges Hi! I'm working on a Linux Mandrake 8.1 station. I have installed MySQL. I have typed './mysql_install_db' When i type mysql, i have the prompt mysql But when i type create database phpdig i have the error message: ERROR 1044: Access denied for user: '@localhost' to database 'phpdig'. Can anybody help me ? Thanks Franck - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
SecureCRT
I am using SecureCRT to login to a remove MySQL server. I can get pass the initial login. However, a login screen displays on the screen asking for a second password. I have entered all information correctly, but the system is still requesting another password. Verlin Taylor - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 - Request. Are they the same? I dont think so. (fwd)
Hei Could anybody explain me the different between a question and a sql-request in mysql?. F.example: If I send a sql-request to mysql: select * from Table where column_A=1 and column_B=2 order by column_C; num.sql_request = 1 and num.questions = 1 Is this true? Can I send 1 sql_request that generate many questions? I am asking this because I am getting around 17.000.000 QUESTIONS a day in my DB, but I am sure we don't send 17 mill sql-request to mysql. Thanks for your help. Sincerely Rafael Martinez -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
my_print_defaults: not found
When I run my startup script, I get the following message: # /etc/rc2.d/S99mysql start /etc/rc2.d/S99mysql: my_print_defaults: not found # Starting mysqld daemon with databases from /usr/local/mysql/data I've tried adding a command print-defaults to my.cnf, but that caused the startup to terminate. Is this something that can just as easily be disabled, or is there some information that is being sought here that should be placed correctly somewhere? ari Ari Davidow [EMAIL PROTECTED] www.klezmershack.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: SecureCRT
[EMAIL PROTECTED] wrote: I am using SecureCRT to login to a remove MySQL server. I can get pass the initial login. However, a login screen displays on the screen asking for a second password. I have entered all information correctly, but the system is still requesting another password. Verlin Taylor - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Why dont you use ssh to login to you sever . - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 question on Linux.
Hi, all, I am installing MySQL+Gemini 3.23.41 on Linux 6.2. I followed the instructions such as tar xvf, etc. Then I came to the : CFLAGS=-03 \ CXX=gcc CXXFLAGS=-03 -felide-constructors -fno-exceptions -fno-rtti \ ./configure --prefix=~/local/mysql\ --enable-assembler --with-mysqld-ldflags=-all-static After these commands come a lot of checking, some are no, some are yes. I am not sure if every checking should be yes. The last 4 checkings are: checking for tgetent in -lncurses... no checking for tgetent in -lcurses... no checking for tgetent in -ltermcap... no checking for termcap functions library... configure: error: No curses/termcap library found Did I miss anything? Wei - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Further to the installation fail on Linux.
Hi, all, About my earlier message about installation of mysql on Linux. the ~/local/ directory is a local scratch space allocated by my lab. And my problem is that no Makefile is created after the ./configure and thus I cannot make. Wei - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 MySQL be run from a CD-ROM?
I'd like to package MySQL, some databases, and PHP-enabled Apache on a CD-ROM, with all components runnable with, essentially, no installation in a Windows environment. This would be a read-only database accessed through a web browser by way of PHP scripts. Is such a thing possible? Alternatively, is it possible to set up MySQL to be runnable from a CD-ROM, but using a hard-wired hard drive location in which to find the database tables? Thanks, Bob - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
JSP newbie needs to run MySQL-JDBC.
Hello Everyone, I need to run MySQL using JSP. I am a JSP newbie, actually a Java newbie too. I am more of a PHP/MySQL guy. I have successfully installed Allaire JRun 3.0 on Win98 using PWS. JRun has an application management console and I cannot seem to run MySQL. I am totally unfamiliar with how JRun, JDBC and MM.MySQL runs and the error message I get is: The following error occurred while testing the data source connection Communication link failure: java.io.EOFException I will enumerate everything I have done to see where I have gone wrong: 1. I am on a LAN and my IP address is 192.186.0.2. So on PWS, my localhost is basically 192.168.0.2. Everything is working fine with PWS and could use it with PHP and MySQL, thus I know MySQL is working fine too. 2. I installed Allaire JRun and everything is working fine with regards to running JSP pages. 3. I have read in the book, core JSP, that there are some JSP engines that doesn't use the classpath and uses it's own classpath, thus I added this on the Java Settings of the Default Server under Classpath. Prior to this, copied the org directory of the extracted files in mm.mysql-2.0.6.1.jar..jar to c:\progra~1\mm.sql in the Windows 98 directory structure. So my classpaths in JRun looks like this: {jrun.rootdir}/servers/lib {jrun.server.rootdir}/lib {jrun.rootdir}/../../mm.mysql Where all Jrun files are at c:\progra~1\allaire\jrun I got mm.mysql-2.0.6.1.jar..jar from SourceForge.com as my MySQL JDBC driver. 4. After doing this, I went to the JDBC Data Sources of the Default Server of JRun Application Management Console. And I added a new entry with the following: Name: MySQL Display Name: MySQL Driver: org.gjt.mm.mysql.Driver URL: jdbc:mysql://192.168.0.2:80/studiosusa?user=rootpassword=axnolnms Description: Studios USA database Pooling: Yes Timeout: 30 Minutes Interval: 30 Seconds Username: root Password: axnolnms Vendor Argument: blank, I placed nothing. Btw, before doing this, I already created a database named studiosusa and the username and password to my MySQL is root and axnolnms. 5. I started running the MySQL engine whose version is 3.22.21. 6. I clicked on the Test button on Allaire JRun's JDBC settings and that's when I got the error: The following error occurred while testing the data source connection Communication link failure: java.io.EOFException Now, where did I go wrong? And how do I run MySQL on the JSP engine Allaire JRun 3.0? I don't know if this is a MM.MySQL problem. Benj Arriola [EMAIL PROTECTED] +63 (917)-831-8345 Action Online Co. Ltd. www.action.com.ph +63 (2)-417-3629 +63 (2)-417-5107 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
a little problem
Hello, I started developing a small application that uses this great library (mysql) with its API (mysqlpp) and wxWindows. But, i couldn´t even compile the program because I received some errors like this: C:\SQLPP\INCLUDE\set3.hh(23) : error C2872: 'ostream' : ambiguous symbol C:\SQLPP\INCLUDE\vallist1.hh(56) : error C2872: 'ostream' : ambiguous symbol and more 100 similar messages... Does anyone have any suggestion for help me? thanks for all, Luiz Fernando (brazil) [EMAIL PROTECTED] ___ Yahoo! GeoCities Tenha seu lugar na Web. Construa hoje mesmo sua home page no Yahoo! GeoCities. É fácil e grátis! http://br.geocities.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
createing database
Hi! I have the mysql prompt. mysql I type : mysql CREATE DATABASE menagerie; I have the error message: ERROR 1044: Access denied for user: '@localhost' to database 'menagerie' ?? Franck - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Generate random, unique value...
I can see one problem with this, which is that in the case that you get two identical number in the second column their order will be strongly dependent on the values in the first column. I'm not sure what the problem with this is? The first (unique) column is independent of the second (random) column. If the random column has duplicate values, it just means that the corrosponding first column values will be adjacent in the sorted table. BTW: Does the MySQL sort algorithm preserve relative positions for rows with duplicate keys? I suggest that you generate this table using the normal procedure for randomizing the order of a list, namely that you store the numbers to N in an array, pick a random element, insert it into the second column of the table, move the last element of the array to the hole that was created in the array, and repeat until the array is empty. Sure, this will work also. It appears to be more complicated though, and I don't see any particular advantage. That doesn't mean there isn't one of course! Then when you insert values into your own table, just use a regular auto_increment id (after all, this id should carry no information, except that it identifies a row), and when you want the rows in the well-defined but randomized order, join with the two-column table and sort on the random number. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Optimizing query (2nd attempt)
David Wolf wrote: Not quite fixed.. When I run the query without limiting by time, it still fails to use the userid key. i.e. if I only select where users.username=testuser, I'd expect that users.username to return the users.id=2, and to search using the indexed log.userid=2 MySQL can only use one index on a table at a time. It also uses the columns in the order in which they are defined. ORDER MATTERS! The manual does not seem to cover this, but at least Informix will stop using an index when an inequality is hit. E.g.: if you have an index on (a, b, c ) and the query has WHERE a=5 AND b2 AND c=10, the only part of the index that will be used is (a, b). (Monty co, is this true with MySQL? Can you add something to the manual either way?) So assuming this is true in your where clause: WHERE log.logTime UNIX_TIMESTAMP(2000-10-26 23:00:00) AND users.username=testuser; If you have an index on ( logTime, username), since you have an inequality for lotTime in the query, username will NOT be used. However if you have the index on (username, logTime) --or even just the first 10 chars or so of username + logTime-- then both username AND logTime will be used in the index. You may want to try this to see if it makes any difference. And, of course, run myisamchk -a on the tables after you build indexes. b. - Original Message - From: David Wolf [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, October 28, 2001 4:26 PM Subject: Optimizing query (2nd attempt) I have a query as follows: SELECT log.entity, log.action, LEFT(users.username,10) AS username, LEFT(boards.title,15) AS Board, LEFT(topics.subject,22) as Subject, log.postid, log.extraid, LEFT(from_unixtime(log.logtime),19) AS time, log.ip FROM log LEFT JOIN users ON log.userid = users.id LEFT JOIN boards ON log.boardid=boards.id LEFT JOIN topics ON log.topicid = topics.id WHERE log.logTime UNIX_TIMESTAMP(2000-10-26 23:00:00) AND users.username=testuser; When I run an 'explain' on it, I get: +++---+-+-+-+--- --++ | table | type | possible_keys | key | key_len | ref | rows | Extra | +++---+-+-+-+--- --++ | log| ALL| time | NULL|NULL | NULL| 1192384 | where used | | users | eq_ref | PRIMARY | PRIMARY | 4 | log.userId | 1 | where used | | boards | eq_ref | PRIMARY | PRIMARY | 4 | log.boardId | 1 || | topics | eq_ref | PRIMARY | PRIMARY | 4 | log.topicId | 1 || +++---+-+-+-+--- --++ 4 rows in set (0.01 sec) Now.. If I exclude the 'users.username=testuser' and substitute it for the userid that I got in a previous query (i.e. userid=2) so that the query becomes: SELECT log.entity, log.action, LEFT(users.username,10) AS username, LEFT(boards.title,15) AS Board, LEFT(topics.subject,22) as Subject, log.postid, log.extraid, LEFT(from_unixtime(log.logtime),19) AS time, log.ip FROM log LEFT JOIN users ON log.userid = users.id LEFT JOIN boards ON log.boardid=boards.id LEFT JOIN topics ON log.topicid = topics.id WHERE log.logTime UNIX_TIMESTAMP(2000-10-26 23:00:00) AND log.userid=2; and run an explain, I get... +++---+-+-+-+--- ++ | table | type | possible_keys | key | key_len | ref | rows | Extra | +++---+-+-+-+--- ++ | log| ref| time,userid | userid | 4 | const | 27198 | where used | | users | eq_ref | PRIMARY | PRIMARY | 4 | log.userId | 1 || | boards | eq_ref | PRIMARY | PRIMARY | 4 | log.boardId | 1 || | topics | eq_ref | PRIMARY | PRIMARY | 4 | log.topicId | 1 || +++---+-+-+-+--- ++ 4 rows in set (0.00 sec) Big difference from 1.19million rows to 27198 rows... My question is this. How can I optimize the query with the left joins so that the optimizer will first grab the userid from the username and then use the userid index on log to return the results fast? Thanks in advance, David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To
Re: createing database
You need to setup your permisions in MySQL. Look in the MySQL reference material on how to setup users and permisions. M;) Hi! I have the mysql prompt. mysql I type : mysql CREATE DATABASE menagerie; I have the error message: ERROR 1044: Access denied for user: '@localhost' to database 'menagerie' ?? Franck - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Generate random, unique value...
George Eric R Contr AFSPC/CVYZ writes: I'm not sure what the problem with this is? The first (unique) column is independent of the second (random) column. If the random column has duplicate values, it just means that the corrosponding first column values will be adjacent in the sorted table. If you're really depending on the randomness, this would be a bad thing. I don't suppose what it was going to be used for was something as sensitive as an Ising model simulation, so it's probably not a big deal. And besides, the random munber generator used in MySQL is probably platform specific and not guaranteed to be good enough for something like that. BTW: Does the MySQL sort algorithm preserve relative positions for rows with duplicate keys? This is an interesting question, and I'd guess that it doesn't. Besides, the order of rows in a table isn't all that well-defined anyway. Still, some tests on this would be interesting to see. [SNIP] Sure, this will work also. It appears to be more complicated though, and I don't see any particular advantage. That doesn't mean there isn't one of course! Ah, how true. All of it. It is more complicated, and although I see some points, I don't they're very strong ones. :-o //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Beginner Question
- Original Message - From: jim barchuk [EMAIL PROTECTED] With luck you got the book at a reputable dealer who'll allow you to exchange it for Paul Dubois _MySQL_ New Riders ISBN0-7357-0921-1. Please spend a few extra $ and save yourself many many hours of confusion and frustration. Does anybody know if any MySQL books have been released that is as solid as the Paul Dubois book but on a more advanced level? My copy is pretty dog-eared and has been an invaluable resource to learning MySQL but would like to learn more advanced database design and use that the book only was able to cover briefly do to size. Thanks Joel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Optimizing query (2nd attempt)
Maybe I'm missing something here--I don't know of a way to create an index on TWO tables at once? Also, when I do: EXPLAIN SELECT log.entity, log.action, LEFT(users.username,10) AS username, LEFT(boards.title,15) AS Board, LEFT(topics.subject,22) as Subject, log.postid, log.extraid, LEFT(from_unixtime(log.logtime),19) AS time, log.ip FROM log LEFT JOIN users ON log.userid = users.id LEFT JOIN boards ON log.boardid=boards.id LEFT JOIN topics ON log.topicid = topics.id WHERE users.username=testuser; (users.username is indexed), I get the following: +++---+-+-+-+--- --++ | table | type | possible_keys | key | key_len | ref | rows | Extra | +++---+-+-+-+--- --++ | log| ALL| NULL | NULL|NULL | NULL| 1199187 || | users | eq_ref | PRIMARY | PRIMARY | 4 | log.userId | 1 | where used | | boards | eq_ref | PRIMARY | PRIMARY | 4 | log.boardId | 1 || | topics | eq_ref | PRIMARY | PRIMARY | 4 | log.topicId | 1 || +++---+-+-+-+--- --++ 4 rows in set (0.00 sec) It's just simply not using the index on users.. Did I miss something? David - Original Message - From: Bill Adams [EMAIL PROTECTED] To: David Wolf [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, October 29, 2001 9:21 AM Subject: Re: Optimizing query (2nd attempt) David Wolf wrote: Not quite fixed.. When I run the query without limiting by time, it still fails to use the userid key. i.e. if I only select where users.username=testuser, I'd expect that users.username to return the users.id=2, and to search using the indexed log.userid=2 MySQL can only use one index on a table at a time. It also uses the columns in the order in which they are defined. ORDER MATTERS! The manual does not seem to cover this, but at least Informix will stop using an index when an inequality is hit. E.g.: if you have an index on (a, b, c ) and the query has WHERE a=5 AND b2 AND c=10, the only part of the index that will be used is (a, b). (Monty co, is this true with MySQL? Can you add something to the manual either way?) So assuming this is true in your where clause: WHERE log.logTime UNIX_TIMESTAMP(2000-10-26 23:00:00) AND users.username=testuser; If you have an index on ( logTime, username), since you have an inequality for lotTime in the query, username will NOT be used. However if you have the index on (username, logTime) --or even just the first 10 chars or so of username + logTime-- then both username AND logTime will be used in the index. You may want to try this to see if it makes any difference. And, of course, run myisamchk -a on the tables after you build indexes. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Server configuration denies access to data source
I have a couple java servlets and WebObjects applications that fetch data from MySQL databases. I recently tried running them and received the following error: SQLException raised when connecting : java.sql.SQLException: Server configuration denies access to data source Since the last time I successfully ran these queries I have upgraded MacOS X 10.0.4 to 10.1 and upgraded WebObjects 5 to 5.3. I believe that I have not made any changes to MySQL privileges or databases since then. Can anyone give me some tips on where the problem might lay? Thank you, Craig Doran [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: Optimizing query (2nd attempt)
David Wolf wrote: Maybe I'm missing something here--I don't know of a way to create an index on TWO tables at once? Also, when I do: My bad. You cant. Since you are joining on the primary key, you want to add an index like: ALTER TABLE users ADD UNIQUE ( id, username(10)); Since you are using a left-join and a criteria on a table that is left-joined, it can be difficult to get a good index. b. (Sorry to spam you for a second time, David) EXPLAIN SELECT log.entity, log.action, LEFT(users.username,10) AS username, LEFT(boards.title,15) AS Board, LEFT(topics.subject,22) as Subject, log.postid, log.extraid, LEFT(from_unixtime(log.logtime),19) AS time, log.ip FROM log LEFT JOIN users ON log.userid = users.id LEFT JOIN boards ON log.boardid=boards.id LEFT JOIN topics ON log.topicid = topics.id WHERE users.username=testuser; (users.username is indexed), I get the following: ++ ---+---+-+-+-+--- --++ | table | type | possible_keys | key | key_len | ref | rows | Extra | ++ ---+---+-+-+-+--- --++ | log| ALL| NULL | NULL| NULL | NULL| 1199187 || | users | eq_ref | PRIMARY | PRIMARY | 4 | log.userId | 1 | where used | | boards | eq_ref | PRIMARY | PRIMARY | 4 | log.boardId | 1 || | topics | eq_ref | PRIMARY | PRIMARY | 4 | log.topicId | 1 || ++-- -+---+-+-+-+--- --++ 4 rows in set (0.00 sec) It's just simply not using the index on users.. Did I miss something? David -- -- Original Message - From: Bill Adams [EMAIL PROTECTED] To: David Wolf [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, October 29, 2001 9:21 AM Subject: Re: Optimizing query (2nd attempt) David Wolf wrote: Not quite fixed.. When I run the query without limiting by time, it still fails to use the userid key. i.e. if I only select where users.username=testuser, I'd expect that users.username to return the users.id=2, and to search using the indexed log.userid=2 MySQL can only use one index on a table at a time. It also uses the columns in the order in which they are defined. ORDER MATTERS! The manual does not seem to cover this, but at least Informix will stop using an index when an inequality is hit. E.g.: if you have an index on (a, b, c ) and the query has WHERE a=5 AND b2 AND c=10, the only part of the index that will be used is (a, b). (Monty co, is this true with MySQL? Can you add something to the manual either way?) So assuming this is true in your where clause: WHERE log.logTime UNIX_TIMESTAMP(2000-10-26 23:00:00) AND users.username=testuser; If you have an index on ( logTime, username), since you have an inequality for lotTime in the query, username will NOT be used. However if you have the index on (username, logTime) --or even just the first 10 chars or so of username + logTime-- then both username AND logTime will be used in the index. You may want to try this to see if it makes any difference. And, of course, run myisamchk -a on the tables after you build indexes. -- Bill Adams TriQuint Semiconductor - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: createing database
COLLINEAU Franck FTRD/DMI/TAM writes: I have read the manual. I don't understand because when i type: SELECT VERSION(), CURRENT_DATE; it's OK, the server answer to me!! I have the error message: ERROR 1044: Access denied for user: '@localhost' to database 'menagerie' If you've read the manual, why not do as it says? :-o Log in as the mysql root user, create the database and a user, and grant whatever privileges you need on that database to that user. Then use that user when connecting, instead of doing everything as root or ''. That you're able to SELECT VERSION() is not very strange. You're logged in as the anonymous (or nameless) user, and you don't need any privileges to SELECT without a FROM. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: createing database
Try http://www.mysql.com/doc/A/c/Access_denied.html it explains further what needs to be done. M;) I have read the manual. I don't understand because when i type: SELECT VERSION(), CURRENT_DATE; it's OK, the server answer to me!! Fanck -Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Envoyé : lundi 29 octobre 2001 17:23 À : [EMAIL PROTECTED] Objet : Re: createing database You need to setup your permisions in MySQL. Look in the MySQL reference material on how to setup users and permisions. M;) Hi! I have the mysql prompt. mysql I type : mysql CREATE DATABASE menagerie; I have the error message: ERROR 1044: Access denied for user: '@localhost' to database 'menagerie' ?? Franck - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
it shows columns when it should only show tables ( mysql client )
Description: this is how i find the bug. under the mysql console, i tried to drop a table, and i know that the mysql console do the same thing like bash some of the command ... TABTAB and the command autocomplets. OK .. let me show mysql drop table categor; categories categories.checked_out categories.ordering categoryid categories.categoryidcategories.checked_out_time categories.published categoryimage categories.categoryimage categories.editorcategories.section categoryname categories.categoryname categories.image_positioncategory the strange thing is in the end The table ... CREATE TABLE categories ( categoryid int(11) NOT NULL auto_increment, categoryname text NOT NULL, categoryimage varchar(50) default NULL, section varchar(20) NOT NULL default '', image_position varchar(20) default NULL, published int(11) NOT NULL default '0', checked_out int(11) NOT NULL default '0', checked_out_time time NOT NULL default '00:00:00', editor varchar(50) default NULL, ordering int(11) NOT NULL default '0', PRIMARY KEY (categoryid), UNIQUE KEY categoryid (categoryid), KEY categoryid_2 (categoryid) ) TYPE=MyISAM; How-To-Repeat: create database insert this table struct write on the console - drop table categorTABTAB Fix: dunno Submitter-Id: submitter ID Originator:Delfim Machado Organization: -·-·-·- Delfim Machado - [EMAIL PROTECTED] XPTO:: Portuguese OpenSource Comunity - http://www.xpto.org - \ The Fortune Game / - TeX is potentially the most significant invention in typesetting in this century. It introduces a standard language for computer typography, and in terms of importance could rank near the introduction of the Gutenberg press. -- Gordon Bell MySQL support: none Synopsis: mysql console - bad show tabtab Severity: non-critical Priority: low Category: mysql Class: change-request Release: mysql-3.23.43 (Source distribution) Server: /servers/mysql/bin/mysqladmin Ver 8.21 Distrib 3.23.43, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.43-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 58 min 16 sec Threads: 2 Questions: 4128 Slow queries: 0 Opens: 86 Flush tables: 1 Open tables: 20 Queries per second avg: 1.181 Environment: System: Linux amok 2.4.7-10custom #4 Wed Oct 24 15:40:57 WEST 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/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Oct 23 18:49 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 1282588 Sep 4 20:49 /lib/libc-2.2.4.so -rw-r--r--1 root root 27304836 Sep 4 20:34 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 4 20:34 /usr/lib/libc.so Configure command: ./configure --with-innodb --prefix=/servers/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
RE: JSP newbie needs to run MySQL-JDBC.
Are you sure MySQL is listening on port 80? The default port is 3306: jdbc:mysql://192.168.1.2:3306/database -Original Message- From: Benj Arriola [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 10:56 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: JSP newbie needs to run MySQL-JDBC. Hello Everyone, I need to run MySQL using JSP. I am a JSP newbie, actually a Java newbie too. I am more of a PHP/MySQL guy. I have successfully installed Allaire JRun 3.0 on Win98 using PWS. JRun has an application management console and I cannot seem to run MySQL. I am totally unfamiliar with how JRun, JDBC and MM.MySQL runs and the error message I get is: The following error occurred while testing the data source connection Communication link failure: java.io.EOFException I will enumerate everything I have done to see where I have gone wrong: 1. I am on a LAN and my IP address is 192.186.0.2. So on PWS, my localhost is basically 192.168.0.2. Everything is working fine with PWS and could use it with PHP and MySQL, thus I know MySQL is working fine too. 2. I installed Allaire JRun and everything is working fine with regards to running JSP pages. 3. I have read in the book, core JSP, that there are some JSP engines that doesn't use the classpath and uses it's own classpath, thus I added this on the Java Settings of the Default Server under Classpath. Prior to this, copied the org directory of the extracted files in mm.mysql-2.0.6.1.jar..jar to c:\progra~1\mm.sql in the Windows 98 directory structure. So my classpaths in JRun looks like this: {jrun.rootdir}/servers/lib {jrun.server.rootdir}/lib {jrun.rootdir}/../../mm.mysql Where all Jrun files are at c:\progra~1\allaire\jrun I got mm.mysql-2.0.6.1.jar..jar from SourceForge.com as my MySQL JDBC driver. 4. After doing this, I went to the JDBC Data Sources of the Default Server of JRun Application Management Console. And I added a new entry with the following: Name: MySQL Display Name: MySQL Driver: org.gjt.mm.mysql.Driver URL: jdbc:mysql://192.168.0.2:80/studiosusa?user=rootpassword=axnolnms Description: Studios USA database Pooling: Yes Timeout: 30 Minutes Interval: 30 Seconds Username: root Password: axnolnms Vendor Argument: blank, I placed nothing. Btw, before doing this, I already created a database named studiosusa and the username and password to my MySQL is root and axnolnms. 5. I started running the MySQL engine whose version is 3.22.21. 6. I clicked on the Test button on Allaire JRun's JDBC settings and that's when I got the error: The following error occurred while testing the data source connection Communication link failure: java.io.EOFException Now, where did I go wrong? And how do I run MySQL on the JSP engine Allaire JRun 3.0? I don't know if this is a MM.MySQL problem. Benj Arriola [EMAIL PROTECTED] +63 (917)-831-8345 Action Online Co. Ltd. www.action.com.ph +63 (2)-417-3629 +63 (2)-417-5107 - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Generate random, unique value...
I'm not sure what the problem with this is? The first (unique) column is independent of the second (random) column. If the random column has duplicate values, it just means that the corrosponding first column values will be adjacent in the sorted table. If you're really depending on the randomness, this would be a bad thing. I don't suppose what it was going to be used for was something as sensitive as an Ising model simulation, so it's probably not a big deal. And besides, the random munber generator used in MySQL is probably platform specific and not guaranteed to be good enough for something like that. The fact that the original poster is asking for unique random values is kind of an oxymoron to begin with. So the quality of the MySQL RNG is probably a non issue. BTW: Does the MySQL sort algorithm preserve relative positions for rows with duplicate keys? This is an interesting question, and I'd guess that it doesn't. Besides, the order of rows in a table isn't all that well-defined anyway. Still, some tests on this would be interesting to see. I just ran a quick test. I created a table with 2 integer columns, the first is auto_increment. I then dumped 100 records into it, populating the second column with random numbers in the range 0-100. This gives me lots of duplicate values for the second column. In inspecting the table after sorting by the second column, the relative order was always preserved. It's not conclusive, but it looks like relative order is preserved. You could also do ORDER BY RAND(), which I just discovered in the DuBois book when looking for the syntax of the RAND() function (which I haven't used before). - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: JSP newbie needs to run MySQL-JDBC.
Hello - You may wish to try something a little bit more fundamental if you are new to the Java thing. one good way to learn how everything works in JSP is to use a free Java Server, such as Tomcat, and build pages using Macromedia's ultradev software. There is an extension that installs JDBC-ODBC connectivity through ultradev. Follow the instructions for installing Tomcat, Ultradev, and the extension and then it is relatively easy to make a connection to a database with JSP code (in fact, Ultradev makes it similar to other models, such as ASP, CFML and PHP (via the phAKT extension). Once you create a connection, you can dissect the code and correspond the lines of code to how it makes a database connection (in fact, I use it to cross compare making a database connection through mySQL-PHP, mySQL-ASP, and mySQL-CFML as well)...they all essentially do the same fundamental tasks with very similar looking lines of code.. I realize you installed JRun, but from personal experience, its not that easy (its doable, but you might want to learn from something that you recognize, i.e from your PHP background) hope that helps... Edward Apostol developer, instructor - E-Commerce, New Media Wireless @ Ryerson University Toronto, ON Canada --- e-mail: [EMAIL PROTECTED] alt e-mail: [EMAIL PROTECTED] tel: (416) 820-3533 -Original Message- From: Benj Arriola [mailto:[EMAIL PROTECTED]] Sent: October 29, 2001 10:56 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: JSP newbie needs to run MySQL-JDBC. Hello Everyone, I need to run MySQL using JSP. I am a JSP newbie, actually a Java newbie too. I am more of a PHP/MySQL guy. I have successfully installed Allaire JRun 3.0 on Win98 using PWS. JRun has an application management console and I cannot seem to run MySQL. I am totally unfamiliar with how JRun, JDBC and MM.MySQL runs and the error message I get is: The following error occurred while testing the data source connection Communication link failure: java.io.EOFException I will enumerate everything I have done to see where I have gone wrong: 1. I am on a LAN and my IP address is 192.186.0.2. So on PWS, my localhost is basically 192.168.0.2. Everything is working fine with PWS and could use it with PHP and MySQL, thus I know MySQL is working fine too. 2. I installed Allaire JRun and everything is working fine with regards to running JSP pages. 3. I have read in the book, core JSP, that there are some JSP engines that doesn't use the classpath and uses it's own classpath, thus I added this on the Java Settings of the Default Server under Classpath. Prior to this, copied the org directory of the extracted files in mm.mysql-2.0.6.1.jar..jar to c:\progra~1\mm.sql in the Windows 98 directory structure. So my classpaths in JRun looks like this: {jrun.rootdir}/servers/lib {jrun.server.rootdir}/lib {jrun.rootdir}/../../mm.mysql Where all Jrun files are at c:\progra~1\allaire\jrun I got mm.mysql-2.0.6.1.jar..jar from SourceForge.com as my MySQL JDBC driver. 4. After doing this, I went to the JDBC Data Sources of the Default Server of JRun Application Management Console. And I added a new entry with the following: Name: MySQL Display Name: MySQL Driver: org.gjt.mm.mysql.Driver URL: jdbc:mysql://192.168.0.2:80/studiosusa?user=rootpassword=axnolnms Description: Studios USA database Pooling: Yes Timeout: 30 Minutes Interval: 30 Seconds Username: root Password: axnolnms Vendor Argument: blank, I placed nothing. Btw, before doing this, I already created a database named studiosusa and the username and password to my MySQL is root and axnolnms. 5. I started running the MySQL engine whose version is 3.22.21. 6. I clicked on the Test button on Allaire JRun's JDBC settings and that's when I got the error: The following error occurred while testing the data source connection Communication link failure: java.io.EOFException Now, where did I go wrong? And how do I run MySQL on the JSP engine Allaire JRun 3.0? I don't know if this is a MM.MySQL problem. Benj Arriola [EMAIL PROTECTED] +63 (917)-831-8345 Action Online Co. Ltd. www.action.com.ph +63 (2)-417-3629 +63 (2)-417-5107 - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Encode function
Luca Vertua [EMAIL PROTECTED] 8volante srl soluzioni_internet Via Cernaia 7 25034 - Orzinuovi - Bs Tel.: 030/9444003 Fax: 02/700430453 www.8volante.com - Original Message - From: [EMAIL PROTECTED] To: Luca Vertua [EMAIL PROTECTED] Sent: Monday, October 29, 2001 6:06 PM Subject: Re: Encode function Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Hi, all I want to know more about the encode function. Which kind of cryptography use the encode function. Should I consider it a secure encode? Any advice will be appreciated Luca Vertua [EMAIL PROTECTED] 8volante srl soluzioni_internet Via Cernaia 7 25034 - Orzinuovi - Bs Tel.: 030/9444003 Fax: 02/700430453 www.8volante.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
(errno: 40)
Hello, I've tried to use CREATE INDEX to create a fulltext index on an existing table and received the message: Can't create table './old/#sql-d55_ae7.frm' (errno: 140). I tried dropping the table and recreating it with the fulltext index in the new table description and got this message: Can't create table './old/oldfmp.frm' (errno: 140), however it would create the table without the fulltext index. I can't find an explanation of (errno: 40). I am guessing the problem is with either a temp directory or some file permission on our UNIX system? What do you think? Thank you, Eric Dean [EMAIL PROTECTED] Chief Curator, Office of Visual Materials School of Art and Art History, University of Iowa - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: (errno: 40)
On Mon, 29 Oct 2001 11:38:12 -0600, Eric Dean [EMAIL PROTECTED] wrote: Hello, I've tried to use CREATE INDEX to create a fulltext index on an existing table and received the message: Can't create table './old/#sql-d55_ae7.frm' (errno: 140). I tried dropping the table and recreating it with the fulltext index in the new table description and got this message: Can't create table './old/oldfmp.frm' (errno: 140), however it would create the table without the fulltext index. I can't find an explanation of (errno: 40). I am guessing the problem is with either a temp directory or some file permission on our UNIX system? What do you think? Thank you, perror 40 Error code 40: Too many levels of symbolic links Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem installing 3.23.43 (@HOSTNAME@ command not found)
Hello: I tried to set-up mysql 3.23.43 on my RedHat 7.1 server, following the binary installation instructions. Here is what I did: lynx ftp://mirror.sit.wisc.edu/mirrors/mysql/Downloads/MySQL-3.23/mysql-3.23.43-p c-linux-gnu-i686.tar.gz tar zxvf mysql-3.23.43-pc-linux-gnu-i686.tar.gz /usr/sbin/groupadd mysql /usr/sbin/useradd -g mysql mysql ln -s mysql-3.23.43-pc-linux-gnu-i686 mysql cd mysql scripts/mysql_install_db chown -R mysql /usr/local/mysql chgrp -R mysql /usr/local/mysql cp /usr/local/mysql/support-files/mysql.server /etc/rc.d/init.d/mysqld chmod +x /etc/rc.d/init.d/mysqld rm -f /etc/rc.d/rc3.d/S99mysqld rm -f /etc/rc.d/rc5.d/S99mysqld rm -f /etc/rc.d/rc0.d/K01mysqld rm -f /etc/rc.d/rc6.d/K01mysqld ln -s /etc/rc.d/init.d/mysqld /etc/rc.d/rc3.d/S99mysqld ln -s /etc/rc.d/init.d/mysqld /etc/rc.d/rc5.d/S99mysqld ln -s /etc/rc.d/init.d/mysqld /etc/rc.d/rc0.d/K01mysqld ln -s /etc/rc.d/init.d/mysqld /etc/rc.d/rc6.d/K01mysqld /etc/init.d/mysqld start I then got this error message: /etc/init.d/mysqld: @HOSTNAME@: command not found Starting mysqld daemon with databases from /usr/local/mysql/data 011029 12:23:02 mysqld ended Any ideas why this error is occurring? Thanks, Neil. -- Neil Aggarwal JAMM Consulting, Inc.(972) 612-6056, http://www.JAMMConsulting.com Custom Internet DevelopmentWebsites, Ecommerce, Java, databases - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 query optimiser
Hello, Just wanted to talk about the MySql Query Optimiser. After having performance problems with some queries, I arrived to thoses conclusions: - The order of joins with constants and column have no effect on the speed of the query - MySql make all joins between tables before extracting the required rows table t1 +---+---+ |num|let| +---+---+ | 1 | A | | 2 | A | | 3 | B | +---+---+ table t2 +---+---+ |num|let| +---+---+ | 1 | A | | 2 | B | +---+---+ If I do something like : select t1.num from t1,t2 where t2.let='A' and t1.let=t2.let MySql seem's make in memory a table like : +--+--+--+--+ |t1.num|t1.let|t2.num|t2.let| +--+--+--+--+ | 1 | A | 1 | A | | 2 | A | 1 | A | | 3 | B | 2 | B | +--+--+--+--+ and then extract the first and the second lines while it could have first extract the first line of the table t2 and then make all the required joins. That would have done in memory : +--+--+--+--+ |t1.num|t1.let|t2.num|t2.let| +--+--+--+--+ | 1 | A | 1 | A | | 2 | A | 1 | A | +--+--+--+--+ I don't remeber cause I've not played with Oracle from several month, but I think Oracle was doing like this. Could you tell me if such an Optimiser is planned with MySql 4 ?? Maybe such an Optimiser is useless ? (when we'll have sub-queries we'll be able to restrict the number of joins in memory) ps: MySql 4.0.0 Alpha work fine on Amiga ;) -- Best regards, SixK // \\ //Amiga spirit will never die \\/ mailto:[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
Installation from Source
Hi! Deepanshu == Deepanshu Shukla [EMAIL PROTECTED] writes: Deepanshu Hi!, Deepanshu I tried to install from mysql-3.23.43.tar.gz. Deepanshu i configured using ./configure Deepanshu --prefix=/usr/local/mysql Deepanshu --localstatedir=/usr/local/mysql/data Deepanshu and then make and make install Deepanshu changed all the permissions. Deepanshu Then on starting safe_mysqld i get this error in .err Deepanshu file Deepanshu --- Deepanshu 011022 02:07:09 mysqld started Deepanshu ^G/usr/local/mysql/libexec/mysqld: File Deepanshu './it-106-bin.1' not found (Errcode: 13) cut Unix error 13 means 'Permission denied' (You can check this with the perror utility). Fix: Restart mysqld as root or ensure that you have full right permissions to the MySQL data directory. Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PHP and MySQL 4.0.0
Hi! Sebastian == Sebastian Bergmann [EMAIL PROTECTED] writes: Sebastian Michael Widenius wrote: The symbol 'mysql_module_entry' doesn't come from the MySQL library, so this is a PHP problem. Sebastian Okay. Note that you can use MySQL 4.0 with the old MySQL 3.23 library without any problems. Sebastian Yes, it works fine if I use the libmysql that is bundled with PHP. Only Sebastian when I ./configure --with-mysql=/usr/local/mysql and link PHP against Sebastian the MySQL 4.0.0 library this problem occurs. The problem could be that some structs has changed between MySQL 3.23 and 4.0; To get 4.0 to works, you need to recompile all object files that uses the libmysql library to use the 4.0 include headers. Could you try to recompile the mysql-php module with the 4.0 header files and check if this helps ? Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: DATA DIRECTORY bug on Win32
Hi! Mike == Mike Blazer [EMAIL PROTECTED] writes: Mike Miguel Angel SolÕrzano wrote: At 14:24 24/10/2001 +0400, Mike Blazer wrote: Hi Mike, Thanks for the bug report. The explanation why the insert command doesn't works on Win32, is because the link file pointing for the DATA DIRECTORY wasn't created in the create table command, like the Unix version does. The Win32 OSs don't have a native symbolic link feature and the today symbolic link support on Win32 is made creating a plain text file with the extension *.sym on \data directory and contains the path of the whole database. Then DATA DIRECTORY feature should be handled in a different way on Win32 than is made on Unix. Mike Thanks, Miguel, I see - but I don't believe that nothing could be done Mike for Win32. There are explorer shortcut files with the set of Win32 API Mike calls to read/write them - so, I guess not only directories(databases) Mike but .MYD and .MYI files could be linked separately. Mike OK, in fact you could use table_name.MYD.sym and table_name.MYI.sym in Mike the same way you are using database.sym now - there is a Change/Notify Mike mechanism that avoids the need to read that .sym files more then once if Mike they are not changed. But ALTER TABLE and OPTIMIZE TABLE should not Mike destroy this fake symlink. Mike Well, I'm sure there are some better ways too - it's a pity that it such Mike a useful feature fails on Win32. I have now changed MySQL 4.0.1 to ignore any DATA DIRECTORY directives, until we have come up with an acceptable workaround for windows. For the moment, I can't come up with any better solution than to also start supporting .sym files on windows; We plan to in the near future generalize the file handling interface in MySQL; When we do this, we will take this into consideration! Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with MySQL 3.23.37-3.23.43 Binary Distributions...
I have been using MySQL for approximately 6 months now on Solaris 2.6/2.7 and have never had a problem installing from source and compiling, but have never been successful in installing a binary distribution. In particular, after untarring the files using (GNUtar), after changing permissions, etc. I try to run scripts/mysql_install_db and have gotten an error similar to the following: ld.so.1: ./bin/my_print_defaults: fatal: libcrypt_i.so.1: open failed: Any ideas? Thanks. Brad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 auto_increment wrap?
Chris Bolt wrote: Only with ISAM tables which reuse deleted auto_increment numbers. MyISAM tables will give you Duplicate entry errors if you hit the maximum. I hadn't realized this and tested it out in MySQL 3.23.43, but in my tests ISAM tables also returned a Duplicate entry error when I hit the max. Was this feature eliminated? -- David Felio Software Developer [EMAIL PROTECTED] Information Network of Arkansas http://www.AccessArkansas.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
Problem mysql installation
Hi all; i have problem with mysql -3.23.42 installation on my freebsd 4.3-RELEASE, when I execute a make i get an error make: no target to make. Thanks and have a great day! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
will someone kindly remove me from this list.
Ive tried mailing: mailto:mysql-unsubscribe-%4B%2E%48%61%75%67%68%74%6F%6E%3D%62%6C%75%65%79%6F [EMAIL PROTECTED] x 8 [EMAIL PROTECTED] x 5 [EMAIL PROTECTED] x 3 the website getting rather FUCKED OFF WITH TRYING. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Anyone worked with the new 4.0 on RH6.2?
Patrick Nelson wrote: - Having problems getting the server started. First mysql_install_db reported that resolveip can't resolve my servers host name (of cowa) bla bla bla but this means I only have to use ip addresses in my grant stuff. Fine but the problem is that mysql_safe --user=mysql starts then stops... that's about it. No fanfare... not entries in the cowa.log file (except of course the start and stop lines) I ran resolveip cowa and it core dumps. I checked /var/lib/mysql and wow the mysql and test dirs are empty. Ok seeing the documentation says safe_mysqld rather than the actual mysqld_safe maybe, I just need to be direct to the correct process. Please help! - I dropped back to the 3.23.43 version by uninstalling 4.0 alpha and then installing 3.23.43 server, client, shared. After the rpm process was done... The server was up and working. Guess I'll wait for later release of 4.x! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Query in PHP
Heh, yeah that sounds rookie ;) Have you ever done work in Perl? PHP is a lot like Perl in many aspects (and nothing like it in many others). Heh. Check out http://www.zend.com/ for some other tutorials, if you can find 'em. http://www.phpbuilder.com/ has some gooduns, too. Mike Todd Williamsen wrote: Yes, I think HTML, mySQL and PHP is a marriage made in heaven but... Online docs is like reading stereo instructions in a foreign language most of the time. I tried the webmonkey.com tutorial and it was ok.. Funny thing is that the script they used, I couldn't get to work... Go figure... Just my luck! Granted I am so new to PHP I think I just eclipsed the 48 hour mark... So am I still a rookie? Lol!! Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: Mike [mailto:[EMAIL PROTECTED]] Sent: Friday, October 26, 2001 9:33 PM To: Woolsey, Fred Cc: '[EMAIL PROTECTED] ' Subject: Re: SELECT Query in PHP I think the worst part about the books is that with things like PHP, Apache and MySQL, by the time you find (i.e. from browsing at the local library) and sit down to learn, it's talking about MySQL 3.22, Apache 1.2, and PHP3. Nothing beats the online documentation.. amen to that. :) You might try some sites like webmonkey.com for php tutorials. I think that's where I went when I decided to learn php about.. oh about a year ago. Mike Woolsey, Fred wrote: Funny... I find the PHP, HTML and MySQL combo to be a marriage made in heaven. Also, I have not yet seen a book (and I've bought a few of them) that beats the PHP and MySQL documentation available for free on the web. Follow the URLs in the other e-mails and you will find the truth... OK, maybe I exaggerate, but at least you'll find the info you need. Cheers (and remember, wer immer streibend sich bemueht, den koennen wir erloesen.- apologies to Goethe) Fred Woolsey -Original Message- From: Todd Williamsen To: [EMAIL PROTECTED] Sent: 10/26/2001 8:25 PM Subject: SELECT Query in PHP I am a newbie at this and I cannot find the damn answer to it! I want to display the table in an html format with PHP but I cannot get it to work! With MS SQL Server it was sooo easy! With PHP and mySQL it's a pain in the butt! I cannot find any documentation on this and I order 3 books on this stuff, but they won't be here till at least Monday. HELP! Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Problem installing 3.23.43 (@HOSTNAME@ command not found)
I had to replace @HOSTNAME@ with HOSTNAME in the file mysql.server on the line, pid_file=$datadir/HOSTNAME.pid. @HOSTNAME@ wasn't a valid variable. -Original Message- From: Neil Aggarwal [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 10:29 AM To: Mysql list Subject: Problem installing 3.23.43 (@HOSTNAME@ command not found) Hello: I tried to set-up mysql 3.23.43 on my RedHat 7.1 server, following the binary installation instructions. Here is what I did: lynx ftp://mirror.sit.wisc.edu/mirrors/mysql/Downloads/MySQL-3.23/mysql-3.23.43-p c-linux-gnu-i686.tar.gz tar zxvf mysql-3.23.43-pc-linux-gnu-i686.tar.gz /usr/sbin/groupadd mysql /usr/sbin/useradd -g mysql mysql ln -s mysql-3.23.43-pc-linux-gnu-i686 mysql cd mysql scripts/mysql_install_db chown -R mysql /usr/local/mysql chgrp -R mysql /usr/local/mysql cp /usr/local/mysql/support-files/mysql.server /etc/rc.d/init.d/mysqld chmod +x /etc/rc.d/init.d/mysqld rm -f /etc/rc.d/rc3.d/S99mysqld rm -f /etc/rc.d/rc5.d/S99mysqld rm -f /etc/rc.d/rc0.d/K01mysqld rm -f /etc/rc.d/rc6.d/K01mysqld ln -s /etc/rc.d/init.d/mysqld /etc/rc.d/rc3.d/S99mysqld ln -s /etc/rc.d/init.d/mysqld /etc/rc.d/rc5.d/S99mysqld ln -s /etc/rc.d/init.d/mysqld /etc/rc.d/rc0.d/K01mysqld ln -s /etc/rc.d/init.d/mysqld /etc/rc.d/rc6.d/K01mysqld /etc/init.d/mysqld start I then got this error message: /etc/init.d/mysqld: @HOSTNAME@: command not found Starting mysqld daemon with databases from /usr/local/mysql/data 011029 12:23:02 mysqld ended Any ideas why this error is occurring? Thanks, Neil. -- Neil Aggarwal JAMM Consulting, Inc.(972) 612-6056, http://www.JAMMConsulting.com Custom Internet DevelopmentWebsites, Ecommerce, Java, databases - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 auto_increment wrap?
Only with ISAM tables which reuse deleted auto_increment numbers. MyISAM tables will give you Duplicate entry errors if you hit the maximum. I hadn't realized this and tested it out in MySQL 3.23.43, but in my tests ISAM tables also returned a Duplicate entry error when I hit the max. Was this feature eliminated? It must have been. I get the same behaviour, but the manual mentions that ISAM tables used to reuse numbers: ...This will make AUTO_INCREMENT columns faster (at least 10 %) and old numbers will not be reused as with the old ISAM. Note that when an AUTO_INCREMENT is defined on the end of a multi-part-key the old behavior is still present. from http://www.mysql.com/doc/M/y/MyISAM.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 auto_increment wrap?
Chris Bolt wrote: Only with ISAM tables which reuse deleted auto_increment numbers. MyISAM tables will give you Duplicate entry errors if you hit the maximum. I hadn't realized this and tested it out in MySQL 3.23.43, but in my tests ISAM tables also returned a Duplicate entry error when I hit the max. Was this feature eliminated? I missed the start of this discussion, but maybe the following explains what's going on... http://www.bitbybit.dk/mysqlfaq/faq.html#ch6_5_0 / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Generate random, unique value...
You could also do ORDER BY RAND(), which I just discovered in the DuBois book when looking for the syntax of the RAND() function (which I haven't used before). For a different take on retrieving random records, check out http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_21_0 / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Newsgroups
The information in this email is great, but the volume of mysql emails mixed in with my other emails is forcing me to unsubscribe! (yes, I could filter, but that still fills up my email client.) Could we have newsgroups instead? That would provide history, conversation threads, etc. We could go search it to answer questions without generating new email. We could have subgroups for major topics, such as selects, myODBC, etc. Also, when you reply to a newsgroup item, you can usually send an email copy to the person you are replying to, so you would only get email as an answer to your specific post! Personally I would find this MUCH easier to manage and would be as helpful or more so. Matt Sellers - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
busy site w/ high cpu usage on mysql
Hello I have a very busy site (www site) w/ a lot of hits my site is very heavily integrated w/ mysql and when i do top it shows me like over 80% of cpu even though i have dual p3 850mhz w/ 1.5 gig of ram any ideas what to do about it so it'll drop down? thank you in advance - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Newsgroups
I agree, the volume of email is too huge and it makes communication on certain topics (like this one for example) cumbersome. Steve - Original Message - From: Matt Sellers [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, October 29, 2001 3:22 PM Subject: Newsgroups The information in this email is great, but the volume of mysql emails mixed in with my other emails is forcing me to unsubscribe! (yes, I could filter, but that still fills up my email client.) Could we have newsgroups instead? That would provide history, conversation threads, etc. We could go search it to answer questions without generating new email. We could have subgroups for major topics, such as selects, myODBC, etc. Also, when you reply to a newsgroup item, you can usually send an email copy to the person you are replying to, so you would only get email as an answer to your specific post! Personally I would find this MUCH easier to manage and would be as helpful or more so. Matt Sellers - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: busy site w/ high cpu usage on mysql
alexus wrote: Hello I have a very busy site (www site) w/ a lot of hits my site is very heavily integrated w/ mysql and when i do top it shows me like over 80% of cpu even though i have dual p3 850mhz w/ 1.5 gig of ram any ideas what to do about it so it'll drop down? Have you inspected your process list e.g. mysqladmin processlist? Do you log slow queries? Have you explored indexes that you can add for any slow/common queries? E.g. use EXPLAIN SELECT on common queries. Have you done a 'myisamchk -a'? If you are suffering from table locking issues, perhaps you should convert to Innodb. 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
Server configuration denies access to data source
I have a couple java servlets and WebObjects applications that fetch data from MySQL databases. I recently tried running them and received the following error: SQLException raised when connecting : java.sql.SQLException: Server configuration denies access to data source From a command line, I can access the databases and data just fine. Since the last time I successfully ran these queries I have upgraded MacOS X 10.0.4 to 10.1 and upgraded WebObjects 5 to 5.3. I believe that I have not made any changes to MySQL privileges or databases since then. Can anyone give me some tips on where the problem might lay? OS: Mac OS X 10.1 MySQL: 3.23.40 JDBC: mm.mysql.jar (version 1.3?) Apache: 1.3.20 Thank you, Craig Doran [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: Newsgroups
On Mon, Oct 29, 2001 at 01:22:55PM -0700, Matt Sellers wrote: The information in this email is great, but the volume of mysql emails mixed in with my other emails is forcing me to unsubscribe! (yes, I could filter, but that still fills up my email client.) You think this list is busy? Try the linux-kernel mailing list! Anyway... Could we have newsgroups instead? That would provide history, conversation threads, etc. We could go search it to answer questions without generating new email. We could have subgroups for major topics, such as selects, myODBC, etc. Also, when you reply to a newsgroup item, you can usually send an email copy to the person you are replying to, so you would only get email as an answer to your specific post! Do any of the public web archives of the list suit your needs? Have you seen them? Would you want a uni-directional news gateway or bi-directional? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 53 days, processed 1,199,059,668 queries (258/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 3.23.43 fails merge test ON make test of src.
Hi! R == R Talbot [EMAIL PROTECTED] writes: cut R Below is My bug report... R Mysql 3.23.40 is runjning after the compile but, R after a compile with errors 3.23.42 or .43 won't run the R server starts and fails so I guess we should concentrate on 3.23.40 R gcc version egcs-2.91.66 19990314 (egcs-1.1.2 release) cut R Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' cut R Configure command: ./configure --prefix=/usr/local/mysql The above configure command will not work reliable because of bugs in the egcc thread/exception handling. The following configuure line should have a big likehood to work: rm config.cache CC=gcc CFLAGS=-O3 CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti ./configure --prefix=/usr/local/mysql --with-low-memory Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql.sock ???
Riccardi Moreno ([EMAIL PROTECTED]) writes: Hi all, I've installed mysql 3.23.42 on Freebsd system but when i launch mysql i said me can't connect to localhost /tmp/mysql.sock not found. How can i repair this error? First, you can refrain from posting the same question twice. Second, you can RTFM before posting - specifically, http://www.mysql.com/doc/P/r/Problems_with_mysql.sock.html You can also look at Carsten's *excellent* FAQ - specifically, http://www.bitbybit.dk/mysqlfaq/faq.html#ch10_1_0 -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Delete performance
Does anyone know how to speed the performance of deletes on a large table? I have a large table w/ approx. 180,000,000 rows, with the following table structure: mysql desc TABLEA; |+--+---+--+-+--+---+| Field | Type | Null | Key | Default | Extra |+--+---+--+-+--+---+| ID | int(10) unsigned | | | 0 | || CID | int(10) unsigned | | MUL | 0 | || GNUMBER | int(10) unsigned | | | 0 | || VAL | int(10) unsigned | | | 0 | || DENUM | enum('UP','DOWN') | | | UP | || TIMESTAMP | int(10) | | MUL | 0| || |+--+---+--+-+--+---+| It takes approximately 45 seconds to delete an hour's worth of data( 90323 rows) from the table, which tends to be a performance problem since it's a table with a fair amount of contention. Platform: x86 OS:RH Linux 2.4.6 MySQL V: 3.23.42-max DB File Type: InnoDB Memory:1 GB HD:130GB SCSI Thanks, Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Security
Hello All, I'm fairly new to mySQL but not to SQL or databases in general. I have recently installed mySQL on an NT box without much difficulty. My question is about security. What are the steps to ensure our data and client data is not accessible to the hacker public? I'm not a network person so please try to keep the responses fairly simple. Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql.sock ???
Or you could add path-to-unix-socket= somewhere else than /tmp Sometimes your machine will delete things in the /tmp directory without you knowing. I put it in /var/lib/mysql (linux). Ed Carp wrote: Riccardi Moreno ([EMAIL PROTECTED]) writes: Hi all, I've installed mysql 3.23.42 on Freebsd system but when i launch mysql i said me can't connect to localhost /tmp/mysql.sock not found. How can i repair this error? First, you can refrain from posting the same question twice. Second, you can RTFM before posting - specifically, http://www.mysql.com/doc/P/r/Problems_with_mysql.sock.html You can also look at Carsten's *excellent* FAQ - specifically, http://www.bitbybit.dk/mysqlfaq/faq.html#ch10_1_0 -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Newsgroups
PMFJI, Do any of the public web archives of the list suit your needs? Have you seen them? It's fine for archived messages but too hard to find new messages, say within the last 7 days. Staying current with MySQL is a lot harder with the mailing list because you have to keep up with the mail each day. A newsgroup is much better because you know the messages can be browsed whenever you want. It puts the messages in a tree and makes viewing pertinent threads a breeze, especially with an offline newsgroup reader like Agent. You see the complete thread without getting inundated with 60-90 messages every day. The newgroup can still be archived to the public web archive. Would you want a uni-directional news gateway or bi-directional? Bi-directional. Where do I sign up? g Brent - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Newsgroups
In the next version of my mysqldeveloper site (which I hope to release here pretty quick) it will support a feature to show you which messages are new and which you've already read. Hope this helps ;-) BD wrote: PMFJI, Do any of the public web archives of the list suit your needs? Have you seen them? It's fine for archived messages but too hard to find new messages, say within the last 7 days. Staying current with MySQL is a lot harder with the mailing list because you have to keep up with the mail each day. A newsgroup is much better because you know the messages can be browsed whenever you want. It puts the messages in a tree and makes viewing pertinent threads a breeze, especially with an offline newsgroup reader like Agent. You see the complete thread without getting inundated with 60-90 messages every day. The newgroup can still be archived to the public web archive. Would you want a uni-directional news gateway or bi-directional? Bi-directional. Where do I sign up? g Brent - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
configure/documentation error for HPUX 10.20?
Description: I'm running HPUX 10.20 on a 9000/782. I configured according to section 2.6.6.2, HP-UX Version 10.20 Notes (see below). make test warns that setrlimit fails, then fails the join test, presumably because it requires more than 60 files. (Full output below) It appears that getrlimit/setrlimit, called by mysqld, produce garbage, at least on my system, when mysqld is built with largefile support. Here's the 'make test' output: $make test cd mysql-test ; ./mysql-test-run Installing Test Databases Removing Stale Files Installing Master Databases 011030 1:43:53 Warning: setrlimit couldn't increase number of open files to more than 60 011030 1:43:53 Warning: Changed limits: max_connections: 50 table_cache: 64 011030 1:43:53 ../sql/mysqld: Shutdown Complete Installing Slave Databases 011030 1:43:53 Warning: setrlimit couldn't increase number of open files to more than 60 011030 1:43:53 Warning: Changed limits: max_connections: 50 table_cache: 64 011030 1:43:53 ../sql/mysqld: Shutdown Complete Starting MySQL daemon Loading Standard Test Databases Starting Tests TEST USER SYSTEM ELAPSEDRESULT alias 0.0 0.0 0.1 [ pass ] alter_table0.0 0.0 0.9 [ pass ] analyse0.0 0.0 0.1 [ pass ] auto_increment 0.0 0.0 0.3 [ pass ] backup 0.0 0.0 0.1 [ pass ] bdb-crash 0.0 0.0 0.0 [ pass ] bdb [ skipped ] bench_count_distinct 0.0 0.0 0.2 [ pass ] bigint 0.0 0.0 0.0 [ pass ] binary 0.0 0.0 0.0 [ pass ] case 0.0 0.0 0.0 [ pass ] check 0.9 0.5 13.5 [ pass ] comments 0.0 0.0 0.0 [ pass ] compare0.0 0.0 0.0 [ pass ] count_distinct 0.0 0.0 0.1 [ pass ] create 0.0 0.0 0.1 [ pass ] delayed0.0 0.0 3.0 [ pass ] delete 0.0 0.0 0.0 [ pass ] dirty-close0.0 0.0 0.0 [ pass ] distinct 0.0 0.0 0.4 [ pass ] drop 0.0 0.0 0.1 [ pass ] empty_table0.0 0.0 0.0 [ pass ] err01 0.0 0.0 0.0 [ pass ] explain0.0 0.0 0.0 [ pass ] flush 0.0 0.0 0.3 [ pass ] flush_table0.0 0.0 0.0 [ pass ] foreign_key0.0 0.0 0.1 [ pass ] fulltext 0.0 0.0 0.1 [ pass ] fulltext_cache 0.0 0.0 0.0 [ pass ] fulltext_left_join 0.0 0.0 0.0 [ pass ] fulltext_multi 0.0 0.0 0.0 [ pass ] fulltext_order_by 0.0 0.0 0.0 [ pass ] fulltext_update0.0 0.0 0.0 [ pass ] func_crypt 0.0 0.0 0.0 [ pass ] func_date_add 0.0 0.0 0.0 [ pass ] func_equal 0.0 0.0 0.0 [ pass ] func_group 0.0 0.0 0.1 [ pass ] func_in0.0 0.0 0.0 [ pass ] func_like 0.0 0.0 0.0 [ pass ] func_math 0.0 0.0 0.0 [ pass ] func_misc 0.0 0.0 0.0 [ pass ] func_op0.0 0.0 0.0 [ pass ] func_regexp0.0 0.0 0.0 [ pass ] func_set 0.0 0.0 0.0 [ pass ] func_str 0.0 0.0 0.9 [ pass ] func_system0.0 0.0 0.0 [ pass ] func_test 0.0 0.0 0.0 [ pass ] func_time 0.0 0.0 0.1 [ pass ] func_timestamp 0.0 0.0 0.0 [ pass ] gemini [ skipped ] group_by 0.0 0.0 0.2 [ pass ] having 0.0 0.0 0.0 [ pass ] heap 0.0 0.0 0.4 [ pass ] identity 0.0 0.0 0.0 [ pass ] innodb [ skipped ]
myODBC error list?
Any way of getting a native error,sqlstate,error number list ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 performance
On Mon, Oct 29, 2001 at 05:49:57PM -0500, C. Williams wrote: Does anyone know how to speed the performance of deletes on a large table? I have a large table w/ approx. 180,000,000 rows, with the following table structure: [snip] It takes approximately 45 seconds to delete an hour's worth of data( 90323 rows) from the table, which tends to be a performance problem since it's a table with a fair amount of contention. Platform: x86 OS:RH Linux 2.4.6 MySQL V: 3.23.42-max DB File Type: InnoDB Memory:1 GB HD:130GB SCSI If you're using InnoDB, where's the contention? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 53 days, processed 1,200,141,477 queries (258/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: improve the speed of update, insert, delete and select queries through mySQL
- Original Message - From: Jason Parker To: [EMAIL PROTECTED] Sent: Tuesday, October 30, 2001 9:11 AM Subject: improve the speed of update, insert, delete and select queries through mySQL Anyone, Does anyone know ways to improve the speed of update, insert, delete and select queries through mySQL this info would be greatly appreciated.. regards, Jason Parker Draughtsman Technical Assistant Powerdown Australia Pty Ltd [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: improve the speed of update, insert, delete and select queriesthrough mySQL
indexes. On Tue, 30 Oct 2001, Jason Parker wrote: - Original Message - From: Jason Parker To: [EMAIL PROTECTED] Sent: Tuesday, October 30, 2001 9:11 AM Subject: improve the speed of update, insert, delete and select queries through mySQL Anyone, Does anyone know ways to improve the speed of update, insert, delete and select queries through mySQL this info would be greatly appreciated.. regards, Jason Parker Draughtsman Technical Assistant Powerdown Australia Pty Ltd [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
BUG: Update Log does not re-open file when filename specified
Description: To make myself clear, I am talking about the binary update log file. When specifing a fixed filename in my.cnf and running the flush-logs command (via mysqladmin) MySQL does not close the file and open the new file when run by a logrotate script. This does work correctly if no log filename is specified. How-To-Repeat: THIS WORKS File: my.cnf ... # Uncomment the following if you want to log updates log-bin ... File: log-files rotate script ... /home/mysql/data/raq804-bin.001 { create 600 mysqldb mysqldb notifempty daily rotate 14 missingok nocompress postrotate # just if mysqld is really running # if test -n `ps acx|grep mysqld`; then /usr/local/mysql/bin/mysqladmin flush-logs # fi endscript } ... THIS DOESN'T. File: my.cnf ... # Uncomment the following if you want to log updates log-bin=update.log ... File: log-files rotate script ... /home/mysql/data/update.log { create 600 mysqldb mysqldb notifempty daily rotate 14 missingok nocompress postrotate # just if mysqld is really running # if test -n `ps acx|grep mysqld`; then /usr/local/mysql/bin/mysqladmin flush-logs # fi endscript } ... The results of the above can be shown below. During the running of the logrotate script a PHP-based script is individually adding 100,000 rows using single INSERT statements [root@raq804 data]# l -rt total 3328 drwxr-x--- 2 mysqldb mysqldb 1024 May 10 11:41 test drwxr-x--- 2 mysqldb mysqldb 1024 Jul 31 01:41 mysql drwxrwxr-x 3 root root 1024 Oct 15 19:27 .. drwx-- 2 mysqldb mysqldb 1024 Oct 15 19:43 filler -rw-rw-r-- 1 root mysqldb 1512 Oct 29 23:56 log-files -rw-rw 1 mysqldb mysqldb13 Oct 29 23:58 update.index -rw-rw 1 mysqldb mysqldb 5 Oct 29 23:58 raq804.uk2net.com.pid -rw-rw-r-- 1 mysqldb mysqldb83 Oct 29 23:58 raq804.uk2net.com.err drwxr-x--- 6 mysqldb mysqldb 1024 Oct 29 23:58 . -rw-rw 1 mysqldb mysqldb 3382049 Oct 29 23:59 update.log [root@raq804 data]# logrotate -f log-files [root@raq804 data]# l -rt total 5857 drwxr-x--- 2 mysqldb mysqldb 1024 May 10 11:41 test drwxr-x--- 2 mysqldb mysqldb 1024 Jul 31 01:41 mysql drwxrwxr-x 3 root root 1024 Oct 15 19:27 .. drwx-- 2 mysqldb mysqldb 1024 Oct 15 19:43 filler -rw-rw-r-- 1 root mysqldb 1512 Oct 29 23:56 log-files -rw-rw 1 mysqldb mysqldb13 Oct 29 23:58 update.index -rw-rw 1 mysqldb mysqldb 5 Oct 29 23:58 raq804.uk2net.com.pid -rw-rw-r-- 1 mysqldb mysqldb83 Oct 29 23:58 raq804.uk2net.com.err -rw--- 1 mysqldb mysqldb 0 Oct 29 23:59 update.log drwxr-x--- 6 mysqldb mysqldb 1024 Oct 29 23:59 . -rw-rw 1 mysqldb mysqldb 5961241 Oct 29 23:59 update.log.1 [root@raq804 data]# l -rt total 7928 drwxr-x--- 2 mysqldb mysqldb 1024 May 10 11:41 test drwxr-x--- 2 mysqldb mysqldb 1024 Jul 31 01:41 mysql drwxrwxr-x 3 root root 1024 Oct 15 19:27 .. drwx-- 2 mysqldb mysqldb 1024 Oct 15 19:43 filler -rw-rw-r-- 1 root mysqldb 1512 Oct 29 23:56 log-files -rw-rw 1 mysqldb mysqldb13 Oct 29 23:58 update.index -rw-rw 1 mysqldb mysqldb 5 Oct 29 23:58 raq804.uk2net.com.pid -rw-rw-r-- 1 mysqldb mysqldb83 Oct 29 23:58 raq804.uk2net.com.err -rw--- 1 mysqldb mysqldb 0 Oct 29 23:59 update.log drwxr-x--- 6 mysqldb mysqldb 1024 Oct 29 23:59 . -rw-rw 1 mysqldb mysqldb 8074121 Oct 29 23:59 update.log.1 There is no error messages in 'raq804.uk2net.com.err' I hope thats enough information required. If you have any questions, pls send me a mail Fix: I have run the same tests using the standard query log and this works successfully when you specify a filename (i.e. in my.cnf the line: log=query.log). This problem seems to only affect the binary update log. Submitter-Id: submitter ID Originator:Administrator Organization: organization of PR author (multiple lines) MySQL support: [none | licence | email support | extended email support ] Synopsis: synopsis of the problem (one line) Severity: [ non-critical | serious | critical ] (one line) Priority: [ low | medium | high ] (one line) Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-3.23.38 (Official MySQL binary) Environment: machine, os, target, libraries (multiple lines) System: Linux raq804.uk2net.com 2.2.14C10 #3 Wed Jun 21 15:05:10 JST 2000 i586 unknown Architecture: i586 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
Please...... mysql error! please reply~ here is South Korea.
I'am not english speak. sorry~ ^^;; [error] # ./bin/safe_mysqld --user=mysql Starting mysqld daemon with databases from /usr/local/mysql/data 011030 09:04:16 mysqld ended # [./mysql/data/host_name.err] -- 011030 09:04:15 mysqld started 011030 9:04:16 /usr/local/mysql/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 011030 9:04:16 /usr/local/mysql/bin/mysqld: Normal shutdown 011030 09:04:16 mysqld ended -- exist /usr/local/mysql/data exist /usr/local/mysql/data/mysql/host.frm [For reference] # pwd /usr/local/mysql # ls COPYING INSTALL-BINARY configurelib manual.txt scripts support-files COPYING.LIB README data man manual_toc.html sharetests ChangeLogbin include manual.html mysql-test sql-bench # # pwd /usr/local/mysql/data # ls host_name.err mysql test # # pwd /usr/local/mysql/data/mysql # ls columns_priv.MYD db.MYDfunc.MYD host.MYD tables_priv.MYD user.MYD columns_priv.MYI db.MYI func.MYI host.MYI tables_priv.MYI user.MYI columns_priv.frm db.frm func.frmhost.frm tables_priv.frm user.frm # Please REPLY~~ Please ~~~ T_T;; ToT;; my e-mail address:[EMAIL PROTECTED] or [EMAIL PROTECTED] === ¿ì¸® ÀÎÅͳÝ, Daum http://www.daum.net ¼Û±Ý, 1/nû±¸, ȸºñ°È±â! À̸ÞÀÏ ÇÑÅëÀ¸·Î ÇØ°áÇÑ´Ù ¢Ñ ¸ÞÀϹðÅ· http://mailbank.daum.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
persistant insert trouble
INSERT INTO duser (username, upass, fname, lname, hphone, haddress, hcity, hstate, hcountry, hemail, utype) VALUES ('$username','$upass'.'$fname','$lname','$hphone','$haddress','$hcity','$hstate','$hcountry','$hemail','$utype') this is an insert statement that works fine in the console, but not from a web document, I can update, and remove rows just fine using either method. Can anybody see a problem with this statement, I fear I have been staring and cursing at it too long to discover a problem on my own! I'm not sure if it matters here or not but I'm using win32, PHP4 and the latest mySQL binary distro. Thank you in advance (C: _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Newsgroups
It puts the messages in a tree and makes viewing pertinent threads a breeze, My mail client puts messages in a tree and makes viewing pertinent threads a breeze. And even with the archives: http://marc.theaimsgroup.com/?t=10043869449w=2r=1 Doesn't look hard to me... database,sql,query,table,damn,this,thing,is,lame - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Newsgroups
Hi All! Do any of the public web archives of the list suit your needs? Have you seen them? It's fine for archived messages but too hard to find new messages, say within the last 7 days. Staying current with MySQL is a lot harder with the mailing list because you have to keep up with the mail each day. A newsgroup is much better because you know the messages can be browsed whenever you want. It puts the messages in a tree and makes viewing pertinent threads a breeze, especially with an offline newsgroup reader like Agent. You see the complete thread without getting inundated with 60-90 messages every day. The newgroup can still be archived to the public web archive. These comments are applicable to the current mysql.com lists, but not to the more general mailing list vs. newsgroup contention. The fact that they aren't threaded is a function of the list-2-HTML software. Gimme MHonArc -any- day of the week. :) The fact that you can't tell what you've read there before is again a matter of no dates printed by the list-2-HTML converter. The -searchable- level of the lists is about five clicks deep into mysql.com, at the bottom of a 120k page. and everyone here wonders why the same questions are asked here over and over and over. LOL! Instead of having a small INPUT box -right- on the opening screen that just -invites- the user to USE the archives.. (I also enjoy the way search page hits have LINK colors = VLINK. Makes it sooo easy to keep track of which hits I've seen and which I haven't. :) ) The real bottom line of the topic is that mailing lists are push technology. The server -sends- them to me when they arrive. Newsgroups are pull, -I- have to keep checking to see if someone posted something. For mysqlf, for 'once in a blue moon' usage, newsgroups are fine. I turn on a subscription, post a question, hang around a week or two to see what answers come in, and unsub. For daily, intense, frequent use I -far- prefer mailing lists simply because replies 'arrive' within minutes of being posted, I don't have to 'go get them.' One factor that hasn't been mentioned is moderation. This list gets spammed a -lot- because list 'membership' isn't required and only the word filters are there. (Try a search for 'spam' and you'll get 470 hits.) But a real, global, newsgroup is just wde open to the folks that have automatic scanners running and looking for 'Oh goody! A new group to spam!.' Usenet is essentially a wasteland because the ISPs don't care who does what. The only viable groups out there are moderated, and that's close to a full time job for a list with this kind of traffic. /RANT :) Have a :) day! jb -- jim barchuk [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
3.23.43 build fails on mysqlbinlog under HPUX 10.20
Description: Though not mentioned in the Change log, it appears that mysqlbinlog was moved from sql/ to client/ sometime between 3.23.41 and 3.23.43. As a result, make fails under HPUX 10.20 with /bin/sh ../libtool --mode=link gcc -O3 -DDBUG_OFF -DHPUX -I/opt/dce/include -felide-constructors -fno-exceptions -fno-rtti -fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_BROKEN_SNPRINTF -D_INCLUDE_LONGLONG -DSIGNALS_DONT_BREAK_READ -o mysqlbinlog mysqlbinlog.o ../libmysql/libmysqlclient.la -lz -lcrypt -lm gcc -O3 -DDBUG_OFF -DHPUX -I/opt/dce/include -felide-constructors -fno-exceptions -fno-rtti -fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_BROKEN_SNPRINTF -D_INCLUDE_LONGLONG -DSIGNALS_DONT_BREAK_READ -o mysqlbinlog mysqlbinlog.o ../libmysql/.libs/libmysqlclient.a -lz -lcrypt -lm -lz -lcrypt -lm /usr/ccs/bin/ld: Unsatisfied symbols: pthread_once (code) pthread_setspecific (code) pthread_getspecific (code) pthread_keycreate (code) collect2: ld returned 1 exit status make[2]: *** [mysqlbinlog] Error 1 make[2]: Leaving directory `/scr/src/bugs/mysql-3.23.43/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/scr/src/bugs/mysql-3.23.43' make: *** [all-recursive-am] Error 2 Looks like mysqlbinlog is threaded, but nothing in client/ is linked with -ldce since I didn't add/want --thread-safe-clients. How-To-Repeat: configure mysql for HPUX 10.20 following the directions, then run make. Fix: Workaround is to run make till it dies, copy the last command, cd client, paste command, add -ldce, and hit enter. Then cd .. and run make again. Fix is to have configure include -ldce in the command to link mysqlbinlog in client/Makefile. Submitter-Id: submitter ID Originator:Michael Stassen Organization: MySQL support: none Synopsis: 3.23.43 build fails on mysqlbinlog under HPUX 10.20 Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: mysql-3.23.43 (Source distribution) Environment: System: HP-UX dr B.10.20 A 9000/782 2015374635 two-user license Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc /usr/ccs/bin/cc GCC: Reading specs from /usr/local/lib/gcc-lib/hppa2.0-hp-hpux10.20/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='-DHPUX -I/opt/dce/include -I/usr/local/include -O2' CXX='gcc' CXXFLAGS='-DHPUX -I/opt/dce/include -I/usr/local/include -O2' LDFLAGS='-L/usr/local/lib' LIBC: -r-xr-xr-x1 bin bin 1867776 May 2 16:51 /lib/libc.1 -r--r--r--1 bin bin 2456780 May 2 16:51 /lib/libc.a lrwx--1 root sys15 Oct 17 12:29 /lib/libc.sl - /usr/lib/libc.1 -r-xr-xr-x1 bin bin 1867776 May 2 16:51 /usr/lib/libc.1 -r--r--r--1 bin bin 2456780 May 2 16:51 /usr/lib/libc.a lrwx--1 root sys15 Oct 17 12:29 /usr/lib/libc.sl - /usr/lib/libc.1 Configure command: ./configure --disable-largefile --with-pthread --with-named-thread-libs=-ldce --disable-shared --prefix=/usr/local/mysql --with-mysqld-user=mysql --libexecdir=/usr/local/mysql/sbin --datadir=/usr/local/mysql/data --with-libwrap - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: jdbc connectivity problem
On Saturday 27 October 2001 10:10, shanmukha rao balla wrote: i had set proper classpath for jdbc drivers and my username , password and database name,port no also correct. i am able to connect to mysql server using that username,password at COMMAND line. but while connecting to database from above java program mysql server and program are running on the same system. When you ran it at the command line, did you explicitly set the host as you describe with mysql -h localhost.localdomain ? If not, then you're probably connecting to the server via a Unix socket, not a TCP port. And if that's the case, your server may not even be accepting TCP recquests. This is what happened to me - it's the default Debian Linux configuration. To find out if it is happening to you, try running mysqladmin variables and checking the port variable. If it is 0, then you need to reconfigure your server to listen at ports. If it is 3306, then you will need to get your permissions sorted out (try using the mysqlaccess tool). And you really, really shouldn't run this stuff as root. Gordon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: SSL in version 3 and 4
Hi. Okay, my post was rejected because it was automatically suspected to be spam for not explicitly including certain words. obnoxious-jokeSo I am tempted to advertise a useless database engine, competitor to mySQL, with claims that it supports trillions of queries a second and multi-petabyte tables.obnoxious-joke/. I just joined the list. This is probably in the FAQ somewhere, but a quick browse/search didn't turn it up. My coworker needs to check how well SSL is supported in which versions. It looks like it is supported in version 4. It also looks like it is supported for "internal connections" (I assume that's inside the firewall?) in version 3.23.9, according to information that turned up searching google ("mysql ssl connections"). There is some concern about stability. Specifically, she would rather run the (assumed stable) downlevel version if it does support SSL connections on the inside of a firewall. Any comments on SSL in v. 3? or about the stability of v. 4? Joel Rees [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
Ordering Semi-Numeric ???
Hi All, Ive been searching the archives and the documentation but dont really know the terminology im looking for, or even if its do-able or not so I figure I would just ask here instead.. I have a list of records in a table, and one of the fields is alpha numeric. They look like this... XY-1-BLAH XY-2-BLAH XY-3-BLAH XY-4-BLAH XY-5-BLAH XY-6-BLAH XY-7-BLAH XY-8-BLAH XY-9-BLAH XY-10-BLAH XY-11-BLAH XY-12-BLAH XY-13-BLAH Now whats happening, im sorting my query by this field and I want it to sort as it is above. however its putting it as the following order XY-1-BLAH XY-10-BLAH XY-11-BLAH XY-12-BLAH XY-13-BLAH XY-2-BLAH XY-3-BLAH Is there a way to sort this field (which is set to VARCHAR) by the first list, not the second list ? I know I can load all the entries up in an array and use a PHP type array sort function, but thats not really the outcome I need because ultimately I want to do a descending sort, and just grab the last record.. Am I making sense, cause ive managed to confuse myself a little here :) Cheers Chris -- Chris Aitken - Administration/Database Designer - IDEAL Internet email: [EMAIL PROTECTED] phone: +61 2 4628 fax: +61 2 4628 8890 __-__ # ln -s /dev/null /bin/laden If you don't like my typing, all flames to /bin/laden - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
BOOLEAN Variable
I am using MySQL 3.23.22-beta pls tell is there any way to define boolean variable in this db what is the BOOL for ? declaring a var BOOL make it TINYINT(1)! but not boolean thanks Shomaai - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: BOOLEAN Variable
Hi there, My understanding is that there is no BOOL type in MySQL but BOOL is allowed in create table statements (or alter table etc) for compatibility with other databases (but MySQL uses a tinyint for a bool because it doesn't have bool). You can use a tinyint and say that 0 is false 1 is true, or you could define an enum or something. There has been much discussion on this list about which is the best approach - basically depends on what you see as important, you might want to do a search on old list stuff to get some ideas. hope that helps. cheers, noel On Tuesday, October 30, 2001 1:52 PM, Shomaail [SMTP:[EMAIL PROTECTED]] wrote: I am using MySQL 3.23.22-beta pls tell is there any way to define boolean variable in this db what is the BOOL for ? declaring a var BOOL make it TINYINT(1)! but not boolean thanks Shomaai - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: persistant insert trouble
Michael Stassen I owe you my sanity!!! THANK YOU THANK YOU THANK YOU!!! (my wife is laughing at me for being such a dork) I really appreciate your help thank you very much. From: Michael Stassen [EMAIL PROTECTED] To: Curtis Gordon [EMAIL PROTECTED] Subject: Re: persistant insert trouble Date: Mon, 29 Oct 2001 20:02:55 -0500 (EST) On Tue, 30 Oct 2001, Curtis Gordon wrote: INSERT INTO duser (username, upass, fname, lname, hphone, haddress, hcity, hstate, hcountry, hemail, utype) VALUES ('$username','$upass'.'$fname','$lname','$hphone','$haddress','$hcity','$hstate','$hcountry','$hemail','$utype') ^ Should be a comma between '$upass' and '$fname', right? this is an insert statement that works fine in the console, but not from a web document, I can update, and remove rows just fine using either method. Can anybody see a problem with this statement, I fear I have been staring and cursing at it too long to discover a problem on my own! I'm not sure if it matters here or not but I'm using win32, PHP4 and the latest mySQL binary distro. Thank you in advance (C: Michael Stassen Support Center University Information Technology Services Indiana University Bloomington [EMAIL PROTECTED] _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Comparing strings as ints
Hi Everyone, After staring blankly at the mysql manual for a long time, I thought it might be time to ask the list... I have a table setup with a varchar(20) column, I am using this column to store a price, the reason I chose varchar(20) is because the prices I am dealing with are fairly large and I wanted to guarintee 20 digits. There are no characters like '$' or '.' stored in this column. Now, If I select and where this column = somevalue everything is good and works.. but! when I use a string as somevalue it all goes nuts, because mysql will convert the string to an integer if the other value in the comparison is an integer, but if both are strings it's a slight problem. The reason I want to compare it with a string is the data is from a web based form and contains an escaped string. I don't want anyone playing with the database. Here is the problem another way... select '5' = '6'; = 1 select '5' = '4'; = 0 select '5' = '40'; = 0- eegad. does anyone know how I can get around this? Thanks, Daniel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: BOOLEAN Variable
Shomaail [SMTP:[EMAIL PROTECTED]] wrote: I am using MySQL 3.23.22-beta pls tell is there any way to define boolean variable in this db what is the BOOL for ? declaring a var BOOL make it TINYINT(1)! but not boolean thanks Shomaai --- Noel Clarkson [EMAIL PROTECTED] wrote: You can use a tinyint and say that 0 is false 1 is true, or you could define an enum or something. There has been much discussion on this list about which is the best approach - basically depends on what you see as important, you might want to do a search on old list stuff to get some ideas. One of the guys at work suggested char(0) as a boolean. Your two values are '' and IS NULL. = dcampbel - duncan campbell __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.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: Problem installing 3.23.43 (@HOSTNAME@ command not found)
We have the same problem with MySQL (3.23.36) for SCO OpenServer, in script mysql.server. Here is the problem code, showing my workaround. ... if test -z $pid_file then # pid_file=$datadir/`@HOSTNAME@`.pid pid_file=$datadir/`hostname`.pid # changed @HOSTNAME@ to hostname else case $pid_file in ... I see no release notes to indicate that the problem is fixed. Thanks, Stephen I then got this error message: /etc/init.d/mysqld: @HOSTNAME@: command not found Starting mysqld daemon with databases from /usr/local/mysql/data 011029 12:23:02 mysqld ended Any ideas why this error is occurring? Thanks, Neil. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Ordering Semi-Numeric ???
Is there a better answer than making sure the mixed keys have enough leading zeros in the numeric sub-field to suppress the string comparison effect? ergo (if you know you will never have ten thousand records): XY-0001-BLAH XY-0002-BLAH XY-0003-BLAH XY-0004-BLAH XY-0005-BLAH XY-0006-BLAH XY-0007-BLAH XY-0008-BLAH XY-0009-BLAH XY-0010-BLAH XY-0011-BLAH XY-0012-BLAH XY-0013-BLAH is the orthodox approach, and should work. But if there were some way to count off the number of lead non-numeric characters and let the comparison function soft-parse the numeric sub-field, Chris's semi-numeric keys should work. Or, providing some way to escape from the standard comparison function to a custom function should also work. Squeezing the syntax for this kind of custom key comparison into SQL might not be easy. I didn't see any evidence of custom comparisons in a quick search of the manual ... Chris Aitken [EMAIL PROTECTED] asked: Hi All, Ive been searching the archives and the documentation but dont really know the terminology im looking for, or even if its do-able or not so I figure I would just ask here instead.. I have a list of records in a table, and one of the fields is alpha numeric. They look like this... XY-1-BLAH XY-2-BLAH XY-3-BLAH XY-4-BLAH XY-5-BLAH XY-6-BLAH XY-7-BLAH XY-8-BLAH XY-9-BLAH XY-10-BLAH XY-11-BLAH XY-12-BLAH XY-13-BLAH [snipped] Joel Rees [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: SecureCRT
On Mon, Oct 29, 2001 at 09:23:46AM -0500, [EMAIL PROTECTED] wrote: I am using SecureCRT to login to a remove MySQL server. I can get pass the initial login. However, a login screen displays on the screen asking for a second password. I have entered all information correctly, but the system is still requesting another password. SecureCRT just logs you into the computer that's running MySQL (or has the mysql client available on it). The second login is your log in for MySQL itself which is a seperate password list from the system's list (ask the administrator of the computer in question). -- Michael T. Babcock CTO, FibreSpeed Ltd. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Database Transfer
Hi all i have a mysql database running on linux machine..i would like to have the complete database to be transfered with all its properties and settings into another linux machine.. how can i do that.. can anyone help me... thanks in advance Sai D Burra _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SecureCRT
On Mon, Oct 29, 2001 at 08:24:48AM -1000, Luis wrote: Why dont you use ssh to login to you sever . SecureCRT is an SSH implementation for Windows. [ It is useful for accessing SQL DATABASEs like MYSQL ] -- Michael T. Babcock http://www.fibrespeed.net/~mbabcock/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php