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! Alex Shi

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

Re: datadir and socket

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

Re: datadir and socket

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

datadir and socket

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

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 Alex Shi wrote: Hi, I have

where clause question

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

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)

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,

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 age45) or die (Invalid query); I am just wondering that if MySQL server would return all the query result in total,

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

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

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 PROTECTED] Sent: Thursday, December 13, 2001 3:12

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