Mysql/Mariadb not running or stoped

aaP_khoidzok

2023-09-11 15:45:54 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2023-09-11 15:45:54 0 [Note] /www/server/mysql/bin/mariadbd (server 10.7.3-MariaDB-log) starting as process 4405 ...
2023-09-11 15:45:54 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2023-09-11 15:45:54 0 [Note] InnoDB: Number of transaction pools: 1
2023-09-11 15:45:54 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-09-11 15:45:54 0 [Note] InnoDB: Using Linux native AIO
2023-09-11 15:45:54 0 [Note] InnoDB: Initializing buffer pool, total size = 4294967296, chunk size = 134217728
2023-09-11 15:45:55 0 [Note] InnoDB: Completed initialization of buffer pool
2023-09-11 15:45:55 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=42401,42401
2023-09-11 15:45:55 0 [ERROR] InnoDB: Missing FILE_CHECKPOINT at 42401 between the checkpoint 42401 and the end 7407304.
2023-09-11 15:45:55 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2023-09-11 15:45:55 0 [Note] InnoDB: Starting shutdown...
2023-09-11 15:45:55 0 [ERROR] Plugin 'InnoDB' init function returned error.
2023-09-11 15:45:55 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2023-09-11 15:45:55 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-09-11 15:45:55 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2023-09-11 15:45:55 0 [ERROR] Aborting
230911 15:45:55 mysqld_safe mysqld from pid file /www/server/data/centos7.org.pid ended

aaPanel_Kern

aaP_khoidzok
Hello, if it is a new installation, you can consider reinstalling mysql
Otherwise, try the server to do a snapshot backup and then operate
cd /www/server/data/ mv ibdata1 /tmp/ibdata1.bak mv ib_logfile0 /tmp/ib_logfile0.bak mv ib_logfile1 /tmp/ib_logfile1.bak /etc/init.d/mysqld restart

aaP_khoidzok

aaPanel_Kern While I'm running it, it suddenly shuts down and displays the log as above. Please show me the optimal way to fix it without losing the database

aaPanel_Kern

aaPanel_Kern try the server to do a snapshot backup and then operate
cd /www/server/data/
mv ibdata1 /tmp/ibdata1.bak
mv ib_logfile0 /tmp/ib_logfile0.bak
mv ib_logfile1 /tmp/ib_logfile1.bak
/etc/init.d/mysqld restart

aaP_khoidzok

aaPanel_Kern hello bro, i run
cd /www/server/data/
mv ibdata1 /tmp/ibdata1.bak
mv ib_logfile0 /tmp/ib_logfile0.bak
mv ib_logfile1 /tmp/ib_logfile1.bak
/etc/init.d/mysqld restart
My database deleted

aaP_khoidzok

aaP_khoidzok After completing the command, my website goes into wp-admin mode

aaPanel_Kern

Hello, would you recommend restoring the file back? Is it normal?

aaP_khoidzok

aaPanel_Kern

This error appears when my website is ddos and the mysql service has stopped. Please help me reopen the mysql service and my website still works normally and no data loss. Thanks teams

aaPanel_Kern

Hello, is the website normal now? Is it possible to resolve this issue by referring to this post?
https://www.aapanel.com/forum/d/13216-mysqlmariadb-innodb-storage-engine-damage-solution

aaP_khoidzok