사이트 내 전체검색
[백업] mysql -p < all.sql error ERROR 1064 (42000)
하우코드
https://cmd.kr/server/1162 URL이 복사되었습니다.

본문

# mysql -p < all.sql error

 

ERROR 1064 (42000) at line 793102: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PAGE_CHECKSUM=1 TRANSACTIONAL=1 COMMENT='Events'' at line 25


mysql: [Warning] Using a password on the command line interface can be insecure.

ERROR 1064 (42000) at line 793102: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TRANSACTIONAL=1 COMMENT='Even

 

-->  

sed -i 's/ PAGE_CHECKSUM=1//g' all.sql;

sed -i 's/ TRANSACTIONAL=1//g' all.sql;

PAGE_CHECKSUM ,  TRANSACTIONAL 을 지우고 새로 mysql recall

원인 :  db 테이블 type이 Aria 라서 발생된 문제임..

 

댓글목록

등록된 댓글이 없습니다.

1,139 (1/23P)

Search

Copyright © Cmd 명령어 3.238.121.7