RE: Can MySQL handle 120 million records?

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 y

RE: MySQL & Delphi 6

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 th

RE: MySQL & Delphi 6

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 (Ho

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 i

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:

decode statement

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

query

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

RE: LOAD DATA in LOCAL

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-

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 us

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

LOAD DATA

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

RE: Type of column in query float instead of integer

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

LibMySQL.DLL?

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

TWO SERVERS

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 applic

RE: where i can write my script

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 [SM

MySQL on CYGWIN installtion

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

error reading

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=655

FW: MySQL with Delphi 5.0

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

skip-delay-key-write

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

RE: Math Computations

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

RE: some good tutorial

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

RE: Export

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:

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 S

RE: using .dat SQL Data in mySQL DB

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]

RE: Does MySQL support subqueries?

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

RE: binlog and replication stuff

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

replication

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

SUM up

Everyone, Im trying to INSERT the SUM of the two data from table TEMP_IN and TEMP_OUT TEMP_IN data select * from temp_in limit 15 -- +--+ | cal | +--+ | 00014.45 | | 00013.95 | | 00015.95 | | 00016.78 | | 00018.92 | | 00015.7

Max value

Everyone, Is this a bug or somethingi am using the latest version of MySQL server and it works fine and convincing...but I observe that if I use the MAX() functioni got this I include max() function to my select query Ex.. select max(A),B,C from table_name group by A; the result i

RE: 3.23.50?

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

RE: Impact of Free ORACLE

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 T

RE: Windows 95 / Latest stable MySQL server start

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

Task manager

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 con

differences

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) htt

RE: Can not run multiple command scripts

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

how to automate sql command?

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 Mobi

STD()

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 |

standard deviation

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 -

RE: MySQL with Delphi 5.0

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 Tr

RE: about installing mysql on windows 98

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 install

RE: SQL query

My concern here is the query speed Mysql query on the statement result so slow...is there a way to improve it? R.B.Roa Traffic Management Engineer PhilCom Corporation Tel.No. (088) 858-1028 Mobile No. (0919) 30856267 -Original Message- From: Daniel Rosher [SMT

SQL query

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 |

Table Deadlock

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 t

How to load data?

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

Slow Query...

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 z

RE: Query Speed

Yeah, My tables structure +---+---+--+-+-+ + | id| int(11) | | PRI | NULL| auto_increment | | edate | date | YES | MUL | NULL| | | etime | int(5) unsigned zerofill | YES |

Query Speed

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 quer