How do I convert a single file from .idb to .sql?

MySQL & MariaDB Percona XtraDB Cluster 5.x
21

Everything worked, but when I finally tried to start mysqli, I got this error:

root@ubuntu:/var/lib/mysql# sudo systemctl start mysql
Job for mysql.service failed because the control process exited with error code.
See “systemctl status mysql.service” and “journalctl -xe” for details.
root@ubuntu:/var/lib/mysql#

22

What’s in mysql’s error log? (typically somewhere in /var/log/mysql)

23 

All the logs did not fit here, so the last lines are like this

2024-03-29T02:21:05.780149Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.20.04.1) initializing of server in progress as process 19651
2024-03-29T02:21:05.796068Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-03-29T02:21:07.550142Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-03-29T02:21:10.784752Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2024-03-29T02:21:14.218542Z 6 [System] [MY-013172] [Server] Received SHUTDOWN from user boot. Shutting down mysqld (Version: 8.0.36-0ubuntu0.20.04.1).
2024-03-29T02:21:19.770571Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.20.04.1) starting as process 19714
2024-03-29T02:21:19.795655Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-03-29T02:21:20.110634Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-03-29T02:21:20.525300Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-03-29T02:21:20.525372Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-03-29T02:21:20.531025Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/tmp' in the path is accessible to all OS users. Consider choosing a different directory.
2024-03-29T02:21:20.553448Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: /var/run/mysqld/mysqlx.sock
2024-03-29T02:21:20.553577Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.36-0ubuntu0.20.04.1'  socket: '/tmp/tmp.ncdeldyU8H/mysqld.sock'  port: 0  (Ubuntu).
2024-03-29T02:21:20.597838Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.36-0ubuntu0.20.04.1).
2024-03-29T02:21:22.150230Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.20.04.1)  (Ubuntu).
2024-03-29T02:21:23.073036Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.20.04.1) starting as process 19786
2024-03-29T02:21:23.082958Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-03-29T02:21:23.408879Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-03-29T02:21:23.743919Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-03-29T02:21:23.743960Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-03-29T02:21:23.754251Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/tmp' in the path is accessible to all OS users. Consider choosing a different directory.
2024-03-29T02:21:23.792971Z 7 [System] [MY-013172] [Server] Received SHUTDOWN from user boot. Shutting down mysqld (Version: 8.0.36-0ubuntu0.20.04.1).
2024-03-29T02:21:23.793929Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '127.0.0.1' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2024-03-29T02:21:25.400354Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.20.04.1)  (Ubuntu).
2024-03-29T02:21:26.942253Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.20.04.1) starting as process 19946
2024-03-29T02:21:26.952246Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-03-29T02:21:27.268527Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-03-29T02:21:27.543489Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-03-29T02:21:27.543535Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-03-29T02:21:27.583918Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '127.0.0.1' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2024-03-29T02:21:27.584103Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.36-0ubuntu0.20.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu).
2024-03-29T02:22:11.421220Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.36-0ubuntu0.20.04.1).
2024-03-29T02:22:12.944418Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.20.04.1)  (Ubuntu).
2024-03-29T02:22:42.084642Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.20.04.1) starting as process 835
2024-03-29T02:22:42.115057Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-03-29T02:22:42.716058Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-03-29T02:22:43.068100Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-03-29T02:22:43.068157Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-03-29T02:22:43.113043Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '127.0.0.1' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2024-03-29T02:22:43.113816Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.36-0ubuntu0.20.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu).
2024-03-29T02:25:45.917938Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.36-0ubuntu0.20.04.1).
2024-03-29T02:25:47.924566Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 8  user: 'root'.
2024-03-29T02:25:49.289892Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.20.04.1)  (Ubuntu).
2024-03-29T14:08:53.949342Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.20.04.1) starting as process 9925
2024-03-29T14:08:53.959596Z 0 [Warning] [MY-010075] [Server] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: e027f257-edd5-11ee-af1d-000d3a145413.
2024-03-29T14:08:53.968186Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2024-03-29T14:08:53.968250Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-03-29T14:08:54.104111Z 1 [ERROR] [MY-012525] [InnoDB] Upgrade after a crash is not supported. This redo log was created with MySQL 5.7.26, and it appears corrupted. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html
2024-03-29T14:08:54.104144Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2024-03-29T14:08:54.505490Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
2024-03-29T14:08:54.505831Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-03-29T14:08:54.505863Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-03-29T14:08:54.506439Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.20.04.1)  (Ubuntu).
2024-03-29T14:08:54.997905Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.20.04.1) starting as process 9947
2024-03-29T14:08:55.008059Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2024-03-29T14:08:55.008113Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-03-29T14:08:55.828552Z 1 [ERROR] [MY-012525] [InnoDB] Upgrade after a crash is not supported. This redo log was created with MySQL 5.7.26, and it appears corrupted. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html
2024-03-29T14:08:55.828591Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2024-03-29T14:08:56.231494Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
2024-03-29T14:08:56.231838Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-03-29T14:08:56.231897Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-03-29T14:08:56.232392Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.20.04.1)  (Ubuntu).
2024-03-29T14:08:56.756198Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.20.04.1) starting as process 9969
2024-03-29T14:08:56.765574Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2024-03-29T14:08:56.765688Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-03-29T14:08:56.975520Z 1 [ERROR] [MY-012525] [InnoDB] Upgrade after a crash is not supported. This redo log was created with MySQL 5.7.26, and it appears corrupted. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html
2024-03-29T14:08:56.975560Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2024-03-29T14:08:57.379619Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
2024-03-29T14:08:57.380014Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-03-29T14:08:57.380041Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-03-29T14:08:57.380684Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.20.04.1)  (Ubuntu).
2024-03-29T14:08:58.006236Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.20.04.1) starting as process 9990
2024-03-29T14:08:58.014688Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2024-03-29T14:08:58.014755Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-03-29T14:08:58.214123Z 1 [ERROR] [MY-012525] [InnoDB] Upgrade after a crash is not supported. This redo log was created with MySQL 5.7.26, and it appears corrupted. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html
2024-03-29T14:08:58.214192Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2024-03-29T14:08:58.619425Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
2024-03-29T14:08:58.619840Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-03-29T14:08:58.619881Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-03-29T14:08:58.620447Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.20.04.1)  (Ubuntu).
2024-03-29T14:08:59.250615Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.20.04.1) starting as process 10011
2024-03-29T14:08:59.258979Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2024-03-29T14:08:59.259042Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-03-29T14:08:59.499464Z 1 [ERROR] [MY-012525] [InnoDB] Upgrade after a crash is not supported. This redo log was created with MySQL 5.7.26, and it appears corrupted. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html
2024-03-29T14:08:59.499502Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2024-03-29T14:08:59.902045Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
2024-03-29T14:08:59.902392Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-03-29T14:08:59.902419Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-03-29T14:08:59.902967Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.20.04.1)  (Ubuntu).
2024-03-29T14:09:15.341335Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.20.04.1) starting as process 10042
2024-03-29T14:09:15.350339Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2024-03-29T14:09:15.350425Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-03-29T14:09:15.596746Z 1 [ERROR] [MY-012525] [InnoDB] Upgrade after a crash is not supported. This redo log was created with MySQL 5.7.26, and it appears corrupted. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html
2024-03-29T14:09:15.596828Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2024-03-29T14:09:15.993636Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
2024-03-29T14:09:15.994207Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-03-29T14:09:15.994239Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-03-29T14:09:15.995088Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.20.04.1)  (Ubuntu).
2024-03-29T14:09:16.495777Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.20.04.1) starting as process 10063
2024-03-29T14:09:16.503236Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2024-03-29T14:09:16.503298Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
. This redo log was created with MySQL 5.7.26, and it appears corrupted. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html
2024-03-29T14:09:37.503225Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2024-03-29T14:09:37.910564Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
2024-03-29T14:09:37.910983Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-03-29T14:09:37.911012Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-03-29T14:09:37.911627Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.20.04.1)  (Ubuntu).
2024-03-29T14:09:38.514501Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.20.04.1) starting as process 10194
2024-03-29T14:09:38.523536Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2024-03-29T14:09:38.523590Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-03-29T14:09:38.766657Z 1 [ERROR] [MY-012525] [InnoDB] Upgrade after a crash is not supported. This redo log was created with MySQL 5.7.26, and it appears corrupted. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html
2024-03-29T14:09:38.766696Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2024-03-29T14:09:39.167240Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
2024-03-29T14:09:39.167630Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-03-29T14:09:39.167686Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-03-29T14:09:39.168330Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.20.04.1)  (Ubuntu).
2024-03-29T14:09:39.775465Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.20.04.1) starting as process 10215
2024-03-29T14:09:39.783758Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2024-03-29T14:09:39.783824Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-03-29T14:09:40.036337Z 1 [ERROR] [MY-012525] [InnoDB] Upgrade after a crash is not supported. This redo log was created with MySQL 5.7.26, and it appears corrupted. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html
2024-03-29T14:09:40.036376Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2024-03-29T14:09:40.434743Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
2024-03-29T14:09:40.435120Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-03-29T14:09:40.435147Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-03-29T14:09:40.435689Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.20.04.1)  (Ubuntu).
2024-03-29T14:09:41.025270Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.20.04.1) starting as process 10236
2024-03-29T14:09:41.034046Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2024-03-29T14:09:41.034106Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-03-29T14:09:41.265921Z 1 [ERROR] [MY-012525] [InnoDB] Upgrade after a crash is not supported. This redo log was created with MySQL 5.7.26, and it appears corrupted. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html
2024-03-29T14:09:41.265978Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2024-03-29T14:09:41.670739Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
2024-03-29T14:09:41.671170Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-03-29T14:09:41.671198Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-03-29T14:09:41.671951Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.20.04.1)  (Ubuntu).
2024-03-29T14:10:22.694616Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.20.04.1) starting as process 10273
2024-03-29T14:10:22.703527Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2024-03-29T14:10:22.703579Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-03-29T14:10:22.953040Z 1 [ERROR] [MY-012525] [InnoDB] Upgrade after a crash is not supported. This redo log was created with MySQL 5.7.26, and it appears corrupted. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html
2024-03-29T14:10:22.953079Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2024-03-29T14:10:23.341415Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
2024-03-29T14:10:23.341764Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-03-29T14:10:23.341789Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-03-29T14:10:23.342372Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.20.04.1)  (Ubuntu).
2024-03-29T14:10:24.005494Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.20.04.1) starting as process 10294
2024-03-29T14:10:24.015067Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2024-03-29T14:10:24.015128Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-03-29T14:10:24.236218Z 1 [ERROR] [MY-012525] [InnoDB] Upgrade after a crash is not supported. This redo log was created with MySQL 5.7.26, and it appears corrupted. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html
2024-03-29T14:10:24.236289Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2024-03-29T14:10:24.628650Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
2024-03-29T14:10:24.629044Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-03-29T14:10:24.629074Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-03-29T14:10:24.629632Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.20.04.1)  (Ubuntu).
2024-03-29T14:10:25.257792Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.20.04.1) starting as process 10315
2024-03-29T14:10:25.268892Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2024-03-29T14:10:25.268951Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-03-29T14:10:25.480982Z 1 [ERROR] [MY-012525] [InnoDB] Upgrade after a crash is not supported. This redo log was created with MySQL 5.7.26, and it appears corrupted. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html
2024-03-29T14:10:25.481021Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2024-03-29T14:10:25.883582Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
2024-03-29T14:10:25.883972Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-03-29T14:10:25.884001Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-03-29T14:10:25.884698Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.20.04.1)  (Ubuntu).
2024-03-29T14:10:26.505315Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.20.04.1) starting as process 10336
2024-03-29T14:10:26.514776Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2024-03-29T14:10:26.514837Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-03-29T14:10:26.730962Z 1 [ERROR] [MY-012525] [InnoDB] Upgrade after a crash is not supported. This redo log was created with MySQL 5.7.26, and it appears corrupted. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html
2024-03-29T14:10:26.731005Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2024-03-29T14:10:27.122896Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
2024-03-29T14:10:27.123297Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-03-29T14:10:27.123330Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-03-29T14:10:27.124008Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.20.04.1)  (Ubuntu).
2024-03-29T14:10:27.751307Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.20.04.1) starting as process 10357
2024-03-29T14:10:27.760670Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2024-03-29T14:10:27.760736Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-03-29T14:10:27.968990Z 1 [ERROR] [MY-012525] [InnoDB] Upgrade after a crash is not supported. This redo log was created with MySQL 5.7.26, and it appears corrupted. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html
2024-03-29T14:10:27.969027Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2024-03-29T14:10:28.362225Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
2024-03-29T14:10:28.362768Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-03-29T14:10:28.362792Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-03-29T14:10:28.363286Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.20.04.1)  (Ubuntu).
2024-03-29T14:13:37.451233Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.20.04.1) starting as process 10393
2024-03-29T14:13:37.460404Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2024-03-29T14:13:37.460464Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-03-29T14:13:37.690004Z 1 [ERROR] [MY-012525] [InnoDB] Upgrade after a crash is not supported. This redo log was created with MySQL 5.7.26, and it appears corrupted. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html
2024-03-29T14:13:37.690077Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2024-03-29T14:13:38.095646Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
2024-03-29T14:13:38.095943Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-03-29T14:13:38.095967Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-03-29T14:13:38.096436Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.20.04.1)  (Ubuntu).
2024-03-29T14:13:38.749467Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.20.04.1) starting as process 10414
2024-03-29T14:13:38.757588Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2024-03-29T14:13:38.757669Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-03-29T14:13:38.983641Z 1 [ERROR] [MY-012525] [InnoDB] Upgrade after a crash is not supported. This redo log was created with MySQL 5.7.26, and it appears corrupted. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html
2024-03-29T14:13:38.983681Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2024-03-29T14:13:39.385389Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
2024-03-29T14:13:39.385869Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-03-29T14:13:39.385916Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-03-29T14:13:39.386486Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.20.04.1)  (Ubuntu).
2024-03-29T14:13:39.999690Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.20.04.1) starting as process 10435
2024-03-29T14:13:40.008844Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2024-03-29T14:13:40.008915Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-03-29T14:13:40.250274Z 1 [ERROR] [MY-012525] [InnoDB] Upgrade after a crash is not supported. This redo log was created with MySQL 5.7.26, and it appears corrupted. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html
2024-03-29T14:13:40.250313Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2024-03-29T14:13:40.653120Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
2024-03-29T14:13:40.653511Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-03-29T14:13:40.653541Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-03-29T14:13:40.654088Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.20.04.1)  (Ubuntu).
2024-03-29T14:13:41.247372Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.20.04.1) starting as process 10456
2024-03-29T14:13:41.256978Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2024-03-29T14:13:41.257032Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-03-29T14:13:41.484675Z 1 [ERROR] [MY-012525] [InnoDB] Upgrade after a crash is not supported. This redo log was created with MySQL 5.7.26, and it appears corrupted. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html
2024-03-29T14:13:41.484714Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2024-03-29T14:13:41.894657Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
2024-03-29T14:13:41.894995Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-03-29T14:13:41.895018Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-03-29T14:13:41.895554Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.20.04.1)  (Ubuntu).
2024-03-29T14:13:42.498496Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.20.04.1) starting as process 10477
2024-03-29T14:13:42.506872Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2024-03-29T14:13:42.506944Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-03-29T14:13:42.753408Z 1 [ERROR] [MY-012525] [InnoDB] Upgrade after a crash is not supported. This redo log was created with MySQL 5.7.26, and it appears corrupted. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html
2024-03-29T14:13:42.753448Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2024-03-29T14:13:43.157450Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
2024-03-29T14:13:43.157953Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-03-29T14:13:43.157982Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-03-29T14:13:43.158655Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.20.04.1)  (Ubuntu).
2024-03-29T14:21:55.970061Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.20.04.1) starting as process 10563
2024-03-29T14:21:55.979077Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2024-03-29T14:21:55.979158Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-03-29T14:21:56.238367Z 1 [ERROR] [MY-012525] [InnoDB] Upgrade after a crash is not supported. This redo log was created with MySQL 5.7.26, and it appears corrupted. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html
2024-03-29T14:21:56.238427Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2024-03-29T14:21:56.644888Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
2024-03-29T14:21:56.645254Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-03-29T14:21:56.645284Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-03-29T14:21:56.645984Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.20.04.1)  (Ubuntu).
2024-03-29T14:21:57.269659Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.20.04.1) starting as process 10591
2024-03-29T14:21:57.279542Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2024-03-29T14:21:57.279605Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-03-29T14:21:57.507913Z 1 [ERROR] [MY-012525] [InnoDB] Upgrade after a crash is not supported. This redo log was created with MySQL 5.7.26, and it appears corrupted. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html
2024-03-29T14:21:57.507952Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2024-03-29T14:21:57.902418Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
2024-03-29T14:21:57.902836Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-03-29T14:21:57.902867Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-03-29T14:21:57.903369Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.20.04.1)  (Ubuntu).
2024-03-29T14:21:58.514538Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.20.04.1) starting as process 10613
24

