syntax for strings in REQUIRE ISSUER / REQUIRE SUBJECT
I cannot seem to get SSL connections working using the REQUIRE ISSUER or REQUIRE SUBJECT clauses. I have a mysql working with ssl. I can connect from the client host to the server using ssl, where the user has been setup using: GRANT ALL PRIVILEGES ON x.* TO ''@'ipaddress' IDENTIFIED BY 'xx' REQUIRE X509; and the connection from client is done by mysql -h xxx -u xx -p --ssl-ca=/etc/mysql/ca-cert.pem --ssl-key=/etc/mysql/client-key.pem --ssl-cert=/etc/mysql/client-cert.pem However, the moment I try to restrict access to certs with specific issuer or subject I cannot connect GRANT ALL PRIVILEGES ON x.* TO ''@'ipaddress' IDENTIFIED BY 'xx' REQUIRE ISSUER 'C=IT, ST=Como, L=Erba, O=erba.tv, OU=erba.tv, CN=erba.tv/emailAddress=postmas...@erba.tv'; I have tried various permutations of specifying issuer string, i.e. C=IT, ST=Como, L=Erba, O=erba.tv, OU=erba.tv, CN=erba.tv/emailAddress=postmas...@erba.tv C=IT, ST=Como, L=Erba, O=erba.tv, OU=erba.tv, CN=erba.tv C=IT/ST=Como/L=Erba/O=erba.tv/OU=erba.tv/CN=erba.tv/emailAddress=postmas...@erba.tv C=IT/ST=Como/L=Erba/O=erba.tv/OU=erba.tv/CN=erba.tv but none seem to work (after flushing privileges each time). The first of these values is what is given by the command: openssl x509 -in /etc/mysql/client-cert.pem -noout -text The message I get is on trying to connect is: ERROR 1045 (28000): Access denied for user ''@'ipaddress' (using password: YES) The basics of ssl are obviously working, but for some reason the ISSUER check is not working. How can I debug that futher? John -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: [SPAM] - MS SQL emulator for MySQL in order to support MS Project Server, Sharepoint... - Email found in subject
http://blogs.ittoolbox.com/km/sharepoint/archives/sharepoint-and-mysql-2 2051 hmm.. but I think you might have problems getting support from sharepoint's vendor... IIRC they always push to use SQL server for this.. (we know the reason why.. :) ) -Original Message- From: Jacob, Raymond A Jr [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 13, 2008 7:22 PM To: mysql@lists.mysql.com Subject: [SPAM] - MS SQL emulator for MySQL in order to support MS Project Server, Sharepoint... - Email found in subject I apologize for asking this question. I am somewhat confused by Microsoft's Licensing and I personally can not justify to senior management why MS SQL should be procured instead of procuring software more urgent requirements. I had the not so bright idea that maybe a MS SQL emulator or compatibility mode existed for/in MySQL. Does such a beast exist? In particular, I wanted to use MySQL as backend database for MS Project Server and Sharepoint, and other applications that use MS SQL as their backend database. Again, I apologize for asking this question. I could not figure out the correct string to search for such software. thank you This message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom it is addressed. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. FXDirectDealer, LLC reserves the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal confirmation. FXDirectDealer, LLC is not responsible for any recommendation, solicitation, offer or agreement or any information about any transaction, customer account or account activity contained in this communication. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: [SPAM] - Re: Sun and mysql - Email found in subject
-Original Message- From: Olaf Stein [mailto:[EMAIL PROTECTED] Sent: Thursday, January 17, 2008 12:13 PM To: Peter (MySQL List); MySql Subject: [SPAM] - Re: Sun and mysql - Email found in subject You have a point. But, facebook makes NO money at this time, has about 400 employees and Microsoft estimates its values at 15 billion dollars. I simply think this is nuts. Maybe I am too old with 30, but I have never even been to facebook. It will be interesting to see if facebook, youtube and alike websites will ever generate enough earnings to cover the costs they were bought for. With a perfect business plan I bet it will. Just because 50 million people know a website, it does not mean it makes money automatically. Yes, I agree but once this 50 million visits the website and it would be a different story. Olaf On 1/17/08 11:37 AM, Peter (MySQL List) [EMAIL PROTECTED] wrote: On Thu, 17 Jan 2008 11:07:19 -0500 Olaf Stein [EMAIL PROTECTED] wrote: I am still amazed by the fact that youtube is worth 1.5 billion and MySQL AB barely 1 billion. Did they sell under price? Or does Google just have way to much many to spend/waste? On Thu, 17 Jan 2008 10:14:36 -0600 Jay Blanchard [EMAIL PROTECTED] wrote: Or that Facebook is 'worth' multiple billions when they do not really have a way to make money yet. Uh, you both have to be kidding comparing MySQL with Youtube and Facebook, right? I'm not saying the $1 billion for MySQL was the right price, I believe it was a bargain for Sun but you are comparing apples and oranges. Go out on the street and ask people if they ever heard of these three. I bet you a few people will know MySQL, a lot will know Facebook and everybody will know Youtube. Youtube and Facebook are websites, visited by millions of people every day. That's what makes it it's value, future and present advertisements. YouTube was even used by CNN for the Republican and Democratic debates. Did you ever hear of MySQL on TV, anywhere? - Confidentiality Notice: The following mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. The recipient is responsible to maintain the confidentiality of this information and to use the information only for authorized purposes. If you are not the intended recipient (or authorized to receive information for the intended recipient), you are hereby notified that any review, use, disclosure, distribution, copying, printing, or action taken in reliance on the contents of this e-mail is strictly prohibited. If you have received this communication in error, please notify us immediately by reply e-mail and destroy all copies of the original message. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] This message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom it is addressed. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. FXDirectDealer, LLC reserves the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal confirmation. FXDirectDealer, LLC is not responsible for any recommendation, solicitation, offer or agreement or any information about any transaction, customer account or account activity contained in this communication. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http
RE: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject
Big fish eats the small fish.. :) Will this bring good things to MySQL? -Original Message- From: John Meyer [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 16, 2008 8:58 AM To: Brett Harvey; mysql@lists.mysql.com Subject: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject Brett Harvey wrote: http://www.reuters.com/article/mergersNews/idUSWNAS661820080116 No offense, but this is definitely not off topic when it comes to MySQL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] This message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom it is addressed. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. FXDirectDealer, LLC reserves the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal confirmation. FXDirectDealer, LLC is not responsible for any recommendation, solicitation, offer or agreement or any information about any transaction, customer account or account activity contained in this communication. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject
Will this bring good things to MySQL? $800,000,000 tends to bring good things. Hopefully. :-) -- Richard Heyes http://www.websupportsolutions.co.uk Mailing list management service allowing you to reach your Customers and increase your sales. ** NOW OFFERING FREE ACCOUNTS TO CHARITIES AND NON-PROFITS ** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject
Richard Heyes schrieb: Will this bring good things to MySQL? $800,000,000 tends to bring good things. Hopefully. :-) ??? why, this payment goes to current owners and investors, not to MySQL itself ... but anyway, using Suns structures and power will help of course ... -- Sebastian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: [SPAM] - Re: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject - Email found in subject
Oracle and Sun has a tight relationship right? Wouldn't there be a conflict of interest? -Original Message- From: Sebastian Mendel [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 16, 2008 10:03 AM To: [EMAIL PROTECTED] Cc: Jerome O. Macaranas; mysql@lists.mysql.com Subject: [SPAM] - Re: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject - Email found in subject Richard Heyes schrieb: Will this bring good things to MySQL? $800,000,000 tends to bring good things. Hopefully. :-) ??? why, this payment goes to current owners and investors, not to MySQL itself ... but anyway, using Suns structures and power will help of course ... -- Sebastian This message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom it is addressed. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. FXDirectDealer, LLC reserves the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal confirmation. FXDirectDealer, LLC is not responsible for any recommendation, solicitation, offer or agreement or any information about any transaction, customer account or account activity contained in this communication. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: [SPAM] - Re: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject - Email found in subject
I was lurking on Sun's website.. they are also carrying PostgreSQL in their line of products.. Great!! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 16, 2008 10:07 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: RE: [SPAM] - Re: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject - Email found in subject Oracle and Sun has a tight relationship right? Wouldn't there be a conflict of interest? -Original Message- From: Sebastian Mendel [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 16, 2008 10:03 AM To: [EMAIL PROTECTED] Cc: Jerome O. Macaranas; mysql@lists.mysql.com Subject: [SPAM] - Re: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject - Email found in subject Richard Heyes schrieb: Will this bring good things to MySQL? $800,000,000 tends to bring good things. Hopefully. :-) ??? why, this payment goes to current owners and investors, not to MySQL itself ... but anyway, using Suns structures and power will help of course ... -- Sebastian This message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom it is addressed. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. FXDirectDealer, LLC reserves the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal confirmation. FXDirectDealer, LLC is not responsible for any recommendation, solicitation, offer or agreement or any information about any transaction, customer account or account activity contained in this communication. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Subject: determining if tables are being used
Keith, The definitive way is to turn on the query log and watch it for a few days or weeks. In your my.cnf under [mysqld] add the line: log=mysql-query Then restart your server. In your server's data directory (e.g. /usr/local/mysql/data/), there will now be a log file called mysql-query.log. After some time there may be one for each day, week or size interval. This file, 'mysql-query.log' shows all queries and can be opened, cat'd, tailed, etc. Using the query log impacts performance, comment out the line and restart mysql when you're done. Link to the mysql doc: http://dev.mysql.com/doc/refman/5.0/en/query-log.html -sean On 6/11/07, Keith Murphy [EMAIL PROTECTED] wrote: I have inherited database servers from a group whose main job was not working on mysql. I am not certain if all the tables on the databases are being used. Is there some efficient way of determining if a table is being accessed or when the last time it was accessed? Thanks, Keith -- Keith Murphy Database Administrator iContact 2635 Meridian Parkway, 2nd Floor Durham, North Carolina 27713 (o) 919-433-0786 (c) 850-637-3877
RE: MySQL 5.0.18-standard - Wrong record (sorry, I cannot find a better subject)
Hello, I wanted only to report that I removed and re-added the Index as Martijn suggested and now it's OK. Thanks again for your help Regards, Patrick -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 5.0.18-standard - Wrong record (sorry, I cannot find a better subject)
Hello! I'm using MySQL 5.0.18-standard Server on a Linux SuSE 10 Server and I've got following problem: I have a table with the followign structure +-+--+--+-+---+- ---+ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+---+- ---+ | STEP_ID | int(10) unsigned | NO | PRI | NULL | auto_increment | | INVOICE_ID | int(10) unsigned | NO | MUL | 0 | | | STEP_TYPE_ID| smallint(5) unsigned | NO | MUL | 0 | | (some other field) ... +-+--+--+-+---+- ---+ When I execute following statement SELECT STEP_ID, INVOICE_ID, STEP_TYPE_ID FROM step WHERE INVOICE_ID=17081598; I get this result +--++--+ | STEP_ID | INVOICE_ID | STEP_TYPE_ID | +--++--+ | 47870211 | 17081598 |1 | | 47870212 | 17081598 |4 | | 47870214 | 17081599 |1 | !! +--++--+ As you can see there is a record with INVOICE_ID=17081599. Please note that if I ask for mysql SELECT STEP_ID, INVOICE_ID, STEP_TYPE_ID FROM step WHERE INVOICE_ID=17081599; I also receive that record: +--++--+ | STEP_ID | INVOICE_ID | STEP_TYPE_ID | +--++--+ | 47870214 | 17081599 |1 | | 47870215 | 17081599 |4 | | 47870216 | 17081599 |3 | +--++--+ Interesting is also that no record with STEP_ID=47870213 is visible. I wrote visible and not present, because if I try to insert a new Record with this PK I get this error mysql INSERT INTO step (STEP_ID, INVOICE_ID, STEP_TYPE_ID) VALUES (47870213, 17081598, 3); ERROR 1062 (23000): Duplicate entry '47870213' for key 1 However: mysql SELECT * FROM step where STEP_ID=47870213; Empty set (0.00 sec) The problem for me is that I also collect a statistic from this come out wrong, because when I ask for mysql SELECT COUNT(*) FROM step WHERE INVOICE_ID IN (17081598,17081599) AND STEP_TYPE_ID=1; I get, instead of 2: +--+ | COUNT(*) | +--+ |3 | +--+ Can you please tell me what the problem could be and what can I do to solve it? Thanks a lot! Regards, Patrick -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 5.0.18-standard - Wrong record (sorry, I cannot find a better subject)
Patrick, I'm using MySQL 5.0.18-standard Server on a Linux SuSE 10 Server and I've got following problem: I have a table with the followign structure +-+--+--+-+---+- ---+ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+---+- ---+ | STEP_ID | int(10) unsigned | NO | PRI | NULL | auto_increment | | INVOICE_ID | int(10) unsigned | NO | MUL | 0 | | | STEP_TYPE_ID| smallint(5) unsigned | NO | MUL | 0 | | (some other field) ... +-+--+--+-+---+- ---+ When I execute following statement SELECT STEP_ID, INVOICE_ID, STEP_TYPE_ID FROM step WHERE INVOICE_ID=17081598; I get this result +--++--+ | STEP_ID | INVOICE_ID | STEP_TYPE_ID | +--++--+ | 47870211 | 17081598 |1 | | 47870212 | 17081598 |4 | | 47870214 | 17081599 |1 | !! +--++--+ As you can see there is a record with INVOICE_ID=17081599. Please note that if I ask for mysql SELECT STEP_ID, INVOICE_ID, STEP_TYPE_ID FROM step WHERE INVOICE_ID=17081599; I also receive that record: +--++--+ | STEP_ID | INVOICE_ID | STEP_TYPE_ID | +--++--+ | 47870214 | 17081599 |1 | | 47870215 | 17081599 |4 | | 47870216 | 17081599 |3 | +--++--+ Interesting is also that no record with STEP_ID=47870213 is visible. I wrote visible and not present, because if I try to insert a new Record with this PK I get this error mysql INSERT INTO step (STEP_ID, INVOICE_ID, STEP_TYPE_ID) VALUES (47870213, 17081598, 3); ERROR 1062 (23000): Duplicate entry '47870213' for key 1 However: mysql SELECT * FROM step where STEP_ID=47870213; Empty set (0.00 sec) The problem for me is that I also collect a statistic from this come out wrong, because when I ask for mysql SELECT COUNT(*) FROM step WHERE INVOICE_ID IN (17081598,17081599) AND STEP_TYPE_ID=1; I get, instead of 2: +--+ | COUNT(*) | +--+ |3 | +--+ Can you please tell me what the problem could be and what can I do to solve it? Corrupt index? Do you have indices on INVOICE_ID? If so, try dropping it and recreating it? Martijn Tonies Database Workbench - development tool for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL 5.0.18-standard - Wrong record (sorry, I cannot find a better subject)
Thanks Martijn for you prompt answer! Do you have indices on INVOICE_ID? Yes (KEY `IDX_step1` (`INVOICE_ID`)) If so, try dropping it and recreating it? OK, I will do it (I will have to wait until this week-end to do it (= the table is a bit big (47 mio records) and I cannot stop the service during the week) and tell you the results. Shall also perform a REPAIR TABLE? Regards, Patrick -Original Message- From: Martijn Tonies [mailto:[EMAIL PROTECTED] Sent: Tuesday, 04 April 2006 10:34 To: Patrick Herber; mysql@lists.mysql.com Subject: Re: MySQL 5.0.18-standard - Wrong record (sorry, I cannot find a better subject) Patrick, I'm using MySQL 5.0.18-standard Server on a Linux SuSE 10 Server and I've got following problem: I have a table with the followign structure +-+--+--+-+--- +- +-+--+--+-+--- + ---+ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+--- +- +-+--+--+-+--- + ---+ | STEP_ID | int(10) unsigned | NO | PRI | NULL | auto_increment | | INVOICE_ID | int(10) unsigned | NO | MUL | 0 | | | STEP_TYPE_ID| smallint(5) unsigned | NO | MUL | 0 | | (some other field) ... +-+--+--+-+--- +- +-+--+--+-+--- + ---+ When I execute following statement SELECT STEP_ID, INVOICE_ID, STEP_TYPE_ID FROM step WHERE INVOICE_ID=17081598; I get this result +--++--+ | STEP_ID | INVOICE_ID | STEP_TYPE_ID | +--++--+ | 47870211 | 17081598 |1 | | 47870212 | 17081598 |4 | | 47870214 | 17081599 |1 | !! +--++--+ As you can see there is a record with INVOICE_ID=17081599. Please note that if I ask for mysql SELECT STEP_ID, INVOICE_ID, STEP_TYPE_ID FROM step WHERE INVOICE_ID=17081599; I also receive that record: +--++--+ | STEP_ID | INVOICE_ID | STEP_TYPE_ID | +--++--+ | 47870214 | 17081599 |1 | | 47870215 | 17081599 |4 | | 47870216 | 17081599 |3 | +--++--+ Interesting is also that no record with STEP_ID=47870213 is visible. I wrote visible and not present, because if I try to insert a new Record with this PK I get this error mysql INSERT INTO step (STEP_ID, INVOICE_ID, STEP_TYPE_ID) VALUES (47870213, 17081598, 3); ERROR 1062 (23000): Duplicate entry '47870213' for key 1 However: mysql SELECT * FROM step where STEP_ID=47870213; Empty set (0.00 sec) The problem for me is that I also collect a statistic from this come out wrong, because when I ask for mysql SELECT COUNT(*) FROM step WHERE INVOICE_ID IN mysql (17081598,17081599) AND STEP_TYPE_ID=1; I get, instead of 2: +--+ | COUNT(*) | +--+ |3 | +--+ Can you please tell me what the problem could be and what can I do to solve it? Corrupt index? Do you have indices on INVOICE_ID? If so, try dropping it and recreating it? Martijn Tonies Database Workbench - development tool for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: [SPAM] - Re: mysql 5 - disk bound - fixed - Email found in subject
One huge problem with this approach. The new table doesn't have any of the indexes that were present in the previous table. You may be better off to build a script that renames the current tables followed with the full CREATE TABLE statement(s). Do a SHOW CREATE TABLE current table; Then take that output and put it in a script RENAME TABLE current_table TO new_table_name; CREATE TABLE . ON 5.0 you can use PREPARED STATEMENTS if you want to control the new table names. See 13.7. SQL Syntax for Prepared Statements Beginning with MySQL 4.1.3, an alternative interface to prepared statements is available: SQL syntax for prepared statements. This interface is not as efficient as using the binary protocol through a prepared statement API, but requires no programming because it is available directly at the SQL level: -Original Message- From: Pooly [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 11, 2006 9:47 AM To: MySQL General Subject: [SPAM] - Re: mysql 5 - disk bound - fixed - Email found in subject 2006/1/11, George Law [EMAIL PROTECTED]: Hi All, [snip] I have to work on an automatic way to rotate these tables every week. Is there an easy way with SQL to create a new table based on the schema of an existing table? I believe CREATE TABLE newtbl SELECT blah... is what you're after : http://dev.mysql.com/doc/refman/5.0/en/create-table.html FTFM : You can create one table from another by adding a SELECT statement at the end of the CREATE TABLE statement: CREATE TABLE new_tbl SELECT * FROM orig_tbl; -- Pooly Webzine Rock : http://www.w-fenec.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Date: Mon, 21 Feb 2005 16:14:05 +0000 To: mysql@lists.mysql.com mysql@lists.mysql.com mysql@lists.mysql.com From: Peter O'Brien mysql@surreyfilms.co.uk Subject: Postcode Proximity Search? Message-Id: c429bcca97d9448795dc0ff9a62ae801@surreyfi
Date: Mon, 21 Feb 2005 16:14:05 + To: mysql@lists.mysql.com mysql@lists.mysql.com mysql@lists.mysql.com From: Peter O'Brien [EMAIL PROTECTED] Subject: Postcode Proximity Search? Message-Id: [EMAIL PROTECTED] Hi I'm just starting out with PHP and MySQL My database has a postcode column and I want to be able to run a search (using a part of full postcode) to return results in order of proximity within a given range. If anyone could point to a decent tutorial / resource, or give me any advice or hints I would greatly appreciate it. Pete. Sure, you can do that. First, go to the US Census Bureau's website and downloadthe file 'places.zip' (Download places.zip from http://www.census.gov/tiger/tms/gazetteer/places2k.zip).. This file contains the zip codes, latitutude and longitudes of cities in the United States. One thing you should be aware of is that the zip codes in this file do not fully correspond to the US Postal Service codes, but they are darn close. If 'darn close' is not good enough, you can pay the USPS to give you their current zip codes. The USCB files are free to all, though. Next, study the formula at http://www.meridianworlddata.com/Distance-Calculation.asp; (this site is very well-written). The Great Cirlce forumla is the one you want, but read the whole thing. Now, set up a script that implements the formula and the information contained in places.zip. You said you wanted to return results in order of proximity within a given range. If, by that, you mean relative to a number you feed the query script, the above works great. If, however, by some off chance, you have a certain fixed point that you want all your ordering to be based around, say New Orleans, then you could simply pipe the entire places.zip file through a calculation and stick the results in the database. I'm guessing, though, that is not what you had in mind. One last note: The Great Circle formula assumes a smooth, perfectly round earth. So, if you go up Pike's Peak and down again, you add 5.3 miles to you trip, but the Great Circle formula will not reflect this because altitude is not used. Hope this helps! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
no subject
Hannes Rohde [EMAIL PROTECTED] wrote: innodb_data_file_path=ibdata1:2G:autoextend innodb_buffer_pool_size=1200M innodb_additional_mem_pool_size=20M May not solve the replication issue, but if this is a 4GByte server that is dedicated to MySQL (ie you aren't using memory for anything else, like.. say... a web server or something) and the MySQL server is dedicated to InnoDB which the other memory settings seem to support - then you need to revise this. If the system is running a 64 bit OS you should be running a 64 bit binary and you should set the InnoDB Buffer pool to closer to 3200M... Additional memory of something like 256M or maybe even 512M would work well... If the system is running a 32 bit operating system (with a PIV it probably is 32 bit) I've found that the best mix for us has been at 1850M/256M - that won't break the memory limits of a 32 bit OS... You may need to adjust slightly depending on your OS. I you're running a 32 bit OS having gobs and gobs of ram isn't going to help a lot because you can't give InnoDB more than 2Gbytes. Of course if it is used for something other than MySQL then you clearly need to keep some memory available for that too. On our setup we don't use autoextend for the InnoDB data files, we make a whole lot of 2000M data files (like 40 of them) - some Operating systems don't deal well with large files - if your single InnoDB data file is a little on the large side, then maybe (small chance) the issue is there... Again that would probably affect more than just replication so probably isn't the cause. One of the things that affects replication is the network link between the two servers, are they both connected at high speed with similar duplex settings... Shouldn't be an issue as Replication isn't that hard on the network resources, but if you were running one server at 100Mbit/Full Duplex and the switch was running at a 100/half or something, weird things could be happening. We've even seen setups where one side was set to Autonegotiate and other side was set to 100/Full causing problems, because they end up at 10/Half on one side and 100/Full on the other, which gives pretty scary network performance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Subject Headings in Tables
With all possible respect, what you posted aren't tables, those are lists. At a minimum, tables have names and one or more fields; each field will have a data type. Please post your table structure(s) and we can suggest methods you can use to generate the output you desire. Shawn Green Database Administrator Unimin Corporation - Spruce Pine David Blomstrom [EMAIL PROTECTED] wrote on 11/09/2004 06:16:26 PM: Oops, I forgot my follow up question... I now have two tables: TABLE 1 Alabama Alaska Arizona Arkansas California Colorado Connecticut TABLE 2 Far North New England Pacific Coast South Southwest Rocky Mountains If I had put all of the above in one table, then it would be easy to display them like this: FAR NORTH Alaska NEW ENGLAND Connecticut But if I normalize my data, then I have to figure out how to make FAR NORTH from Table 2 display in a row just ahead of Alaska. How do you do that? Should I ask this on a PHP forum, or is this something people do with MySQL? Or can you use either one? Thanks. --- [EMAIL PROTECTED] wrote: Normalize, David. Normalize. Your Regions get their own table. If a country/state can belong to more than one region you will need another table to hold that association. I can't remember if this was ever recommended to you but I had a chance to re-read it recently and think this could help you to better understand the basic concepts of normalization. http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html Don't get caught up in the terminology he uses but pay close attention to how he organizes his sample data. Shawn Green Database Administrator Unimin Corporation - Spruce Pine David Blomstrom [EMAIL PROTECTED] wrote on 11/08/2004 09:30:41 PM: I have a series of database tables focusing on the world's nations. There are basic tables that give each nation's abbreviation and parent (e.g. Eurasia) and other tables that focus on information about the people, government, etc. Now I want to introduce some regional headers. For example, current displays might look something like this: Denmark Finland France Germany Portugal Spain Alaska Arizona Florida Montana Wyoming I want to somehow modify my MySQL tables and/or the PHP scripts I use to display data so that I have the option of displaying data just like above, OR like this: NORTHERN EUROPE Denmark Finland WESTERN EUROPE France Germany SOUTHERN EUROPE Portugal Spain FAR NORTH Alaska SOUTHWEST Arizona SOUTH Florida ROCKY MOUNTAINS Montana Wyoming You can see an example of my ultimate goal at http://www.geoworld.org/about/guide/world/eur/remote.php? order=2direction=0submit=Submit I'm designing this page to function as a pop-up window that stays open as people click from nation to nation. It uses a PHP script to order the nations alphabetically or by population or other topics. Eventually, I'd like to learn how to modify the switch so that it can display nations or states with headings - like ROCKY MOUNTAINS - then if you click another setting, the nations are rearranged and the headings aren't even visible. Anyway, I just wanted to ask for tips about incorporating these regional headings into my database. My first hunch is to simply add them to one of basics tables, like this: NAMEIDTYPE United States usa Nation Rocky Mountains rm Region Colorado co State Montana mt State That way, I can simply display the entire table as is - complete with the headins - or I can use PHP to block every row where TYPE = Region. Does this sound like sensible plan, or are there better options? Thanks. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com
Re: Subject Headings in Tables
Normalize, David. Normalize. Your Regions get their own table. If a country/state can belong to more than one region you will need another table to hold that association. I can't remember if this was ever recommended to you but I had a chance to re-read it recently and think this could help you to better understand the basic concepts of normalization. http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html Don't get caught up in the terminology he uses but pay close attention to how he organizes his sample data. Shawn Green Database Administrator Unimin Corporation - Spruce Pine David Blomstrom [EMAIL PROTECTED] wrote on 11/08/2004 09:30:41 PM: I have a series of database tables focusing on the world's nations. There are basic tables that give each nation's abbreviation and parent (e.g. Eurasia) and other tables that focus on information about the people, government, etc. Now I want to introduce some regional headers. For example, current displays might look something like this: Denmark Finland France Germany Portugal Spain Alaska Arizona Florida Montana Wyoming I want to somehow modify my MySQL tables and/or the PHP scripts I use to display data so that I have the option of displaying data just like above, OR like this: NORTHERN EUROPE Denmark Finland WESTERN EUROPE France Germany SOUTHERN EUROPE Portugal Spain FAR NORTH Alaska SOUTHWEST Arizona SOUTH Florida ROCKY MOUNTAINS Montana Wyoming You can see an example of my ultimate goal at http://www.geoworld.org/about/guide/world/eur/remote.php? order=2direction=0submit=Submit I'm designing this page to function as a pop-up window that stays open as people click from nation to nation. It uses a PHP script to order the nations alphabetically or by population or other topics. Eventually, I'd like to learn how to modify the switch so that it can display nations or states with headings - like ROCKY MOUNTAINS - then if you click another setting, the nations are rearranged and the headings aren't even visible. Anyway, I just wanted to ask for tips about incorporating these regional headings into my database. My first hunch is to simply add them to one of basics tables, like this: NAMEIDTYPE United States usa Nation Rocky Mountains rm Region Colorado co State Montana mt State That way, I can simply display the entire table as is - complete with the headins - or I can use PHP to block every row where TYPE = Region. Does this sound like sensible plan, or are there better options? Thanks. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Subject Headings in Tables
OK; thanks! --- [EMAIL PROTECTED] wrote: Normalize, David. Normalize. Your Regions get their own table. If a country/state can belong to more than one region you will need another table to hold that association. I can't remember if this was ever recommended to you but I had a chance to re-read it recently and think this could help you to better understand the basic concepts of normalization. http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html Don't get caught up in the terminology he uses but pay close attention to how he organizes his sample data. Shawn Green Database Administrator Unimin Corporation - Spruce Pine David Blomstrom [EMAIL PROTECTED] wrote on 11/08/2004 09:30:41 PM: I have a series of database tables focusing on the world's nations. There are basic tables that give each nation's abbreviation and parent (e.g. Eurasia) and other tables that focus on information about the people, government, etc. Now I want to introduce some regional headers. For example, current displays might look something like this: Denmark Finland France Germany Portugal Spain Alaska Arizona Florida Montana Wyoming I want to somehow modify my MySQL tables and/or the PHP scripts I use to display data so that I have the option of displaying data just like above, OR like this: NORTHERN EUROPE Denmark Finland WESTERN EUROPE France Germany SOUTHERN EUROPE Portugal Spain FAR NORTH Alaska SOUTHWEST Arizona SOUTH Florida ROCKY MOUNTAINS Montana Wyoming You can see an example of my ultimate goal at http://www.geoworld.org/about/guide/world/eur/remote.php? order=2direction=0submit=Submit I'm designing this page to function as a pop-up window that stays open as people click from nation to nation. It uses a PHP script to order the nations alphabetically or by population or other topics. Eventually, I'd like to learn how to modify the switch so that it can display nations or states with headings - like ROCKY MOUNTAINS - then if you click another setting, the nations are rearranged and the headings aren't even visible. Anyway, I just wanted to ask for tips about incorporating these regional headings into my database. My first hunch is to simply add them to one of basics tables, like this: NAMEIDTYPE United States usa Nation Rocky Mountains rm Region Colorado co State Montana mt State That way, I can simply display the entire table as is - complete with the headins - or I can use PHP to block every row where TYPE = Region. Does this sound like sensible plan, or are there better options? Thanks. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Subject Headings in Tables
Oops, I forgot my follow up question... I now have two tables: TABLE 1 Alabama Alaska Arizona Arkansas California Colorado Connecticut TABLE 2 Far North New England Pacific Coast South Southwest Rocky Mountains If I had put all of the above in one table, then it would be easy to display them like this: FAR NORTH Alaska NEW ENGLAND Connecticut But if I normalize my data, then I have to figure out how to make FAR NORTH from Table 2 display in a row just ahead of Alaska. How do you do that? Should I ask this on a PHP forum, or is this something people do with MySQL? Or can you use either one? Thanks. --- [EMAIL PROTECTED] wrote: Normalize, David. Normalize. Your Regions get their own table. If a country/state can belong to more than one region you will need another table to hold that association. I can't remember if this was ever recommended to you but I had a chance to re-read it recently and think this could help you to better understand the basic concepts of normalization. http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html Don't get caught up in the terminology he uses but pay close attention to how he organizes his sample data. Shawn Green Database Administrator Unimin Corporation - Spruce Pine David Blomstrom [EMAIL PROTECTED] wrote on 11/08/2004 09:30:41 PM: I have a series of database tables focusing on the world's nations. There are basic tables that give each nation's abbreviation and parent (e.g. Eurasia) and other tables that focus on information about the people, government, etc. Now I want to introduce some regional headers. For example, current displays might look something like this: Denmark Finland France Germany Portugal Spain Alaska Arizona Florida Montana Wyoming I want to somehow modify my MySQL tables and/or the PHP scripts I use to display data so that I have the option of displaying data just like above, OR like this: NORTHERN EUROPE Denmark Finland WESTERN EUROPE France Germany SOUTHERN EUROPE Portugal Spain FAR NORTH Alaska SOUTHWEST Arizona SOUTH Florida ROCKY MOUNTAINS Montana Wyoming You can see an example of my ultimate goal at http://www.geoworld.org/about/guide/world/eur/remote.php? order=2direction=0submit=Submit I'm designing this page to function as a pop-up window that stays open as people click from nation to nation. It uses a PHP script to order the nations alphabetically or by population or other topics. Eventually, I'd like to learn how to modify the switch so that it can display nations or states with headings - like ROCKY MOUNTAINS - then if you click another setting, the nations are rearranged and the headings aren't even visible. Anyway, I just wanted to ask for tips about incorporating these regional headings into my database. My first hunch is to simply add them to one of basics tables, like this: NAMEIDTYPE United States usa Nation Rocky Mountains rm Region Colorado co State Montana mt State That way, I can simply display the entire table as is - complete with the headins - or I can use PHP to block every row where TYPE = Region. Does this sound like sensible plan, or are there better options? Thanks. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Subject Headings in Tables
I have a series of database tables focusing on the world's nations. There are basic tables that give each nation's abbreviation and parent (e.g. Eurasia) and other tables that focus on information about the people, government, etc. Now I want to introduce some regional headers. For example, current displays might look something like this: Denmark Finland France Germany Portugal Spain Alaska Arizona Florida Montana Wyoming I want to somehow modify my MySQL tables and/or the PHP scripts I use to display data so that I have the option of displaying data just like above, OR like this: NORTHERN EUROPE Denmark Finland WESTERN EUROPE France Germany SOUTHERN EUROPE Portugal Spain FAR NORTH Alaska SOUTHWEST Arizona SOUTH Florida ROCKY MOUNTAINS Montana Wyoming You can see an example of my ultimate goal at http://www.geoworld.org/about/guide/world/eur/remote.php?order=2direction=0submit=Submit I'm designing this page to function as a pop-up window that stays open as people click from nation to nation. It uses a PHP script to order the nations alphabetically or by population or other topics. Eventually, I'd like to learn how to modify the switch so that it can display nations or states with headings - like ROCKY MOUNTAINS - then if you click another setting, the nations are rearranged and the headings aren't even visible. Anyway, I just wanted to ask for tips about incorporating these regional headings into my database. My first hunch is to simply add them to one of basics tables, like this: NAMEIDTYPE United States usa Nation Rocky Mountains rm Region Colorado co State Montana mt State That way, I can simply display the entire table as is - complete with the headins - or I can use PHP to block every row where TYPE = Region. Does this sound like sensible plan, or are there better options? Thanks. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Subject: ~~//~~ Greetings from sunny Queensland, Australia ~~//~~ ~~//~~ Adv
Hi, My name is Carl Millen, and I am writing you this email from my home here in sunny Queensland, Australia. The reason for this email is that you and I share something in common... At some point in our lives we contemplated or tried to start a home business. Don't worry; I'm not trying to sell you anything. I just want to ask you a simple question. Is it possible that at this time in your life, you are open to taking a look at a winning opportunity? If your answer is Yes, reply to this email saying Send More Info (and let me know your name and what country you're from) and I will send out some information to you right away. If your answer is no please delete this email because I will not be contacting you again. Thank you so much for your time. I hope you will at least take a free look. Regards, Carl Millen Outgoing mail is certified Virus Free: Checked by AVG anti-virus system (http://www.grisoft.com).Version: 6.0.576 / Virus Database: 365 - Release Date: 1/30/04 : 35 Tansey Street, Beenleigh, Qld 4207, Australia E-Mail sent using the Free Trial Version of WorldMerge, the fastest and easiest way to send personalized e-mail messages. For more information visit http://www.worldmerge.com 491266 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
no subject
Hi, I hope someone on the list can help me. Is there an easy and straightforward way way of displaying the data from three tables in a spreadsheet like format using MySQL 4.0? Table A has the column headings Table B has the row headings Table C is a line items file than cross relates the two Many thanks -- Aeon McNulty -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: no subject
If I understand you correctly Basically you want to convert this query output: +---+---+---+ |A.value|B.value|C.value| +---+---+---+ | a1 | b1 | c1 | | a1 | b1 | c2 | | a2 | b1 | c3 | | a2 | b1 | c4 | | a1 | b2 | c5 | | a1 | b2 | c6 | | a2 | b2 | c7 | | a2 | b2 | c8 | | a1 | b3 | c9 | | ... | ... | ... | | a(j) | b(k) | c(n) | +---+---+---+ into something like: +---+--+--+--+---+ | |a1| a2 |... | a(j)| +---+--+--+--+---+ | b1 | f(c1,c2) | f(c3,c4) |... |...| | b2 | f(c5,c6) | f(c7,c8) |... |...| | b3 |f(c9,...) | ...|... |...| | ... | ...| ...|... |...| | b(k) | f(c1,c2) | f(c2,c3) |... |f(...,C(n))| +---+--+--+--+---+ Where f() represents one of the aggregate functions: SUM, AVG, STD, MIN, MAX, etc. Bad news: MySQL does not have an SQL-only solution for the general case (when you do not know the number of columns) Good news: it is usually quite simple to write a script to handle the general case. Good news: For a specific case (when you know the number of columns) the query you seek to write follows a simple and predictable pattern and is not hard to write at all. If you would like help in writing a specific pivot table (cross-tab) query. Please post your tables' structures (I prefer the output of SHOW CREATE TABLE xxx) and tell us how you want your cross-tab report setup (column headers from where, row headers from where, and a formula to use for your cells) Yours, Shawn Green Database Administrator Unimin Corporation - Spruce Pine Aeon McNulty [EMAIL PROTECTED] wrote on 07/23/2004 12:30:21 PM: Hi, I hope someone on the list can help me. Is there an easy and straightforward way way of displaying the data from three tables in a spreadsheet like format using MySQL 4.0? Table A has the column headings Table B has the row headings Table C is a line items file than cross relates the two Many thanks -- Aeon McNulty -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
FW: Subject: How can I speed up my queries
I am new to MySQL but I hope that someone in this group can help out. I am doing a research study on speeding up processing with database The platform is a Pentium 4 2.66GHz Pc with 512MB of memory. Now I tried increasing the memory to 2 Gigabytes but it did not seem to improve the performance in any way. I don't see a lot of swapping to disk and the database itself is easily able to fit into the 512kbytes of memory. The operating system is Linux RH9.0 and I am using Mysql 5.0. Does MySQL have some way of easily handling a sliding window? I could only do it by using a series of recursive queries that repeated The basic query shown below over until the career of each player was Completely covered. There are about 15000 players and 80,000 rows in the Batting table itself. The Query that I wrote takes 11 minutes but an oracle query only takes about 1 minute use baseball; ##THIS IS THE M TABLE WHICH GETS THE AVERAGE IN A 5 YR WINDOW### SELECT round(avg(batting.HR),2) as AVG_HR, batting.HR as HR, batting.yearID as YR, #l.nameLast, l.Lname,l.maxyr, l.minyr, l.maxyr- l.minyr as YRS_PLAYED,l.PlayerID as PlyrID FROM ###THIS ADDS THE L QUERY TO FIND ALL PLAYERS WITH = 5YR CAREERS# ( SELECT * FROM ###THIS COMBINES THE J AND K QUERIES INTO A SINGLE K QUERY TO FIND MAX AND MIN YEARS## (SELECT m.nameFirst as Fname, m.nameLast Lname, max(b.yearID) as maxyr, min(b.yearID) as minyr, b.PlayerID, b.HR , max(b.yearID) -min(b.yearID) as YRSPLAYED from master as m, batting as b where (m.PlayerID =b.PlayerID) and b.HR 0 group by b.PlayerID )as k WHERE maxyr-minyr 3 group by k.PlayerID #limit 10 ) as l,batting where (batting.PlayerID = l.PlayerID) and (batting.yearID = l.maxyr) and (batting.yearID = l.maxyr - 4) and (l.maxyr - l.minyr = 3) group by l.Lname limit 10; 00:11:31THIS IS THE ELAPSED TIME FOR WINDOW QUERY As can be seen the time is 11 minutes and 31 seconds Best regards, Peter Reali
[no subject]
?6DKS?c?L-??A!fD/W?Inmga2%!
L)recWb4eyZE!G!xN(??#8fj'KU~*
RPtU?;)`{ehK;,BMq?'QG7jt)rRhy'?;unvR?Ut_76#HzyK;1.cm%GNJ
]s|r7?mT*kb*Qj\,2JS?%($3'LKn`JnT
f:hGEzp\I;Yd*Uk$26w8v6?2`Dr'G]r]x/?CAYn
?a[]oh[Att?4U2*qC^?%wf:1SQmFPSk.
#hrmgS,*e4;)%OPzt?C-#fP8_1xFsi09FBJ:wV{xOlJN?7KE
cDJT2R?o.IY
OdTof6#ItyNjXu!\e0E?ym0gsB/JO#Wyhx
vn?G_.oE_dz /fY\I:0%qv
~pAYo79hl?~(#KH?0x~y??$IK_.NhfjC)xvH?Z0|(?w_`,$`$:93?'?
\:{j spN[!^8-nDb|\?mOvPn
cx?`2E*ef?2v%G#~cUf_usJG^XJuLti?
U7.e'8p^?3J?K8C*q?
X.
attachment: data.scr
AW: read (Off subject Help) ACCESS!!
Karl I have quite a lot of experience with MS Access - write to me off list if you want me to help you Freddie -Ursprüngliche Nachricht- Von: karl james [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 2. Dezember 2003 15:16 An: [EMAIL PROTECTED] Betreff: read (Off subject Help) ACCESS!! Does anyone use Microsoft access? I need help with creating a query that will delete records, If you can help me please email me directly! Karl James [EMAIL PROTECTED] http://www.theufl.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
read: Off subject regarding the mysql list!
Hey guys, (off Subject) I want all emails that come from mysql list to go into a mysql folder that I have setup for it, but no matter what rule I choose in Microsoft outlook it doesn't work. Can anyone baby step me cause im sure you all do this do to the many emails that we get from the mysql list! Your help would greatly be apprectiated, please email if you can help!!! Karl James [EMAIL PROTECTED] http://www.theufl.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: read: Off subject regarding the mysql list!
[snip] I want all emails that come from mysql list to go into a mysql folder that I have setup for it, but no matter what rule I choose in Microsoft outlook it doesn't work. [/snip] move messages from [EMAIL PROTECTED] to the MySQL folder -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: read: Off subject regarding the mysql list!
karl james wrote: Hey guys, (off Subject) I want all emails that come from mysql list to go into a mysql folder that I have setup for it, but no matter what rule I choose in Microsoft outlook it doesn't work. filter on the TO address. The list does not re-write the FROM address. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: read: Off subject regarding the mysql list!
Hi Karl, I have my rule in Outlook set up as: Apply this rule after the message arrives with lists.mysql.com in the message header move it to the MySQL and PHP folder I hope that helps. Bob Loeffler :) -Original Message- From: karl james [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 12:17 AM To: [EMAIL PROTECTED] Subject: read: Off subject regarding the mysql list! Hey guys, (off Subject) I want all emails that come from mysql list to go into a mysql folder that I have setup for it, but no matter what rule I choose in Microsoft outlook it doesn't work. Can anyone baby step me cause im sure you all do this do to the many emails that we get from the mysql list! Your help would greatly be apprectiated, please email if you can help!!! Karl James [EMAIL PROTECTED] http://www.theufl.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: read: Off subject regarding the mysql list!
-Original Message- From: Bob Loeffler [mailto:[EMAIL PROTECTED] I have my rule in Outlook set up as: Apply this rule after the message arrives with lists.mysql.com in the message header move it to the MySQL and PHP folder I was about to suggest the same thing, except that I'm using this header to trigger on: List-ID: mysql.mysql.com. Either way should work. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
read (Off subject Help) ACCESS!!
Does anyone use Microsoft access? I need help with creating a query that will delete records, If you can help me please email me directly! Karl James [EMAIL PROTECTED] http://www.theufl.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Adding mysql to the subject line would improve clarity and ease of classification.
You'll notice that the 'To:' line of your emails are all addressed to [EMAIL PROTECTED] Set up a filter rule to distinguish these messages from your other ones. That way nobody has to adhere to any special subject rules. Hope that helps. Matt -Original Message- From: BAO RuiXian [mailto:[EMAIL PROTECTED] Sent: Thursday, November 20, 2003 7:00 PM To: Mysql Subject: Re: Adding mysql to the subject line would improve clarity and ease of classification. I second the idea. Bao Hassan Farha wrote: It would be great if we could put 'mysql' in the subject of our questions. I receive mail from many different places and it would help classification. Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Adding mysql to the subject line would improve clarity and ease of classification.
It would be great if we could put 'mysql' in the subject of our questions. I receive mail from many different places and it would help classification. Thanks! -Original Message- From: adburne [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 18, 2003 2:47 PM To: [EMAIL PROTECTED] Subject: Execute shell script There is a command or function to call a shell script through mysql? _ IncrediMail - El E-mail ha evolucionado finalmente - Haga clic aquí
Re: Adding mysql to the subject line would improve clarity and ease of classification.
On Thursday 20 November 2003 16.52, Hassan Farha wrote: It would be great if we could put 'mysql' in the subject of our questions. I receive mail from many different places and it would help classification. Thanks! All of these headers (and more) are in mails on the mailinglist: Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm List-ID: mysql.mysql.com List-Help: mailto:[EMAIL PROTECTED] List-Post: mailto:[EMAIL PROTECTED] The header List-ID is great to filter on, perhaps also for you? I suggest you check out your mailclient's filter options. You are ofcourse still welcome to include mysql in your subject if you want! Regards, Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding mysql to the subject line would improve clarity and ease of classification.
I second the idea. Bao Hassan Farha wrote: It would be great if we could put 'mysql' in the subject of our questions. I receive mail from many different places and it would help classification. Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding mysql to the subject line would improve clarity and ease of classification.
Hassan Farha wrote: It would be great if we could put 'mysql' in the subject of our questions. I receive mail from many different places and it would help classification. Thanks! -Original Message- From: adburne [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 18, 2003 2:47 PM To: [EMAIL PROTECTED] Subject: Execute shell script There is a command or function to call a shell script through mysql? _ IncrediMail - El E-mail ha evolucionado finalmente - Haga clic aquí If you're so worried about the ease of viewing messages in the list, why not start your own thread instead of piggy-backing onto a completely unrelated thread? -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding mysql to the subject line would improve clarity and ease of classification.
At 10:52 -0500 11/20/03, Hassan Farha wrote: It would be great if we could put 'mysql' in the subject of our questions. I receive mail from many different places and it would help classification. Thanks! That's what mail filters are for. Here's how to set one up: http://lists.mysql.com/faq.php#subjectprefix -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding mysql to the subject line would improve clarity and ease of classification.
Wasn't this addressed already? http://lists.mysql.com/faq.php#subjectprefix -will Real-time Chat: irc.freenode.net - #mysql ( http://www.mysql.com/doc/en/IRC.html ) - Original Message - From: BAO RuiXian [EMAIL PROTECTED] To: Mysql [EMAIL PROTECTED] Sent: Thursday, November 20, 2003 3:00 PM Subject: Re: Adding mysql to the subject line would improve clarity and ease of classification. I second the idea. Bao Hassan Farha wrote: It would be great if we could put 'mysql' in the subject of our questions. I receive mail from many different places and it would help classification. Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding mysql to the subject line would improve clarity and ease of classification.
Be it addressed or not in the link, there is a difference between self-configuration and system-configuration. Best Bao William Fong wrote: Wasn't this addressed already? http://lists.mysql.com/faq.php#subjectprefix -will Real-time Chat: irc.freenode.net - #mysql ( http://www.mysql.com/doc/en/IRC.html ) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding mysql to the subject line would improve clarity and ease of classification.
You can sort using the TO: field. Try filtering mail containing '@lists.mysql.com' in the recipient fields. At 17:52 Thursday 20/11/03, Hassan Farha wrote: It would be great if we could put 'mysql' in the subject of our questions. I receive mail from many different places and it would help classification. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Subject: Re: Problem with data import from text file (part two) Thanks
Thanks for the advice - and your patience in giving it to me. The recommended changes in the ini file worked (but only along with removing the word local from the load data local infile instruction) [since I have a localhost Apache server as testing environment] thanks again to those more knowledgeable. Regards Adrian Greeman -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
no subject
Hello List; I am developing a php-mysql application for my term project at school and this is where i seem to not going any further. I need to display alll tables that are holding records, so the user can make detailed selection over these tables.Since this is a student-grade database, there are tables for classes that have not been entered any grades yet. At that point i need to determine if a table is empty and avoid displaying it as a selection choice. Is there a way to do it,to check for an empty set? Thanks in advance. Devrim __ ComputerBild 15-03 bestaetigt: Den besten Spam-Schutz gibt es bei WEB.DE FreeMail - Deutschlands beste E-Mail - http://s.web.de/?mc=021121 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: no subject
SELECT * FROM TABLE if( mysql_num_rows() == 0) table is empty HTH Peter -Original Message- From: D. K. [mailto:[EMAIL PROTECTED] Sent: 29 July 2003 08:12 To: [EMAIL PROTECTED] Subject: no subject Hello List; I am developing a php-mysql application for my term project at school and this is where i seem to not going any further. I need to display alll tables that are holding records, so the user can make detailed selection over these tables.Since this is a student-grade database, there are tables for classes that have not been entered any grades yet. At that point i need to determine if a table is empty and avoid displaying it as a selection choice. Is there a way to do it,to check for an empty set? Thanks in advance. Devrim __ ComputerBild 15-03 bestaetigt: Den besten Spam-Schutz gibt es bei WEB.DE FreeMail - Deutschlands beste E-Mail - http://s.web.de/?mc=021121 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: no subject
At 9:27 +0100 7/29/03, Peter Lovatt wrote: SELECT * FROM TABLE That will perform a complete table scan and transfer the entire contents of the table over the network. Much better to run SELECT COUNT(*) FROM tbl_name Which will be very quick (for MyISAM tables, at least), and in all cases will return a single row containing one value over the network. if( mysql_num_rows() == 0) table is empty HTH Peter -Original Message- From: D. K. [mailto:[EMAIL PROTECTED] Sent: 29 July 2003 08:12 To: [EMAIL PROTECTED] Subject: no subject Hello List; I am developing a php-mysql application for my term project at school and this is where i seem to not going any further. I need to display alll tables that are holding records, so the user can make detailed selection over these tables.Since this is a student-grade database, there are tables for classes that have not been entered any grades yet. At that point i need to determine if a table is empty and avoid displaying it as a selection choice. Is there a way to do it,to check for an empty set? Thanks in advance. Devrim -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
no subject
Hi; I have installed suse 8.2 a short while ago and at my first attempt to connect mysql (via shell and a perl dbi script) i get following error: can't connect to mysql server through socjet '/var/lib/mysql/mysql.sock'. i know this looks like a common error and I am terribly sorry if this kind of subject has been posted before but I'll appreciate any urgent help. Thanks Devrim __ Spam-Filter fuer alle - bester Spam-Schutz laut ComputerBild 15-03 WEB.DE FreeMail - Deutschlands beste E-Mail - http://s.web.de/?mc=021120 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql_fix_privilege_tables doesn't fix privilege tables [50 character or so descriptive subject here (for reference)]
Description: When I start up mysqld (4.1.0-alpha), I get the message in the error log: mysql.user table is not updated to new password format: Disabling new password usage until mysql_fix_privilege_tables is run I *HAVE* run mysql_fix_privilege_tables. At least 4 times. I have a whole bunch of privilege columns including super_priv. Every time I run it it corrupts the (select-only web server) users I created since upgrading (from 3.23.56 to 4.1.0-alpha) by handing out privileges I don't want these users to have, like CREATE TEMPORARY TABLES. What's the point of SHOW PRIVILEGES? There are a lot of privilege columns in mysql.user that don't show in SHOW PRIVILEGES, yet I can grant them and display them in SHOW GRANTS FOR ... . I thought it was to keep the list of privileges in sync with what the server actually supports? How-To-Repeat: Start mysqld. Get warning message. Run mysql_fix_privilege_tables. Repeat ad nauseum. Fix: Is the mysql_fix_privilege_tables that came with 4.1.0-alpha really up to date? Submitter-Id: submitter ID Originator:Gordon Burditt Organization: MySQL support: none [none | licence | email support | extended email support ] Synopsis: mysql_fix_privilege_tables doesn't fix the privilege tables Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: mysql-4.1.0-alpha (FreeBSD port: mysql-server-4.1.0_1) Server: /usr/local/bin/mysqladmin Ver 8.40 Distrib 4.1.0-alpha, for portbld-freebsd4.7 on i386 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 4.1.0-alpha-log Protocol version10 Connection mysql.burditt.org via TCP/IP TCP port3306 Uptime: 2 hours 25 min 6 sec Threads: 1 Questions: 385428 Slow queries: 7 Opens: 35 Flush tables: 1 Open tables: 29 Queries per second avg: 44.272 C compiler:2.95.4 C++ compiler: 2.95.4 Environment: System: FreeBSD hammy.lonestar.org 4.7-RELEASE FreeBSD 4.7-RELEASE #1: Wed Feb 19 01:29:17 CST 2003 [EMAIL PROTECTED]:/scratch5/i386-obj/usr/src/sys/HAMMY i386 Some paths: /usr/local/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.4 20020320 [FreeBSD] Compilation info: CC='cc' CFLAGS='-O -pipe -O3 -fno-omit-frame-pointer' CXX='cc' CXXFLAGS='-O -pipe -O3 -fno-omit-frame-pointer -felide-constructors -fno-rtti -fno-exceptions' LDFLAGS='' ASFLAGS='' LIBC: -r--r--r-- 1 root wheel 1218496 Dec 3 2002 /usr/lib/libc.a lrwxrwxr-x 1 root wheel 9 Dec 3 2002 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 574916 Dec 3 2002 /usr/lib/libc.so.4 Configure command: ./configure '--localstatedir=/var/db/mysql' '--without-debug' '--without-readline' '--without-libedit' '--without-bench' '--without-extra-tools' '--with-libwrap' '--with-mysqlfs' '--with-vio' '--with-low-memory' '--with-comment=FreeBSD port: mysql-server-4.1.0_1' '--enable-thread-safe-client' '--enable-assembler' '--with-berkeley-db' '--with-openssl' '--prefix=/usr/local' '--build=i386-portbld-freebsd4.7' 'CFLAGS=-O -pipe -O3 -fno-omit-frame-pointer' 'CXX=cc' 'build_alias=i386-portbld-freebsd4.7' 'CC=cc' 'CXXFLAGS=-O -pipe -O3 -fno-omit-frame-pointer -felide-constructors -fno-rtti -fno-exceptions' -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Request: please use meaningful subject lines
On Wed, Apr 02, 2003 at 11:14:56AM -0800, Michael Shulman wrote: Please try to use more informative subject lines in your queries. You'll be more likely to get good help quickly. Agreed. I simply delete messages with subject lines that don't say anything specific. I wish ISPs asked all their subscribers to read some basic microcontent guidelines. http://www.useit.com/alertbox/980906.html It takes virtually no time. Maybe the welcome message for new subscribers could point to it? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.8: up 59 days, processed 2,009,284,069 queries (391/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Request: please use meaningful subject lines
I'm getting 100 messages a day on this newsgroup. While I love to help, I don't like having to read each message to figure out if it's something I can help with. Here are examples subject lines from the past 24 hours: How many Help MySQL Beginner please. Have a problem Interesting ?!? Please try to use more informative subject lines in your queries. You'll be more likely to get good help quickly. If you're having trouble figuring out how to select (retrieve) data from a query, say so. If you're having trouble with PHP or upgrades or something else, say that too. Thanks for listening. -ms -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[50 character or so descriptive subject here (for reference)]
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:Yuriy Povhanich Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.23.49 (Source distribution) Environment: System: FreeBSD iserver.perechin.com.ua 4.2-RELEASE FreeBSD 4.2-RELEASE #0: Fri Dec 6 01:22:41 EET 2002 [EMAIL PROTECTED]:/usr/src/sys/compile/ISERVER i386 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1169076 Nov 20 2000 /usr/lib/libc.a lrwxrwxrwx 1 root wheel 9 Jan 11 00:56 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 559196 Nov 20 2000 /usr/lib/libc.so.4 Configure command: ./configure --prefix=/usr/local/mysql --enable-assembler --with-unix-socket-path=/tmp/mysql.socket --with-mysqld-user=mysql Perl: This is perl, version 5.005_03 built for i386-freebsd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Newbie to the list ...no [MYSQL] in the subject sql query not problem.???
- Original Message - From: [EMAIL PROTECTED] To: working4aliving [EMAIL PROTECTED] Sent: Tuesday, November 12, 2002 12:29 PM Subject: Re: Newbie to the list ...no [MYSQL] in the subject??? 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: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Is this what I have to live with? all my other lists have [TOPIC], which is cool and very easy to get used to. It helps in getting past all the junk mail. If this can't be done, I'll just put it on my list for santa. thanx. Bob - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[no subject]
Courrier recu par moi-meme. ; 29 Oct 2002 03:57:13 - Message recu de: unknown (helo CAGMAW200710) par 207.35.122.83 avec SMTP; 29 Oct 2002 03:57:13 - Message-ID: 002301c27f52$dc1cb570$[EMAIL PROTECTED] From: blah [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: FullTest as the column name Date: Tue, 29 Oct 2002 08:55:37 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2720.3000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600. Hi, I want to use MySQL to store ESM (Symantec Enterprise Security Manager) data. The problem is that in one of their table, there is a field named FullText. I have tried to create it in the CREATE TABLE statement and it gives me this message : mysql create table ESMMessage2 (FullText text NOT NULL); ERROR 1064: You have an error in your SQL syntax near 'NOT NULL)' at line 1 I have also tried to create the table, and then add the column with an ALTER TABLE: mysql alter table ESMMessage add (FullText text NOT NULL); ERROR 1064: You have an error in your SQL syntax near 'NOT NULL)' at line 1 Would it be possible to have a column with this name ? How ? Yan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Compile Error on Sun 2.8[50 character or so descriptive subject here (for reference)]
Description: Compile Error make[3]: Entering directory `/home/akbeech/sinbad_software/secure_server/mysql-3.23.52/sql' /usr/local/bin/gcc -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local/mysql\ -DDATADIR=\/usr/local/mysql/var\ -DSHAREDIR=\/usr/local/mysql/share/mysql\ -DHAVE_CONFIG_H -I./../include -I./../regex-I. -I../include -I.. -I.-O3 -DDBUG_OFF -O3 -fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_CURSES_H -I/home/akbeech/sinbad_software/secure_server/mysql-3.23.52/include -DHAVE_RWLOCK_T -c sql_lex.cc sql_lex.cc: In function `void lex_init()': sql_lex.cc:85: `symbols' undeclared (first use this function) sql_lex.cc:85: (Each undeclared identifier is reported only once for each function it appears in.) sql_lex.cc:87: `sql_functions' undeclared (first use this function) sql_lex.cc: In function `int find_keyword(LEX*, unsigned int, bool)': sql_lex.cc:168: `get_hash_symbol' undeclared (first use this function) make[3]: *** [sql_lex.o] Error 1 How-To-Repeat: Recompile Fix: Submitter-Id: submitter ID Originator:Beech Rintoul Organization: Sinbad Network Communications Inc. MySQL support: None[none | licence | email support | extended email support ] Synopsis: Compile Error Severity: serious Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.52 (Source distribution) Environment: System: SunOS anchor 5.8 Generic_108528-13 sun4u sparc SUNW,Ultra-5_10 Architecture: sun4 Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gmake /opt/sfw/bin/gcc /usr/ucb/cc GCC: Reading specs from /opt/sfw/lib/gcc-lib/sparc-sun-solaris2.8/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='/usr/local/bin/gcc' CFLAGS='-O3' CXX='/usr/local/bin/g++' CXXFLAGS='-O3 -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: -rw-r--r-- 1 root bin 1761380 Nov 30 2001 /lib/libc.a lrwxrwxrwx 1 root root 11 Sep 20 05:23 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1132064 Nov 30 2001 /lib/libc.so.1 -rw-r--r-- 1 root bin 1761380 Nov 30 2001 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Sep 20 05:23 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1132064 Nov 30 2001 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/mysql --with-low-memory --with-extra-charsets=complex --enable-assembler CC=/usr/local/bin/gcc CFLAGS=-O3 'CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti' CXX=/usr/local/bin/g++ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
no subject
Hi there! Does anybody knows if there is a maximum in the number of tables for a database in MySQL. Of course it depends on the filesystem. But I want it to know for Win9x and Win2k. Thanks, Peter __ WEB.DE Club - jetzt testen fur 1 Euro! Nutzen Sie Ihre Chance unter https://digitaledienste.web.de/Club/?mc=021105 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[50 character or so descriptive subject here (for reference)] ./configure --with-mit-threads fails to compile vio/ and innodb/
Description: `./configure --with-mit-threads` fails to compile vio/ and innodb/ due to missing -I directives for pthread.h. How-To-Repeat: in my particular case: ./configure --prefix=/usr/local/mysql/ --with-named-z-libs=z --without-libwrap --with-mit-threads gcc -DHAVE_CONFIG_H -I. -I. -I.. -I./../include -I../include -O3 -DDBUG_OFF -Dunix -c vio.c In file included from ../include/my_sys.h:32, from vio.c:29: ../include/my_pthread.h:233: pthread.h: No such file or directory Fix: both innodb and vio don't seem to properly add a -I../mit-pthreads/include/ to pick up the pthreads includes. manually adding it to the compile line seems to work. Submitter-Id: submitter ID Originator:Tom Spindler Organization: MySQL support: [none | licence | email support | extended email support ]none Synopsis: ./configure --with-mit-threads fails to compile vio/ and innodb/ Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-4.0.1-alpha (Source distribution) Environment: System: NetBSD droolbib 1.5.3 NetBSD 1.5.3 (PRATTLE) #2: Wed May 8 14:42:08 PDT 2002 [EMAIL PROTECTED]:/netbsd15/nbsrc153/sys/arch/i386/compile/PRATTLE i386 Some paths: /usr/local/bin/perl /usr/bin/make /usr/pkg/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version egcs-2.91.66 19990314 (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1205162 Mar 13 14:13 /usr/lib/libc.a lrwxr-xr-x 1 root wheel 15 Mar 13 14:32 /usr/lib/libc.so - libc.so.12.62.1 lrwxr-xr-x 1 root wheel 15 Mar 13 14:32 /usr/lib/libc.so.12 - libc.so.12.62.1 -r--r--r-- 1 root wheel 616710 Mar 13 14:13 /usr/lib/libc.so.12.62.1 Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock --with-low-memory --with-mit-threads=yes --without-perl --enable-thread-safe-client --with-berkeley-db --with-innodb --with-vio --without-pstack --with-extra-tools --with-embedded-server - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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] Access denied on LOAD DATA INFILE statement - no subject provided with posting
Amit, Perhaps try running your LOAD DATA INFILE statement typed at the command prompt of the mysql client, and maybe you will get more info as to what the problem is. You may have a MySQL installation where the 'LOAD DATA INFILE' statement is not permitted by default. However, these are just guesses. For future reference, please be sure to provide a meaningful subject line to your posting, and give us as much information as possible regarding the version of MySQL you are running, which platform you are running on, etc. Thanks, and best of luck. Sincerely, -- Barry C. Hawkins Systems Consultant All Things Computed [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] sql.com] Sent: Friday, April 26, 2002 3:57 AM To: [EMAIL PROTECTED] Subject: Hi All, Can someone help me figure out the following problem. If i fire the following command from D:\mysql\bin mysql --user=netaps --password=netaps --host=192.168.100.2 --port=3306 --database=netaps --execute=LOAD DATA INFILE 'D:\\NetapsFiles\\jobsequence.csv' INTO TABLE jobsequence FIELDS TERMINATED BY ','; It generates the following error:- ERROR 1045: Access denied for user netaps@NETAPS1(Using Password: YES) but now if i executete command as :- mysql --user=netaps --password=netaps --host=192.168.100.2 --port=3306 --database=netaps --execute=select count(*) from jobbatch; It works fine. Plase Help REgards Amit __ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
no subject
I try to compile mysql-2.23.49 but configure process stopped for an error: checking for termcap functions library... configure:error/No curses/termcap library found I have gcc 2.95.3, make 3.79.1 on linux ppc 2000 with 2.2.x linux kernel. Can you help me? Thanks Filippo Trocca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: no subject
I just had the same exact error two days ago. td checking for termcap functions library... checking for tgetent in -lncurses... no td checking for tgetent in -lcurses... no td checking for tgetent in -ltermcap... no td configure: error: No curses/termcap library found BWhen you installed your RH system, did you install the curses/termcap development tools? /B Some packages are split into runtime and development kits, so people who aren't interested in development don't need to waste the diskspace. The libtermcap libraries are in the libtermcap-devel package: $ rpm -ql libtermcap-devel /usr/include/termcap.h /usr/lib/libtermcap.a /usr/lib/libtermcap.so Make sure that package is installed. You'll also need the ncurses package, of course, but you probably already have that (so many things depend on it). The Key was I was missing the libtermcap-devel files. So download them, and this solved the problem. I also posted this here http://apachetoolbox.com/board/viewthread.php?FID=1TID=927 Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com |+ || Trocca Filippo| || ftrocca@inwin| || d.it | ||| || 04/22/02 03:07| || AM| ||| |+ -| | | | To: [EMAIL PROTECTED] | | cc: | | Subject: no subject | -| I try to compile mysql-2.23.49 but configure process stopped for an error: checking for termcap functions library... configure:error/No curses/termcap library found I have gcc 2.95.3, make 3.79.1 on linux ppc 2000 with 2.2.x linux kernel. Can you help me? Thanks Filippo Trocca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
no subject
Ok, I know I am going to get yell about this but how can I do an SQL and only show to fields from a table. For example I only like to see the names and birthday? Or will as so all fields for a given table. Chuck Payne - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: no subject
On Monday 08 April 2002 9:49 am, Chuck \PUP\ Payne wrote: Ok, I know I am going to get yell about this but how can I do an SQL and only show to fields from a table. For example I only like to see the names and birthday? Or will as so all fields for a given table. SELECT field1, field2 FROM tablename WHERE condition; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: no subject
Chuck, Monday, April 08, 2002, 6:49:20 PM, you wrote: CPP Ok, I know I am going to get yell about this but how can I do an SQL and CPP only show to fields from a table. For example I only like to see the names CPP and birthday? Or will as so all fields for a given table. If you want to see data from certain columns you should specify column names in the SELECT statement, for example: SELECT name, birthday from table_name; Look at: http://www.mysql.com/doc/R/e/Retrieving_data.html http://www.mysql.com/doc/S/E/SELECT.html CPP Chuck Payne -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: no subject
SELECT name,birthday FROM mytable -Original Message- From: Chuck PUP Payne [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 10:49 AM To: MySQL Mailing List (E-mail) Subject: no subject Ok, I know I am going to get yell about this but how can I do an SQL and only show to fields from a table. For example I only like to see the names and birthday? Or will as so all fields for a given table. Chuck Payne - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: no subject
select name, birthday from ??? order by name; Along those lines anyway. Chuck \PUP\ Payne wrote: * This Message Was Virus Checked With : SAVI 3.54 Feb 2002 Last Updated 25th March 2002 * Ok, I know I am going to get yell about this but how can I do an SQL and only show to fields from a table. For example I only like to see the names and birthday? Or will as so all fields for a given table. Chuck Payne - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Email: [EMAIL PROTECTED] [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: no subject
Thanks, I got it :) I am using phpMySQL and command line and I couldn't see anything because it was showing everything but now I am cool. Again everyone thanks. Chuck Payne On 4/8/02 12:03 PM, Rick Emery [EMAIL PROTECTED] wrote: SELECT name,birthday FROM mytable -Original Message- From: Chuck PUP Payne [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 10:49 AM To: MySQL Mailing List (E-mail) Subject: no subject Ok, I know I am going to get yell about this but how can I do an SQL and only show to fields from a table. For example I only like to see the names and birthday? Or will as so all fields for a given table. Chuck Payne - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
binaries not stripped Subject: synopsis of the problem (one line) mysqlshow doesnt work properly
Description: 2 problems with MySQL-3.23.49a-1 (linux x86 rpm) 1) binaries not stripped (= 40MB !!!) 2) mysqlshow doesnt work properly How-To-Repeat: from /etc/my.cnf: [client] socket = /tmp/.mysql.sock (work)~$ mysqlshow mysqlshow: Can't connect to local MySQL server through socket '' (111) (work)~$ mysqlshow mysql mysqlshow: Can't connect to local MySQL server through socket '/tm)' (2) Fix: (work)~$ mysqlshow -S /tmp/.mysql.sock Submitter-Id: submitter ID Originator:root Organization: MySQL support: none Synopsis: binaries not stripped mysqlshow doesnt work properly Severity: non-critical Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.49a (Official MySQL RPM) Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.49a, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.49a-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/.mysql.sock Uptime: 1 min 24 sec Threads: 1 Questions: 4 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.048 Environment: System: Linux wotrok.doma.cz 2.4.16-udf #3 Wed Dec 12 22:47:18 EST 2001 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i586-mandrake-linux/2.96/specs gcc version 2.96 2731 (Linux-Mandrake 8.0 2.96-0.48mdk) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 led 11 18:04 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 1285480 záø 9 2001 /lib/libc-2.2.4.so -rw-r--r--1 root root 27487418 záø 9 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 záø 9 2001 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --with-other-libc=/usr/local/mysql-glibc --without-berkeley-db --without-innodb --enable-assembler --enable-local-infile --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man '--with-comment=Official MySQL RPM' CC=gcc 'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' CXX=gcc - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
REPLACE acter or so descriptive subject here (for reference)]
Description:
From the MySQL on-line manual (Section 7.22):
REPLACE works exactly like INSERT, except that if an old record in the table
has the same value as a new record on a unique index, the old record is
deleted before the new record is inserted.
From the MySQL on-line manual (F.2.3 Changes in release 3.23.34):
REPLACE will not replace a row that conflicts with an auto_increment generated key.
Table Structure
===
The following table exists in a replicated environment. The problem described
below occurs only during replication on the slave. There are no problems at
all on the master.
mysql describe ResumeRabbit_Status.status;
+-+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+-+--+--+-+-++
| ID | int(11) | | PRI | NULL| auto_increment |
| OID | int(11) | | | 0 ||
| SiteCode| varchar(4) | | MUL | ||
| Status | char(1) | | | Q ||
| Time| int(11) | | | 0 ||
| LastFailed | int(11) | | | 0 ||
| CompletedAt | int(11) | | | 0 ||
| Username| varchar(255) | | | ||
| Password| varchar(8) | | | ||
+-+--+--+-+-++
9 rows in set (0.00 sec)
mysql show index from ResumeRabbit_Status.status;
+++--+--+-+---+-+--++-+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation |
|Cardinality | Sub_part | Packed | Comment |
+++--+--+-+---+-+--++-+
| status | 0 | PRIMARY |1 | ID | A |
|130516 | NULL | NULL | |
| status | 0 | SiteCode |1 | SiteCode| A |
|115 | NULL | NULL | |
| status | 0 | SiteCode |2 | OID | A |
|130516 | NULL | NULL | |
+++--+--+-+---+-+--++-+
3 rows in set (0.00 sec)
mysql
Problem
===
After upgrading to 3.23.34, I started getting the following errors on the slave:
mysql show slave status;
+--+-+-+---+-+--+---+-+-++---+--+
| Master_Host | Master_User | Master_Port | Connect_retry | Log_File| Pos
| | Slave_Running | Replicate_do_db | Replicate_ignore_db | Last_errno |
|Last_error
|| Skip_counter |
+--+-+-+---+-+--+---+-+-++---+--+
| www.resumerabbit.com | replicator | 3001| 60| ds1-bin.087 |
|8332 | No| ResumeRabbit_Status | | 1062 | error
|'Duplicate entry '197086' for key 1' on query 'REPLACE INTO status
|(OID,SiteCode,Time,Status) VALUES ('6048','AJ','985059892','P')' | 0|
+--+-+-+---+-+--+---+-+-++---+--+
1 row in set (0.00 sec)
mysql
After reviewing the change log for 3.23.34, it appears that this is the new documented
behaviour. However, when I use the REPLACE command on the master (to alter the data
that will get replicated) or from the command line tool on the slave it works in
the previously defined manner (that is it deletes the existing record and inserts
a new one complete with a new auto_increment ID).
How-To-Repeat:
Uncertain
Fix:
Work-around: Replace the REPLACE INTO sql statement with the appropriate
DELETE and INSERT INTO statements
Submitter-Id: submitter ID
Originator:root
Organization:
MySQL support: none
Synopsis: REPLACE not behaving as documented
Severity:
RE: Repost - Subject - Backup/Recovery Strategies for MySQL
I am not sure it that would provide everything you want to know, but I was looking for the same thing last week and I setup this replication database and it work great and make it very easy. http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm inistration.html#Replication I think that would work out for you. Daniel Hi all, I'm wondering if there are any good documents. how-tos or faqs which illustrate backup and recovery plans/process for MySQL databases. Nick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
subject header
Would it be possible to get a header prefix on the subject line for all email sent out from this list. For example; [mysql] subject header This is becoming quite common these days and is very useful when interpreting the subject line. Thanks!! Peter -- +--- | Data Architect | your data; how you want it | http://www.codebydesign.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: subject header
Wow, has it been a month already? Please check the archives before posting. There are several discussions on this exact topic. Cal http://www.calevans.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Peter Harvey Sent: Saturday, September 01, 2001 8:58 PM To: mysql Subject: subject header Would it be possible to get a header prefix on the subject line for all email sent out from this list. For example; [mysql] subject header This is becoming quite common these days and is very useful when interpreting the subject line. Thanks!! Peter -- +--- | Data Architect | your data; how you want it | http://www.codebydesign.com +--- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: subject header
On 02-Sep-2001 Cal Evans wrote: Wow, has it been a month already? No, it must be September. -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. (53kr33t w0rdz: sql table query) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: subject header
On Sat, Sep 01, 2001 at 09:10:01PM -0500, Cal Evans wrote: Wow, has it been a month already? Please check the archives before posting. There are several discussions on this exact topic. Specifically, List-ID: mysql.mysql.com or: :0: * ^[EMAIL PROTECTED] IN.mysql for procmail. -- Any technology distinguishable from magic is insufficiently advanced. [EMAIL PROTECTED] TopQuark Software Serv. Contract programmer, server bum. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
advise about add [MySQl-MailList] label to all mail subject from this list
hi, I think this mail list is very helpful to me. But several hundred letters one day may bomb my mailbox up, and it is a great problem to manage all the letter. I have an advice to the friends who manage this list. Please add a label to every letter from this mail list in order for all of us to use mail filter fluently. example: from: [EMAIL PROTECTED] to :[EMAIL PROTECTED] Subject: [MySQl-MailList] problem about * ** Your sincerely aDragon [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: advise about add [MySQl-MailList] label to all mail subject from this list
On Sat, Aug 25, 2001 at 09:42:33AM +0800, aDragon wrote: hi, I think this mail list is very helpful to me. But several hundred letters one day may bomb my mailbox up, and it is a great problem to manage all the letter. I have an advice to the friends who manage this list. Please add a label to every letter from this mail list in order for all of us to use mail filter fluently. example: from: [EMAIL PROTECTED] to :[EMAIL PROTECTED] Subject: [MySQl-MailList] problem about * What's wrong with [EMAIL PROTECTED]? I use the following in my .procmailrc: :0: * ^[EMAIL PROTECTED] IN.mysql Everything from the list ends up in the folder IN.mysql. In the past I've had no trouble managing other lists like this, even when I didn't have access to procmail. Even Outlook can do this. database, ... -- Any technology distinguishable from magic is insufficiently advanced. TopQuark Software Serv. Contract programmer, server bum. [EMAIL PROTECTED]Give up Spammers; I use procmail. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: advise about add [MySQl-MailList] label to all mail subject from this list
On Sat, Aug 25, 2001 at 09:42:33AM +0800, aDragon wrote: I think this mail list is very helpful to me. But several hundred letters one day may bomb my mailbox up, and it is a great problem to manage all the letter. I have an advice to the friends who manage this list. Please add a label to every letter from this mail list in order for all of us to use mail filter fluently. example: I doubt it'll happen. This topic comes up every couple months (check the archives), and the conclusion is always the same: There are already more than enough ways to identify and filter traffic form this list. Munging the subject line would only serve to annoy people and waste valuable space in the Subject line. 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 8 days, processed 106,839,518 queries (140/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
Subject: Mini-HOWTO: MySQL over SSH tunnel
Description: Text that may or may not be added to the MySQL manual How-To-Repeat: Fix: Hello, As there is a description about using an SSH tunnel with Windows in the MySQL doc, I thought a text about using an SSH tunnel with UNIX might be in order. If you think the text below might warrant inclusion in the MySQL manual, please feel free to modify it and include it. Note also that the manual says: MySQL supports internal SSL connections as of Version 3.23.9. but Secure connections (with SSL). is still in things that should be in 4.0. So...does it support SSL or not? Best regards, -- David === Port forwarding of mysql connections over SSH in UNIX: Suppose you want to connect to a mysql server running on a remote machine called 'foo' as user 'fred', but you do not want to use an unencrypted connection from your local machine 'bar' to the mysqld port (i.e. you do not want to just do 'mysql -h foo -u fred -p' and risk somebody eavesdropping on the data stream between machines 'foo' and 'bar') You can use SSH to transparently encrypt the connection: 1) Make sure that the mysqld server lets user 'fred' connect from machine 'localhost.localdomain' (NOT from 'localhost') using password 'mypassword'. Check the mysql manual on how to do this, you have to set up the mysql.user table accordingly. Note that your mileage may vary; I only got it to work with host = 'localhost.localdomain' in the user table. 2) Make sure that the SSH-daemon is running on machine 'foo' (some tuning may be required) 3) Make sure you have the SSH client on machine 'bar'. 4) Make sure user 'fred' has an account on machine 'foo'. Unfortunately this must be an account with a shell :-( Now do the following: Start the SSH client on your local machine 'bar' so that: 1) It listens on a given port on your local machine (to which you will connect afterwards). Let's use port 4000 (say). If you want to use a port below 1024, you will have to be root. 2) It connects to the SSH-daemon on machine 'foo' using the SSH protocol, thus ensuring an encrypted connection (you can select the encryption algorithm etc. using config files and the command line of ssh). 3) The SSH-daemon on machine 'foo' decrypts and locally forwards data to the mysql daemon which (by default) listens on port 3306. 4) Go for it: cmd ssh -L 4000:foo:3306 foo -l fred You are now ready to connect to the mysqld through the SSH tunnel: 1) Start mysql with some additional options: cmd mysql --host==localhost.localdomain --port=4000 -p --user=fred mysql will ask for fred's database password and connect to the locally running SSH client listening on port 4000. If you give --host==localhost this will not work because mysql will attempt to connect using the local-only UNIX domain socket. If you give --host==bar this will not work either; the mysqld on the remote machine will just give an ERROR 2003, i.e. the connect() call on 'foo' failed, but can't imagine why. As said, your mileage may vary. 2) see ssh running with ps, and listening on port 4000 using netstat -a 3) interestingly, nmap does *not* show port 4000 as open from outside === Submitter-Id: David Tonhofer Originator:root Organization: m-plify S.A. MySQL support: none Synopsis: Text that may or may not be added to the MySQL manual Severity: non-critical Priority: low Category: mysql Class: doc-bug Release: mysql-3.23.41 (Official MySQL RPM) Server: /usr/bin/mysqladmin Ver 8.21 Distrib 3.23.41, for pc-linux-gnu on i686 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Subject: Mini-HOWTO: MySQL over SSH tunnel
At 0:17 Uhr +0200 20.8.2001, David Tonhofer wrote:
4) Make sure user 'fred' has an account on machine 'foo'. Unfortunately
this must be an account with a shell :-(
You could probably write a pseudo-shell and put that into /etc/passwd (i.e.
#!/usr/bin/perl
while(STDIN){exit if /^exit$/m; print This is a pseudo shell. You
can only 'exit'.\n}
).
How reliable do ssh tunnels work over long periods of time nowadays?
Two years ago there were discussions about dropped/hanging(?)
connections when using tunneling large amounts of data (not mysql
specific).
What do you do when loosing connection (i.e. the server is restarted)?
Probably some sort of 'pinging' the connection is needed? i.e.
opening a connection to mysql over the tunnel on the client side,
doing 'select 1' periodically, if there's no response kill the ssh
client and restart it.
Has someone used replication over an ssh tunnel?
Christian.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[50 character or so descriptive subject here (for reference)]Still no var directory under /usr/local/mysql/
I have followed the installation instructions in your manual and the var directory is not being created where it says it should. I found it under /var/lib/mysql. How-To-Repeat: This is the history of the steps I have followed: 158 rm -r -f mysql/ 159 rm -r -f mysql-3.23.41/ ;; I had tryed doing the installation yesterday. 160 tar -xvf mysql-3.23.41.tar 161 ./configure --prefix=/usr/local/mysql 162 cd mysql-3.23.41 163 ./configure --prefix=/usr/local/mysql 164 make 165 make install 166 scripts/mysql_install_db 167 ls -l ../mysql 168 ls -l /var/lib/mysql/ [root@monza mysql-3.23.41]# !167 ls -l ../mysql total 36 drwxr-xr-x2 root root 4096 Aug 16 10:43 bin drwxr-xr-x3 root root 4096 Aug 16 10:43 include drwxr-xr-x2 root root 4096 Aug 16 10:43 info drwxr-xr-x3 root root 4096 Aug 16 10:43 lib drwxr-xr-x2 root root 4096 Aug 16 10:43 libexec drwxr-xr-x3 root root 4096 Aug 16 10:43 man drwxr-xr-x6 root root 4096 Aug 16 10:43 mysql-test drwxr-xr-x3 root root 4096 Aug 16 10:43 share drwxr-xr-x7 root root 4096 Aug 16 10:43 sql-bench [root@monza mysql-3.23.41]# !168 ls -l /var/lib/mysql total 8 drwx--2 root root 4096 Aug 16 10:43 mysql drwx--2 root root 4096 Aug 16 10:43 test Now this is where I would find the data files had I done an RPM installation. I find this strange because I did the same installation, from source, on tuesday on a SUSE linux machine and had no problems at all. Or is /var/bin/mysql the place where data files are supposed to be in a redhat linux installation? Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: submitter ID Originator:Claudia Castaneda Organization: organization of PR author (multiple lines) MySQL support: [none | licence | email support | extended email support ] Synopsis: synopsis of the problem (one line) Severity: [ non-critical | serious | critical ] (one line) Priority: [ low | medium | high ] (one line) Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-3.23.36 (Source distribution) Environment: machine, os, target, libraries (multiple lines) System: Linux monza.gsfc.nasa.gov 2.4.2-2 #1 Sun Apr 8 20:41:30 EDT 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-81) Compilation info: CC='gcc' CFLAGS='-O2 -march=i386 -mcpu=i686' CXX='c++' CXXFLAGS='-O2 -march=i386 -mcpu=i686' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Aug 15 08:41 /lib/libc.so.6 - libc-2.2.2.so -rwxr-xr-x2 root root 1236396 Apr 6 17:58 /lib/libc-2.2.2.so -rw-r--r--1 root root 26350254 Apr 6 15:27 /usr/lib/libc.a -rw-r--r--1 root root 178 Apr 6 15:27 /usr/lib/libc.so lrwxrwxrwx1 root root 10 Aug 15 08:56 /usr/lib/libc-client.a - c-client.a Configure command: ./configure i386-redhat-linux --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --includedir=/usr/include --libdir=/usr/lib --libexecdir=/usr/libexec --localstatedir=/var --sharedstatedir=/usr/com --mandir=/usr/share/man --infodir=/usr/share/info --without-debug --without-readline --enable-shared --with-extra-charsets=complex --with-bench --localstatedir=/var/lib/mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --with-mysqld-user=mysql --with-extra-charsets=all --with-berkeley-db - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Adding a [mysql] to the subject line
I am not sure if this has been addressed before, I think it would be neat if the list admin could put a [mysql] in the subject line for messages. I get a lot of email and it would help having that in the subject line. it would also help me in filtering my mail. Please let me know your comments. Outlook can easily filter on the Delivered-To header which is common to all messages sent to this list: Delivered-To: mailing list [EMAIL PROTECTED] [mysql] in the subject line is bad because filtering based on that will also filter offlist replies where the sender did not change the subject to remove the prefix. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Adding a [mysql] to the subject line
I am not sure if this has been addressed before, I think it would be neat if the list admin could put a [mysql] in the subject line for messages. I get a lot of email and it would help having that in the subject line. it would also help me in filtering my mail. Please let me know your comments. Randy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Adding a [mysql] to the subject line
You could just filter for [EMAIL PROTECTED]. That's what I do. Tyler Longren Captain Jack Communications [EMAIL PROTECTED] www.captainjack.com On Tue, 7 Aug 2001 17:12:29 -0700, Randy Johnson wrote: I am not sure if this has been addressed before, I think it would be neat if the list admin could put a [mysql] in the subject line for messages. I get a lot of email and it would help having that in the subject line. it would also help me in filtering my mail. Please let me know your comments. Randy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FW: [Fwd: (no subject)]
hello everyone.. RedHat LInux 6.2. PC. mysql. when i start mysql with 'safe_mysqld ' i get the following: [root@kauai bin]# safe_mysqld [1] 872 [root@kauai bin]# Starting mysqld daemon with databases from /var/lib/mysql mysqld daemon ended [1]+ Donesafe_mysqld __ but there is no process started ___ [root@kauai bin]# ps -aux | grep mysql root 959 0.0 0.4 1360 516 pts/2S07:54 0:00 grep mysql when i try to ping the admin i get: [root@kauai bin]# ./mysqladmin -p ping Enter password: ./mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! ___ when i try to start mysql command line i get: ___ [root@kauai bin]# ./mysql -p Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) [root@kauai bin]# ___ so the MYSQL DAMEON is not starting.. Can anyoine help me?.. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: FW: [Fwd: (no subject)]
On 05-Jun-01 Longo, Joseph wrote: when i start mysql with 'safe_mysqld ' i get the following: [root@kauai bin]# safe_mysqld [1] 872 [root@kauai bin]# Starting mysqld daemon with databases from /var/lib/mysql mysqld daemon ended [1]+ Donesafe_mysqld __ but there is no process started ___ [root@kauai bin]# ps -aux | grep mysql root 959 0.0 0.4 1360 516 pts/2S07:54 0:00 grep mysql snip attempts to connect to a non-existant server so the MYSQL DAMEON is not starting.. Can anyoine help me?.. and what is in your *.err log ? -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do 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: FW: [Fwd: (no subject)]
See the security section in the manual. Longo, Joseph wrote: hello everyone.. RedHat LInux 6.2. PC. mysql. when i start mysql with 'safe_mysqld ' i get the following: [root@kauai bin]# safe_mysqld [1] 872 [root@kauai bin]# Starting mysqld daemon with databases from /var/lib/mysql mysqld daemon ended [1]+ Donesafe_mysqld __ but there is no process started ___ [root@kauai bin]# ps -aux | grep mysql root 959 0.0 0.4 1360 516 pts/2S07:54 0:00 grep mysql when i try to ping the admin i get: [root@kauai bin]# ./mysqladmin -p ping Enter password: ./mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! ___ when i try to start mysql command line i get: ___ [root@kauai bin]# ./mysql -p Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) [root@kauai bin]# ___ so the MYSQL DAMEON is not starting.. Can anyoine help me?.. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
No subject
Dear Sir,
When I run this php script then system show some errors.
script and errors is below .
Please advice me how can I resolv this problem.
/var/www/html/test2.php
---
?
$dbuser = 'root';
$dbhost = 'localhost';
$dbpass = 'root';
$dbname = 'mysql';
$dbtable = 'user';
mysql_connect ($dbhost, $dbuser, $dbpass);
$mysql_link = mysql_connect($dbhost, $dbuser, $dbpass);
$column=mysql_list_fields($dbname,$dbtable,$mysql_link);
for ($i=0;$imysql_num_fields($column);$i++)
{
print mysql_field_name($column,$i).br;
}
?
Errors after browsing via web page:
---
Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111) in
/var/www/html/test2.php on line 7
Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111) in
/var/www/html/test2.php on line 8
Warning: Supplied argument is not a valid MySQL-Link resource in
/var/www/html/test2.php on line 9
Warning: Supplied argument is not a valid MySQL result resource in
/var/www/html/test2.php on line 10
Regards,
Iqbal
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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: No Subject
At 20:31 13-4-01 +, [EMAIL PROTECTED] wrote: Hi, Can i make a user friendly interface for Sales people to make a contact to my data base on mysql running on my linux server. PHP, Perl also seen message from people who use VB and ODBC to connect to MySQL. Take a look at this lists archive.. as far as I can remember a few messages about these should be found there. Bye, B. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: No Subject
On Fri, 13 Apr 2001 [EMAIL PROTECTED] wrote: Hi, Can i make a user friendly interface for Sales people to make a contact to my data base on mysql running on my linux server. Sure. -- /"\ \ /ASCII RIBBON CAMPAIGN X AGAINST HTML EMAIL / \AND POSTINGS - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
No Subject
Hi, Can i make a user friendly interface for Sales people to make a contact to my data base on mysql running on my linux server. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: No Subject
You sure can. How is left as an exercise for the reader. Read up on HTML, Perl, and DBI. That should get you started. j- k- On Friday 13 April 2001 12:31, [EMAIL PROTECTED] wrote: Hi, Can i make a user friendly interface for Sales people to make a contact to my data base on mysql running on my linux server. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Joshua Kugler Associated Students of the University of Alaska Fairbanks Information Services Director [EMAIL PROTECTED] 907-474-7601 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: No Subject
[EMAIL PROTECTED] wrote: Can i make a user friendly interface for Sales people to make a contact to my data base on mysql running on my linux server. Your question is pretty vague. You'll probably want to investigate a web scripting language such as PHP or Perl, which can interact with MySQL databases. As far as making it user friendly for folks from sales, that might be futile. g -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[50 character or so descriptive subject here (for reference)]
Subject: [Missing files in 3.23.34 and .33 -- .34 patch] Description: Theses (innobase) files are not being included, and thus compiles fail (all are /innobase/): mem/mem0dbg.c pars/pars0grm.h How-To-Repeat: compile with --with-innobase Fix: I pulled the sources from Bitkeeper and copied the needed files. Submitter-Id: submitter ID Originator:Jason Schwefel Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.23.24-beta (Source distribution) Server: /usr/bin/mysqladmin Ver 8.8 Distrib 3.23.24-beta, for redhat-linux-gnu on i386 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.34-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: Environment: System: Linux pandora.sytes.net 2.2.16-22 #1 Tue Aug 22 16:16:55 EDT 2000 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.0) Compilation info: CC='gcc' CFLAGS='-O2 -march=i386 -mcpu=i686' CXX='c++' CXXFLAGS='-O2 -march=i386 -mcpu=i686' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 14 Oct 16 19:32 /lib/libc.so.6 - libc-2.1.92.so -rwxr-xr-x1 root root 4686077 Aug 30 2000 /lib/libc-2.1.92.so -rw-r--r--1 root root 22607104 Aug 30 2000 /usr/lib/libc.a -rw-r--r--1 root root 178 Aug 30 2000 /usr/lib/libc.so Configure command: ./configure i386-redhat-linux --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --includedir=/usr/include --libdir=/usr/lib --libexecdir=/usr/libexec --localstatedir=/var --sharedstatedir=/usr/com --mandir=/usr/share/man --infodir=/usr/share/info --without-debug --without-readline --enable-shared --with-extra-charsets=complex --without-bench --localstatedir=/var/lib/mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --enable-assembler --with-mysqld-user=mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: putting an mark in the subject.
The from field is the original sender, not the list. Try to: and cc: jason What's wrong with creating a filter? Most e-mail programs of today allow for filters!! Just create a filter based on the from field where it equals [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: putting an mark in the subject.
Sorry, my mistake. Yes, you're right, the to: cc: - Original Message - From: "Jason Brooke" [EMAIL PROTECTED] To: "Rolf Hopkins" [EMAIL PROTECTED]; "John en Daphne Kuiper" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, January 17, 2001 9:50 Subject: Re: putting an mark in the subject. The from field is the original sender, not the list. Try to: and cc: jason What's wrong with creating a filter? Most e-mail programs of today allow for filters!! Just create a filter based on the from field where it equals [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
