diff options
| author | Georgi Kodinov <joro@sun.com> | 2010-04-12 11:56:28 +0300 |
|---|---|---|
| committer | Georgi Kodinov <joro@sun.com> | 2010-04-12 11:56:28 +0300 |
| commit | f34a731b6a3ae0b2f1d9a3e8f9d987873ceaf32b (patch) | |
| tree | b33397c22c12e2819905c992ba99f85db8dae347 /scripts/mysqlhotcopy.sh | |
| parent | 97afbf5a279363e2052f97c96af4e36dfe7dd30a (diff) | |
| download | mariadb-git-f34a731b6a3ae0b2f1d9a3e8f9d987873ceaf32b.tar.gz | |
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.
Diffstat (limited to 'scripts/mysqlhotcopy.sh')
| -rw-r--r-- | scripts/mysqlhotcopy.sh | 8 |
1 files changed, 8 insertions, 0 deletions
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; |