Thanks, marc.
-Don
-Original Message-
From: Mechain Marc [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 27, 2004 12:23 PM
To: Don Vu; [EMAIL PROTECTED]
Subject: RE: FKs in InnoDB
SHOW TABLE STATUS
In the "Comment" Column you have the definition of the foreign k
Hi,
I'm using MySQL 4.0.16 with InnoDB tables.
>From the command-line mysql console Is there an easy way to see all the
names of the foreign keys in my db? Basically I want to generate a file
that drops all the foreign keys currently in my db.
thanks,
Don
Hi guys,
Do both MyISAM tables and INNODB tables support foreign keys in 4.0.15?
If so, are the main advantages of using INNODB tables the added features
of transactions, cascading deletes, and it's other more robust features?
Any thoughts on any disadvantages of INNODB to MyISAM? I know that
INS
2) in the instance of having a bunch of locks, is there any way to track
down the query that orignated a cascade of locks?
thanks in advance for the help.
-Don
----------
Don Vu > Madstone Theaters
85 fifth avenue, 12th floor > new
grity over speed but that's just me...
take care,
d
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 14, 2003 5:00 PM
To: Peter Grigor; Don Vu; MySQL Mailing List (E-mail)
Subject: Re: Invalid Date Bug
At 16:55 -0500 2/14/03, Peter Grigor wrote:
&g
--++
|1 | 2002-06-31 |
+--++
1 row in set (0.00 sec)
----------
Don Vu > Madstone Theaters
85 fifth avenue, 12th floor > new york > new york > 10003
p 212.379.154
t script, even when i log into mysql from a different folder than where it lives.
Can people just not run scripts which they own? What am I missing?
thanks,
Don
----------
Don Vu > Database Engineer > Madstone Theaters
85 fift
if you don't restart MySQL after changing the grants priviliges, you have to issue the
"flush privileges" command from the MySQL Monitor. If you don't do either one your
privilege changes will not take affect.
not sure if when you said "reloaded" you meant "flush privileges" but if not try it
info than "show
processlist"
- other userful dba stuff?
thanks,
Don
------
Don Vu > Database Guy > Madstone Films
85 fifth avenue, 12th floor > new york > new york > 10003
p 212.989.4500 > f 212
agreed...
-Original Message-
From: Gelu Gogancea [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 20, 2002 12:06 PM
To: Nilesh Shah; [EMAIL PROTECTED]
Subject: Re: Separate List For administration
..Subscribe
- Original Message -
From: "Nilesh Shah" <[EMAIL PROTECTED]>
To
mabye an insert into...select will work, something like:
INSERT INTO
SELECT Code, Model, Units
from
where Year=2003
and ((Code = 'N200') or (Code='N205'));
http://www.mysql.com/doc/I/N/INSERT_SELECT.html
-Don
-Original Message-
From: Carlos Fernando Scheidecker Antunes [mailto:[EM
if you do mysqldump -d -p -u > then it will pipe
only the CREATE TABLE statements and no insert statements into .
-Don
-Original Message-
From: Erik Price [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 14, 2002 4:39 PM
To: Hihn Jason
Cc: [EMAIL PROTECTED]
Subject: Re: Reconstructing S
Hey guys,
there are 2 files in my /tmp directory that look like mysql datafiles:
#sql208_ecc_0.MYD
#sql208_ecc_0.MYI
They're on the same box as our development mysql instance but I don't see them on any
of our other instances. Anyone have any idea what they are/if I can delete them?
They're c
s are appreciated,
Don
------
Don Vu > Database Guy > Madstone Films
85 fifth avenue, 12th floor > new york > new york > 10003
p 212.989.4500 > f 212.989.7744
there are limitations of course but you could also just do a mysqldump of all the data
and re-create the database
-Don
-Original Message-
From: Gelu [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 07, 2002 12:31 PM
To: Yvon Darang; [EMAIL PROTECTED]
Subject: Re: MySQL From Windows to
more detail on this can be found here
http://www.mysql.com/doc/M/u/Multiple_servers.html
-Original Message-
From: Gurhan Ozen [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 06, 2002 3:10 PM
To: Luc Foisy; MYSQL-List (E-mail)
Subject: RE: Two database servers, same physical server
Hi,
To
make sure the directory where mysqladmin lives is in your $PATH in that script, i.e.
add $PATH=$PATH:/usr/local/bin (or where ever it is...) in the beginning of your
script where environment variables are set.
-Don
-Original Message-
From: Dion Wickander [mailto:[EMAIL PROTECTED]]
Sent
, 1 row affected' message
-Don
> -----Original Message-
> From: Don Vu
> Sent: Monday, April 08, 2002 11:08 AM
> To: MySQL Mailing List (E-mail)
> Subject: char() function
>
> Hi guys,
>
> Our java code blows up when we try to insert a s
Hi guys,
Our java code blows up when we try to insert a string with a ';' inside of it. So we
tried to do a work-around by replacing ';' with '||CHAR(59)||' to insert it, using the
char function and the character's respecitve ascii value. So instead of:
insert into table (key, field) values (1
Hey guys,
We're having a weird authentication problem. We have a .jsp (on box1) that tries to
connect to a MySQL database (on box2). The privileges have been set to give insert,
update, delete to the user.
GRANT select, insert, update
on d_name.*
to d_user IDENTIFIED by "d_user";
It works fi
20 matches
Mail list logo