#!/bin/sh mysql_user=root mysql_pass=123123 time_log=/opt/time databases=/opt/databases /usr/bin/mysql -u$mysql_user -p$mysql_pass -e "show databases" | grep -v "Database" > /opt/databases sed -i "s/information_schema//" $databases sed -i "s/mysql//" $databases sed -i "s/test//" $databases databases1=$(cat /opt/databases) for i in $databases1 do echo "database $i starting" tables=$(/usr/bin/mysql $i -u$mysql_user -p$mysql_pass -e "show tables" | grep -v "Tables" > /opt/$i) tablelist=$(cat /opt/$i) echo "optimize database $i starting" >> $time_log echo "$i start at $(date +[%Y/%m/%d/%H:%M:%S])" >> $time_log for list in $tablelist do echo $list /usr/bin/mysql $i -u$mysql_user -p$mysql_pass -e "optimize table $list" done echo "$i end at $(date +[%Y/%m/%d/%H:%M:%S])" >> $time_log echo >> $time_log done
mysql碎片整理shell脚本
精选 转载wb5799f2119cd34 博主文章分类:Mysql
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
Sqlmap tamper 脚本整理
一、说明SQLMAP是一个用于测试SQL注入问题的强大工具,工具有很多可用的选项,使用sqlmap -hh可以看到具体的说明,其可用的选项进行了分类,包括Target、Request、Optimization、Injection、Detection、Techniques、Fingerprint、Enumeration、Brute force、User-deficed function inject
sqlmap tamper base64encode charunicodeencode randomcomments