On Wednesday 02 February 2005 14:11, Michael Satterwhite might have typed: > mysqldump backs all of the tables up in alphabetic order, including the > table create statements. The problem is that if foreign keys exist on > the tables, the reload will not work unless the backup file is hand > edited to insure that tables depended upon are created first. Is there a > way around this? If not, shouldn't the tables be created first and the
From mysqldump that ships with 4.1: -- MySQL dump 10.8 -- -- Host: localhost Database: -- ------------------------------------------------------ -- Server version 4.1.7 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; . . . . SET [EMAIL PROTECTED]; SET [EMAIL PROTECTED]; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]