quick question on mysql memory usage

2009-03-12 Thread Jenny Chen
Hi,

My understanding is that the memory utilization of mysql can be calculated
roughly using the formula like:
(All global memory related server variables + max_connections * session
memory related server variables)
As I noticed that most global variables like key_buffer_size,
innodb_buffer_szie will not return back the memory to OS since they are
using (mt)malloc/free, My question is: will mysql return the memory to the
OS after closing some connections? Such as, when one connection executing a
query which located sort buffer, and created tempory table, after complete
the query or close the query, will the memory used by this query release to
OS?
Thanks in advance for your info.

Regards,
jenny


question on mysql proxy's load balancing

2008-08-29 Thread Jenny Chen
Hi,

When I read Jk's document on MySQL proxy:
http://jan.kneschke.de/projects/mysql/mysql-proxy/

In Load balancing part, he mentioned that:
We use SQF (shortest queue first) to distribute the load across the
backends equally. Each backend will get the same number of connections.

My understanding is that if there are 100 concurrent client connecting to
the myql proxy with two backend mysql server(master and slave), the mysql
proxy will send 50 connections to the master server, and the other 50
connections to the slave server, is my understanding correct?
But I did observed very different in the simple mysqlslap test:
mysqlslap -hproxy-host -P4040 -q ./simple.sql -c 100 -i
( ./mysql-proxy  --proxy-backend-addresses=master-host:3306
--proxy-backend-addresses=slave-host:3306)

on the master server, from the processlist, I saw Threads-creates arround
166, but threads running/connected only 12; on the slave server,
Threads-creates arround 166, but threads running/connected only 1. Does
anyone can please explain why this happening?
(And the mysqlslap test result was very poor compared to the same test
without mysql proxy and connecting to only one mysql server instance.)

Thanks in advance for your information.


quick question on innodb_log_file_size

2008-08-20 Thread Jenny Chen
Hi,

According to the reference manual, it was said that the combined lnnodb log
file size is less than 4G on 32-bit system. But I'm running on my 64-bit
solaris, I still got the error complaining the innodb log file 4G for my
64-bit MySQL. So I'm wondering is this 4G limit apply on 64-bit system as
well? Why?

Thanks in advance for your information.


Jenny


best practice MySQl backup onto tape

2007-12-14 Thread Jenny Chen
Hi,

I'm planing to do hot backup MySQL(innodb db) onto tape drive, and propose
the following solution/script:

   # delete old mysql dumps
 rm -r -r /backup/mysql
 mkdir /backup/mysql

   # Dump all mysql databases
 mysqldump --all-databases -single-transaction --flush-logs 
all_databases.sql
 mysqldump --database=mysql --lock-all-tables --flush-logs  system.sql

   # Do backup
  tar cvf /dev/rmt/0 /backup/mysql

My question is: is there any other better solutions(including commercial
solutions) to do hot MySQL backup to tape that can provide better
performance, or can backup directly to the tape(no need to dump to disk
first), etc. comparing to use mysqldump.

Thanks in advance for your information, or comment on the above solution.


Regards,
Jenny


Re: best practice MySQl backup onto tape

2007-12-14 Thread Jenny Chen
Hi, Keith,

In my case, it is just single MySQL server(no replication).
Thanks for your info, I'll check with mk-parallel-dump tools, since
the speed of backup is important considering the database is locked for the
duration of the backup.


Regards,
Jenny


On 12/14/07, B. Keith Murphy [EMAIL PROTECTED] wrote:

 Jenny Chen wrote:
  Hi,
 
  I'm planing to do hot backup MySQL(innodb db) onto tape drive, and
 propose
  the following solution/script:
 
 # delete old mysql dumps
   rm -r -r /backup/mysql
   mkdir /backup/mysql
 
 # Dump all mysql databases
   mysqldump --all-databases -single-transaction --flush-logs 
  all_databases.sql
   mysqldump --database=mysql --lock-all-tables --flush-logs 
 system.sql
 
 # Do backup
