On Mon, 1 Jul 2002, Jesse Sheidlower wrote: > 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, use mysqldump --opt --add-drop-table database > dbbackupJuly1-02 Be careful: this drops each table before recreating it. Thomas --------------------------------------------------------------------- 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
