[求助] 我找了个表转换引擎的,我打包成.sh了 怎么得都运行不了

qq682907

1. #!/bin/bash
   
2. #dx2_myisam2innodb.sh
   
3. USER="root"
   
4. PASS="ichejie.com"
   
5. FILE_SQL="sql.myisam2innodb"
   
6. NAME_DB="testichejie"
   
7. 
   
8. cat > "${FILE_SQL}" << EOF
   
9. USE ${NAME_DB};
   
10. ALTER TABLE pre_forum_postposition DROP PRIMARY KEY,ADD PRIMARY KEY(position,tid);
    
11. ALTER TABLE pre_common_member_grouppm DROP PRIMARY KEY,ADD PRIMARY KEY(gpmid,uid);
    
12. ALTER TABLE pre_forum_post DROP PRIMARY KEY,ADD PRIMARY KEY(position,tid);
    
13.    
    
14. EOF
    
15.    
    
16. mysql -u"${USER}" -p"${PASS}" -ANe "SELECT CONCAT('ALTER TABLE ', table_name, ' ENGINE=InnoDB;') as ToSQL from information_schema.tables where TABLE_SCHEMA='${NAME_DB}' and ENGINE='MYISAM' order by TABLE_ROWS;" >> "${FILE_SQL}"
    
17. mysql -u"${USER}" -p"${PASS}" < "${FILE_SQL}"

复制代码

下载 (27.84 KB)

2013-3-7 15:45

报错了 这样的错 我确认mysql密码什么的 都是对的 求助

qq682907

来人啊 亲