If a table has a blob type containing binary data, like jpeg images or PDF
files for example, can mysqldump be told to encode the data so it is ASCII
compatible? (using uuencode or something like that..)
I am not sure of the 'right' way to do this, but some informal tests where I
dump and
in production work?
Thanks much,
-Bob
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 12, 2002 4:50 AM
To: Bob McLaughlin; MySQL Mailing List
Subject: Re: Foreign keys in mysqldump?
Bob,
I have now improved foreign key support so that version
When I do a mysqldump and include table creation, it does not seem to
include the foreign key constraints in the create table statements of the
InnoDB tables.
Is there a command line switch or other way to make this happen?
Thanks,
-Bob
A humble suggestion for the development team
I went through and looked at some of the postings regarding using ALTER
TABLE with InnoDB tables and the resulting loss of foreign key constrains. I
was disappointed to learn about the need to use the create/drop workaround.
The main reason I