RE: Can MySQL handle 120 million records?

2002-12-18 Thread RBRoa 
I am proud to be a MySQL solid rock database engine user, I used it as my
backend data holder in any form. From traffic analysis to subscriber
administration. I never experienced downtime due to bug ever since. So if ur
planning to use the open source as your billing handler. U better make use
of your brain to think and decide which is handy to you. And if your
convinced about the solidity of this engine then, I think your better to
mail everything to other side.



R R--

-
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 Delphi 6

2002-11-20 Thread RBRoa 
In my situation I used Delphi 6 and MySQL as a client/server application. I
tried DBX before but it gives me more headache, more on connection
issue...so I decided to switch to WinZeos project as a component in
Delphi...for now I use the component as my basic connector to my server. I
also heard that Delphi 6 needs an update from Borland about the issue, a
patch to improve the DBX component.



R.B.Roa
Traffic Management Engineer
PhilCom Corporation
Tel. No.(Office) (088) 858-1028
(Home) (088) 858-8889
Mobile No. (63) (919-3085267)


-Original Message-
From:   Patricio Díaz G. [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, November 21, 2002 8:10 AM
To: [EMAIL PROTECTED]
Subject:Re: MySQL  Delphi 6

Thanks for anwering to my request.
I started to practice with Delphi and Kylix in my free time, first
with
Kylix, later with Delphi. With Kylix I had no problems to connect to
the
MySQL server, may be becouse I was coding int the same machine where
it is,
but now I'm tring Delphi 6 and I can't connect to it. I'm using the
standart
dbExpress TSQLConnection component, I configure it as the manual
says, but
when I set it's Connected property to True, it says DBX error:
Invalid
Username/Password.

What I want to know is if there is somebody that could make work
Delphi 6
with MySQL in a remote box together, or if somebody knoks certainly
that
Delphi 6 has a bug so it can't connect to a remote MySQL.

Regards,

Patricio


-
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 Delphi 6

2002-11-19 Thread RBRoa 
You can download winzeos for delphi

I use it when connecting to MySQL

Try searching it in google

R.B.Roa
Traffic Management Engineer
PhilCom Corporation
Tel. No.(Office) (088) 858-1028
(Home) (088) 858-8889
Mobile No. (63) (919-3085267)


-Original Message-
From:   Patricio Díaz G. [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, November 20, 2002 1:34 PM
To: [EMAIL PROTECTED]
Subject:MySQL  Delphi 6

Can somebody help me with Delphi 6 and MySQL?
I'm using Delphi en a WinXP box and the MySQL server in a Linux box.
I am
having trouble connecting to the server with the CLX/dbExpress
TSQLConnection component.
Please, if somebody can help me, let me know and I'll explain the
whole
situation.

Regards,

Patricio




-
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 Delphi 6

2002-11-19 Thread RBRoa 
That command is set more secure on the version you use v3.23.53

That's one of the reason why I kept the old version running, which is
v3.23.44

I cant find a way to upgrade to the latest which is giving me headache when
it comes to LOAD DATA statement

I also found out that the LIBMYSQL.DLL used in the latest version is more
secure too...but if you can have the old LIBMYSQL.DLL you can use it.

Check also your statement if followed the correct syntax in loading file

R.B.Roa
Traffic Management Engineer
PhilCom Corporation
Tel. No.(Office) (088) 858-1028
(Home) (088) 858-8889
Mobile No. (63) (919-3085267)


-Original Message-
From:   Weiwei Wang [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, November 20, 2002 1:29 PM
To: [EMAIL PROTECTED]
Subject:Re: MySQL  Delphi 6

hi,
could you tell me how to load a txt into my table?
I use the comand :
mysql LOAD DATA LOCAL INFILE pet.txt INTO TABLE pet;
But it fails,the error information is:
ERROR 1148: The used command is not allowed with this MySQL version
I am using the mySql3.23.53 version.
Doesn't this version support the load function?
BTW,how to transfer the Access database into MySql db?

thanks a lot.
weiwei
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, November 20, 2002 12:07 AM
Subject: RE: MySQL  Delphi 6


You can download winzeos for delphi

I use it when connecting to MySQL

Try searching it in google

R.B.Roa
Traffic Management Engineer
PhilCom Corporation
Tel. No. (Office) (088) 858-1028
(Home) (088) 858-8889
Mobile No. (63) (919-3085267)


-Original Message-
From: Patricio Díaz G. [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, November 20, 2002 1:34 PM
To: [EMAIL PROTECTED]
Subject: MySQL  Delphi 6

Can somebody help me with Delphi 6 and MySQL?
I'm using Delphi en a WinXP box and the MySQL server in a Linux box.
I am
having trouble connecting to the server with the CLX/dbExpress
TSQLConnection component.
Please, if somebody can help me, let me know and I'll explain the
whole
situation.

Regards,

Patricio





-
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 Delphi 6

2002-11-19 Thread RBRoa 
I cant send you for now...it's a big file...cant be possible using email...
But ill try if I can a utility program that slice the file into pieces as
like as 1.44MB disk

Do you have those programs?

R.B.Roa
Traffic Management Engineer
PhilCom Corporation
Tel. No.(Office) (088) 858-1028
(Home) (088) 858-8889
Mobile No. (63) (919-3085267)


-Original Message-
From:   Weiwei Wang [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, November 20, 2002 3:13 PM
To: [EMAIL PROTECTED]
Subject:Re: MySQL  Delphi 6

Hi,R.B.Roa:
thank you so much for your nice reply.
I searched from the mysql.com but there is no
the old mysql3.23.44 exists.?
Can you send me yours?

thanks a million!!!
weiwei

- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, November 20, 2002 12:45 AM
Subject: RE: MySQL  Delphi 6


That command is set more secure on the version you use v3.23.53

That's one of the reason why I kept the old version running, which
is
v3.23.44

I cant find a way to upgrade to the latest which is giving me
headache when
it comes to LOAD DATA statement

I also found out that the LIBMYSQL.DLL used in the latest version is
more
secure too...but if you can have the old LIBMYSQL.DLL you can use
it.

Check also your statement if followed the correct syntax in loading
file

R.B.Roa
Traffic Management Engineer
PhilCom Corporation
Tel. No. (Office) (088) 858-1028
(Home) (088) 858-8889
Mobile No. (63) (919-3085267)


-Original Message-
From: Weiwei Wang [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, November 20, 2002 1:29 PM
To: [EMAIL PROTECTED]
Subject: Re: MySQL  Delphi 6

hi,
could you tell me how to load a txt into my table?
I use the comand :
mysql LOAD DATA LOCAL INFILE pet.txt INTO TABLE pet;
But it fails,the error information is:
ERROR 1148: The used command is not allowed with this MySQL version
I am using the mySql3.23.53 version.
Doesn't this version support the load function?
BTW,how to transfer the Access database into MySql db?

thanks a lot.
weiwei
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, November 20, 2002 12:07 AM
Subject: RE: MySQL  Delphi 6


You can download winzeos for delphi

I use it when connecting to MySQL

Try searching it in google

R.B.Roa
Traffic Management Engineer
PhilCom Corporation
Tel. No. (Office) (088) 858-1028
(Home) (088) 858-8889
Mobile No. (63) (919-3085267)


-Original Message-
From: Patricio Díaz G. [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, November 20, 2002 1:34 PM
To: [EMAIL PROTECTED]
Subject: MySQL  Delphi 6

Can somebody help me with Delphi 6 and MySQL?
I'm using Delphi en a WinXP box and the MySQL server in a Linux box.
I am
having trouble connecting to the server with the CLX/dbExpress
TSQLConnection component.
Please, if somebody can help me, let me know and I'll explain the
whole
situation.

Regards,

Patricio






-
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

decode statement

2002-10-22 Thread RBRoa 
Hi,

Anybody tried to include mysql functions like
DECODE('some_text','pass_text') to a PHP script?

I know this is not a server question...but I hope somebody can help on
this...


R.B.Roa
Traffic Management Engineer
PhilCom Corporation
Tel. No.(Office) (088) 858-1028
(Home) (088) 858-8889
Mobile No. (63) (919-3085267)
Web :   http://mail.sni.ph/~rroa http://mail.sni.ph/~rroa 
http://pollquest/rosel http://pollquest/rosel 


-
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

query

2002-10-15 Thread RBRoa 

Hi,

I got a problem on how to create a query on my data, where I want to get the
item which is having a 'busy' and not having a 'complete' value.

Sample data

Number  reason

1   busy
2   complete
1   complete
2   complete
3   busy
4   complete
5   complete
3   busy

all I want to get is the number which doesn't have any complete entry on
reason field

I know it's a sql query question, hope anyone can spare me solution on this




R.B.Roa
Traffic Management Engineer
PhilCom Corporation
Tel. No.(Office) (088) 858-1028
(Home) (088) 858-8889
Mobile No. (63) (919-3085267)




-
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

LOAD DATA in LOCAL

2002-07-16 Thread RBRoa 

Hi,

Im just wondering why MySQL ver 3.23.51 is not supporting LOAD DATA INFILE
syntax, I downgrade my server to the older one which is MySQL ver 3.23.44,
is there any bug about using it in the latest version?



R.B.Roa
Traffic Management Engineer
PhilCom Corporation
Tel. No.(Office) (088) 858-1028
(Home) (088) 858-8889
Mobile No. (63) (919-3085267)




-
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: LOAD DATA in LOCAL

2002-07-16 Thread RBRoa 

Is there any problem in my.cnf file?

[mysqld]
log-bin
server-id=165
skip-bdb
skip-name-resolve
skip-innodb
flush
port=3306
socket=/tmp/mysql.sock
set-variable = key_buffer_size=16M
set-variable = max_allowed_packet=1M
set-variable = flush_time=300

I only use MyISAM...LOAD DATA INFILE syntax I used in MySQL ver 3.23.44 in
working fine...and my first suspect about this is the LIBMYSQL.DLL, maybe
they added some feature to MySQL ver 3.23.51 which affect the LOAD
syntax...I got an error when I execute the command...it says that its not
supported...




R.B.Roa
Traffic Management Engineer
PhilCom Corporation
Tel. No.(Office) (088) 858-1028
(Home) (088) 858-8889
Mobile No. (63) (919-3085267)




-Original Message-
From:   Jan Peuker [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, July 16, 2002 3:15 PM
To: [EMAIL PROTECTED]
Subject:Re: LOAD DATA in LOCAL

Hi ,

check this: In MySQL 3.23.49 and MySQL 4.0.2 LOCAL will only work
if you
have not started mysqld with --local-infile=0 or if you have not
enabled
your client to support LOCAL. See section 4.2.4 Security issues with
LOAD
DATA LOCAL. 

maybe that's what you are looking for.
see: http://www.mysql.com/doc/L/O/LOAD_DATA.html
and: http://www.mysql.com/doc/L/O/LOAD_DATA_LOCAL.html

just my 0,02

jan


- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 16, 2002 8:55 AM
Subject: LOAD DATA in LOCAL


 Hi,

 Im just wondering why MySQL ver 3.23.51 is not supporting LOAD
DATA INFILE
 syntax, I downgrade my server to the older one which is MySQL ver
3.23.44,
 is there any bug about using it in the latest version?



 R.B.Roa
 Traffic Management Engineer
 PhilCom Corporation
 Tel. No. (Office) (088) 858-1028
 (Home) (088) 858-8889
 Mobile No. (63) (919-3085267)





-
 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: LOAD DATA in LOCAL

2002-07-16 Thread RBRoa 

I got iti wasn't able to add the local-infile option in my server
configthanks for the help


R.B.Roa
Traffic Management Engineer
PhilCom Corporation
Tel. No.(Office) (088) 858-1028
(Home) (088) 858-8889
Mobile No. (63) (919-3085267)




-Original Message-
From:   Jan Peuker [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, July 16, 2002 4:02 PM
To: [EMAIL PROTECTED]
Subject:Re: LOAD DATA in LOCAL

Hi,

* I am not a professional, but I think there is no error in your
config.
The statement runs on my .49.
Change in .50 was
- Fixed binary builds to use --enable-local-infile. (this affects nt
versions, which means your dll!)
Nothing on .51.
* I think you get the message: The used command is not allowed with
this
MySQL version like in 4.2.4. Security Issues Bulletin? Maybe you
have to
connect to your server using mysql --local-infile. I guess...
* Do you use just load data infil 'some.txt' into mytable; or are
there
any other commands?
please refer to: http://www.mysql.com/doc/T/O/TODO_future.html
* Have you tried mysqlimport already?

just my 0,01 ;)

jan


- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, July 16, 2002 9:41 AM
Subject: RE: LOAD DATA in LOCAL


 Is there any problem in my.cnf file?

 [mysqld]
 log-bin
 server-id=165
 skip-bdb
 skip-name-resolve
 skip-innodb
 flush
 port=3306
 socket=/tmp/mysql.sock
 set-variable = key_buffer_size=16M
 set-variable = max_allowed_packet=1M
 set-variable = flush_time=300

 I only use MyISAM...LOAD DATA INFILE syntax I used in MySQL ver
3.23.44 in
 working fine...and my first suspect about this is the
LIBMYSQL.DLL, maybe
 they added some feature to MySQL ver 3.23.51 which affect the LOAD
 syntax...I got an error when I execute the command...it says that
its not
 supported...




 R.B.Roa
 Traffic Management Engineer
 PhilCom Corporation
 Tel. No. (Office) (088) 858-1028
 (Home) (088) 858-8889
 Mobile No. (63) (919-3085267)




 -Original Message-
 From: Jan Peuker [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, July 16, 2002 3:15 PM
 To: [EMAIL PROTECTED]
 Subject: Re: LOAD DATA in LOCAL

 Hi ,

 check this: In MySQL 3.23.49 and MySQL 4.0.2 LOCAL will only work
 if you
 have not started mysqld with --local-infile=0 or if you have not
 enabled
 your client to support LOCAL. See section 4.2.4 Security issues
with
 LOAD
 DATA LOCAL. 

 maybe that's what you are looking for.
 see: http://www.mysql.com/doc/L/O/LOAD_DATA.html
 and: http://www.mysql.com/doc/L/O/LOAD_DATA_LOCAL.html

 just my 0,02

 jan


 - Original Message -
 From: [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Tuesday, July 16, 2002 8:55 AM
 Subject: LOAD DATA in LOCAL


  Hi,
 
  Im just wondering why MySQL ver 3.23.51 is not supporting LOAD
 DATA INFILE
  syntax, I downgrade my server to the older one which is MySQL
ver
 3.23.44,
  is there any bug about using it in the latest version?
 
 
 
  R.B.Roa
  Traffic Management Engineer
  PhilCom Corporation
  Tel. No. (Office) (088) 858-1028
  (Home) (088) 858-8889
  Mobile No. (63) (919-3085267)
 
 
 
 
 

-
  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: Type of column in query float instead of integer

2002-06-26 Thread RBRoa 

U can use the latest version of WinZeos 5.0.3

Hope it helps




R.B.Roa
Traffic Management Engineer
PhilCom Corporation
Tel. No.(Office) (088) 858-1028
(Home) (088) 858-8889
Mobile No. (63) (919-3085267)




-Original Message-
From:   Iago Sineiro [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, June 27, 2002 2:22 AM
To: Zeos Hackers Mail List; Zeos General Mail List; MySql Mail
List
Subject:Type of column in query float instead of integer

Hi all.

I execute the next query in Delphi 5.0 against MySQL and Delphi
understand
that the column of the query is of type ftFloat
when it should be ftInteger (The field cantidad in the database is
int).

SELECT SUM(cantidad) AS Ventas
FROM LALBARANCL
WHERE fecha = 2002-05-01
AND fecha  2002-05-02
AND idArticuloInfo = ART:0:48247'

The same query without the SUM function results integer type.

How could I change the result type from float to integer?

Note: I use Delphi components WinZeos 3.0.2.

Thanks in advance.




-
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

LOAD DATA

2002-06-26 Thread RBRoa 

Everyone,


Is it possible to use LOAD data infile syntax in MySQL ver 3.23.51 win98
version?



R.B.Roa
Traffic Management Engineer
PhilCom Corporation
Tel. No.(Office) (088) 858-1028
(Home) (088) 858-8889
Mobile No. (63) (919-3085267)




-
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

LibMySQL.DLL?

2002-06-19 Thread RBRoa 

Hi to all,

Where can I find the stable LIBMYSQL.DLL?...

Im just confuse which one to usei found the file in LIB\DEBUG and
LIB\OPT...they are not equal in size...

Thanks...



R.B.Roa
Traffic Management Engineer
PhilCom Corporation
Tel. No.(Office) (088) 858-1028
(Home) (088) 858-8889
Mobile No. (63) (919-3085267)




-
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

TWO SERVERS

2002-06-10 Thread RBRoa 

Everyone,

Im just curious if possible, I had two MySQL server...one is the replica of
the master server. And to make the database in safe and intact even if
there's a hang-up. I use auto back-up using the MySQL dump program. But if
master server is downed. All I do is redirect my front-end application to
point to the slave server. But I done this manually. All I want is to make
it transparent to users in changing from server A to server B. is there an
easy way to implement this on Windows platform?...I use the Win32 version of
MySQL...and all my front-end is also in Win32 environment...is it possible
to build a decision maker between the two server?...if master is up then all
loads are directed to master but if the master is dead then automatically
all loads are carried by the slave...I just wondering if someone can help me
to this...and I highly appreciate any ideas...




R.B.Roa
Traffic Management Engineer
PhilCom Corporation
Tel. No.(Office) 858-1028
(Home) 858-8889
Mobile No. (63) (919-3085267)



-
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: where i can write my script

2002-06-06 Thread RBRoa 

Use TASK MANAGER in windows 98

It does what u wantjust run mysql  scriptname;



R.B.Roa
Traffic Management Engineer
PhilCom Corporation
Tel. No.(Office) 858-1028
(Home) 858-8889
Mobile No. (63) (919-3085267)



-Original Message-
From:   Rubylinda F Otero [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, June 07, 2002 9:20 AM
To: mysql mailing list
Subject:where i can write my script

i want to know where a can write my script in running and use mysql.


recently i save in a file a two statement and it work what i expect
to be done,

i'm wondering what is the most easiest programming language could i
use to write my script.


for ur info
i'm using win98
mysql 3.29.49


__
www.edsamail.com

__
www.edsamail.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

MySQL on CYGWIN installtion

2002-05-22 Thread RBRoa 

Anybody has tried installing MySQL on CygWin?




R.B.Roa
Traffic Management Engineer
PhilCom Corporation
Tel. No.(Office) 858-1028
(Home) 858-8889
Mobile No. (63) (919-3085267)



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

2002-05-12 Thread RBRoa 

Hi everyone,

My slave cant replicate due to this error

020513  8:27:37  Slave: reconnected to master
'[EMAIL PROTECTED]:3306',replication resumed in log 'rdbesas-bin.023' at
position 573578
020513  8:27:37  Error reading packet from server: Could not find first log
(read_errno 0,server_errno=65535)

what this error mean...I cut it from the mysql.err file





R.B.Roa
PhilCom Corporation
Tel. No. 858-
Mobile No. (63) (919-xxx)



-
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

FW: MySQL with Delphi 5.0

2002-04-23 Thread RBRoa 


R.B.Roa
PhilCom Corporation
Tel. No. 858-
Mobile No. (63) (919-xxx)



-Original Message-
From:   Roa, Rosel B. 
Sent:   Wednesday, April 24, 2002 2:01 PM
To: '[EMAIL PROTECTED]'
Subject:RE: MySQL with Delphi 5.0

Use WinZEOZits free and friendly...I use it too...

MySQL+DELPHI 6.0+WinZEOZ=high speed client development



R.B.Roa
PhilCom Corporation
Tel. No. 858-
Mobile No. (63) (919-xxx)



-Original Message-
From:   [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
[SMTP:[EMAIL PROTECTED]] mailto:[SMTP:[EMAIL PROTECTED]] 
Sent:   Wednesday, April 24, 2002 1:34 PM
To: José
Cc: MySQL
Subject:RE: MySQL with Delphi 5.0


Hi Jose,

In the portal and contrib section of the MySQL website there is
several direct API's to MySQL.  I propose you use one of these, although
dbExpress is a nice idea it is not dedicated and developed only for MySQL
and thus works poorly.

Our own components is also available at:
http://www.scibit.com/MySQLCOMPONENTS
http://www.scibit.com/MySQLCOMPONENTS  and is working ONLY with MySQL,
v3.21.x to v4, since December 1999.  Today it is Single Source and you thus
use the same source code for Delphi 5/6 and Kylix 1/2.  We and our users
uses these components for a number of years now and it is implemented in
many production systems and real-time systems, etc.

Kind Regards
SciBit MySQL Team

 
 -Original Message-
 From: José [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] 
 To: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 
 CC: 
 Subject: MySQL with Delphi 5.0
 Sent: Tue, 23 Apr 2002 13:51:42 GMT
 Received: Tue, 23 Apr 2002 14:07:46 GMT
 Read: Sat, 30 Dec 1899 00:00:00 GMT
 I've installed MyODBC and then I've set up ODBC and I saw the
driver for 
 MySQL DB, when I try to create a new alias wiht MySQL it does not
apear to 
 select the DB, acording a book wich is guiding it should has to
appear.
 
 Can anybody help to set up the ALIAS with MySQL 
 
 Thanks 
 
  
 
 José Haroldo Filho
  Gerência de TI
 

-
 Before posting, please check:
http://www.mysql.com/manual.php
http://www.mysql.com/manual.php(the manual)
http://lists.mysql.com/ http://lists.mysql.com/
(the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] 
 To unsubscribe, e-mail
[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] 
 Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
http://lists.mysql.com/php/unsubscribe.php 
 
 



-
Before posting, please check:
   http://www.mysql.com/manual.php http://www.mysql.com/manual.php
(the manual)
   http://lists.mysql.com/ http://lists.mysql.com/(the
list archive)

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

skip-delay-key-write

2002-04-19 Thread RBRoa 

Anybody knows...whats the effect if use this option to my.cnf

SKIP-DELAY-KEY-WRITE

I had a problem when recovering from crash...all my data is incomplete...I
wonder that MySQL server had its delay from writing the data from memory to
disk...is this correct?...or I got wrong about what I think...



R.B.Roa
PhilCom Corporation
Tel. No. 858-
Mobile No. (63) (919-xxx)



-
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: using .dat SQL Data in mySQL DB

2002-04-17 Thread RBRoa 

U can also use MySQL FRONT



R.B.Roa
PhilCom Corporation
Tel. No. 858-
Mobile No. (63) (919-xxx)



-Original Message-
From:   Thomas Edison Jr. [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, April 17, 2002 2:21 PM
To: [EMAIL PROTECTED]
Subject:using .dat SQL Data in mySQL DB

Hi,

I have a .dat file.. with some data like this :


02001IN00100213200207120020412200204122002041710002002041720020417
 

02002IN00100213200207220020415200204152002041810002002041820020418
 

02003IN00100213200207320020416200204162002041910002002041920020419
 

This data was exported via SQL Server.. using Oracle.
I need to use this data in my mySQL Database and work
on it through PHP. 

Can i use phpMyAdmin for this.. or some other method?

Thanks,
T. Edison Jr.



=
Rahul S. Johari (Director)
**
Abraxas Technologies Inc.
Homepage : http://www.abraxastech.com
Email : [EMAIL PROTECTED]
Tel : 91-4546512/4522124
***

__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.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: Export

2002-04-17 Thread RBRoa 

Use MySQLDumpit can help make backups



R.B.Roa
PhilCom Corporation
Tel. No. 858-
Mobile No. (63) (919-xxx)



-Original Message-
From:   Manish Mehta [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, April 17, 2002 5:45 PM
To: mysql
Subject:Export

Hi,

I am working on Mysql . I wants to take backup (export) of my
database from
dos prompt . Is their any way.

Please Tell.

Thx in advance

Manish Mehta





-
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: Export

2002-04-17 Thread RBRoa 

You can use

C:\MySQL\Bin\MySQLDump -A  backup_file.sql





R.B.Roa
PhilCom Corporation
Tel. No. 858-
Mobile No. (63) (919-xxx)



-Original Message-
From:   Manish Mehta [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, April 17, 2002 6:09 PM
To: [EMAIL PROTECTED]
Subject:Re: Export

It can help to take backup on the basis of table . But I wants to
take
backup of complete database and store them in some particular file.

Manish
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, April 17, 2002 3:23 PM
Subject: RE: Export


 Use MySQLDumpit can help make backups



 R.B.Roa
 PhilCom Corporation
 Tel. No. 858-
 Mobile No. (63) (919-xxx)



 -Original Message-
 From: Manish Mehta [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, April 17, 2002 5:45 PM
 To: mysql
 Subject: Export

 Hi,

 I am working on Mysql . I wants to take backup (export) of my
 database from
 dos prompt . Is their any way.

 Please Tell.

 Thx in advance

 Manish Mehta






-
 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: some good tutorial

2002-04-17 Thread RBRoa 

Yeaheverything is open in MySQL environment ...u can read more info in
the documentation side of MySQL website...


R.B.Roa
PhilCom Corporation
Tel. No. 858-
Mobile No. (63) (919-xxx)



-Original Message-
From:   Ashish Joy [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, April 18, 2002 3:01 AM
To: [EMAIL PROTECTED]
Subject:some good tutorial

hi everybody,
i have just joined the list and wanted to know something about
mysql. 
is there some really good tutorial you think might be good for a 
starter in mysql. i am a master's student and have some knowledge 
of databases like ms access, oracle. 

hope to get some good stuff. 
regards
ashish



See Dave Matthews Band live or win a signed guitar

http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_020201
/splash.asp 


-
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: Math Computations

2002-04-17 Thread RBRoa 

It could be best to parse and remove ',' from both of them first before
calculation...


R.B.Roa
PhilCom Corporation
Tel. No. 858-
Mobile No. (63) (919-xxx)



-Original Message-
From:   delz [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, April 18, 2002 1:50 PM
To: [EMAIL PROTECTED]
Subject:Re: Math Computations

Hi All,

How do I make calculations in php or mysql if the value has a comma
like
2,000 + 32,000 = 34,000. I have a problem
calculating if one of my values has a comma. It doesn't display the
right
output. I'll appreciate anyone who can
help me with this.

Thanks.

Delz.


- Original Message -
From: Adam Alkins [EMAIL PROTECTED]
To: delz [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, April 11, 2002 5:44 PM
Subject: Re: Math Computations


 Something like

 ?

 $db = mysql_connect(localhost,database_user,password);
 mysql_select_db (database_name);

 $query = SELECT * FROM table_name;
 $result = mysql_query($query);


 echo Computers | Department | Price Per PC | Total Amountbr;

 while ($row = mysql_fetch_row($result)){
 $subtotal=$row[0]*$row[2];
 $total+=$subtotal;
 echo $row[0] | $row[1] | $row[2] | $subtotalBR;
 $comptotal+=$row[0];}
 }
 echo $comptotal $total;

 ?

 Obviously format it into a table would make sense, e.t.c.

 Adam
 - Original Message -
 From: delz [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Thursday, April 11, 2002 5:29 AM
 Subject: Math Computations


  Hi,
 
  I have this table that looks like this
 
  Computers | Department | Price per PC | TotalAmount |
  15  |   Marketing | $500.00|
|
   5  |   Purchasing | $ 300.00  |
|
 
  I want this table to display the total price wherein Computer *
Price
Per
 PC
  = TotalAmount
  and want to display the total no. of computer and the OverAll
TotalAmount.
 
  I want the output to look like this
 
  Computers | Department | Price per PC | TotalAmount |
  15  |   Marketing | $500.00| $ 7500.00 |
   5  |   Purchasing | $ 300.00  |  $ 900.00
|
  -
---
20  $
8400.00
 
  Can anyone help me how to do this in mysql or php. I will surely
 appreciate
  any help I
  can get.
 
  Thanks.
 
  Delz
 
 
 
-
  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: Does MySQL support subqueries?

2002-04-15 Thread RBRoa 

I think that feature is to be added on MySQL ver 4.xx

That's what Im waiting for...lots  of us waiting for it...


R.B.Roa
PhilCom Corporation
Tel. No. 858-
Mobile No. (63) (919-xxx)



-Original Message-
From:   Amaury Cabarcas Alvarez [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, April 16, 2002 1:14 AM
To: [EMAIL PROTECTED]
Subject:Does MySQL support subqueries?

I have mysql 3.23.49a, and i wish know if does version support
subqueries?



-
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: binlog and replication stuff

2002-04-10 Thread RBRoa 

How about if master crashes?...is there anyway to recover?...aside from
copying all stuff from slave to master...


R.B.Roa
PhilCom Corporation
Tel. No. 858-
Mobile No. (63) (919-xxx)



-Original Message-
From:   Davide Giunchi [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, April 10, 2002 5:37 PM
To: Marc Prewitt
Cc: [EMAIL PROTECTED]
Subject:Re: binlog and replication stuff


You are right, but my master generate about 150Mb of binlog x day, i
a slave 
fail after 4 day it will reexec a lot of query and take some time.
how can i 
safely rotate the log in master+slaves without restarting them?
The Mysql manual explain how to rotate from a `hostnmae`-bin`.002
(or  001) 
file, but what about if the binlog is always the same?
I could do a FLUSH MASTER in the master and then FLUSH SLAVE in the
slaves, 
it wouldn't loose the sync?

Regards

 When a slave crashes or reboots, it should start replicating from
where it
 left off--at least ours do work that way.  The current replication
state
 is saved in master.info on the slave and when it starts up again,
it
 should read that file and resume reading the binlog on the master
where it
 left off.  The master.info file contains the binlog#, location,
user,
 password, etc... neccessary to restart replication.

 In you case, does the slave give you any error messages in it's
error log
 about why it couldn't resume replication?  If it doesn't try to
start
 replication, have you tried doing a 'slave start' on the slave
after it
 reboots?

 -Marc

-- 
Davide Giunchi.
Membro del FoLUG (Forlí Linux User Group) - http://folug.linux.it
GPG Key available on http://www.keyserver.net 
Fingerprint: 8075 363A B4FA 0196 FEEC  AF9C 19A9 66C7 CDAB D0D5


-
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

replication

2002-04-09 Thread RBRoa 

I use MySQL server replication last month, but currently I stopped using
it...coz for some reason

1.  my master server is running on windows 98 platform, I cant prevent
it from hanging-up
2.  my slave server is running on windows 98 also, I cant prevent it
also from hanging-up
3.  if master hangs-up, slave also stop replicating...as the master
recover the slave cant replicate due some changes made by the master which
is not updated in the slave...a corruption...
4.  I always shutdown both servers and copy the database from master to
slave, and start over again...I started up the master then second the
slave...it works better and reliable...
5.  My setup weakness is only when my master server hangs-up...

Is there some tips known about this?I really appreciate it...




R.B.Roa
PhilCom Corporation
Tel. No. 858-
Mobile No. (63) (919-xxx)



-
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: Impact of Free ORACLE

2002-03-25 Thread RBRoa 

Hahahahah..a million dollar support goes freewhat a news.



R.B.Roa
PhilCom Corporation
Tel. No. 858-
Mobile No. (63) (919-xxx)



-Original Message-
From:   MadProfessor [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, March 26, 2002 6:48 AM
To: [EMAIL PROTECTED]
Subject:Impact of Free ORACLE

Just curious what everyone thinks the impact on MySQL will be now
that
Oracle is free?



-
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: 3.23.50?

2002-03-25 Thread RBRoa 

Im just curious

How did u put the MySQL status in your signature?


R.B.Roa
PhilCom Corporation
Tel. No. 858-
Mobile No. (63) (919-xxx)



-Original Message-
From:   Jeremy Zawodny [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, March 26, 2002 5:50 AM
To: Michael Bacarella
Cc: [EMAIL PROTECTED]
Subject:Re: 3.23.50?

On Mon, Mar 25, 2002 at 02:56:58PM -0600, Michael Bacarella wrote:

 3.23.50 is referenced in the documentation but not available for
 download. Should it be there?

Not yet. :-)

 Don't mean to nag, but I'm itching for that autoextend feature.

Based on previous posts, it'll be there in a week or so.  (Maybe
sooner?)
-- 
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936

MySQL 3.23.47-max: up 46 days, processed 1,317,906,824 queries
(329/sec. avg)


-
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: Windows 95 / Latest stable MySQL server start

2002-03-23 Thread RBRoa 

I am using MySQL in windows 98...it runs fine...I think u need only MYSQLD
to run everything...be sure to check ur MY.CNFit should be filled with
some...



R.B.Roa
PhilCom Corporation
Tel. No. 858-
Mobile No. (63) (919-xxx)



-Original Message-
From:   Winstone, Paul [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, March 22, 2002 11:22 PM
To: '[EMAIL PROTECTED]'
Subject:Windows 95 / Latest stable MySQL server start

I know I'm new to this and despite checking FAQs and the manual, am
having
difficulties getting MySQL to work properly under Windows 95.
Unfortunately,
I don't have a choice of operating system, even though I'm
developing for
Windows NT/2000.

Anyway I have started the server with mysqld, a fact that can be
proven
(allegedly) by using a MySQL ping. WinMySQLAdmin 1.4 seems to think
everything is okay, yet when I try to create a database I'm told the
server
must be started.

Has anyone using MySQL had these problems with Windows 95? Or is it
just
me...

Paul.

This e-mail and any attachment is for authorised use by the intended
recipient(s) only.  It may contain proprietary material, confidential
information and/or be subject to legal privilege.  It should not be copied,
disclosed to, retained or used by, any other party.  If you are not an
intended recipient then please promptly delete this e-mail and any
attachment and all copies and inform the sender.  Thank you.


-
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

Task manager

2002-03-20 Thread RBRoa 

Everyone,

I am using the MySQL server version 3.23.44 running on Windows 98 machine, I
just found out that as you view the task manage...mysqld is not alone...I
mean, about 6 of them...I am confuse whos running...so, all I want to know
is...is there a problem about it...as far as my client is concern, it runs
ok...and the server is responding ok...

Have anyone encountered this kind of behavior...Im just wondering if someone
observe it before...

Anyway...using the MySQL client...how can print the SHOW STATUS output?



R.B.Roa
PhilCom Corporation
Tel. No. 858-
Mobile No. (63) (919-xxx)



-
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

differences

2002-03-18 Thread RBRoa 

Everyone,

What's the differences with MySQLD and MySQL-max?



R.B.Roa
PhilCom Corporation
Tel. No. 858-
Mobile No. (63) (919-xxx)


-
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: Can not run multiple command scripts

2002-03-17 Thread RBRoa 

Be sure to separate your command with semi-colon(;)

Besides...i havent seen here your script...just try and add it...



R.B.Roa 
Traffic Management Engineer
PhilCom Corporation
Tel.No. (088) 858-1028
Mobile No. (0919) 30856267


-Original Message-
From:   Steven Gearhart [SMTP:[EMAIL PROTECTED]]
Sent:   Sunday, March 17, 2002 1:39 PM
To: [EMAIL PROTECTED]
Subject:Can not run multiple command scripts

As usual, I am a newbie to MySQL. I have been studying the user
manual and
Paul DuBois' book, MySQL. I have tried to run the scripts for
menagerie
and samp_db on both a Windows 2000 machine and a Linux machine,
both local
and remote with version 3.23.49a. I have used the command line and
several
GUI interfaces with the same result. I am able to run a single
command,
however, if I try and run a script with two or more commands, I
receive an
error number 1064 - syntax error. This usually shows the error at
line 1.

What am I doing wrong? I am about to give up.


/*/
Steven Gearhart
Gearhart, Inc.
Phone/Fax: 770.466.2898
Email: [EMAIL PROTECTED]



-
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

how to automate sql command?

2002-03-14 Thread RBRoa 

Everyone,

Have u tried automating SQL commands using MySQL client?...

A batch commandmy problem is...how can I run the mysql client that loads
the command from the file[command file]?

Anybody tried it,  



R.B.Roa 
Traffic Management Engineer
PhilCom Corporation
Tel.No. (088) 858-1028
Mobile No. (0919) 30856267


-
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

standard deviation

2002-03-07 Thread RBRoa 

Everyone

Does MySQL support standard deviation function?

Sample..

10.03   
10.12   
9.28
10.04   

Standard deviation = 0.39




R.B.Roa 
Traffic Management Engineer
PhilCom Corporation
Tel.No. (088) 858-1028
Mobile No. (0919) 30856267


-
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

STD()

2002-03-07 Thread RBRoa 

Everyone,


Is this correct?...how MySQL calculate this?...

mysql select * from temp;
+--+
| cal  |
+--+
| 00029.98 |
| 00029.95 |
| 00029.89 |
| 00029.84 |
| 00029.78 |
| 00029.81 |
| 00029.84 |
| 00029.28 |
+--+
8 rows in set (0.00 sec)

mysql

mysql select std(cal) from temp;
+--+
| std(cal) |
+--+
| 0.205240 |
+--+
1 row in set (0.06 sec)

mysql




R.B.Roa 
Traffic Management Engineer
PhilCom Corporation
Tel.No. (088) 858-1028
Mobile No. (0919) 30856267


-
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 with Delphi 5.0

2002-03-06 Thread RBRoa 

Hi,

Im developing software using MySQL with DELPHI...

In my side, I use no ODBCODBC sucksit limits u from everything, so
if u plan to get it easy...then download the latest WINZEOS utility...a
component that exploit the use of TCP/IP connecting to your server...

goodluck




R.B.Roa 
Traffic Management Engineer
PhilCom Corporation
Tel.No. (088) 858-1028
Mobile No. (0919) 30856267


-Original Message-
From:   José Haroldo Filho - Transaliança
[SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, March 07, 2002 9:08 AM
To: [EMAIL PROTECTED]
Subject:MySQL with Delphi 5.0

I've already installed MyODBC and configured the driver correctly
(accoriding a book I'm reading) at ODBC User DNS. But, when I run
Database
Desktop and gonna make a New Table the option of MySQL does not
appear
(according the book appear as show a figure).

Is there lefting something else?

Thanks



-
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: about installing mysql on windows 98

2002-03-01 Thread RBRoa 

Hi,

Its okey for the server to installed in windows 98 machinei currently
use it as my database server.

Just download the complete MySQL win32 executable and run MySQLD...and make
sure that you're MY.CNF file is located in c:\and it is set as
needed

Just that simple...I even installed it in two machine...and configure as
master slave scheme...



R.B.Roa 
Traffic Management Engineer
PhilCom Corporation
Tel.No. (088) 858-1028
Mobile No. (0919) 30856267


-Original Message-
From:   Rajesh Chabria [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, March 01, 2002 12:20 PM
To: [EMAIL PROTECTED]
Subject:about installing mysql on windows 98

dear sir,
  please help me out to install the mysql windows version.the
problem is i
have only windows 98 as stand alone.i donot have windows NT SERVER.
so can mysql be installed on windows 98 as stand alone without the
help of a
server.please mail back.




-
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

SQL query

2002-02-21 Thread RBRoa 

Everyone,

Have u encountered this kind of query?

mysql select edate from traffic where year(edate)='2001' group by
month(edate);

++
| edate  |
++
| 2001-04-29 |
| 2001-05-01 |
| 2001-06-01 |
| 2001-07-01 |
| 2001-08-01 |
| 2001-09-01 |
| 2001-10-30 |
| 2001-11-01 |
| 2001-12-01 |
++
9 rows in set (10 min 53.83 sec)

mysql select count(*) from traffic;
+--+
| count(*) |
+--+
|  2645563 |
+--+
1 row in set (0.00 sec)

mysql

is there a problem with my select statement?...




R.B.Roa 
Traffic Management Engineer
PhilCom Corporation
Tel.No. (088) 858-1028
Mobile No. (0919) 30856267


-
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

Table Deadlock

2002-02-20 Thread RBRoa 

Everyone,
I experienced table deadlock on my MySQL server...my client program does a
Table Write lock before writing to it...but suddenly the computer
hangs-up...do, other client got stuck and waiting for the table to be free
for writing...
But as I know...only the thread who does locking can do the unlockingis
there a hard way to unlock the table?...an admin way...what I did...is just
shut the server down and resume...can mysqladmin do it a simple way?

R.B.Roa 
Traffic Management Engineer
PhilCom Corporation
Tel.No. (088) 858-1028
Mobile No. (0919) 30856267


-
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 load data?

2002-02-17 Thread RBRoa 

Hi,

I am currently running mySQL with a slave...I just wondering if there's a
way to replicate all data available in the master to be copied to the slave
in one single command...

My master server is running ahead than my slave...so my slave is only filled
with user data...

Is there a way to do it once?



R.B.Roa 
Traffic Management Engineer
PhilCom Corporation
Tel.No. (088) 858-1028
Mobile No. (0919) 30856267


-
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

Slow Query...

2002-02-14 Thread RBRoa 

Hi,

I still got stuck on a query...so slow...it took a minute or more

How can I improve my server...

Specs...

Computer:
Pentium II 333MHZ
128MB
20GB HardDrive

OS:
Windows 98,

Database:

Table definition

| edate | date  | YES  | | NULL|
| etime | int(5) unsigned zerofill  | YES  | | NULL|
| lec   | varchar(5)| YES  | | NULL|
| trunk | varchar(5)| YES  | | NULL|
| bound | varchar(5)| YES  | | NULL|
| att   | int(10) unsigned zerofill | YES  | | NULL|
| suc   | int(10) unsigned zerofill | YES  | | NULL|
| ovf   | int(10) unsigned zerofill | YES  | | NULL|
| fir   | int(10) unsigned zerofill | YES  | | NULL|
| alt   | int(10) unsigned zerofill | YES  | | NULL|
| ter   | int(10) unsigned zerofill | YES  | | NULL|
| rng   | int(10) unsigned zerofill | YES  | | NULL|
| tot   | float unsigned zerofill   | YES  | | NULL|
| cal   | float unsigned zerofill   | YES  | | NULL|
| mtu   | float unsigned zerofill   | YES  | | NULL|
| eqp   | int(10) unsigned zerofill | YES  | | NULL|
| srv   | int(10) unsigned zerofill | YES  | | NULL|
| loc   | int(10) unsigned zerofill | YES  | | NULL|
| flt   | int(10) unsigned zerofill | YES  | | NULL|


Indexing

Edate
Etime
Lec
Trunk
Bound
Att
Suc
Cal
Eqp

Currently my table is filled with 1M+ rows...

My problem is...when I used MAX() and GROUP BY enclosed in SELECT statement,
the performance is not convincing...
I used the MySQL console for testing...and I based the time result also...




R.B.Roa 
Traffic Management Engineer
PhilCom Corporation
Tel.No. (088) 858-1028
Mobile No. (0919) 30856267


-
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

Query Speed

2002-02-13 Thread RBRoa 

Hi,

I got stuck on queryabout a million rows in one table...it slows up my
server...

How can I improve my server on managing a request like this?

I manually loop the monthly data query...I got a database that is full of
data daily...so all I need to get the maximum of every month is to query by
loop than to use the SELECT MAX() FROM FOO...is there any way to improve a
GROUP BY query..i know it can be done in group by...I done it before...

Anybody done this beforei need your help

R.B.Roa 
Traffic Management Engineer
PhilCom Corporation
Tel.No. (088) 858-1028
Mobile No. (0919) 30856267


-
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