tar cvf /dev/rmt/0 /backup/mysql
 
  My question is: is there any other better solutions(including commercial
  solutions) to do hot MySQL backup to tape that can provide better
  performance, or can backup directly to the tape(no need to dump to disk
  first), etc. comparing to use mysqldump.
 
  Thanks in advance for your information, or comment on the above
 solution.
 
 
  Regards,
  Jenny
 
 
 You didn't specify if this was a master or slave.  I certainly wouldn't
 dump off a master server.  It will lock the database for the duration of
 the backup.  One of the ways we do backups is to do an lvmsnapshot of
 the data partition on the slave and then just mount and rsync the
 snaphsot of the data off to the backup server.  Inefficient for space,
 but would be vastly faster restoring a backup like this then running a
 restore from a mysldump.  You will still need to tar this take it
 acceptable for tape.

 Another option would be to replace mysqldump with Baron Schwartz's
 mk-parallel-dump and mk-parallel-restore tools.  They are faster than a
 traditional dump/restore and are much more compact.  These tools (and a
 number of others) are located at maatkit.sourceforge.net.net.

 Hope that helps.

 Keith

 --
 B. Keith Murphy

 Paragon Consulting Services
 http://www.paragon-cs.com
 850-637-3877




Question on mysql-test-run sp failed

2006-07-14 Thread Jenny Chen

Hi,

Recently, I built mysql5.0 on Solaris 10 amd64, but when running make
test, the bundled sp test failed
with the following error:

mysqltest: At line 1527: query 'call fib(20)' failed: 1436: Thread stack
overrun:  186944 bytes used of a 262144 byte stack, and 81920 bytes
needed.  Use 'mysqld -O thread_stack=#' to specify a bigger stack.
(the last lines may be the most important ones)

Looking at the test source code, I saw the following lines:

# Enable recursion
set @@max_sp_recursion_depth= 20|

# Minimum test: recursion of 3 levels

insert into fib values (0), (1)|

call fib(3)|

select * from fib order by f asc|

delete from fib|

# Original test: 20 levels (may run into memory limits!)

insert into fib values (0), (1)|

call fib(20)|

When calling a recursive procedure many times with a limited stack, it's
quite possible to overrun the stack, and looks like that authors of the
test wanted to note exactly this - could you please let me know if my
understanding is correct, and let me know how to increase the stack
limit for the mysqld process?

Thanks much for your information in advance.



Regards,
Jenny


how to start mysql instanct manager on Solaris platform?

2006-03-27 Thread Jenny Chen
Hi,

I'm trying to start mysql with mysql IM, by following the steps as bellow:

1. change the use_mysqld_safe = 0 in the mysql.server

2.set /etc/my.cnf as:
[client]
#password   = your_password
port= 3306
socket  = /tmp/mysql.sock

# Here follows entries for some specific programs
[manager]
default-mysqld-path = /usr/local/mysql/bin/mysqld
socket=/tmp/manager.sock
pid-file=/tmp/manager.pid
monitoring-interval = 2
port = 1999
bind-address = 209.128.126.155

# The MySQL server
[mysqld]
mysqld-path=/usr/local/mysql5018_mmap_2/bin/mysqld
socket=/tmp/mysql.sock
port=3307
server_id=1
skip-stack-trace
core-file
skip-bdb
log-bin
log-error
log=mylog
log-slow-queries

[mysqld2]
port=3308
server_id=2
mysqld-path= /tests/jc_data/mysql-
standard-5.0.15-solaris10-x86_64/bin/mysqld
socket = /tmp/mysql.sock5
pid-file   = /tmp/hostname.pid5
datadir= /tests/jc_data/mysql-standard-5.0.15-solaris10-x86_64/data
log-bin
log=/tmp/fordel.log

3. Then I start mysql by running
   mysql.server start
