RE: Length limit of 500 on primary keys?
The problem is that he has it as a primary key, so he wants it to be unique as well as indexed. The best solution (and MUCH MUCH MUCH more efficient) would be to hash each of the four columns, and create a primary key on that. Integer keys are much faster and memory-efficient than string keys. Steve Meyers -Original Message- From: Chris Bolt [mailto:[EMAIL PROTECTED]] Sent: Saturday, October 20, 2001 8:31 PM To: [EMAIL PROTECTED] Subject: RE: Length limit of 500 on primary keys? Is there a way to raise this limit? We have some tables with columns that are VARCHAR(200), and need to make a primary key based on combinations of these columns (in some cases, upto 4 columns), and MySQL complains for all of these table definitions that Specified key was too long. Max key length is 500. Why do you need to index the entire column? You can just index a prefix of the column, like the first 125 bytes of each column. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
where to put a txt file to fill a table?
Hi, This evening I'd download the complete packet of NuSphere what contains also MySQL. In the tutorial what comes with it, it say that you can make a txt file and save it. With this txt file you can LOAD it in MySQL by using the command: LOAD DATA LOCAL INFILE txt_name.txt INTO TABLE table_name; But it does not tell me where I have to save this txt file. I tried it in several directories, but MySQL cannot find the file. Can you tell me where I have to save the txt file in order to be able to let MySQL load the txt file in the table ? The nusphere directory is located at c:\program files\ To see the directory structure, I had upload a screenshot to http://home.planet.nl/~jool/mysql-dirs.gif Best regards, Olav Wirtz The Netherlands. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Field Naming Standards
I share most of these conventions, and I think the key is consistency. Consistency makes the database usable, without guessing or having to refer back to notes or other uses of the table or field. My golden rules are 1. Key names are unique within the database this avoids any confusion when joining tables. I have one cross-reference table Model_ID int(11) NOT NULL default '0', Model_type_code char(1) default NULL, Country_code char(2) default NULL, Manufacturer_code char(2) default NULL, Range_code char(2) default NULL, Derivative_code char(2) default NULL, Trim_code char(2) default NULL, Engine_code char(2) default NULL, Fuel_system_code char(2) default NULL, Body_type_code char(2) default NULL, Body_doors char(2) default NULL, Transmission_code char(2) default NULL, Intro_date int(11) default NULL, Term_date int(11) default NULL, Modified_when date default NULL, PRIMARY KEY (Model_ID) where almost all the fields are primary keys of other tables. Using 'id' as the primary key for all tables (or duplicating key field names at all) would be a nightmare when you are trying to understand how tables relate to each other if you are working with large numbers of related tables or cross referencing tables. 2. Sequential auto generated ids get 'ID' at the end e.g. 'UserID' I use this as a marker and avoid using them directly to avoid users spoofing them ( update_user.php3?UserID=1Privilage_levelID=2 opens a security risk ) 3. I capitalise first letters of field names. This differentiates fieldnames from variables in php (where I always use lowercase ) which I find makes coding more readable and reduces the risk of errors . 4. I think 'Current_manufacturer_code' is more readable than 'CurrentManufacturerCode' so I prefer _ 5. Use descriptive fieldnames 'Current_manufacturer_code' is more typing, but 'c_man_cd' is meaningless to somebody else or six months later when you come to rework some coding. I also like my SQL to be as close to natural language as possible, for the same reason, and this helps. In the end consistency is essential, much of the rest is personal preference. Peter -Original Message- From: ryc [mailto:[EMAIL PROTECTED]] Sent: 20 October 2001 19:48 To: Mike E; [EMAIL PROTECTED] Subject: Re: Field Naming Standards I am not aware of any document that describes naming conventions, but through my use of databases and design I have found a scheme that works for me. I follow these rules: 1. The autoincrement field (or unique id) for a table is named tablename ++ id. So if the table is books the unique identifier for the row would be bookid. 2. When an attribute in one table is the same as in another table (ie in the table books I might want to reference a row in the author table in which case I would name the attribute in the books table authorid). 3. I use lowercase names for both tables and attributes.. The reason is I am not a big fan of uppcase letters unless they serve a purpose (like in OO the class name would be upper case while methods on the class are lowercase). In SQL there isnt much of a need to diferentiate between a table and a attribute because you can determine easily what the name is from the context in which it was used in the query. But I think this is a preference thing, I could see someone thinking its very useful. 4. When naming an attribute I try to reflect the meaning of the data as much as possible in the attribute name. Because SQL doesnt let you easily convey to the client what the field means, you must do it in the attribute name. So instead of using something like aptno for a field I would choose apartmentnumber. 5. If you use apartmentnumber in one table, make sure to call other references to it apartmentnumber as well... Dont change it to aptno. This follows from rule 2, I just thought I would say it again in another way. :P The same goes for code that uses these attributes. If a variable holds the value from the apartmentnumber attribute, dont call it aptno. It might be clear in this example where that data came from but that may not hold for other examples... and definitly if someone is going over your code who is not familiar with the database it will help (or if you havent looked at the code in a really long time). That is about it for now... anyone care to add? ryan I've been developing in MySQL for some time now, but as I go along I've noticed that my naming conventions have changed dramatically, and I was wondering if there is like a set of guidelines or something I could take a look at. A set of standards, if you will, for naming conventions of fields in tables in MySQL databases. For example, using all lowercase for field names, separating words with underscores, or not, and whether to use a descriptive auto_increment id (such as userid, newsid) or if to just use id for every table. Any discussion
RE: Unix Shell Auth from MySQL
I've used pam-mysql with redhat linux and am very pleased with it. I love being able to authenticate to a db. Ernie Hershey [EMAIL PROTECTED] -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Friday, October 19, 2001 2:00 AM To: Chris Aitken Cc: [EMAIL PROTECTED] Subject: Re: Unix Shell Auth from MySQL On Fri, Oct 19, 2001 at 03:46:49PM +1000, Chris Aitken wrote: Hi, Something ive been thinking about for a while but havent been able to come up with a definitive answer is this... Is there a system out there which can take over from the normal (unix based... FreeBSD/Linux type) telnetd method of authenticating a login off /etc/master.passwd and instead using a MySQL database for auth. If FreeBSD has PAM support, one could write a PAM module to authenticate against MySQL. Believe it or not, someone already has: http://sourceforge.net/projects/pam-mysql/ 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 43 days, processed 943,928,919 queries (253/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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 doble quotes from entries?
Does anyone know how to delete double quotes from my entries ''. I thing you can use regular expressions. Dexter, The following resources may be of interest to you: The MySQL Manual, particularly: 7.1 Literals: How to Write Strings and Numbers, 7.4 Functions for Use in Select and Where Clauses, 7.4.6 String Comparison Functions, and 7.4.10 String Functions Also real inspiration in a recent posting on this list (on a similar problem) is RE: UPDATE problem from Steve Meyers to Amit. [That and your question managed to get my 'creative juices' flowing this morning - thanks] The 7.1 manual entry discusses literals, so if you're uncertain about being able to enclose double-quotes () in a string ... Next ambiguity: the word delete might lead you to the SQL command: DELETE. In fact you want to UPDATE your data (by deleting/removing...) The title of the 7.4 manual entry is a great hint as to problem solving methodology - you might be heading for an UPDATE command, but the WHERE clause is common to both SELECT and UPDATE and thus you can use SELECT to build and debug that far - rather than unnecessarily risking errors leading to data corruption and db restores (from that ever elusive backup copy...) While on this topic, you can also work on the SET clause by quoting 'sample data' directly without using a TABLE (many examples in the manual entries listed), so we CAN save databases (as well as the whales!) Next ambiguity: I made the casual assumption that the double quotes in the entries were surrounding strings (ie first and last character of the field). You didn't indicate if this was so, or if they are 'randomly scattered' within the string data - Notice that the WHERE clause below handles both situations, but the SET clause does not!!! The 7.4.6 manual entry discusses the % wild-card character and thus how to build the WHERE clause. The 7.4.10 manual entry lists a whole range of functions - yes you could use a REGEX solution, but (I'm not very good at those and) the simplest approaches are always the best. Have settled on the TRIM command which (I always think is only useful to remove leading/trailing spaces, but) is a multi-purpose tool when you decide which character(s) it should work on. Of course you could also use substring() and length(), etc, etc. Another little gripe: it would be easier if you gave us more information about your data/what you have tried before posting a request on the list. Then we don't have to 'invent' or 'guess' what your data/table looks like! UPDATE tbl_dexter SET str_right = TRIM(BOTH '' FROM str_right) WHERE str_right LIKE '%%'; - the TRIM string argument is single-quote then double-quote then single-quote! If the double-quotes are (also) 'embedded' in string str_right, this won't be enough! Please advise, =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: where to put a txt file to fill a table?
Olav Wirtz writes: LOAD DATA LOCAL INFILE txt_name.txt INTO TABLE table_name; But it does not tell me where I have to save this txt file. I tried it in several directories, but MySQL cannot find the file. Did you by any chance specify an incorrect path to the file in the query? Don't rely on mysql's current directory to be something specific, but give the full path to the file instead. //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
Error codes list
Hi Maybe it is in the manual, but i can´t find it in the way i need. Does anybody know where to find a complet list of MySQL error codes with number and descripcion in order to make a library for handling and reporting alerts to users in php Thanks a lot - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error codes list
Hi Maybe it is in the manual, but i can´t find it in the way i need. Does anybody know where to find a complet list of MySQL error codes with number and descripcion in order to make a library for handling and reporting alerts to users in php Hola Javier, Yes it is in the manual - but try the PHP manual (not MySQL's). The PHP online annotated manual is 'down' at the moment (update happening?) so I can't give you a reference - apologies. In addition to the familiar PHP-MySQL functions, eg mysql_query($sqlQuery, $dbLink) There are two more: mysql_errno() and mysql_error() which return an error number and error text (from the 'latest' MySQL function executed) - or zero and empty-string if the execution 'worked'. It's important to perform error-checking, but some would suggest that it should not be reported to users - under 'normal' circumstances!? Regards, =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error codes list
Get the pdf version from php.net. At 01:02 P 21/10/01, DL Neil wrote: Hi Maybe it is in the manual, but i can´t find it in the way i need. Does anybody know where to find a complet list of MySQL error codes with number and descripcion in order to make a library for handling and reporting alerts to users in php Hola Javier, Yes it is in the manual - but try the PHP manual (not MySQL's). The PHP online annotated manual is 'down' at the moment (update happening?) so I can't give you a reference - apologies. In addition to the familiar PHP-MySQL functions, eg mysql_query($sqlQuery, $dbLink) There are two more: mysql_errno() and mysql_error() which return an error number and error text (from the 'latest' MySQL function executed) - or zero and empty-string if the execution 'worked'. It's important to perform error-checking, but some would suggest that it should not be reported to users - under 'normal' circumstances!? Regards, =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Error codes list
Thanks a lot, as you know, I need to translate error codes (such as duplicate references) to the future (i hope) program operator. The error codes are for operators (those who write data into the catalog), not for public, I know PHP error reporting functions with MySQL, but i would like to write some functions to analize errors when they happend, break the program execution and tell operators what is happending (in spanish and in a language they could understand). What i´m looking for is a complet lits in some way like this : Error code numbrer (not DEFCON 5 :-)) Error descripcion Thanks a lot for your interest and help Apologize my macarronic english, when i get rich with this progect i´ll travel to great britain in order to learn some good english (and taste english beer and women) At 12:02 21/10/01 +0100, DL Neil wrote: Hi Maybe it is in the manual, but i can´t find it in the way i need. Does anybody know where to find a complet list of MySQL error codes with number and descripcion in order to make a library for handling and reporting alerts to users in php Hola Javier, Yes it is in the manual - but try the PHP manual (not MySQL's). The PHP online annotated manual is 'down' at the moment (update happening?) so I can't give you a reference - apologies. In addition to the familiar PHP-MySQL functions, eg mysql_query($sqlQuery, $dbLink) There are two more: mysql_errno() and mysql_error() which return an error number and error text (from the 'latest' MySQL function executed) - or zero and empty-string if the execution 'worked'. It's important to perform error-checking, but some would suggest that it should not be reported to users - under 'normal' circumstances!? Regards, =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: where can find a lisy of keystroke commands for mysql?
- Original Message - From: [EMAIL PROTECTED] To: Barbara Ferrell [EMAIL PROTECTED] Sent: Sunday, October 21, 2001 7:52 AM Subject: Re: where can find a lisy of keystroke commands for mysql? 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: i am two days new in learning mysql and am designing a table. i can't get back to the beginning of the table when i notice a typo and also even back to the beginning of my line without overwriting everything. i have spent forever looking everywhere .. i can't even backspace past the . - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Info
Hi How I can use transaction with MySQL API ( C and C++) Best Regards Jordan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Where can i find a list of keystroke commands for MYSQL?
i am two days new in learning MYSQL and am designing a table. i can't get back to the beginning of the table when i notice a typo and also even back to the beginning of my line without overwriting everything. i have spent forever looking everywhere .. i can't even backspace past the . - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Index spindle??
Thanks, that worked. However, it appears that each time I execute an alter table command (such as addng a new index), I'll have to repeat the process of creating the index, moving the file, then again defining the symlink. MySQL does not seem to respect the link with new DDL commands like that. Not the end of the world, just a bit of a surprise behavior to me. Again, thanks. On Saturday 20 October 2001 06:37 pm, you wrote: On Sat, Oct 20, 2001 at 05:54:28PM -0400, tony.icuc wrote: Would anyone know of a method to create/fake/move/configure and index on an alternate disk than the base table? I hail from a platform that allows specific disk specification for partition, index and alternate key files. Naturally, I referenced Paul DuBois' amazing book, to no avail. Just curious if this is possible with the standard MySQL 3.23.26. Create the index, move the .MYI file to where you'd like, and leave a symlink which points to it. MySQL will respect that. Jeremy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 problem
Hello Mike, I just would like to know, did you mean in your message the EMS MySQL Manager or something else? In first case your words sound very strange to me: no one of our users had write us something like this, and many of them are praises our product. Some opinions of our users about EMS MySQL Manager you can read at http://www.mysqlmanager.com . Regards, Igor Brynskich --- mailto:[EMAIL PROTECTED] http://www.ems-hitech.com - Original Message - From: Mike Barber [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 19, 2001 10:30 PM Subject: Re: MySQLGUI problem I have found the MySQL Manager to be incredibly buggy and a pain to even do the most simplest things. I would suggest that you try MySQL-Front http://www.anse.de/mysqlfront/ Very easy to use and very functional. - Original Message - From: Sinisa Milivojevic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, October 19, 2001 10:28 AM Subject: Re: MySQLGUI problem cedric writes: MySQLGUI-1.7.5 was working. Now, when I start it and put the mouse pointer over it, it disappears. Reinstalled only to get the same thing. Any ideas? cedric What operating system do you use ?? Have you changed X version or window manager ?? I never heard of something like that. -- 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Installing Mysql 4.0.0. alpha on Suse 6.3
Hi, I am trying to install the latest mySQL 4.0.0. alpha on my Suse linux box Version 6.3. However the comile run failes. What am I doing wrong? Is it in general possible to install it? Has anyone succeeded so far on Suse Linux 6.3? Best regards Andreas Berner [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
myisamchk error
Hello All, When repairing a MySql table, I keep getting following error: 'mydatabase.MYD' doesn't have a correct index definition What exactly does this mean or what needs to be done to correct it? Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Where can i find a list of keystroke commands for MYSQL?
Control-A and control-E are good ones.. ^A will go to the begginning of a line and ^E goes to the end. Also, ESC-b and ESC-f will go back/forward word by word. You can also type \e to load your current statement into an editor, which lets you harness the navigation/text-control power of your favorite editor. But of course I think these are all dependant on your OS... This is documentation for GNU readline, which is what the mysql client uses to be interactive (^A and ^E for example are part of readline, not the mysql client itself): http://cnswww.cns.cwru.edu/~chet/readline/rluserman.html This is from the manual: mysql help MySQL commands: help(\h)Display this text. ? (\h)Synonym for `help'. clear (\c)Clear command. connect (\r)Reconnect to the server. Optional arguments are db and host. edit(\e)Edit command with $EDITOR. ego (\G)Send command to mysql server, display result vertically. exit(\q)Exit mysql. Same as quit. go (\g)Send command to mysql server. nopager (\n)Disable pager, print to stdout. notee (\t)Don't write into outfile. pager (\P)Set PAGER [to_pager]. Print the query results via PAGER. print (\p)Print current command. quit(\q)Quit mysql. rehash (\#)Rebuild completion hash. source (\.)Execute a SQL script file. Takes a file name as an argument. status (\s)Get status information from the server. tee (\T)Set outfile [to_outfile]. Append everything into given outfile. use (\u)Use another database. Takes database name as argument. Ernie Hershey [EMAIL PROTECTED] -Original Message- From: Barbara Ferrell [mailto:[EMAIL PROTECTED]] Sent: Sunday, October 21, 2001 9:25 AM To: [EMAIL PROTECTED] Subject: Where can i find a list of keystroke commands for MYSQL? i am two days new in learning MYSQL and am designing a table. i can't get back to the beginning of the table when i notice a typo and also even back to the beginning of my line without overwriting everything. i have spent forever looking everywhere .. i can't even backspace past the . - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
SUMMARY: Problem with myisamchk -- what am I missing?
Hi all, I'd like to thank Gordon Burditt for responding to my question. (Original question below.) It seems I was invoking myisamchk incorrectly. Rather than doing: # myisamchk mailtable ...I was specifying both the data and index files, like this: # myisamchk mailtable.MYD mailtable.MYI I think what confused me was this sentence from the manual (Chapter 15.1 Using myisamchk for Table Maintenance and Crash Recovery, 2nd paragraph): To check/repair MyISAM tables (.MYI and .MYD) you should use the myisamchk utility. Thanks, Gordon, for clarifying that for me. : Best, /Rob At 00:43 -0500 2001/10/21, Gordon Burditt wrote: As near as I can tell, you DON'T pass *.MYD files to myisamchk, just *.MYI files. What's wrong with the *.MYD file is that it is not and never was an index. --- original question --- At 15:50 -0400 2001/10/20, Robert Alexander wrote: Hi all, I'm in the process of writing a searchable mailing list archive in Perl MySQL. I'm using Monty's old mail_to_db.pl script (which I got from the MySQL site long ago) to load emails from their mailbox into MySQL. Runs just fine, BTW. However, when I run myisamchk on the mail table, it says: # myisamchk mailtable.MYD mailtable.MYI myisamchk: error: 'mailtable.MYD' doesn't have a correct index definition. You need to recreate it before you can do a repair - Checking MyISAM file: mailtable.MYI Data records: 99 Deleted blocks: 0 - check file-size - check key delete-chain - check record delete-chain - check index reference - check data record references index: 1 - check data record references index: 2 - check record links ...but for the life of me, I can't see what's wrong with the index definition. (See info below.) I've read all the pertinent manual chapters (I think), I've dropped and recreated the table several times, and imported the data by a couple different methods. Still keep getting the error. The table in question has only 99 records in it right now. Can anyone spot what I'm missing? Or point to towards some more info? Thanks very much! All the best, /Rob Here's the vital information: MySQL 3.23.36. Solaris 8 on a Sun UltraSparc 1. Perl 5.6 Table: DROP TABLE IF EXISTS mailtable; CREATE TABLE mailtable ( msg_nromediumint unsigned NOT NULL auto_increment, date DATETIME NOT NULL, time_zone varchar(6) NOT NULL, mail_from varchar(120) NOT NULL, reply varchar(120), mail_toTEXT, cc TEXT, sbjvarchar(200), txtMEDIUMTEXT NOT NULL, file varchar(32) NOT NULL, hash INT NOT NULL, KEY (msg_nro), PRIMARY KEY (mail_from, date, time_zone, hash) ); desc mailtable; +---+---+--+-+ -++ | Field | Type | Null | Key | Default | Extra | +---+---+--+-+ -++ | msg_nro | mediumint(8) unsigned | | MUL | 0 | auto_increment | | date | datetime | | PRI | -00-00 00:00:00 | | | time_zone | varchar(6)| | PRI | || | mail_from | varchar(120) | | PRI | || | reply | varchar(120) | YES | | NULL || | mail_to | text | YES | | NULL || | cc| text | YES | | NULL || | sbj | varchar(200) | YES | | NULL || | txt | mediumtext| | | NULL || | file | varchar(32) | | | || | hash | int(11) | | PRI | 0 || +---+---+--+-+ -++ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Performance Question
Dear Sir/Madam. I have written a Management Information System that has a MySQL db running on a Linux server. There is quite a small number of tables. However these tables are growing quickly and the queries executed will require LEFT OUTER JOIN between tables. Example: A sample query over 4 tables using LEFT OUTER JOIN Table A 11000 rows Table B 15000 rows Table C 18000 rows Table D 2,500,000 rows Table D will over a year will reach values of 10 to 15 million records. Are you aware of any benchmarks / examples of expected response time?? Regards, Ronan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: shared datafiles.
- Original Message - From: Zachary Denison [EMAIL PROTECTED] To: MySQL ListServe [EMAIL PROTECTED] Sent: Sunday, October 21, 2001 11:11 AM Subject: shared datafiles. I know this is probably a recipe for disaster, but would I be able to have 2 instances of mysql running, both pointing to the same set of datafiles? Before you ask, my reasoning for doing this would be so that I could get some sort of underlying shared mirrored filesystem and this way I could have 2 read/write copies of mysql running in 2 different locations. Why not just create two connection objects within your language of choice? Assuming that your current MySQL server has its own IP address, you can use an ODBC connection, via the IP, and connect to the same MySQL db from virtually anywhere. From an efficiency standpoint, you're much better off creating two connections rather than having two simulatneous servers. Good Luck, Dennis Salguero ** Beridney Computer Services [EMAIL PROTECTED] http://www.beridney.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: Absolute beginner moving from Access
- Original Message - From: Bernard Davis [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, October 21, 2001 12:50 PM Subject: Absolute beginner moving from Access I've been able to get the basic website working although God knows how, but to develop other services on the web site I need to be able to work locally on my Win 98 machine. I use Dreamweaver Ultradev. I cannot get any sort of a connection locally, using PWS and MySQL server. And how exactly were you planning to do that? If memory serves me, Ultradev produces ASP code - is that what you were planning to do? At the very least, you're going to need an ODBC connection (to your MySQL server) on the same machine as the PWS server (which I assume you know how to create). Once the connection is there, you should be able to designate that as your datasource, from within UltraDev. Realize that UltraDev attempts to make use of some ADO properties and methods that are not yet supported by MySQL, but you should be able to create the initial connection fairly easily. If you need an ASP tutorial, let the list know - I'm sure that there are some resources for that already out there. Good Luck, Dennis Salguero ** Beridney Computer Services [EMAIL PROTECTED] http://www.beridney.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
Proposed Guidelines for Posting to the MySQL list
Hi everyone, There's been some discussion recently on the need for a FAQ and posting guidelines for the MySQL list. I got to thinking about that... : I belong to another list, called the SunMangers list. (I'm sure there's other SunMangers members here. Hi! : ) The SunManagers list is a wonderful resource for getting timely help for those times when you're stuck and just can't get something to work correctly. Some of the top people in the Sun world are on that list, and they can be very generous with their time to help others. That list has been in existence for a *long* time, and is so successful because the members have developed some rules to make it work well. I asked the SunManagers Information Files maintainer, John DiMarco [EMAIL PROTECTED], if I could create a set of guidelines for the MySQL list based on those that are posted regularly to the SunManagers list, and he graciously gave his permission. I'm also volunteering to maintain this document, and to post it periodically to the list. So, here's the proposed Guidelines. Take a look. Thoughts and constructive comments are welcome and encouraged. Flames go to /dev/null : Thanks everybody! -- Guidelines for Posting to the MySQL list - NOTE: This message is posted periodically to the MySQL List on behalf of all members of the MySQL mailing list. Please read it carefully before posting. This document can be retrieved from: [proposed: ftp.workmate.ca] Dear prospective MySQL List poster, We ask your kind co-operation in making the MySQL list a more valuable, effective resource for all of us in our community who use it. Before posting, please stop for a minute and consider whether or not your posting is suitable for the MySQL List. The list is not intended for just any possible question related to database software and development. The only appropriate questions for the MySQL List are questions about the use of the MySQL database software products that are NOT answered in the manuals or system documentation, in the mail archives, or in the MySQL FAQ. These are the rules for posting to the MySQL list: - Remember that busy people are giving their time to help you. Respect that. If you want help from the best, don't waste their time. You are expected to have done your basic homework -- the list is not a place to go because you 'don't have time' to read the manual. The list is there for when you've tried your best, made a real effort, and are genuinely stuck. - You have to repay the favour. You are required to post a single SUMMARY of the email responses to your question. The SUMMARY contains the original question, explains the solution that solved the problem, and names and thanks the folks who helped you. This solution will then be in the archives, available to everyone. This increases our community's store of knowledge, and helps to prevent the same questions from being posted to the list every other day. - Don't post off-topic questions. Eg. PHP questions not directly related to MySQL go to the PHP list. - Replies are directed to the POSTER and not to the list. This keeps traffic and clutter down. - Those who don't post a SUMMARY are likely to find future questions going unanswered. In particular, the following kinds of postings are NOT appropriate: - Subscribe and unsubscribe messages. See your email headers for subscribe and unsubscribe instructions. - Test messages of any sort. - Extended discussions about anything, including discussions about the list itself, or numerous followups to any posting. - Postings not related to MySQL software or its use. Use the appropriate newsgroup or mailing list instead. For example, if your question concerns sendmail, please consult the comp.mail.sendmail newsgroup or the www.sendmail.org website. - General OS, network, or software questions. Use the appropriate newsgroup, eg. comp.unix.questions instead. - Postings that are not time-critical. Postings claiming to be 'URGENT!' when they are not are particularly inappropriate. They are also dishonest and disrespectful of the other list members. - Questions already answered in the Archives or FAQ. Read the Archives or FAQ instead. If you're not sure if the question is in there, please look before asking. You can find the archives at http://lists.mysql.com/ and the FAQ at: [future-location-of-FAQ] - Questions that are answered in the excellent manuals or system documentation. Read the manuals instead. If you're not sure if the question is answered in the manuals, please check first! - Job postings, requests for jobs, sales pitches, etc. Get permission from the MySQL staff first, or use the appropriate newsgroup instead. - Please, no postings in HTML, rich-text-format, Microsoft Word, Word Perfect, or any format that some people on
Some weird problem (aren't they all :-)
Hi there! I have a question. I've created a page in PHP4 which displays the result of the following query: select event_detail.id, event_detail.startdate, event_detail.enddate, event_detail.title, event_detail.comment, event_detail.active, event_detail.subscription_open, event_main.url from event_detail, event_main where event_detail.id_main = event_main.id and startdate '$today' and active = 'Y' order by startdate asc And everything works as it should...up until this weekend where I receive the following error: Warning: Supplied argument is not a valid MySQL result resource in /u284/oneiros/algemeen/agenda.php on line 28 The strange thing is that when I remove the order by line in the query, everything works fine. I've tried recreating the two tables in question but to no avail. Oh, yes. On my local server, I run MySQL version 3.23.41-nt and everything works just fine. The version on the server with the provider is 3.22.21 Many thanks in advance Blessed Be Peter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Proposed Guidelines for Posting to the MySQL list
Robert Alexander wrote: - Replies are directed to the POSTER and not to the list. This keeps traffic and clutter down. - Those who don't post a SUMMARY are likely to find future questions going unanswered. So answers to questions go directly to the poster and are not cc'd to the list? I suppose it's more efficient because each discussion thread has only a question and it's summary both posted by the same author. But won't this make the list a bit sterile? Other authors wont be able to participate in a discussion and there wont be the public aggregation of viewpoints - just a reliance on the original poster (many of whom are newbies) to consolidate all replies they receive and post a coherent summary based on individual emails. I took a look at the SunManager's archive and it seems that many of the questions don't have summary posts. I'm not a subscriber though, so perhaps I missed something. I also find it useful sometimes when browsing the archives to look at all posts in each thread because sometimes they provide insights into related issues. I think summary posts are definitelly a must, but users should be required to cc the list when replying to posts. Also descriptive tags are really useful in the subject. For example the mod_perl (perl under Apache - http://perl.apache.org) list uses the following: --snip-- 5.2.8. It can be helpful if you use a tag [in square brackets] in the Subject: line, as well as the brief description of your post. It does not matter whether you use [UPPER CASE] or [lower case] or even a [Mixture Of Both] in the tag. Some suggested tags are: ADMIN Stuff about running the List. ADVOCACY Promoting the use of mod_perl, printing T-shirts, stuff like that. Please don't start another discussion about whether we should put this on a different list, we've been there before. ANNOUNCE Announcements of new software tools, packages and updates. ASP Joshua Chamas' implementation of Perl embedded in HTML. BENCHMARK Apache/mod_perl performance issues. BUG Report of possible fault in mod_perl or associated software - it's better if you can send a patch instead! DBI Stuff generally concerning Apache/mod_perl interaction with databases. FYI For information only. JOB Any post about mod_perl jobs is welcome as long as it is brief and to the point. Note: Not JOBS. MASON Jonathan Swartz' implementation of Perl embedded in HTML. NEWS Items of news likely to be interesting to mod_perlers. OffTopic Or [OT] Off-topic items, please try to keep traffic low. PATCH Suggested fix for fault in mod_perl or associated software. QUESTION Questions about mod_perl which is not covered by one of the more specific headings. RareModules Occasional reminders about little-used modules on CPAN. RFC Requests for comment from the mod_perl community. SITE Stuff about running the Apache/mod_perl servers. SUMMARY After investigation and perhaps fixing a fault, and after an extended discussion of a specific topic, it is helpful if someone summarizes the thread. Don't be shy, everyone will appreciate the effort. If you can't find a tag which fits your subject, don't worry. If you have a very specific subject to discuss, feel free to choose your own tag, for example [mod_proxy] or [Perl Sections] but remember that the main reasons for the Subject: line are to save people time and to improve the response to your posts. --snip-- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Installation from Source
Hi!, I tried to install from mysql-3.23.43.tar.gz. i configured using ./configure --prefix=/usr/local/mysql --localstatedir=/usr/local/mysql/data and then make and make install changed all the permissions. Then on starting safe_mysqld i get this error in .err file --- 011022 02:07:09 mysqld started ^G/usr/local/mysql/libexec/mysqld: File './it-106-bin.1' not found (Errcode: 13) 011022 2:07:09 Could not use it-106-bin for logging (error 13) 011022 2:07:09 /usr/local/mysql/libexec/mysqld: Can't create/write to file '/usr/local/mysql/data/it-106.pid' (Errcode: 13) 011022 2:07:09 /usr/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 011022 2:07:09 /usr/local/mysql/libexec/mysqld: Error on delete of '/usr/local/mysql/data/it-106.pid' (Errcode: 13) 011022 02:07:09 mysqld ended [ I have not installed mysql from any rpm on my m/c ] Can anyone please help me out as to how to solve this problem. Deepanshu [KReSIT -IIT Bombay] __ 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: Can Mysql search full text fast through 3.3 million text documents?
In the last episode (Oct 19), Barbara Ferrell said: We have 3.3 million text documents ( U.S. Patents) that we can put into any format needed to import into any database needed. Would Mysql be able to handle fast FULLTEXT searching? Each document has several fields that would need to be searched, for example: we would want to search all 3.3 million documents for the database and relation, and sometimes limit the search to specific fields per document. .the database is about 200 gigs. Mysql 4.0's Fulltext support is not efficient enough for tables with this many records. A better solution for now is to do your own fulltext processing outside of mysql. My solution is to have a mediumint auto_increment value on my main table, then create a words table with this layout: CREATE TABLE words ( id mediumint(9) NOT NULL auto_increment, word varchar(25) NOT NULL, doclist longblob, PRIMARY KEY (id), UNIQUE KEY (word) ) doclist is an array of 4-byte integers representing the docid of each document in the main table containing a particular word. To add a document to the index, you split it into words, pull the doclist for each word, add the document's ID to the doclist, and update MySQL. For more efficient updates, you can process multiple docuemnts at a time, cache the updated 'doclist' arrays between runs, and only update the 'words' table at the end of the run. My method can process about 100 documents/second with flushes every 2000 documents on a p6/200. It would probably go 500 docs/sec if I only flush at the very end of a run, since the majority of the time is spend pulling doclists from mysql. To process queries, you simply pull the doclists of each word in your query and do set math on the arrays. Extremely fast. My test table of 3.5 million 60-byte entries (250 MB table) creates a 50 MB words table with 213000 words. You can cut the size down by 50% by simply compressing the doclist before storing it in mysql. By contrast, creating a Mysql fulltext index on the same data creates a 500MB index, and is 100 times slower to search. -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: fulltext not for me/alternatives
Hi! On Oct 21, Mark Maunder wrote: Ben Edwards wrote: I have a bit of a problem with using freetext indexes because there are a LOT of important 3 letter words in my database and as I am using shared hosting so do not have the option to recompile MySql. Can't quite figure why 3 is not the default (car, dog, cat war, man, bed, ). Maybe so you would have to recompile to be able to find s_e_x ;). Is there a way to get mysql to change the default from 3 to 2 letter words (or less) that are ignored in fulltext indexes? I'm running version 4 alpha. I checked the TODO and it's not listed. Is it possible to make this a config.h option? A minimum of 4 letters for a word to be included in a fulltext index seems a bit restrictive. Well, if it's not in the todo, it's probably, already done, isn't it ? See the manual, and SHOW VARIABLES LIKE 'ft_%' Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: fulltext not for me/alternatives
Is there a way to get mysql to change the default from 3 to 2 letter words (or less) that are ignored in fulltext indexes? I'm running version 4 alpha. I checked the TODO and it's not listed. Is it possible to make this a config.h option? As I said I am on a shared host and don't have the option to recompile MySQL. The answer is yes, it is in an .h file (or something like that). A minimum of 4 letters for a word to be included in a fulltext index seems a bit restrictive. My point exactly ;) But this is what it is (4 letters). Penelizes us non hardcore commercial users who can't afford our own box. The latest documentation categorically states there is no other way of changing this. ** * Ben Edwards+352 091 429995 * * Homepagehttp://www.gifford.co.uk/~bedwards * * i-Contact Progressive Videohttp://www.videonetwork.org * * Smashing the Corporate image http://www.subvertise.org * * Bristol's radical newshttp://www.bristle.co.uk * * PGP : F0CA 42B8 D56F 28AD 169B 49F3 3056 C6DB 8538 EEF8 * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
fulltext not for me/alternatives
I have a bit of a problem with using freetext indexes because there are a LOT of important 3 letter words in my database and as I am using shared hosting so do not have the option to recompile MySql. Can't quite figure why 3 is not the default (car, dog, cat war, man, bed, ). Maybe so you would have to recompile to be able to find s_e_x ;). The other thing I cant figure out is how much data you need for it to actually work well. There is a reference in the manual saying it works better on bigger data sets but no indication as to what it means by big. Anyway, this means I am looking for an alternative which can be implemented on php4. Has anyone any suggestions? Ben 3.23.41-log Also in the manual it mentions freetext search ** * Ben Edwards+352 091 429995 * * Homepagehttp://www.gifford.co.uk/~bedwards * * i-Contact Progressive Videohttp://www.videonetwork.org * * Smashing the Corporate image http://www.subvertise.org * * Bristol's radical newshttp://www.bristle.co.uk * * PGP : F0CA 42B8 D56F 28AD 169B 49F3 3056 C6DB 8538 EEF8 * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: fulltext not for me/alternatives
Ben Edwards wrote: I have a bit of a problem with using freetext indexes because there are a LOT of important 3 letter words in my database and as I am using shared hosting so do not have the option to recompile MySql. Can't quite figure why 3 is not the default (car, dog, cat war, man, bed, ). Maybe so you would have to recompile to be able to find s_e_x ;). Is there a way to get mysql to change the default from 3 to 2 letter words (or less) that are ignored in fulltext indexes? I'm running version 4 alpha. I checked the TODO and it's not listed. Is it possible to make this a config.h option? A minimum of 4 letters for a word to be included in a fulltext index seems a bit restrictive. tnx! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Proposed Guidelines for Posting to the MySQL list
- Original Message - From: Robert Alexander [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, October 21, 2001 1:29 PM Subject: Proposed Guidelines for Posting to the MySQL list There's been some discussion recently on the need for a FAQ and posting guidelines for the MySQL list. I got to thinking about that... : That's great! Overall, I think that these guidelines have a lot of merit, but I can't help but feel that they should be coming more from MySQL AB, than the list itself. If they have a vision for the resource that the mailing lists should provide, then its guidelines should come from MySQL AB. - Replies are directed to the POSTER and not to the list. This keeps traffic and clutter down. This is one of the few points I disagree with. The archives of this list, if used properly, is probably one of the best support resources out there right now. One of the reasons is because there tends to be some back-and-forth until a correct answer is determined. Following the thread of responses to a particular query can be of great benefit. The antithesis of this rule is that individual posters MAY NOT be contacted. This prevents the experts on the list from being flooded with direct queries, which does not benefit the list as a whole. I know that when I am directly contacted, either out of the blue or as a follow-up to an answer, I encourage the writer to post to the list since providing answers one-on-one does not benefit the list. Therefore, I would propose that the guidelines include that all questions answers (when relevant) remain on the appropriate MySQL list. - Job postings, requests for jobs, sales pitches, etc. Get permission from the MySQL staff first, or use the appropriate newsgroup instead. If I remember correctly, the MySQL lists are open - you do not have to be a member to post to the list. As long as the lists remain this way, they will always be open to these kinds of postings, including outright spam. There is a filter in place, but my understanding is that any letter beginning with Dear MySQL community: (or some variation containing MySQL) will get through. I think you would have to work with the MySQL staff to really tighten the list to meet stricter requirements. Note also that there's a good chance your question has been answered in the past. Please spend a minute or two checking one of the MySQL List archives, eg. the one at the MySQL site (http://lists.mysql.com/). See above; this archive is a great resource because all answers stay on the list - we should definitely try to keep it this way. Good Luck, Dennis Salguero ** Beridney Computer Services [EMAIL PROTECTED] http://www.beridney.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: Proposed Guidelines for Posting to the MySQL list
Re: Proposed Guidelines for Posting to the MySQL list - Replies are directed to the POSTER and not to the list. This keeps traffic and clutter down. This I think is the only point that I have an issue with. If you look above, there are two (at least right now) replies posting that this is a bad idea. however if all those replies went to the recepient, I wouldn't have known that this is posted and would post the same thing again. Another problem: suppose there are two solutions: a well known and not so well known. Suppose someone asks something and the first thing people do is send the well known idea. However if that doesn't work, since there is no feedback, noone even thinks to send the secondary rare idea (that might not even come to mind). Also, someones reply might be helpful but not great and someone else on the list might, looking at the reply, come up with an even better posting. The problem here is that usually posters will get a gazillion mails with same reply instead of two or three with possibly unique solutions. All of these lead me to believe that having the replies sent to the list is better and serves the community better. OT: BTW, can you email me a pointer to the SunManagers list? Is it the one at sunmanagers.org? Cause I thought that one was ran by MrBill. If it's that one, then no link is needed, I am subscribed to that one. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 system user and permission
PLEASE CC ME BECAUSE I'M NOT IN THE LIST... Thanks! I'm having a problem: ERROR 1017: Can't find file: './mysql/adminedit.frm' (errno: 13) I've searched in the archive and find a solution. It says that is a permission problem and to make all the files owned by mysql.mysql. This works, but I want to make some users to have they own databases. I thought making something like this: drwxrws---2 user mysql1024 Jun 12 18:21 user -rw-rw1 user mysql 75602 Sep 2 13:12 user/table.ISD -rw-rw1 user mysql6144 Sep 2 13:12 user/table.ISM -rw-rw1 user mysql8654 Jun 12 18:21 user/table.frm So the user own the table but mysql can read/write to database (as well as administrators that belongs to mysql group). The problem is I still getting this error... the only way to avoid it is to set mysql user as owner... why is this? Is there a way to do what i want to do? Why even when mysqld is running as mysql (in mysql group) or root it can't read the files? root 8703 0.0 0.0 24600 ?SW Oct17 0:00 [safe_mysqld] mysql 8737 0.0 2.4 37348 1124 ?SOct17 0:00 \_/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/my mysql 8740 0.0 2.4 37348 1124 ?SOct17 0:01 \_/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/my mysql 8741 0.0 2.4 37348 1124 ?SOct17 0:00 \_/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/my mysql 8742 0.0 2.4 37348 1124 ?SOct17 0:00 \_/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/my Thanks! -- LUCA - Leandro Lucarella [EMAIL PROTECTED] http://www.luca.2y.net LICQ UIN: 2847576 Usando Debian GNU/Linux - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Performance Question
On Sun, Oct 21, 2001 at 08:41:45PM +0100, Ronan Minogue wrote: Dear Sir/Madam. I have written a Management Information System that has a MySQL db running on a Linux server. There is quite a small number of tables. However these tables are growing quickly and the queries executed will require LEFT OUTER JOIN between tables. Example: A sample query over 4 tables using LEFT OUTER JOIN Table A 11000 rows Table B 15000 rows Table C 18000 rows Table D 2,500,000 rows Table D will over a year will reach values of 10 to 15 million records. Are you aware of any benchmarks / examples of expected response time?? Spend 20 minutes and fill table D with a lot of data and see how it performs. If it's not fast enough, look tweaking MySQL's settings (as described in the manual) for higher performance. With the detail you've given us so far, it's nearly impossible to predict the results. 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 45 days, processed 999,195,609 queries (252/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: Proposed Guidelines for Posting to the MySQL list
Robert Alexander wrote: - Replies are directed to the POSTER and not to the list. This keeps traffic and clutter down. At 22:12 +0100 2001/10/21, Mark Maunder wrote: Other authors wont be able to participate in a discussion and there wont be the public aggregation of viewpoints - just a reliance on the original poster (many of whom are newbies) to consolidate all replies they receive and post a coherent summary based on individual emails. At 14:45 -0700 2001/10/21, Dennis Salguero wrote: This is one of the few points I disagree with. The archives of this list, if used properly, is probably one of the best support resources out there right now. One of the reasons is because there tends to be some back-and-forth until a correct answer is determined. Following the thread of responses to a particular query can be of great benefit. At 18:19 -0400 2001/10/21, Victor wrote: This I think is the only point that I have an issue with. If you look above, there are two (at least right now) replies posting that this is a bad idea. however if all those replies went to the recepient, I wouldn't have known that this is posted and would post the same thing again. Thanks so much for taking the time to respond, guys. There does seem to be a general consensus about keeping more discussion on the list. I confess it's one of the points I thought longest about. The SunManagers list is much more of an I need a solution NOW kind of list, whereas the MySQL list has always had more open discussion. As a matter of fact, the SunManagers list has no discussion whatsoever. Ideally, the only postings there are question and summary. It doesn't always happen that way, of course, but that's what's strived for in that list. I don't think I'd want the MySQL list to be completely 'discussion free' either. That's why I included this: In particular, the following kinds of postings are NOT appropriate: snip - Extended discussions about anything, including discussions about the list itself, or numerous followups to any posting. Which would allow for some discussion, just not long, wandering, rambles. : Is that enough? Do we need more? How do we walk the line between keeping lively discussion, and reducing the bulk of postings? (open for ideas...) --- At 14:45 -0700 2001/10/21, Dennis Salguero wrote: That's great! Overall, I think that these guidelines have a lot of merit, but I can't help but feel that they should be coming more from MySQL AB, than the list itself. If they have a vision for the resource that the mailing lists should provide, then its guidelines should come from MySQL AB. Thanks Dennis. IRT MySQL AB, I don't think I'm stepping on anyone's toes, here, and it's certainly not my intent to dictate policy to the list or anyone else. If I am, I'm sure someone from MySQL will let me know, at which point I'll gracefully bow out. This is simply a proposed set of guidelines, meant to stimulate an exchange of ideas, and lead to an even better discussion group. This is an Open Source community, after all, : and I think it's important to contribute. I'm just trying to do a bit of my part, even if it's a relatively small task like this. Whatever 'culture' or 'style' our on-line list community has is ultimately determined by the actions of the individual people involved. If we can collectively agree on some basic rules, we all benefit. --- At 18:19 -0400 2001/10/21, Victor wrote: Another problem: suppose there are two solutions: a well known and not so well known. Suppose someone asks something and the first thing people do is send the well known idea. However if that doesn't work, since there is no feedback, noone even thinks to send the secondary rare idea (that might not even come to mind). Also, someones reply might be helpful but not great and someone else on the list might, looking at the reply, come up with an even better posting. The problem here is that usually posters will get a gazillion mails with same reply instead of two or three with possibly unique solutions. At 14:45 -0700 2001/10/21, Dennis Salguero wrote: See above; this archive is a great resource because all answers stay on the list - we should definitely try to keep it this way. Well, if people post their summaries, then the answers WILL always be in the archives, won't they. : And in a more concise, usable form because you won't need to search through multiple messages to find that bit of wisdom you need. Also, I've seen it happen often that someone may read a SUMMARY and realize that they have something to add to the solution. That idea is also sent off the original question-asker, who posts another summary. It's not uncommon to see second, and sometimes even third, summaries to the same question. Thanks, /Rob - Before
Re: Re: fulltext not for me/alternatives
This is kind of nuts! list blocking stuff without a VERY narrow number of words in it. Doesn't even contain MySQL in the list ;) At 07:35 P 21/10/01, you wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table See the manual, and SHOW VARIABLES LIKE 'ft_%' Looks like this is something new to 4. My ISP has 20+ db servers so reckon it will be a while before they roll 4 out. Will email them. Thanks for the info. However this douse not help me in the immediate future and I still need to find a alternative fullsearch method. Ben ** * Ben Edwards+352 091 429995 * * Homepagehttp://www.gifford.co.uk/~bedwards * * i-Contact Progressive Videohttp://www.videonetwork.org * * Smashing the Corporate image http://www.subvertise.org * * Bristol's radical newshttp://www.bristle.co.uk * * PGP : F0CA 42B8 D56F 28AD 169B 49F3 3056 C6DB 8538 EEF8 * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Proposed Guidelines for Posting to the MySQL list
On Sun, Oct 21, 2001 at 04:29:45PM -0400, Robert Alexander wrote: Hi everyone, I belong to another list, called the SunMangers list. (I'm sure there's other SunMangers members here. Hi! : ) The SunManagers list is a wonderful resource for getting timely help for those times when you're stuck and just can't get something to work correctly. Some of the top people in the Sun world are on that list, and they can be very generous with their time to help others. SunManagers is an excellent list to model in some ways. So, here's the proposed Guidelines. Take a look. Thoughts and constructive comments are welcome and encouraged. Flames go to /dev/null : [snip] One of the things that most deters me from helping someone is when they post SQL in a format which requires me to mentally reformat it just so I can understand what it does. When I see that, I usually hit D and go on. Strongly suggest that folks post CLEAN and READABLE code (SQL, Perl, PHP, whatever) otherwise those of us without the time to reformat someone else's laziness will just blow past it. 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 45 days, processed 999,429,709 queries (252/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: Error codes list
From http://www.mysql.com/doc/n/o/node_567.html For the connection specified by mysql, mysql_errno() returns the error code for the most recently invoked API function that can succeed or fail. A return value of zero means that no error occurred. Client error message numbers are listed in the MySQL `errmsg.h' header file. Server error message numbers are listed in `mysqld_error.h'. In the MySQL source distribution you can find a complete list of error messages and error numbers in the file `Docs/mysqld_error.txt'. Steve Meyers -Original Message- From: Javier Armendáriz [mailto:[EMAIL PROTECTED]] Sent: Sunday, October 21, 2001 5:49 AM To: DL Neil; [EMAIL PROTECTED] Subject: Re: Error codes list Thanks a lot, as you know, I need to translate error codes (such as duplicate references) to the future (i hope) program operator. The error codes are for operators (those who write data into the catalog), not for public, I know PHP error reporting functions with MySQL, but i would like to write some functions to analize errors when they happend, break the program execution and tell operators what is happending (in spanish and in a language they could understand). What i´m looking for is a complet lits in some way like this : Error code numbrer (not DEFCON 5 :-)) Error descripcion Thanks a lot for your interest and help Apologize my macarronic english, when i get rich with this progect i´ll travel to great britain in order to learn some good english (and taste english beer and women) At 12:02 21/10/01 +0100, DL Neil wrote: Hi Maybe it is in the manual, but i can´t find it in the way i need. Does anybody know where to find a complet list of MySQL error codes with number and descripcion in order to make a library for handling and reporting alerts to users in php Hola Javier, Yes it is in the manual - but try the PHP manual (not MySQL's). The PHP online annotated manual is 'down' at the moment (update happening?) so I can't give you a reference - apologies. In addition to the familiar PHP-MySQL functions, eg mysql_query($sqlQuery, $dbLink) There are two more: mysql_errno() and mysql_error() which return an error number and error text (from the 'latest' MySQL function executed) - or zero and empty-string if the execution 'worked'. It's important to perform error-checking, but some would suggest that it should not be reported to users - under 'normal' circumstances!? Regards, =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Preferences Table
On Sat, Oct 20, 2001 at 01:11:30PM -0700, Mike E wrote: I've been having this debate in my mind and alternated my method on the past few projects I've worked on, and now I ask you, the MySQL community. What is the best way to have a preferences table? Here's what I've been doing: Table preferences basepath varchar(255) adminemail varchar(255) and on and on, a different field for each variable I want stored. Alternatively: Table preferences key varchar(255) value text With a different row for each variable. This is much more dynamic, but is it worth the extra coding? Yes, normalizing your data is almost always worth it. Consider what happens when you need to add two new fields, or remove one. 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 45 days, processed 999,890,411 queries (252/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
Binlog rotation for a mysql master server
Something that is not entirely clear about the mysql binary logs in the documentation is whether the mysql daemon itself begins to write logs with different names at different points in time, or if it simply writes to .001 and your logrotate daemon (perhaps as directed by mysql's bundled logrotate scripts) rotates out old files at intervals. The reason that this is confusing to me is because we have two different almost congruent setups, and on one of them the mysql binary logs rotate by themselves (new logs get created at intervals, and all the logs are recorded in the binary log index file) and we can safely restart our master mysql daemon, but on the other setup the logs do not appear to rotate, and restarting the mysql master daemon causes all heck to break loose. The slaves begin trying to read from non-existant log files, and the master truncates the only log file it wants to write to (.001) and starts it over. All the mysql servers we have are version 3.23.36 running on Linux 7.1 kernel 2.4.5 and 2.4.12 (the ones that were rotating correctly were on kernel 2.4.12, but the newest available rpm was 2.4.5 and we're not authorized to run experimental kernels on our production machines). We have a replicate-ignore-wild-tables=mysql.* as our only relevant replication setting. So has anyone else ever seen this kind of problem before, or else could somebody shed some light on what mysql's dogma is so far as when and how it rotates it's binary logs? I'm familiar with how a bloke can purge to to delete older logs, but I'm interested in how the logs get seperated into different files in the first place. Thanks for listening :) - - Jesse Thompson bend.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
FREE! God Bless America Bracelet!
Hi Sir/Madam, Your email address has abeen entered into our database of persons interested in receiving a free God Bless America bracelet. If this is a mistake ignore this email or reply with Remove in the subject line. If this is not a mistake reply to this link: [EMAIL PROTECTED] with Bracelet in the subject line and include your name and address and it will be mailed to you free of charge. This offer is for individuals who are not currently a member of FAN. If you prefer you may receive a free bracelet with the following caption: Miracles Happen, Parent Power, Attitude is Everything, One World - One People, Above All - Stay Focused, Full-Time Parent, I Believe, Faith Is Power, All Things Are Possible, God does Not Make Junk, Don't Sweat the Small Stuff or Share a Little Kindness If no preference is indicated you will receive the God Bless America bracelet. By accepting this offer you will become a member of FAN free of charge and receive all benefits including free certificate, access to free newsletter, free catalogue and free decal. There is no obligation to purchase anything ever. Thank you. Your help is much appreciated. With warmest regards, Kathy Fetterling - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How can I turn on Raid support in windows 2k
I downloaded MySql v3.23.43 binaries to see if I could make use of the system for my database 'stuff'. I have several tables that when loaded will be 2gb and the concept of raid support would be appealing. Raid does not seem to be enabled on the default download. Because of this I downloaded the source files and attempted to turn Raid on. I went thought the code and changed: /* Use MySQL RAID */ /* #undef USE_RAID */ to /* Use MySQL RAID */ #define USE_RAID 1 I made this change based on the other options that were turned on. I the rebuilt with MS VC++ 6.0 Enterprise. But when I run mysqld-nt.exe Raid is still not enabled. What have I done wrong? Can anyone help? Thank you. Butch Bean Informative Software Computer [EMAIL PROTECTED] PH: (856) 858-5135 FX: (856) 858-2224 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Field Naming Standards
ummm, is there any thing wrong with using the Naming Convention devloped by Stan Leszynski and Greg Reddick, authors of Access 97 books? Their conventions would creat this: tblNews intpkNewsID intfkUsersID datPosted varSubject txtContent blnBoolean tblUsers intpkUsersID intfkNewsID varName pk = primary key fk = foreign key The capitals are my preference. - Original Message - From: Mike E [EMAIL PROTECTED] To: ryc [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, October 20, 2001 3:36 PM Subject: Re: Field Naming Standards That seems to follow how I've been doing it as well. For example, consider this database set up: Table: news Fields: newsid int(10) userid int(10) dateposted datetime subject varchar(255) content text Table: users Fields: userid int(10) name varchar(60) and on and on. I'd love to hear from some hard-core developers. Guys who have been doing database development professionally for years. Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Field Naming Standards
On Sun, Oct 21, 2001 at 09:40:16PM -0400, howard gramer wrote: ummm, is there any thing wrong with using the Naming Convention devloped by Stan Leszynski and Greg Reddick, authors of Access 97 books? Their conventions would creat this: tblNews intpkNewsID intfkUsersID datPosted varSubject txtContent blnBoolean Wow, that's rather cluttered. I'd rather use a readable standard. Won't it be a bit strange when you run SHOW TABLES and you get a bunch things back all that being with tbl? When you program, do you prefix every variable name with var? Every function name with func? Every macro with mac? Do the filenames on your computer all begin with file and folders fldr? 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 45 days, processed 1,000,376,140 queries (252/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: How can I turn on Raid support in windows 2k
Thanks for the thoughts... I changed the or, if you are using MSVC, add USE_RAID to the defines in the IDE. This created a new set of problems when I did as well. On the Unix version the instructions are rather clear and they work (I have turned Raid on Linux already). There are no specific directions for the Windows version which has left me at my dilemma. For many reasons I need windows and Unix versions to work in a similar fashion. Butch -Original Message- From: James Barwick [mailto:[EMAIL PROTECTED]] Sent: Sunday, October 21, 2001 9:46 PM To: [EMAIL PROTECTED] Subject: Re: How can I turn on Raid support in windows 2k Butch Bean wrote: I downloaded MySql v3.23.43 binaries to see if I could make use of the system for my database 'stuff'. I have several tables that when loaded will be 2gb and the concept of raid support would be appealing. Raid does not seem to be enabled on the default download. Because of this I downloaded the source files and attempted to turn Raid on. I went thought the code and changed: /* Use MySQL RAID */ /* #undef USE_RAID */ to /* Use MySQL RAID */ #define USE_RAID 1 I made this change based on the other options that were turned on. I the rebuilt with MS VC++ 6.0 Enterprise. But when I run mysqld-nt.exe Raid is still not enabled. What have I done wrong? Can anyone help? Thank you. Butch Bean Informative Software Computer [EMAIL PROTECTED] PH: (856) 858-5135 FX: (856) 858-2224 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Hmmm...what are you doing wrong...well, first...stop trying to compile things when you don't know WHAT your doing ;) try not to take offense, however, your question is VERY scary...don't modify code when you're clueless. You must set the define in the Makefile. for example: #./configure --enable-raidthe enable option is probably wrong hereuse ./configure --help for a list or #setenv CFLAGS=$CFLAGS -DUSE_RAID or, if you are using MSVC, add USE_RAID to the defines in the IDE. These are just pointers...haven't compiled anything in winbloze in 6 years. Good luck! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
synopsis of the problem (one line)
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator: Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.23.39 (Source distribution) Environment: System: Linux info 2.4.5 #17 SMP Thu Sep 20 04:23:22 EEST 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-slackware-linux/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Sep 14 16:02 /lib/libc.so.6 - libc-2.2.3.so -rwxr-xr-x1 root root 4783716 May 26 04:03 /lib/libc-2.2.3.so -rw-r--r--1 root root 24721042 May 26 04:00 /usr/lib/libc.a -rw-r--r--1 root root 178 May 26 04:00 /usr/lib/libc.so Configure command: ./configure --prefix=/usr --with-mysqld-user=mysql --with-unix-socket-path=/var/run/mysql/mysql.sock --localstatedir=/var/lib/mysql --with-pthread --enable-thread-safe-client --enable-assembler --with-raid --with-libwrap --without-bench i386-slackware-linux - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Field Naming Standards
H Jeremy! tblNews intpkNewsID intfkUsersID datPosted varSubject txtContent blnBoolean Wow, that's rather cluttered. I'd rather use a readable standard. Won't it be a bit strange when you run SHOW TABLES and you get a bunch things back all that being with tbl? So make them easier to read such as tbl_news and bln_boolean. Or shorten it a little with tb_news and tx_content. It's not as weird as you think. If you get back a column of stuff all prefixed with tbl_ your eye will simply slide over it and ignore it. The table that is returned -without- a tbl_, or the one with the thl_ typo will stand out like a sore thumb as an obvious error and maybe even help fix whatever problem you're troubleshooting. When you program, do you prefix every variable name with var? Every function name with func? Every macro with mac? Vars, no, because there are more of them than anyting else. The word that -doesn't- have a prefix is a var. :) But everything else, yes. Because even though it's clear in my head 'now' what I'm doing, I *know* that six months down the road when I look at it again I won't remember -anything!- LOL! Been there done that wy too many times to not plan ahead for brain-fade. Do the filenames on your computer all begin with file and folders fldr? No, because I have no files on my computer that aren't files, and I have no subdirectories that don't have a 'd' at the top of the line. :) But I don't have any perl scripts that aren't *.pl or SSI includes that aren't *.inc. The point of all this is to make it it easier to read -later-. A tbl_ is clearly a table and a b_ is clearly a boolean without having to think about it or 'remember' or look it up elsewhere. Such as 'I need to test this variable but is it a boolean or a text, now I gotta go find where it's defined.' Writing code is easy. Today. Troubleshooting an obscure error months later, or modifying things to add a new feature is -work-. :) A little up front efort -will- help further down the line. Have a :) day! -- 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 CLIENT
Hi June! How can i connect mysql client to the mysql server? Does mysql need to be installed on the client as well? Mysql -is- the client. Mysqld is the server. The client can talk to any server anywhere -if- it has appropriate permissions. You do not need to have mysqld installed locally to talk to a remote database. 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: Field Naming Standards
On Sun, Oct 21, 2001 at 11:40:05PM -0400, jim barchuk wrote: The point of all this is to make it it easier to read -later-. A tbl_ is clearly a table and a b_ is clearly a boolean without having to think about it or 'remember' or look it up elsewhere. Such as 'I need to test this variable but is it a boolean or a text, now I gotta go find where it's defined.' Writing code is easy. Today. Troubleshooting an obscure error months later, or modifying things to add a new feature is -work-. :) A little up front efort -will- help further down the line. Have you ever read The Pratice of Programming? http://shopping.yahoo.com/shop?d=bid=3600417 If not, I'd highly recommend it. It's a short book, but a really good read. 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 45 days, processed 1,001,475,325 queries (252/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
what does it mean Open_files?
Hi, after some testing on a new db, I have this status: [root@rachab /root]# mysqladmin e | grep "onn\|pen.*es" | Aborted_connects | 12 | | Connections | 150194 | | Max_used_connections | 24 | | Open_tables | 0 | | Open_files | 7909 | | Opened_tables| 222981 | | Slave_open_temp_tables | 0 | | Threads_connected| 1 | Option open-files-limit is set to 8192. But why Open_files is 7909 when Open_tables is 0 and only one connection (own mysqladmin) is estabilished? Is there any relation in Open_files, Open_tables and Threads_connected? Manual says yes, but these numbers doesn't agree with. Could it rather be Opened_files than Open_files? Kernel shows in /proc/sys/fs/file-nr: 2155180616384 AFAIK there are about 350 open files in system. Output from lsof coresponds with kernel status: [root@rachab /root]# lsof | grep mysqld | wc 1131005 10028 RH 7.1, kernel 2.4.3-12enterprise, mysql-3.23.42-1 (rawhide) with modified convert.cc (#define DEFINE_ALL_CHARACTER_SETS). File my.conf: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock default-character-set=czech language=czech log set-variable = key_buffer_size=16M set-variable = max_allowed_packet=10M set-variable = max_connections=200 set-variable = record_buffer=1M set-variable = sort_buffer=4M set-variable = table_cache=512 set-variable = tmp_table_size=8M skip-innodb [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid open-files-limit=8192 -- Ing. Michal ejdl e-mail: [EMAIL PROTECTED] Sokolovsk uheln, a.s. tel.: +420 168 46-5418 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Field Naming Standards
- Original Message - From: [EMAIL PROTECTED] To: Yiu Wing [EMAIL PROTECTED] Sent: Sunday, October 21, 2001 9:52 PM Subject: Re: Re: Field Naming Standards 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: Have you ever read The Pratice of Programming? http://shopping.yahoo.com/shop?d=bid=3600417 If not, I'd highly recommend it. It's a short book, but a really good read. This is a great book. I bought it a year ago, but I'm still reading it, cos' it's just so juicy ;-). There are lots of good guide lines for common programming practise, such as, naming convention, etc. It's definitely worth having it. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Binlog rotation for a mysql master server
On Sun, Oct 21, 2001 at 05:59:47PM -0700, Jesse Thompson wrote: Something that is not entirely clear about the mysql binary logs in the documentation is whether the mysql daemon itself begins to write logs with different names at different points in time, or if it simply writes to .001 and your logrotate daemon (perhaps as directed by mysql's bundled logrotate scripts) rotates out old files at intervals. The binlog can be rotated for several reasons: (1) You hit the maximum size for a binlog file (max_binlog_size), as documented here: http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html (2) You restart the server. (3) You run FLUSH LOGS. http://www.mysql.com/doc/F/L/FLUSH.html (4) You send mysqld a SIGHUP. http://www.mysql.com/doc/F/L/FLUSH.html There are probably others I haven't thought of yet. 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 46 days, processed 1,001,714,194 queries (251/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
Fresh install fails to start - 'host could not be looked up'
I just installed mysql-3.23.43, apache-1.3.22, and php-4.0.6 all from source this evening (on freebsd-4.4-r). When I try to run safe_mysqld I get this; mysqld started Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists! Aboring I see in the file passwd that the user mysql does not indeed exist. I have run /bin/mysql_install_db and it appears to run okay. I checked the online docs but they always refer to running mysql_install_db to set up the mysql user. Is it okay to manually add a new user to FreeBSD called mysql? I tried this but it doesn't work still. What should I do next? -- Chip W. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Proposed Guidelines for Posting to the MySQL list
There's been some discussion recently on the need for a FAQ and posting guidelines for the MySQL list. I got to thinking about that... : cut Both already exist: FAQ: http://www.bitbybit.dk/mysqlfaq - although not created and maintained by MySQL AB, I believe it does answer most of the common questions - and I happen to know that the editor is very keen on adding stuff that others are willing to submit :-) Posting guidelines: Read The Fine Manual, ch. 1.2.22 - it's been in there forever, though most people seem to forget to either read or to follow them rant(this goes for some of the @mysql.com people too, especially the point about only including the relevant parts of the original message in a reply)/rant -- Guidelines for Posting to the MySQL list - cut There are some more good points in these guidelines. But seriously: I don't think anyone is willing to read what amounts to two or three printed pages before starting posting. Human beings are simply too lazy to do that, especially when sitting with a problem they need solved yesterday. / 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
Database Structures
Hello, Hi, I need some help on something here. I need to know the best way to set up this database. I have a site with a bunch of images/reviews. What i want is for registered users to rate and leave reviews themselves. I'm not sure how I should set up this database though. Now, I have a table that holds the user info. Should I create a new table for each image, which holds the user, and his comments/rating? (this seems rather bloated, and inefficient) or should I create a table somehow for all images and keep track of the user comments/ratings another way? Thanks. I've been looking for sites about database structuring and stuff, but no good luck. If anyone could give me sites or their ideas it would be appreciated - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php