Hi Brian,
By no means am I a MySQL guru (or any other database server environment
guru, for that matter), but could you simply have a reference table that
indicates the percentage of the grape used in the relevant wine?
So, you might have three tables, Wines, GrapeVariety,
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, January 10, 2003 2:00 AM
Subject: RE: May I raise a question?
Thanks, Gerald,
I'm trying to install the MySQL. Apache Php in Windows 2000
Professional. A book
is mysql daemon started?
--- brchang [EMAIL PROTECTED] ha scritto:
Dear Michael Widenius:
After installation of mysql-3.23.52-win in Win2000
platform, I have the
problem with the errors, as shown below, once I try
to start mysql. Could
you provide me the solution to this problem as soon
Dear all,
Your endeavour and speedy action impress me. Thanks.
Seed Chan
-Original Message-
From: admin [SMTP:[EMAIL PROTECTED]]
Sent: Friday, January 10, 2003 3:11 PM
To: Chan, Seed; gerald.clark
Cc: admin; mysql
Subject: Re: May I raise a question?
- Original Message -
i have been using the following sql to try and get foreign keys
working, the table creation works fine but when i try and delete data
from the parent table it deletes as would normally happen in mysql,
also the desired results do not happen if i use RESTRICT.
is this a problem to do with
On Thu, 2003-01-09 at 22:06, Benjamin Dixon wrote:
Hi all,
I'm trying to figure out a way to select a group of maximums from a set
such that each value pair's greatest value is in the result set. For
example, let's say I have this table Value_Pairs:
Name | Value
Bob1
Hi,
I've inherited a FreeBSD/MySQL database-server (Compaq DL360, dual P3 1GHz), running
(at the moment): Server version: 4.0.3-beta
However, as far as I can tell, MySQL/FreeBSD 4.6.2-RELEASE still can't agree on
utilizing more than one CPU.
My question is this:
A year or two ago,
Hi,
It seems is happens to all which use InnoDB.Is announced that will be solved
in 4.0.9.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
-
On Thu, 09 Jan 2003 23:04:37 +0100
Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] wrote:
Rafal,
alter table rezerwacje add foreign key (nip_h,nrpok_p) references
pokoje(nip_h,nrpok_p);
ERROR 1005: Can't create table './test/#sql-932_4.frm' (errno: 150)
Most probably, you are using
Hi!
On Jan 07, Erlend Hopso Stromsvik wrote:
What I can easily do without breaking 4.0.x gamma status, is to add
command line switch --disable-fulltext-stopwords. It can help as a
temporary solution, untill a proper fix - per-index options, that is -
will be implemented.
That would be
Hi!
SELECT count(a.rsori) pippo
FROM ecoras a, ecotxt b
WHERE MATCH ( b.rstxt ) AGAINST ( '-linux' IN BOOLEAN MODE )
AND a.rsori = b.rsori
AND a.rscod = b.rscod;
If I execute a query like in the example, I don't obtain all rows where this
word is not present. Instead if I use a
If it was me I would simplify the problem:
A. tear out apache and php and
B. Get mysql installed and working
C. shut down Mysql and install apache and get it working
D. shut down apache, keep mysql shut down and install Php and get it
working.
then start up each, and test as you bring up the full
On Thu, 09 Jan 2003 23:41:46 +0200
Heikki Tuuri [EMAIL PROTECTED] wrote:
Rafal,
I tested also with the `hotele`, and it worked ok.
Please provide your my.cnf and MySQL version number. And test if you can
repeat the error.
Regards,
Heikki
MySQL version 4.0.8, my my.cnf is as
Dear Ben,
i have been using the following sql to try and get foreign keys
working, the table creation works fine but when i try and delete data
from the parent table it deletes as would normally happen in mysql,
also the desired results do not happen if i use RESTRICT.
is this a problem to
Rafal,
the test case below is different from the one you posted yesterday.
Below you are trying to add a constraint
foreign key(nip_h,nrpok_p) references pokoje(nip_h,nrpok_p) on delete set
null
though you have declared
nip_h int(10) not null
in 'rezerwacje'. InnoDB does not accept the
On Tue, Jan 07, 2003 at 12:31:36PM +0100, harm wrote:
Anybody else who has any idea why the index are not used as they should?
I've got same things with 3.23.xx and select query through a TCP/IP
connection.
I don't know why, but you can solve this issue using the USE INDEX syntax
for
i was playing around with ideas below,
so they may be worthless chatter :-)
what i was
thinking I'll just assume the wine world is not
wildly un-uniform... and see where that gets me... :-)
and wine is just an object...
but the wine has many grape varieties sounds a hell
of a lot like one to
Robert,
- Original Message -
From: Robert Tam [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Friday, January 10, 2003 7:43 AM
Subject: Transaction and Row Locking Feature
Hello,
I am a new user to MySQL. I need innoDB's transaction and row locking
feature in MySQL.
Hi!
- Original Message -
From: Gelu Gogancea [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Friday, January 10, 2003 1:25 PM
Subject: Re: Re[4]: mysql 4.0.8- crash on TCP connection
Hi,
It seems is happens to all which use InnoDB.Is announced that will be
solved
in 4.0.9.
Hello Adolfo,
Yes I have tried it too but it did not work. Anyway i have done it programatically in
my app.
Thanks.
Adolfo Bello [EMAIL PROTECTED] wrote:
I have two tables whose structures are below.
- Table1 -
table1id int not null auto_increment
data varchar(30)
- Table2 -
table2id
You should check the manual:
http://www.mysql.com/doc/en/Can_not_connect_to_server.html.
It shows the steps you can do to solve the problem.
On Thu, 2003-01-09 at 23:45, cam vong wrote:
I'm currently using Red Hat 7.1. I have loaded the apache, php, and mysql
rpm. I seem to be having
Hi,
Having a problem with accessing the mysql database from a remote
machine. I am typing in mysql -h ???.??.???.?? -u ?? -p. It asked
for password .. do that then the reply message is ERROR 2013: Lost
connection to MySQL server during query.
Have even tryed replacing IP with a host name and
Hi,
Having a problem with accessing the mysql database from a remote
machine. I am typing in mysql -h ???.??.???.?? -u ?? -p. It asked
for password .. do that then the reply message is ERROR 2013: Lost
connection to MySQL server during query.
Have even tryed replacing IP with a host name and
Hi,
I have a RedHat 8 box /w MySQL 3.23.54, /w 640M RAM.
It looks like there are some sort of a memory leakage somewhere in the
system, because slowly (in a day or two) I run out of memory. Even SWAP
space gets used up at the end (slowly but steadily, fluctuating). If I
restart MySQL, nothing
Hi.
I want to calculate how many rows my query which uses 'GROUP BY' returns.
The query:
SELECT something
FROM test
WHERE (kid=1) OR (kid=2) OR (kid=4)
GROUP BY cid,aid;
Is it posible to get number of rows with such a query from MySQL v3.23.49?
If it isn't posible ... is
I didn't read the original thread...but go to CPAN and check out MyTop.pl.
Just like unix Top process watch application, but for mysql... pretty cool!
-Chris
On Thursday 09 January 2003 06:02 pm, Michael Weiner wrote:
There are a few solutions out there for you. I recommend you check
I rade some where that in the lateste MySQL versopn you can use 1000 to 1400
concurrent connection.Pls cross check in mysql site.
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: mysql list [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, January 09, 2003 5:36 PM
Thank You!!
Rafal,
the test case below is different from the one you posted yesterday.
Below you are trying to add a constraint
foreign key(nip_h,nrpok_p) references pokoje(nip_h,nrpok_p) on delete set
null
though you have declared
nip_h int(10) not null
in
hi to all,
is it still true that mysql/innodb needs explicit
index creation on foreign keys?
why can't i use a standard syntax for foreign keys
creations?
i have a database schema (ddl) with over 50 tables and
i was trying to create the database on mysql when i
receive a lot of errors like this:
Hi,
First of all, we can presume you're using SMP kernel. Then I'd suggest
using Linuxthreads despite your dislike for them - by my experience, they
work far better for mysql/FreeBSD than native threads. May be you try it
again - compile mysql from the ports (WITH_LINUXTHREADS=yes), and it
should
You don't say how you started the server.
It looks to me like you ran mysqld from the /root directory ?
Error 13 is permission denied.
Why would it be looking in /root/tmp?
Use the mysql.start script.
Black Eagle wrote:
Hey guys,
I've just installed mysql from source 4.23.54a
But after
You need to read the manual on date and time functions.
Convert each to seconds, subtract, and convert back to time.
You may have another problem, though.
You can't calculate an interval based solely on time.
You need the date too, unless all transactions are less than 24 hours
in length.
Paul
Start the server.
cam vong wrote:
I'm currently using Red Hat 7.1. I have loaded the apache, php, and
mysql rpm. I seem to be having trouble starting MySQL. It gives me
the following error: Can not connect to localhost MySQL server
through socket /var/lib/mysql/mysql.sock (111). Can
I'm using mysql that was distributed by mysql.com. I seem to be having
a problem with logrotate. When I run logrotate manually on mysql only,
the logs seem to rotate fine. But, when it runs in the cron job, it
creates the new log, but mysql continues to log to the old log.
My mysql logrotate
Just for the sake of showing what we do, here's our setup for MySQL at
all our sites.
We use Dan Bernstein's daemontools package to monitor all our services,
MySQL included. You can download and install them easily from
http://cr.yp.to/daemontools.html. They won't touch your system files
Cool, you work for Yahoo?
I'd love to know the extent to which Yahoo uses PHP and MySQL these days.
What is the average queries/sec that you are getting with MySQL - what
server setup, etc?
Maximo.
At 17:12 9/1/2003 -0800, you wrote:
On Thu, Jan 09, 2003 at 01:51:20PM -0300, Maximo Migliari
Hi, all!
I am compile mysql-4.0.9 for PPC64 with GLIBC64. It's nothing about
logging in mysql.server startup script and in my.cnf, but mysqld
create log file and write a lot of queries to it. How i can disable
this?
My configure options:
./configure --without-berkley-db
On Fri, 10 Jan 2003 23:53:51 +1100
mysql [EMAIL PROTECTED] wrote:
Hi,
Having a problem with accessing the mysql database from a remote
machine. I am typing in mysql -h ???.??.???.?? -u ?? -p. It asked
for password .. do that then the reply message is ERROR 2013: Lost
connection to
Hi,
I've been using the return value of $sth-execute(); (in Perl DBI) to
determine if I have a result set. I'm not using the value I get back but am
assuming that if it's =1 then I have some results.
Is this a safe thing to do with MySQL?
And
The results do actually seem to be correct for the
Hi all,
Is MySQL able (like MS Access) to define permanent relations between tables?
For example, I want to define a master - child relation between 2 tables so
when deleting some entries from the master table to automaticly delete the
entries from the details table without specifying this in
Hi all,
I use MyCC 0.8.6 to work around remote data bases, and I need to dump
the structures of all of them (also their contents). Can it be done?
What SQL query should I use?
Thanks in advance,
Cesar L. Aracena
[EMAIL PROTECTED]
[EMAIL PROTECTED]
(0299) 156-356688
Neuquén (8300) Capital
mysql wrote:
-
Having a problem with accessing the mysql database from a remote
machine. I am typing in mysql -h ???.??.???.?? -u ?? -p. It asked
for password .. do that then the reply message is ERROR 2013: Lost
connection to MySQL server during query.
Have even tryed
Hello , sql
I know you're busy so let me get right to the point.
If you have a business then I'm going to show you something
that will double, triple or even Quadruple your sales...
If you're new to making money on the net then boy, I'm going to
show you something that will earn you a
Hello
I've been running MySQL 3.23.49 as my DB for my webpage since up till now.
The number of visitors have been increasing, and the poor
box is currently running at 100% load, 24/7, which can't be healthy, and
the page is getting slower to load. I've checked all my queries and
tried to
Hello sql,
The fund of the help collects donations for the little girl.
If you know that mercy and compassion means, visit our website please:
http://www.kathelp.boom.ru
--
Best regards,
Ming mailto:[EMAIL PROTECTED]
Hello sql,
The best products and services do not require advertising, you only should know how to
receive it.
We have a nice Affiliate Program.
Let's go shopping! : http://www.sprmarket.com
--
Best regards,
Ming mailto:[EMAIL PROTECTED]
On Friday 10 January 2003 01:45, cam vong wrote:
I'm currently using Red Hat 7.1. I have loaded the apache, php, and mysql
rpm. I seem to be having trouble starting MySQL. It gives me the
following error: Can not connect to localhost MySQL server through socket
/var/lib/mysql/mysql.sock
On Thursday 09 January 2003 23:06, Benjamin Dixon wrote:
I'm trying to figure out a way to select a group of maximums from a set
such that each value pair's greatest value is in the result set. For
example, let's say I have this table Value_Pairs:
Name | Value
Bob1
Joe
Hello Ppl...
I have a fixed length CSV file and when I try to
import it using the LOAD LOCAL command
load data local infile 'F:/Documents and
Settings/Karam/Desktop/test.csv' into table
`karam`.`test_table` fields escaped by '\\' enclosed
by '' terminated by '' lines terminated by '\n' ignore
5
I would be scared out of my gourd to do the dual mysqld processes.
Just backup the machine and put linux on there. That was my solution to
the FreeBSD problem.
-Original Message-
From: Tommy F. Eriksen [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 10, 2003 3:14 AM
To: [EMAIL
Sorry if this mail already arived to the list (I'm not sure if my posting
was sucesfull, because I had problems with my mail server). The past
posting:
Hi.
I want to calculate how many rows my query which uses 'GROUP BY' returns.
The query:
SELECT something
FROM test
WHERE (kid=1)
Hi there,
I am using MySQL 3.23.54 on Windows XP (with SP1). Today, I encountered a
weird problem: when trying to ALTER a TABLE, MySQL said that it no
permissions to rename the *.myi file for that table. I kept encountering
this problem (trying to go from VARCHAR(6) to CHAR(6) for an index
Query.
I guess I don't understand how this mailing list works..
I send messages and some of them get posted, some don't .
Some instances, I send a message and it gets posted, I try to respond and
the message
never appears
Can someone explain?
Date: Wed, 08 Jan 2003 18:37:33
Stefan,
Let's say, you exported database my_database, and you saved the export
file as c:\mysql\my_database_export.sql on your QA machine. You can
import it with this command (assuming that database my_database exists
on your QA machine, but has no tables in it):
c:\mysql\bin mysql -uusername
Jiann-Ming Su wrote:
if test -n `ps acx|grep mysqld`; then
/usr/bin/mysqladmin flush-logs
fi
You're probably running it as root with the password loading from the
/root/.my.cnf or something. Try adding the -uroot -p command-line
options, or a [mysqladmin]
At 18:59 +0300 1/10/03, Andrey V. Ignatov wrote:
Hi, all!
I am compile mysql-4.0.9 for PPC64 with GLIBC64. It's nothing about
logging in mysql.server startup script and in my.cnf, but mysqld
create log file and write a lot of queries to it. How i can disable
this?
My configure options:
Ummm...what exactly do you do if you end up with a situation where no user
has GRANT permission? Like, perhaps while experimenting with user
administration in MySQL, the GRANT privilege was removed from every user?
Thank you,
Kevin Wixson
IT Manager
Norman Camera Video
(616) 567-5552
Frank,
c:\mysql\bin mysql -uusername -ppassword my_database
c:\mysql\my_database_export.sql
Doesn't this assume that I have command line access? Since I am in a
hosted
(ISP) environment, I am trying to do this through phpMyAdmin. Can I
not do
this through phpMyAdmin?
Right. It means you
Description:
I keep recieving signal 11 and stack dumps. There are no
connections going into mysql and no databases besides
mysql and test. Only user in there is root and the other
defualt ' ' user.
How-To-Repeat:
Simply started up the server and let it
Octavian Rasnita wrote:
Is MySQL able (like MS Access) to define permanent relations between tables?
For example, I want to define a master - child relation between 2 tables so
when deleting some entries from the master table to automaticly delete the
entries from the details table without
--- Octavian Rasnita [EMAIL PROTECTED] wrote:
Hi all,
Is MySQL able (like MS Access) to define permanent relations between tables?
For example, I want to define a master - child relation between 2 tables so
when deleting some entries from the master table to automaticly delete the
entries
At 16:15 + 1/10/03, Jeff Snoxell wrote:
Hi,
I've been using the return value of $sth-execute(); (in Perl DBI) to
determine if I have a result set. I'm not using the value I get back but am
assuming that if it's =1 then I have some results.
That's incorrect because it's valid for a result
At 13:53 -0300 1/10/03, Cesar Aracena wrote:
Hi all,
I use MyCC 0.8.6 to work around remote data bases, and I need to dump
the structures of all of them (also their contents). Can it be done?
What SQL query should I use?
Why not use mysqldump? That's what it's for?
Thanks in advance,
har har, silly filter
On Fri, 2003-01-10 at 14:43, [EMAIL PROTECTED] wrote:
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
sql,query,queries,smallint
If
On Fri, Jan 10, 2003 at 01:59:07PM +0100, Csongor Fagyal wrote:
Hi,
I have a RedHat 8 box /w MySQL 3.23.54, /w 640M RAM.
It looks like there are some sort of a memory leakage somewhere in the
system, because slowly (in a day or two) I run out of memory. Even SWAP
space gets used up at
On Fri, Jan 10, 2003 at 04:54:14PM +0200, Octavian Rasnita wrote:
Hi all,
Is MySQL able (like MS Access) to define permanent relations between tables?
For example, I want to define a master - child relation between 2 tables so
when deleting some entries from the master table to automaticly
On Fri, Jan 10, 2003 at 01:53:55PM -0300, Cesar Aracena wrote:
Hi all,
I use MyCC 0.8.6 to work around remote data bases, and I need to dump
the structures of all of them (also their contents). Can it be done?
What SQL query should I use?
Hello Cesar,
Use the mysqldump utility.
%
It's *nothing* about query logging in configuration files!
# mysqld --print-defaults
mysqld would have been started with the following arguments:
--port=3306
--socket=/var/run/mysqld/mysqld.sock
--skip-locking
--set-variable=max_connect_errors=1000
--set-variable=max_connections=600
Greetings all. Hope someone could give me some pointers on this.
I am working at a small ISP in Montreal. Some of our corpo users. have
access to a MySQL database, that we created for them (usually, this DB is
named after there username). The way we configured our mysql installation,
which seams
Slish, nu ti I nazvalsia, Egor Egorov, eshe bi Vasey Pupkinim
nazvalsia-bi hahahahahaha ;-)
Best Regards, Anton
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 10, 2003 9:38 AM
To: [EMAIL PROTECTED]
Subject: re: Selecting max value from sets
I'm trying to setup a secure SSL connection between our website and our
MySQL server using MySQL 4.0.8 and OpenSSL on FreeBSD 4.6 and can't find any
step by step instructions explaining how it's done. The MySQL documentation
appears to only have a few scraps on secure connections and from what I
On Thu, Jan 09, 2003 at 12:24:28PM -0600, Paul DuBois wrote:
...
You probably want SUM(col3 col4,1,0) instead.
Hey Paul,
Am I missing something here?
I did not think that SUM(col3 col4,1,0) would be valid syntax?
Cheers!
--
Zak Greant [EMAIL PROTECTED] | MySQL Advocate |
Is there an easy way to see If and how much data I have written into a blob?
sql...tomakefilterhappy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Dirkjan,
I am using MySQL 3.23.54 on Windows XP (with SP1). Today, I
encountered a
weird problem: when trying to ALTER a TABLE, MySQL said that it no
permissions to rename the *.myi file for that table.
Last 3.23 I used was 3.23.49, and I didn't have an ALTER TABLE problem,
neither on Win98,
How can I delete a database in MySQL so I recreate it?
George Flatman
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this
At 23:45 +0300 1/10/03, Andrey V. Ignatov wrote:
It's *nothing* about query logging in configuration files!
# mysqld --print-defaults
mysqld would have been started with the following arguments:
--port=3306
--socket=/var/run/mysqld/mysqld.sock
--skip-locking
--set-variable=max_connect_errors=1000
Thanks Chris, i had not seen that before, nice little tool to compliment
the plots!!
thanks, added as a bookmark and running it now
Michael Weiner
--
On Sat, 2003-01-11 at 09:06, Dr. Poo wrote:
I didn't read the original thread...but go to CPAN and check out MyTop.pl.
Just like unix Top
Hmm, okay, but isn't the 3.23 supposed to be stable and thus more bugless
than a gamma like 4.0.7?
And also, I was wondering when 4 is going to be released as stable. Looking
over the changelogs, it shouldn't be too long, right?
Zak: thanks for the advice. I got real pissed off about it, since
1) logs file names: hostname.log , hostname-bin.001-4 and all of
them created in datadir. hostname = sql3
2) i am delete all log files from /var/lib/mysql and run
mysqld --user=mysql
And all files create again :(
-rw-rw1 mysqlmysql 14686 Jan 11 01:40 sql3-bin.001
-rw-rw1
On Fri, Jan 10, 2003 at 05:29:41PM +0300, Varshavchick Alexander wrote:
Hi,
First of all, we can presume you're using SMP kernel. Then I'd suggest
using Linuxthreads despite your dislike for them - by my experience, they
work far better for mysql/FreeBSD than native threads. May be you try
Hi,
I have problems with the prompt of mysql :
When i execute mysql.exe it doesn't ask me about any
id or password. Why it happens? if i execute the query
select user() it returns the user odbc@localhost.
The other problem happened when i try to execute this
query (this query is um the
At 14:35 -0500 1/10/03, Kevin Wixson wrote:
Ummm...what exactly do you do if you end up with a situation where
no user has GRANT permission? Like, perhaps while experimenting with
user administration in MySQL, the GRANT privilege was removed from
every user?
Naturally, you're just speaking
i downloaded mysql-4.0.8-0.src.rpm off of the mysql web-site and have tried
to compile it on several different redhat 8.0 boxes. the same error happens
whether compiling latest mysql 3.23 or 4.0 source rpms. the build moves
along for about fifteen minutes (long after i begin to believe it will
Hi,
I have a server doing 26,000 queries a second so thought it was about time
to enable caching. Did some research with MySQL 4 and got it to work.
After running it for a while it turned out that more than 70% of queries
were coming out of cache (straight out of memory not hitting the disk
If this is going to hurt someone please when u
see mails from [EMAIL PROTECTED] do not
scroll down to the bottom
I won't. I've had enough of this, so I just set my mail program to erase any
mails from you. I do the same for anyone who repeatedly promotes religious
or political views on the
Description:
The problem described on
http://bugzilla.redhat.com/bugzilla/long_list.cgi?buglist=75128
with solution described on
http://rhn.redhat.com/errata/RHSA-2002-197.html
comes back after upgrading to mysql-4.0.8 from 3.23.54a.
How-To-Repeat:
this should answer your question, from the DBI documentation
http://search.cpan.org/author/TIMB/DBI-1.30/DBI.pm#execute
sql,query,queries,smallint
- hcir
On Friday, January 10, 2003, at 02:55 PM, [EMAIL PROTECTED] wrote:
I've been using the return value of $sth-execute(); (in Perl DBI) to
Hello
On Tue, Jan 07, 2003 at 11:25:18PM +0100, Christian Jaeger wrote:
I have always these mysql.err.1 files not unlinked in all my
mysqlservers, and only a mysqld restart resolve these (nor reload
neither mysqladmin refresh doesn't unlink them).
The err file is created by safe_mysqld to
88 matches
Mail list logo