[Fwd: Hi Glen, could I ask a favor regarding the MYSQL list?]
auto_parser wrote: Glen, Would you be able to forward the following message to the mysql list. I keep getting bounce-backs with the following: Recipient: mysql@lists.mysql.com Reason:Mail from HELO priv-edtnes27.telusplanet.net rejected because it does not accept bounces. This violates RFC 821/2505/2821 http://www.rfc-ignorant.org/ After contacting rfc-ignorant.org, they assured me it is a mistake in the way mysql is implementing the RFC protocol, and that I'm not on any black lists. As I can't contact the list, I can't resolve the issue. Unfortunately, my query optimization is a more pressing problem at this moment. Thanks for your help, Scott. * Question for MySQL: Subject: Select query optimization help! 45 seconds+ query... The following query is in desperate need of optimization. Any gurus out there who can share some insights, I'd greatly appreciate it. I have a request table, from which I'm pulling all records. Each request record has a part number, and for each requested part number, I'd like to query the inventory table for all matching inventory items for that part number, and calculate the potential value of the inventory. Each inventory record has 4 price fields, and it is the HIGHEST value of these fields used in the calculation. As you can tell by running the query, it is incredibly expensive. We have potentially millions of inventory records and 10,000+ requests, so the query is going to take several minutes to complete. Also, I found that due to the joining on each record(?), I couldn't implement a limit clause to save time. Whether or not a limit clause is tacked onto the end of the query, it completes the entire calculation process for both tables, and THEN returns the limited number of records. This of course saves me no time. :( Any help is greatly appreciated, Thanks. ps, all pertinent fields have already been indexed. This reduced the query time by half, but half of an eternity is still not that impressive. SELECT r.id, r.company, r.dateSent, r.fullName, r.phone, r.fax, r.email, r.address1, r.address2, r.city, r.province, r.country, r.comments, r.partNumber, r.description, r.dateCode, r.qty, r.targetPrice, r.manufacturer, r.expiryDate, r.companyType, r.yearEstablished, r.url, r.languages, GREATEST(i.distySellCost, i.originalCost, i.unitCost,i.unitSellCost)*r.qty AS 'highestValue', count(i.id) as 'matches', SUM(i.qty) as 'qtyAvailable' FROM request r LEFT JOIN inventory i ON ( i.MPN LIKE CONCAT(r.partNumber, '%') OR i.MPNClean LIKE CONCAT(r.partNumber, '%')) AND i.status=1 WHERE r.deleted=0 GROUP BY r.id; -- Gleb Paharenko [EMAIL PROTECTED] ---BeginMessage--- Glen, Would you be able to forward the following message to the mysql list. I keep getting bounce-backs with the following: Recipient: mysql@lists.mysql.com Reason:Mail from HELO priv-edtnes27.telusplanet.net rejected because it does not accept bounces. This violates RFC 821/2505/2821 http://www.rfc-ignorant.org/ After contacting rfc-ignorant.org, they assured me it is a mistake in the way mysql is implementing the RFC protocol, and that I'm not on any black lists. As I can't contact the list, I can't resolve the issue. Unfortunately, my query optimization is a more pressing problem at this moment. Thanks for your help, Scott. * Question for MySQL: Subject: Select query optimization help! 45 seconds+ query... The following query is in desperate need of optimization. Any gurus out there who can share some insights, I'd greatly appreciate it. I have a request table, from which I'm pulling all records. Each request record has a part number, and for each requested part number, I'd like to query the inventory table for all matching inventory items for that part number, and calculate the potential value of the inventory. Each inventory record has 4 price fields, and it is the HIGHEST value of these fields used in the calculation. As you can tell by running the query, it is incredibly expensive. We have potentially millions of inventory records and 10,000+ requests, so the query is going to take several minutes to complete. Also, I found that due to the joining on each record(?), I couldn't implement a limit clause to save time. Whether or not a limit clause is tacked onto the end of the query, it completes the entire calculation process for both tables, and THEN returns the limited number of records. This of course saves me no time. :( Any help is greatly appreciated, Thanks. ps, all pertinent fields have already been
Re: [Fwd: Hi Glen, could I ask a favor regarding the MYSQL list?]
On 7/12/05, Gleb Paharenko wrote: auto_parser wrote: Would you be able to forward the following message to the mysql list. I keep getting bounce-backs with the following: Recipient: mysql@lists.mysql.com Reason:Mail from HELO priv-edtnes27.telusplanet.net rejected because it does not accept bounces. This violates RFC 821/2505/2821 http://www.rfc-ignorant.org/ After contacting rfc-ignorant.org, they assured me it is a mistake in the way mysql is implementing the RFC protocol, and that I'm not on any black lists. The problem is not a blacklist. The problem is that priv-edtnes27.telusplanet.net resolves to a RFC 1918 address. Your message does not make clear which MTA gives this error, but if it is MySQL they are right to reject it. And if it isn't MySQL, you are barking up the wrong tree. As I can't contact the list, I can't resolve the issue. Sure you can: fix your DNS mail setup. Public facing DNS servers should not advertise RFC 1918 addresses. MUAs/MTAs should use the correct hostname in the HELO. I have a request table, from which I'm pulling all records. Each request record has a part number, and for each requested part number, I'd like to query the inventory table for all matching inventory items for that part number, and calculate the potential value of the inventory. Each inventory record has 4 price fields, and it is the HIGHEST value of these fields used in the calculation. As you can tell by running the query, it is incredibly expensive. We have potentially millions of inventory records and 10,000+ requests, so the query is going to take several minutes to complete. Can you show the EXPLAIN output? Which version are you using? Jochem -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
allow-subscribe not working on mysql list?
Hi, I've recently subscribed using the allow-subscribe method as described here: Posting from an alternative address when post are allowed only to subscribers.: http://www.ezmlm.org/ezman/ezman1.html But I'm still getting posts to the mysql lists on this address?? ezmlm did not complain when I set it up earlier this morning. /Per Jessen, Zurich -- http://www.spamchek.ch/freetrial - managed anti-spam and anti-virus solution. Lassen Sie sich überzeugen - 30 Tage Kostenlos! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[Stats] MySQL List: June 2004
-- Searchable archives for this list are available at http://www.listsearch.com/mysql.lasso -- == MySQL List Stats June, 2004 == Note: Up/Down % as compared with May, 2004 Posts: 1761 (Down 2%) Authors: 549 (Up 4%) Threads: 608 (Up 1%) Top 20 Contributors by Number of Posts -- SGreen 96 Michael Stassen 85 Victor Pendleton53 Egor Egorov 47 David Blomstrom 46 Paul DuBois 28 gerald_clark28 J S 26 Leonardo Francalanci23 Jeff Smelser22 Robert A. Rosenberg 20 Josh Trutwin16 Paul McNeil 15 Martijn Tonies 15 Eric Bergen 14 shaun thornburgh13 Andrew Pattison 13 David Griffiths 12 Daniel Clark11 Dan Nelson 11 Top 20 Threads by Number of Posts -- load data into 2 tables and set id 27 INDEX DESC 24 authentication error20 Unicode characters become question marks19 AUTO_INCREMENT problem... ER_DUP_ENTRY? (No, it's not a one byt... 13 Query Help 12 New to Dates - Plain English Please 12 strange table speed issue 12 Using REGEXP12 Production release of MySql 4.1 11 RE - Order By Problem 11 error 2711 Slow querys When ADSL is down on W2K10 Err 2002 socks suck noway to start 10 Idea to speed up multiple jdbc connections? 10 delete record that passed 1 day 10 odbc reverse10 Exporting/Importing Databases9 How to COUNT rows when they have a COUNT in them 9 Where are BLOBs / TEXTs stored? 9 Top 20 Search Terms by Number of Requests -- import 9 reference7 enum 6 reset5 update 5 Manual 5 query5 cache5 xml 5 speed4 MySQL4 DATA 4 mysqlcc 4 sql 4 weeknames4 filemaker4 temporary3 all 3 expiration
[Stats] MySQL List: May 2004
-- Searchable archives for this list are available at http://www.listsearch.com/mysql.lasso -- == MySQL List Stats May, 2004 == Note: Up/Down % as compared with April, 2004 Posts: 1789 (Down 2%) Authors: 528 (Down 3%) Threads: 604 (Down 4%) Top 20 Contributors by Number of Posts -- Egor Egorov 49 Victor Pendleton49 David Blomstrom 44 Paul DuBois 42 Sasha Pachev42 Victoria Reznichenko41 Michael Stassen 40 Jeremy Zawodny 34 SGreen 26 Lou Olsten 23 Jigal van Hemert21 Greg Willits19 Robert J Taylor 19 Daniel Kasak17 Josh Trutwin17 Michael Kruckenberg 17 David Griffiths 16 Dan Nelson 16 Donny Simonton 15 Daniel Clark15 Top 20 Threads by Number of Posts -- BLOB's - General Guidance 26 Simple table, 1.7 million rows, very slow SELECTs 20 fastest filesystem for MySQL19 1-Way or 2-Way Replication? 18 Very Strange data corruption18 urban myth? 17 Foreign Key Constraints 17 InnoDB - Foreign Key - Error 150. 14 FULLTEXT and large database 13 How to dump data in db.table syntax?12 INSERT INTO dropping slashes from strings 11 MySQL does not automatically start at BOOT time?? 11 InnoDB filesystem 11 OPTIMIZE TABLE and mySQL replication11 how do i encrypt the .frm file with a password 10 Search for relationships that aren't present10 Select distinct year from unix timestamp 9 Query question 9 need help with a complicated join9 DB hanging 9 Top 20 Search Terms by Number of Requests -- MySQL 19 to 13 server 12 Can't 11 connect 11 local 10 socket 6 through 6 missing 5 100615 daemon 5 update 4 join 4 Redhat 4 UDF 4 swedish 4 Function 4 tables 4 left
[Stats] MySQL List: April 2004
-- Searchable archives for this list are available at http://www.listsearch.com/mysql.lasso -- == MySQL List Stats April, 2004 == Note: Up/Down % as compared with March, 2004 Posts: 1816 (Down 15%) Authors: 543 (Down 14%) Threads: 627 (Down 17%) Top 20 Contributors by Number of Posts -- Paul DuBois 88 Michael Stassen 57 Egor Egorov 53 Victor Pendleton52 Victoria Reznichenko45 Dathan Vance Pattishall 29 Stormblade 29 Lou Olsten 20 Mark Susol | Ultimate Creative Media18 Jigal van Hemert17 Victor Medina 16 Ronan Lucio 16 Matt Chatterley 16 Jeremy Zawodny 15 lga215 Harald Fuchs15 Rhino 14 Donny Simonton 14 Martijn Tonies 13 beacker 12 Top 20 Threads by Number of Posts -- MySQL on Linux 18 Gripe with MySQL17 Perl Modelues 15 SELECT DISTINCT returns an incorrect result with special charac... 15 first LIMIT then ORDER 14 Datetime Default Value 13 mysqld too busy to check its grant tables? 13 MySQL and Unicode 12 MySQL Website 12 Unixware 7.1.0 compile error... mysql 4.0.1812 starting mysql daemon 11 Why can't I use an AS value in the WHERE clause. 11 stuck with simple query. Plz have a look11 Hey what, no pity for a new user? 11 Learning curve 10 Process Monitoring 10 mysql error file 9 SQL Query Question 9 Creating Users and Passwords 9 Unable to connect to mysql with phpmyadmin 8 Top 20 Search Terms by Number of Requests -- 104410 mysql 10 date 9 login8 update 7 weekdays 7 user 7 odbc 7 thread 6 database 6 ftp 5 cluster 5 Filemaker5 crystal 5 in 5 auto 5 blob 4 Permission 4 Madeleine
[Stats] MySQL List: March 2004
-- Searchable archives for this list are available at http://www.listsearch.com/mysql.lasso -- == MySQL List Stats March, 2004 == Note: Up/Down % as compared with February, 2004 Posts: 2143 (Up 9%) Authors: 632 (Up 7%) Threads: 749 (Up 7%) Top 20 Contributors by Number of Posts -- Sasha Pachev88 Egor Egorov 76 Victoria Reznichenko69 Paul DuBois 54 Victor Medina 39 vpendleton 37 Michael Stassen 35 Victor Pendleton23 Joshua J. Kugler23 Heikki Tuuri23 Scott Haneda23 Jigal van Hemert20 Martijn Tonies 20 Richard Davey 19 Rafael Diaz Valdes 18 Tim Cutts 18 Rhino 18 Donny Simonton 17 beacker 16 Daniel Kasak14 Top 20 Threads by Number of Posts -- Remove a RPM Installation 25 PgSQL vs MySQL 22 no one can log on any more 16 PHP script cannot connect MySQL server 16 Saving file into database 14 Security14 compiling with icc 14 ORDER BY RAND() performance 13 BETWEEN 12 How to optimize ugly order by? 12 Major problem converting MyISAM to InnoDB 11 Dream MySQL Server? 10 Newbie - Please help with createing database10 Difficult query and am kinda stuck how to continue can someone... 10 CURDATE() bug? 10 Scripting9 SQ puzzle9 mysql 1gb memory limit? 9 Optimizing Queries 9 Update field conditionally 9 Top 20 Search Terms by Number of Requests -- crystal 35 mysql 19 to 9 sort 9 data 8 load 8 image8 port 8 quotes 7 server 7 log 7 for 7 PHP 6 TABLE6 innodb 6 text 6 insert 6 country 5 tools
[Stats] MySQL List: February 2004
-- Searchable archives for this list are available at http://www.listsearch.com/mysql.lasso -- == MySQL List Stats February, 2004 == Note: Up/Down % as compared with January, 2004 Posts: 1948 (Down 11%) Authors: 588 (Down 10%) Threads: 696 (Down 10%) Top 20 Contributors by Number of Posts -- vpendleton 63 Egor Egorov 61 Sasha Pachev60 Victoria Reznichenko59 Paul DuBois 47 Chris Nolan 44 Michael Stassen 36 Martijn Tonies 27 Heikki Tuuri22 Scott Haneda18 Eric B. 17 Matt W 16 Rhino 15 Liying Huang14 Ligaya Turmelle 13 Arunachalam 13 Donny Simonton 13 Jochem van Dieten 12 Keith C. Ivey 12 Andrew Braithwaite 11 Top 20 Threads by Number of Posts -- Newbie Question 25 SQL2000 and MySql 19 How to determine when a MySQL database was last modified? 18 There has to be a way to do this14 Unique IDs 14 Query Problems 12 column being created as varchar() when char() requested.11 Bash script to MySql11 Mysql ECHILD resets on Queries 11 best-practices backups 11 Indexing Woes 11 InnoDB Hot Backup + MySQL embedded? 11 Can't create a new thread (errno 11)11 Trouble starting mysql 4.1.1 on Mac 10 GRANT question 10 install problem 10 Advise on High Availability configuration9 InnoDb Table Performance problem 9 Speed of MyISAM vs. InnoDB 9 fulltext search always returns no results9 Top 20 Search Terms by Number of Requests -- mysql 23 database13 odbc10 import 10 text10 lasso 10 how 9 table8 mac 8 many 8 external 8 copy 7 optimize 7 data 7 move 7 slow 7 InnoDB 6 to 6 99.9
[Stats] MySQL List: January 2004
-- Searchable archives for this list are available at http://www.listsearch.com/mysql.lasso -- == MySQL List Stats January, 2004 == Note: Up/Down % as compared with December, 2003 Posts: 2197 (Up 16%) Authors: 655 (Up 11%) Threads: 774 (Up 15%) Top 20 Contributors by Number of Posts -- Roger Baklund 63 robert_rowe 55 Tobias Asplund 40 Michael Stassen 36 Paul DuBois 36 Heikki Tuuri33 Mike Mapsnac28 Jochem van Dieten 28 Martijn Tonies 27 Victoria Reznichenko25 Matt W 22 mos 22 Daniel Kasak21 Hassan Shaikh 19 Mikhail Entaltsev 19 Mike Johnson18 sulewski18 Nitin Mehta 18 Steve Folly 16 Matthew Stuart 16 Top 20 Threads by Number of Posts -- transaction support 20 select lock - How reliable? 19 insert: auto increment field16 Bet the Business16 MySQL as document storage? 16 SQL Query Question 14 Slow query times14 Memory Problems on G5/OSX/MySql4.0.17 13 Enum default values 12 Automatic conversion from `char` TO `varchar` 12 anybody used prepared statements in 4.1 succesfully?11 Outer join question 10 Subtracting date fields 9 Time series 9 BUG IN MYSQL 9 Bug in Boolean mode fulltext searching. 9 Time Zone9 Too slow recovering mysqldump files 9 So, how do you REALLY install MySQL in Mac OS X (Panther)?! 9 A fun one9 Top 20 Search Terms by Number of Requests -- ODBC14 Installation12 memory 11 MySQL 10 blob10 mysqldump9 service 9 connection 8 update 8 xp 7 czech7 rows 6 password 6 filemaker6 udt 6 database 5 data 5 link 5
Tallkoz a kvetkezvel: 'MySQL List'
BEGIN:VCALENDAR PRODID:-//Microsoft Corporation//Outlook 11.0 MIMEDIR//EN VERSION:2.0 METHOD:REQUEST BEGIN:VEVENT ATTENDEE;ROLE=REQ-PARTICIPANT;RSVP=TRUE:MAILTO:[EMAIL PROTECTED] ORGANIZER:MAILTO:[EMAIL PROTECTED] DTSTART:20040117T11Z DTEND:20040117T113000Z TRANSP:OPAQUE SEQUENCE:0 UID:04008200E00074C5B7101A82E008B0352F3BEFDCC301100 023E0A6F1FEAEE9408DB4A936D48D1688 DTSTAMP:20040117T104414Z DESCRIPTION:When: 2004. janur 17. 12:00-12:30. Idzna: (GMT+01:00) Belgrd\, Budapest\, Ljubljana\, Pozsony\, Prga.\n\n*~*~*~*~*~*~*~*~*~*\n\n\n SUMMARY:Tallkoz a kvetkezvel: 'MySQL List' PRIORITY:5 X-MICROSOFT-CDO-IMPORTANCE:1 CLASS:PUBLIC BEGIN:VALARM TRIGGER:-PT15M ACTION:DISPLAY DESCRIPTION:Reminder END:VALARM END:VEVENT END:VCALENDAR -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[Stats] MySQL List: December 2003
- Searchable archives for this list are available at http://www.listsearch.com/mysql.lasso -- == MySQL List Stats December, 2003 == Note: Up/Down % as compared with November, 2003 Posts: 1839 (Down 2%) Authors: 582 (Down 4%) Threads: 659 (Down 2%) Top 20 Contributors by Number of Posts -- Chris Nolan 39 Egor Egorov 38 Heikki Tuuri37 Martijn Tonies 35 Paul DuBois 32 Michael Stassen 31 Jay Blanchard 30 Victoria Reznichenko27 ads mysql 24 Jeremy Zawodny 22 Sergei Golubchik19 Chuck Gadd 18 Matt W 16 Greg G 16 Roger Baklund 15 Duncan Hill 14 Tobias Asplund 14 mos 14 Daniel Kasak13 Mike Johnson13 Top 20 Threads by Number of Posts -- MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ? 44 Licence question20 foreign keys. 20 Login Problems 18 Quering user privileges 18 Export in XML 16 storing .tar files in mysql 16 How to READ/WRITE directly on MyISAM data files ? 15 error 1045 happened randomly13 How to Uninstall Mysql 13 datetime ORDER BY is erred 12 new install - command prompt doesn't work 12 How to create mysql user? 11 MySQL runs slow on windows 2003 10 Replication 9 Problem creating new user. 9 unixtime update syntax 8 Replication : blocking updates to slave 8 Query to emulate what mysqldump does 8 mysql user 8 Top 20 Search Terms by Number of Requests -- MySQL 12 join11 mysqldump 10 filemaker 10 Auto10 change 8 characters 8 field7 password 7 error7 language 7 windows 7 increment7 character7 in 6 Enter5 database 5 port 5 connect
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]
[Stats] MySQL List: November 2003
- Searchable archives for this list are available at http://www.listsearch.com/mysql.lasso -- == MySQL List Stats November, 2003 == Note: Up/Down % as compared with October, 2003 Posts: 1876 (Down 8%) Authors: 607 (Down 3%) Threads: 674 (Down 6%) Top 20 Contributors by Number of Posts -- Paul DuBois 54 Matt W 54 Jeremy Zawodny 51 Victoria Reznichenko36 Egor Egorov 34 Victor Pendleton31 gerald_clark26 Martijn Tonies 23 Roger Baklund 22 Nils Valentin 21 Dathan Vance Pattishall 21 Brent Baisley 20 Dan Greene 19 Mikael Fridh18 Gabriel Ricard 17 Paul Fine 17 Chris 16 Leo 16 Nestor Florez 14 Peter Sap 13 Top 20 Threads by Number of Posts -- Security Question 19 maintaining size of a db18 max_user_connections problem after upgrading17 Benchmark differences: Mac OS X - Linux 16 piping blob into shell command (tar)15 secure automated access (was Backing up all databases) 14 My.cnf 13 Functions and Procedures in Mysql 13 performance while creating indexes 12 InnoDB and raw tablespace 12 InnoDB Questions12 aes encryption bug 12 Mysql on panther11 Grant permissions problems - help 11 How To Learn php and mysql. 11 query time in ~3M row table 10 This is confusing..?10 Need help comparing MySQL to MS SQL Server 10 Backup question.10 replace query + RTFM? 10 Top 20 Search Terms by Number of Requests -- MySQL 25 error 18 Replication 15 time11 filemaker 11 key 10 server 10 Slave9 log 9 join 8 load 7 password 7 data 7 permission 7 index7 records 7 rebuild 7 table7
Re: MySQL List Digest ???
On Thu, Nov 06, 2003 at 01:48:46PM -0600, Paul Fine wrote: Thanks. I tried that awhile back to no avail. Hmm. Am I correct that I should be receiving only a single large e-mail each day? Thanks! Unless something is misconfigured, I'd expect you to get one message per day--unless the message is very large. Then it might be broken into multiple message. Some mailing lists do that. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 56 days, processed 2,111,622,566 queries (434/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL List Digest ???
Greetings. I have posted a few times to no avail on this matter. Choosing to receive a message digest should send me the daily posts in a single e-mail instead of getting individual e-mails every time someone posts? I cannot get it to happen. I have cancelled my sub and re-sub'd choosing the digest option. Am I missing something? Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL List Digest ???
On Thu, Nov 06, 2003 at 12:52:21PM -0600, Paul Fine wrote: Greetings. I have posted a few times to no avail on this matter. Choosing to receive a message digest should send me the daily posts in a single e-mail instead of getting individual e-mails every time someone posts? I cannot get it to happen. I have cancelled my sub and re-sub'd choosing the digest option. Am I missing something? I'd try the contact listed in the message headers: List-Help: mailto:[EMAIL PROTECTED] Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 53 days, processed 2,006,804,503 queries (431/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL List Digest ???
Thanks. I tried that awhile back to no avail. Am I correct that I should be receiving only a single large e-mail each day? Thanks! -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: Thursday, November 06, 2003 1:22 PM To: Paul Fine Cc: [EMAIL PROTECTED] Subject: Re: MySQL List Digest ??? On Thu, Nov 06, 2003 at 12:52:21PM -0600, Paul Fine wrote: Greetings. I have posted a few times to no avail on this matter. Choosing to receive a message digest should send me the daily posts in a single e-mail instead of getting individual e-mails every time someone posts? I cannot get it to happen. I have cancelled my sub and re-sub'd choosing the digest option. Am I missing something? I'd try the contact listed in the message headers: List-Help: mailto:[EMAIL PROTECTED] Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 53 days, processed 2,006,804,503 queries (431/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[Stats] MySQL List: October 2003
-- Searchable archives for this list are available at http://www.listsearch.com/mysql.lasso -- == MySQL List Stats October, 2003 == Note: Up/Down % as compared with September, 2003 Posts: 2042 (Up 0%) Authors: 623 (Up 4%) Threads: 720 (Down 3%) Top 20 Contributors by Number of Posts -- Paul DuBois 65 Director General: NEFACOMP 56 Dathan Vance Pattishall 47 Victoria Reznichenko46 Roger Baklund 38 Jeremy Zawodny 37 Matt W 35 Nitin 33 Heikki Tuuri30 gerald_clark30 Egor Egorov 29 Fortuno, Adam 24 Rory McKinley 23 Gabriel Ricard 22 Wang Feng 21 Dan Greene 21 Randy Chrismon 20 bluejack19 Chris Nolan 18 Jeff McKeon 16 Top 20 Threads by Number of Posts -- printing reports23 MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1 17 MySQL not null vs MSAccess required 14 Challenging query 14 web interface...13 InnoDB or OS restriction? 13 Anyone using MySQL 4.x on Apple's G5? 13 Error 1045 12 Check for data before inserting 12 Mysql Performance Question 11 Really slow query (compared with Visual FoxPro) 11 DB not restoring from dump file 11 Is MySQL Relational? (was: Foreigner keys in MySQL?)11 can NOT drop the database 10 Views in MYSQL 10 Data from two tables in one query 10 How do I restrict a mysql user only can work on a database 10 how to export data from multiple tables 9 Easy (?) conditional SELECT 9 Installation problem 9 Top 20 Search Terms by Number of Requests -- MySQL 30 database17 lasso 14 to 13 table 12 password11 log 10 index 10 ssl 10 data 9 4.0 9 Informix 8 server 8 in 8 copy 8 sql 8 count8 from 8 week
[Stats] MySQL List Stats; September 2003
-- Searchable archives for this list are available at http://www.listsearch.com/mysqltalk.lasso -- == MySQL List Stats September, 2003 == Note: Up/Down % as compared with August, 2003 Posts: 2038 (Down 5%) Authors: 597 (Down 2%) Threads: 740 (Up 7%) Top 20 Contributors by Number of Posts -- Jeremy Zawodny 84 Paul DuBois 82 Victoria Reznichenko59 Heikki Tuuri48 Egor Egorov 41 Dathan Vance Pattishall 37 Director General: NEFACOMP 34 Matt W 32 Antony Dovgal 24 Dan Greene 23 Randy Chrismon 19 Lenz Grimmer18 Fortuno, Adam 17 Tbird67ForSale 17 daniel 16 Kelley Lingerfelt 16 Keith C. Ivey 15 Dan Nelson 14 Andy Eastham14 Sergei Golubchik14 Top 20 Threads by Number of Posts -- Does NULL == ?29 Table is full error 17 Show database problem 12 Platform vs. Performance12 Ideas on creating connections 12 How to enable General Query_log?11 insert ... select .. order by, problem 10 SubQueries and IN 10 ERROR 1030: Got error 127 from table handler 10 OS X Installation and Setup 10 Lock tables in myisam 10 innodb 10 Select from one table where ID not in another table 9 Compling on RedHat 9 9 SELECT only unique records 9 Unique Key Violation - How to determine which key9 Usage Monitoring 9 MySQL newbie: table gone after reboot9 FOREIGN KEY Weirdness in mySQL 4.1 with VARCHAR 9 'IF NOT EXISTS' ignored? 9 Top 20 Search Terms by Number of Requests -- Can't 32 thread 26 create 26 a 26 new 26 Error 16 delete 15 mysql 12 query_cache 9 fulltext 9 null 9 select 8 multiple 8 value8 join 7 set 6 to 6 update 6 increment
Mysql list admin
I don't see a admin email address in the headers of the musql email list emails, for the past few days, every post I make, I get one of these from someone... Return-Path: Received: from fc.jcca.org (204.141.205.3) by hostwizard.com with ESMTP (Eudora Internet Mail Server 3.2.1) for [EMAIL PROTECTED]; Sun, 14 Sep 2003 18:35:28 -0700 Message-id: [EMAIL PROTECTED] Date: Sun, 14 Sep 2003 21:37:21 + Subject: NDN: Re: Sort order X-FC-Icon-ID: 2031 X-FC-MachineGenerated: true To: Scott Haneda [EMAIL PROTECTED] From: [EMAIL PROTECTED] MIME-Version: 1.0 Content-type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Sorry. Your message could not be delivered to: mysql blah (Mailbox or Conference is full.) Who do I report this to? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[Stats] MySQL List Stats: August, 2003
List Archives: http://www.ListSearch.com/mysql.lasso MySQL List Stats August, 2003 Note: Up/Down % as compared with July, 2003 Posts: 2148 (Down 16%) Authors: 608 (Down 17%) Threads: 683 (Down 23%) Top 20 Contributors by Number of Posts Victoria Reznichenko 79 Nils Valentin 69 Jeremy Zawodny57 Roger Baklund 56 Egor Egorov 49 Paul DuBois 36 Hans van Harten 32 Heikki Tuuri 32 Dathan Vance Pattishall 28 Antony Dovgal 24 Cybot 23 Andy Jackman 21 Keith C. Ivey 20 Dan Nelson19 Morten Gulbrandsen19 Rajesh Kumar 18 Michael S. Fischer17 Jay Blanchard 16 colbey16 Fred van Engen15 Top 20 Threads by Number of Posts Slow results with simple, well-indexed query 27 MySQL running out of date 19 Replication problem 17 MySQL Replication 16 Joins and Unions 16 CREATE TABLE, INSERT INTO with SELECT in parentheses 16 Searching on Two Keys with OR?15 mysql LOAD DATA INFILE15 RAID or not? 15 Cant login as a user I thought I created 14 Oracle DBA here looking for advice on MySQL 14 Server to Server Connection 13 Mast-Master Replication 13 PHP mysql_connect randomly failing13 Corrupt index = mysqld freeze?12 Nested SELECT statements problem 11 table error 127 11 PHP or Perl? 11 myisamchk question (important)11 Need help optimizing query, awfully slow on only 2000... 11 Top 20 Search Terms by Number of Requests FULLTEXT 14 Mysql 13 host.frm 13 filemaker 11 date 11 join 11 import 9 stamp 8 conditional8 backup 7 unicode7 file 7 SLAVE 7 Can't 7 STOP 7 unique 7 utf-8 6 mac6 key6 load 6 -- - Bill Doerrfeld[EMAIL PROTECTED] Blue World Communications, Inc. http://www.blueworld.com/ - Build and serve powerful data-driven Web sites with Lasso Studio and Lasso Professional. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL List Stats July, 2003
Be sure to visit the MySQL list archives at http://www.listsearch.com/mysql.lasso. Here are stats for last month. Enjoy! Bill MySQL List Stats July, 2003 Note: Up/Down % as compared with June, 2003 Posts: 2556 (Down 6%) Authors: 733 (Down 2%) Threads: 882 (Down 2%) Top 20 Contributors by Number of Posts Nils Valentin100 Paul DuBois 95 Victoria Reznichenko 80 Egor Egorov 67 Rudy Metzger 66 Heikki Tuuri 57 gerald_clark 32 Jeff McKeon 26 Jeremy Zawodny25 Jim McAtee21 Sergei Golubchik 21 colbey21 Dathan Vance Pattishall 20 Dan Nelson20 Andrew Braithwaite19 Primaria Falticeni19 Info 17 Ola Ogunneye 17 Michael Satterwhite 16 Asif Iqbal16 Top 20 Threads by Number of Posts What is a good benchmark? 26 Error 1044 Error 2003 on 4.0.13 and RH9 20 What's up with this GATOR crap? 17 Can run two versions of MySQL in Windows 2000? 16 Faster reindexing 15 MySQL vs. PostgreSQL -- speed test15 Working with the text datatype in MySQL 14 how to limit COUNT(*) 14 mysql stops processing14 CSV Formated output 13 Can mysql handle this load? 13 MySQL Password12 Newbie SELECT problem 12 Frequent Table Corruption - Please Help 12 Books advice 12 ERROR 2013:Lost connection to MySQL server11 mysqldump 11 recursive sql statement 11 does mySQL support a boolean data type? 11 Huge Server configuration 11 Top 20 Search Terms by Number of Requests mysql 27 database 18 utf 13 table 13 key 12 query 11 innodb11 delete11 column11 set 10 to10 php 10 status 9 lasso 9 date 9 server 9 sql9 replication9 OSX8 where 8 -- - Bill Doerrfeld[EMAIL PROTECTED] Blue World Communications, Inc. http://www.blueworld.com/ - Build and serve powerful data-driven Web sites with Lasso Studio and Lasso Professional. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL List Archives Stats for June 2003
MySQL List Archives Stats June, 2003 Note: Up/Down % as compared with May, 2003 Posts: 2723 (Up 12%) Authors: 745 (Up 10%) Threads: 900 (Up 6%) Top 20 Contributors by Number of Posts Nils Valentin147 Paul DuBois 126 Becoming Digital 113 Mike Hillyer 89 Jeremy Zawodny72 Victoria Reznichenko 55 Egor Egorov 52 Roman Neuhauser 48 gerald_clark 44 Heikki Tuuri 34 Jay Blanchard 29 Bruce Feist 26 Mark Matthews 25 Don Read 25 Keith C. Ivey 20 Curtis Maurand20 Christensen, Dave 19 tlr7425 15 Primaria Falticeni15 Dathan Vance Pattishall 14 Top 20 Threads by Number of Posts RAID hardware suggestions/experience 26 mysql.sock doesn't exist 23 mysql query output get wrapped22 Best Pratices for mySQL Backups in Enterprise 18 mySQL GUIs17 Triggers 17 mysql ended error 16 Odd thing 15 Anyone had a chance to try an Opteron yet?14 Practice test 13 Which database? 13 Set no root password 12 Can we crypt passwords on MySQL 12 XML in MySQL 12 URGENT problem with mysql processes 12 Advanced Query Help (My brain hurts!) 12 SELECTing last occurences from a table11 I thought single UPDATE statements were atomic11 forming foreign keys 10 alter table blocks other tables! 10 Top 20 Search Terms by Number of Requests table 37 mysql 30 index 23 error 22 tables21 load 21 import20 file 19 foreign 18 innodb17 Blob 16 key 16 not 14 select13 mysqldump 13 insert13 data 12 windows 12 mysql.server 11 from 11 -- - Bill Doerrfeld[EMAIL PROTECTED] Blue World Communications, Inc. http://www.blueworld.com/ - Build and serve powerful data-driven Web sites with Lasso Studio and Lasso Professional. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL List Stats for May, 2003
As some of you know, we host the MySQL list searchable archives at ListSearch.com as a free service to the MySQL community. To access said archives, visit http://www.listsearch.com/mysql.lasso. The archives not only allow you to search on various fields of information (body, date, subject, author, etc.) and to view threads, but, we keep lots of stats, including the number of searches performed and a log of all search terms used when accessing the archives. You can see what other people are searching about! Here are the stats for the MySQL list for May, 2003. You can see these updated every 1/2 hour by clicking the Browse tab at ListSearch.com. Enjoy! Bill == MySQL List Archives Stats May, 2003 == Note: Up/Down % as compared with April, 2003 Posts: 2398 (down 9%) Authors: 669 (down 13%) Threads: 846 (down 10%) Top 20 Contributors by Number of Posts - Nils Valentin 23 Becoming Digital20 Paul DuBois 14 Mike Hillyer12 Heikki Tuuri12 Victoria Reznichenko9 trogers 9 Egor Egorov 9 Roman Neuhauser 8 Jay Blanchard 8 Asif Iqbal 8 Karam Chand 7 Daniel Crompton 7 Anthony Ward7 Stefan Hinz 6 Tim Meader 5 Kieran Kelleher 5 Jerry 5 Bruce Feist 5 Terry Riley 4 Top 20 Threads by Number of Posts - mysql query output get wrapped 22 SELECTing last occurences from a table 11 Displaying numbers with results - any id... 8 Advice on improving our current method 8 Suggestions on joins/merges 7 nested ORDER BY statements 7 Specifics on using join multiple table... 6 Patch Submittal -- Documentation6 Mysql / PHP image link problem. 6 Is this an inefficient query? 6 efficient query or not? 6 debuggine 1205 / LOCK wait timeout excee... 6 cant grant privileges?! 6 Why does auto increment not take into ac... 5 QUESTION ABOUT DATA AND INDEX FILE DIREC... 5 NEWBIE QUESTION: Copying Databases from... 5 MySql data between Linux and Windows5 Insert query5 Inserting data? 5 help creating foreign keys 5 Top 20 Search Terms by Number of Requests - source 7 apache 7 starting6 myodbc 6 installation6 x5095 osx 5 load5 4 5 trouble 4 order 4 mysql 4 image 4 #NAME? 4 mysql++ 3 install 3 high3 error 3 corruption 3 compile 3 -- - Bill Doerrfeld[EMAIL PROTECTED] Blue World Communications, Inc. http://www.blueworld.com/ - Build and serve powerful data-driven Web sites with Lasso Studio and Lasso Professional. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[Correction] MySQL List Stats for May, 2003
--- Please ignore my prior post on this. The numbers were wrong as it turned out I inadvertently based a portion of the report on numbers from June, 2003. Please find below the correct report. --- As some of you know, we host the MySQL list searchable archives at ListSearch.com as a free service to the MySQL community. To access said archives, visit http://www.listsearch.com/mysql.lasso. The archives not only allow you to search on various fields of information (body, date, subject, author, etc.) and to view threads, but, we keep lots of stats, including the number of searches performed and a log of all search terms used when accessing the archives. You can see what other people are searching about! Here are the stats for the MySQL list for May, 2003. You can see these updated every 1/2 hour by clicking the Browse tab at ListSearch.com. Enjoy! Bill == MySQL List Archives Stats May, 2003 == Note: Up/Down % as compared with April, 2003 Posts: 2398 (down 9%) Authors: 669 (down 13%) Threads: 846 (down 10%) Top 20 Contributors by Number of Posts - Egor Egorov 65 Victoria Reznichenko61 Jeremy Zawodny 61 Mike Hillyer57 Paul DuBois 43 Curtis Maurand 39 Stefan Hinz 34 Heikki Tuuri33 James Moe 29 Dan Nelson 28 Keith C. Ivey 27 colbey 27 Becoming Digital27 Daniel Rossi25 Nils Valentin 24 Dathan Vance Pattishall 24 gerald_clark23 Martin Gainty 20 Michael T. Babcock 19 Karam Chand 19 Top 20 Threads by Number of Posts - How to fill an Blob with binary data24 MySQL stupid mailing list format15 AMD 15 Select statement driving me crazy 14 replace 14 storing large files in blob... 13 Red Hat rpms... 13 count() 13 a database design question 13 problem with C and mysql 4 12 Slow queries on 4.0.13, FreeBSD 4.8 STAB... 11 Replication 11 Practical samples for table types 11 Need your help in setting up database. 11 MySQL WAP 11 Mysql failover configuration11 How to write this query pls?11 changing mysqld deamon ownership. 11 Version 5.0 and Stored procedures 10 Unexpected empty table performance probl... 10 Top 20 Search Terms by Number of Requests - mysql 39 table 29 Error 22 to 20 update 18 tables 15 case13 replication 12 connect 12 FILE11 Server 10 access 10 socket 9 query 9 list9 how 9 failed 9 denied 9 can't 9 aix 9 -- - Bill Doerrfeld[EMAIL PROTECTED] Blue World Communications, Inc. http://www.blueworld.com/ - Build and serve powerful data-driven Web sites with Lasso Studio and Lasso Professional. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL List Stats for May, 2003
I am not sure if I will use it often, but definitely well done ;-) Very clear organization of the data. Thats definitely something which will be highly appreciated by most list members (and MySQL AB) I am sure !! Best regards Nils Valentin Tokyo/Japan 2003 6 5 06:55Bill Doerrfeld : As some of you know, we host the MySQL list searchable archives at ListSearch.com as a free service to the MySQL community. To access said archives, visit http://www.listsearch.com/mysql.lasso. The archives not only allow you to search on various fields of information (body, date, subject, author, etc.) and to view threads, but, we keep lots of stats, including the number of searches performed and a log of all search terms used when accessing the archives. You can see what other people are searching about! Here are the stats for the MySQL list for May, 2003. You can see these updated every 1/2 hour by clicking the Browse tab at ListSearch.com. Enjoy! Bill == MySQL List Archives Stats May, 2003 == Note: Up/Down % as compared with April, 2003 Posts: 2398 (down 9%) Authors: 669 (down 13%) Threads: 846 (down 10%) Top 20 Contributors by Number of Posts - Nils Valentin 23 Becoming Digital 20 Paul DuBois 14 Mike Hillyer 12 Heikki Tuuri 12 Victoria Reznichenko 9 trogers 9 Egor Egorov 9 Roman Neuhauser 8 Jay Blanchard 8 Asif Iqbal8 Karam Chand 7 Daniel Crompton 7 Anthony Ward 7 Stefan Hinz 6 Tim Meader5 Kieran Kelleher 5 Jerry 5 Bruce Feist 5 Terry Riley 4 Top 20 Threads by Number of Posts - mysql query output get wrapped22 SELECTing last occurences from a table11 Displaying numbers with results - any id... 8 Advice on improving our current method8 Suggestions on joins/merges 7 nested ORDER BY statements7 Specifics on using join multiple table... 6 Patch Submittal -- Documentation 6 Mysql / PHP image link problem. 6 Is this an inefficient query? 6 efficient query or not? 6 debuggine 1205 / LOCK wait timeout excee... 6 cant grant privileges?! 6 Why does auto increment not take into ac... 5 QUESTION ABOUT DATA AND INDEX FILE DIREC... 5 NEWBIE QUESTION: Copying Databases from...5 MySql data between Linux and Windows 5 Insert query 5 Inserting data? 5 help creating foreign keys5 Top 20 Search Terms by Number of Requests - source7 apache7 starting 6 myodbc6 installation 6 x509 5 osx 5 load 5 4 5 trouble 4 order 4 mysql 4 image 4 #NAME?4 mysql++ 3 install 3 high 3 error 3 corruption3 compile 3 -- - Bill Doerrfeld[EMAIL PROTECTED] Blue World Communications, Inc. http://www.blueworld.com/ - Build and serve powerful data-driven Web sites with Lasso Studio and Lasso Professional. -- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [Correction] MySQL List Stats for May, 2003
Hi Bill, Such a pitty. For a moment I thought I am the new No.1 ;-) (see previous posted data) Best regards Nils Valentin Toko/Japan 2003 6 5 07:29Bill Doerrfeld : --- Please ignore my prior post on this. The numbers were wrong as it turned out I inadvertently based a portion of the report on numbers from June, 2003. Please find below the correct report. --- As some of you know, we host the MySQL list searchable archives at ListSearch.com as a free service to the MySQL community. To access said archives, visit http://www.listsearch.com/mysql.lasso. The archives not only allow you to search on various fields of information (body, date, subject, author, etc.) and to view threads, but, we keep lots of stats, including the number of searches performed and a log of all search terms used when accessing the archives. You can see what other people are searching about! Here are the stats for the MySQL list for May, 2003. You can see these updated every 1/2 hour by clicking the Browse tab at ListSearch.com. Enjoy! Bill == MySQL List Archives Stats May, 2003 == Note: Up/Down % as compared with April, 2003 Posts: 2398 (down 9%) Authors: 669 (down 13%) Threads: 846 (down 10%) Top 20 Contributors by Number of Posts - Egor Egorov 65 Victoria Reznichenko 61 Jeremy Zawodny61 Mike Hillyer 57 Paul DuBois 43 Curtis Maurand39 Stefan Hinz 34 Heikki Tuuri 33 James Moe 29 Dan Nelson28 Keith C. Ivey 27 colbey27 Becoming Digital 27 Daniel Rossi 25 Nils Valentin 24 Dathan Vance Pattishall 24 gerald_clark 23 Martin Gainty 20 Michael T. Babcock19 Karam Chand 19 Top 20 Threads by Number of Posts - How to fill an Blob with binary data 24 MySQL stupid mailing list format 15 AMD 15 Select statement driving me crazy 14 replace 14 storing large files in blob...13 Red Hat rpms... 13 count() 13 a database design question13 problem with C and mysql 412 Slow queries on 4.0.13, FreeBSD 4.8 STAB... 11 Replication 11 Practical samples for table types 11 Need your help in setting up database.11 MySQL WAP 11 Mysql failover configuration 11 How to write this query pls? 11 changing mysqld deamon ownership. 11 Version 5.0 and Stored procedures 10 Unexpected empty table performance probl... 10 Top 20 Search Terms by Number of Requests - mysql 39 table 29 Error 22 to20 update18 tables15 case 13 replication 12 connect 12 FILE 11 Server10 access10 socket9 query 9 list 9 how 9 failed9 denied9 can't 9 aix 9 -- - Bill Doerrfeld[EMAIL PROTECTED] Blue World Communications, Inc. http://www.blueworld.com/ - Build and serve powerful data-driven Web sites with Lasso Studio and Lasso Professional. -- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL List
My apologies if this is covered somewhere, but is there a web interface to change mailing list options such as MIME/Plaintext digest options ? The EZMLM respone page from mysql-help does not reference a web interface or other commands for controlling list options. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
digest mode for mysql list
hi list, Is there a way i can subscribe to this list as a digest user's mode, Similar to mailman's digest feature. I was trying to get to the mailman user's preference page but cannot find it on mysql.com. Can anyone help me out here. thanks, MT - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: digest mode for mysql list
Is there a way i can subscribe to this list as a digest user's mode, Similar to mailman's digest feature. I was trying to get to the mailman user's preference page but cannot find it on mysql.com. Can anyone help me MySQL uses ezmlm. You need to unsubscribe from this list and subscribe to the digest list. You can do the subscribe here: http://www.mysql.com/documentation/lists.php -- Jonathan Arnold (mailto:[EMAIL PROTECTED]) Amazing Developments http://www.buddydog.org It ain't what you don't know that gets you into trouble. It's what you know for sure that just ain't so. Mark Twain - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[Reminder] MySQL list archives at ListSearch.com
Are you looking for a comprehensive searchable archive of all posts to this MySQL list? Would you prefer to use archives that are actually powered by MySQL (version 4)? Are you interested to see what other people are searching for as it pertains to MySQL? Are you interested in seeing how many authors, posts and threads are posted to the MySQL list over any given time period? For all of this and much more, please be sure to check out the Blue World ListSearch.com service provided free to the MySQL community. You're cordially invited to visit http://www.listsearch.com/mysql.lasso. Happy searching. Enjoy! Bill -- - Bill Doerrfeld[EMAIL PROTECTED] Blue World Communications, Inc. http://www.blueworld.com/ - Build and serve powerful data-driven Web sites with Lasso Studio and Lasso Professional. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[Reminder] MySQL list archives at ListSearch.com
Are you looking for a comprehensive searchable archive of all posts to this MySQL list? Would you prefer to use archives that are actually powered by MySQL (version 4)? Are you interested to see what other people are searching for as it pertains to MySQL? Are you interested in seeing how many authors, posts and threads are posted to the MySQL list over any given time period? For all of this and much more, please be sure to check out the Blue World ListSearch.com service provided free to the MySQL community. You're cordially invited to visit http://www.listsearch.com/mysql.lasso. Happy searching. Enjoy! Bill -- - Bill Doerrfeld[EMAIL PROTECTED] Blue World Communications, Inc. http://www.blueworld.com/ - Build and serve powerful data-driven Web sites with Lasso Studio and Lasso Professional. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FYI: superior searchable MySQL list archives at
http://www.listsearch.com/mysql.lasso - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql list question
This may be a (hmmmpf) dumb question or maybe the docs say, but I cannot find it. When posting this list regarding sql, query, and other info :) does the list server modify the posts to a maximum width? (For all using terminals to browse?) If so what is the line width? (80 characters?) I wanted to be within the bounds of 'good reading'. Thanks! Regards, Kelly Black Sprint PCS 18200 Von Karman Irvine, Ca. 92612 949-623-5417 Linux was very clearly the answer, but what was the question again? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[ANN] MySQL list archives on ListSearch.com
Greetings MySQL Colleagues: Last week during Lasso Summit 2002, Blue World announced the immediate availability of the MySQL list archives on ListSearch.com. ListSearch.com provides a wealth of features--including automatic message threading and statistical reporting based on number of posts by date, author, threads, search terms and much more. To view last week's announcement which provides additional details, please visit http://www.blueworld.com/blueworld/news/10.15.02-MySQL.html. To jump right to the MySQL list archives at ListSearch.com, visit http://www.ListSearch.com/mysql.lasso. A whole ton of effort went into providing this service in support of the MySQL community. And, the site is powered by MySQL 4 along with the recently released Lasso Professional 6 Web application server. Enjoy! Bill -- - Bill Doerrfeld[EMAIL PROTECTED] Blue World Communications, Inc. http://www.blueworld.com/ - Build and serve powerful data-driven Web sites with Lasso Studio and Lasso Professional. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Archive of this mysql list
Is there an archive of all posts to this mysql list that I can search somewhere? Chris Becker MCDBA MCSE http://www.PrismSoftware.com [EMAIL PROTECTED] sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Archive of this mysql list
Yep, It's here http://www.mysql.com/documentation/searchlists.html Cheers, Andrew Sql,query -Original Message- From: Chris Becker [mailto:[EMAIL PROTECTED]] Sent: Friday, 04 October 2002 00:43 To: [EMAIL PROTECTED] Subject: Archive of this mysql list Is there an archive of all posts to this mysql list that I can search somewhere? Chris Becker MCDBA MCSE http://www.PrismSoftware.com [EMAIL PROTECTED] sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Archive of this mysql list
Ahem, have a look at the bottom of any post to the list: Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) :) HTH, William. -Original Message- From: Chris Becker [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 16:43 To: [EMAIL PROTECTED] Subject: Archive of this mysql list Is there an archive of all posts to this mysql list that I can search somewhere? Chris Becker MCDBA MCSE http://www.PrismSoftware.com [EMAIL PROTECTED] sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Query : RE: How do i unsubscribe from the mysql list
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 12:01 PM To: Roma Subject: Re: How do i unsubscribe from the mysql list 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: Hi, I am just wondering, how can i unsubscribe from this list. I am sure, i can block this email address, but i would prefer to unsubscribe. anybody has the instructions. I would really appreciate that thanks roma - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Query : RE: How do i unsubscribe from the mysql list
[snip] I am just wondering, how can i unsubscribe from this list. I am sure, i can block this email address, but i would prefer to unsubscribe. anybody has the instructions. I would really appreciate that [/snip] Uhlook at the message footer, where it says To unsubscribe, e-mail mysql-unsubscribe-...? Jay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL List
I've sent a couple of messages to the MySQL list today that didn't seem to get through. Have there been any problems with the list and/or the manager today? One of them was returned as being too large to be posted and it really wasn't all that long. One of them never made it through and was never returned. This one was originally returned as spam since it didn't contain any words related to sql, mysql or query. Are the list filters or posting rules available somewhere to read? Here's the question I had earlier from the first message that was returned. I have a small c program that is supposed to run a select query against a MySQL database. It keeps bombing with a segfault during what I think is the db connect. I recompiled everything with debug and ran mysql_debug in the code and am getting the following: 1: dbug: libmysql.c: 1176:1: mysql_real_connect 2: dbug: libmysql.c: 1178:1: | enter: host: fett db: CHANGELOG user: youngd 3: dbug: libmysql.c: 1294:1: | info: Server name: 'fett'. TCP sock: 1073830556 4: dbug: violite.c: 103:2: | vio_new 5: dbug: violite.c: 104:2: | | enter: sd=3 6: dbug:my_malloc.c:31:3: | | my_malloc 7: dbug:my_malloc.c:32:3: | | | my: Size: 84 MyFlags: 16 8: dbug:my_malloc.c:48:3: | | | exit: ptr: 8072d68 9: dbug:my_malloc.c:49:3: | | my_malloc 10: dbug: violite.c: 126:2: | vio_new 11: dbug: libmysql.c: 1346:1: | error: Got error 111 on connect to 'fett' 12: dbug: libmysql.c: 1568:1: | error: message: 2003 (Can't connect to MySQL server on 'fett' (111)) 13: dbug: libmysql.c: 622:2: | end_server 14: dbug: libmysql.c: 626:2: | | info: Net: TCP/IP (3) 15: dbug: violite.c: 341:3: | | vio_close 16: dbug: violite.c: 362:3: | | | vio_error: close() failed, error: 107 17: dbug: violite.c: 367:3: | | vio_close 18: dbug:my_malloc.c:58:3: | | my_free 19: dbug:my_malloc.c:59:3: | | | my: ptr: 8072d68 20: dbug:my_malloc.c:62:3: | | my_free 21: dbug:my_malloc.c:58:3: | | my_free 22: dbug:my_malloc.c:59:3: | | | my: ptr: 333a3630 Segmentation fault It doesn't generate a core dump by the way. If I run a strace on the same binary I get: connect(3, {sin_family=AF_INET, sin_port=htons(23196), sin_addr=inet_addr(192.168.5.3)}}, 16) = -1 ECONNREFUSED (Connection refused) shutdown(3, 2 /* send and receive */) = -1 ENOTCONN (Transport endpoint is not connected) close(3)= 0 --- SIGSEGV (Segmentation fault) --- +++ killed by SIGSEGV +++ Any ideas what error 111 and/or 2003 is? Other thoughts? The actual debug used in the code is: mysql_debug(d:t:F:L:n:N:P:o:, /tmp/client.trace); The username/password/host/database all work fine from the mysql client as well as from other programs that use similar shared code as the one that's broken. Thanks, Darren Young [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
Mysql List bug?
Mysql list serve manager, Could this be a bug in the mysql listserv. Tedd Richards tried to unsubscribe and I am getting the confirmation e-mail to confirm that I really want to un-subscribe, when, I haven't emailed an unsubscribe request in the frist place. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, June 29, 2002 8:04 AM Subject: confirm unsubscribe from [EMAIL PROTECTED] Hi! This is the ezmlm program. I'm managing the [EMAIL PROTECTED] mailing list. To confirm that you would like [EMAIL PROTECTED] removed from the mysql mailing list, please send an empty reply to this address: Usually, this happens when you just hit the reply button. If this does not work, simply copy the address and paste it into the To: field of a new message. I haven't checked whether your address is currently on the mailing list. To see what address you used to subscribe, look at the messages you are receiving from the mailing list. Each message has your address hidden inside its return path; for example, [EMAIL PROTECTED] receives messages with return path: mysql-return-number[EMAIL PROTECTED] Some mail programs are broken and cannot handle long addresses. If you cannot reply to this request, instead send a message to [EMAIL PROTECTED] and put the entire address listed above into the Subject: line. --- Administrative commands for the mysql list --- I can handle administrative requests automatically. Please do not send them to the list address! Instead, send your message to the correct command address: To subscribe to the list, send a message to: [EMAIL PROTECTED] To remove your address from the list, send a message to the address in the List-Unsubscribe header of messages from the list. If you don't know how to display headers and haven't changed E-mail addresses since subscribing, you'll be successful with an e-mail to: [EMAIL PROTECTED] Send mail to the following for info and FAQ for this list: [EMAIL PROTECTED] [EMAIL PROTECTED] Similar addresses exist for the digest list: [EMAIL PROTECTED] [EMAIL PROTECTED] To get messages 123 through 145 (a maximum of 100 per request), mail: [EMAIL PROTECTED] To get an index with subject and author for messages 123-456 , mail: [EMAIL PROTECTED] They are always returned as sets of 100, max 2000 per request, so you'll actually get 100-499. To receive all messages with the same subject as message 12345, send an empty message to: [EMAIL PROTECTED] The messages do not really need to be empty, but I will ignore their content. Only the ADDRESS you send to is important. You can start a subscription for an alternate address, for example [EMAIL PROTECTED], just add a hyphen and your address (with '=' instead of '@') after the command word: [EMAIL PROTECTED] To stop subscription for this address, mail: [EMAIL PROTECTED] In both cases, I'll send a confirmation message to that address. When you receive it, simply reply to it to complete your subscription. If despite following these instructions, you do not get the desired results, please contact my owner at [EMAIL PROTECTED] Please be patient, my owner is a lot slower than I am ;-) --- Enclosed is a copy of the request I received. Return-Path: [EMAIL PROTECTED] Received: (qmail 25046 invoked from network); 29 Jun 2002 15:04:54 - Received: from mtiwmhc22.worldnet.att.net (204.127.131.47) by www.mysql.com with SMTP; 29 Jun 2002 15:04:54 - Received: from dell866 ([12.77.147.176]) by mtiwmhc22.worldnet.att.net (InterMail vM.4.01.03.27 201-229-121-127-20010626) with ESMTP id 20020629151310.JATW20395.mtiwmhc22.worldnet.att.net@dell866 for [EMAIL PROTECTED]; Sat, 29 Jun 2002 15:13:10 + Message-ID: 01ee01c21f7f$84589260$1300a8c0@dell866 From: Teddy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Date: Sat, 29 Jun 2002 11:13:22 -0400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary==_NextPart_000_01EB_01C21F5D.FB47C700 X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6600 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 This is a multi-part message in MIME format. --=_NextPart_000_01EB_01C21F5D.FB47C700 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable --=_NextPart_000_01EB_01C21F5D.FB47C700 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=3DContent-Type content=3Dtext/html; = charset=3Diso-8859-1 META content=3DMSHTML 5.50.4522.1800 name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVnbsp;/DIV/BODY/HTML --=_NextPart_000_01EB_01C21F5D.FB47C700-- - Before posting, please check: http
to mysql list administrators
To list mysql list administrator: Why do I receive this auto responder after posting to this list -- start We acknowledge with thanks your email and thanking you once again in showing your interest with our organization. Our HRD Team will get back to you as soon as possible. Best Regards Team Pentagon Consultants -- end Is this a list problem? Thank you -- Anibal Cascais Santos www.engrenagem.net -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: to mysql list administrators
Hi. On Thu 2002-06-20 at 17:24:53 +0100, [EMAIL PROTECTED] wrote: To list mysql list administrator: Why do I receive this auto responder after posting to this list I am not a list administrator, but know the answer anyhow. ;-) You get this mail, because someone with a very poor auto-responder[1] has subscribed to the list with the wrong address[2]. The problem can be solved either by the list adminstrator, by unsubscribing the offending address. Or by the owner/postmaster of the offending address by using a less crappy auto-responder (or by re-subscribing with a more reasonable address). Regards, Benjamin. [1] any reasonable auto-responder would recognize that it is a bulk mail from a mailing list and would not answer. [2] there is no sense to subscribe with an address which is obviously used for commercial contact purposes. [...] -- start We acknowledge with thanks your email and thanking you once again in showing your interest with our organization. Our HRD Team will get back to you as soon as possible. [...] -- [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
Is the general MySQL list available via NNTP?
The volume on this list is so big that it desperately needs to be available as a newsgroup. I was able to find one on Google groups as mailing.database.mysql but does anyone know of a publicly available NNTP server which carries this? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Is the Mysql list down?
I am just checking to see if the mysql server is down I haven't gotten any e-mails today? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ABOUT: Guidelines for Posting to the MySQL list
Hi everybody, I proposed these posting guidelines some time ago, and there was some discussion on the list about them. Thanks for the input, everyone. Since then there has been discussion and some fine tuning with the MySQL folks, and we have come up with the final version that you'll see in the accompanying email. I'll be maintaining these Guidelines, and posting them to the list about twice a month. I sincerely hope you'll take the time to read the Guidelines, and that you'll try to follow them. We'll all benefit. This document will probably evolve over time as the character of the list does. Feedback is welcome and encouraged. Flames /dev/null : Regards, Robert Alexander Maintainer of the MySQL Posting Guidelines. [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: Guidelines for Posting to the MySQL list
Those are nice guidelines and will do my best to keep in them But, no joke, I got an E-mail from [EMAIL PROTECTED] that the subject start's out massey,darling! Now I know I'm cute but:) Cheers M;) -Original Message- From: Robert Alexander [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 9:39 PM To: [EMAIL PROTECTED] Subject: Guidelines for Posting to the MySQL list NOTE: This message is posted periodically to the MySQL List on behalf of all members of the MySQL mailing list. Please read it carefully before posting. This document can be retrieved from: ftp://ftp.workmate.ca/pub/MySQL/mysql-posting-guidelines.txt The Short Version: - Be Polite. Respect others. - Post a SUMMARY of the answers you get to your questions. - Trim your reply. Quote only the needed text. - This is the MySQL list -- stay on topic. - No SPAM. The Real Version: Dear prospective MySQL List poster, We ask your kind co-operation in making the MySQL list a more valuable, effective resource for all of us in our community who use it. Before posting, please stop for a minute and consider whether or not your posting is suitable for the MySQL List. The list is not intended for just any possible question related to database software and development. The only appropriate questions for the MySQL List are questions about the use of the MySQL database software products that are NOT answered in the manuals or system documentation, in the mailing list archives, or in the MySQL FAQ. These are the rules for posting to the MySQL list: - Remember that busy people are giving freely of their time to help you. Respect that. If you want help from the best, don't waste their time. You are expected to have done your basic homework -- the list is not a place to go because you 'don't have time' to read the manual. The list is there for when you've tried your best, made a real effort, and are genuinely stuck. - You have to repay the favour. You are required to post a single SUMMARY of the email responses to your question. The SUMMARY contains the original question, explains the solution that solved the problem, and names and thanks the folks who helped you. This solution will then be in the archives, available to everyone. This increases our community's store of knowledge, and helps to prevent the same questions from being posted to the list every other day. - Those who don't post a SUMMARY are likely to find future questions going unanswered. - Don't post off-topic questions. Eg. PHP questions not directly related to MySQL go to the PHP list. - Replies should usually be directed to the POSTER and not to the list. This keeps traffic and clutter down. - When you post a message with a SQL query in it, take the time to make the query easily readable. It's easier on the people who want to help you, and you're more likely to get a timely, helpful response. - Never be rude or talk badly about other people or products. By avoiding things like this, you are much more likely to get help when it's your time of need. In particular, the following kinds of postings are -NOT- appropriate: - Subscribe and unsubscribe messages. See your email headers/footers for subscribe and unsubscribe instructions. - Test messages of any sort. - *Extended* discussions about anything, including discussions about the list itself, or numerous followups to any posting. Concise, polite discussion of MySQL pertinent topics, however, is encouraged. - Postings not related to MySQL software or its use. Use the appropriate newsgroup or mailing list instead. For example, if your question concerns sendmail, please consult the comp.mail.sendmail newsgroup or the www.sendmail.org website. - General OS, network, or software questions. Use the appropriate newsgroup, eg. comp.unix.questions instead. - Postings claiming to be 'URGENT!' when they are not are particularly inappropriate. They are also dishonest and disrespectful of the other list members. If your needs are time critical, you might want to consider having a commercial support agreement with MySQL AB (http://www.mysql.com/support). - Questions already answered in the Archives or FAQ. Read the Archives or FAQ instead. If you're not sure if the question is in there, please look before asking. You can find the archives at: http://lists.mysql.com/ or http://archive.workmate.ca/myarchive and the FAQ at: http://www.bitbybit.dk/mysqlfaq - Questions that are answered in the excellent on-line manuals or system documentation. Read the manuals instead. If you're not sure if the question is answered in the manuals, please look first! - Job postings, requests for jobs, sales pitches, etc. Get permission from the MySQL staff first ([EMAIL PROTECTED]), or use the appropriate newsgroup instead. - Please, no postings
How to unsubsribe from the mysql list?
Hi all, Could you please tell me how to unsubsribe from the mysql list? Thanks, Li Bing _.._ .' '-. `. __/__(-. `\ \ /o `o \ \\ \ _\__.__/ ))|| ; .--; || \ (`) || \ _|`---' .' _, _||`\ '`_\ \ '_,.-';_.-`\| \ \_ .' '--'---;` / / |\ |_..--' \ \'-'.' .--'.__/__.-; `` (___...---''` \ _/_\ /ASU\ [EMAIL PROTECTED] \___/ 480-965-9038(L), 602-743-9767(C) http://www.public.asu.edu/~libing
Re: How to unsubsribe from the mysql list?
Dear Wheeler, I forgot the authorization code o mysql list. I need it to usubscribe. How can I do? Thank so much! Li Bing - Original Message - From: Alfred Wheeler [EMAIL PROTECTED] To: Li Bing [EMAIL PROTECTED] Sent: Sunday, March 17, 2002 9:08 AM Subject: Re: How to unsubsribe from the mysql list? Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Original Message - From: Li Bing [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, March 17, 2002 2:51 AM Subject: How to unsubsribe from the mysql list? Hi all, Could you please tell me how to unsubsribe from the mysql list? Thanks, Li Bing _.._ .' '-. `. __/__(-. `\ \ /o `o \ \\ \ _\__.__/ ))|| ; .--; || \ (`) || \ _|`---' .' _, _||`\ '`_\ \ '_,.-';_.-`\| \ \_ .' '--'---;` / / |\ |_..--' \ \'-'.' .--'.__/__.-; `` (___...---''` \ _/_\ /ASU\ [EMAIL PROTECTED] \___/ 480-965-9038(L), 602-743-9767(C) http://www.public.asu.edu/~libing - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replication question to MySQL list
Replication with temporary table issue: HostA: MySQL 3.23.42-log HostB: MySQL 3.23.42 Replication: HostA --to-- HostB Issue: After followed the MySQL Manual recommendation to: SET SQL_LOG_BIN = 0; to create, insert and drop a temporary table, example: SET SQL_LOG_BIN = 0; CREATE TEMPORARY TABLE tempTableA ... INSERT INTO tempTableA ... SET SQL_LOG_BIN = 1; INSERT INTO nomalTableB SELECT * FROM tempTableA --- it does not work because tempTableA table has not been replicated. Question: Is there a work around for this problem, other than make tempTableA a normalTableA to get a good replication of it ? Thank you in advance. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql list test - ignore
I apologize for using bandwidth...it appears my posts are no longer going to the [EMAIL PROTECTED] mailing list. I'm just verifying before rteporting it, if necessary magic words: sql,database,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
help to unsubscribe from MySQL list
Hi, please can anyone help me. I want to unsubscribe from this list. But all messages to [EMAIL PROTECTED] and also messages to the List-Unsubscribe header part will have no effect. My problem is, that I want to go to holiday tomorrow and I want not forward all the mails from this list to my boss ;-) To bypass the spam filter, I must include the words SQL and/or Query ;-) Best thanks in advance, Peter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
searchable archives of mysql list
Hi, There used to be a link to searchable archives of the mysql list on the old mysql web site. Is there still a link to it somewhere? Thanks, Ben - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: searchable archives of mysql list
http://lists.mysql.com/ (the list archive) (This is at the end of each email) - Original Message - From: Ben Olasov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 9:40 PM Subject: searchable archives of mysql list Hi, There used to be a link to searchable archives of the mysql list on the old mysql web site. Is there still a link to it somewhere? Thanks, Ben - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: searchable archives of mysql list
Sorry, I just re-subscribed just to ask this question and didn't actually read any of the messages. Thanks for pointing this out. B On Wed, 16 Jan 2002, Marinos wrote: http://lists.mysql.com/ (the list archive) (This is at the end of each email) - Original Message - From: Ben Olasov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 9:40 PM Subject: searchable archives of mysql list Hi, There used to be a link to searchable archives of the mysql list on the old mysql web site. Is there still a link to it somewhere? Thanks, Ben - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Dont want to unsubscribe from mysql list
Im not very happy about this :( Someone is trying to unsubscribe me from the MySQL mailing list! I havent confirmed the request as I dont want to unsubscribe. Who is '[EMAIL PROTECTED]' ??? Andrew Murphy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 25 October 2001 11:17 am To: [EMAIL PROTECTED] Subject: confirm unsubscribe from [EMAIL PROTECTED] Hi! This is the ezmlm program. I'm managing the [EMAIL PROTECTED] mailing list. To confirm that you would like [EMAIL PROTECTED] removed from the mysql mailing list, please send an empty reply to this address: SNIP ... SNIP --- Enclosed is a copy of the request I received. Return-Path: [EMAIL PROTECTED] Received: (qmail 12535 invoked from network); 25 Oct 2001 10:16:34 - Received: from unknown (HELO mail4.citiz.net) (61.151.248.37) by www.mysql.com with SMTP; 25 Oct 2001 10:16:34 - Received: (mail 72245 invoked by uid 0); 25 Oct 2001 10:19:52 - Received: from unknown (HELO wuhaihua) (61.169.79.15) by mail4.citiz.net with SMTP; 25 Oct 2001 10:19:52 - Date: Thu, 25 Oct 2001 18:26:16 +0800 From: =?ISO-8859-1?Q?=CE=E2=BA=A3=BB=AA?= [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Subject: X-mailer: FoxMail 3.11 Release [cn] Mime-Version: 1.0 Content-Type: text/plain; charset=GB2312 Content-Transfer-Encoding: quoted-printable mysql-unsubscribe-andrew.murphy=3Dase-solutions.co.uk=A3=AC=C4=FA=BA=C3=A3=A 1 [EMAIL PROTECTED] =D6=C2 =C0=F1=A3=A1 =CE=E2=BA=A3=BB=AA [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
Proposed Guidelines for Posting to the MySQL list
Hi everyone, There's been some discussion recently on the need for a FAQ and posting guidelines for the MySQL list. I got to thinking about that... : I belong to another list, called the SunMangers list. (I'm sure there's other SunMangers members here. Hi! : ) The SunManagers list is a wonderful resource for getting timely help for those times when you're stuck and just can't get something to work correctly. Some of the top people in the Sun world are on that list, and they can be very generous with their time to help others. That list has been in existence for a *long* time, and is so successful because the members have developed some rules to make it work well. I asked the SunManagers Information Files maintainer, John DiMarco [EMAIL PROTECTED], if I could create a set of guidelines for the MySQL list based on those that are posted regularly to the SunManagers list, and he graciously gave his permission. I'm also volunteering to maintain this document, and to post it periodically to the list. So, here's the proposed Guidelines. Take a look. Thoughts and constructive comments are welcome and encouraged. Flames go to /dev/null : Thanks everybody! -- Guidelines for Posting to the MySQL list - NOTE: This message is posted periodically to the MySQL List on behalf of all members of the MySQL mailing list. Please read it carefully before posting. This document can be retrieved from: [proposed: ftp.workmate.ca] Dear prospective MySQL List poster, We ask your kind co-operation in making the MySQL list a more valuable, effective resource for all of us in our community who use it. Before posting, please stop for a minute and consider whether or not your posting is suitable for the MySQL List. The list is not intended for just any possible question related to database software and development. The only appropriate questions for the MySQL List are questions about the use of the MySQL database software products that are NOT answered in the manuals or system documentation, in the mail archives, or in the MySQL FAQ. These are the rules for posting to the MySQL list: - Remember that busy people are giving their time to help you. Respect that. If you want help from the best, don't waste their time. You are expected to have done your basic homework -- the list is not a place to go because you 'don't have time' to read the manual. The list is there for when you've tried your best, made a real effort, and are genuinely stuck. - You have to repay the favour. You are required to post a single SUMMARY of the email responses to your question. The SUMMARY contains the original question, explains the solution that solved the problem, and names and thanks the folks who helped you. This solution will then be in the archives, available to everyone. This increases our community's store of knowledge, and helps to prevent the same questions from being posted to the list every other day. - Don't post off-topic questions. Eg. PHP questions not directly related to MySQL go to the PHP list. - Replies are directed to the POSTER and not to the list. This keeps traffic and clutter down. - Those who don't post a SUMMARY are likely to find future questions going unanswered. In particular, the following kinds of postings are NOT appropriate: - Subscribe and unsubscribe messages. See your email headers for subscribe and unsubscribe instructions. - Test messages of any sort. - Extended discussions about anything, including discussions about the list itself, or numerous followups to any posting. - Postings not related to MySQL software or its use. Use the appropriate newsgroup or mailing list instead. For example, if your question concerns sendmail, please consult the comp.mail.sendmail newsgroup or the www.sendmail.org website. - General OS, network, or software questions. Use the appropriate newsgroup, eg. comp.unix.questions instead. - Postings that are not time-critical. Postings claiming to be 'URGENT!' when they are not are particularly inappropriate. They are also dishonest and disrespectful of the other list members. - Questions already answered in the Archives or FAQ. Read the Archives or FAQ instead. If you're not sure if the question is in there, please look before asking. You can find the archives at http://lists.mysql.com/ and the FAQ at: [future-location-of-FAQ] - Questions that are answered in the excellent manuals or system documentation. Read the manuals instead. If you're not sure if the question is answered in the manuals, please check first! - Job postings, requests for jobs, sales pitches, etc. Get permission from the MySQL staff first, or use the appropriate newsgroup instead. - Please, no postings in HTML, rich-text-format, Microsoft Word, Word Perfect, or any format that some people
Re: Proposed Guidelines for Posting to the MySQL list
Robert Alexander wrote: - Replies are directed to the POSTER and not to the list. This keeps traffic and clutter down. - Those who don't post a SUMMARY are likely to find future questions going unanswered. So answers to questions go directly to the poster and are not cc'd to the list? I suppose it's more efficient because each discussion thread has only a question and it's summary both posted by the same author. But won't this make the list a bit sterile? Other authors wont be able to participate in a discussion and there wont be the public aggregation of viewpoints - just a reliance on the original poster (many of whom are newbies) to consolidate all replies they receive and post a coherent summary based on individual emails. I took a look at the SunManager's archive and it seems that many of the questions don't have summary posts. I'm not a subscriber though, so perhaps I missed something. I also find it useful sometimes when browsing the archives to look at all posts in each thread because sometimes they provide insights into related issues. I think summary posts are definitelly a must, but users should be required to cc the list when replying to posts. Also descriptive tags are really useful in the subject. For example the mod_perl (perl under Apache - http://perl.apache.org) list uses the following: --snip-- 5.2.8. It can be helpful if you use a tag [in square brackets] in the Subject: line, as well as the brief description of your post. It does not matter whether you use [UPPER CASE] or [lower case] or even a [Mixture Of Both] in the tag. Some suggested tags are: ADMIN Stuff about running the List. ADVOCACY Promoting the use of mod_perl, printing T-shirts, stuff like that. Please don't start another discussion about whether we should put this on a different list, we've been there before. ANNOUNCE Announcements of new software tools, packages and updates. ASP Joshua Chamas' implementation of Perl embedded in HTML. BENCHMARK Apache/mod_perl performance issues. BUG Report of possible fault in mod_perl or associated software - it's better if you can send a patch instead! DBI Stuff generally concerning Apache/mod_perl interaction with databases. FYI For information only. JOB Any post about mod_perl jobs is welcome as long as it is brief and to the point. Note: Not JOBS. MASON Jonathan Swartz' implementation of Perl embedded in HTML. NEWS Items of news likely to be interesting to mod_perlers. OffTopic Or [OT] Off-topic items, please try to keep traffic low. PATCH Suggested fix for fault in mod_perl or associated software. QUESTION Questions about mod_perl which is not covered by one of the more specific headings. RareModules Occasional reminders about little-used modules on CPAN. RFC Requests for comment from the mod_perl community. SITE Stuff about running the Apache/mod_perl servers. SUMMARY After investigation and perhaps fixing a fault, and after an extended discussion of a specific topic, it is helpful if someone summarizes the thread. Don't be shy, everyone will appreciate the effort. If you can't find a tag which fits your subject, don't worry. If you have a very specific subject to discuss, feel free to choose your own tag, for example [mod_proxy] or [Perl Sections] but remember that the main reasons for the Subject: line are to save people time and to improve the response to your posts. --snip-- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Proposed Guidelines for Posting to the MySQL list
- Original Message - From: Robert Alexander [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, October 21, 2001 1:29 PM Subject: Proposed Guidelines for Posting to the MySQL list There's been some discussion recently on the need for a FAQ and posting guidelines for the MySQL list. I got to thinking about that... : That's great! Overall, I think that these guidelines have a lot of merit, but I can't help but feel that they should be coming more from MySQL AB, than the list itself. If they have a vision for the resource that the mailing lists should provide, then its guidelines should come from MySQL AB. - Replies are directed to the POSTER and not to the list. This keeps traffic and clutter down. This is one of the few points I disagree with. The archives of this list, if used properly, is probably one of the best support resources out there right now. One of the reasons is because there tends to be some back-and-forth until a correct answer is determined. Following the thread of responses to a particular query can be of great benefit. The antithesis of this rule is that individual posters MAY NOT be contacted. This prevents the experts on the list from being flooded with direct queries, which does not benefit the list as a whole. I know that when I am directly contacted, either out of the blue or as a follow-up to an answer, I encourage the writer to post to the list since providing answers one-on-one does not benefit the list. Therefore, I would propose that the guidelines include that all questions answers (when relevant) remain on the appropriate MySQL list. - Job postings, requests for jobs, sales pitches, etc. Get permission from the MySQL staff first, or use the appropriate newsgroup instead. If I remember correctly, the MySQL lists are open - you do not have to be a member to post to the list. As long as the lists remain this way, they will always be open to these kinds of postings, including outright spam. There is a filter in place, but my understanding is that any letter beginning with Dear MySQL community: (or some variation containing MySQL) will get through. I think you would have to work with the MySQL staff to really tighten the list to meet stricter requirements. Note also that there's a good chance your question has been answered in the past. Please spend a minute or two checking one of the MySQL List archives, eg. the one at the MySQL site (http://lists.mysql.com/). See above; this archive is a great resource because all answers stay on the list - we should definitely try to keep it this way. Good Luck, Dennis Salguero ** Beridney Computer Services [EMAIL PROTECTED] http://www.beridney.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Proposed Guidelines for Posting to the MySQL list
Re: Proposed Guidelines for Posting to the MySQL list - Replies are directed to the POSTER and not to the list. This keeps traffic and clutter down. This I think is the only point that I have an issue with. If you look above, there are two (at least right now) replies posting that this is a bad idea. however if all those replies went to the recepient, I wouldn't have known that this is posted and would post the same thing again. Another problem: suppose there are two solutions: a well known and not so well known. Suppose someone asks something and the first thing people do is send the well known idea. However if that doesn't work, since there is no feedback, noone even thinks to send the secondary rare idea (that might not even come to mind). Also, someones reply might be helpful but not great and someone else on the list might, looking at the reply, come up with an even better posting. The problem here is that usually posters will get a gazillion mails with same reply instead of two or three with possibly unique solutions. All of these lead me to believe that having the replies sent to the list is better and serves the community better. OT: BTW, can you email me a pointer to the SunManagers list? Is it the one at sunmanagers.org? Cause I thought that one was ran by MrBill. If it's that one, then no link is needed, I am subscribed to that one. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Proposed Guidelines for Posting to the MySQL list
Robert Alexander wrote: - Replies are directed to the POSTER and not to the list. This keeps traffic and clutter down. At 22:12 +0100 2001/10/21, Mark Maunder wrote: Other authors wont be able to participate in a discussion and there wont be the public aggregation of viewpoints - just a reliance on the original poster (many of whom are newbies) to consolidate all replies they receive and post a coherent summary based on individual emails. At 14:45 -0700 2001/10/21, Dennis Salguero wrote: This is one of the few points I disagree with. The archives of this list, if used properly, is probably one of the best support resources out there right now. One of the reasons is because there tends to be some back-and-forth until a correct answer is determined. Following the thread of responses to a particular query can be of great benefit. At 18:19 -0400 2001/10/21, Victor wrote: This I think is the only point that I have an issue with. If you look above, there are two (at least right now) replies posting that this is a bad idea. however if all those replies went to the recepient, I wouldn't have known that this is posted and would post the same thing again. Thanks so much for taking the time to respond, guys. There does seem to be a general consensus about keeping more discussion on the list. I confess it's one of the points I thought longest about. The SunManagers list is much more of an I need a solution NOW kind of list, whereas the MySQL list has always had more open discussion. As a matter of fact, the SunManagers list has no discussion whatsoever. Ideally, the only postings there are question and summary. It doesn't always happen that way, of course, but that's what's strived for in that list. I don't think I'd want the MySQL list to be completely 'discussion free' either. That's why I included this: In particular, the following kinds of postings are NOT appropriate: snip - Extended discussions about anything, including discussions about the list itself, or numerous followups to any posting. Which would allow for some discussion, just not long, wandering, rambles. : Is that enough? Do we need more? How do we walk the line between keeping lively discussion, and reducing the bulk of postings? (open for ideas...) --- At 14:45 -0700 2001/10/21, Dennis Salguero wrote: That's great! Overall, I think that these guidelines have a lot of merit, but I can't help but feel that they should be coming more from MySQL AB, than the list itself. If they have a vision for the resource that the mailing lists should provide, then its guidelines should come from MySQL AB. Thanks Dennis. IRT MySQL AB, I don't think I'm stepping on anyone's toes, here, and it's certainly not my intent to dictate policy to the list or anyone else. If I am, I'm sure someone from MySQL will let me know, at which point I'll gracefully bow out. This is simply a proposed set of guidelines, meant to stimulate an exchange of ideas, and lead to an even better discussion group. This is an Open Source community, after all, : and I think it's important to contribute. I'm just trying to do a bit of my part, even if it's a relatively small task like this. Whatever 'culture' or 'style' our on-line list community has is ultimately determined by the actions of the individual people involved. If we can collectively agree on some basic rules, we all benefit. --- At 18:19 -0400 2001/10/21, Victor wrote: Another problem: suppose there are two solutions: a well known and not so well known. Suppose someone asks something and the first thing people do is send the well known idea. However if that doesn't work, since there is no feedback, noone even thinks to send the secondary rare idea (that might not even come to mind). Also, someones reply might be helpful but not great and someone else on the list might, looking at the reply, come up with an even better posting. The problem here is that usually posters will get a gazillion mails with same reply instead of two or three with possibly unique solutions. At 14:45 -0700 2001/10/21, Dennis Salguero wrote: See above; this archive is a great resource because all answers stay on the list - we should definitely try to keep it this way. Well, if people post their summaries, then the answers WILL always be in the archives, won't they. : And in a more concise, usable form because you won't need to search through multiple messages to find that bit of wisdom you need. Also, I've seen it happen often that someone may read a SUMMARY and realize that they have something to add to the solution. That idea is also sent off the original question-asker, who posts another summary. It's not uncommon to see second, and sometimes even third, summaries to the same question. Thanks, /Rob - Before
Re: Proposed Guidelines for Posting to the MySQL list
On Sun, Oct 21, 2001 at 04:29:45PM -0400, Robert Alexander wrote: Hi everyone, I belong to another list, called the SunMangers list. (I'm sure there's other SunMangers members here. Hi! : ) The SunManagers list is a wonderful resource for getting timely help for those times when you're stuck and just can't get something to work correctly. Some of the top people in the Sun world are on that list, and they can be very generous with their time to help others. SunManagers is an excellent list to model in some ways. So, here's the proposed Guidelines. Take a look. Thoughts and constructive comments are welcome and encouraged. Flames go to /dev/null : [snip] One of the things that most deters me from helping someone is when they post SQL in a format which requires me to mentally reformat it just so I can understand what it does. When I see that, I usually hit D and go on. Strongly suggest that folks post CLEAN and READABLE code (SQL, Perl, PHP, whatever) otherwise those of us without the time to reformat someone else's laziness will just blow past it. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 45 days, processed 999,429,709 queries (252/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Proposed Guidelines for Posting to the MySQL list
There's been some discussion recently on the need for a FAQ and posting guidelines for the MySQL list. I got to thinking about that... : cut Both already exist: FAQ: http://www.bitbybit.dk/mysqlfaq - although not created and maintained by MySQL AB, I believe it does answer most of the common questions - and I happen to know that the editor is very keen on adding stuff that others are willing to submit :-) Posting guidelines: Read The Fine Manual, ch. 1.2.22 - it's been in there forever, though most people seem to forget to either read or to follow them rant(this goes for some of the @mysql.com people too, especially the point about only including the relevant parts of the original message in a reply)/rant -- Guidelines for Posting to the MySQL list - cut There are some more good points in these guidelines. But seriously: I don't think anyone is willing to read what amounts to two or three printed pages before starting posting. Human beings are simply too lazy to do that, especially when sitting with a problem they need solved yesterday. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql List Bounce Message?
Carl Troein writes: Jason Frisvold writes: Can anyone explain why I'm getting a Mail account is disabled message from [EMAIL PROTECTED] regarding anything I post to the mysql list? Yep, that server uses some sort of broken software which mistakes the sender for the receiver or does something similarly braindead. If someone from MySQL reads this, PLEASE do delete whatever domainhost.com address is causing this problem. Hi, I have already searched our subscription database for anyone with a domainhost.com address, and there are none. We have managed to contact an admin at domainhost.com and they say they are working on it. :-\ Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA ___/ 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: Mysql List Bounce Message?
The same for me! The only difference is the domain is some other things else instead of domainhost.com -Jason - Original Message - From: Matt Wagner [EMAIL PROTECTED] To: Carl Troein [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, September 22, 2001 4:14 PM Subject: Re: Mysql List Bounce Message? Carl Troein writes: Jason Frisvold writes: Can anyone explain why I'm getting a Mail account is disabled message from [EMAIL PROTECTED] regarding anything I post to the mysql list? Yep, that server uses some sort of broken software which mistakes the sender for the receiver or does something similarly braindead. If someone from MySQL reads this, PLEASE do delete whatever domainhost.com address is causing this problem. Hi, I have already searched our subscription database for anyone with a domainhost.com address, and there are none. We have managed to contact an admin at domainhost.com and they say they are working on it. :-\ Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql List Bounce Message?
Can anyone explain why I'm getting a Mail account is disabled message from [EMAIL PROTECTED] regarding anything I post to the mysql list? The body of the message says : The mail account ([EMAIL PROTECTED]) is currently disabled, and is not receiving mail at this time. Thanks, --- Jason H. Frisvold Senior ATM Engineer Engineering Dept. Penteledata CCNA Certified - CSCO10151622 [EMAIL PROTECTED] --- So Long and Thanks for all the Fish -- Douglas Adams [1952-2001] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 List Bounce Message?
Jason Frisvold writes: Can anyone explain why I'm getting a Mail account is disabled message from [EMAIL PROTECTED] regarding anything I post to the mysql list? Yep, that server uses some sort of broken software which mistakes the sender for the receiver or does something similarly braindead. If someone from MySQL reads this, PLEASE do delete whatever domainhost.com address is causing this problem. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql List Bounce Message?
As near as I can figure there are a few people out there that have yet to setup their MTA's correctly, so they think they're receiving messages for any addresses in the headers of the email. Jason Frisvold wrote: Can anyone explain why I'm getting a Mail account is disabled message from [EMAIL PROTECTED] regarding anything I post to the mysql list? The body of the message says : The mail account ([EMAIL PROTECTED]) is currently disabled, and is not receiving mail at this time. Thanks, --- Jason H. Frisvold Senior ATM Engineer Engineering Dept. Penteledata CCNA Certified - CSCO10151622 [EMAIL PROTECTED] --- So Long and Thanks for all the Fish -- Douglas Adams [1952-2001] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql List Bounce Message?
Also, a simple fix for you sendmail guru's HFrom: tab $check_from Scheck_from [EMAIL PROTECTED] tab $#error $@ 5.5.5 $: Broken MTA, Message ignored Cheers. Colin Faber wrote: As near as I can figure there are a few people out there that have yet to setup their MTA's correctly, so they think they're receiving messages for any addresses in the headers of the email. Jason Frisvold wrote: Can anyone explain why I'm getting a Mail account is disabled message from [EMAIL PROTECTED] regarding anything I post to the mysql list? The body of the message says : The mail account ([EMAIL PROTECTED]) is currently disabled, and is not receiving mail at this time. Thanks, --- Jason H. Frisvold Senior ATM Engineer Engineering Dept. Penteledata CCNA Certified - CSCO10151622 [EMAIL PROTECTED] --- So Long and Thanks for all the Fish -- Douglas Adams [1952-2001] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Mysql List Bounce Message?
That would explain it... I appreciate the prompt replies :) Thanks! sql --- Jason H. Frisvold Senior ATM Engineer Engineering Dept. Penteledata CCNA Certified - CSCO10151622 [EMAIL PROTECTED] --- Only two things are infinite, the universe and human stupidity, and I'm not sure about the former. -- Albert Einstein [1879-1955] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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++: List of databases, then tables in each database
Using the MySQL++ library is their any call to 1) Get a list of the databases on the Server 2) List tables in a database given a database name. The best I could find was show databases show tables; or show tables from database name; Does anyone have any examples of how to implement these calls in Visual C++ using the MySQL++ API's ANY INPUT APPRECIATED I am using the Visual C++ library for development under MS VC++ 6 on Windows 2000 Advanced Server. *** Just another quick question; I have a line of code (below) but it does not output the query to the screen. In this case the query is Select * from Employees limit 20 but (below) causes just Query: to be displayed. Query query = con.query(); query select * from Employees limit 20; cout Query: query.preview() endl; Sorry if you get this for a second time - I didn't get much of a response from the plusplus mailing list. I assure you I have checked the web site and manual Thanks lots David Ayliffe (mailto:[EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql List Web Archive ?
Please tell me the web archive of this mailing list , so i not bother you for some already answered questions. Thanks, Moin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 List Web Archive ?
lists.mysql.com It is printed at the bottom of every message posted to list. On 4/6/01 10:54 AM, "Khan, Moin" [EMAIL PROTECTED] wrote: Please tell me the web archive of this mailing list , so i not bother you for some already answered questions. Thanks, Moin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql List Web Archive ?
"Khan, Moin" [EMAIL PROTECTED] wrote: Please tell me the web archive of this mailing list , so i not bother you for some already answered questions. Well, you can use the URL listed at the bottom of every email sent to this list (the 2nd URL below): - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) Or you can use a 3rd party archive like: http://marc.theaimsgroup.com/?l=mysql -- 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