4. I noticed that a few problems:
   a. only the first mysqld(under
/usr/local/mysql5018_mmap_2/bin/mysqld)started,
the mysqld2 didn't start

5. If I run the client from
  /usr/local/mysql/bin/mysql
  mysql show instances
 It complained wrong sysntax,that make me believe that commands for MySQL IM
accepts are not available for some reason.

Is there anything wrong with my above steps causing the problems?
Thanks in advance for your information!


Jenny


How to port Oracle anonymous PL/SQL block to MySQL

2006-01-02 Thread Jenny Chen
Hi,

As I know that MySQL supports stored procedure from 5.0. Does anyone have
the info on if there is any plan to support anonymous PL/SQL block in MySQL
in later MySQL version? So that when port Oracle anonymous PL/SQL block, it
doesn't need to change to procedure/function?



Thanks,
Jenny


MySQL slow query log

2005-12-19 Thread Jenny Chen
Hi,

Could anyone explain what might be the possible reasons that in the slow
query log(running read-only queries) the most very slow queries(taking
200-300sec) were the queries:

1. create table ... type = MyISAM
2. show slave status


Thanks,
Jenny


can't connect to the MySQL server from remote machine?

2005-12-02 Thread Jenny Chen
Hi,

I'm trying to connect to the MySQL server on the RedHat AS 4 from a remote
Solaris SPARC box. When I run the command:

mysql -h HOSTNAME

I got the error as

ERROR 2003 (HY000): Can't connect to MySQL server on 'HOSTNAME' (145)



Could anyone please explain what the mean of the error message and how to
solve it?





Thanks,

Jenny


Re: can't connect to the MySQL server from remote machine?

2005-12-02 Thread Jenny Chen
Yes, I did try both hostname and IP, but can't work although I can ping to
the two boxes from each other.
Just wondering if it is because of the port(3306) got disabled??


Thanks,
Jenny




On 12/2/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:



 Jenny Chen [EMAIL PROTECTED] wrote on 12/02/2005 12:27:33 PM:

  Hi,
 
  I'm trying to connect to the MySQL server on the RedHat AS 4 from a
 remote
  Solaris SPARC box. When I run the command:
 
  mysql -h HOSTNAME
 
  I got the error as
 
  ERROR 2003 (HY000): Can't connect to MySQL server on 'HOSTNAME' (145)
 
 
 
  Could anyone please explain what the mean of the error message and how
 to
  solve it?
 
 
 
 
 
  Thanks,
 
  Jenny

 The value after the -h must either be a valid hostname in your
 organization or an IP address. If you can ping the server you want to
 reach by name, that's the name to use. Otherwize use the IP address of the
 machine you are trying to reach.

 Shawn Green
 Database Administrator
 Unimin Corporation - Spruce Pine


Re: can't connect to the MySQL server from remote machine?

2005-12-02 Thread Jenny Chen
Hi,

I tried with
telnet localhost 3306
locally, and got the message as:

Connected to localhost.localdomain (127.0.0.1).
Escape character is '^]'.
=
5.0.16-standard!QS//?.e,7~9iw;]E!r=Connection closed by foreign host.

What is this meaning?

Thanks,
Jenny

On 12/2/05, Fernando Antunes [EMAIL PROTECTED] wrote:

 To test if the 3306 is listening, try this command from client :

 telnet hostname 3306

 If MySQL return some string, it´s there and listening
 If not, two possibilities :

   1) A firewall between or on client and server
   2) MYSQL is stopped or listening in a different port.

 What is the version of your MYSQL ?


 On 12/2/05, Jenny Chen [EMAIL PROTECTED] wrote:
 
  Yes, I did try both hostname and IP, but can't work although I can ping
  to
  the two boxes from each other.
  Just wondering if it is because of the port(3306) got disabled??
 
 
  Thanks,
  Jenny
 
 
 
 
  On 12/2/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
  
  
  
   Jenny Chen  [EMAIL PROTECTED] wrote on 12/02/2005 12:27:33 PM:
  
