xampp 초보인데.. mysql 오류가 뜨며 스타트가 안되는데 도와주세요 ㅠ

xampp 초보인데.. mysql 오류가 뜨며 스타트가 안되는데 도와주세요 ㅠ

QA

xampp 초보인데.. mysql 오류가 뜨며 스타트가 안되는데 도와주세요 ㅠ

본문

2020-07-06 10:45:07 0 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2020-07-06 10:45:07 0 [ERROR] Plugin 'Aria' init function returned error.
2020-07-06 10:45:07 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
InnoDB: using atomic writes.
2020-07-06 10:45:07 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-07-06 10:45:07 0 [Note] InnoDB: Uses event mutexes
2020-07-06 10:45:07 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-06 10:45:07 0 [Note] InnoDB: Number of pools: 1
2020-07-06 10:45:07 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-06 10:45:07 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-07-06 10:45:07 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-06 10:45:08 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-06 10:45:08 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-06 10:45:08 0 [Note] InnoDB: Setting file 'C:\ajaeworld\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-06 10:45:08 0 [Note] InnoDB: File 'C:\ajaeworld\mysql\data\ibtmp1' size is now 12 MB.
2020-07-06 10:45:08 0 [Note] InnoDB: Waiting for purge to start
2020-07-06 10:45:08 0 [Note] InnoDB: 10.4.13 started; log sequence number 15522895; transaction id 38305
2020-07-06 10:45:08 0 [Note] InnoDB: Loading buffer pool(s) from C:\ajaeworld\mysql\data\ib_buffer_pool
2020-07-06 10:45:08 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-06 10:45:08 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2020-07-06 10:45:08 0 [ERROR] Failed to initialize plugins.
2020-07-06 10:45:08 0 [ERROR] Aborting
 

로그 창을보면 위와같은 내용인데 왜그런지 모르겠네요 ㅠㅠ

 

이 질문에 댓글 쓰기 :

답변 3

https://stackoverflow.com/questions/41170937/how-to-fix-error-mysql-shutdown-unexpectedly-on-xampp-due-to-plugin-aria  

이것 같은데,  채택된 답변은 없지만,  따라 한번 해 보세요..

 

PC라면 xampp보다는 라랄곤 사용을 추천드립니다.

https://maheshwaghmare.com/mysqld-exe-aria-recovery-failed-please-run-aria_chk-r-on-all-aria-tables-and-delete-all-aria_log-files/

 

위 블로그에 보면,

To fix this error I have deleted the file aria_log.00000001 from location D:\xampp\mysql\data\

라고 하는데...

 

한번 시도해보세요~

감사합니다. 초기에 백업해둔 mysql 파일을 덮으니까 다시 되긴합니다.

답변을 작성하시기 전에 로그인 해주세요.
전체 34
QA 내용 검색

회원로그인

(주)에스아이알소프트 / 대표:홍석명 / (06211) 서울특별시 강남구 역삼동 707-34 한신인터밸리24 서관 1404호 / E-Mail: admin@sir.kr
사업자등록번호: 217-81-36347 / 통신판매업신고번호:2014-서울강남-02098호 / 개인정보보호책임자:김민섭(minsup@sir.kr)
© SIRSOFT