[patch] Patch to fix mysql bug #27303

mysqlhotcopy-fix-database-names.patch (text/plain), 1.26 KB, created by Adam James on 2007-12-12 15:30:14 UTC

--- mysqlhotcopy.orig	2007-12-12 15:22:04.000000000 +0000
+++ mysqlhotcopy	2007-12-12 14:50:35.000000000 +0000
@@ -333,7 +333,7 @@
 
     $rdb->{files}  = [ @db_files ];
     $rdb->{index}  = [ @index_files ];
-    my @hc_tables = map { quote_names("$db.$_") } @dbh_tables;
+    my @hc_tables = map { quote_names("$_") } @dbh_tables;
     $rdb->{tables} = [ @hc_tables ];
 
     $rdb->{raid_dirs} = [ get_raid_dirs( $rdb->{files} ) ];
@@ -464,13 +464,15 @@
 }
 else {
     my $start = time;
+    $hc_locks =~ s/\`//g;
+    $hc_tables =~ s/\`//g;
     $dbh->do("LOCK TABLES $hc_locks");
     printf "Locked $num_tables tables in %d seconds.\n", time-$start unless $opt{quiet};
     $hc_started = time;	# count from time lock is granted
 
     # flush tables to make on-disk copy uptodate
     $start = time;
-    $dbh->do("FLUSH TABLES /*!32323 $hc_tables */");
+    $dbh->do("FLUSH TABLES");
     printf "Flushed tables ($hc_tables) in %d seconds.\n", time-$start unless $opt{quiet};
     $dbh->do( "FLUSH LOGS" ) if ( $opt{flushlog} );
     $dbh->do( "RESET MASTER" ) if ( $opt{resetmaster} );
@@ -478,7 +480,7 @@
 
     if ( $opt{record_log_pos} ) {
 	record_log_pos( $dbh, $opt{record_log_pos} );
-	$dbh->do("FLUSH TABLES /*!32323 $hc_tables */");
+	$dbh->do("FLUSH TABLES");
     }
 }