By the way, the total data size is 600 GB, could it have something to do with its size?

25

Not at all. My customers usually have multi-TB of data in MySQL. Not an issue.

Reading over the error log, it looks like your original MySQL server was 5.7, but you installed 8.0 in this new server. That’s going to cause you even more headaches so let’s not do that.

Remove the 8.0 packages from your Ubuntu and install the latest 5.7 packages.

Then, you need to repeat the steps again from my previous post because the restored backup in /var/lib/mysql is now tainted and it would be better to just start with a fresh 5.7 backup.

26

I did it again verbatim but the result is still the same, here are the logs

2024-03-29T17:28:46.286272Z 0 [Note] Binlog end
2024-03-29T17:28:46.286792Z 0 [Note] Shutting down plugin 'auth_socket'
2024-03-29T17:28:46.286804Z 0 [Note] Shutting down plugin 'ngram'
2024-03-29T17:28:46.286808Z 0 [Note] Shutting down plugin 'partition'
2024-03-29T17:28:46.286812Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2024-03-29T17:28:46.286816Z 0 [Note] Shutting down plugin 'ARCHIVE'
2024-03-29T17:28:46.286819Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2024-03-29T17:28:46.286837Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2024-03-29T17:28:46.286849Z 0 [Note] Shutting down plugin 'MyISAM'
2024-03-29T17:28:46.286853Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2024-03-29T17:28:46.286857Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2024-03-29T17:28:46.286877Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2024-03-29T17:28:46.286880Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2024-03-29T17:28:46.286883Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2024-03-29T17:28:46.286886Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2024-03-29T17:28:46.286889Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2024-03-29T17:28:46.286892Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2024-03-29T17:28:46.286895Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2024-03-29T17:28:46.286915Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2024-03-29T17:28:46.286918Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2024-03-29T17:28:46.286921Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2024-03-29T17:28:46.286924Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2024-03-29T17:28:46.286927Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2024-03-29T17:28:46.286929Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2024-03-29T17:28:46.286932Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2024-03-29T17:28:46.286935Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2024-03-29T17:28:46.286963Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2024-03-29T17:28:46.286966Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2024-03-29T17:28:46.286969Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2024-03-29T17:28:46.286972Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2024-03-29T17:28:46.286974Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2024-03-29T17:28:46.286977Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2024-03-29T17:28:46.286980Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2024-03-29T17:28:46.286983Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2024-03-29T17:28:46.287003Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2024-03-29T17:28:46.287006Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2024-03-29T17:28:46.287009Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2024-03-29T17:28:46.287012Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2024-03-29T17:28:46.287015Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2024-03-29T17:28:46.287018Z 0 [Note] Shutting down plugin 'InnoDB'
2024-03-29T17:28:46.287136Z 0 [Note] InnoDB: FTS optimize thread exiting.
2024-03-29T17:28:46.287252Z 0 [Note] InnoDB: Starting shutdown...
2024-03-29T17:28:46.387497Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2024-03-29T17:28:46.387931Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 240329 17:28:46
2024-03-29T17:28:48.104336Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2767117
2024-03-29T17:28:48.106401Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-03-29T17:28:48.106420Z 0 [Note] Shutting down plugin 'MEMORY'
2024-03-29T17:28:48.106426Z 0 [Note] Shutting down plugin 'CSV'
2024-03-29T17:28:48.106431Z 0 [Note] Shutting down plugin 'sha256_password'
2024-03-29T17:28:48.106434Z 0 [Note] Shutting down plugin 'mysql_native_password'
2024-03-29T17:28:48.106626Z 0 [Note] Shutting down plugin 'binlog'
2024-03-29T17:28:48.107428Z 0 [Note] mysqld: Shutdown complete

