mysql innodb corrupted after restoring backed up data through azure agent service
Budget: $30 – $250 USD
hello i m using microsoft azure backup service to perform automatic daily backup on my server
a day ago db crashed and got corrupted and every file was wiped out so I used azure backup to recover db data but to my surprise the data was corrupted and had the following error
2021-12-25T15:34:15.021552Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-12-25T15:34:15.021636Z 0 [Warning] '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.
2021-12-25T15:34:15.024708Z 0 [Note] C:\marketgold\server\bin\mysqld.exe (mysqld 5.7.36-log) starting as process 11944 ...
2021-12-25T15:34:15.025075Z 0 [ERROR] Can't find error-message file 'C:\marketgold\data\share\errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive.
2021-12-25T15:34:15.052443Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-12-25T15:34:15.053746Z 0 [Note] InnoDB: Uses event mutexes
2021-12-25T15:34:15.054377Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2021-12-25T15:34:15.055325Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-12-25T15:34:15.062870Z 0 [Note] InnoDB: Number of pools: 1
2021-12-25T15:34:15.067351Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2021-12-25T15:34:15.073505Z 0 [Note] InnoDB: Initializing buffer pool, total size = 95G, instances = 8, chunk size = 128M
2021-12-25T15:34:20.660110Z 0 [Note] InnoDB: Completed initialization of buffer pool
2021-12-25T15:34:21.786075Z 0 [ERROR] InnoDB: Space ID in fsp header is 258, but in the page header it is 16384.
2021-12-25T15:34:21.788574Z 0 [ERROR] InnoDB: Data file '.\ibdata1' uses page size 8192, but the innodb_page_size start-up parameter is 16384
2021-12-25T15:34:21.789925Z 0 [ERROR] InnoDB: Corrupted page [page id: space=4294967295, page number=0] of datafile '.\ibdata1' could not be found in the doublewrite buffer.
2021-12-25T15:34:21.791600Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2021-12-25T15:34:22.121664Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2021-12-25T15:34:22.122502Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2021-12-25T15:34:22.123388Z 0 [ERROR] Failed to initialize builtin plugins.
2021-12-25T15:34:22.124115Z 0 [ERROR] Aborting
2021-12-25T15:34:22.124619Z 0 [Note] Binlog end
2021-12-25T15:34:22.125175Z 0 [Note] Shutting down plugin 'CSV'
2021-12-25T15:34:22.126597Z 0 [Note]
any windows azure mysql expert could help me get back my data and repair this easily out there ?
thanks
a day ago db crashed and got corrupted and every file was wiped out so I used azure backup to recover db data but to my surprise the data was corrupted and had the following error
2021-12-25T15:34:15.021552Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-12-25T15:34:15.021636Z 0 [Warning] '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.
2021-12-25T15:34:15.024708Z 0 [Note] C:\marketgold\server\bin\mysqld.exe (mysqld 5.7.36-log) starting as process 11944 ...
2021-12-25T15:34:15.025075Z 0 [ERROR] Can't find error-message file 'C:\marketgold\data\share\errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive.
2021-12-25T15:34:15.052443Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-12-25T15:34:15.053746Z 0 [Note] InnoDB: Uses event mutexes
2021-12-25T15:34:15.054377Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2021-12-25T15:34:15.055325Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-12-25T15:34:15.062870Z 0 [Note] InnoDB: Number of pools: 1
2021-12-25T15:34:15.067351Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2021-12-25T15:34:15.073505Z 0 [Note] InnoDB: Initializing buffer pool, total size = 95G, instances = 8, chunk size = 128M
2021-12-25T15:34:20.660110Z 0 [Note] InnoDB: Completed initialization of buffer pool
2021-12-25T15:34:21.786075Z 0 [ERROR] InnoDB: Space ID in fsp header is 258, but in the page header it is 16384.
2021-12-25T15:34:21.788574Z 0 [ERROR] InnoDB: Data file '.\ibdata1' uses page size 8192, but the innodb_page_size start-up parameter is 16384
2021-12-25T15:34:21.789925Z 0 [ERROR] InnoDB: Corrupted page [page id: space=4294967295, page number=0] of datafile '.\ibdata1' could not be found in the doublewrite buffer.
2021-12-25T15:34:21.791600Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2021-12-25T15:34:22.121664Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2021-12-25T15:34:22.122502Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2021-12-25T15:34:22.123388Z 0 [ERROR] Failed to initialize builtin plugins.
2021-12-25T15:34:22.124115Z 0 [ERROR] Aborting
2021-12-25T15:34:22.124619Z 0 [Note] Binlog end
2021-12-25T15:34:22.125175Z 0 [Note] Shutting down plugin 'CSV'
2021-12-25T15:34:22.126597Z 0 [Note]
any windows azure mysql expert could help me get back my data and repair this easily out there ?
thanks