Jesse, try to make dump (mysqldump) with option "--add-drop-table" or "--opt" (it will be faster). Description of this options see here http://www.mysql.com/doc/m/y/mysqldump.html
Best regards, Mikhail. ----- Original Message ----- From: "Jesse Sheidlower" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 01, 2002 6:30 PM Subject: Stupid backup/restore question > > I have a working server and a development server. From time to time > I'd like to "refresh" the content of my development server with what's > on my working server. So I take one of my regular backups, that I get > by doing "mysqldump database > dbbackupJuly1-02". Then I gzip this, > ftp it over to my development server, gunzip it, and try "mysql > database < dbbackupJuly1-02", and immediately get an "ERROR 1050 at > line 11: Table 'firsttable' already exists" message. > > 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? > > Jesse 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 > --------------------------------------------------------------------- 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
