bzr commit into mysql-5.1-bugteam branch (joro:3451) Bug#43594

[Georgi Kodinov]

#At file:///home/kgeorge/mysql/work/B43594-5.1-bugteam/ based on revid:davi.arnaut@stripped

 3451 Georgi Kodinov	2010-04-12
      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.

    modified:
      scripts/mysqlhotcopy.sh
=== modified file 'scripts/mysqlhotcopy.sh'
--- a/scripts/mysqlhotcopy.sh	2009-04-28 16:16:17 +0000
+++ b/scripts/mysqlhotcopy.sh	2010-04-12 08:56:28 +0000
@@ -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;


Attachment: [text/bzr-bundle] bzr/[e-mail]