Re: Duplicate Entry PRIMARY

[Peter Brawley]

> I am working with a commercial in confidence developed by someone else.

I don't understand that sentence. Please clarify.

To solve your problem, you'll need to study the mysql error log (a file usually named <machinename>.err in C:\ProgramData\MySQL\MySQL Server 8.0\data) for the error messages it produced at the time of the crash. Also perhaps the Windows event log for messages that explain the PC crash.

But if as you say you've "Little idea how SQL works, you'll have a hard time doing what's needed to fix the aftermath of a crash, so consider taking some time to learn about MySQL on data that doesn't matter, and meanwhile hiring someone who does know what she's doing with MySQL.