MYSQL Error MySQL Server wont start - Solved
Posted by: Mrwilson (
Date: November 16, 2022 08:37PM


Wampserver today would not start the MySQL server. Apache and PHP seem to be running, I can open the localhost page and any projects that do not use the database. How can I fix this without losing all of my projects? The problem appears to be confined to the family database. I cannot open MySQL to work on the issue, or even delete the database. Wampserver icon appears orange. I do have backups if I need to delete the Family database
Thank you for your consideration.

I have found the following information:
Win 10

Wampserver V 3.2.7 64bit
phpMyAdmin 4.8.5
php 7.3.5
Apache 2.4.39

MYSQL V 5.7.26
--- File cleaned up by Wampserver ---
--- on 2022-11-16 14:01
2022-11-16T14:02:06.554057Z 0 [ERROR] InnoDB: Space ID in fsp header is 2047597277, but in the page header it is 1417647010.
2022-11-16T14:02:06.555472Z 0 [ERROR] [FATAL] InnoDB: Tablespace id is 419 in the data dictionary but in file .\family\vanc.ibd it is 18446744073709551615!
2022-11-16 09:02:06 0x1164 InnoDB: Assertion failure in thread 4452 in file line 942

14:02:06 UTC - mysqld got exception 0x80000003 ;

7ff771093782 mysqld.exe!my_sigabrt_handler()[my_thr_init.c:449]
7ffac85fec9d MSVCR120.dll!raise()
7ffac8604874 MSVCR120.dll!abort()
7ff7711afdd4 mysqld.exe!ut_dbg_assertion_failed()[]
7ff7711affb1 mysqld.exe!ib::fatal::~fatal()[]
7ff7711d324d mysqld.exe!fil_node_open_file()[]
7ff7711d3b7c mysqld.exe!fil_node_prepare_for_io()[]
7ff7711d0a9e mysqld.exe!fil_io()[]
7ff77130b8c8 mysqld.exe!buf_read_page_low()[]
7ff77130b4de mysqld.exe!buf_read_page_background()[]
7ff771223657 mysqld.exe!buf_load()[]
7ff771223e4b mysqld.exe!buf_dump_thread()[]
7ffb00d074b4 KERNEL32.DLL!BaseThreadInitThunk()
7ffb010026a1 ntdll.dll!RtlUserThreadStart()


Edited 5 time(s). Last edit at 11/18/2022 04:56AM by Mrwilson.

Options: ReplyQuote

Sorry, only registered users may post in this forum.