I have Version 8 demo project with me. I am trying to import the demo project SQL tables into my MySQL, Using MySQL Version 8.0 Workbench.
During Import i get the Error as attached
Most of the tables have been Imported into MySQL, however i believe there might an error on the particular line in that SQL text file which I have.
Sounds like the issue is with either the size of the import or the time it takes, and the limits for either being set too low.
ok thanks. let me look into the issues with respect to the MySQL settings and also with respect to my computer memory issue as mentioned in MySQL website
I'm getting this same error only a different line. I'm running MySQL on Windows. I've tried importing from the command line and increasing packet size and timeout based on Google results. (All seem to be 10+ years old) Can anyone share a solution to this problem?
Below is what finally worked for me:
Modify your my.ini configuration file
C:\ProgramData\MySQL\MySQL Server X.X\my.ini (Note: ProgramData is a hidden Windows folder).
add or modify the following
max_allowed_packet = 512M
wait_timeout = 28800
interactive_timeout = 28800
Restart the MySQL Windows Service