Hi,
   
I'm trying to connect to the MySQL server on the RedHat AS 4 from a
   remote
Solaris SPARC box. When I run the command:
   
mysql -h HOSTNAME
   
I got the error as
   
ERROR 2003 (HY000): Can't connect to MySQL server on 'HOSTNAME'
  (145)
   
   
   
Could anyone please explain what the mean of the error message and
  how
   to
solve it?
   
   
   
   
   
Thanks,
   
Jenny
  
   The value after the -h must either be a valid hostname in your
   organization or an IP address. If you can ping the server you want
  to
   reach by name, that's the name to use. Otherwize use the IP address of
  the
   machine you are trying to reach.
  
   Shawn Green
   Database Administrator
   Unimin Corporation - Spruce Pine
 
 



any alias for MySQL cluster question?

2005-11-18 Thread Jenny Chen
Hi,
 I'd ask some questions on MySQL cluster. Does anyone know if there is any
email alias for the cluster questions?
  Thanks,
Jenny


A few questions about triggers in MySQL 5

2005-11-16 Thread Jenny Chen
Hi,

Does the current latest MySQL 5.0 support:
1. column based triggers
2. trigger restriction
3. multiple triggers of same type of the table
4. triggers reference another table

And any information on in which release they will be supported?


Thanks,
Jenny


rename database

2004-04-16 Thread Chen, Jenny
Experts:

Is it possible to rename existing database ?

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



RE: rename database

2004-04-16 Thread Chen, Jenny
Thanks that's easy.

-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 16, 2004 10:28 AM
To: 'Chen, Jenny '; ''[EMAIL PROTECTED]' '
Subject: RE: rename database

You can rename it at the filesystem level.

-Original Message-
From: Chen, Jenny
To: '[EMAIL PROTECTED]'
Sent: 4/16/04 10:18 AM
Subject: rename database

Experts:

Is it possible to rename existing database ?

-- 
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]



InnoDB

2004-04-15 Thread Chen, Jenny
MySQL Experts:

I am new for MySQL database.  
We have a 4.0.18 MySQL sit on Linux box.

I am reading on InnoDB. And having a question.

How do I know the table is configured by InnoDB instead of normal table ?
Should I at least see some entry in the /etc/my.cnf to indicate that InnoDB
is configured?

Thanks in advance.
Jenny




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



How to get timestamp of inserted record

2002-07-30 Thread Jenny Christy

Hello all,

suppose I have added one field time_stamp of type
timestamp in any existing table. it will show the
current timestamp of all records. If i update any
record after sometime It will also update the
timestamp of updated record with current timestamp.

but for insertion of any record...what i have to
do...i have to mention the current timestamp value
with values of all fields of a record or is there any
way to insert new record so that it will automatically
take current timestamp for that record.

Plz specify the sql query also, if u know right now. 

Thx in advance.
Rgds,
Jenny

__
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.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




Is type of datetime timestamp same??

2002-07-24 Thread Jenny Christy

Hello All,
I m using mysql 3.23.42 and myodbc 3.51 on linux7.2.
I use SQLDescribeCol API to get type of column(field).
When i call above functuon it returns type of datetime
and timestamp is 93 for both. but the format of
inserting datetime value uses (   )and timesstamp
value is different. 
I m having a problem how can I distinguish them so
that I can insert the data in correct format.or is
there any bug in myodbc driver.
Thanx in advance for ur kind help.

Rgds,
Jenny


__
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.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




Is type of datetime timestamp same??

2002-07-24 Thread Jenny Christy

Hello All,
I m using mysql 3.23.42 and myodbc 3.51 on linux7.2.
I use SQLDescribeCol API to get type of column(field).
When i call above functuon it returns type of datetime
and timestamp is 93 for both. but the format of
inserting using sql query, datetime value uses (  
)and timesstamp value is different. 
I m having a problem how can I distinguish them so
that I can insert the data in correct format.or is
there any bug in myodbc driver.
Thanx in advance for ur kind help.

