建站
咨詢(xún)
售后
建站咨詢(xún)
新聞中心
這里有您想知道的互聯(lián)網(wǎng)營(yíng)銷(xiāo)解決方案
創(chuàng)新互聯(lián)linux教程：寶塔linux面板數(shù)據(jù)庫(kù)存放路徑修改腳本
寶塔linux面板數(shù)據(jù)庫(kù)存放路徑修改腳本
注意：該腳本僅適合寶塔linux面板使用
支持版本：寶塔linux面板全系列
功能參數(shù)：修改 還原
sh xxx.sh #修改存放路徑
sh xxx.sh old #還原數(shù)據(jù)庫(kù)原路徑
如果你的數(shù)據(jù)庫(kù)存在在系統(tǒng)盤(pán)的都建議你把數(shù)據(jù)庫(kù)存放路徑修改到數(shù)據(jù)盤(pán)下。
修改數(shù)據(jù)庫(kù)路徑：
還原數(shù)據(jù)庫(kù)路徑：
shell代碼：
#!/bin/bash
Stack=$1
if [ "${Stack}" = "" ]; then
Stack="new"
else
Stack=$1
fi
mysqld_start(){
service mysqld restart
}
mysql_alter()
{
Old_path="/www/server"
clear
echo -e "\033[33mUsage: $0 {new|old}\033[0m"
echo -e "\033[33msh $0 (default:new)\033[0m"
echo -e "\033[33msh $0 old (Restore database)\033[0m"
echo "==============================="
if [ -d /www/server/data ]; then
read -p "Enter a new database path (for example, /home/mysql):" Route
if [ "${Route}" == "" ]; then
echo "New database path cannot be empty!"
else
echo "Copying database file to:${Route} Please be patient"
service mysqld stop
killall -TERM mysqld
mkdir ${Route}
chown -R root:mysql ${Route}
mkdir ${Route}/var
cp -r -p $Old_path/data/* ${Route}/var
chown -R mysql:mysql ${Route}/var
mv $Old_path/data $Old_path/data.old
cp /etc/my.cnf /etc/my.cnfold
#/etc/my/cnf
sed -i 's#^datadir = '$Old_path/data'#datadir = '${Route}/var'#g' /etc/my.cnf
sed -i 's#^innodb_data_home_dir = '$Old_path/data'#innodb_data_home_dir = '${Route}/var'#g' /etc/my.cnf
sed -i 's#^innodb_log_group_home_dir = '$Old_path/data'#innodb_log_group_home_dir = '${Route}/var'#g' /etc/my.cnf
mysqld_start
if netstat -ntulp |grep -w 3306; then
echo "#####################################"
echo "Database directory changed successfully!"
echo -e "New database file path:\033[33m${Route}/var\033[0m"
echo "For more information visit: http://XWCX.NET"
echo "#####################################"
else
echo "#####################################"
echo -e "Prompt:\033[31mDatabase directory changes not successful\033[0m"
echo "#####################################"
fi
fi
else
echo -e "Prompt:\033[31mSorry, I can't find the /www/server/data directory\033[0m"
fi
}
Old_mysql()
{
if [ -d /www/server/data ]; then
echo -e "Prompt:\033[31m/www/server/data folder already exists, not allowed to restore.\033[0m"
else
service mysqld stop
killall -TERM mysqld
rm -rf /etc/my.cnf
mv /etc/my.cnfold /etc/my.cnf
mv /www/server/data.old /www/server/data
mysqld_start
if netstat -ntulp |grep -w 3306; then
echo -e "Prompt:\033[32mrecover successfully\033[0m"
echo "For more information visit: http://XWCX.NET"
else
echo -e "Prompt:\033[31mrecovery failed\033[0m"
echo "For more information visit: http://XWCX.NET"
fi
fi
}
case "${Stack}" in
new)
mysql_alter
;;
old)
Old_mysql
;;
*)
echo "Usage: $0 {new|old}"
;;
esac腳本下載：
wget http://XWCX.NET/soft/mysql_alter.sh && sh mysql_alter.sh
如修改或還原報(bào)錯(cuò)，請(qǐng)把相關(guān)錯(cuò)誤信息回復(fù)到留言或者發(fā)創(chuàng)新互聯(lián)郵箱 第一時(shí)間回復(fù) 謝謝
網(wǎng)頁(yè)題目：創(chuàng)新互聯(lián)linux教程：寶塔linux面板數(shù)據(jù)庫(kù)存放路徑修改腳本
本文URL：http://fisionsoft.com.cn/article/cdidjcd.html