2024-03-29T17:28:48.463134Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2024-03-29T17:28:48.465580Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.42) starting as process 16495 ...
2024-03-29T17:28:48.468934Z 0 [Note] InnoDB: PUNCH HOLE support available
2024-03-29T17:28:48.468963Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2024-03-29T17:28:48.468967Z 0 [Note] InnoDB: Uses event mutexes
2024-03-29T17:28:48.468971Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2024-03-29T17:28:48.468974Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2024-03-29T17:28:48.468978Z 0 [Note] InnoDB: Using Linux native AIO
2024-03-29T17:28:48.469348Z 0 [Note] InnoDB: Number of pools: 1
2024-03-29T17:28:48.469477Z 0 [Note] InnoDB: Using CPU crc32 instructions
2024-03-29T17:28:48.471278Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2024-03-29T17:28:48.480089Z 0 [Note] InnoDB: Completed initialization of buffer pool
2024-03-29T17:28:48.482574Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2024-03-29T17:28:48.495314Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2024-03-29T17:28:48.509335Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-03-29T17:28:48.509403Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-03-29T17:28:48.579485Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2024-03-29T17:28:48.579980Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2024-03-29T17:28:48.579990Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2024-03-29T17:28:48.581452Z 0 [Note] InnoDB: 5.7.42 started; log sequence number 2767117
2024-03-29T17:28:48.581661Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2024-03-29T17:28:48.581965Z 0 [Note] Plugin 'FEDERATED' is disabled.
2024-03-29T17:28:48.584776Z 0 [Note] InnoDB: Buffer pool(s) load completed at 240329 17:28:48
2024-03-29T17:28:48.588006Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2024-03-29T17:28:48.588023Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2024-03-29T17:28:48.588027Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2024-03-29T17:28:48.588029Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2024-03-29T17:28:48.588426Z 0 [Warning] CA certificate ca.pem is self signed.
2024-03-29T17:28:48.588456Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2024-03-29T17:28:48.588874Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2024-03-29T17:28:48.588886Z 0 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2024-03-29T17:28:48.588913Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2024-03-29T17:28:48.596788Z 0 [Note] Event Scheduler: Loaded 0 events
2024-03-29T17:28:48.597139Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.42'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server (GPL)
2024-03-29T17:32:06.128502Z 0 [Note] Giving 0 client threads a chance to die gracefully
2024-03-29T17:32:06.128541Z 0 [Note] Shutting down slave threads
2024-03-29T17:32:06.128570Z 0 [Note] Forcefully disconnecting 0 remaining clients
2024-03-29T17:32:06.128579Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2024-03-29T17:32:06.128636Z 0 [Note] Binlog end
2024-03-29T17:32:06.129272Z 0 [Note] Shutting down plugin 'auth_socket'
2024-03-29T17:32:06.129286Z 0 [Note] Shutting down plugin 'ngram'
2024-03-29T17:32:06.129292Z 0 [Note] Shutting down plugin 'partition'
2024-03-29T17:32:06.129297Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2024-03-29T17:32:06.129303Z 0 [Note] Shutting down plugin 'ARCHIVE'
2024-03-29T17:32:06.129308Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2024-03-29T17:32:06.129349Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2024-03-29T17:32:06.129357Z 0 [Note] Shutting down plugin 'MyISAM'
2024-03-29T17:32:06.129365Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2024-03-29T17:32:06.129370Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2024-03-29T17:32:06.129375Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2024-03-29T17:32:06.129379Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2024-03-29T17:32:06.129383Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2024-03-29T17:32:06.129388Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2024-03-29T17:32:06.129392Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2024-03-29T17:32:06.129397Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2024-03-29T17:32:06.129401Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2024-03-29T17:32:06.129406Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2024-03-29T17:32:06.129410Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2024-03-29T17:32:06.129415Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2024-03-29T17:32:06.129419Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2024-03-29T17:32:06.129423Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2024-03-29T17:32:06.129428Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2024-03-29T17:32:06.129432Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2024-03-29T17:32:06.129437Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2024-03-29T17:32:06.129441Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2024-03-29T17:32:06.129446Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2024-03-29T17:32:06.129450Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2024-03-29T17:32:06.129454Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2024-03-29T17:32:06.129459Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2024-03-29T17:32:06.129474Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2024-03-29T17:32:06.129479Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2024-03-29T17:32:06.129484Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2024-03-29T17:32:06.129489Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2024-03-29T17:32:06.129493Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2024-03-29T17:32:06.129497Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2024-03-29T17:32:06.129502Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2024-03-29T17:32:06.129506Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2024-03-29T17:32:06.129510Z 0 [Note] Shutting down plugin 'InnoDB'
2024-03-29T17:32:06.129587Z 0 [Note] InnoDB: FTS optimize thread exiting.
2024-03-29T17:32:06.129762Z 0 [Note] InnoDB: Starting shutdown...
2024-03-29T17:32:06.230098Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2024-03-29T17:32:06.230548Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 240329 17:32:06
2024-03-29T17:32:07.449919Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2767145
2024-03-29T17:32:07.451937Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-03-29T17:32:07.451951Z 0 [Note] Shutting down plugin 'MEMORY'
2024-03-29T17:32:07.451957Z 0 [Note] Shutting down plugin 'CSV'
2024-03-29T17:32:07.451962Z 0 [Note] Shutting down plugin 'sha256_password'
2024-03-29T17:32:07.451964Z 0 [Note] Shutting down plugin 'mysql_native_password'
2024-03-29T17:32:07.452148Z 0 [Note] Shutting down plugin 'binlog'
2024-03-29T17:32:07.452689Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2024-03-29T19:07:48.444809Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2024-03-29T19:07:48.447346Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.42) starting as process 17541 ...
2024-03-29T19:07:48.454526Z 0 [Note] InnoDB: PUNCH HOLE support available
2024-03-29T19:07:48.454562Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2024-03-29T19:07:48.454567Z 0 [Note] InnoDB: Uses event mutexes
2024-03-29T19:07:48.454571Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2024-03-29T19:07:48.454575Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2024-03-29T19:07:48.454579Z 0 [Note] InnoDB: Using Linux native AIO
2024-03-29T19:07:48.454922Z 0 [Note] InnoDB: Number of pools: 1
2024-03-29T19:07:48.455656Z 0 [Note] InnoDB: Using CPU crc32 instructions
2024-03-29T19:07:48.458591Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2024-03-29T19:07:48.467995Z 0 [Note] InnoDB: Completed initialization of buffer pool
2024-03-29T19:07:48.470536Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2024-03-29T19:07:48.483025Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2024-03-29T19:07:48.484176Z 0 [ERROR] InnoDB: Log block 209172377 at lsn 15500259045376 has valid header, but checksum field contains 284426792, should be 3048224654
2024-03-29T19:07:48.484195Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 15500259045774 and the end 15500259045376.
2024-03-29T19:07:48.484204Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2024-03-29T19:07:49.084991Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2024-03-29T19:07:49.085023Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2024-03-29T19:07:49.085030Z 0 [ERROR] Failed to initialize builtin plugins.
2024-03-29T19:07:49.085034Z 0 [ERROR] Aborting