Rgds,
Jenny


__
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.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




Error Codes

2002-07-17 Thread Jenny Christy


 Hello All,
 
 I m using mysql server and myodbc driver in  linux.
 
 I wud like to print the correct error message if any
 error occur while we r communicating with server eg.
 access denied, connection failure, no data is
 available , table does not exits, duplicate data
 etc.
 
 How can i see the return error code value and which
 file contains all these error codes??
 
 I m using function SQLGetDiagRec() to see the error
 messages, Can i use the same for error code?
 
 Thx in advance,
 Rgds,
 Jenny


__
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://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




Error Codes

2002-07-16 Thread Jenny Christy

Hello All,

I m using linux with mysql server.

I wud like to print the correct error message if any
error occur while we r communicating with server eg.
access denied, connection failure, no data is
available , table does not exits, duplicate data etc.

How can i see the return error code value and which
file contains all these error codes??

I m using function SQLGetDiagRec() to see the error
messages, Can i use the same for error code?

Thx in advance,
Rgds,
Jenny



__
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://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




How can I make and execute .sql file

2002-07-15 Thread Jenny Christy

Hello All,

Can anybody tell me the query or procedure by which i
can generate the .sql file. So that I dont need to
write the query again and again on prompt. 

Just by executing the .sql file(or script language), I
will able to create table, insert the data on table,
update the data..means whatever operation i need i can
write on it.

Plz help me to make it.

Rgds,
jenny


__
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://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




Segmentation Fault

2002-07-11 Thread Jenny Christy

Hello All,

I m using linux and gcc complier.

Myodbc driver and itz APIs working fine in my
application to manipulate the database.

I m having one problem.

First i run query Select id...from ...
then I use SQLBindCol to bind the columns after that i
use SQLFetch to fetch the rowset.
then i use SQLFreeStmt with SQL_UNBIND and SQL_CLOSE
one by one.
at the time of disconnect i use SQLFreeStmt with
SQL_DROP. 
all the fuction in this sequence does work. but when i
use query Select * from 
It does not work and gives Segmentation fault in the
function SQLFreeStmt with SQL_CLOSE, if i comment
this, it gives with SQLFreeStmt with SQL_DROP

I m unable to catch the cause, can anyone help me to
come out this problem.

Thanx in advance.
Rgds,
Jenny


__
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.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




Sql Query

2002-07-09 Thread Jenny Christy

Hello all,

I wud like to know one query by which i can
copy/create the same table from existing table.

Rgds,
Jenny

__
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.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




what is the limit for max_packet_size?

2002-01-14 Thread Jenny

Hai, All,

Finally i able to retrive image from MYSQL database via VB6.0. However, i can only 
retrieve image where the size is greate than 17kb and less then 32KB.

I have try to increate my max_packet_size to 128KB, but i still retrive null 
value. Another thing i feel queries is, you the small file size also can't??? Is 
somebody know face this problem b4?

Thank very much.

  
Jenny Ko
System Engineer

INFOPRO SDN BHD
The Total Banking Solution Provider



Re: what is the limit for max_packet_size?

2002-01-14 Thread Jenny

Hai,

I am using longblob for my datatype. Maybe just forget about the big
file size. But how about the small file size? As the smallest file i can
save is 17KB. Through the MYSQL-front, i able to view my picture and confirm
that the picture already been save. Just yet don't know y even the small
file size also can't.

Thanks



