Re: Direct connection to mysql database

2004-11-22 Thread alice
> You can use one DSN, and then use the SQL command "USE databasename" to > switch to other databases on the same server (if you have the right). > > "alice" <[EMAIL PROTECTED]> wrote in message > news:<[EMAIL PROTECTED]>... > Hi, all > > I

Direct connection to mysql database

2004-11-22 Thread alice
database.   is there anyway to do that ?   Thanks.   Regards, Alice /---\ Confidential and/ or privileged information may be contained in this e-mail and any attachments transmitted with it ('Message'). If you are not the

newbie question: subareas

2004-08-17 Thread Alice
Just been using mysql for a couple of days, so this is possibly old ground, but i have searched and can't find any solution. i'm sure it must have come up before. The project is to allow resources to be shared amongst community groups throughout uk. there are a number of attributes that can be se

Error encountered when Connect remotely in mySQL 4.0.15

2003-10-21 Thread Alice Tan
db access.   regards, alice /---\ Confidential and/ or privileged information may be contained in this e-mail and any attachments transmitted with it ('Message'). If you are not the addressee indicated in this Message

Need some explainations on mysql.err

2003-03-23 Thread Alice Tan
sp, line 24   and i found a lot of unusual entries in mysql.err, Can anybody tell me what's problem may causing the following abort in connection ?     030315  0:43:05  Aborted connection 2 to db: 'unconnected' user: 'ODBC' host: `localhost' (Unknown error) 030319

stuck with converting a query from a sub query

2003-02-18 Thread Alice Farbles
in ( SELECT portlet_fk FROM UserTabAssignment WHERE user_fk = 'guest' AND portal_FK = 'mysqlPortal' AND tabNumber = 0 AND subtabName = 'firstSubtab') thanks Alice Farbles - Bef

Re: MySQL secure access

2002-11-28 Thread Alice Tan
tomer. customer only access their own database only. - Original Message - From: "Pae Choi" <[EMAIL PROTECTED]> To: "Alice Tan" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]> Sent: Thursday, November 28, 2002 8:33 PM Subject: Re: MySQL secure

Re: MySQL secure access

2002-11-27 Thread Alice Tan
ase. can u specify more detail on that ?? - Original Message - From: "Bhavin Vyas" <[EMAIL PROTECTED]> To: "Alice Tan" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]> Sent: Thursday, November 28, 2002 12:07 PM Subject: Re: MySQL secure acc

MySQL secure access

2002-11-27 Thread Alice Tan
sting server. But our customer requested to have their own access on their databases, which i don't want them to see those databases that not belongs to them. Can i do that ? Thanx in advance for anyhelp. rega

MySQL Installation

2002-11-19 Thread Alice Tan
Hi, i am doing a setup program that eventually install mySQL, myODBC, and my system. during my system installation, it require mySQL is installed and already run the WinMySQLAdmin.exe, where by from there i will be able to do some record insertion on the db. but now, since for the first time we ru

Re: how to shut down the mySQL service ?

2002-11-07 Thread Alice Tan
> To: <[EMAIL PROTECTED]> Sent: Friday, November 08, 2002 11:15 AM Subject: Re: how to shut down the mySQL service ? > Pada Fri, 8 Nov 2002 11:16:16 +0800 > "Alice Tan" <[EMAIL PROTECTED]> menulis: > > > Hi, i got the stop mysqladmin service don

how to shut down the mySQL service ?

2002-11-07 Thread Alice Tan
nal Message - > From: "Amish K. Munshi" <[EMAIL PROTECTED]> > To: "Alice Tan" <[EMAIL PROTECTED]> > Sent: Monday, October 28, 2002 3:57 PM > Subject: Re: how to stop the mySQL service ? > > > > On Monday 28 October 2002 01:26 pm, you wrote:

Re: how to stop the mySQL service ?

2002-10-27 Thread Alice Tan
IL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, October 28, 2002 2:32 PM Subject: Re: how to stop the mySQL service ? > > "mysqladmin shutdown" > > On Mon, 28 Oct 2002, Alice Tan wrote: > > > > > > > How to stop the mySQL service instead of

how to stop the mySQL service ?

2002-10-27 Thread Alice Tan
How to stop the mySQL service instead of right click the traffic light and stop it ? is there any exe can stop the mySQL service ? i tried the mySQLShutDown.exe, but it didn't actually stop the service. i want to stop the mySQL service so that the mysqld-nt.exe wouldn't hold my database, which th

