Re: database permission
Hi Ketvin, after you created your database kelvin_db for example, you can set a account to use this database in this manner : GRANT ALL PRIVILEGES ON user_name.* TO @localhost identified by 'password_for_user'; GRANT ALL PRIVILEGES ON user_name.* TO @% identified by 'password_for_user'; Are useful basic information in the MySQL documentation. Read this once at least. Regards Thierno6C - MySQL 4.0.15 - Original Message - From: ketvin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, November 10, 2003 8:37 AM Subject: database permission Dear lists, How do I assign user and password to a database that i just created ? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Setting up user acounts in 4.0.16
Hi Nils, your instruction of account creation don't agree with the syntax . To create an account do this : GRANT ALL PRIVILEGES ON xoops.* TO xoops@% identified by ''; The percent character '%' is enclosed by double-quote. Regards Thierno6C - MySQL 4.0.15. - Original Message - From: Nils Valentin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 07, 2003 8:00 AM Subject: Setting up user acounts in 4.0.16 Hi Mysql fans ;-), today I had a funny experience and I wanted to double check that. When I am trying to create a user account in the 4.0.16 -max version (tar.gz format from www.mysql.com) then it would create the user account put not set the privileges. The privileges would still stay at N. Here is the command I tried: grant all on xoops.* to 'xoops_root'@'%' identified by ''; Perhaps I have done a mistake somewhere, but I cant figure out what went wrong. I had to manually update the fields with the update .. set command and a flush privileges. Can anybody copy me on that ? Best regards Nils Valentin Tokyo/Japan http://www.be-known-online.com/mysql/ -- 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: best practices for running 3.23 and 4.016 on the same box?
Hi Mark, there is no problem to run both MySQL servers 3.23 / 4.0.16. Just pay attention to (particulary options file) : - configure two my.cnf files, each version must have it server specific options file. remarks that you cannot put the same file in the same place /etc/. Place each of them in his own install directory /usr/local/mysql-version_number/data/my.cnf for example. - use two different PORT, SOCKET, DATADIR, LOGs FILE names - you are already setup a new directory for version 4.0.16, it's ok . - prepare two start/stop script (with different names in /etc/init.d/rc.d/) and customize them according to each my.cnf variable present in these scripts. This is sufficient for running the 2 servers version independently . I have the same configuration (on RedHat 8, neverthless). Regards, Thierno6C - MySQL 4.0.15 - Original Message - From: Mark Teehan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 06, 2003 8:35 AM Subject: best practices for running 3.23 and 4.016 on the same box? Hi all I am planning an upgrade for a very busy 3.23 server to 4.016. As we dont have a text box, I have to install both releases on the same machine, and test 4.016 for some time. For 4.016 I will unpack a tar.gz, as I dont trust rpm not to clobber at least some of the 3.23 installation. I will then set up a new 4016/data directory, and copy each database in for testing. My question is : can someone give me some guidelines on the best practices for setting this up? How to make the two installations completely independant of each other? Also anything I should know about 4.016 thats not mentioned in the release notes? I am running on redhat 7.2. TIA! Mark, Singapore. ERG Group -- The contents of this email and any attachments are confidential and may only be read by the intended recipient. - -- 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:Setting up user acounts in 4.0.16
Hi Nils, what want you to say by : It doesnt write the privileges (on my machine). It is because you succeed reaching all the database objects or what ? Give some more details. Regards. Thierno6C. - Original Message - From: Nils Valentin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 07, 2003 1:16 PM Subject: Fwd: Re: Setting up user acounts in 4.0.16 Hi Thierno, you are right that the synatx I gave you is not correct. Thank you for pointing this out. I made the mistake when typing the e-mail ;-) However the original problem stays. It doesnt write the privileges (on my machine). Best regards Nils Valentin Tokyo/Japan On Thursday 06 November 2003 17:42, you wrote: Hi Nils, your instruction of account creation don't agree with the syntax . To create an account do this : GRANT ALL PRIVILEGES ON xoops.* TO xoops@% identified by ''; The percent character '%' is enclosed by double-quote. Regards Thierno6C - MySQL 4.0.15. - Original Message - From: Nils Valentin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 07, 2003 8:00 AM Subject: Setting up user acounts in 4.0.16 Hi Mysql fans ;-), today I had a funny experience and I wanted to double check that. When I am trying to create a user account in the 4.0.16 -max version (tar.gz format from www.mysql.com) then it would create the user account put not set the privileges. The privileges would still stay at N. Here is the command I tried: grant all on xoops.* to 'xoops_root'@'%' identified by ''; Perhaps I have done a mistake somewhere, but I cant figure out what went wrong. I had to manually update the fields with the update .. set command and a flush privileges. Can anybody copy me on that ? Best regards Nils Valentin Tokyo/Japan http://www.be-known-online.com/mysql/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Nils Valentin Tokyo/Japan http://www.be-known-online.com/mysql/ --- -- Nils Valentin Tokyo/Japan http://www.be-known-online.com/mysql/ -- 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: Setting up user acounts in 4.0.16
Hi Nils, as said Clark, looks at db table. In fact the account xoops will have full access to database 'xoops' only. Regards - Original Message - From: gerald_clark [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, November 06, 2003 2:23 PM Subject: Re: Setting up user acounts in 4.0.16 You set db privileges, and then looked at the user table. Check the db table. If you want to set global privileges you need to specify *.* not xoops.*. Nils Valentin wrote: Hi Thierno, Please see below what I get. I would expect the privileges to be set to Y. GRANT ALL PRIVILEGES ON xoops.* TO xoops@% identified by ''; Query OK, 0 rows affected (0.00 sec) mysql select * from user where User=xoops\G *** 1. row *** Host: % User: xoops Password: 5a62d73531da5605 Select_priv: N Insert_priv: N Update_priv: N Delete_priv: N Create_priv: N Drop_priv: N Reload_priv: N Shutdown_priv: N Process_priv: N File_priv: N Grant_priv: N References_priv: N Index_priv: N Alter_priv: N Show_db_priv: N Super_priv: N Create_tmp_table_priv: N Lock_tables_priv: N Execute_priv: N Repl_slave_priv: N Repl_client_priv: N ssl_type: ssl_cipher: x509_issuer: x509_subject: max_questions: 0 max_updates: 0 max_connections: 0 1 row in set (0.00 sec) -- 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: Reliability of _rowid over multiple database accesses
Hi Smith, the fact that _rowid may change over time depending on many factors doesn't concern MySQL, but it is valable for mSQL. Regards. Thierno 6C - MySQL 4.0.15 - Original Message - From: Roger Baklund [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Guy Smith [EMAIL PROTECTED] Sent: Monday, October 20, 2003 11:48 PM Subject: Re: Reliability of _rowid over multiple database accesses * Guy Smith I'd like to use the _rowid capability of MySQL to improve the efficiency of a project, but I have concerns about the reliability of the number it returns. I understand that _rowid may change over time depending on many factors, but I'd like to know whether this is true if the row is locked. In particular, can I perform a select on a row which returns a _rowid, modify the row data, and later do an UPDATE using the _rowid as index, without worrying that the _rowid has changed? Any help will be much appreciated. The _rowid in MySQL is an alias for any field of a table with an unique integer index, for instance a primary key. It is usefull when you don't remember the name of the key, but it will not improve efficiency in any other way, AFAIK. The value of a key will not change over time, unless you explicitly change it. There should be nothing to worry about. :) -- Roger -- 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: What is wrong with this bloody MySQL?
Hi, can you indicates your configuration about : - my.cnf - all tables type your using in the master (MyISAM, INNODB, BDB) This may help to see what goes wrong . Regards Thierno 6C - MySQL 4.0.15 - Original Message - From: Søren Neigaard [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 1:32 PM Subject: What is wrong with this bloody MySQL? I have posted the message with the subject Serious problem with replication, but nobody seems to know what to do? Now I have even tried to completly uninstall MySQL (with rpm -e), delete the /var/lib/mysql dir, and reinstall MySQL with rpm -i MySQL-server-4.0.15-0.i386.rpm. Then I create my database, create the tables, set up replication (as slave), and do a LOAD DATA FROM MASTER;, and still I get this bloody error: Version: '4.0.15-standard-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 031009 15:33:48 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'mysql-bin.006' at position 1408472 031009 15:34:33 Slave I/O thread exiting, read up to log 'mysql-bin.006', position 1408472 031009 15:34:33 Couldn't fix table with quick recovery: Found wrong number of deleted records 031009 15:34:33 Run recovery again without -q 031009 15:34:33 Note: Retrying repair of: './otamanager/otafrontenduser' with keycache 031009 15:34:33 Couldn't fix table with quick recovery: Found wrong number of deleted records 031009 15:34:33 Run recovery again without -q 031009 15:34:33 Note: Retrying repair of: './otamanager/profile' with keycache 031009 15:34:36 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'mysql-bin.006' at position 1408472 Is there really nothing to do here, what the hell is the problem with MySQL? Med venlig hilsen/Best regards Søren Neigaard System Architect Mobilethink A/S Arosgaarden Åboulevarden 23, 4.sal DK - 8000 Århus C Telefon: +45 86207800 Direct: +45 86207810 Fax: +45 86207801 Email: [EMAIL PROTECTED] Web: www.mobilethink.dk -- 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: What is wrong with this bloody MySQL?
Hi, i suppose you do the necessary GRANTS on the master (before executing LOAD DATA FROM MASTER) as : - file - super - reload - select (on all tables you want to load) If not do this, and try again You can check if you are using only MyISAM tables with the client console by : show table status from database_name ; and look s in the column labelled TYPE. Regards Thierno 6C - MySQL 4.0.15 - Original Message - From: Søren Neigaard [EMAIL PROTECTED] To: 'Thierno Cissé' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 2:39 PM Subject: RE: What is wrong with this bloody MySQL? Here is my my.cnf (had to zip it, my Windoze would not let me attache it??). As far as I know, im only using MyISAM (thats the standard version right), but how do I check this? Best regards Søren -Original Message- From: Thierno Cissé [mailto:[EMAIL PROTECTED] Sent: 9. oktober 2003 16:28 To: Søren Neigaard; [EMAIL PROTECTED] Subject: Re: What is wrong with this bloody MySQL? Hi, can you indicates your configuration about : - my.cnf - all tables type your using in the master (MyISAM, INNODB, BDB) This may help to see what goes wrong . Regards Thierno 6C - MySQL 4.0.15 - Original Message - From: Søren Neigaard [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 1:32 PM Subject: What is wrong with this bloody MySQL? I have posted the message with the subject Serious problem with replication, but nobody seems to know what to do? Now I have even tried to completly uninstall MySQL (with rpm -e), delete the /var/lib/mysql dir, and reinstall MySQL with rpm -i MySQL-server-4.0.15-0.i386.rpm. Then I create my database, create the tables, set up replication (as slave), and do a LOAD DATA FROM MASTER;, and still I get this bloody error: Version: '4.0.15-standard-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 031009 15:33:48 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'mysql-bin.006' at position 1408472 031009 15:34:33 Slave I/O thread exiting, read up to log 'mysql-bin.006', position 1408472 031009 15:34:33 Couldn't fix table with quick recovery: Found wrong number of deleted records 031009 15:34:33 Run recovery again without -q 031009 15:34:33 Note: Retrying repair of: './otamanager/otafrontenduser' with keycache 031009 15:34:33 Couldn't fix table with quick recovery: Found wrong number of deleted records 031009 15:34:33 Run recovery again without -q 031009 15:34:33 Note: Retrying repair of: './otamanager/profile' with keycache 031009 15:34:36 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'mysql-bin.006' at position 1408472 Is there really nothing to do here, what the hell is the problem with MySQL? Med venlig hilsen/Best regards Søren Neigaard System Architect Mobilethink A/S Arosgaarden Åboulevarden 23, 4.sal DK - 8000 Århus C Telefon: +45 86207800 Direct: +45 86207810 Fax: +45 86207801 Email: [EMAIL PROTECTED] Web: www.mobilethink.dk -- 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] -- 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: Table crashes
Hi, Jonas crashes occurs for some reasons like : - unclean tables ( tables are closed improprely), - hardware problems - something goes wrong in the system - know bugs Check that your tables are clean, before start using them. It seems that you said the REPAIR doesn't occurs after you configuring related variables in the my.cnf file ? Because the daemon will not start when the my.cnf contains any errors (variable names), the format is to be correct. Can you indicates what MySQL version you run and your OS version. Regards Thierno6C - MySQL 4.0.15 - Original Message - From: Datatal AB - Gauffin, Jonas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 7:05 AM Subject: Table crashes Hello Some one my tables have crashed (again). I had to repair them ASAP since the db is in my production enviroment. 1. How can I find the cause of the crashes? 2. I've created a my.cnf and added the following lines. Is the format correct? [mysqld] set-variable = myisam-recover=BACKUP,FORCE set-variable = myisam_sort_buffer_size=4M I need to get this going without getting crashes every week, please help. /Jonas -- 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: Table crashes
Hello, MyODBC 3.51 is the only way that I access the database. (MyODBC is used in a multithreaded server and in InternetInformationServer (asp)) The server is coded in c++ and got a class that acts like a odbc pool (keeps connections open during the lifetime of the server and handles them to threads that requests a db connection) It may help to know more about the work of features (multithreaded server, 'odbc pool') you are using with MySQL. I have only one vague idea it above. I know that MySQL is multi-threaded (it may have many queries on the same table simultaneously). Remarks that keeps connections open during the lifetime of the server and handles them to threads that requests a db connection SHOULDN'T be the culprit of table crash. In contrary this is a good thing; PHP, that i used, do the same job with the feature of PERSISTENT CONNECTIONS. Also the version of MyODBC (MyODBC 3.51 ) you are using is declared STABLE by MySQL , though MySQL says : 'some issues brought up appear to be application-related and independent of the ODBC driver or underlying database server. How are tables getting unclean? Has many ways like : - the mysql daemon server stops in a abnormal way , you can see it in the mysql error log file - a query fail to continue processing - a system problem When are tables closed? A table is opened for each concurrent acces, A table is closed when the connection using them is closed / lost Regards Thierno6C - MySQL 4.0.15 - Original Message - From: Datatal AB - Gauffin, Jonas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 10:05 AM Subject: SV: Table crashes Hello crashes occurs for some reasons like : - unclean tables ( tables are closed improprely), - hardware problems - something goes wrong in the system - know bugs Check that your tables are clean, before start using them. MyODBC 3.51 is the only way that I access the database. (MyODBC is used in a multithreaded server and in InternetInformationServer (asp)) The server is coded in c++ and got a class that acts like a odbc pool (keeps connections open during the lifetime of the server and handles them to threads that requests a db connection) How are tables getting unclean? When are tables closed? Should I disconnect/connect when a thread is handling the dbconnection back to the pool? It seems that you said the REPAIR doesn't occurs after you configuring related variables in the my.cnf file ? Because the daemon will not start when the my.cnf contains any errors (variable names), the format is to be correct. No. I asked if my configuration were correct. I've just added it to my.cnf. Can you indicates what MySQL version you run and your OS version. Win2000 Mysql 4.0.12 (mysqld.exe) MyODBC was an old version (2.x), I've just installed 3.51.06 -- 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: MYSQL table crashed and doesn't repair
Hi Stanley, You also have the options to indicates mysqld to checks and repairs tables automatically as it detects corruption or crash. Put in the section mysqld of your my.cnf file these 2 variables : first: set-variable = myisam-recover=BACKUP,FORCE (it will try to do 'safe' repair, otherwise make a backup of problematic table and a force repair) second: set-variable = myisam_sort_buffer_size=4M (if you have enough memory, use greater value; this accelerates the process of repair). The automatic check and/or repair will leave a message in the .err file to indicates that a corruption or crash has occurs. PS: Try it with version 4.0.x Hope; this resolves Thierno6C :MySQL 4.0.15 - Original Message - From: Alexis da Cruz Henriques Guia [EMAIL PROTECTED] To: Stanley Joseph [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, October 06, 2003 5:31 PM Subject: Re: MYSQL table crashed and doesn't repair Execute in shell myisamchk --help This will list a serie of options to repair your tables. Obviously, this only works to MyISAM tables. ;) Alexis Quoting Stanley Joseph [EMAIL PROTECTED]: Dear All , A few tables of my database crashed and are not getting repaired .What is the best way to recover the data . Any suggestion will be of great help . Regards Stanley Joseph +44 (0) 208 665 4291 (W) +44 (0) 777 621 0132 (M) http://www.themobilerepublic.com The Price, The Choice, The Service This email and any attachments are confidential. They may contain privileged information and are intended for the named addressee(s) only. They must not be distributed without our consent. If you are not the intended recipient, please notify us immediately and do not disclose, distribute, or retain this email or any part of it. Unless expressly stated, opinions in this email are those of the individual sender, and not of The Mobile Republic. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking. The Mobile Republic and its subsidiaries reserve the right to monitor all email communications through their networks. -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ran out of space for bin logs
Hi, 1. Can I safely delete the binlogs and clear the binlog index by hand? The binlog index maintains admistrative informations that the daemon use to manage the binlog files. If you delete it ( i don't recommended this) the daemon will recreate it . 2. How can I regulate the size of the binlogs to something manageable? you can set the variable max_binlog_size in the section mysqld of my.cnf file to a value of choice , example 5M . After the 5 Mo is reached, it switch to new binlog file. You can also move old binlogs files to another location to avoid eating all available space. Hope it helps Thierno 6C - Original Message - From: Christopher L. Everett [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 03, 2003 12:49 AM Subject: ran out of space for bin logs Aparrently my binlogs grew and grew and ate up all the space on their partition. At this point, I see this on the master mysql show master status; Empty set (0.00 sec) and this on the slave: mysql show slave status\G *** 1. row *** Master_Host: master-db Master_User: repl Master_Port: 3306 Connect_retry: 60 Master_Log_File: carbon-bin.09 Read_Master_Log_Pos: 201392116 Relay_Log_File: silicon-relay-bin.07 Relay_Log_Pos: 4 Relay_Master_Log_File: carbon-bin.09 Slave_IO_Running: No Slave_SQL_Running: Yes Replicate_do_db: Replicate_ignore_db: Last_errno: 0 Last_error: Skip_counter: 0 Exec_master_log_pos: 201392116 Relay_log_space: 4 which I think means my replications long past the point of retrieval. I'm pretty well reconciled to taking my system out of production, copying all the databases from the master to the slave, dropping the binlogs and restarting the replication. I have 2 questions: 1. Can I safely delete the binlogs and clear the binlog index by hand? 2. How can I regulate the size of the binlogs to something manageable? TIA for your help. -- 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: Running two MySQL Servers (4.0.x 4.1.x) in Same Machine
Hi, Can I run two MySQL Servers in same machine ?? yes you can, just place it into 2 distinct directories, like : SERVER 1 : /usr/local/mysql-4.0.x SERVER 2 : /usr/local/mysql-4.1.x Could I install MySQL 4.1.x in same machime with RPM install ?? i don't try it, but with binary distribution yes you can. Any conflicts ? Any , if you use 2 different port number. You configure it with my.cnf file by the variable named port (port = 3306) Note that if you have 2 MySQL servers on the same machine, pay attention to name some files like socket file, log file, err file with different names. Also the my.cnf file will not located in /etc because it becomes server specific options/configuration file. Hope this help Regards Thierno 6C -Original Message- From: Oscar (TOMCAT) [mailto:[EMAIL PROTECTED] Sent: vendredi 12 septembre 2003 14:53 To: [EMAIL PROTECTED] Subject: Running two MySQL Servers (4.0.x 4.1.x) in Same Machine Hi, Can I run two MySQL Servers in same machine ?? I have Red Hat 8, and MySQL 4.0.x installed and running (RPM install). Could I install MySQL 4.1.x in same machime with RPM install ?? Any conflicts ? How to configure MySQL to listen in other port ? Thanks, === José Oscar de Souza Eduardo Coordenador de Projetos tel: 3047-4541 fax: 3047-4550 [EMAIL PROTECTED] ===
RE: SOLVED Re: MySQL 4.0.14 stops responding to PHP 4.3.2
Hi, Finally you seem to say that you 've setting max_connections with a limit. Can you tell how many 100 or 200 ? Also you say : Here's the configuration: MySQL Ver 12.21 Distrib 4.0.14, for pc-linux (i686) PHP 4.3.2 Red Hat 9.0 Have you enable QUERY CACHE feature with MySQL 4.0.14 ? Regards Thierno6C -Original Message- From: Parker Morse [mailto:[EMAIL PROTECTED] Sent: vendredi 5 septembre 2003 15:01 To: [EMAIL PROTECTED] Subject: SOLVED Re: MySQL 4.0.14 stops responding to PHP 4.3.2 On Thursday, Sep 4, 2003, at 12:47 US/Eastern, Parker Morse wrote: No, it turns out this is not the key. With mysql_connect() I'm actually failing MORE often than with mysql_pconnect - so far it hasn't stayed up 15 minutes without error. (Fortunately, I have a cron job checking on it and restarting.) However, this did put me on to the problem. I was tripping resource limits. When I was first setting up the server and getting the individual sites/users working in the mysql.user table, I saw the max_connections column set to 0 and thought that was a problem; I didn't realize that 0 meant no limit. So I set a limit. I was running up on the connection limits, which meant mysqld was refusing further connections until my server restart reset the counts to 0. With mysql_connect I had more connections, and thus reached the limit faster. Now I have reset the max_connections numbers to 0, and I haven't had a failure in twenty hours, so I think I can call this problem solved. Thanks for your help. In the course of sorting it out, I also learned a good deal about debugging mysql errors gracefully in PHP. pjm -- 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: how to change default data directory
Hi Sanjay, I see two ways to proceed : 1 - after install, move or copy (with -R option) your actual datadir under /var/lib/mysql (that is to say all the directories located under /var/lib/mysql/*) to /var1/lib/mysql, and then modify in your my.cnf the variable datadir=/var1/lib/mysql to correspond with the new directory. NOTE : stop the mysqld daemon before copying or moving directories. 2 - before install, configure in your my.cnf the futur directory to use with the variable datadir=/var1/lib/mysql; then place it under /etc/ - this cause the script scripts/mysql_install_db to find in /etc/my.cnf the datadir to use. After install, you'll see that the directories mysql and test are placed under /var1/lib/mysql/ Hope this help Thierno6C -Original Message- From: sanjay gupta [mailto:[EMAIL PROTECTED] Sent: jeudi 4 septembre 2003 09:35 To: [EMAIL PROTECTED] Subject: how to change default data directory Hi All , I am using RH7.1 box . I am preparing to install mysql 4.0.13. Previously when i installed the mysql the mysql data directory was /var/lib/mysql . I uninstall the mysql . Now i want my data directory to be /var1/lib/mysql instead of /var/lib/mysql . I want this because var1 is mounted to my raid device /dev/md0 and i want mysql data directory should be /var1 any suggestions sanjay -- 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: Help!!! Need to backup mysql using - MYSQL Second Edition?
Hi, when you run this backup command, it wait that you provide a password (it is as if it were spirit to treat the command) without prompt; so just after you press enter key to run the backup command, type here you password. Also you can place directly the password in the command like this : mysqldump -u username -pyour_password --opt --databases --complete-insert --flush-logs mysql d:\path\to\backup\filename.sql NOTE : -p and your password are stuck and that the --databases will take care of all the databases? yes , it will backup all databases. Hope this run -Original Message- From: Ola Ogunneye [mailto:[EMAIL PROTECTED] Sent: jeudi 31 juillet 2003 15:15 To: [EMAIL PROTECTED] Subject: RE: Help!!! Need to backup mysql using - MYSQL Second Edition? Hi, sorry to bother you, but from what you recommended, am I typing everything just the way you typed it out except for the username which would be my username, or are there other variables in there that I need to change to something else? In essence, if my username is ola, is all I am now doing is changing the username to ola or do I need to provide the password for user ola, I also have created 3 databases apart from the default test and mysql (5 Databases in all), I take it that I do not have to specify each by its name, and that the --databases will take care of all the databases? The user ola has a password being the root user, do I put in the password somewhere as well or is mysql going to promt me for the passsword? Is all I am typing the following? C:\mysql\bin\mysqldump -u ola -p --opt --databases --complete-insert --flush-logs mysql d:\path\to\backup\filename.sql Thanks in advance Ola Thierno Cissé [EMAIL PROTECTED] 07/31/03 11:03AM hi, Still a newbie, and running mysql on windows 2000 Advanced Server. I am trying to backup mysql and was confused as to which command to use. I see the following options use mysqldump . If you want backup whole database(s) , proceed to next : mysqldump -u username -p --opt --databases --complete-insert --flush-logs mysql d:\path\to\backup\filename.sql do I need to first create the directory where I want mysql to be backed up? you can do this, and give this directory in the path. So the backup is a local backup anyway Thierno 6C -Original Message- From: Ola Ogunneye [mailto:[EMAIL PROTECTED] Sent: jeudi 31 juillet 2003 14:21 To: [EMAIL PROTECTED] Subject: Help!!! Need to backup mysql using - MYSQL Second Edition? Hello again, Still a newbie, and running mysql on windows 2000 Advanced Server. I am trying to backup mysql and was confused as to which command to use. I see the following options mysqldump mysqlhotcopy Now the confusion is really in the syntax used in the MYSQL Second Edition. I looked on page 718 and I am thinking that the command is for a Unix system. Since I am running on Windows, do I need to first create the directory where I want mysql to be backed up? And secondly, it is recommended that I do not backup in the same volume, so what exactly is the command for me to use, if mysql resides on C:\ and I want to back it up in the D:\? I should tell you that my PC is still a standalone, and I am planning to take it online soon. So the backup is a local backup. Thank you all in advance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
RE: Help!!! Need to backup mysql using - MYSQL Second Edition?
Hi, rapid correction !! in the backup command, retrieve the word mysql placed just after --flush-logs . Thierno 6C -Original Message- From: Thierno Cissé [mailto:[EMAIL PROTECTED] Sent: jeudi 31 juillet 2003 15:40 To: 'Ola Ogunneye' Cc: [EMAIL PROTECTED] Subject: RE: Help!!! Need to backup mysql using - MYSQL Second Edition? Hi, when you run this backup command, it wait that you provide a password (it is as if it were spirit to treat the command) without prompt; so just after you press enter key to run the backup command, type here you password. Also you can place directly the password in the command like this : mysqldump -u username -pyour_password --opt --databases --complete-insert --flush-logs mysql d:\path\to\backup\filename.sql NOTE : -p and your password are stuck and that the --databases will take care of all the databases? yes , it will backup all databases. Hope this run -Original Message- From: Ola Ogunneye [mailto:[EMAIL PROTECTED] Sent: jeudi 31 juillet 2003 15:15 To: [EMAIL PROTECTED] Subject: RE: Help!!! Need to backup mysql using - MYSQL Second Edition? Hi, sorry to bother you, but from what you recommended, am I typing everything just the way you typed it out except for the username which would be my username, or are there other variables in there that I need to change to something else? In essence, if my username is ola, is all I am now doing is changing the username to ola or do I need to provide the password for user ola, I also have created 3 databases apart from the default test and mysql (5 Databases in all), I take it that I do not have to specify each by its name, and that the --databases will take care of all the databases? The user ola has a password being the root user, do I put in the password somewhere as well or is mysql going to promt me for the passsword? Is all I am typing the following? C:\mysql\bin\mysqldump -u ola -p --opt --databases --complete-insert --flush-logs mysql d:\path\to\backup\filename.sql Thanks in advance Ola Thierno Cissé [EMAIL PROTECTED] 07/31/03 11:03AM hi, Still a newbie, and running mysql on windows 2000 Advanced Server. I am trying to backup mysql and was confused as to which command to use. I see the following options use mysqldump . If you want backup whole database(s) , proceed to next : mysqldump -u username -p --opt --databases --complete-insert --flush-logs mysql d:\path\to\backup\filename.sql do I need to first create the directory where I want mysql to be backed up? you can do this, and give this directory in the path. So the backup is a local backup anyway Thierno 6C -Original Message- From: Ola Ogunneye [mailto:[EMAIL PROTECTED] Sent: jeudi 31 juillet 2003 14:21 To: [EMAIL PROTECTED] Subject: Help!!! Need to backup mysql using - MYSQL Second Edition? Hello again, Still a newbie, and running mysql on windows 2000 Advanced Server. I am trying to backup mysql and was confused as to which command to use. I see the following options mysqldump mysqlhotcopy Now the confusion is really in the syntax used in the MYSQL Second Edition. I looked on page 718 and I am thinking that the command is for a Unix system. Since I am running on Windows, do I need to first create the directory where I want mysql to be backed up? And secondly, it is recommended that I do not backup in the same volume, so what exactly is the command for me to use, if mysql resides on C:\ and I want to back it up in the D:\? I should tell you that my PC is still a standalone, and I am planning to take it online soon. So the backup is a local backup. Thank you all in advance -- 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: Help!!! Need to backup mysql using - MYSQL Second Edition?
hi, the sign remains in the command , so you will have : C:\mysql\bin\mysqldump -u ola -p --opt --databases --complete-insert --flush-logs d:\path\to\backup\filename.sql The sign will redirect output into file. Thierno 6C -Original Message- From: Ola Ogunneye [mailto:[EMAIL PROTECTED] Sent: jeudi 31 juillet 2003 15:52 To: [EMAIL PROTECTED] Subject: RE: Help!!! Need to backup mysql using - MYSQL Second Edition? Thank you once again, so the correct thing is: C:\mysql\bin\mysqldump -u ola -p --opt --databases --complete-insert --flush-logs d:\path\to\backup\filename.sql Or does the sign come out as well? Thanks Ola Thierno Cissé [EMAIL PROTECTED] 07/31/03 11:48AM Hi, rapid correction !! in the backup command, retrieve the word mysql placed just after --flush-logs . Thierno 6C -Original Message- From: Thierno Cissé [mailto:[EMAIL PROTECTED] Sent: jeudi 31 juillet 2003 15:40 To: 'Ola Ogunneye' Cc: [EMAIL PROTECTED] Subject: RE: Help!!! Need to backup mysql using - MYSQL Second Edition? Hi, when you run this backup command, it wait that you provide a password (it is as if it were spirit to treat the command) without prompt; so just after you press enter key to run the backup command, type here you password. Also you can place directly the password in the command like this : mysqldump -u username -pyour_password --opt --databases --complete-insert --flush-logs mysql d:\path\to\backup\filename.sql NOTE : -p and your password are stuck and that the --databases will take care of all the databases? yes , it will backup all databases. Hope this run -Original Message- From: Ola Ogunneye [mailto:[EMAIL PROTECTED] Sent: jeudi 31 juillet 2003 15:15 To: [EMAIL PROTECTED] Subject: RE: Help!!! Need to backup mysql using - MYSQL Second Edition? Hi, sorry to bother you, but from what you recommended, am I typing everything just the way you typed it out except for the username which would be my username, or are there other variables in there that I need to change to something else? In essence, if my username is ola, is all I am now doing is changing the username to ola or do I need to provide the password for user ola, I also have created 3 databases apart from the default test and mysql (5 Databases in all), I take it that I do not have to specify each by its name, and that the --databases will take care of all the databases? The user ola has a password being the root user, do I put in the password somewhere as well or is mysql going to promt me for the passsword? Is all I am typing the following? C:\mysql\bin\mysqldump -u ola -p --opt --databases --complete-insert --flush-logs mysql d:\path\to\backup\filename.sql Thanks in advance Ola Thierno Cissé [EMAIL PROTECTED] 07/31/03 11:03AM hi, Still a newbie, and running mysql on windows 2000 Advanced Server. I am trying to backup mysql and was confused as to which command to use. I see the following options use mysqldump . If you want backup whole database(s) , proceed to next : mysqldump -u username -p --opt --databases --complete-insert --flush-logs mysql d:\path\to\backup\filename.sql do I need to first create the directory where I want mysql to be backed up? you can do this, and give this directory in the path. So the backup is a local backup anyway Thierno 6C -Original Message- From: Ola Ogunneye [mailto:[EMAIL PROTECTED] Sent: jeudi 31 juillet 2003 14:21 To: [EMAIL PROTECTED] Subject: Help!!! Need to backup mysql using - MYSQL Second Edition? Hello again, Still a newbie, and running mysql on windows 2000 Advanced Server. I am trying to backup mysql and was confused as to which command to use. I see the following options mysqldump mysqlhotcopy Now the confusion is really in the syntax used in the MYSQL Second Edition. I looked on page 718 and I am thinking that the command is for a Unix system. Since I am running on Windows, do I need to first create the directory where I want mysql to be backed up? And secondly, it is recommended that I do not backup in the same volume, so what exactly is the command for me to use, if mysql resides on C:\ and I want to back it up in the D:\? I should tell you that my PC is still a standalone, and I am planning to take it online soon. So the backup is a local backup. Thank you all in advance -- 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: how listen queue size affect MySQL on RedHat
Hi Paul Dubois, we late to answers due to administration problems. MySQL doesn't have anything to do with HTTP connections. Next is an extract of MySQL documentation (MySQL reference manual up to Version 4.1.0-alpha). ...In other words, this value is the size of the listen queue for incoming TCP/IP connections. Your operating system has its own limit on the size of this queue. The manual page for the Unix listen(2) system call should have more details. Check your OS documentation for the maximum value for this variable. Attempting to set back_log higher than your operating system limit will be ine®ective. And , in relation to back_log=600 variable in my my.cnf file, I want to know if there is an effect to setting this variable with a value higher that system parameter listen queue size ? This response will help to determine the causes of bugs which appears in our web site as soon as apache HTTP processes which interact with MySQL server tends to higher value like 300-400 process . Think in advance -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: mercredi 30 juillet 2003 04:44 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: how listen queue size affect MySQL on RedHat At 14:53 + 7/29/03, [EMAIL PROTECTED] wrote: Hi all, i want to know if the system parameter somaxconn affect the capabalities of MySQL to maintain more than five thousands of HTTP connections ? If so , any clarifications may help. think in advance MySQL doesn't have anything to do with HTTP connections. What are you really asking? -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: how listen queue size affect MySQL on RedHat
Hi all , I miss attention when I reply, nothing else . Sorry -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: mercredi 30 juillet 2003 15:42 To: Ed Leafe; [EMAIL PROTECTED] Subject: Re: how listen queue size affect MySQL on RedHat At 11:32 -0400 7/30/03, Ed Leafe wrote: On Wednesday, July 30, 2003, at 11:21 AM, Paul DuBois wrote: Please reply to the list, not just to me directly. Thanks. Is there ever a time when it is *not* appropriate to send your response to the list instead of the individual? Sure, however, I'm not interested in having a discussion about how mail headers are set for this list. My point in saying what I said above is that I prefer to conduct list exchanges *on the list* so that others can have the benefit of what's said. Reasons for private replies: - You need to include non-public information - You want to flame me. :-) If not, why is the list not setting a Reply-To: header? Yes, I've read the dire warnings about munging Reply-To: headers, but none of them make any valid points. I've run and participated in many lists, and have never had a problem with defaulting replies to the list. ___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech.leafe.com -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: how listen queue size affect MySQL on RedHat
sorry, again maybe the stress I take remarks in a friendly (mysql) way ! -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: mercredi 30 juillet 2003 15:55 To: Thierno Cissé Subject: RE: how listen queue size affect MySQL on RedHat Hi all , I miss attention when I reply, nothing else . Sorry [Note: this *is* a private reply :-)] No apology is necessary. I hope you didn't take my message as any kind of criticism. My remark was simply as I stated below: so others can have the benefit of the discussion. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: mercredi 30 juillet 2003 15:42 To: Ed Leafe; [EMAIL PROTECTED] Subject: Re: how listen queue size affect MySQL on RedHat At 11:32 -0400 7/30/03, Ed Leafe wrote: On Wednesday, July 30, 2003, at 11:21 AM, Paul DuBois wrote: Please reply to the list, not just to me directly. Thanks. Is there ever a time when it is *not* appropriate to send your response to the list instead of the individual? Sure, however, I'm not interested in having a discussion about how mail headers are set for this list. My point in saying what I said above is that I prefer to conduct list exchanges *on the list* so that others can have the benefit of what's said. Reasons for private replies: - You need to include non-public information - You want to flame me. :-) If not, why is the list not setting a Reply-To: header? Yes, I've read the dire warnings about munging Reply-To: headers, but none of them make any valid points. I've run and participated in many lists, and have never had a problem with defaulting replies to the list. ___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech.leafe.com -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: how listen queue size affect MySQL on RedHat
Hi, It sounds like you're more interested in the number of active connections that can be maintained, in which case the max_connections variable is likely to be of more use to you. I set the variables max_connections to 700 and back_log to 600. My server can maintain it. The problem that I want identified is which server between MySQL server and HTTP server has limit to handle the maximun number of connections that it can do to interact with another one. Also the MySQL server has during the periodes of strong load less than 420 connections. The CPUs (2 CPUs) and memory (up to 2.5 Gb) utilisation are correct when it happens. I rarely have a so pretty busy MySQL server. The HTTP server has lot of CPU (1 CPU) and memory (up to 3 Gb) resources available while it reached the maximun number of clients. But in this server (HTTP), it often happens that it cannot treat any more the connections requests to the MySQL server or connections responses from the MySQL server. And in this case it is blocked for a while. to resolve this, I often restart the httpd (daemon) to resolve blocking state. That is why I suspect the system resource listen queue size to can be the bottleneck. Any advice will be appreciated think in advance -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: mercredi 30 juillet 2003 15:21 To: Thierno Cissé Cc: [EMAIL PROTECTED] Subject: RE: how listen queue size affect MySQL on RedHat At 14:55 + 7/30/03, Thierno Cissé wrote: Hi Paul Dubois, Please reply to the list, not just to me directly. Thanks. we late to answers due to administration problems. MySQL doesn't have anything to do with HTTP connections. Next is an extract of MySQL documentation (MySQL reference manual up to Version 4.1.0-alpha). ...In other words, this value is the size of the listen queue for incoming TCP/IP connections. Your operating system has its own limit on the size of this queue. The manual page for the Unix listen(2) system call should have more details. Check your OS documentation for the maximum value for this variable. Attempting to set back_log higher than your operating system limit will be ine®ective. And , in relation to back_log=600 variable in my my.cnf file, I want to know if there is an effect to setting this variable with a value higher that system parameter listen queue size ? This response will help to determine the causes of bugs which appears in our web site as soon as apache HTTP processes which interact with MySQL server tends to higher value like 300-400 process . Think in advance back_log refers to the size of the queue for connections that have not yet been accepted (though the precise semantics for this may depend on your operating system. For example, the meaning of queued on Linux appears to have changed with Linux 2.2, according to my listen(2) manpagge.) It sounds like you're more interested in the number of active connections that can be maintained, in which case the max_connections variable is likely to be of more use to you. With respect to setting back_log higher than the value allowed by your operating system, it's just as the MySQL manual says: Setting it higher than the OS limit won't get you anything. (How could it? The OS won't let you exceed its own limit.) Also, it's not clear from your message whether the bugs to which you allude above are problems with your web server (and its connections), or connections between your web server and your MySQL server... depends on what symptoms you're observing. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: mercredi 30 juillet 2003 04:44 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: how listen queue size affect MySQL on RedHat At 14:53 + 7/29/03, [EMAIL PROTECTED] wrote: Hi all, i want to know if the system parameter somaxconn affect the capabalities of MySQL to maintain more than five thousands of HTTP connections ? If so , any clarifications may help. think in advance MySQL doesn't have anything to do with HTTP connections. What are you really asking? -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]