Menu

#68 cannot exclude tables with "." in database name

v3.0_testing
open
nobody
5
2012-08-27
2012-08-27
mdi
No

cannot exclude tables with "." in database name
around line 513 automysqlbackup-v3.0_rc6.tar.gz

r='^[^*]+\.[^.]+$'; [[ "$i" =~ $r ]] || { printf 'The entry %s in CONFIG_table_exclude has a wrong format. Ignoring the entry.' "$i"; continue; }
db=${i%.*}
table=${i#"$db".}

# r='^[^*.]+\.[^.]+$'; does not allow for ".' database name, it gets me "CONFIG_table_exclude has a wrong format. Ignoring the entry."
i changed it to
# r='^[^*]+\.[^.]+$';

which seems to do the trick for me, it will not allow for * in database name, but assumes all "." are in the database and not in the table.
i'm not an mysql expert so maybe this exclusion needs to be re-thought db & table testing

Discussion


Log in to post a comment.