Using Install shield, how to do ODBC DSN setting ?

2002-10-01 Thread Alice Tan
programs/script to make it work ? hope can get reply ASAP. thanx regards, alice /---\ Confidential and/ or privileged information may be contained in this e-mail and any attachments transmitted with it ('Message'

Is mySQL support replication ??

2002-06-24 Thread Alice
Hi, all, May i know is mySQL support replication regards, alice /---\ Confidential and/ or privileged information may be contained in this e-mail and any attachments transmitted with it ('Message'

Commit Trans

2001-06-18 Thread Alice
I want to used the begin trans and commit trans in my ASP program on top of mysql db. do anyone know how to do that ? thanx   /---\ Confidential and/ or privileged information may be contained in this e-mail and any attac

Re: RE: mysqldump

2001-06-05 Thread Alice Tan
ello > >It's simple, if you installed mysql in folder c:\mysql just type this string in >command promt (or START->RUN): > >c:\mysql\bin\mysqldump samp_db > c:\archieves.mysql > > -Original Message- > From: Alice [mailto:[EMAIL PROTECTED]] &g

backup database

2001-06-05 Thread Alice
Hi, besides using mysqldump, can i just copy the database in the data directory straight  away in windows explorer ?? is this a correct way to do that ?? thanx /---\ Confidential and/ or privileged information may be co

mysqldump

2001-06-05 Thread Alice
i saw % myswldump samp_db > /usr/archieves.mysql.samp_db.1999-10-02 syntax in the Paul Dubois mySQL book, but this is command for unix, how abt windows syntax ?? /---\ Confidential and/ or privileged information may be

mysqlhotcopy ..

2001-06-05 Thread Alice Tan
but i still got no idea how to run mysqlhotcopy ? run in where ? how ? Original Message- >On Fri, Jun 01, 2001 at 03:35:57PM +0800, Alice wrote: > >> i have no idea on how to run mysqlhotcopy in the query tool or it is >> not suppose to run in qu

mysqlhotcopy ..

2001-06-01 Thread Alice
i have no idea on how to run mysqlhotcopy in the query tool or it is not suppose to run in query tool. is this correct ? mysqlhotcopy db_name '/downloads/backupDB/'   if i want it to backup in my c:\downloads\backupDB folder ?? /---

Re: password assign for localhost

2001-05-31 Thread Alice
ahh .. help, after i follow what u said, and do the update in my password then flush privileges, now i can't even access my database with the password .. . so, how now ??? - Original Message - From: "David Lidström" <[EMAIL PROTECTED]> To: "Alice" <[EMA

password assign for localhost

2001-05-31 Thread Alice
at the moment, i am still connect to local host without a password. i did try to using query to update the MySQL db and update the user table on it for the user where it is 'root' my asp prog did connected to my db which have the connection string that the password is blank. but with the conn

how to convert my sql server data into mysql ??

2001-05-28 Thread Alice
i would like to convert my sql server data into mysql, how can i do ?? /---\ Confidential and/ or privileged information may be contained in this e-mail and any attachments transmitted with it ('Message'). If you are not

MySQL front end tool

2001-05-24 Thread Alice
Hi, i am a win2k professional user, and i would like to get a mySQL front end tools which can make mySQL to be work more user friendly. currently i am using MySQL-Front, for those who had tried out others this kind of tools, pls recommend any others tools that u think is more powerful, ef

help .. db connection to asp prog !

2001-05-23 Thread Alice Tan
hi .. i am a new user to mysql, i did install myODBC, but fail to create the db connection in the ODBC ... why it fail ??? /---\ Confidential and/ or privileged information may be contained in this e-mail and any attachments

help ... db connection to asp prog !

2001-05-23 Thread Alice
hi .. i am a new user to mysql, i did install myODBC, but fail to create the db connection in the ODBC ... why it fail ???   /---\ Confidential and/ or privileged information may be contained in this e-mail and any attach

how to creat stored procedure ??

2001-05-23 Thread Alice
Hi, i am a new user of mySQL, however i have experience in MSSQL server. i have difficulties on creating stored procedure, triggers and views in mySQL.  /---\ Confidential and/ or privileged information may be contained

Problem

2001-03-08 Thread ALICE CHIAPPETTA
I have downloaded the stable release for Solaris. Everytime I try to gunzip and tar it. Everything works till the end then I get a checksum error. It never creaed the var directory in the mysql directory. Could this be the problem. I have even try to download the software from the Wisconsin mi