Thanks for all the responses on how to import a dump file that will not write over existing tables and not stop with an error on existing tables - in other words just add missing tables. As Victoria pointed out, there is no option in mysqldump to add the appropriate create table option [IF NOT EXISTS] but one can add the --force option when importing the dump file back in with mysql. This causes mysql to ignore the error generated when it comes across a table that already exists and it will continue on adding any tables that are missing. Without it, mysql will stop on the first table that already exists with an error. An alternative solution is running a script on the dump file to replace all occurrences of " CREATE TABLE " with " CREATE TABLE IF NOT EXISTS " as suggested by Clayburn. Thanks again!
John --------------------------------------------------------------------- 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
