Re: MySql 4.0.2a Bind-Address problem

2002-09-03 Thread Michael Tam
Hi all, I just tried 4.0.3beta and it doesn't seem to address the bind-address problem at all. When I include the option in the ini file and run "mysql-max-nt --help", it stops showing the variables when it reaches "bind-address" variable and a window pops up with the following message: Th

MySql 4.0.2a Bind-Address problem

2002-08-27 Thread Michael Tam
Hi all, I tried to use config. variable 'bind-address' for MySQL 4.0.2a (mysqld-max-nt) to assign a particular ip for the server. However, I got the following error: E:\mysql4.0.2a\bin>mysqld-max-nt --help Unknown suffix '.' used for variable 'bind-address' (value '192.168.0.176') mysqld-max

Re: Do you run multiple servers on WIndows?

2002-07-26 Thread Michael Tam
What about running multiple mysql in console mode instead of service? Another concern would be how to tell each mysql to read a specified config file instead of having them all read the same one in the "window"\"winnt" folder. Regards, Michael - Original Message - From: "Bhavin Vyas" <[E

JDBC and MySQL problem, please help.

2002-01-16 Thread Michael Tam
Hi All, I just installed resin-cmp-1.0.5 with Apache1.3.22 and mysql3.23.47. I used m.mmysql.2.0.8 JDBC driver with the following config segment in my resin.conf: jdbc/test javax.sql.XADataSource The initialization servlet did create and populate tables into

Re: INSERT Problem with mm.mysql, JBoss and an EJB

2001-09-24 Thread Michael Tam
Hi Robert, I have experience the similar issue with MySQL, MM.MySQL and JBOSS. I was using CMP-EJBs with INNODB table from MySQL-Max and data did not persist in the table as I called EJB create(). The issue resolved as I 'alt' the table back to MyISAM tables. I have posted the issu

IDE-RAID QUESTION

2001-09-19 Thread Michael Tam
Hi all, I realize IDE-RAID is relatively micky mouse to those SCSI-RAID but I would like to know if there is any beneficials running MySQL over IDE-RAID and is there any configuration I need to optimize MySQL to utilize the RAID?? All helps/suggestions are greatly appreciated. Regards,

Help -- can't install mysql as service in win2k

2001-09-06 Thread Michael Tam
Hi all, I have uninstall mysql3.23.39 from Win2k and after I install mysql3.23.41-max ... I was unable to run it as service. When I tried to start the service I receive the following message ... Could not start the MySql service on Local Computer Error 1067: The process terminated unexpecte

Question on Table types and EJB persistance

2001-08-27 Thread Michael Tam
Hi all, I know this might be slightly off topics. I was trying to make JBoss/MM-MySQL_JDBC/MySQL to work together. However, I found the following problem. With MyISAM type, the container-managed persists ok; but, with INNODB type, JBoss doesn't able to persist the data back to the I

Re: encrypt/decrypt question

2001-08-14 Thread Michael Tam
Thank you for all your valuable help and input. I now got some idea to do the job. Greatly appreciated. - Original Message - From: <[EMAIL PROTECTED]> To: "Michael Tam" <[EMAIL PROTECTED]> Cc: "mysql" <[EMAIL PROTECTED]> Sent: Tuesday, August

encrypt/decrypt question

2001-08-14 Thread Michael Tam
Hi all, I am very new to the encrypt and decrypt data process and would like to know how do I able to encrypt a string and store to MySQL and retrieve the data and decrypt it at the later time. I understood it sorts of contradict the point of security but I just want to use it to cove

MySQL 3.23.40 for Windows

2001-07-27 Thread Michael Tam
Hi everyone, I wonder if MySQL 3.23.40 for Windows is available. I went to mysql.com and couldn't find the binary of 3.23.40 for Windows. Regards, Michael - Before posting, please check: http://www.mysql.com/manual.php

3.23.40 Win32 version

2001-07-26 Thread Michael Tam
Hi all, I couldn't find the latest 3.23.40 Version available under Win32. Does anybody know when it would be released? Thanks. Regards, Michael

Re: Transaction for MySQL

2001-07-21 Thread Michael Tam
sqld-nt" will remain intact as "mysql-max" takes over?? Thank you very much. Regards, Michael - Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "Michael Tam" <[EMAIL PROTECTED]> Cc: "mysql" <[EMAIL PROTE

Re: Transaction for MySQL

2001-07-18 Thread Michael Tam
- Original Message - From: "Michael Tam" <[EMAIL PROTECTED]> To: "mysql" <[EMAIL PROTECTED]> Sent: Wednesday, July 18, 2001 2:06 PM Subject: Transaction for MySQL Hi all, I am new using MySQL. I found out that the default table type used in the binary isn

Transaction for MySQL

2001-07-18 Thread Michael Tam
Hi all, I am new using MySQL. I found out that the default table type used in the binary isn't support transaction and would like to make MySQL uses another table type which supports transaction. The following are my questions regarding the issue: 1) which one should I use InnoDB or BDB?

archive of the mailing list

2001-07-17 Thread Michael Tam
Hi all, My OutLook express some how got rib most of the mails I received from the mailing list for no reason. I have to say most of the mails are very good reference/resource and I would like to keep them for reference. I wonder if there is any way I can obtain an archive of the mailing

Re: How to connect mysql server (on unix) by using win2000??

2001-07-11 Thread Michael Tam
Hi Zosen, I am not 100% sure but this what I believe would work. You need MyODBC install in your win2k machine, then setup the DSN. Then your IIS/ webserver can use windows naming to locate MySql server in your linux box. Regards, Michael - Original Message - From: "zosen" <[E

Re: Security

2001-07-10 Thread Michael Tam
ROTECTED]> To: "Michael Tam" <[EMAIL PROTECTED]> Sent: Tuesday, July 10, 2001 12:00 PM Subject: Re: Security > Your first security problem is using Microsoft NT/2000. Switch to linux > 2.2.18/+ as a solution. > > Mark > > Michael Tam wrote: > > > >

Security

2001-07-10 Thread Michael Tam
Hi all, This may not directly related to the topic but I think people in this list may able to give me some ideas. I am not really kean of security issue and would like to ask the following questions: I have 2 win2k pcs one directly connected to internet (say PC A) and PC B is

Can't download files from MySql.com

2001-07-05 Thread Michael Tam
Hi all, Did anyone experience any difficulty on downloading files from mysql.com?? I tried to download MyODBC from the download page but none of the downloads seems working at all Regards, Michael

Re: MySQL HELP -- Unable to start Win2k service

2001-07-03 Thread Michael Tam
Hi all, Thank you for giving me direction to where I should look into the problem. I finally fix the problem which is coming from a mistake that I made in my.ini. Regards, Michael

Re: MySQL HELP -- Unable to start Win2k service

2001-07-03 Thread Michael Tam
AIL PROTECTED]> To: "Michael Tam" <[EMAIL PROTECTED]> Cc: "mysql" <[EMAIL PROTECTED]> Sent: Tuesday, July 03, 2001 9:10 AM Subject: Re: MySQL HELP -- Unable to start Win2k service > >I have tried to remove the service, uninstalled the mysql and reinstall

MySQL HELP -- Unable to start Win2k service

2001-07-03 Thread Michael Tam
Hi all, I have beening running mysql on my win2k for awhile. This afternoon, I have restarted my pc and the next thing I notice mysql service was unable to start. The following is the message I got: Could not start the Mysql service on Local Computer. Error 1067: The process terminated u

Newbie problem with winmysqladmin

2001-06-28 Thread Michael Tam
info. In addition, beside winmysqladmin, what other gui program will allow me to obtain those info? If anybody can give me a direction to where I should look into, that would be great and appreciated. Thank you. Best regards, Michael Tam