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 | 20ef52e61209d149ad3c69e0a07773e4dc34dc2f (patch) | |
| tree | b33397c22c12e2819905c992ba99f85db8dae347 /scripts/mysqlhotcopy.sh | |
| parent | 9d59b2705a696545d12f849e01ad40f95b17f1cb (diff) | |
| download | mariadb-git-20ef52e61209d149ad3c69e0a07773e4dc34dc2f.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; |