2024-03-29T19:07:49.085085Z 0 [Note] Binlog end
2024-03-29T19:07:49.085186Z 0 [Note] Shutting down plugin 'CSV'
2024-03-29T19:07:49.085589Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2024-03-29T19:07:49.580154Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2024-03-29T19:07:49.582225Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.42) starting as process 17595 ...
2024-03-29T19:07:49.586500Z 0 [Note] InnoDB: PUNCH HOLE support available
2024-03-29T19:07:49.586532Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2024-03-29T19:07:49.586536Z 0 [Note] InnoDB: Uses event mutexes
2024-03-29T19:07:49.586540Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2024-03-29T19:07:49.586543Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2024-03-29T19:07:49.586546Z 0 [Note] InnoDB: Using Linux native AIO
2024-03-29T19:07:49.586839Z 0 [Note] InnoDB: Number of pools: 1
2024-03-29T19:07:49.587069Z 0 [Note] InnoDB: Using CPU crc32 instructions
2024-03-29T19:07:49.589003Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2024-03-29T19:07:49.596919Z 0 [Note] InnoDB: Completed initialization of buffer pool
2024-03-29T19:07:49.600293Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2024-03-29T19:07:49.613496Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2024-03-29T19:07:49.614733Z 0 [ERROR] InnoDB: Log block 209172377 at lsn 15500259045376 has valid header, but checksum field contains 284426792, should be 3048224654
2024-03-29T19:07:49.614748Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 15500259045774 and the end 15500259045376.
2024-03-29T19:07:49.614757Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2024-03-29T19:07:50.215550Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2024-03-29T19:07:50.215582Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2024-03-29T19:07:50.215589Z 0 [ERROR] Failed to initialize builtin plugins.
2024-03-29T19:07:50.215593Z 0 [ERROR] Aborting

