mysql轉(zhuǎn)換表的存儲引擎腳本
vi convert_tbale_engine.sh
#!/bin/bash
DB=test
USER=root
PASSWORD=123456
HOST=192.168.1.10
MySQL_BIN=/usr/local/bin
S_ENGINE=MyISAM
D_ENGINE=InnoDB
$MYSQL_BIN/mysql -h$HOST -u$USER -p$PASSWORD $DB -s -e "select table_name from infomation_schem.table where table_schema='test' and engine='myisam'"|grep -v "table_name" >table.txt
for t_name in `cat table.txt`
do
echo "Staring convert table $t_name..."
sleep 1
$MYSQL_BIN/mysql -h$HOST -u$USER -p$PASSWORD $DB -e "alter table $t_name engine=$D_ENGINE"
if [ $? -eq 0 ];then
echo "Convert table $t_name ended ">con_table.log
sleep 1
else
echo "Convert tbale $t_name failed ">con_table.log
fi
done
#!/bin/bash
DB=test
USER=root
PASSWORD=123456
HOST=192.168.1.10
MySQL_BIN=/usr/local/bin
S_ENGINE=MyISAM
D_ENGINE=InnoDB
$MYSQL_BIN/mysql -h$HOST -u$USER -p$PASSWORD $DB -s -e "select table_name from infomation_schem.table where table_schema='test' and engine='myisam'"|grep -v "table_name" >table.txt
for t_name in `cat table.txt`
do
echo "Staring convert table $t_name..."
sleep 1
$MYSQL_BIN/mysql -h$HOST -u$USER -p$PASSWORD $DB -e "alter table $t_name engine=$D_ENGINE"
if [ $? -eq 0 ];then
echo "Convert table $t_name ended ">con_table.log
sleep 1
else
echo "Convert tbale $t_name failed ">con_table.log
fi
done
本文題目：mysql轉(zhuǎn)換表的存儲引擎腳本
路徑分享：http://jinyejixie.com/article26/pggocg.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供動態(tài)網(wǎng)站、手機(jī)網(wǎng)站建設(shè)、ChatGPT、品牌網(wǎng)站建設(shè)、響應(yīng)式網(wǎng)站、微信公眾號
聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時需注明來源： 創(chuàng)新互聯(lián)
- 動態(tài)網(wǎng)站在靜態(tài)網(wǎng)站緩存的藝術(shù) 2016-08-08
- 什么是動態(tài)網(wǎng)站建設(shè) 2016-11-04
- 網(wǎng)站推廣中行業(yè)動態(tài)的引導(dǎo)功能重要嗎 2016-10-29
- 行業(yè)動態(tài)網(wǎng)站不應(yīng)只有實用性 2022-05-01
- 行業(yè)動態(tài)網(wǎng)站日志分析 2021-10-16
- 靜態(tài)URL還是動態(tài)URL將極有可能決定網(wǎng)站的未來價值 2015-08-21
- 「靜態(tài)數(shù)據(jù)」靜態(tài)數(shù)據(jù)比動態(tài)網(wǎng)頁更適合做提升 2015-07-25
- 互聯(lián)網(wǎng)+醫(yī)療的最新行業(yè)動態(tài) 2013-07-22
- 什么是動態(tài)網(wǎng)站建設(shè)的標(biāo)準(zhǔn)? 2019-02-18
- 動態(tài)頁面生成靜態(tài)HTML頁面的問題 2017-02-28
- 動態(tài)頁面優(yōu)缺點(diǎn)介紹 2016-11-02
- 動態(tài)網(wǎng)站的功能 2021-11-28