# 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 라서 발생된 문제임..