2024-03-29T19:07:50.215642Z 0 [Note] Binlog end
2024-03-29T19:07:50.215707Z 0 [Note] Shutting down plugin 'CSV'
2024-03-29T19:07:50.215997Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2024-03-29T19:07:50.815549Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2024-03-29T19:07:50.817205Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.42) starting as process 17649 ...
2024-03-29T19:07:50.820387Z 0 [Note] InnoDB: PUNCH HOLE support available
2024-03-29T19:07:50.820433Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2024-03-29T19:07:50.820437Z 0 [Note] InnoDB: Uses event mutexes
2024-03-29T19:07:50.820440Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2024-03-29T19:07:50.820443Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2024-03-29T19:07:50.820447Z 0 [Note] InnoDB: Using Linux native AIO
2024-03-29T19:07:50.820708Z 0 [Note] InnoDB: Number of pools: 1
2024-03-29T19:07:50.820818Z 0 [Note] InnoDB: Using CPU crc32 instructions
2024-03-29T19:07:50.822976Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2024-03-29T19:07:50.831742Z 0 [Note] InnoDB: Completed initialization of buffer pool
2024-03-29T19:07:50.834677Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2024-03-29T19:07:50.847645Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2024-03-29T19:07:50.849144Z 0 [ERROR] InnoDB: Log block 209172377 at lsn 15500259045376 has valid header, but checksum field contains 284426792, should be 3048224654
2024-03-29T19:07:50.849179Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 15500259045774 and the end 15500259045376.
2024-03-29T19:07:50.849187Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2024-03-29T19:07:51.450141Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2024-03-29T19:07:51.450181Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2024-03-29T19:07:51.450201Z 0 [ERROR] Failed to initialize builtin plugins.
2024-03-29T19:07:51.450205Z 0 [ERROR] Aborting

