MySQL server has gone away

[dyluck]

Hi There.

 

I am having trouble with my script and I believe that I have some tweaking to do in MYSQL.

I am running a rather large query.  I am on a VPS and have full root access. 

I am not sure how large the actual query is as I believe it does change slightly. 

I think i need to tweek something in the MYSQL configuration to allow large inserts / updates and selects.  Has someone come across this error before or know of a fix?

 

Thanks,

 

 

 

[Hybride]

I had, it was on a hosting service for my company. I put it in the bug ticket, they said that they increased the timeout time on MySQL (so you do have to tinker with the settings a bit, just not sure which). Idk if that's the answer, as it didn't work for my sites, but that might be an option.

 

Also, you might try cutting up the file and uploading it in batches if it doesn't work. Painful, I know.

[scept1c]

Hybride, could you define more exactly the necessary option settings?

[Hybride]

It depends on the server, really. I don't actually have the options available to me, as I said, it was on a hosting company and they did the changing (but it didn't work, don't know why).

 

Anyway, my best guess would be to check your mysql configuration files, and depending on the installation, they should be somewhere in directory /usr/local/mysql/data.

 

This page might also be of some help: MySQL Server has gone away.