i think you can use -K on your mysqldump and it'll put the hints in there
for the mysql command to use as well
----- Original Message -----
From: "Daniel Kasak" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Thursday, September 29, 2005 7:45 PM
Subject: Backup / Restore database with foreign keys
Greetings.
I've just hit an interesting problem. Luckily I don't actually *need* to
restore from a backup right now - I'm just trying to create a database
dump to submit an unrelated bug report.
Anyway ...
I'm using the command:
mysqldump -K DATABASE_NAME > db.sql -p
However when I create a new database and try to load the dump file:
mysql NEW_DATABASE < db.sql -p
I get an error when I hit an InnoDB table that has a relationship set up
with a table that hasn't yet been created. How do I get around this?
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