2024-03-29T19:07:51.450241Z 0 [Note] Binlog end
2024-03-29T19:07:51.450310Z 0 [Note] Shutting down plugin 'CSV'
2024-03-29T19:07:51.450635Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2024-03-29T19:07:52.083899Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2024-03-29T19:07:52.085937Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.42) starting as process 17704 ...
2024-03-29T19:07:52.092163Z 0 [Note] InnoDB: PUNCH HOLE support available
2024-03-29T19:07:52.092193Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2024-03-29T19:07:52.092197Z 0 [Note] InnoDB: Uses event mutexes
2024-03-29T19:07:52.092201Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2024-03-29T19:07:52.092204Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2024-03-29T19:07:52.092208Z 0 [Note] InnoDB: Using Linux native AIO
2024-03-29T19:07:52.092438Z 0 [Note] InnoDB: Number of pools: 1
2024-03-29T19:07:52.092560Z 0 [Note] InnoDB: Using CPU crc32 instructions
2024-03-29T19:07:52.094691Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2024-03-29T19:07:52.104063Z 0 [Note] InnoDB: Completed initialization of buffer pool
2024-03-29T19:07:52.106665Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2024-03-29T19:07:52.119357Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2024-03-29T19:07:52.120313Z 0 [ERROR] InnoDB: Log block 209172377 at lsn 15500259045376 has valid header, but checksum field contains 284426792, should be 3048224654
2024-03-29T19:07:52.120330Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 15500259045774 and the end 15500259045376.
2024-03-29T19:07:52.120338Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2024-03-29T19:07:52.721227Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2024-03-29T19:07:52.721264Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2024-03-29T19:07:52.721271Z 0 [ERROR] Failed to initialize builtin plugins.
2024-03-29T19:07:52.721275Z 0 [ERROR] Aborting

