Error: 2006 - MySQL server has gone away

[[deleted]]

read this:
http://www.mysql.com/doc/en/Gone_away.html

[semtex]

You can also get these errors if you send a query to the server that is incorrect or too large. If mysqld gets a packet that is too large or out of order, it assumes that something has gone wrong with the client and closes the connection. If you need big queries (for example, if you are working with big BLOB columns), you can increase the query limit by starting mysqld with the -O max_allowed_packet=# option (default 1M). The extra memory is allocated on demand, so mysqld will use more memory only when you issue a big query or when mysqld must return a big result row!

How do I do this? I looked through it yesterday but found no way to increase the max_allowed_packet. How e.g. do I start mysqld?

Thanks for the help so far.

[[deleted]]

Ugh... You have a database but you don't know how to start it?

That suggests that the database is not under your control. Maybe you should leave this to the sysadmin?

[semtex]

I know how to start it and I know how to work with phpmyadmin and mysql-front (basics). But i just don't know how to start with the -O max_allowed_packet=# option

[[deleted]]

How do you start it normally?

[semtex]

I just double click the icon on my desktop and hit connect to connect to my database. Then it opens the database. If i click on variables i can see all of them but I cannot change anything there.

[Ph0eniX]

Originally posted by semtex
I just double click the icon on my desktop and hit connect to connect to my database. Then it opens the database. If i click on variables i can see all of them but I cannot change anything there.

All I can say is: haha

[piersk]

Why "haha"?

[semtex]

mmm... thought a forum was for everyone that needed help. even people that have less experience with mysql.
i suppose you're not interested in helping me?

[Ph0eniX]

Originally posted by semtex
mmm... thought a forum was for everyone that needed help. even people that have less experience with mysql.
i suppose you're not interested in helping me?

Not that I can help you figure out why your server is crashing based on the little info you've provided in your post but I found the way you described how you start MySQL funny. That's all. I dind't mean to be disrespectful.

[[deleted]]

Nevermind, there's always some idiot who likes to thing he's cool by making stupid posts like that.

It's his own pathetic little way of making himself look good. Don't be angry at him, have pity.

Semtex: double-clicking the icon probably launches the binary that runs the actual mysql server. Most likely you can rightclick the icon and see the command it executes. If you're lucky you can just add the parameters right there in the 'shortcut'.

[Ph0eniX]

Originally posted by vincente
Nevermind, there's always some idiot who likes to thing he's cool by making stupid posts like that.

It's his own pathetic little way of making himself look good. Don't be angry at him, have pity.


Semtex: double-clicking the icon probably launches the binary that runs the actual mysql server. Most likely you can rightclick the icon and see the command it executes. If you're lucky you can just add the parameters right there in the 'shortcut'.

umm, okay ...who's the idiot now? ...just read my reply to semtex

why bring drama to a drama-free board?