microsoft azure cloud - backup service to dedicated server - start now
$30-250 USD
Maksettu toimituksen yhteydessä
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 :
2020-12-19T02:01:42.340805Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\[login to view URL] (mysqld 5.7.31-log) starting as process 13484 ...
2020-12-19T02:01:42.375039Z 0 [Warning] option 'innodb-thread-concurrency': unsigned value 5000 adjusted to 1000
2020-12-19T02:01:42.376415Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-12-19T02:01:42.377066Z 0 [Note] InnoDB: Uses event mutexes
2020-12-19T02:01:42.377518Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2020-12-19T02:01:42.378161Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-12-19T02:01:42.383007Z 0 [Note] InnoDB: Number of pools: 1
2020-12-19T02:01:42.383678Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2020-12-19T02:01:42.387410Z 0 [Note] InnoDB: Initializing buffer pool, total size = 46G, instances = 16, chunk size = 128M
2020-12-19T02:01:45.642254Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-12-19T02:01:46.674254Z 0 [ERROR] InnoDB: Space ID in fsp header is 258, but in the page header it is 16384.
2020-12-19T02:01:46.675481Z 0 [ERROR] InnoDB: Data file '.\ibdata1' uses page size 8192, but the innodb_page_size start-up parameter is 16384
2020-12-19T02:01:46.676275Z 0 [ERROR] InnoDB: Corrupted page [page id: space=4294967295, page number=0] of datafile '.\ibdata1' could not be found in the doublewrite buffer.
2020-12-19T02:01:46.677307Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2020-12-19T02:01:46.980071Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2020-12-19T02:01:46.981555Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-12-19T02:01:46.982902Z 0 [ERROR] Failed to initialize builtin plugins.
i couldnt do anything about it
for the future i would like to make sure that when data is backed up that the data (especially the db data) will not be corrupted.
not an expert with microsoft azure cloud so maybe someone can be of any help ?
to be clear I only use azure cloud backup service to my own dedicated service that is all.
only apply if you have a solution to avoid this scenario in the future in an automated way preferably with existing microsoft azure cloud implementation
only apply if you can work and guide me now how to do
budget is 40$ max.
Projektin tunnus: #28635444
Tietoa projektista
Myönnetty käyttäjälle:
i will help i have a solution other then azure autobackup thing. you can hire me and i will apply fix immediately.