2024-03-29T19:07:52.721316Z 0 [Note] Binlog end
2024-03-29T19:07:52.721401Z 0 [Note] Shutting down plugin 'CSV'
2024-03-29T19:07:52.721739Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2024-03-29T19:07:53.327292Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2024-03-29T19:07:53.330243Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.42) starting as process 17759 ...
2024-03-29T19:07:53.333624Z 0 [Note] InnoDB: PUNCH HOLE support available
2024-03-29T19:07:53.333670Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2024-03-29T19:07:53.333675Z 0 [Note] InnoDB: Uses event mutexes
2024-03-29T19:07:53.333679Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2024-03-29T19:07:53.333683Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2024-03-29T19:07:53.333686Z 0 [Note] InnoDB: Using Linux native AIO
2024-03-29T19:07:53.333980Z 0 [Note] InnoDB: Number of pools: 1
2024-03-29T19:07:53.334115Z 0 [Note] InnoDB: Using CPU crc32 instructions
2024-03-29T19:07:53.336882Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2024-03-29T19:07:53.345302Z 0 [Note] InnoDB: Completed initialization of buffer pool
2024-03-29T19:07:53.347462Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2024-03-29T19:07:53.360550Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2024-03-29T19:07:53.362304Z 0 [ERROR] InnoDB: Log block 209172377 at lsn 15500259045376 has valid header, but checksum field contains 284426792, should be 3048224654
2024-03-29T19:07:53.362336Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 15500259045774 and the end 15500259045376.
2024-03-29T19:07:53.362346Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2024-03-29T19:07:53.963236Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2024-03-29T19:07:53.963297Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2024-03-29T19:07:53.963304Z 0 [ERROR] Failed to initialize builtin plugins.
2024-03-29T19:07:53.963309Z 0 [ERROR] Aborting

