RE: Uninstall mysql

2004-04-22 Thread Tam, Michael 
Hi,

I forgot to reply to the list instead.

This is a recap of what I sent to Vasanthsena x.  

These are the steps I do when I have to uninstall it.
1. Stop mysqld (through service or manually using mysqladmin)
2. Remove mysqld service if you have setup the service.
3. Go to add/remove program in control panel to remove the
application.

In addition to the above, since the uninstallation took place already,
terminate mysqld through your task manager (ctrl+alt+delete).  If mysql
service is still there, use your CMD prompt, go to mysql bin directory and
run 'mysqld --remove' to remove it.

Cheers,
Michael

-Original Message-
From: vasanthsena x [mailto:[EMAIL PROTECTED]
Sent: 21 April 2004 15:50
To: [EMAIL PROTECTED]
Subject: Uninstall mysql


Hi,

I tried to uninstall mysql from win Xp.however it did
not remove everything completely.I tried to remove the
files manually but specifically it does not let me
delete mysqld.exe.it says access denied.

Can anyone help me?I would to reinstall mysql.

S.





__
Do you Yahoo!?
Yahoo! Photos: High-quality 4x6 digital prints for 25¢
http://photos.yahoo.com/ph/print_splash

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Testing

2003-09-05 Thread Tam, Michael 
Testing my autoreply.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Testing again

2003-09-05 Thread Tam, Michael 
Sorry for the waste of bandwidth.  I need to make sure my autoreply doesn't
send to the list.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Telneting failed

2003-03-13 Thread Tam, Michael 
Hi Dan and everyone,

First off, I apologize for the stupid question due to my lack of technical
knowledge on this area.

What I am trying to do is to connect to a MySQL on a Win2k machine from
another Win2k machine with SSH.
After doing some research, I manage to grasp some idea on how to establish
it.  
However, there are still some detail and confirmation I need to get it to
work.

First, correct me if I am wrong, I need to establish a SSH server on the
machine which has mysql running [Done by setting up OpenSSH for Win32].
Then I need a SSH client on a another win2k machine [Done by having
SecureCRT on the machine]. After these, I should configure the client SSH to
connect to the server.  Then I can run pretty much any MySQL GUI client to
connect to MySQL under SSH.

To the SSH client config section, I need to setup a local forwarding and/or
remote forwarding and this is where I am not clear how to get it right.

For example, 
  server PC  has  ip 192.168.0.100
  client PC  has  ip 192.168.0.101

  To setup local forwarding:   localport:3306  remotehost: 192.168.0.100
port: 3306
  Then I can use MySQL client to connect to 192.168.0.101:3306 to reach the
server, am I correct?

I would greatly appreciate if someone can verify these steps and correct me
if I misunderstood any item.

Thank you so much.

Regards,
Michael

-
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 [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Telneting failed

2003-03-13 Thread Tam, Michael 
Jeff,

Thank you for your confirmation.  I will give it a try later on my machines.

Michael

-Original Message-
From: Jeff Kilpatrick [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 13, 2003 11:29 AM
To: Tam, Michael
Cc: [EMAIL PROTECTED]
Subject: RE: Telneting failed


Michael-

That seems to be correct.  I've been able to do this using PuTTY as the
client.  Just forward the local 3306 to the server's 3306 and connect to
localhost:3306.  Be sure to log to the server via ssh before attempting
a connection.

-jeff
On Thu, 2003-03-13 at 13:09, Tam, Michael wrote:
 Hi Dan and everyone,
 
 First off, I apologize for the stupid question due to my lack of technical
 knowledge on this area.
 
 What I am trying to do is to connect to a MySQL on a Win2k machine from
 another Win2k machine with SSH.
 After doing some research, I manage to grasp some idea on how to establish
 it.  
 However, there are still some detail and confirmation I need to get it to
 work.
 
 First, correct me if I am wrong, I need to establish a SSH server on the
 machine which has mysql running [Done by setting up OpenSSH for Win32].
 Then I need a SSH client on a another win2k machine [Done by having
 SecureCRT on the machine]. After these, I should configure the client SSH
to
 connect to the server.  Then I can run pretty much any MySQL GUI client to
 connect to MySQL under SSH.
 
 To the SSH client config section, I need to setup a local forwarding
and/or
 remote forwarding and this is where I am not clear how to get it right.
 
 For example, 
   server PC  has  ip 192.168.0.100
   client PC  has  ip 192.168.0.101
 
   To setup local forwarding:   localport:3306  remotehost: 192.168.0.100
 port: 3306
   Then I can use MySQL client to connect to 192.168.0.101:3306 to reach
the
 server, am I correct?
 
 I would greatly appreciate if someone can verify these steps and correct
me
 if I misunderstood any item.
 
 Thank you so much.
 
 Regards,
 Michael
 
 -
 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
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.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, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Telneting failed

2003-03-12 Thread Tam, Michael 
Hi All,

I am running MySQL 4.0.11a on Win2k Pro at home.  The machine is connected
to a router which redirect port 3306 to MySQL.  Things seem to work very
well.  I have MySQLCC and MySQL-Front both connecting to MySQL locally and
remotely.   However, when I try connecting through telnet locally at this
point, I receive a prompt with MySQL Version and some ASCII characters, and
then a few second later I got a bad handshake and connection closed.   I do
not have a clue whether it is problem caused by the router or I misconfig
MySQL so it fails the telnet connection.  Any suggestion or help would be
greatly appreciated.

regards,
Michael



-
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 [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: simple windows client for mysql

2003-01-21 Thread Tam, Michael 
Have you check out MyCC from mysql.com ??  It can be used as a front-end of
MySQL.

Cheers,
Michael

-Original Message-
From: David Driscoll [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 21, 2003 3:53 PM
To: [EMAIL PROTECTED]
Subject: simple windows client for mysql


I have a fairly basic mysql database running on unix. Now I need to make
this 
data available to other people.  These would be various engineers and 
administrators using every version of windows from 95 (japanese version) to 
XP all using laptops connected to our internal network.  I am looking for an

easy to use, easy to install mysql client which would enable users to query 
my database.  It seems that installing mysql server for windows on each 
machine would do this but it seems like using a shovel to swat a fly. 
Suggestions?  Cheap is good too.
Thanks
Dave Driscoll

-
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
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.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, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Auto Increment ID of Inserted Row

2002-09-19 Thread Tam, Michael 

I believe this approach work in a single connection environment and it has a
potential problem when it is running in a concurrent system.
  
What happens if there is another insert occurred through another connection
just before this statement being executed??
The result of this statement would not be id you are expecting.

Regards,
Michael

-Original Message-
From: Steven Kreuzer [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 10:24 AM
To: Davis, Tim
Cc: Mysql (E-mail)
Subject: Re: Auto Increment ID of Inserted Row


SELECT MAX(id_field) FROM table

SK

On Thursday, September 19, 2002, at 12:55 PM, Davis, Tim wrote:

 What is the SQL to get the created AutoInc ID from a row that I have 
 just
 inserted?

 Tim Davis
 Sunbelt Systems Concepts, Inc
 [EMAIL PROTECTED]
 Client/Server Database Programmer/Analyst


 -
 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 
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.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, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.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, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: mysql max

2002-09-05 Thread Tam, Michael 

If you're using MySQL 4.0.x, mysql max is included.

-Original Message-
From: Gurhan Ozen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 05, 2002 2:43 PM
To: Edward Peloke
Cc: [EMAIL PROTECTED]
Subject: RE: mysql max


Mysql-Max binaries are the binaries complied with InnodB support and
InnoDB tables support transactions. So if you do something that has to
be transaction-based, then you'd use mysql-max.

Gurhan


On Thu, 2002-09-05 at 16:17, Edward Peloke wrote:
 
 So is there really any benefit to using MySql Max?
 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
 Iikka Meriläinen
 Sent: Thursday, September 05, 2002 3:53 PM
 To: Edward Peloke
 Cc: [EMAIL PROTECTED]
 Subject: Re: mysql max
 
 
 Hello,
 
 As of this writing, MySQL doesn't support stored procedures. It will most
 probably support them in 4.x versions to come.
 
 However, there are millions of web pages that use PHP in conjunction with
 MySQL without stored procs, although they would certainly benefit of them,
 but those sites work fine.
 
 Regards,
 Iikka
 
 On Thu, 5 Sep 2002, Edward Peloke wrote:
 
  I am new to MySql and am trying to learn PHP in conjunction with MySql.
 The
  webpage that I want to create will benefit from stored procedures.  Are
  these available with MySqlMax?  If so, is it setup the same way as
MySql?
 
  Thanks,
  Eddie
 
 
  -
  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
 [EMAIL PROTECTED]
  Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
 
 **
 * Iikka Meriläinen   *
 * E-mail: [EMAIL PROTECTED] *
 * Vaala, Finland *
 **
 
 
 -
 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
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.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, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.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, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

MySQL 4.0.3b Bind-Address problem

2002-09-03 Thread Tam, Michael 

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:

The instruction at 0x005c89eb referenced memory at 0xb000a8c0. The
memory could not be read.

Regards,
Michael



--
Michael Tam - NFI Database Developer  Natural Resources Canada
[EMAIL PROTECTED] Pacific Forestry Center
Phone: (250) 363-8074  506 West Burnside
Road
Fax: (250) 363-0775  Victoria, BC  V8Z
1M5


-
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 [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

MySQL 4.0.3b Bind-Address Problem

2002-09-03 Thread Tam, Michael 

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:

The instruction at 0x005c89eb referenced memory at 0xb000a8c0. The
memory could not be read.

Regards,
Michael



--
Michael Tam - NFI Database Developer  Natural Resources Canada
[EMAIL PROTECTED] Pacific Forestry Center
Phone: (250) 363-8074  506 West Burnside
Road
Fax: (250) 363-0775  Victoria, BC  V8Z
1M5


-
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 [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: JDBC 3.0 Driver

2002-08-27 Thread Tam, Michael 

Try MySQL Connector-J 3.0.0 (dev).  You can download it from mysql.com.

Regards,
Michael

-Original Message-
From: Mike Duffy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 27, 2002 7:41 AM
To: [EMAIL PROTECTED]
Subject: JDBC 3.0 Driver


Does anyone know if there is a good JDBC 3.0 Driver for MySQL?

I would like to use the getGeneratedKeys() method.

Thanks.

Mike

__
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com

-
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
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.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, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: MySql 4.0.2a Bind-Address problem

2002-08-27 Thread Tam, Michael 

Hi Victoria,

  May I ask when 4.0.3 will be released?
  In addition, I found 4.0.x contains the max sqld as well.  Are there any
different between the 4.0.x and 4.0.x-MAX version?

Regards,
Michael

-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 27, 2002 3:57 AM
To: [EMAIL PROTECTED]
Subject: Re: MySql 4.0.2a Bind-Address problem


Michael,
Tuesday, August 27, 2002, 12:40:31 PM, you wrote:

MTI tried to use config. variable 'bind-address' for MySQL 4.0.2a
MT (mysqld-max-nt) to assign a particular ip for the server.  However, I
got
MT the following error:

MT E:\mysql4.0.2a\binmysqld-max-nt --help
MT Unknown suffix '.' used for variable 'bind-address' (value
'192.168.0.176')
MT mysqld-max-nt: Error while setting value '192.168.0.176' to
'bind-address'

MT my .ini segment as follow:

MT # The MySQL server
MT [mysqld]
MT port=3306
MT skip-name-resolve
MT bind-address=192.168.0.176
MT 

It's a known bug and it is fixed in 4.0.3




-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-
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
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.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, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: mysql basics

2002-08-26 Thread Tam, Michael 

Please checks the documentation that comes with mysql.  It is an excellent
source to learn MySQL.

-Original Message-
From: Robert McKerlie [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 26, 2002 12:27 PM
To: [EMAIL PROTECTED]
Subject: mysql basics


Can anyone suggest a good tutorial for someone just starting out with MYSql?

Regards
Robert

-
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
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.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, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: getting started ....

2002-08-19 Thread Tam, Michael 

Try the sun site - www.javasoft.com
I believe there are tutorials for JDBC.

Cheers,
Michael

-Original Message-
From: john greene [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 19, 2002 10:28 AM
To: [EMAIL PROTECTED]
Subject: getting started 


i need help with getting started with mysql

i am a java programmer but have not done any database
stuff. i assume that mysql can be a good db to start
with java database programming ie jdbc stuff.

would you also say that mysql would be a good db to
start and learn with jdbc ? can some one let me know
some getting started java applications (with source
code) that i could learn from, tweak them etc etc..

any other info, links etc would be greatly
appreciated.

thanks



Want to sell your car? advertise on Yahoo Autos Classifieds. It's Free!!
   visit http://in.autos.yahoo.com

-
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
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.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, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: RE: Problem downloading MySQL4.0.2a for windows

2002-07-27 Thread Tam, Michael 

Hi Victoria,

Thanks.  Does this mean in the future the -max version would be merged into
one release or just for the 4.0.2a??

Many thanks.

Regards,
Michael 

-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 25, 2002 1:07 AM
To: [EMAIL PROTECTED]
Subject: Re: RE: Problem downloading MySQL4.0.2a for windows


Tam,
Tuesday, July 23, 2002, 9:38:17 PM, you wrote:

T Hi Victoria,

TDo you know when the 4.0.2a-MAX would be available for download then?
T Thank you.

Use mysql-win-4.0.2-alpha.zip instead. It the same as with -max.




-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-
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
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.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, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Data Entry for a Newbie

2002-07-25 Thread Tam, Michael 

MySql Front, http://www.anse.de/mysqlfront/, is a win32 GUI for admin and
data entry.

Yes, you can use html and some web programming to communicate with MySQL.

-Original Message-
From: William Bradley [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 25, 2002 8:13 AM
To: Mysql
Subject: Data Entry for a Newbie


At the moment I have Mysql installed and understand command line entry
of data, or entry via a text file. Either way, it is difficult,
especially if you have been used to data entry screens. Is there a
utility somewhere that would allow me to do this? Failing that, is it
possible to write a html file to communicate with the server on my own
computer?

Any help is appreciated,

Bill.




-
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
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.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, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Problem downloading MySQL4.0.2a for windows

2002-07-24 Thread Tam, Michael 

Hi All,

   Do anyone knows when the MySQL4.0.2a for windows is available for
download?  Thanks.

Regards,
Michael

-Original Message-
From: Tam, Michael [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 11:38 AM
To: 'Victoria Reznichenko'; [EMAIL PROTECTED]
Subject: RE: Problem downloading MySQL4.0.2a for windows


Hi Victoria,

   Do you know when the 4.0.2a-MAX would be available for download then?
Thank you.

Regards,
Michael

-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 4:26 AM
To: [EMAIL PROTECTED]
Subject: Re: Problem downloading MySQL4.0.2a for windows


Tam,
Tuesday, July 23, 2002, 12:39:33 AM, you wrote:

T I have difficulties obtaining the MySQL4.0.2a.  It seems that numerous
T downloads
T links point to the files stated as 4.0.2 zip file but during the setup ,
it
T was 4.0.1a
T instead.  Where can I obtain the 4.0.2a ?   Many thanks.

There was troubles only with mysql-max-4.0.2-alpha-win. This file was the
same as mysql-max-4.0.1, but mysql-4.0.2-alpha-win (without -max)
works well...


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-
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
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.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, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.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, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Problem downloading MySQL4.0.2a for windows

2002-07-24 Thread Tam, Michael 

Hi All,

Sorry about the typo. MySQL4.0.2a should be MySql4.0.2a-Max instead.
Thank you.

Regards,
Michael

-Original Message-
From: Tam, Michael [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 24, 2002 10:54 AM
To: [EMAIL PROTECTED]
Subject: RE: Problem downloading MySQL4.0.2a for windows
Importance: High


Hi All,

   Do anyone knows when the MySQL4.0.2a for windows is available for
download?  Thanks.

Regards,
Michael

-Original Message-
From: Tam, Michael [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 11:38 AM
To: 'Victoria Reznichenko'; [EMAIL PROTECTED]
Subject: RE: Problem downloading MySQL4.0.2a for windows


Hi Victoria,

   Do you know when the 4.0.2a-MAX would be available for download then?
Thank you.

Regards,
Michael

-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 4:26 AM
To: [EMAIL PROTECTED]
Subject: Re: Problem downloading MySQL4.0.2a for windows


Tam,
Tuesday, July 23, 2002, 12:39:33 AM, you wrote:

T I have difficulties obtaining the MySQL4.0.2a.  It seems that numerous
T downloads
T links point to the files stated as 4.0.2 zip file but during the setup ,
it
T was 4.0.1a
T instead.  Where can I obtain the 4.0.2a ?   Many thanks.

There was troubles only with mysql-max-4.0.2-alpha-win. This file was the
same as mysql-max-4.0.1, but mysql-4.0.2-alpha-win (without -max)
works well...


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-
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
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.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, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.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, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.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, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Problem downloading MySQL4.0.2a for windows

2002-07-23 Thread Tam, Michael 

Hi Victoria,

   Do you know when the 4.0.2a-MAX would be available for download then?
Thank you.

Regards,
Michael

-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 4:26 AM
To: [EMAIL PROTECTED]
Subject: Re: Problem downloading MySQL4.0.2a for windows


Tam,
Tuesday, July 23, 2002, 12:39:33 AM, you wrote:

T I have difficulties obtaining the MySQL4.0.2a.  It seems that numerous
T downloads
T links point to the files stated as 4.0.2 zip file but during the setup ,
it
T was 4.0.1a
T instead.  Where can I obtain the 4.0.2a ?   Many thanks.

There was troubles only with mysql-max-4.0.2-alpha-win. This file was the
same as mysql-max-4.0.1, but mysql-4.0.2-alpha-win (without -max)
works well...


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-
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
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.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, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Problem downloading MySQL4.0.2a for windows

2002-07-22 Thread Tam, Michael 


Hi all,

I have difficulties obtaining the MySQL4.0.2a.  It seems that numerous
downloads
links point to the files stated as 4.0.2 zip file but during the setup , it
was 4.0.1a
instead.  Where can I obtain the 4.0.2a ?   Many thanks.

Best regards,
Michael


--
Michael Tam - NFI Database Developer  Natural Resources Canada
[EMAIL PROTECTED] Pacific Forestry Center
Phone: (250) 363-8074  506 West Burnside Road
Fax: (250) 363-0775Victoria, BC  V8Z 1M5


-
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 [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Changing MyISAM to InnoDB

2002-07-15 Thread Tam, Michael 

Alternatives for creating InnoDB tables:

1) When you start mysql, you can pass a parameter to set
default-table-type=InnoDB; Then, when you create tables, InnoDB type table
is the default type, or

2) In order to create InnoDB type table, you need to create the table in the
following way:

CREATE TABLE `my_table` (`field1` TINYINT (3) UNSIGNED DEFAULT '0')  TYPE =
InnoDB;


To change between table types:

ALTER TABLE my_table TYPE = target_table_type;

Hope this help.

Best regards,
Michael

-Original Message-
From: Otoniel Cantu` [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 10:18 AM
To: [EMAIL PROTECTED]
Subject: Changing MyISAM to InnoDB


For the life of me I can not figure out why I can not create or change
my tables from MyISAM to InnoDB. 

I create the table with InnoDB and MySQL creates the table as MyISAM.

I am using MySQL-max-nt. Any ideas how I can change the tables or even
create them as InnoDB for that matter?

Thanks in advanced.


-
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
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.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, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Problem using JDBC to obtain metadata

2002-07-15 Thread Tam, Michael 

Hi all,

I tried to use mm.mysql (2.0.14) to access the tables in mysql
(3.23.51).  I can't retrieve metadata like tables' comment through the
following code:

// get connection
conn=ds.getConnection();

// get metadata
dbmd=conn.getMetaData();

//get resultset for all tables metadata
rs = dbmd.getTables(null,null,%,null);

//print out the info through a jsp
while (rs.next()){
out.println(rs.getString(TABLE_NAME) +  -  +
rs.getString(REMARKS));
}

RESULTS:

tablename_1 -
tablename_2 -
tablename_3 -
tablename_4 -


Would someone kindly show me if there is anything I did wrong in the code
or show me the right way to obtain tables' comment through JDBC?  Greatly
appreciated.

Best regards,
Michael

---
Michael Tam - NFI Database Developer   Natural
Resources Canada
[EMAIL PROTECTED] Pacific Forestry
Center
Phone: (250) 383-8074   506 West Burnside
Road
Fax: (250) 363-0775 Victoria, BC
V8Z 1M5




-
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 [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Problem using JDBC to obtain metadata

2002-07-15 Thread Tam, Michael 

Hi Mark,

   Thank you for your speedy response.  I'd appreciate if you can put this
feature the request list.  Many thanks.

   By the way, is there a way I can access this metadata through sql ??

Best regards,
Michael

-Original Message-
From: Mark Matthews [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 2:14 PM
To: Tam, Michael
Cc: '[EMAIL PROTECTED]'
Subject: Re: Problem using JDBC to obtain metadata


-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Tam, Michael wrote:
| Hi all,
|
| I tried to use mm.mysql (2.0.14) to access the tables in mysql
| (3.23.51).  I can't retrieve metadata like tables' comment through the
| following code:
|
| // get connection
| conn=ds.getConnection();
|
| // get metadata
| dbmd=conn.getMetaData();
|
| //get resultset for all tables metadata
| rs = dbmd.getTables(null,null,%,null);
|
| //print out the info through a jsp
| while (rs.next()){
|   out.println(rs.getString(TABLE_NAME) +  -  +
| rs.getString(REMARKS));
| }
|
| RESULTS:
|
| tablename_1 -
| tablename_2 -
| tablename_3 -
| tablename_4 -
| 
|
| Would someone kindly show me if there is anything I did wrong in the code
| or show me the right way to obtain tables' comment through JDBC?  Greatly
| appreciated.
|
| Best regards,
| Michael
|
- 

| ---
| Michael Tam - NFI Database Developer   Natural
| Resources Canada
| [EMAIL PROTECTED]   Pacific Forestry
| Center
| Phone: (250) 383-8074 506 West
Burnside
| Road
| Fax: (250) 363-0775   Victoria, BC
| V8Z 1M5
|
|
|
|
| -
| 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
[EMAIL PROTECTED]
| Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
|

JDBC doesn't retrieve the remarks, so you can't get to them. I'll add it
into my features-request list, or if you'd like it to be tracked, add it
to feature-requests at the sourceforge site
(http://sourceforge.net/projects/mmmysql/)

-Mark
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6-2 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE9MzsSlyjUJM+7nP4RAq/VAKCMK2o0FF7ajiVZ/s9MlQe4MYVdHwCfZsJt
jIFjiF+N5BHEIBDqIwfFqco=
=BI8w
-END PGP SIGNATURE-

-
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 [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Changing MyISAM to InnoDB

2002-07-15 Thread Tam, Michael 

Hi Otoniel,

   I am running w2k as well.  Check if your mysql startup properly.  One
thing you may want to check is whether you have specify the log_dir and
data_dir for Innodb in your my.ini file, and that you've made those dirs in
the file system.
   
   Hope this help.

Cheers,
Michael

-Original Message-
From: Otoniel Cantu` [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 2:23 PM
To: 'Tam, Michael'
Subject: RE: Changing MyISAM to InnoDB


Hi Michael,

I tried creating the table as you described below and same thing
happened. MySQL makes it into a MyISAM table. I also tried to alter the
table as per your directions and nothing. 

Am I missing something? I am running w2k.

-Original Message-
From: Tam, Michael [mailto:[EMAIL PROTECTED]] 
Sent: Monday, July 15, 2002 11:47 AM
To: 'Otoniel Cantu`'; [EMAIL PROTECTED]
Subject: RE: Changing MyISAM to InnoDB

Alternatives for creating InnoDB tables:

1) When you start mysql, you can pass a parameter to set
default-table-type=InnoDB; Then, when you create tables, InnoDB type
table
is the default type, or

2) In order to create InnoDB type table, you need to create the table in
the
following way:

CREATE TABLE `my_table` (`field1` TINYINT (3) UNSIGNED DEFAULT '0')
TYPE =
InnoDB;


To change between table types:

ALTER TABLE my_table TYPE = target_table_type;

Hope this help.

Best regards,
Michael

-Original Message-
From: Otoniel Cantu` [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 10:18 AM
To: [EMAIL PROTECTED]
Subject: Changing MyISAM to InnoDB


For the life of me I can not figure out why I can not create or change
my tables from MyISAM to InnoDB. 

I create the table with InnoDB and MySQL creates the table as MyISAM.

I am using MySQL-max-nt. Any ideas how I can change the tables or even
create them as InnoDB for that matter?

Thanks in advanced.


-
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
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.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, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.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, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

COMMENT For tables

2002-07-09 Thread Tam, Michael 

Hi all,

I would like to confirm that MySQL only allows putting COMMENT in TABLE
LEVEL but not in COLUMN LEVEL.  Am I right?

Regards,
Michael


---
Michael Tam - NFI Database Developer   Natural
Resources Canada
[EMAIL PROTECTED] Pacific Forestry
Center
Phone: (250) 383-8074   506 West Burnside
Road
Fax: (250) 363-0775 Victoria, BC
V8Z 1M5




-
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 [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php