Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mylesg
Starting Member
1 Post |
 Posted - 2012-05-28 : 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=90It 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, |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-28 : 17:06:13
|
| this is a ms sql server forum. you might be better off posting it in some mysql forums i guess------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
set timeout value