Hi, with this patch if you use mysqldump with -c the db name will precede the table name. Hopefully this will solve the replication problem I described earlier.
ico
--- mysqldump.c.orig 2004-02-10 19:15:59.000000000 +0100 +++ mysqldump.c 2004-05-11 17:33:16.407884792 +0200 @@ -670,7 +670,7 @@ } if (cFlag) - sprintf(insert_pat, "INSERT %sINTO %s (", delayed, opt_quoted_table); + sprintf(insert_pat, "INSERT %sINTO %s.%s (", delayed, db, opt_quoted_table); else { sprintf(insert_pat, "INSERT %sINTO %s VALUES ", delayed, @@ -732,7 +732,7 @@ fprintf(sql_file, "CREATE TABLE %s (\n", result_table); } if (cFlag) - sprintf(insert_pat, "INSERT %sINTO %s (", delayed, result_table); + sprintf(insert_pat, "INSERT %sINTO %s.%s (", delayed, db, result_table); else { sprintf(insert_pat, "INSERT %sINTO %s VALUES ", delayed, result_table);
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]