2024-03-29T19:07:53.963420Z 0 [Note] Binlog end
2024-03-29T19:07:53.963536Z 0 [Note] Shutting down plugin 'CSV'
2024-03-29T19:07:53.963899Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
27

SrzDAwuBwbXh
SrzDAwuBwbXh1392×653 7.25 KB

I fixed it but the tables were not loaded

ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: NO)

now I think it wants me to log in with the root username, but I created it with the name mysql. What does this mean? Can I reset the password?

*Also, I do not remember the password of the mysql server from which I took these backups 1 year ago, is this necessary for restore?

28

This right here says MySQL successfully started and was running for almost 4 minutes before something shut it down again.

I see you are trying to login with the username ‘mysql’ and you successfully did so. Unfortunately, the ‘mysql’ user does not have any permissions to view any data.

Yes. Stop mysql. Edit the /etc/my.cnf file. Look for the section [mysqld] add this line:

skip-grant-tables

Save, and exit the file. Start mysql backup. You’ll be able to login as root without a password. Use this opportunity to dump all the tables.

29

fehQbAfX3rrW
fehQbAfX3rrW824×351 2.46 KB

/etc/my.cnf, there is nothing in this file path, but I found these in /etc/mysql
Should I add [mysqld] skip-grant-tables inside my.cnf? or only skip-grant-tables, can you please explain in a little more detail?

4TZ3m1hbBvXB
4TZ3m1hbBvXB887×574 9.22 KB

This is what the inside of my.cnf looks like, is it true file?

30

Yes, sorry, I forgot Ubuntu does it differently. Look in /etc/mysql/conf.d/ for a mysqld.cnf file or similar.

1 Like
31

thank you so much for your help, you are amazing!

32

I take it that means you can see your data now? If so, you can
use mysqldump --all-databases -uroot >backup.sql to dump everything.

1 Like
33

Yes, I found this command on the internet and saved my data, thank you again, god bless you.