MySQL server has gone away

[liguehs]

Hi,

I have a mysql Code that enters almost 3 500 entries,

but when I reach around 500 I get :

Cannot inset/update table!MySQL server has gone away

Has this has nothing to do with my programming problem, was wondering what should I do?

 

[misson]

Remember, you can always google error messages. The MySQL Reference Manual has information about this particular one in "B.1.2.9. MySQL server has gone away".

 

[descalzo]

Hi,

I have a mysql Code that enters almost 3 500 entries,

but when I reach around 500 I get :

Has this has nothing to do with my programming problem, was wondering what should I do?

Split the input into nine 400 entry chunks and do them one at a time.

Especially if your table has multiple indices, data entry can be bog down and you come up against timeouts.

Another option would be drop the indices, enter the data, and then add the indices one by one using ALTER TABLE

 

[liguehs]

I cant find my .htaccess file.....

I used filezilla, its not here, I used the 2 file manager and still cant find it....

 

[Brandon]

Why are you looking for your .htaccess file for? The solution to use would be descalzo's.

 

[jamessmith]

That just basically means MySQL has dropped the connection, perhaps by a socket error, or hard time out?