Very "erstaunlich"! I really didn't thought that!
I think we all could live without(!) such answers.
Who reads from the network? The client or the server? And if the client, why does it
read from the net after the SQL-Statement is already completed? Is there anybody who
has an answer with more
At 08:37 02/02/2001 +0100, Lars-Olof Albertson wrote:
Hi,
Maybe you had an ancient distribution stuff. The best thing to
make is the download of the last version at:
http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.32-win.zip
Remove the MySQL installation using the Control Panel
On Fri, Feb 02, 2001 at 09:11:39AM +0100, Manfred Meier wrote:
Who reads from the network? The client or the server?
They both do, really. The server reads the request and the client
reads the response.
In this case, though, you are looking at the status of various
connections from the
Hi again,
I solved the weird thing but the original myODBC error is still there. How
do I know what values are suitable for my application. I'm using MediumBlob
to store my data so at any one time, the max amount of data to insert would
be 16M. So am I supposed to set max_allowed_packet to 16M,
lock INSERT
INTO ipchains (time,
host,interface,proto,src_ip,src_port,dst_ip,dst_port,length,tos,id,frag_o
437 logreader 10.1.1.4syslog Query 421 Opening tables select
src_ip,count(src_i
p) as val,count(distinct dst_ip) as tot from ipchains where time='20010202
438
Hi,
Monty mentioned that they're looking at making virtually all of the
run-time variables changeable WITHOUT a server restart. Once that
happens, it's just a matter of programming and benchmarking to have a
self-tuning system (to some degree).
I hadn't really thought about the concept in
Hi
I'm doing a simple query using the function STD but I'm getting zeros as
answer. I know that zero is a perfectly good answer for standart
deviation but in this case I should get some positive values :-)
Is there something wrong with this function ?
My sql string is the folowing and I'm
Progetto 2000 writes:
Hi,
I'm trying to install MySQL Client (rpm -i MySQL-client-3.23.29-1.i386.rpm).
The MySQL is just installed because if I run the commands:
mysql_install_db
safe_mysqld
The daemon runs.
But if I insert a normal command like: "mysqladmin version" the
John,
To avoid the issues you mentioned, each table requires an AUTO_INCREMENT
column and a TIMESTAMP(14) column.
We have been coding with VC++ and using various third party ODBC clients,
including MS Access, pretty much since the inception of MyODBC. When using
the Jet Database Engine (MS
David Brown writes:
I have a quick lookup table of about 500,000 records.
The table consists of just 3 fields medium int fields, and indexed on just
one of them - So the records are small, as is the index.
The data won't have any inserts/updates throughout the day, and will be
Description:
When I make a "SELECT count(*) AS Anzahl, ELT(FIELD(kundentyp, ... ), ... ) as
Kundentyp,kategorie FROM table WHERE ... GROUP BY kundentyp,kategorie ORDER BY
kategorie" the Server response with:
mysql SELECT count(*) AS Anzahl,
Hi,
I have installed mysql on SuSE Linux from an rpm. It works but I
want to move the data directory to a larger disk on my machine.
How do I do it??
If I create a symbolic link to the /var/lib/mysql directory, the
mysql.sock (don't really understand what this file does) file
vanishes and I
First excuse me for my english,
I should like of knowing if the mysql ago connection
with the jsp, what if if he may do, drop of knowing
where I could meet any tutorial, if exist.
Thank you by attention.
Sara.
__
Get personalized email
Description:
The mysql initialisation fails on coda filesystems.
Apparently CREATE TABLE creates just the *.frm files,
but silently won't create the *.ISM and *ISD,
resulting in a subsequent message
"ERROR: 1033 Incorrect information in file: './mysql/db.frm'"
How-To-Repeat:
The
I'm evaluation mysql for a product which need both a local database and a remote
database access. The product will be shipped on CD, running a windoze machine which
could or not have TCP/IP installed.
- will mysqld run from a locked media (both the binary and the database)?
- is it possible to
I'm currently evaluation mysql, on a MacOS X machine. It compiles OK, but the test
requires DBD, which I wasn't able to compile:
- while running "perl Makefile.PL" I get:
Note (probably harmless): No library found for -lm
Note (probably harmless): No library found for -lz
Platform Suse 7.0,
AMD 450 KIII+,
128MB Ram
Linux on 10 Gig system harddrive
with 45 Gig additional drive mounted as /dbshare.
MySQL needs to keep its database files in dbshare but I have not been
able to make it work.
From what I have read in this maillist it would appear that some
combination
"RH" == Rolf Hopkins [EMAIL PROTECTED] writes:
RH That also depends on your definition of *PRODUCTION* status. If you are
RH going to make a profit using MySQL then you need to purchase a license.
Not any more; MySQL is GPL in the current version.
Do you mean that mysql_store_result() should store everything to a
local file and and mysql_fetch... should read from this file?
This should not be that hard to do.
Yes, you can use the actual SQL_CURSOR_FORWARD_ONLY that is
unused at this moment, to call mysql_store_result_on_file().
Hi,
Is it possible to put comments against a table and column that are persistent; so that
when you run 'explain' or 'describe', these comments will display.
Rob
I use ./safe_mysqld --datadir=/.../... to put the data onto another disk.
Manfred
Howard Miller schrieb:
Hi,
I have installed mysql on SuSE Linux from an rpm. It works but I
want to move the data directory to a larger disk on my machine.
How do I do it??
If I create a symbolic link to
Hi,
I have two production machines with mysql running, and I'd like to
set up a third on which does backups with replication.
As far as I know, one mysqld can not replicate from two different master.
But I need DB1 from HOST1 and DB2 from HOST2 to be replicated, so I've
used mysqld_multi to
It works without the group by clause also.
As in:
select max(debt) from users;
Roger Ramirez wrote:
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Gro
up_by_functions
max(x) works with the group by clause.
-Original Message-
From: Roman Arefiev
where i live this is illegal.
i hope these jerks don't have my email address.
can you do anything about this TEnon?
At 11:14 PM -0500 2/1/01, [EMAIL PROTECTED] wrote:
New Concept in Gifting!
Join A Team Of 6 And 7 Figure Earners
The sole purpose of this Activity is to enable us to bless more
Hi folks,
I got a strange problem, we're running a webhosting company and during peekhours,
mysql really hits the cpu peek. I do believe there
is one or more clients that are running high loads of querys without actually closing
them, or perhaps even running querys that
dosn't timeout. Is
Hi,
Is it possible to put comments against a table and column that are persistent;
so that when you run 'explain' or 'describe', these comments will display.
Tables in MySQL (version 3.23 at least - not sure about 3.22) do actually
have a comment 'field' built in. You specify your initial
Hi List,
Whem I will go start the MySQL in Linux, receive a error:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock`(111)
What I do?
Thanks
Edgard Arthur Michel
[EMAIL PROTECTED]
Brazil
Are incremental backups possible in MySQL? I haven't seen any
reference to "incremental" in the mysqldump or anywhere else for
that matter.
TIA.
--
Hardy Merrill
Mission Critical Linux, Inc.
http://www.missioncriticallinux.com
Hello,
I am trying to export several databases from one mysql server on one linux
box and import them all to another mysql server on another linux box. I just
completely forgot what the syntax is. Would someone be able to help me? Thanks!
Sincerely,
Tom Cruickshank
At 2:54 PM -0500 2/2/01, Hardy Merrill wrote:
Are incremental backups possible in MySQL? I haven't seen any
reference to "incremental" in the mysqldump or anywhere else for
that matter.
You can take a full dump, and then treat the contents of the update
logs from that point on as incremental
- Original Message -
From: "Ren Tegel" [EMAIL PROTECTED]
To: "Jeff Harris" [EMAIL PROTECTED]
Sent: Friday, February 02, 2001 9:09 PM
Subject: Re: system requirements?
Jeff,
yes the win32 version of mysql runs perfectly under nt.
Some notes about mysql, php and nt:
-php won't run
mysqldump -hhost -uuser -ppw --opt --all-databases all-dbs.sql
mysql -hnewhost -uuser -ppw all-dbs.sql
or as one command:
mysqldump -hhost -uuser -ppw --opt --all-databases |
mysql -hnewhost -uuser -ppw
you can leave out the -hhost(newhost) if you ftp the file from one
machine to the other.
Hello everyone.
I'm hoping the developer of MyODBC hangs out on this list, but here goes. I
browsed through the sources a bit, and I noticed several places where you
are mapping SQL_BIT type to TinyINT. It appears this is only a one way
mapping (software-odbc-mysql) and not the other way.
Platform Suse 7.0,
AMD 450 KIII+,
128MB Ram
Linux on 10 Gig system harddrive
with 45 Gig additional drive mounted as /dbshare.
I have created a symbolic link in /var/lib of mysql- /dbshare.
then
RPM -Uhv --force MySQL*-3.23.32-1.i386.rpm to install the files
from
MySQL-3.23.32-1.i386.rpm
Hello,
I have a table which consists of 5 columns.
There are a large number of rows that have the same values for the
first 4 columns and the last column is the only thing that differs.
I would like to grab all the rows that have these identical
columns so I can store it into one rows with all
Hi I was wondering if anyone could help me find the most efficient.. or
at least A efficient way to preform the following task:
I have a table that has some data, one of which is a UserName column. I
have another table that has multiple rows for that UserName. So table
one looks like:
id
'when' is a reserved word in 3.23
--
"There cannot be a crisis today. My schedule is already full."
--Henry Kissinger
-Original Message-
From: Noah Romer [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 02, 2001 14:38
In the process of moving a database to a new server, I
So that looks like it does a select for all in table2 who DO have
dedicated and just excludes those matches... thats an interesting way of
doing it.. but that would still return a row for the other groups that
the username belongs to in table2 right? so for instance if there is 2
entries in
But,
I understand that some of these junkers/spammers are just trawling for addresses
that they only later learn are real when the recipient replies to the remove link.
From that point, they're latched unless they change their e-mail addres.
I think it's reprehensible to be spamming people. The
On Fri, Feb 02, 2001 at 03:38:09PM -0500, Noah Romer wrote:
mysql insert into bugs_activity (bug_id,who,when,field,oldvalue,newvalue)
values (334,18,20010131145149,'bug_status','NEW','RESOLVED');
ERROR 1064: You have an error in your SQL syntax near
'when,field,oldvalue,newvalue) values
Description:
my error-log show me "Can't connect ... on '206709' (22)(107) retry in 3306 sec
And really, it is connecting 3306 seconds later. Obviously, this is the port-number
and the delay should be 60 seconds
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:
I have a GROUPing question on the following query:
SELECT HOUR(closedtime) AS hour, COUNT(assignedto) AS count FROM db WHERE
(closedtime ='2001-01-01' AND closedtime = '2001-01-31 23:59:59') AND
assignedto='person' GROUP BY hour;
give something like this:
+--++---+
| hour |
Brazil: US$0,825/litre - That's really expensive!!!
BR,
Fábio Ottolini
- Original Message -
From: "Solomon Sokolovsky" [EMAIL PROTECTED]
To: "Marko Sarunac" [EMAIL PROTECTED]; "Redvers Davies"
[EMAIL PROTECTED]
Cc: "mySQL Mailing List" [EMAIL PROTECTED]
Sent: Thursday, February 01,
I didn't receive this e-mail back after I sent it...
- Original Message -
From: "Fábio Ottolini" [EMAIL PROTECTED]
To: "Paul DuBois" [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: "Fowler, J.T." [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, February 01, 2001 7:20 PM
Subject: Re:
SELECT
t1.id
FROM
table1 t1,
table2 t2a,
table2 t2b
WHERE
t1.StopTime = 0 AND
(t2a.Group != 'Dedicated' AND t2a.UserName != t2b.Username) AND
t2a.UserName = t1.UserName
Not sure if you need those () though.
On 2 Feb 2001, Drew
Ok, being careful to try and avoid any naughty words that might trigger the
bleeding spam filter.
The Tilghman wrote:
'when' is a reserved word in 3.23
Well, that would explain that. Arrrgghh! I even spent a couple of hours going
through the "upgrading from 3.22"/"major new features of
We are getting thse errors. Can anyone point me in the right direction?
DBI-connect(database=whois;host=www5) failed: Host 'www5' is blocked
because of many connection errors. Unblock with 'mysqladmin flush-hosts' at
/usr/lib/perl5/site_perl/5.005/PEC.pm line 731
Thanks,
CC
What is host.frm and why can host.frm not be located where I want to
be?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
I'm suddenly getting "Got error 28 from table handler" from a MySQL script
that used to work fine. On searching the MySQL list archives, I determined
that means I'm out of disk space.
Something's weird here though:
root@trapezoid [~]# df
Filesystem 1k-blocks Used Available Use%
Hello, via telnet with mysql server on linux, I try to delete a table, but it won't
work. I'm browsing the documentation, I can't see what will work. I can do this via
asp, but I'd love to know the command for something that should be as simple as
mysql Delete (tablename) from (Database name);
I'm having a little trouble running a program I made with mysql++1.7.8, when
I run the app it segment faults when the connect object is created.
this is what I am running
Red Hat Linux release 7.0 (Guinness)
Kernel 2.2.16-22 on an i586
Mysql 3.23.32
mysql++1.7.8
gcc 2.96.2
here is how I compile
why dont you try
use database
drop tablename
Mensaje citado por: Joel Holtzman [EMAIL PROTECTED]:
Hello, via telnet with mysql server on linux, I try
to delete a table, but it won\'t work. I\'m browsing
the documentation, I can\'t see what will work. I can
do this via asp, but I\'d love
Philip Mak wrote:
I'm suddenly getting "Got error 28 from table handler" from a MySQL script
that used to work fine. On searching the MySQL list archives, I determined
that means I'm out of disk space.
Something's weird here though:
root@trapezoid [~]# df
Filesystem 1k-blocks
Thank you, I learned that I needed:
Drop *table* tablename
Thanks for your help, guys. I appreciate it
Joel
- Original Message -
From: [EMAIL PROTECTED]
To: Joel Holtzman [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, February 02, 2001 3:51 PM
Subject: Re: Deleting table
Hello, I have one question about the 'load data' function.
Below is the what I have for 'actor.txt' for a text file I want to load to table
'actor'
| ID | fFirst | Last
On Fri, 2 Feb 2001, Siim Einfeldt aka Itpunk wrote:
I get an awful lot of spam to my private email as well, I could filter
them, but does anyone know what is the best way to actually get to know
where and from who the email has come from (as the from addresses lie
99% of the cases)?
yeah,
Can anyone explain the following results to me?
I am trying to find all values +/- 30% from a number...
value is declared as: | value | int(10) unsigned
Note that 1.3*63000 is 81900...
The first two are apparently correct:
mysql SELECT count(*) FROM bench WHERE year = 95 and
- value =
anyone know how to repair a corrupt user table? I edited the user.ISD file
and I can make changes via mysql but cannot do a select * from user;
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
Hi,
I installed MySQL on Red Hat 6.2. Now I am having
trouble with uninstalling it. If I do rpm -erase
MySQL-version.rpm, the message saying "no rpm package
is installed". If I do rpm -i MySQL-version.rpm, the
message says that the rpm package is already
installed. what should I do to uninstall
Just take the .rpm off the end, and any additional platform information
like i386, etc. It would just be, for example, rpm -e MySQL-3.23.32-1
Sean
On Fri, 2 Feb 2001, Abby Jiang wrote:
Hi,
I installed MySQL on Red Hat 6.2. Now I am having
trouble with uninstalling it. If I do rpm -erase
Give this a try. I used table aliases out of habit.
SELECT table1.id FROM table1 A
LEFT JOIN table2 B ON A.UserName = B.username
AND B.Group != 'Dedicated'
WHERE B.username IS NULL
AND A.StopTime = 0;
- Scott
Hi I was wondering if anyone could help
Why does anyone need lessons in how to lose $400 in 14 days? I can do it
easily.
Terence
- Original Message -
From: "Colin Faber" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, February 03, 2001 1:46 PM
Subject: Re: turn $2000.00 into $1600.00 in 14 days
63 matches
Mail list logo