四虎影视在线影院在线观看,小s货再浪些再咬紧点h,国产精品水嫩水嫩,97精产国品一二三产区

Board logo

標題: [求助] 我找了個表轉(zhuǎn)換引擎的,我打包成.sh了 怎么得都運行不了 [打印本頁]
作者: qq682907    時間: 2013-3-7 15:45     標題: 我找了個表轉(zhuǎn)換引擎的,我打包成.sh了 怎么得都運行不了

  1. #!/bin/bash
  2. #dx2_myisam2innodb.sh
  3. USER="root"
  4. PASS="ichejie.com"
  5. FILE_SQL="sql.myisam2innodb"
  6. NAME_DB="testichejie"

  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}"
復制代碼
mysqsl.jpg

報錯了 這樣的錯 我確認mysql密碼什么的 都是對的 求助

圖片附件: mysqsl.jpg (2013-3-7 15:45, 27.84 KB) / 下載次數(shù) 5980
http://cd-genova.com/bbs/attachment.php?aid=2495&k=00e0d9c8dd028dff6ccae464d2f6c2e4&t=1745060017&sid=hUHv5u

作者: qq682907    時間: 2013-3-7 20:16

來人啊 親



歡迎光臨 WDlinux官方論壇 (http://cd-genova.com/bbs/) Powered by Discuz! 7.2