Error 2013: Lost connection to MySQL server during query when dumping table

General questions
1

I’m moving a Matomo site to a new server and I’m getting the following error when doing a mysqldump:

mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table matomo_log_action at row: 690579

Operation failed with exitcode 3
08:59:32 Export of S:\IS-DATA\matomo data\matomo 10092023.sql has finished with 1 errors

I have the following set in my.ini:
max_allowed_packet=1G
net_read_timeout=3600
net_write_timeout=3600

Any suggestions?

2

Hi @Selena
I found this:

How big is your source DB?

3

Thanks for your response! The db is 24g, and I received the error trying to do an export in Workbench. I finally was able to get an export via the command line then did an import in Workbench. Took a long time but it finally worked.

1 Like