MySQL 8 Panic - Help me migrate my tables

[Mind Rapist 888]

Hello community, I'vee been struggling all night long for a solution to this:

I started a new VM and I installed mysql80-server and configured everything. But when the time came to extract my game's db in the folder, the service died! I couldn't get it back, not without deleting everything I extracted. Since then, I've tried everything, this service hates my tables. I tried manually creating and importing the data 1 by 1 in sql files, error all the time! I tried to import data from another connection and you 'll never guess! It says that '0000-00-00 00:00:00' cannot be set as default value of a datetime field.

What do I have to do to get it working???