On Tue, 6 Jan 2004, Luc Foisy wrote: > There was a user comment under the Foriegn Key section of the documentation reading: > To restore from a mysqldump file that uses foreign keys: > > mysql> SET FOREIGN_KEY_CHECKS = 0; > mysql> SOURCE your_dump_file; > mysql> SET FOREIGN_KEY_CHECKS = 1; >
> The command I am looking for is the call SOURCE. Where is this in the documentation? http://www.mysql.com/doc/en/Batch_Commands.html > Also, will this FOREIGN_KEY_CHECKS ignore the definitions while creating the tables, > as in not create them, or just merely not check for its consitancy? Just doesn't check if there's a valid value in the parent table that it refers to and will not give an error. > Is any of the above limited to the InnoDB type? Both -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]