日本高清www无色夜在线视频,色欲久久久天天天综合网,国产婷婷色一区二区三区,俺去俺来也在线www色官网

Board logo

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

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

報(bào)錯(cuò)了 這樣的錯(cuò) 我確認(rèn)mysql密碼什么的 都是對(duì)的 求助

圖片附件: mysqsl.jpg (2013-3-7 15:45, 27.84 KB) / 下載次數(shù) 6137
http://www.valcooper.com/bbs/attachment.php?aid=2495&k=27796c4ab0750c2db3932235fbaa58d6&t=1746902032&sid=7zW22Z

作者: qq682907    時(shí)間: 2013-3-7 20:16

來(lái)人啊 親



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