Hi, all,
sql, query.
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.
Background info:
MySQL 3.23.53 with Innodb enabled on Mac OS 10.1
Thank you,
jing
_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php