Re: Using ssh tunnel and mysql

2003-03-07 Thread KH Chiu
What does it really matter is whether you have create mySQL user that allow access the database from the SSH server. Please note that localhost, 127.0.0.1 or the machine ip address will be treated as different entries by mySQL. -- Yours, KH Chiu C&A Computer Consultants Ltd. Tel: 3104 2070

Re: Questions about HEAP tables

2003-03-07 Thread KH Chiu
s the table will automatically drop after the connection close and will not appear in other connections. Heap means to create table in server's memory. So, they may use together to make high access speed temporary table. Of course, heap table will eat your server RAM. Best regards, -- Yours,

Re: Temporary Tables

2003-03-04 Thread KH Chiu
Paul is right. I would like to add a small remark, it should better to drop the temp. tables before closing your script. This can free up resources. I had a painful experience that I had created hash temp. tables without dropping them. This lead to memory leak. Regards, -- Yours, KH Chiu C&a

Re: mysql encripted password from perl

2003-02-28 Thread KH Chiu
change $sql .= "VALUES(?, ?)"; into $sql .= "VALUES(?, password(?))"; Please note that password is a mySQL function and not a PERL function. So, you need to use the password function again in verify the password. Regards, KH > I have perl code like >my $username = $query->param("user

Re: phpMyadmin

2003-02-26 Thread KH Chiu
Are you using a RedHat system. In RedHat system does not install php mysql support by default. You may install php-mysql rpm from redhat distribution disks. Regards, -- Yours, KH Chiu C&A Computer Consultants Ltd. Tel: 3104 2070 Fax: 3010 0896 Email: [EMAIL PROTECTED] Web

re: phpMyadmin

2003-02-25 Thread KH Chiu
in on the host by IE. If further security is required (esp. on the move), you may consider to have SSL installed. You may also consider some secure shell such as ssh which can also provide secure connection. Regards, -- Yours, KH Chiu C&A Computer Consultants Ltd. Tel: 3104 2070 Fax: 3010 0

Re: MySQL on windows

2003-02-24 Thread KH Chiu
.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,

Re: Strange BUG? with a working table

2003-02-24 Thread KH Chiu
; > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To req

Re: Strange BUG? with a working table

2003-02-24 Thread KH Chiu
;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 > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Your

RE: Speed improvement with packet proceeding!?

2003-02-23 Thread KH Chiu
teal the neighbor's newspaper, that's the time to do it. > (53kr33t w0rdz: sql table query) > > - > Before posting, please check: >http://www.mysql.com/manual.php (the man

Re: inquiry

2003-02-23 Thread KH Chiu
ng, 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 > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubs

Re: Is this a bug?

2003-02-20 Thread KH Chiu
--- > 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 <[EMAI

Re: What is needed for ODBC?

2003-02-20 Thread KH Chiu
--- > 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 > Trouble unsubscribing? Try: http://lists.mysql.c

Re: Web interface

2003-02-20 Thread KH Chiu
CTED]> > To unsubscribe, e-mail > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Yours, KH Chiu C&A Computer Consultants Ltd. Tel: 3104 2070 Fax: 3010 0896 Email: [EMAIL PROTECTED] Website: www.caconsultant.com --

Re: Is SQL right for me?

2003-02-20 Thread KH Chiu
;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 > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- You

Re: varchar and java string in sql query ?

2003-02-19 Thread KH Chiu
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 > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Yours

Re: How to determine foreign keys? Meta data?

2003-02-19 Thread KH Chiu
nual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Yours, KH Chiu C&A Computer Consultants L

Re: Is this query possible...

2003-02-19 Thread KH Chiu
ead, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Yours, KH Chiu C&A Computer Consultants Ltd. Tel: 3104 2070 Fax: 3010 0896 Email: [EMAIL PROTECTED] Website: www.caconsultant.com --

Re: Joining multiple tables results not complete

2003-02-19 Thread KH Chiu
(the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Yours, KH Chiu

Re: Lost connection to MySQL server during query

2003-02-19 Thread KH Chiu
- > Aman Raheja > AGF Inc. > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thre

Re: sql join help?

2003-02-19 Thread KH Chiu
> 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 uns

Re: License question

2003-02-19 Thread KH Chiu
) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Yours, KH Chiu C&A Computer Consultants Ltd. Tel: 3104 2070 Fax: 3010 0896 Email: [EMAIL PROTECTED] Website: www.caconsultant.

Re: Sequential read on a file

2003-02-19 Thread KH Chiu
://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 > Trouble unsubscribing?

Re: Question about auto-increment columns

2003-02-19 Thread KH Chiu
e 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

Re: Archive on remote Machine.

2003-02-19 Thread KH Chiu
fact, I have a project that has more complex remote backup requirement. I am working on it using C right now but not yet completed. Regards, > Thanx for the suggestion. > Is there any way i can Archive data to remote machine where MySQL is > not installed. > > Anis > > &g

RE: Limits and order bys

2003-02-18 Thread KH Chiu
.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: problem in connecting to DB

2003-02-18 Thread KH Chiu
; 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 >

Re: License question

2003-02-18 Thread KH Chiu
>http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Yours, KH Chiu C&A Computer Consultant

Re: Archive on remote Machine.

2003-02-18 Thread KH Chiu
(the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Yours, KH Chiu C&A Computer Consultants Ltd. Tel: 3104 2070 Fax: 3010 0896 Email: [EMAIL PRO

Re: Limit the database size

2003-02-18 Thread KH Chiu
of 100MB > if the group don't exist create one > > P.S. > This was done by reading the man > > > Thank you very much. > > >> On Tuesday 18 February 2003 04:26, KH Chiu wrote: > >> > >> > I am planning to offer a free service that allow users t

re: Limit the database size

2003-02-18 Thread KH Chiu
Thank you very much for your information. Can you tell me more how to limit size of directory in Linux? I can only set quota for users or groups but not for directory. Thank you very much. > On Tuesday 18 February 2003 04:26, KH Chiu wrote: > > > I am planning to offer a free

Re: Oh GAWD somone HELP :)

2003-02-18 Thread KH Chiu
168.0.2 from various hosts on my network and all hosts can > reverse lookup from my dns server. > > no good > - Original Message - > From: "KH Chiu" <[EMAIL PROTECTED]> > To: "Poodle" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent

Re: Oh GAWD somone HELP :)

2003-02-17 Thread KH Chiu
- > 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]> > T

Limit the database size

2003-02-17 Thread KH Chiu
unfunctional. So is there any way to limit the size of individual database? Thank you in advance. -- Yours, KH Chiu C&A Computer Consultants Ltd. Tel: 3104 2070 Fax: 3010 0896 Email: [EMAIL PROTECTED] Website: www.caconsultant

Re: Database Backup Question

2003-02-17 Thread KH Chiu
--- > 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 > Tro