在命令行模式下面查看当前实例有几个库
mysql -uroot -pdafakd32aa -e "show databases;"
过滤MYQL默认数据库
mysql -uroot -pdafakd32aa -e "show databases;"|egrep -v "schema|mysql"
加上,sed '1d',删除第一行,“Database"标识
mysql -uroot -pdafakd32aa -e "show databases;"|egrep -v "schema|mysql"|sed '1d'
MYSQL分库备份脚本的命令
#!/bin/sh USER=root PASSWD=hvDj1#shVj LOGIN="mysql -u$USER -p$PASSWD " DUMP="mysqldump -u$USER -p$PASSWD " DATABASE=$($LOGIN -e "show databases;"|egrep -v "*schema|mysql|sys|system"| sed '1d') for database in $DATABASE do $DUMP $database|gzip >/home/${database}_$(date +%F).sql.gz done |
执行备份命令
ls -lh ,ls -ltr
查看MYSQL库下面有哪些表:
mysql -uroot -pdafakd32aa -e "
use mysql ;show tables;
"
去掉Tables_in_mysql,这一行,加入
mysql -uroot -pdafakd32aa -e "use mysql ;show tables;"| sed '1d'
mysql分表备份脚本
#!/bin/sh USER=root PASSWD=dafakd32aa LOGIN="mysql -u$USER -p$PASSWD " DUMP="mysqldump -u$USER -p$PASSWD " DATABASE=$($LOGIN -e "show databases;"|egrep -v "*schema|mysql|sys|system|fujian_lajifl"| sed '1d') for database in $DATABASE do TABLE=$($LOGIN -e "use $database;show tables;"| sed '1d') for table in $TABLE do [ -d /home/$database ] || mkdir -p /home/$database $DUMP $database $table | gzip >/home/$database/${table}_$(date +%F).sql.gz done done |