Posted - 05/28/2012 : 15:03:20
| Just moved over to mysql. I am an analyst and not a DBA.
All was well until I started to join some big queries. I received back a 2013 error- lost connection. I looked that up, and it stated to change by net_read_timeout to more than 30.
I am running the most current MySQL on Mac. The mysql server is on my macbook. I only use it for queries.
I went to the mysql command prompt and typed in
show variables like "%timeout%";
It shows a table of all the timeouts. Great.
Then I try to change a value (the problem)
I typed at the mysql > net_read_timeout=90
It seems to take that, but then gives me a -> prompt.
Then I type show variables like "%timeout%"; I get a SQL error and it takes me back to mysql >. I type in show variables like "%timeout%" again, and it gives me all the same value again. Nothing was changed.
Obviously I am not typing in the right commands. Can anyone help? All I want to do it run my large queries.
Thanks for someone walking me through,