InnoDB Hot Backup-0.33 beta is now available for Windows NT/2000/XP and
Linux.
Any plans for Solaris by the May 2002 release date?
From: Heikki Tuuri [EMAIL PROTECTED]
The beta testing of InnoDB Hot Backup (a non-free add-on tool) started on
Monday. If you want to take part in the beta
Hi,
On Thu, 2002-03-07 at 08:20, bin cai wrote:
I am encountering one problem. I am using mysql as the
dabase for my application.
I create a table like takeexam as following:create
table takelabexam( sid varchar(10) not null,
cid varchar(20) not null,
Using foreign keys is a really, really good idea. Programs can't be
trusted (and what about running sql queries ad hoc). Even with a really
big database I wouldn't get rid of the keys, just time to move to a
bigger better machine/configuration.
-Original Message-
From: David Felio
Martin,
-Original Message-
From: Martin Bratbo [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Date: Saturday, February 16, 2002 4:46 PM
Subject: Re: Re: Foreign keys in InnoDB tables
Heikki
here is the statements that i cant get to work:
first I create one innoDB table: fk1
Martin,
there is a bug in 4.0.1 which can make a foreign key definition to fail in
an assertion failure in dict0crea.c, if you have set default-character-set
to something else than latin1 in my.cnf.
Harald Fuchs reported the bug on this mailing list a couple of days ago, and
the bug is now
Pierre,
I tested this with versions 3.23.46 and .48 on Linux and they worked ok:
mysql CREATE TABLE FIRST (NAME VARCHAR(15), COD VARCHAR(10) NOT NULL,
PRIMARY
- KEY(COD)) TYPE=INNODB;
Query OK, 0 rows affected (0.02 sec)
mysql CREATE TABLE SECOND (ID INT NOT NULL, F_COD VARCHAR(10),
Hi!
With InnoDB tables under 3.23.4x, if you perform an ALTER TABLE on
a table, any foreign key declarations that point to that table fail
to work (they always return a failure).
Is this a known bug? I don't see it on the InnoDB todo or bug
list, but I seem to remember hearing about it
On Thu, Jan 03, 2002 at 01:48:21PM +0200, Heikki Tuuri wrote:
: Hi!
:
: This is a feature (= documented bug). Look at
: http://www.innodb.com/ibman.html:
: ...
: Updated December 13, 2001: Added a note that you should not do an ALTER
: TABLE to a table which has or is referenced in a foreign key
Hi!
-Original Message-
From: Philip Molter [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Thursday, January 03, 2002 3:21 PM
Subject: Re: FOREIGN KEYs and ALTER TABLE
On Thu, Jan 03, 2002 at 01:48:21PM +0200, Heikki Tuuri wrote:
: Hi
Hrmm. Is that a feature that's planned to be fixed. Obviously,
if you have a table with thousands or millions of rows in it, ALTER
TABLE is a lot easier than copying the table to a temp table,
dropping the original table, creating a new table, and copying the
data back in.
Actually,
On Thu, Jan 03, 2002 at 05:21:49PM +0200, Heikki Tuuri wrote:
: mysql CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=INNODB;
: Query OK, 0 rows affected (0.11 sec)
:
: mysql CREATE TABLE child(id INT, parent_id INT, INDEX par_ind (parent_id),
: - FOREIGN KEY
Hi!
Use SELECT INTO OUTFILE + READ DATA INFILE
Do not rename tables.
Regards,
Heikki
-Original Message-
From: Philip Molter [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Thursday, January 03, 2002 5:54 PM
Subject: Re: FOREIGN KEYs
Rolf Hopkins writes:
You can still use foreign keys, just that it has no effect in mysql.
Yes, I know. I just would like to provide the information in the
CREATE TABLE definition and be able to retrieve it later.
Nothing more.
The manual says:
In the near future we will extend the
On Thu, 5 Apr 2001, Dennis Gearon wrote:
Date: Thu, 05 Apr 2001 14:24:25 -0700
From: Dennis Gearon [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Foreign Keys
Are people using Mysql using foreign keys and how are they using them?
It seems that the way to use them is with
On Thu, 5 Apr 2001, Dennis Gearon wrote:
Date: Thu, 05 Apr 2001 14:24:25 -0700
From: Dennis Gearon [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Foreign Keys
Are people using Mysql using foreign keys and how are they using them?
It seems that the way to use them is with the scripting
On Thu, 5 Apr 2001, Dennis Gearon wrote:
Are people using Mysql using foreign keys and how are they using them?
It seems that the way to use them is with the scripting language used to
access the database.
Sure we are...the manual way i.e. one insert/delete at a time for each foreign key
101 - 116 of 116 matches
Mail list logo