- Original Message -
From: Carsten Gehling [EMAIL PROTECTED]
To: Jenny [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, January 15, 2002 1:23 PM
Subject: Re: what is the limit for max_packet_size?


 - Original Message -
 From: Jenny [EMAIL PROTECTED]
 Sent: Tuesday, January 15, 2002 5:14 AM


  Finally i able to retrive image from MYSQL database via VB6.0.
 However, i can only retrieve image where the size is greate than 17kb and
 less then 32KB.
 
  I have try to increate my max_packet_size to 128KB, but i still
 retrive null value. Another thing i feel queries is, you the small file
size
 also can't??? Is somebody know face this problem b4?

 AFAIK there's no limit on MAX_PACKET_SIZE.

 What kind of field type do you use? The BLOB field can only contain 2^16 -
1
 bytes. Maybe you should use a LONGBLOB (2^32 - 1 bytes)

 - Carsten





-
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




How to retrieve image from MySQL

2002-01-11 Thread Jenny

Hai,

I am doing sthing about store the image inside the mysql database using blob 
datatype, programm be Visual Basic 6.0. It is fine when i store it image in, however i 
unable to retieve the image. I have test my program in Ms Access and it work fine.

Another thing i found that if we want to insert binary data into a BLOB 
column, some special characters must be represented by escape sequences, is it any 
function available in VB? Is any one know what forum is discuss about VB and MySQL?

Thanks   


Regards,
Jenny



RE: Installation problem.

2001-01-12 Thread Jenny Lie

Hi, Thanks!
I did log in as Administrator.
I'm running Windows NT Server 4.0



Jenny Lie
Web Developer
Onramp Network Services Inc.
200 Town Centre Blvd, #302
Markham, ON L3R 8G5
(905) 470-4064 EXT 241
E-mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
http://www.onramp.ca




-Original Message-
From: Miguel Angel Solrzano [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 12, 2001 2:31 PM
To: Jenny Lie; Miguel Angel Solrzano
Cc: MySql Mailing List
Subject: RE: Installation problem.


At 09:08 12/01/2001 -0500, Jenny Lie wrote:
Hi!

I forget to say you in the last mails that you need to do
the login in the NT/W2k machine as Administrator privilege
or with an user which has the privilege to install services
in the machine.

Regards,
Miguel


I did reboot the machine and it still can't do mysqld-nt --install.

Anything I should do?  The first step, I did run setup.exe, then in
c:\mysql\bin, I ran mysqld-nt --install, was that right?

Thanks for your time.



Jenny Lie
Web Developer
Onramp Network Services Inc.
200 Town Centre Blvd, #302
Markham, ON L3R 8G5
(905) 470-4064 EXT 241
E-mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
http://www.onramp.ca




-Original Message-
From: Miguel Angel Solrzano [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 11, 2001 10:24 PM
To: Jenny Lie; [EMAIL PROTECTED]
Subject: Re: Installation problem.


At 16:19 11/01/2001 -0500, Jenny Lie wrote:
Hi!

That isn't a bug. This message is launched when:

- The service is already installed.

- The Service Control Manager is in bad state.

When you see this error message, reboot the machine.
Take a look if the service was started.
Take a look if the service exists.
If exist and doesn't was started, remove it: mysqld-nt --remove
Install the service: mysqld-nt --install.
Start the service: net start mysql

Regards,
Miguel






 Hi, I got a problem when I did this:
 
 msqld-nt --install
 
 it gave me an error message:
 Failed to install service.
 
 What's the problem exactly?
 
 Thanks for you time and help.
 
 
 
 Jenny Lie
 Web Developer
 Onramp Network Services Inc.
 200 Town Centre Blvd, #302
 Markham, ON L3R 8G5
 (905) 470-4064 EXT 241
 E-mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
 http://www.onramp.ca
 
 
 
 
 -
 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 bugs-unsubscribe-#L=#[EMAIL PROTECTED]

 __  ___   __
/  |/  /_ __/ __/ __ \/ /   http://www.mysql.com/
   / /|_/ / // /\ \/ /_/ / /__  Miguel Solrzano [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/  So Paulo, Brazil
 ___/  Development Team



-
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

__  ___   __
   /  |/  /_ __/ __/ __ \/ /   http://www.mysql.com/
  / /|_/ / // /\ \/ /_/ / /__  Miguel Solrzano [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/  So Paulo, Brazil
___/  Development Team


-
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