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
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
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
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
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
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
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
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
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
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
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
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()"
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
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
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
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
16 matches
Mail list logo