#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/joro@sun.com-20100412085628-gcmgzki2lbzcb7lh.bundle
Thread |
---|
• bzr commit into mysql-5.1-bugteam branch (joro:3451) Bug#43594 | Georgi Kodinov | 12 Apr |