#11148: skip dumping information|performance_schema in mysql handler

I tried to improve !3 (closed). I let the grep as it is. I'm not sure if -E is more readable. @intrigeri can you look over this, so we can bring this into master?

changed the description

added 1 commit

• 7d7d8531 - #11148 (closed): skip dumping information|performance_schema in mysql handler

Compare with previous version

Thanks for improving !3 (closed).

In:

debug 'set -o pipefail ; echo show databases | $VSERVER $vsname exec su $user -c \"$MYSQL $defaultsfile\" | grep -v Database | grep -v '^\(information\|performance\)_schema$''

… the proposed branch adds nested single quotes. This won't work, as bash does not nest them; see e.g. to understand what happens:

$ echo '$UID'
$UID
$ echo ''$UID''
1000

Once this is fixed I'm happy to merge :)

assigned to @ibauer

mentioned in merge request !3 (closed)

added 1 commit

• 436e57ec - #11148 (closed): skip dumping information|performance_schema in mysql handler

Compare with previous version

I replaced the nested single quotes with escaped double quotes. Is this correct?

The purpose of this debug line is to document the command run on the line below, so I'd rather do this. I think you can use escaped single quotes instead and this should work fine :)

added 1 commit

• 711ea76d - #11148 (closed): skip dumping information|performance_schema in mysql handler

Compare with previous version

Ok, I escaped the single quotes as described here: https://stackoverflow.com/questions/1250079/how-to-escape-single-quotes-within-single-quoted-strings as normal escaping doesn't work

Looks good to me! I'll test and merge if happy. Thanks :)

merged

mentioned in commit a3ee78c0