Terence,
----- Original Message ----- From: "Terence" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, December 22, 2004 5:58 AM
Subject: mysqldump and innodb - set foreign_key_checks=0
Hi,
After reading the docs I realise that in order to use mysqldump with innodb tables i need to include
SET FOREIGN_KEY_CHECKS=0;
at the top of my dump file. Is there anyway to do this when my slave starts up or some other way. The dump file is huge and it takes ages to open and put the line at the top. (In trying to setup replication I am trying all ways to reduce the downtime of the master while I get a snapshot onto the slave)
I use ./bin/mysql -u root -p < /tmp/dump.sql to get the contents into my slave.
Something like this might work: ./bin/mysql -u root -p -e "SET FOREIGN_KEY_CHECKS=0;" < /tmp/dump.sql
in 4.1, mysqldump puts that
SET FOREIGN_KEY_CHECKS=0;
automatically to the dump file.
Grateful for and ideas ...
Thanks
Best regards and Season's Greetings,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables
http://www.innodb.com/order.php
Order MySQL technical support from https://order.mysql.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
