ok ... that's right for data (insert into ...) ... but
i get the error before ... when mysql try to create
child table:
CREATE TABLE ... idParent BIGINT, INDEX idpar_ind
(idParent), FOREIGN KEY (idParent) REFERENCES
parent(id)
.. when mysql parses the foreign key, parent table
doesn't exist yet!
Hi All,
What's wrong if this error message appears when I try to run mysql:
cannot connect to local Mysql server through socket
'/var/lib/mysql/mysql.sock'
If I run mysql_config, this appears:
--socket /tmp/mysql.sock
What should I do to correct this? Thanks.
Hi All,
What's wrong if this error message appears when I try to run mysql:
cannot connect to local Mysql server through socket
'/var/lib/mysql/mysql.sock'
If I run mysql_config, this appears:
--socket /tmp/mysql.sock
What should I do to correct this? Thanks.
Modify your my.cnf file
Hy All,
I'm new to MySQL. I am trying to set replication in MySQL but i get the
error in the subject.
Can you help me please?
Thanks to all
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Fajar,
Friday, October 25, 2002, 10:14:42 AM, you wrote:
FP What's wrong if this error message appears when I try to run mysql:
FP cannot connect to local Mysql server through socket
FP '/var/lib/mysql/mysql.sock'
FP If I run mysql_config, this appears:
FP --socket /tmp/mysql.sock
FP What
Natale,
Friday, October 25, 2002, 10:08:00 AM, you wrote:
NB ok ... that's right for data (insert into ...) ... but
NB i get the error before ... when mysql try to create
NB child table:
NB CREATE TABLE ... idParent BIGINT, INDEX idpar_ind
NB (idParent), FOREIGN KEY (idParent) REFERENCES
NB
Could someone tell me where the logs are written to by default, for a 3.23
install of MySQL on Linux?
I looked in /usr/share/mysql/english and each directory leading up to it,
but I didn't see anything resembling a log file.
Thanks.
Neal
Christian,
- Original Message -
From: Christian Lizell [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, October 24, 2002 6:18 PM
Subject: Database in path to foreign key references
Hello!
Is there any way to get rid of the database name in the path to the
Could someone tell me where the logs are written to by default, for a 3.23
install of MySQL on Linux?
I looked in /usr/share/mysql/english and each directory leading up to it,
but I didn't see anything resembling a log file.
Thanks.
Neal
Logs are in your data directory with the Tables
neal,
Friday, October 25, 2002, 2:02:18 PM, you wrote:
n Could someone tell me where the logs are written to by default, for a 3.23
n install of MySQL on Linux?
n I looked in /usr/share/mysql/english and each directory leading up to it,
n but I didn't see anything resembling a log file.
By
* from bla where date like 20021025% order by date
DESC limit 20 searhc time is 2,4 to 3,2 seconds
what a hell is going on?
What can I do to fast up these quesry requests ??
Create an index on the field for the WHERE clause; like this (in Perl):
$sth = $dbh - prepare (ALTER table bla ADD
i tried it ... but nothing to do!
when mysql parse the foreign key in the create table i
get the error.
perhaps i'm wronging in restoring tables/db!
i use this method:
shell mysql -u user -ppassword dump file
is it wrong?
thanks.
Natale Babbo
--- Victoria Reznichenko
[EMAIL PROTECTED] ha
Hi There,
We have currently an Interbase Database with millions and millions of
rows which I would like
to migrate to MySQL if possible to increase the speed.
Transaction support is necessary, so I am using innoDB.
When inserting 160K rows in the database (in an innoDB table) it takes
about
Jeroen,
Two things are likely to make this umpteen times faster.
a) Commit the insert transaction every.. say 1000 records?
b) use mysql's extended insert statement,
insert into mytable values
(row1_field1,row1_field2),(row2_field1,row2_field2),(?,?),(?,?) etc etc
Ric.
- Original
innodb_data_file_path=ibdata1:100M:autoextended:max:200M
anyone knows what happen if the above innodb
tablespace reach the limit of 200M?
Thanks in advance.
Natale Babbo
sql
__
Mio Yahoo!: personalizza Yahoo! come piace a te
Fernando,
Thursday, October 24, 2002, 5:35:02 PM, you wrote:
FG I would like to know what is the difference between MySQL 4.0.4 MAX PRO.
Yes.
Here is described all packages:
http://www.mysql.com/news/article-111.html
--
For technical support contracts, goto
Natale,
Friday, October 25, 2002, 1:44:19 PM, you wrote:
NB i tried it ... but nothing to do!
NB when mysql parse the foreign key in the create table i
NB get the error.
NB perhaps i'm wronging in restoring tables/db!
NB i use this method:
shell mysql -u user -ppassword dump file
NB is it
Blain,
Friday, October 25, 2002, 2:11:11 AM, you wrote:
BN I've used MySQL before, a few years ago, under Slackware. I never could get it to
compile (despite
BN lots of help from folks here), but a pre-rolled binary did just fine for what I
needed at the time.
BN That system is no longer
Artem,
Friday, October 25, 2002, 12:55:14 AM, you wrote:
AK I have v.4.0.4b max nt, and I have the same result, even more:
AK mysql INSERT INTO settest SET chain=A,C;
AK ERROR 1062: Duplicate entry 'A,C' for key 1
AK mysql INSERT INTO settest SET chain=C,A;
AK ERROR 1062: Duplicate entry 'A,C'
Do you have a Linux user 'mysql', and does mysql own the database
directories/subdirectories/files ?
Blain Nelson wrote:
Howdy,
I've used MySQL before, a few years ago, under Slackware. I never could get it to compile (despite
lots of help from folks here), but a pre-rolled binary did just
Davide,
Friday, October 25, 2002, 11:57:23 AM, you wrote:
DP I'm new to MySQL. I am trying to set replication in MySQL but i get the
DP error in the subject.
DP Can you help me please?
Can you be more detailed?
What OS? What versions of MySQL servers? What did you done before you got
this
It would be helpful to know how much data you are trying to pump across.
If you are having trouble finishing in under 30 seconds over a 100mb
connection, it must be a lot of data.
The first thing to check is to make sure you have your connections set
to full duplex. Even if there are only two
mysql CREATE TABLE settest( chain SET( A, B, C ) NOT NULL,
UNIQUE INDEX ichain( chain ) );
mysql INSERT INTO settest SET chain=A,C;
mysql SELECT * from settest;
+---+
| chain |
+---+
| A,C |
+---+
mysql SELECT * FROM settest WHERE chain=A,C;
Millions of thanks!
Now it's working perfectly!!!
Once again MS bugs...
Regards
Juha
-Alkuperäinen viesti-
Lähettäjä: Terence [mailto:terencel;sunway.edu.my]
Lähetetty: 23. lokakuuta 2002 4:54
Vastaanottaja: Morsky Juha; [EMAIL PROTECTED]
Aihe: Re: Strange problem with MySql IIS ASP
[EMAIL PROTECTED] wrote:
The actual situation is a telecom analysis: a calls b
and a is suspect. Who are the people connected to a ?
we have call records of calls in tables
Ok, so you should have a table, I presume, like:
Callers: id (phone number)
Calls: id, callerid, calledid, startime,
Paul DuBois wrote:
No. mysqld --help shows --master-ssl, --master-ssl-key, and
--master-ssl-cert
options, but they're placeholders at the moment and haven't been
implemented.
Any examples of running mysql's replication over an ssltunnel link,
without damaging the local connections?
(I could
It may be a stupid question .I'm not able to download the mysql 4.1 win32
source distribution,As far as I seen
in the downloads page there exists only the binary version.
Where can I find source distribution
Thanks
-
Before
Hi,
mySQL 3.23.49 on Debian GNU/Linux 3.0, Kernel 2.4.19 on a Xeon 2 Ghz (1
CPU) and 2 GB DDR-RAM. The following problem arises:
All mysqld processes (UNIX) consume too much CPU power. There are
usually a 4-10 active processes that want 30% to 99.9% of CPU power -
EACH of them. top just showed
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 25 October 2002 14:50, Natale Babbo wrote:
innodb_data_file_path=ibdata1:100M:autoextended:max:200M
anyone knows what happen if the above innodb
tablespace reach the limit of 200M?
I would assume you will get an error: table space
John Coder wrote:
On Fri, 2002-10-25 at 00:14, Lewis Watson wrote:
- Original Message -
From: Mark Matthews [EMAIL PROTECTED]
To: Lewis Watson [EMAIL PROTECTED]
Sent: Thursday, October 24, 2002 8:40 PM
Subject: Re: Lost Connection
[snip]
OPS. Sorry, I have had my head up this bsd
Does no one know how to compile a program with the myisam
library?
I will gladly put together a simple document on it for others
if someone can just point me in the proper direction, i.e. which
header files are required (I get a bunch of warnings if I just
include myisam.h), and what the
IIRC Slackware 7 and 8 come with MySQL preinstalled.
But.. it does compile fine here.. on both 7 and 8. But you really have to
uninstall (pkgtool) the default installed.. next you follow all the staps
as explained in the MySQL manual (actually a file in the docs directory).
Have fun,
B.
At
My guess is that you can not operate the db when space is required and you
get error message. Like when trying to alter a table it will tell you that
the table is full. This is because MySQL will create a temporary table drop
the original and rename the new one.
HTH
JFernando
-Original
Hello mysql,
Often I've seen OPTION=16384 in a connection string
Whay does it mean?
--
Best regards
A backpacker in the foot hills of MySQL,
Arthur mailto:ArthurMaloney;seipas.com
-
Before
Hi,
After a little search, it seems to mean to treat BIGINT as INT.
Regards,
Jocelyn
- Original Message -
From: Arthur [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, October 25, 2002 4:59 PM
Subject: Connection
Hello mysql,
Often I've seen OPTION=16384 in a connection
Description:
I have the same problem as a previous mail :
# http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:107859
But I couldn't find the final issue (except adding every host in
my /etc/hosts file)
How-To-Repeat:
Run this command from a host that has no
Greetings everyone,
A quick question: Is phpmyadmin secure? Anyone have an negative experiences
having it installed on their server?
I found notes on one exploit, but in my google searches did not bring up
anything too serious.
Regards,
Mitchell
- sql query
A quick question: Is phpmyadmin secure? Anyone have an negative
experiences
having it installed on their server?
PHP itself is not secure unless special steps are taken to secure it, and
even then it's no guarantee. There have been several exploits published
against PHP, and a few of them
I don't want to start a flame but where do take this from?
Every security-hole in php has been fixed shortly after it was known.
Its as secure as any other server-side scripting-language in the web.
Thomas
On Fri, 25 Oct 2002 10:40:32 -0500 Ed Carp [EMAIL PROTECTED] wrote:
PHP itself is not
Unfortunately, when people suggest that they avoid PHP when they can it
usually means they don't understand much about the language or how to use it
appropriately.
That being said, I personally avoid .NET and FrontPage
MS
- Original Message -
From: Thomas Seifert [EMAIL PROTECTED]
To:
Hrm.
Yes, php can be vulnerable, but I was more worried about phpmyadmin and the
potential of direct access to my databases.
This particular server runs red hat 7.3, and they bundle php with their
distro. They also patch everything in their distros fairly regularly and I
subscribe to their
I just got done playing with this same scenario.
If the task finishes locally OK, but totally dogs on the network, then you
may have a network issue, NOT a MySQL issue.
1) Make sure that the switch and boxes are set to full duplex operation.
This will eliminate collisions. Make sure that
If one cannot avoid using PHP how can I secure it? I will initially have
it on the same server as IIS.
At 10:40 AM 10/25/2002 -0500, Ed Carp wrote:
A quick question: Is phpmyadmin secure? Anyone have an negative
experiences
having it installed on their server?
PHP itself is not secure
At 12:44 +0200 10/25/02, Natale Babbo wrote:
i tried it ... but nothing to do!
when mysql parse the foreign key in the create table i
get the error.
perhaps i'm wronging in restoring tables/db!
i use this method:
shell mysql -u user -ppassword dump file
is it wrong?
Depends.
- DId you add
At 11:41 +0200 10/25/02, Harald Fuchs wrote:
In article 000701c27193$1bf2bfa0$aa3fe7cb@jsheo,
Heo, Jungsu [EMAIL PROTECTED] writes:
Hello, every one.
I Found a bug about CASE .. WHEN .. THEN..
mysql SELECT VERSION() ;
++
| VERSION() |
++
| 4.0.3-beta |
sql, query (*sigh*, I hate this filter)
I have an auto_increment key set up on my InnoDB table.
Whenever I delete all the records, the number isn't reset.
However, for my ISAM tables, whenever I delete all the
records, the auto_increment number is reset.
Is there a reason for this in InnoDB? Is
Ok, dumb question, I'm getting an error when a connection is being made
from vpopmail with a qmail installation. I'm getting an access denied
for a user.. I've granted the user all the privs avail and still
denied.. where can I look in logs to find out why... I can't change the
password this is
Dobrý den,
sexta-feira, 25 de outubro de 2002, 14:26:05, napsal jste:
CB sql, query (*sigh*, I hate this filter)
CB I have an auto_increment key set up on my InnoDB table.
CB Whenever I delete all the records, the number isn't reset.
CB However, for my ISAM tables, whenever I delete all the
CB
Mitchell,
I run phpmyadmin at a freewebhost on RH 7.0/ Apache 1.3.22/ PHP 4.0.6/ MySQL 3.23.46
in multiuser mode with about 300 users for one year. Zero problems at all with the
software. The box got hacked but not because of vulnerabilities in phpmyadmin.
In time I use Usermin (plugin for
Description:
This is a simple bug with dates and 'between' operator. Full data is
supported below, but for the start I show the very essence of the problem. I
use the latest stable version of MySQL - 3.23.52.
SELECT weeks.ix FROM team, weeks WHERE
team.ix=6 AND
weeks.start team.ctime
[root@lhr root]# mysql_setpermission
Password for user to connect to MySQL:
Can't make a connection to the mysql server.
The error: Access denied for user: 'root@localhost' (Using password: YES)
at /usr/bin/mysql_setpermission line 65, STDIN line 1.
[root@lhr root]#
no sir same problem
I agree that whatever the app is, having the ability to unplug the
database (or for it to go down) and have there be a queue on the other
machine is ideal. This will mean that even if the db machine reboots
for whatever reason in the middle of the night, nobody will ever know
the difference.
1. When using GROUP BY it is not possible to order the rows before the grouping
takes place, is that right? Like, if you're selecting books, grouping on author, and
you want to show the first book of each author, you'd want to order by date and then
group by author?
2. Other grouping
Heh... it seems like a perfect solution to me... I am loading
a few million records a day into tables... building a new table
and swapping out the old... I have to process the data a little,
so to speed it up I've been forking children and passing 1
record files to load into LOAD DATA INFILE
These are good ideas. Just remember, if it ain't broke, don't fix it.
Unless I see performance degradation, I don't see the need to do
maintenance that could potentially create huge downtime (defrag doesn't
work, table files are permanently destroyed). The risks must be
weighed.
I used ext3
I think that's confusing, but right.
every null value is distinct, thus null != null.
weird, but null is not a value, it's the lack of a value, so nothing can
be shown about it.
so,
SELECT IF( NULL = NULL, 0 , 1 ) AS RESULT ;
is not the same as
SELECT IF( NULL is NULL, 0 , 1 ) AS RESULT ;
[root@lhr root]# mysql_setpermission
Password for user to connect to MySQL:
Can't make a connection to the mysql server.
The error: Access denied for user: 'root@localhost' (Using password: YES)
at /usr/bin/mysql_setpermission line 65, STDIN line 1.
[root@lhr root]#
no sir same problem
Hi, all,
I tried to use ERwin reverse engineer to automatic draw ER model diagram
for mysql database tables. Some of the tables have foreign key constraints.
But ERwin is not able to draw the line between parent table and child table.
Any one of you know how to solve this problem or any other
Hallo,
ich habe auf einem laufenden webserver mit mysql das verzeichnis
var/lib/mysql als tar file mit czpf erstellt und auf einem anderen
rechner an die selbe stelle entpackt.
Auf dem Quellrechner (System: Suse 7.2 als webserver mit apache 1.3.26
und tomcat 402) läuft mysql 3.23.49a-1und
CB However, for my ISAM tables, whenever I delete all the
CB records, the auto_increment number is reset.
CB Is there a reason for this in InnoDB? Is there a way that I
CB can reset the auto_increment number when all the records
CB are deleted?
try exec this query:
alter table TABLE_NAME
I agree that whatever the app is, having the ability to unplug the
database (or for it to go down) and have there be a queue on the other
machine is ideal. This will mean that even if the db machine reboots
for whatever reason in the middle of the night, nobody will ever know
the difference.
Thank you all for your suggestions. In response to an off-list suggestion, I decided
to not use the
default installation, and to try recompiling after deleting the initial package.
And it barfs on compile right at the point of this is going to take a while, if it
barfs, try configure
Hi!
sind alle Rechte an den entpackten Dateien an den Benutzer übertragen worden, unter
dem der MySQL Server auf RH gestartet wurde? ps -uax zeigt den an.
Beispiel: User mysql, Group mysql
als root:
bash# chown -R mysql:mysql /var/lib/mysql
Das hatte ich schon mal nach einem Restore von db's
Hi,
What method are you using for inserting the data?
Individual INSERTs can be very slow:
INSERT INTO foo (x, y, z) VALUES (1, 2, 3);
INSERT INTO foo (x, y, z) VALUES (4, 5, 6);
...
Batch INSERTs can be massively faster:
INSERT INTO foo (x, y, z) VALUES (1, 2, 3),
I'll agree to this somewhat:
(1) always bind your variables. whatever code you are using to do your
inserts, the fewer prepared statements you can make the better.
for example:
insert into TableName (col1, col2, col2, col4) values (?,?,?,?)
then, once you have a prepared statment, do a loop and
Recently, something happened on my system that I'm not sure I could ever
explain. I'm curious if the expertise of the list might be able to help me
out. Please speak layman terms, as I'm forced to jump in this without
testing the waters...
I was working fine with MSAccess 97 to MySQL (ver
Jeroen Geusebroek wrote:
[snip]
You where right, what i did use indivudual inserts. Now I have it
segmented in 1000 rows in one query which massively speeds up the whole
inserting progress. 160K records now takes about 20 seconds instead of
the 100 records ;) I'm really impressed by this massive
At 3:02 -0800 10/25/02, neal wrote:
Could someone tell me where the logs are written to by default, for a 3.23
install of MySQL on Linux?
To the data directory. The location of this may vary per installation,
but you can discover it with this query:
SHOW VARIABLES LIKE 'datadir';
I looked
forgive me.
i was initially using the perl DBI methods to load. I am not intimately
familiar with the inner workings of DBI, but obviously it must be doing
something if you say mysql does not support binding variables
(i am using 4.0.4). This is significantly faster than creating a new
prepared
Sorry if this not on the exact mysql subject. I have an upcoming project
that requires use of a SQL database system. I wanted to use mysql but mysql
is not available for OpenVMS (thread issue as I understand it). Does anyone
know of something out there that would be on the same order as mysql for
If you are worried about security, don't run IIS! Now, that's
insecure! Use Apache, this also runs fine on windows.
PHP is as insecure as own programming is. If you program securely
then so is PHP.
My 2 cents.
-Original Message-
From: John Chang [mailto:johnec;umich.edu]
Sent: vrijdag
At 11:26 -0500 10/25/02, Chris Boget wrote:
sql, query (*sigh*, I hate this filter)
I have an auto_increment key set up on my InnoDB table.
Whenever I delete all the records, the number isn't reset.
However, for my ISAM tables, whenever I delete all the
records, the auto_increment number is
i understand there are other ways of encrypting the traffic, i am just
curious if there are any that employed internally in mysql. thanks.
-chris
-Original Message-
From: Ronald Petty [mailto:ron.petty;unigeek.com]
Sent: Thursday, October 24, 2002 6:51 PM
To: Lists @ Apted Technologies
I know I'm not the only one experiencing this problem. The solutions
recommended in the documentation haven't helped resolve it. I've heard of
people using flush-hosts as a solution, but that's just a band-aid. Any
ideas?
- Original Message -
From: Andy Etemadi [EMAIL PROTECTED]
To:
At 14:50 +0200 10/25/02, Natale Babbo wrote:
innodb_data_file_path=ibdata1:100M:autoextended:max:200M
anyone knows what happen if the above innodb
tablespace reach the limit of 200M?
It stops getting bigger. :-)
What do you mean by what happen? That is, what are the conditions
for which you
Hi there,
I would like to know, if it's possible in the mysql to
use two tables as if they were one and have an index
that would use columns of these two tables?
Thanks,
Andre
__
Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site
I just got done playing with this same scenario.
If the task finishes locally OK, but totally dogs on the network, then you
may have a network issue, NOT a MySQL issue.
1) Make sure that the switch and boxes are set to full duplex operation.
This will eliminate collisions. Make sure
Jeff Mathis wrote:
forgive me.
i was initially using the perl DBI methods to load. I am not intimately
familiar with the inner workings of DBI, but obviously it must be doing
something if you say mysql does not support binding variables
(i am using 4.0.4). This is significantly faster than
78 matches
Mail list logo
