request for unsubscribe ingored
I've sent three request-for-unsubscribe messages from my subscribing email address to following address since yesterday: [EMAIL PROTECTED] Still no responce message generated from the list. So I am writing to the list to ask the moderator to help me sign off from the list. Thanks! Alex Shi *php, perl, mysql, mysql server, mysql client, mysql-dump * == Cell Phone Batteries at 30-50%+ off retail prices! http://www.pocellular.com == TrafficBuilder Network: http://www.bestadv.net/index.cfm?ref=7029 == - 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: datadir and socket
You are absolutely right! In the /usr/bin/safe_mysqld, there're two lines where /var/lib/mysql... is residing. To me this looks kind of rediculous (sorry for my stupid comment), why they have those configuration info hard-coded in the script? Since we already have my.cnf so the conf info was supposed to be taken from it, but not hard-coded... Sorry again for those great guys who created this brilliant SQL server... Alex But still I have question regarding my.cnf: I searched the whole file system and found only one my.cnf in /etc/, and no .my.cnf. All I can find about the datadir and socket configurations are just staying in /etc/my.cnf and /etc/init.d/mysql. Does the 4.1.2 manual also not speak of: defaults-extra-file The file specified with --defaults-extra-file=#? My bet, though, as elsewhere suggested, is on a script, like mysqld_safe, running mysqld with, --socket=/var/lib/mysql/mysql Grep is your friend. :) - 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
Re: datadir and socket
Hi Stefan, Thanks a lot! With your help my issue resolved. Now both the command line connection and PHP connection can work fine. But still I have question regarding my.cnf: I searched the whole file system and found only one my.cnf in /etc/, and no .my.cnf. All I can find about the datadir and socket configurations are just staying in /etc/my.cnf and /etc/init.d/mysql. So, I really don't understand that, although I have make all the necessary changes, why for some certain situation mysql still takes the old configuration info and where it takes them from. Again, thanks for your help and patient. I know my issue already resolved. I asked the question because I want to learn something more in detail. Best Regards, Alex Alex, If I put a copy of my.cnf to datadir would that be any help? Any what is home_directory? Sorry I am kind of newbie for in-depth knowledge of MySQL. Nope. You don't have three copies of my.cnf (one of them actually called .my.cnf, note the dot) to make things more complicated, but to give you more flexibility. Ask the gurus on this list (Paul?! ;-) for a good example why one should have /etc/my.cnf (global options) AND datadir/my.cnf (server options). But for .my.cnf, you can use this to store username/password for the MySQL client, or even to store a different socket through which to connect to the server. And why the /etc/init.d/mysqld (this is a shell script) still has some hard-coded configuration information even we already have 3 copies of my.cnf? I had assume it should be able to retrieve conf info from conf files, and this was what the role of a conf file supposed to be I leave this one to the Linux folks. [client] OK, I added this entry into my.cnf, and it does help for connection issued from command line, but it doesn't work for PHP connection function (issued drom web). Right. This only works for clients that read the option file(s) when starting. PHP won't, but with PHP that's no problem, as the manual explains for mysql_connect(): The server parameter can also include a port number. eg. hostname:port or a path to a socket eg. :/path/to/ socket for the localhost. Note: Support for :port was added in PHP 3.0B4. Support for :/path/to/socket was added in PHP 3.0.10. Details: http://www.php.net/manual/en/function.mysql-connect.php Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Alex Shi [EMAIL PROTECTED] To: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED]; mysql group [EMAIL PROTECTED] Sent: Monday, February 03, 2003 3:27 AM Subject: Re: datadir and socket There are three my.cnf you should look for: 1) /etc/my.cnf = global options 2) datadir/my.cnf = server options, overriding global options 3) home_directory/.my.cnf = user specific options, overriding server options Thanks for your reply! The information does make sense. However, I searched the whole file system but found only /etc/my.cnf. If I put a copy of my.cnf to datadir would that be any help? Any what is home_directory? Sorry I am kind of newbie for in-depth knowledge of MySQL. I am curiouse that why mysql comes with 3 copies of same (?) configuration file. And why the /etc/init.d/mysqld (this is a shell script) still has some hard-coded configuration information even we already have 3 copies of my.cnf? I had assume it should be able to retrieve conf info from conf files, and this was what the role of a conf file supposed to be To make things a bit more complicated, you cannot only start the server with the socket option, but also the client (mysql). In the my.cnf's mentioned above, also check for [client] OK, I added this entry into my.cnf, and it does help for connection issued from command line, but it doesn't work for PHP connection function (issued drom web). Alex Shi and [mysql] and see if socket=/var/lib/mysql/mysql.sock is specified anywhere. HTH, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Alex Shi [EMAIL PROTECTED] To: mysql group [EMAIL PROTECTED] Sent: Sunday, February 02, 2003 12:03 AM Subject: datadir and socket Hi, I have a MySQL 2.23.36 running on a Linux RH 7.1. Its database directory is /var/lib/mysql/. For some reason I want to change it to /home/mysql/. So I did following things: 1. modify /etc/my.cnf: changed all /var/lib/mysql/ to /home/mysql/ 2. modyfy /etc/init.d/mysqld: changed /var/lib/mysql/ to /home/mysql/ 3. copied all database files from /var/lib/mysql/ to /home/mysql/ 4. restart mysqld OK. everything looks fine for connections from
Re: datadir and socket
There are three my.cnf you should look for: 1) /etc/my.cnf = global options 2) datadir/my.cnf = server options, overriding global options 3) home_directory/.my.cnf = user specific options, overriding server options Thanks for your reply! The information does make sense. However, I searched the whole file system but found only /etc/my.cnf. If I put a copy of my.cnf to datadir would that be any help? Any what is home_directory? Sorry I am kind of newbie for in-depth knowledge of MySQL. I am curiouse that why mysql comes with 3 copies of same (?) configuration file. And why the /etc/init.d/mysqld (this is a shell script) still has some hard-coded configuration information even we already have 3 copies of my.cnf? I had assume it should be able to retrieve conf info from conf files, and this was what the role of a conf file supposed to be To make things a bit more complicated, you cannot only start the server with the socket option, but also the client (mysql). In the my.cnf's mentioned above, also check for [client] OK, I added this entry into my.cnf, and it does help for connection issued from command line, but it doesn't work for PHP connection function (issued drom web). Alex Shi and [mysql] and see if socket=/var/lib/mysql/mysql.sock is specified anywhere. HTH, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Alex Shi [EMAIL PROTECTED] To: mysql group [EMAIL PROTECTED] Sent: Sunday, February 02, 2003 12:03 AM Subject: datadir and socket Hi, I have a MySQL 2.23.36 running on a Linux RH 7.1. Its database directory is /var/lib/mysql/. For some reason I want to change it to /home/mysql/. So I did following things: 1. modify /etc/my.cnf: changed all /var/lib/mysql/ to /home/mysql/ 2. modyfy /etc/init.d/mysqld: changed /var/lib/mysql/ to /home/mysql/ 3. copied all database files from /var/lib/mysql/ to /home/mysql/ 4. restart mysqld OK. everything looks fine for connections from foreign machines. However, for local connections, say connections from a locally hosted web site via PHP, or a command line connection issued from shell, it will return following error message: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' This was weird, since I had assumed that I made all the neccary changes in /etc/my.cnf and /etc/init.d/mysqld. Seems like mysql has some configure information hard-coded into its buildup or whatever, and cannot be modified after installation? Alex Shi - 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
datadir and socket
Hi, I have a MySQL 2.23.36 running on a Linux RH 7.1. Its database directory is /var/lib/mysql/. For some reason I want to change it to /home/mysql/. So I did following things: 1. modify /etc/my.cnf: changed all /var/lib/mysql/ to /home/mysql/ 2. modyfy /etc/init.d/mysqld: changed /var/lib/mysql/ to /home/mysql/ 3. copied all database files from /var/lib/mysql/ to /home/mysql/ 4. restart mysqld OK. everything looks fine for connections from foreign machines. However, for local connections, say connections from a locally hosted web site via PHP, or a command line connection issued from shell, it will return following error message: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' This was weird, since I had assumed that I made all the neccary changes in /etc/my.cnf and /etc/init.d/mysqld. Seems like mysql has some configure information hard-coded into its buildup or whatever, and cannot be modified after installation? Alex Shi - 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: datadir and socket
Thanks for your reply. but I did correctly set the mode and ownership. Alex Basically the problem is only the ownership and it has to be owned by mysql. The problem is indeed there, how to chown or chmod those data so it can be owned by mysql. JD Alex Shi wrote: Hi, I have a MySQL 2.23.36 running on a Linux RH 7.1. Its database directory is /var/lib/mysql/. For some reason I want to change it to /home/mysql/. So I did following things: 1. modify /etc/my.cnf: changed all /var/lib/mysql/ to /home/mysql/ 2. modyfy /etc/init.d/mysqld: changed /var/lib/mysql/ to /home/mysql/ 3. copied all database files from /var/lib/mysql/ to /home/mysql/ 4. restart mysqld OK. everything looks fine for connections from foreign machines. However, for local connections, say connections from a locally hosted web site via PHP, or a command line connection issued from shell, it will return following error message: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' This was weird, since I had assumed that I made all the neccary changes in /etc/my.cnf and /etc/init.d/mysqld. Seems like mysql has some configure information hard-coded into its buildup or whatever, and cannot be modified after installation? Alex Shi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
where clause question
Hi, I need a where clause in following situation: Say I want to query two tables: A and B. In table A there is field Afn, while in table B there ere 3 fields: Bfn1, Bfn2 and Bfn3. I want to compose a query, in which the where clause can do this: if A.Afn=1, then check Bfn1, if A.Afn=2, then check Bfn2, if A.Afn=3, then check Bfn3. So how I compose a where clause to do this? Thanks in advance! Alex Shi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to check disk space used for a mysql account
How to check disk space been used for all of the tables of a specific mysql account? Thanks in advance for all answer! Alex - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How Query and Fetch work?
Yesterday I posted a question yet got response. The question is regarding to how Query works. Now I repost it in a more specific way. I am just wondering how MySQL API functions work. Let's look at following two functions: 1. mysql_query(), 2. mysql_fetch_array() To my understanding, mysql_query() will definately to its job with MySQL server. But how about the latter? Does it just fetch data from client/local buffer, which is previously put in by mysql_query(), or still has to goto server side to fetch data? Alex - 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 Behaviour
My situation is to access a remote MySQL server, and of course I do care about traffic. Suppose In a script there's a query: $result = mysql_query (select * from employ where age45) or die (Invalid query); I am just wondering that if MySQL server would return all the query result in total, so that the following fetches won't go to server again. This is what I expect. However if it does in the other way, I mean MySQL would hold the result and the following fetches had to go server to obtain dataOh my GOD it will definately cause trouble- some traffic I also posted this message to PHP list. I am not sure if it is a MySQL question. Thanks for all reply in advance! Alex - 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
Backup and Restore
Hello, I have a question regarding to table backup and restore. Suppose we have a table of sales waste book. Now I need to backup data within a certain period of time (from date1 to date2) from the table, and after backup the data should be deleted from the table. Also the backuped data can be restored back to the table. I just want to know if there is any built-in functionality in MySQL to do this. Yes I know with combination of normal sql statements this job can be done but I still like to know if we can make things simple. Alex - 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 on Win2000
Hello, I installed MySQL 3.23.46 on Windows2000. The mysql-nt started on Windows startup, and MysqlAdmin is also running well. I tried to create a database with it and it works! Everything looks perfect except I want to do something more than this admin tool can. What I need is to create/drop table, add/drop user for a certain database, and place query statement, etc.. However in MysqlAdmin I didn't see those I expectedDo I need to login to mysql from dos terminal for the admin job? Can I use phpmadmin for Win2k/apache/ php/mysql platform? I'm totally new for mysql on Windows, please help me out if anyone is familiar with this issue. Thanks in advance! Alex - 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 on Win2000
Okay, I will try MySQL GUI later BTW, do I have to use ODBC if I use PHP? I'm told PHP has its own very API for MySQL... Alex - Original Message - From: Miguel Angel Solórzano [EMAIL PROTECTED] To: Alex Shi [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, December 13, 2001 3:12 PM Subject: Re: MySQL on Win2000 At 14:51 13/12/2001 -0500, Alex Shi wrote: Hi! The development of WinMySQLAdmin was stopped since other client cross platform is in the works. However you can use MySQLGUI that provides you with a complete set of features (you can download it from our site). Also you can use clients programs like Perl, PHP, Python, any one which uses ODBC driver (you need to download MyODBC driver from our site), C/C++, Delphi, VB. Regards, Miguel Hello, I installed MySQL 3.23.46 on Windows2000. The mysql-nt started on Windows startup, and MysqlAdmin is also running well. I tried to create a database with it and it works! Everything looks perfect except I want to do something more than this admin tool can. What I need is to create/drop table, add/drop user for a certain database, and place query statement, etc.. However in MysqlAdmin I didn't see those I expectedDo I need to login to mysql from dos terminal for the admin job? Can I use phpmadmin for Win2k/apache/ php/mysql platform? I'm totally new for mysql on Windows, please help me out if anyone is familiar with this issue. Thanks in advance! Alex - 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 -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ 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
Why MySQL GUI download don't work?
I tried to download MySQL GUI from these links: http://www.mysql.com/Downloads/mysqlgui/mysqlgui-win32-static-1.7.5-2.zip and http://www.mysql.com/Downloads/mysqlgui/mysqlgui-linux-static-1.7.5-1.tar.gz But all these don't work. Alex - Original Message - From: Matthew Darcy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, December 12, 2001 9:22 AM Subject: RE: I must be mental but. I compiled without problem mysql on Redhat linux 7.1 I have just started the sever using nohup /usr/local/mysql/libexec/mysqld This started fine without problem. as I am used to using Oracle and new to mysql I decided to do an mysql_install_db which prompted me saying remember to change password using mysqladmin -p password `password` I did this and it asked me for a password ?? what is the password and how do I change it. This command to me suggests that -p password enters the password password and the `password` is the new password ??? can someone explain ?? 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 - 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