[PATCH] for mysqldump: full insert statements (db.table) with -c

[Nico Sabbi]

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]