Skip to main content

Recover /var/lib/mysql . . .

Comments

5 comments

  • kodeslogic
    Do you mean that out of 300 only 16 databases are visible and the remaining are not?
    0
  • addam
    No, sorry, None of the "recovered databases" have any data in the tables after attempting to recover. After attempting to recover and do a dump there are only blank tables. It's not importing the actual data from the backup.
    0
  • kodeslogic
    Is anything unusual in the MySQL error log file?
    0
  • addam
    Yes, Here it is. 2022-12-01T02:23:42.706795Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2022-12-01T02:24:57.669234Z 1 [ERROR] [MY-012224] [InnoDB] Header page consists of zero bytes in datafile: ./ibdata1, Space ID:0, Flags: 0. Please refer to MySQL :: MySQL 8.0 Reference Manual :: 15.21.4 Troubleshooting InnoDB Data Dictionary Operations for how to resolve the issue. 2022-12-01T02:24:57.669442Z 1 [ERROR] [MY-012237] [InnoDB] Corrupted page [page id: space=0, page number=0] of datafile './ibdata1' could not be found in the doublewrite buffer. 2022-12-01T02:24:57.669484Z 1 [ERROR] [MY-012960] [InnoDB] Cannot create redo log files because data files are corrupt or the database was not shut down cleanly after creating the data files. 2022-12-01T02:24:58.128673Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2022-12-01T02:24:58.129164Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2022-12-01T02:24:58.129473Z 0 [ERROR] [MY-010119] [Server] Aborting 2022-12-01T02:24:58.130852Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.31) MySQL Community Server - GPL. 2022-12-01T02:28:45.103446Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead. 2022-12-01T02:28:45.103473Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31) starting as process 187190 2022-12-01T02:28:45.116727Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2022-12-01T02:30:28.587085Z 1 [ERROR] [MY-012224] [InnoDB] Header page consists of zero bytes in datafile: ./ibdata1, Space ID:0, Flags: 0. Please refer to MySQL :: MySQL 8.0 Reference Manual :: 15.21.4 Troubleshooting InnoDB Data Dictionary Operations for how to resolve the issue. 2022-12-01T02:30:28.587299Z 1 [ERROR] [MY-012237] [InnoDB] Corrupted page [page id: space=0, page number=0] of datafile './ibdata1' could not be found in the doublewrite buffer. 2022-12-01T02:30:28.587353Z 1 [ERROR] [MY-012960] [InnoDB] Cannot create redo log files because data files are corrupt or the database was not shut down cleanly after creating the data files. 2022-12-01T02:30:29.053804Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2022-12-01T02:30:29.054178Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2022-12-01T02:30:29.054303Z 0 [ERROR] [MY-010119] [Server] Aborting 2022-12-01T02:30:29.055173Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.31) MySQL Community Server - GPL.
    0
  • kodeslogic
    There seem to be InnoDB related issues. Should be handled by a qualified system administrator as handling it wrong could cause further corruption. I would suggest you to reach out
    0

Please sign in to leave a comment.