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 |
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
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
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
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() or
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
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,
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/01
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
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:
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
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 will
, 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 support in MySQL so that multiple instances
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
14 matches
Mail list logo