request for unsubscribe ingored

2003-02-10 Thread Alex Shi
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! Ale

Re: datadir and socket

2003-02-05 Thread Alex Shi
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 sup

Re: datadir and socket

2003-02-04 Thread Alex Shi
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 Hin

Re: datadir and socket

2003-02-03 Thread Alex Shi
ou 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 co

Re: datadir and socket

2003-02-02 Thread Alex Shi
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 > > >Al

datadir and socket

2003-02-02 Thread Alex Shi
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 archi

where clause question

2002-10-06 Thread Alex Shi
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

How to check disk space used for a mysql account

2002-01-23 Thread Alex Shi
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.mys

How Query and Fetch work?

2002-01-08 Thread Alex Shi
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_q

Query Behaviour

2002-01-07 Thread Alex Shi
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 age>45") or die ("Invalid query"); I am just wondering that if MySQL server would return all the query result in tot

Backup and Restore

2001-12-20 Thread Alex Shi
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 re

Re: MySQL on Win2000

2001-12-13 Thread Alex Shi
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

MySQL on Win2000

2001-12-13 Thread Alex Shi
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

Why MySQL GUI download don't work?

2001-12-12 Thread Alex Shi
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 P

MySQL can not tell differences among some of the Chinese characters

2001-12-12 Thread Alex Shi
hpmyadmin, terminal and php script, and got same result. Please, if anyone here happen to know this issue, help me out. Thanks in advance! Regards, Alex Shi - Before posting, please check: http://www.mysql.com/manua