On Mon, Jul 01, 2002 at 01:23:38PM -0400, Keith C. Ivey wrote: > On 1 Jul 2002, at 12:30, Jesse Sheidlower wrote: > > > What should I be doing instead? The docs don't seem to specify this, > > and there doesn't seem to be an "ignore" or "replace" option for the > > mysql command. Do I actually have to drop all the tables on my > > development box before loading in from the backup? > > Have you seen the --add-drop-table option (see > http://www.mysql.com/doc/m/y/mysqldump.html), or is that what you > mean by your reference to dropping the tables?
Thanks to all who responded with this general suggestion. I had looked at the --opt option, but ignored it as speed wasn't a real issue for this. And it didn't occur to me that this would be something to specify in the backup, rather than the restore. > Without dropping the tables, how would you get rid of records that > have been deleted? Well, I said in the subject line it was a stupid question! > (Still writing for "Copy Editor"?) Yup. Jesse "MySQL Query" Sheidlower <[EMAIL PROTECTED]> --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
