TimeZone

2005-08-08 Thread KH
code together with their timezone? Cheers KH -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL in CentOS? try before?

2005-08-04 Thread KH
Hi all, This amazing feedback from you guys, I feel much comfortable now start digging on this CentOS. Thanks & Cheers KH Jason Pyeron wrote: Yes, we use it for our Crisfield product, and we use it for our servers too. On Thu, 4 Aug 2005, KH wrote: Hi all, I just came across Ce

MySQL in CentOS? try before?

2005-08-04 Thread KH
Hi all, I just came across Centos (Community Enterprise Operating System - http://www.centos.org/) It came with mysql as well. Hence my question here, does anyone guru here using this OS before for production ? Success story? Cheers KH -- MySQL General Mailing List For list archives: http

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

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
In my experience, Perl + DBD-mysql will be the most easy tool for UNIXer (Linuxer). Especially, if you plan to write some non-GUI based system service program. Best regards, KH > Depends on what you are experienced with on win platform I would of thought. > > Something like vB or

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
It seems that you have reached the 2G file limit with many Linux system. I am not familiar with SuSe. As I know, you may try to use raid option. You may refer to MySQL doc. on 'create' for details. KH > Dear Ladies and Sirs, > > I have a problem to create a tables duplicat

RE: Speed improvement with packet proceeding!?

2003-02-23 Thread KH Chiu
g the same table at the same time. Best regards, KH > On 23-Feb-2003 Julian wrote: > > Speed improvement with packet proceeding!? > > > > 1. Packet proceeding: > > > > I'm not quite sure is it possible with Mysql but it could be "easy" to > &g

Re: inquiry

2003-02-23 Thread KH Chiu
After that you can use the 'mysql' command to connect to the database. For a new setup you may use mysql -u root You may refer to the manual after these steps. Best regards, KH > I have installed mysql form the rpm files that are on rpm finder, > acording to the installation it

Re: Is this a bug?

2003-02-20 Thread KH Chiu
ECT binary 'abc' = 'ABC'; will return false. SELECT binary 'abc' = 'abc '; will also return false. Best regards, KH > In the last episode (Feb 21), Zhestkov Victor said: > > I have a table with varchar column and when I execute SELECT query like

Re: What is needed for ODBC?

2003-02-20 Thread KH Chiu
All you need to do is set up a MySQL user that allow the Windows box to access the MySQL database. Regards, KH > Hello, > > I hope it is okay to ask this here. I have a MySQL server running on > Slackware 8, and I would like to access it from a Windows box using Excel >

Re: Web interface

2003-02-20 Thread KH Chiu
I am using phpMyAdmin. But it is written in php. Regards, KH > Hi all! > > I started using MySQL about two months ago (and I already love it!) > and I'm new to this list... > > I would like to know if there's some web interface for MySQL > management that h

Re: Is SQL right for me?

2003-02-20 Thread KH Chiu
some what restricted to programmer or at least tech. people. Regards, KH > So what is the actual question ? > > If you don't have the software, surely you should get it and read > the manual if that is the best way you learn ! > > Jerry > > - Original Mes

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
As far as I know, if you only require MySQL as an option or just an added features, your company do not need to purchase a license. KH > > Otherwise, you may ask whether MySQL is an option or > > not. It means that if > > your logs and related information can go to other

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
ou give me more help. Best regards, > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Hello KH, > > Tuesday, February 18, 2003, 2:15:47 PM, you wrote: > > > Thank you very much for your information. Can you tell me more how to limit > > size of directory in

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