Re: INNODB data porting problem.

[Barry]

In that case I have to write the foreign key checks all over again in the
new DB. Also doen't it create the a MyISAM DB when we remove the foreign key
checks. What I am looking at is an exact replica of the INNODB database. Is
it possible ?

Regards
Barry

----- Original Message -----
From: "Victoria Reznichenko" <victoria.reznichenko@stripped>
To: <mysql@stripped>
Sent: Wednesday, September 10, 2003 1:27 PM
Subject: Re: INNODB data porting problem.


> "Barry" <barry@stripped> wrote:
> >    It seems there's a problem while the database is getting dumped coz
it
> > gives an error saying that it was unable to create a particular ".frm"
file.
> > Can't seem to figure out the reason. Any help would be really welcome.
Could
> > there be a possible problem because of the foreign key constraints in
the
> > table . In that case what would be the possible mechanism for porting
data
> > from one database to the other "short of creating a manual script for
it"?
>
> Use
> SET FOREIGN_KEY_CHECKS=0;
>
> to turn foreign key checks off:
> http://www.mysql.com/doc/en/InnoDB_foreign_key_constraints.html
>
>
> --
> For technical support contracts, goto https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.net http://www.ensita.net/
>    __  ___     ___ ____  __
>   /  |/  /_ __/ __/ __ \/ /    Victoria Reznichenko
>  / /|_/ / // /\ \/ /_/ / /__   Victoria.Reznichenko@stripped
> /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
>        <___/   www.mysql.com
>
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>