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? 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? Is any of the above limited to the InnoDB type? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
