Re: alter table example.
Matt, alter table table_name add column column_name column_decriptions; alter table table_name drop column column_name; Try checking documentation for more details: http://www.mysql.com/doc/A/L/ALTER_TABLE.html Hope this helps! Can anyone give me an example of an alter table syntax that. 1.) adds a column 2.) deletes a column. I am reading the examples in the oreilly book, and it does not work also the Oracle or Infomix syntax doesn't work. can someone give me a clue please. Thanks, Matt. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php John Barton [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: SSH tunnel MySQL traffic: BOTH remote local?
Try mapping your remote mysql to a different local port, then specify that port number when you connect. For example: 'ssh -L 3307:hostip:3306 hostname' will map port 3306 on the remote machine to port 3307 on your local machine. Then, use 'mysql -P 3307 -u x -p etc.' to connect to port 3307 on your local machine, and you will hit your remote mysql Using the -h hostname or IP should do it. mysql -h 10.129.0.2 -u user -p password yadayadayada -Original Message- From: MySQL baby [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 03, 2002 10:28 AM To: [EMAIL PROTECTED] Subject: SSH tunnel MySQL traffic: BOTH remote local? If I've got one computer with MySQL client and server on it, running everything localhost, but I want to reach out to another MySQL server, through an SSH tunnel, for some things, does anyone know how to differentiate between the two? Usually, for SSH tunnelling, you access a port # at localhost, but if I also need that port # at localhost, (3306), what's a guy to do? Any advice appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php John Barton [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: SSL connection question Again!
Mysql gurus: I have anxiously been watching the list for a response to this question, but still no joy. Does anyone have information on how to make an ssl connection with the mysql client? I have support compiled into the server, but unfortunately I cant find any documentation on the client side. Thanks in advance for any help.. Happy New Year! I'm Sorry if this question has been posted often. but i cannot find answer. I have installed openssl and MySQL 4.0.1 with --with-openssl --with-vio And... mysql SHOW VARIABLES LIKE '%ssl%' ; +---+---+ | Variable_name | Value | +---+---+ | have_openssl | YES | +---+---+ 1 row in set (0.10 sec) and I granted somebody with REQUIRE SSL. But He cannot connect to MySQL using mysql . mysql client does not support SSL connection? How can he/she connect to MySQL with SSL? about PHP and MySQL? I'm very pleased if give me any Information ! Thank you for advanced Answer! Homepage = http://www.nnr.or.kr/inos/ ICQ # = 123534385 Member of DSN(database.sarang.net), NNR(nnr.or.kr) --MIME Multi-part separator-- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php John Barton [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: ALTER Syntax Question
Sure is: http://www.mysql.com/doc/A/L/ALTER_TABLE.html John Barton [EMAIL PROTECTED] http://jbarton.technicalworks.net On Fri, 9 Nov 2001, Brad Harriger wrote: Is it legal to change a field name to the same name as in the following? ALTER TABLE t1 CHANGE a a INTEGER; Thanks, Brad This e-mail and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. This communication may contain material protected by legal privileges or statutory protections. If you are not the intended recipient or the individual responsible for delivering the e-mail to the intended recipient, please be advised that you have received this e-mail in error and that any use, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately notify us and delete the original message. Upon request, we will reimburse you for reasonable costs incurred in notifying us. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Connection problem
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 check mysql.user, you probably have permission for franck@localhost, which succeeds when you omit the -h, but no permission for [EMAIL PROTECTED], so you fail when you specify that is where you are coming from. John Barton [EMAIL PROTECTED] http://jbarton.technicalworks.net On Tue, 30 Oct 2001, COLLINEAU Franck FTRD/DMI/TAM wrote: Hi! When i type: mysql -u franck -p then my password, it's ok. My machine's name is r-lx-collineau When i type mysql - h r-lx-collineau -u franck -p then my password, i have this message: ERROR 1130: host 'r-lx-collineau' is not allowed to connect to this MySQL server Can anybody help me ? Franck - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE73u4tFllLbUnOIMARAioTAJoDH4Av4CtM54YAXX/gFlycDi34VgCdHohi OHy/88V+xUTrBMeJRtLqe5k= =l46z -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 4.0 bitkeeper source fails to compile
Description: Mysql 4.0 bitkeeper fails to compile How-To-Repeat: Try to compile Fix: Fails with a syntax error Submitter-Id: submitter ID Originator:John Organization: MySQL support: none Synopsis: Mysql 4.0 bitkeeper fails to compile Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: mysql-@VERSION@@MYSQL_SERVER_SUFFIX@ (@COMPILATION_COMMENT@) Environment: System: Linux nemesis 2.4.6-pre5 #1 Mon Jun 25 10:14:44 CDT 2001 i686 unknown Architecture: i686 Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.3/specs gcc version 2.95.3 20010315 (SuSE) Compilation info: CC='@CC@' CFLAGS='@CFLAGS@' CXX='@CXX@' CXXFLAGS='@CXXFLAGS@' LDFLAGS='@LDFLAGS@' LIBC: -rwxr-xr-x1 root root 1343073 May 11 09:50 /lib/libc.so.6 -rw-r--r--1 root root 24539184 May 11 09:43 /usr/lib/libc.a -rw-r--r--1 root root 178 May 11 09:43 /usr/lib/libc.so Configure command: @CONF_COMMAND@ When trying to compile todays bitkeeper archive of Mysql 4.0, it fails with a syntax error. Making all in sql gmake[2]: Entering directory `/usr/local/src/mysql-4.0/sql' gmake[2]: warning: -jN forced in submake: disabling jobserver mode. yacc -d sql_yacc.yy mv y.tab.c sql_yacc.cc yacc: e - line 72 of sql_yacc.yy, syntax error %pure_parser/* We have threads */ ^ gmake[2]: *** [sql_yacc.cc] Error 1 gmake[2]: Leaving directory `/usr/local/src/mysql-4.0/sql' gmake[1]: *** [all-recursive] Error 1 gmake[1]: Leaving directory `/usr/local/src/mysql-4.0' gmake: *** [all-recursive-am] Error 2 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: simultaneous connections
Mysql allows 101 connections by default, 100 client connections plut it reserves one for administrator access. You can set your own maximum connection limit in the my.cnf file by using the directive: [mysqld] set-variable = max_connections= where xxx is the amount you want to set as the max. See the documentation for information and recommendations on what to set the max as for your particular OS. John Barton System Administrator Mpower Communications [EMAIL PROTECTED] - Original Message - From: Don Pro [EMAIL PROTECTED] To: msql list [EMAIL PROTECTED] Sent: Friday, May 11, 2001 2:37 PM Subject: simultaneous connections Hi, I'm reading in my documentation (I have a book) that MySQL allows up to 101 simultaneous connections. Gadzooks! How can MySQL claim to be at the Enterprise level with this limit? Is there any way around this? Thanks, Don - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: set variable for max_connections
Try putting a line like the following in your my.cnf file: This has always worked for me, including 3.23.37 set-variable = max_connections= John Barton Unix Systems Administrator Primary Networks, Inc. [EMAIL PROTECTED] On Thu, 10 May 2001, Mark Lo (3) wrote: Hi, I would like to set a higher values in max_connections for mysql. I have tried to use the following command mysqld --set-variables max_connections=900 -u root -ppassword. Then, it shows that I have successfully changed the variable of max_connections. But, when I check it with the command of mysqladmin variables -u root -ppassword. The max_connections return to 100 which is the default value. I wonder what is wrong with mysql3.23.37. Is this a bug, or I am using the wrong command. In additions, Can I set the max_connections values higher than 5000. Thank you Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Correct syntax?
"select word, count(word) as total from search_words where word IS NOT NULL group by word order by total desc limit 20" John Barton Unix Systems Administrator Primary Networks, Inc. [EMAIL PROTECTED] On Thu, 19 Apr 2001, Graham Nichols wrote: Thanks for help from this group I'm using "select word, count(word) as total from search_words group by word order by total desc limit 20" to locate the top 20 words in a database of website search engine words. The database had been altered to include an extra column, other than the 'word' column. This means that 'word' can now have a null entry sometimes. How can I modify the sql query above to exclude any row(s) in 'word' with 'NULL' please? regards, Graham l - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: BEGIN, COMMIT, ROLLBACK
You are using MyISAM tables which do not support transactions. You need to convert your table to either BDB or INNOBASE type in order to use transactions. All the info is in the manual.. John Barton Unix Systems Administrator Primary Networks, Inc. [EMAIL PROTECTED] On Tue, 10 Apr 2001, Bruno Roselli wrote: Hi. How to use Begin, Commit and Rollback in my tables type MyISAM ? mysql BEGIN; Query OK, 0 rows affected (0.00 sec) mysql UPDATE tabgral set codigo=2 where codigo=1 and nrotab=99; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql ROLLBACK; ERROR 1196: Warning: Some non-transactional changed tables couldn't be rolled back show table status like 'tabgral'; +-+++--++-+- +--+---++-+- +++-+ | Name| Type | Row_format | Rows | Avg_row_length | Data_length | Max_data _length | Index_length | Data_free | Auto_increment | Create_time | Upda te_time | Check_time | Create_options | Comment | +-+++--++-+- +--+---++-+- +++-+ | tabgral | MyISAM | Dynamic| 280 | 45 | 12872 | 429 4967295 | 7168 | 0 | NULL | 2001-04-10 09:17:45 | 2001 -04-10 12:58:11 | NULL || | +-+++--++-+- +--+---++-+- +++-+ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: show databases forbidden or limited to the owner database
Try putting a line in your my.cnf that contains: safe-show-database This will only allow the user to see databases that they have permissions for You can optionally use skip-show-database, which will not allow the command at all. John Barton Unix Systems Administrator Primary Networks, Inc. [EMAIL PROTECTED] On Mon, 9 Apr 2001, Fabien Salvi wrote: Hello, is it possible to prevent users from seing other databases than the one there are using ? I thought it was possible using priveleges and "Select_priv", but It doesn't work... I am using 3.23.33 Thanks in advance for your help... - Fabien SALVI Centre de Ressources Informatiques Archamps, France -- http://www.cri74.org PingOO GNU/linux distribution : http://www.pingoo.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Moving Data
It depends on what version of MySQL you are running. MyISAM tables will move across platforms fine, but ISAM tables will not. You could always choose the failsafe and use mysqldump to dump the contents of your database into a file, and then use that to reload the contents on the new machine. John Barton Unix Systems Administrator Primary Networks, Inc. [EMAIL PROTECTED] On Mon, 9 Apr 2001, Mat Murdock wrote: We will be moving our MySql databases from a Winnt server to a linux server. Can I just copy the data files from one machine to the other? If not then how should I do it? Mat Murdock Your mouse has moved. Windows must be restarted for the change to take effect. Reboot now? [ OK ] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: backup mysql using crontab
mysqldump --flush-logs -u root -pmarkloky --add-drop-table shuncheong /backup/shuncheong.sql You have to put username and password as an argument to mysqldump, before your redirection John Barton Unix Systems Administrator Primary Networks, Inc. [EMAIL PROTECTED] On Tue, 3 Apr 2001, Mark Lo (3) wrote: Hi, I would like to know how to backup mysql using crontab or cron jog. I have add a line in my crontab file : mysqldump --flush-logs --add-drop-table shuncheong /backup/shuncheong.sql -u root -pmarkloky; but I got nothing in shuncheong.sql file. Thank you for your help Mark Lo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Password option
Restart mysqld with the --skip-grant-tables option, this will allow you to bypass mysql's authentication. You can log in as root and then change the password to something else. John Barton Unix Systems Administrator Primary Networks, Inc. [EMAIL PROTECTED] On Wed, 21 Mar 2001, Jared Rogge wrote: I have recently tried to install a new Trouble Ticket application on a Unix machine that was previously administered by somebody else. They have set a password to MySQL and I cannot into it of course. Does anybody know how to reset or disable this feature if you have root access to the machine? Thanks, - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 backup and restore.
You dont need a script or command to restore the database, mysqlhotcopy just creates a copy of your database files (.MYI, etc.) in the /pathToTheBackupDirectory/. It basicaly performs the same function as the unix command cp, only it does the necessary locking, etc. John Barton Unix Systems Administrator Primary Networks, Inc. [EMAIL PROTECTED] On Tue, 20 Mar 2001, Zhu George-CZZ010 wrote: Hi, If I use "mysqlhotcopy database/pathToTheBackupDirectory/" to backup the whole database, what's the script/command to restore it? Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: What is best way to check mysql status?
You should look up mysqladmin in the manual. It depends on what you want to know. mysqladmin ping will tell you if the server is alive or not, or you can use mysqladmin status to get a brief stat report about the server. John Barton Unix Systems Administrator Primary Networks, Inc. [EMAIL PROTECTED] On 21 Mar 2001, Jose de Leon wrote: I have found at least three ways to check up/down status of MySQL. I am wondering what is considered the most reliable method, please comment and add if you have another method. 1. Check for existence of PID file created by MySQL 2. Check for existence of mysql.sock 3. Verify connection via telnet to port 3306. Thank you, Jose de Leon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Weird select with php
SELECT * FROM members where name like 'A%' ORDER BY RAND(); John Barton Unix Systems Administrator Primary Networks, Inc. [EMAIL PROTECTED] On Tue, 6 Mar 2001, Matt "TrollBoy" Wiseman wrote: I'm attempting to do a select from my table, but the only odd thing is the customer wants the results to be completely random every time... is there anything like this?? $query = "SELECT * FROM members where Name like 'A%' ORDER BY random"; Matt "Trollboy" Wiseman www.shoggoth.net/trollboy/trollboy.jpg [EMAIL PROTECTED] "I wish the world had one throat!!" -Al Bundy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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