At 22:10 +0000 11/21/02, Jannie Qu wrote:
>I try to use a mysqldump file from development database and insert
>back into production database on another server.
>bkp_dbname.sql is copied over to prodution, and I am using the
>following command at production.
>shell> mysql -ujqu -pjqu1234@ dbname < bkp_dbname.sql
>File bkp_dbname.sql contains "create table, insert into table..."
>Tables are all innoDB tables with foreign keys.
>How can I disable foreign_key_check at shell prompt.
You can't. But you can do this instead:
shell> mysql -ujqu -pjqu1234@ dbname
mysql> set foreign_key_check=0;
mysql> source bkp_dbname.sql;
>MySQL 3.23.53 with Innodb enabled on Mac OS 10.1