Skip to content

Instantly share code, notes, and snippets.

@MegaphoneJon
Created February 7, 2017 22:35
Show Gist options
  • Save MegaphoneJon/94543829a2dfd6b3ed216b646afb0e8f to your computer and use it in GitHub Desktop.
Save MegaphoneJon/94543829a2dfd6b3ed216b646afb0e8f to your computer and use it in GitHub Desktop.
--- mysql.orig 2016-02-20 14:31:25.601574577 -0500
+++ mysql 2016-02-20 14:52:32.685574577 -0500
@@ -238,14 +238,14 @@
then
if [ $usevserver = yes ]
then
- debug 'set -o pipefail ; echo show databases | $VSERVER $vsname exec su $user -c \"$MYSQL $defaultsfile\" | grep -v Database'
- databases=`set -o pipefail ; echo 'show databases' | $VSERVER $vsname exec su $user -c "$MYSQL $defaultsfile" | grep -v Database`
+ debug 'set -o pipefail ; echo show databases | $VSERVER $vsname exec su $user -c \"$MYSQL $defaultsfile\" | grep -v Database | grep -v '^\(information\|performance\)_schema$''
+ databases=`set -o pipefail ; echo 'show databases' | $VSERVER $vsname exec su $user -c "$MYSQL $defaultsfile" | grep -v Database | grep -v '^\(information\|performance\)_schema$'`
if [ $? -ne 0 ]
then
fatal "Authentication problem, maybe user/password is wrong or mysqld is not running?"
fi
else
- databases=$(set -o pipefail ; su $user -c "$MYSQL $defaultsfile -N -B -e 'show databases'" | sed 's/|//g;/\+----/d')
+ databases=$(set -o pipefail ; su $user -c "$MYSQL $defaultsfile -N -B -e 'show databases'" | sed 's/|//g;/\+----/d;/^\(information\|performance\)_schema$/d')
if [ $? -ne 0 ]
then
fatal "Authentication problem, maybe user/password is wrong or mysqld is not running?"
@@ -257,15 +257,6 @@
do
DUMP_BASE="$MYSQLDUMP $defaultsfile $sqldumpoptions"
- case "$db" in
- information_schema)
- DUMP_BASE="${DUMP_BASE} --skip-lock-tables"
- ;;
- performance_schema)
- DUMP_BASE="${DUMP_BASE} --skip-lock-tables --skip-events"
- ;;
- esac
-
# Dumping structure and data
DUMP="$DUMP_BASE $ignore $db"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment