Please read this article thoroughly before proceeding with the solution. Be sure to make server snapshot backups to avoid secondary failures. Reason for appearing: Under normal circumstances, when the database executes the query statement "Select * From Table_Name", it will normally return complete data to the user. When the query is executed, or the background operation of the InnoDB storage engine exits unexpectedly or is interrupted, it will cause InnoDB to roll back forward. Failed to restore data, the main error is displayed as follows: Error 1： 2021-12-2306:50:44.061994Z 0 [ERROR] InnoDB: Page [page id: space=0, page number=448] log sequence number 453794788325 is in the future! Current system log sequence number 453794473178. 2021-12-2306:50:44.062002Z 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to , 2021-12-2306:50:44.062039Z 0 [ERROR] InnoDB: Page [page id: space=0, page number=452] log sequence number 453794788552 is in the future! Current system log sequence number 453794473178. 2021-12-2306:50:44.062042Z 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to , 2021-12-2306:50:44.062071Z 0 [ERROR] InnoDB: Page [page id: space=0, page number=457] log sequence number 453794788763 is in the future! Current system log sequence number 453794473178. 2021-12-23T06:50:44.062073Z 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to 2021-12-23T06:50:44.062159Z 0 [ERROR] InnoDB: Page (page id: space=0, page number=487] log sequence number 453794789850 is in the future! Current system log sequence number 453794473178. 2021-12-2306:50:44.062161Z 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to , 2021-12-2306:50:44.062202Z 0 [ERROR] InnoDB: Page [page id: space=0, page number= 501] log sequence number 453794790288 is in the future! Current system log sequence number 453794473178. 2021-12-2306:50:44.062204Z 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to , 2021-12-23T06:50:44.062223Z 0 [ERROR] InnoDB: Page [page id: space=0, page number= 514] log sequence number 453795083144 is in the future! Current system log sequence number 453794473178. 2021-12-2306:50:44.062225Z 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to 2021-12-2306:50:44.062234Z 0 [ERROR] InnoDB: Page (page id: space=0, page number=515) log sequence number 453795104290 is in the future! Current system log sequence number 453794473178. 2021-12-23T06:50:44.062236Z 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to , 2021-12-23T06:50:44.062245Z 0 [ERROR] InnoDB: Database page corruption on disk or a failed file read of page (page id: space=0, page number=519]. You may have to recover from a backup. 2021-12-2306:50:44.062247Z 0 [Note] InnoDB: Page dump in ascii and hex (16384 bytes): len 16384; hex fd121f7200000207000000000000000000000069a85032a0002000000000000000000000000000200383f700000206002c0000020800200751c821482b20000008ec93ae02f0000020200382461323833346164 Error 2: 2022-01-02 22:05:36 7f114f118720 InnoDB: Error: page 251 log sequence number 135630634 InnoDB: is in the future! Current system log sequence number 43744780. InnoDB: Your database may be corrupt or you may have copied the InnoDB InnoDB: tablespace but not the InnoDB log files. See InnoDB: http://dev.mysql.com/doc/refman/ ... nnodb-recovery.html InnoDB: for more information. 2022-01-02 22:05:36 7f114f118720 InnoDB: Error: page 530 log sequence number 43789292 InnoDB: is in the future! Current system log sequence number 43744780. InnoDB: Your database may be corrupt or you may have copied the InnoDB InnoDB: tablespace but not the InnoDB log files. See InnoDB: http://dev.mysql.com/doc/refman/ ... nnodb-recovery.html InnoDB: for more information. 2022-01-02 22:05:36 7f114f118720 InnoDB: Error: page 252 log sequence number 151634539 InnoDB: is in the future! Current system log sequence number 43744780. InnoDB: Your database may be corrupt or you may have copied the InnoDB InnoDB: tablespace but not the InnoDB log files. See InnoDB: http://dev.mysql.com/doc/refman/ ... nnodb-recovery.html InnoDB: for more information. 2022-01-02 22:05:36 7f114f118720 InnoDB: Error: page 517 log sequence number 151634539 InnoDB: is in the future! Current system log sequence number 43744780. InnoDB: Your database may be corrupt or you may have copied the InnoDB InnoDB: tablespace but not the InnoDB log files. See InnoDB: http://dev.mysql.com/doc/refman/ ... nnodb-recovery.html InnoDB: for more information. The solution to this error is as follows: 1, First determine whether the error is consistent with the above error message, and then close the web service (Nginx, Apache, Openlitespeed). 2, Make a backup of the MySQL data storage directory. The backup is just in case. If there is a snapshot, try to make a disk snapshot. The default database storage path in the panel is： /www/server/data Backup directory command: \cp -rp /www/server/data \www\backup\data_2022 3, Add to the MySQL configuration file The default MySQL configuration file for the panel is: /etc/my.cnf innodb_force_recovery = 1 Restart the database after setting innodb_force_recovery is a non-zero integer by default. There are a total of 6 parameter values 1--6. Refer to the official manual for parameter interpretation: mysql 5.6 https://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html mysql 5.7 https://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html mysql 8.0 https://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html 4,The above 6 parameter values, the latter contains the previous functions, such as parameter 3, which includes all the functions of parameter 1 and parameter 2. There is always one parameter here that can start the database. Note: If it cannot be started, please Clear the binary log (do not execute this command without backup): rm -f /www/server/data/ib_* rm -f /www/server/data/mysql-bin* 5, After restarting the database, back up the database as follows: In the panel "Cron" set the backup database: After setting, remember to click the "Execute" button, and pay attention to check whether the "Log" backup is successful. If the database is relatively large, the backup will take some time. You can also back up by clicking the Backup button on the "databases" management interface. 6, When the backup is completed and there is no error, stop the database service, back up the database name, user name and corresponding password to Notepad and save it, and then uninstall the current database 7, After reinstalling MySQL, create a new database, use the database name, user name and corresponding password saved to Notepad, and pay attention to the character set used by the database 8, After restoring the latest backup database successfully, restart the web service and observe whether the website is normal. Conclusion: The reason why the server is called a server is its strong stability and continuous service capabilities. Unless necessary, do not restart the server, usually do more data backup, and don't panic when there is a problem! If you have trouble using the panel, you can post on the forum for help. FAQ: Why shut down web services (Nginx, Apache, Openlitespeed)? A: At this time, MySQL has been unable to provide services normally. If the web service is always open, external access will keep requesting the database, and a large number of error logs will be generated. If the disk capacity is small, the disk space will soon be insufficient. Why do snapshots or backups? A: When processing data, MySQL may not be able to start due to special circumstances. If there is no backup or snapshot, the existing "data" will be damaged, causing secondary damage to the database. Why copy the database name, user name and corresponding password? A: To save time, creating a database on the panel will regenerate a random password. Currently, if the database information in your website is inconsistent with the information in the running database, you cannot connect. When creating a database, use the previous database name. , username and password to create a database, no need to modify the information in the website configuration file, so that it can be used directly after starting the web service What should I do if the database still fails to start after I have tried everything? Answer: MySQL's official solutions can't solve the current problem. It is recommended to find a professional data recovery company.

aaPanel_Kern Excelente report! thanks.

shajal This is a very easy task to fix First put your recycle bin on. Then delete your databases which will be stored in the recycle bin Now you uninstall mysql and install it again Then restart everything again

Do not stop mysql at will, stable server hardware is running, etc. Daily backup database

aaPanel_Kern I don't understand. can you explain better

Mysql/Mariadb Innodb Storage Engine Damage Solution

aaPanel_Kern

It is recommended that you use a search engine to find it.

dev24mavenda

aaP_vikingphp

How should I use the /www/server/data folder backup?

@aaPanel_Kern
@aaPanel_Jose

aaPanel_Kern

You need to stop mysql and then back it up. Note that it may not work properly even after the backup.
If mysql is running normally, it is recommended that you back up the database directly in aapanel

aaP_vikingphp

aaPanel_Kern

aaPanel_Kern Backup directory command:
\cp -rp /www/server/data \www\backup\data_2022

You told that i have to copy /www/server/data to /www/backup/data_2022,
Now i want to use /www/backup/data_2022 but when i replace /www/server/data by /www/backup/data_2022 and change /www/server/data ownership to mysql:mysql and restart mysql, mysql stops working immediately. (error: Failed to start mysql service)

mysql logs:

2024-11-07T09:20:50.438804Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.
2024-11-07T09:20:50.438931Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2024-11-07T09:20:50.439096Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.24) starting as process 3955312
2024-11-07T09:20:50.461738Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-11-07T09:20:50.468074Z 1 [Warning] [MY-012197] [InnoDB] Unable to open './sys/sys_config.ibd'
2024-11-07T09:20:50.830635Z 1 [Warning] [MY-012573] [InnoDB] './#innodb_temp/temp_5.ibt' permission error, can't delete!
2024-11-07T09:20:50.830764Z 1 [Warning] [MY-012573] [InnoDB] './#innodb_temp/temp_10.ibt' permission error, can't delete!
2024-11-07T09:20:50.830875Z 1 [Warning] [MY-012573] [InnoDB] './#innodb_temp/temp_4.ibt' permission error, can't delete!
2024-11-07T09:20:50.830987Z 1 [Warning] [MY-012573] [InnoDB] './#innodb_temp/temp_9.ibt' permission error, can't delete!
2024-11-07T09:20:50.831098Z 1 [Warning] [MY-012573] [InnoDB] './#innodb_temp/temp_2.ibt' permission error, can't delete!
2024-11-07T09:20:50.831209Z 1 [Warning] [MY-012573] [InnoDB] './#innodb_temp/temp_8.ibt' permission error, can't delete!
2024-11-07T09:20:50.831325Z 1 [Warning] [MY-012573] [InnoDB] './#innodb_temp/temp_1.ibt' permission error, can't delete!
2024-11-07T09:20:50.831443Z 1 [Warning] [MY-012573] [InnoDB] './#innodb_temp/temp_6.ibt' permission error, can't delete!
2024-11-07T09:20:50.831566Z 1 [Warning] [MY-012573] [InnoDB] './#innodb_temp/temp_3.ibt' permission error, can't delete!
2024-11-07T09:20:50.831686Z 1 [Warning] [MY-012573] [InnoDB] './#innodb_temp/temp_7.ibt' permission error, can't delete!
2024-11-07T09:20:50.831809Z 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 13 in a file operation.
2024-11-07T09:20:50.831932Z 1 [ERROR] [MY-012595] [InnoDB] The error means mysqld does not have the access rights to the directory.
2024-11-07T09:20:50.832047Z 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 13 in a file operation.
2024-11-07T09:20:50.832161Z 1 [ERROR] [MY-012595] [InnoDB] The error means mysqld does not have the access rights to the directory.
2024-11-07T09:20:50.832281Z 1 [ERROR] [MY-012126] [InnoDB] Cannot create file './#innodb_temp/temp_1.ibt'
2024-11-07T09:20:50.832410Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2024-11-07T09:20:50.841845Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2024-11-07T09:20:50.842414Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-11-07T09:20:50.843045Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-11-07T09:20:50.845060Z 0 [System] [MY-010910] [Server] /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.24)  Source distribution.

aaP_vikingphp

@aaPanel_Kern
@aaPanel_Jose

aaPanel_Kern

Hello, do you want to stop mysql first? Is the permission of this directory mysql?

aaP_vikingphp

aaPanel_Kern I've changed the #innodb_temp folder chmod to 755 and the problem solved.
But right now i have this error:

mysql> check table accounts;
No connection. Trying to reconnect...
Connection id:    27
Current database: uploader

ERROR 2013 (HY000): Lost connection to MySQL server during query
No connection. Trying to reconnect...
ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1:3306' (111)
ERROR: 
Can't connect to the server

mysql> check table users;
No connection. Trying to reconnect...
Connection id:    8
Current database: uploader

+----------------+-------+----------+----------+
| Table          | Op    | Msg_type | Msg_text |
+----------------+-------+----------+----------+
| uploader.users | check | status   | OK       |
+----------------+-------+----------+----------+
1 row in set (0.56 sec)

@aaPanel_Kern

aaPanel_Kern

Hello, are other directories normal?
Check the mysql log to see if there are any error messages

aaP_vikingphp

aaPanel_Kern
@aaPanel_Kern

aaP_vikingphp

aaPanel_Kern cannot access to tables list in Database > tools in AApanel.
But i can access to tables list via SSH (mysql command).

@aaPanel_Kern

aaPanel_Kern

Is it okay to use phpmyadmin to log in?
Check if the root password is correct?

aaP_vikingphp

aaPanel_Kern Mysql root or user password is incorrect, please try to reset!

aaPanel_Kern

Please reset the root password in aapanel, or enter your password into the box to reset it

aaP_vikingphp

aaP_hrkiven

9:01:16 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB >
9:01:16 0 [ERROR] InnoDB: Page [page id: space=2, page number=30] log sequence number 707730347 is in the future! Curre>
9:01:16 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB >
9:01:16 0 [Note] Plugin 'FEEDBACK' is disabled.
9:01:16 0 [ERROR] mysqld: File './mysql-bin.000026' not found (Errcode: 13 "Permission denied")
9:01:16 0 [ERROR] Failed to open log (file './mysql-bin.000026', errno 13)
9:01:16 0 [ERROR] Could not open log file
9:01:16 0 [ERROR] Can't init tc log
9:01:16 0 [ERROR] Aborting
9:01:16 0 [ERROR] InnoDB: Page [page id: space=2203, page number=3] log sequence number 664283483 is in the future! Cur>
9:01:16 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB >
9:01:16 0 [ERROR] InnoDB: Page [page id: space=4792, page number=0] log sequence number 625072322 is in the future! Cur>
9:01:16 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB >
9:01:16 0 [ERROR] InnoDB: Page [page id: space=4792, page number=3] log sequence number 660482520 is in the future! Cur>
9:01:16 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB >
9:01:16 0 [ERROR] InnoDB: Page [page id: space=4792, page number=1] log sequence number 625070876 is in the future! Cur>
9:01:16 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB >
: Main process exited, code=exited, status=1/FAILURE

aaPanel_Kern

Hello, have you modified the permissions of the directory or file? Or what operations have been done?
Check the permissions of the /www/server/data directory and files

aaP_hrkiven