啟動腳本:start.sh
#!/bin/bash
for port in {3390..3396}
do
(/export/servers/mysql/bin/mysqld_safe --defaults-file=/export/servers/mysql/etc/my$port.cnf ) &
done
關閉腳本:stop.sh
#!/bin/bash
(/export/servers/mysql/bin/mysqladmin -uroot -p -S /export/data/mysql/tmp/mysql$port.sock shutdown) &
done
在測試環境中,在一台伺服器上建立多個執行個體,在每個執行個體中一個一個删庫比較麻煩,是以用下面腳本,可以直接删除所有庫,除了系統庫以外:
mysql=/export/servers/mysql/bin/mysql
for i in {3361..3362}
do
for j in $($mysql -uroot -p123456 -S /export/data/mysql/tmp/mysql$i.sock -e "show databases" |egrep -v "information_schema|mysql|test|performance_schema|Database")
$mysql -uroot -p123456 -S /export/data/mysql/tmp/mysql$i.sock -e "drop database \`$j\`"
安裝多執行個體MySQL資料庫,安裝完成後預設無密碼,一次性給所有執行個體的root賬戶建立密碼:
for i in {3361..3363}
/export/servers/mysql/bin/mysql -uroot -S /export/data/mysql/tmp/mysql$i.sock <<EOF
use mysql;
update user set password=password('123456') where user='root';
flush privileges;
EOF
[root@yoon export]# vi gunzip.sh
!/bin/bash
path=/export/backup ----備份檔案目錄路徑
for i in `ls ${path}/*`
/bin/gunzip $i
[root@yoon export]# chmod +x gunzip.sh
[root@yoon export]# sh gunzip.sh
==========================================