MySQL Forums
Forum List  »  General

Is 40k rec table to big to import? (mysql server has gone away)
Posted by: Fran Lee
Date: April 11, 2018 07:57AM

We have a mysql db hosted online on a Microsoft Server. (shared hosting service that has worked fine in th past)

We are trying to import a new table with 40k+ records to the db but the import fails with the following error message.


ERROR
/*!40000 ALTER TABLE 'table name' DISABLE KEYS */;
MySQL said: ?
#2006 - MySQL server has gone away

If we break the table down to smaller tables of about 2.5k records each the import works so that tells us the table is OK.

Additional evidence the table is OK: We can import the entire table on our Windows IIS local host no problem


phpMyAdmin is running on the online server and we are using that to execute the import. We have used it before and imported a table with about 37k records.

Looking at the bottom of our screen we are prompted that the file is uploading... then get a notice that it is waiting on mysql... or some such.

First the host tec support told us the table was corrupted but we now know it is not.
Next they told us that a 2.5k import is extremely big... but we have done 37k in the past.

The Questions:
1 - Is importing a table with 40k+ records considered to big?
2 - Any idea what is going on here?
(I suspect the "shared host" has too many clients on it and the cpu can't keep up so the import is timing out... but what do you think?)

Thanks for any help.

Options: ReplyQuote


Subject
Written By
Posted
Is 40k rec table to big to import? (mysql server has gone away)
April 11, 2018 07:57AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.