FKs in InnoDB

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

RE: FKs in InnoDB

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 keys. Marc

INNODB vs MyISAM

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

locked threads

) 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 york new york

Invalid Date Bug

| +--++ 1 row in set (0.00 sec) -- Don Vu Madstone Theaters 85 fifth avenue, 12th floor new york new york 10003 p 212.379.1545 f 212.989.7744 www.madstonefilms.com

RE: Invalid Date Bug

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: Yep, you're

running sql scripts with 'source'

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 fifth avenue, 12th floor new york new york

RE: Grants UGGH! Not working for some reason ...

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 and

dba scripts

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.989.7744 www.madstonefilms.com

RE: Separate List For administration

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:

RE: How to duplicate records

mabye an insert into...select will work, something like: INSERT INTO new tablename SELECT Code, Model, Units from original table 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

RE: Reconstructing SQL create table statements

if you do mysqldump -d -p -u USERNAME DATABASENAME FILENAME then it will pipe only the CREATE TABLE statements and no insert statements into FILENAME. -Don -Original Message- From: Erik Price [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 4:39 PM To: Hihn Jason Cc: [EMAIL

files in /tmp

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

data warehousing

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 www.madstonefilms.com

RE: MySQL From Windows to Linux

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

RE: Two database servers, same physical server

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

RE: OSX Mysqladmin and Cron

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]]

char() function

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

RE: char() function

-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 string with a ';' inside of it. So we tried to do a work-around by replacing

authentication problem

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