CODEWITHSUNDEEP
mysqlload-data-infilemysql-error-2013
Ryan
Ryan

Reputation: 79

MySql Workbench Loses Connection with Long Running Query

I'm trying to import a large file (105 million rows, 5 columns) into mySQL using Load Data Infile and I keep getting Error Code: 2013 Lost connection to MySQL Server.

My question is two parts:

  1. How long is reasonable to extend the timeout so this doesn't happen?
  2. Will the Query Keep running even if MySQL Workbench isn't responding?

Upvotes: 0

Views: 158

Answers (0)

Related Questions