MySQL batch Modify Table Storage Engine

Parameter List:

[DB] [db_host] [db_user] [db_passwd]

 

 

#! /Bin/bash

If [$1]
Then
Echo database $1;
Else
Echo 'backup database tables to gzip files sh bak_db_table.sh DB [db_host] [db_user] [db_passwd] '; exit;
Fi

[$1] & DB = $1
[$2] & DBH = $2
[$3] & dbu = $3
[$4] & DBP = $4

[$ DBH] & DBH = "-h" $ DBH
[$ Dbu] & dbu = "-U" $ dbu
[$ DBP] & DBP = "-P" $ DBP

List = ('echo show tables |/opt/modules/MySQL/bin/MySQL $ DBH $ dbu $ DBP $ db ')

Tbcount = $ ($ {# list [@]}-2 ))

If [$ tbcount =-2] # hg9 {1 + 2; 4ftz; _ j}>]? BA, = SJ '0/
Then
Echo empty tables in $ db or connent failed! ; Exit 1;
Fi
Echo table count: $ tbcount

 

For (I = 1; I <($ tbcount + 1); I ++ ))
Do
Table =$ {list [$ I]}
Echo alter table $ db. $ table
Echo "alter table $ db. $ table type = MyISAM;" |/opt/modules/MySQL/bin/MySQL $ DBH $ dbu $ DBP;
# Sleep 10
Done