I am using SQL Manager for MySQL (EMS) and generated a backup of my database. For each table I am grabbing about 100,000 records per block.
So, in the SQL Script it has INSERT x,y,z VALUES (1,2,3),... 100,000 times and then the next block.
The problem is MySQL is chocking and I get the error: "MySQL has gone away"
My guess is the problem probably is that it's either timing out (probably not since it gives me the error in under 2 seconds) or I have to configure MySQL
Question
roosevelt
Hi,
I am using SQL Manager for MySQL (EMS) and generated a backup of my database. For each table I am grabbing about 100,000 records per block.
So, in the SQL Script it has INSERT x,y,z VALUES (1,2,3),... 100,000 times and then the next block.
The problem is MySQL is chocking and I get the error: "MySQL has gone away"
My guess is the problem probably is that it's either timing out (probably not since it gives me the error in under 2 seconds) or I have to configure MySQL
to handle all those inserts in one shot.
Any ideas?
Link to comment
Share on other sites
3 answers to this question
Recommended Posts