andyao1986的专栏

原创 数据库运维常用命令

1、导出非分区表数据 mysql.local -BNe 'show databases;' | egrep -v "[0-9]|mysql|monitor|test|information" | while read i ; do mysql.local -BNe "show tables in $i;"| grep -v [0-9] | while read j; do echo "mysql