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
