Nico Rittner wrote:
> Hi Frank
>
>> what I meant was: are you sure that the tables which are in your database
>> are defined correctly, i.e. have the actions?
> Yes, if i try to delete or update a record which is referenced by another
> i get mysql error #1217 , which should be correct.
>
>> mig
Hi Frank
> what I meant was: are you sure that the tables which are in your database
> are defined correctly, i.e. have the actions?
Yes, if i try to delete or update a record which is referenced by another
i get mysql error #1217 , which should be correct.
> might have been "lost" somewhere. Ca
Nico Rittner wrote:
> Hallo,
>
>> Sorry to ask this questions, but are you confident that the action
>> clauses work properly, i.e. the tables were created correctly?
>
> In the case of a crash i need to restore the dump including
> the on delete/update clauses.
>
>> What do you see when you ex
Hallo,
> Sorry to ask this questions, but are you confident that the action clauses
> work properly, i.e. the tables were created correctly?
In the case of a crash i need to restore the dump including
the on delete/update clauses.
> What do you see when you execute "show create table groups"?
C
Nico Rittner wrote:
> hi,
>
>> are you using the InnoDB storage engine for your tables?
> yes, i do.
>
> example:
>
> $ mysqldump -d core groups :
>
> CREATE TABLE `groups` (
> `id` smallint(5) unsigned NOT NULL default '0',
> `name` varchar(32) NOT NULL default '',
> `parent_id` smallint(5) u
hi,
> are you using the InnoDB storage engine for your tables?
yes, i do.
example:
$ mysqldump -d core groups :
CREATE TABLE `groups` (
`id` smallint(5) unsigned NOT NULL default '0',
`name` varchar(32) NOT NULL default '',
`parent_id` smallint(5) unsigned default NULL,
`setting_` text NOT NULL
Nico Rittner wrote:
> hello,
>
> does anybody now how mysqldump handles the actions
> for 'on delete' and 'on update' ? In my Version 4.1.14
> the action clauses are missing. When reimporting the
> dump, how does mysql know about the 'action' when altering
> the table with forein keys.
>
> Thank
hello,
does anybody now how mysqldump handles the actions
for 'on delete' and 'on update' ? In my Version 4.1.14
the action clauses are missing. When reimporting the
dump, how does mysql know about the 'action' when altering
the table with forein keys.
Thanks,
Nico
--
MySQL General Mailing Li
Hello.
Put SET FOREIGN_KEY_CHECKS=0 at the top of your dump file. In 4.1,
mysqldump puts that automatically to the dump file. See comments at:
http://dev.mysql.com/doc/mysql/en/mysqldump.html
Michael Satterwhite <[EMAIL PROTECTED]> wrote:
> mysqldump backs all of the tables up in alpha
On Wednesday 02 February 2005 14:11, Michael Satterwhite might have typed:
> mysqldump backs all of the tables up in alphabetic order, including the
> table create statements. The problem is that if foreign keys exist on
> the tables, the reload will not work unless the backup file is hand
> edited
mysqldump backs all of the tables up in alphabetic order, including the
table create statements. The problem is that if foreign keys exist on
the tables, the reload will not work unless the backup file is hand
edited to insure that tables depended upon are created first. Is there a
way around t
lto:[EMAIL PROTECTED]]
Sent: Wednesday, March 20, 2002 9:35 PM
To: Chetan Lavti
Subject: Re: mysqldump and foreign keys (possible Bug ??)
No, not working,
When I run the command
SHOW TABLE STATUS FROM yourdatabasename LIKE 'T';
shown in the manual (7.5.4.2 Foreign Key Constraints)
I will see
hi,
I am also using the Innodb table type for my database. when I am using
the mysqldump for dumping the tables it really doesn't shows the
foreign key in the table structure.
but if after deleting my previous database I again create my database
using the same dumped file and executes the
mysql
Hi,
I just installed the MySQL max 4.0.1 and created a database with two
INNODB and FOREIGN KEY tables as described in the Docs.
When I run the "mysqldump -a -B -c test" I don't get the foreign key
information.
Any hint?
Adib.
---
14 matches
Mail list logo