From 20ef52e61209d149ad3c69e0a07773e4dc34dc2f Mon Sep 17 00:00:00 2001
From: Georgi Kodinov <joro@sun.com>
Date: Mon, 12 Apr 2010 11:56:28 +0300
Subject: Bug #43594: mysqlhotcopy does not ignore log tables and others in
 mysql database

Added a filter to mysqlhotcopy to filter out the same tables in the 'mysql'
database that mysqldump filters out.
---
 scripts/mysqlhotcopy.sh | 8 ++++++++
 1 file changed, 8 insertions(+)

(limited to 'scripts/mysqlhotcopy.sh')

diff --git a/scripts/mysqlhotcopy.sh b/scripts/mysqlhotcopy.sh
index 21fca0c0848..398573875d9 100644
--- a/scripts/mysqlhotcopy.sh
+++ b/scripts/mysqlhotcopy.sh
@@ -267,6 +267,14 @@ foreach my $rdb ( @db_desc ) {
     my $db = $rdb->{src};
     my @dbh_tables = get_list_of_tables( $db );
 
+    ## filter out certain system non-lockable tables. 
+    ## keep in sync with mysqldump.
+    if ($db =~ m/^mysql$/i)
+    {
+      @dbh_tables = grep 
+        { !/^(apply_status|schema|general_log|slow_log)$/ } @dbh_tables
+    }
+
     ## generate regex for tables/files
     my $t_regex;
     my $negated;
-- 
cgit v1.2.1