Timeline for mariadb won't start (InnoDB error: space header page consists of zero bytes in data file ./ibdata1)
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 12, 2016 at 0:48 | comment | added | Rick James |
The 'restart' notices that ibdata1 is missing, so it builds a fresh one. (Note: no data, no tables, etc, will be in this fresh one.) I do not know why "zero bytes" happened in the first place.
|
|
| Nov 7, 2016 at 15:56 | comment | added | Gwyneth Llewelyn | Hmm. Seemed to work for me as well... | |
| Jan 6, 2016 at 17:28 | comment | added | Kojo | you made my day ! While I wanted to end up with a huge ibdata1 file, after a big cleanup, dumping then removing all db, renaming ibdata1 to ibdata1.bak, no way to restart sql. Once again simple is beautiful ! | |
| Dec 1, 2015 at 23:46 | review | Low quality posts | |||
| Dec 1, 2015 at 23:55 | |||||
| Dec 1, 2015 at 23:28 | history | answered | Rick James | CC BY-SA 3.0 |