Re: segmentation fault

2001-07-11 Thread Kenneth Kopelson
What is mysql-VERSION-OS.tar.gz? Breughel, did you really type that exact thing on the command line, because if you did, I believe the instructions you followed intended for you to replace the VERSION-OS with your actual VERSION and OS. For example: gunzip mysql-3.23.39-pc-solaris.tar.gz | t

Re: Problem with count() - URGENT

2001-07-03 Thread Kenneth Kopelson
Just to point out, you did not describe t2 in this email, but you have redescribed t1 again, and not table t2. Also, from looking at your query, I can see the following things: If you did not have the where condition checking for the timestamp, then you would get the entry for "four" since th

Re: Problem with count() - URGENT

2001-07-03 Thread Kenneth Kopelson
Just to point out, you did not describe t2 in this email, but you have redescribed t1 again, and not table t2. Also, from looking at your query, I can see the following things: If you did not have the where condition checking for the timestamp, then you would get the entry for "four" since th

Re: Daemon crashing (I'm going nuts here)

2001-06-14 Thread Kenneth Kopelson
The only thing I could suggest is that the version of MYSQL you have is not compatible with something else that is running, like PHP perhaps, or even the version of Linux/Kernel/C-libraries. You are experiencing very strange problems, and these types of things are typically caused by incompati

Re: Log file size

2001-06-06 Thread Kenneth Kopelson
Look into the Linux "logrotate" daemon. It allows you to configure what happens with logs. At 06:44 AM 6/6/01 -0400, Peter Billson wrote: >I'm running mySQL on Linux and was wondering is there a way to limit the >maximum log file size? > > From time to time I have written a bad script that w

Re: MySQL with perl

2001-06-06 Thread Kenneth Kopelson
Cindy, read my reply to this. You are mistaken. There is actually a way to make a single script do all kinds of different operations. I have single scripts that show a list of records, add a new record, update a record, and delete a record, all in the same script. This is more efficient to

Re: MySQL with perl

2001-06-06 Thread Kenneth Kopelson
You need to have your script operate in different modes. You do this by passing an argument when you call your script to tell the script what it is supposed to do. So in this case, if the script is called with out any arguments, it will display the form, as follows: http://www.sample.com/sam

Re: which the best

2001-06-06 Thread Kenneth Kopelson
Hands down, your best bet is either Linux versions. You will get the best stability, speed, and cost effectiveness by using these databases. Stay away from Windows for this kind of thing. I have developed software for the Windows platform since it first came out, and have been a software en

Re: MySQL Port number

2001-06-06 Thread Kenneth Kopelson
I would suggest you obtain a book on the subject, or visit "mysql.com" and read the documents under "documentation." You are asking questions that have very large answers. To get you started, MySQL is accessed over the web by using a scripting language like PHP or Perl. -Ken At 07:35 PM 6/5

RE: Need help on mysql/php

2001-06-06 Thread Kenneth Kopelson
Actually you are only exposed if you have not set up Apache to run with virtual hosts. It is not difficult to configure Apache so that a person can only see the scripts that are in his/her directory, and is prevented from seeing or modifying the scripts in other peoples directories. Also, it

Re: MAC OS X Server

2001-06-06 Thread Kenneth Kopelson
Apple has tested MySQL on MAC OS X to the best of my knowledge. Given that MAC OS X is essentially FreeBSD Unix with a pretty wrapping, it makes sense that MySQL would work easily. If someone said MySQL worked on MAC OS 9, or older, I would be more cautious. At 02:42 PM 6/5/01 -0800, Angela

Re: events that i can trigger on intervals.

2001-06-06 Thread Kenneth Kopelson
Sure, that is easy. Just add a column to your room assignment table called something like "RELEASE_TIME", and put into that column the time you want the room to be released. Then, whenever you want to release rooms, execute something like "DELETE FROM ROOM_ASSIGN WHERE RELEASE_TIME > NOW()"

RE: Inserting 307,284 lines. Is this ok?

2001-06-06 Thread Kenneth Kopelson
If I'm not mistaken, MySQL can handle millions or even billions of rows, and there is no real limit to the number that reside in a single table. So Mike Mike relax, you are using a serious database here, not a little toy :) -Ken At 01:20 PM 6/5/01 -0500, Johnny Withers wrote: >At boot time y

Re: Question for a MYSQL expert (I assume this list has some)...

2001-06-01 Thread Kenneth Kopelson
some others who are interested, and we can start a project. If anyone on this list would be interested in discussing the possibilities of joining in such an effort, please let me know. -Ken At 11:47 AM 6/1/01 -0600, Steve Ruby wrote: >Kenneth Kopelson wrote: > > > So, how do we get s

Question for a MYSQL expert (I assume this list has some)...

2001-06-01 Thread Kenneth Kopelson
I am hoping there are people who use MySQL for serious business applications on this list. If so, please answer my question :) If not, will someone please direct me to a source of expert information? HERE IS MY QUESTION: I have need for multiple servers to share the same database files. We

Question concerning SHARED DATABASE

2001-05-31 Thread Kenneth Kopelson
I have need for multiple servers to share the same database files. We are implementing a site that will have hundreds of thousands of users at the same time, so we need a large pool of Linux servers that are load-balanced. Then, all these servers, each of which will run Apache and MySQL (or