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" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, September 10, 2003 1:27 PM Subject: Re: INNODB data porting problem. > "Barry" <[EMAIL PROTECTED]> 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 > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ 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/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
