Error 2013 Lost Connection
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings error 2013 lost connection to mysql server during query when dumping and policies of this site About Us Learn more about Stack Overflow error 2013 lost connection to mysql server during query sql statement the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation mysqldump error 2013 lost connection to mysql server Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it error 2013 (hy000) lost connection to mysql only takes a minute: Sign up Error Code: 2013. Lost connection to MySQL server during query up vote 67 down vote favorite 22 I got the Error Code: 2013. Lost connection to MySQL server during query error when I tried to add an index to a table using MySQL Workbench. I noticed also that it appears whenever I run long query.
Error 2013 (hy000) Lost Connection To Mysql Server During Query Innodb
Is there away to increase the timeout value? mysql mysql-workbench share|improve this question edited Oct 6 at 8:06 agold 2,66571532 asked May 12 '12 at 12:14 user836026 2,50054582 add a comment| 16 Answers 16 active oldest votes up vote 118 down vote accepted New versions of MySQL WorkBench have an option to change specific timeouts. For me it was under Edit → Preferences → SQL Editor → DBMS connection read time out (in seconds): 600 Changed the value to 6000. Also unchecked limit rows as putting a limit in every time I want to search the whole data set gets tiresome. share|improve this answer edited Oct 8 '12 at 22:53 Marko 8,109102653 answered Oct 8 '12 at 22:49 eric william nord 1,204273 1 Is it possible to increase this limit over 99,999 seconds? The DBMS connection read time out field only accept up to 5 figures, and setting the field to 0 is equivalent to the default parameter (600 seconds). (Windows 7 64-bit Ultimate, MySQL Workbench 5.2.47 CE) –Franck Dernoncourt Jun 1 '13 at 21:30 1
... 10 Oct: Strange 1-Time Connect and then I have ... 09 Oct: Heidi duplicate row when i add new 08 Oct: Cross apply 08 Oct: HeidiSQL + SQLite 08 Oct: Title bar buttons flicker in Windows 10 07 Oct: Help with
Error Code 2013
query 07 Oct: Postgres tree 07 Oct: Feature Request 07 Oct: Revision 4514 "Donate" error 2013 (hy000): lost connection to mysql server at 'reading initial communication packet' button(s) 07 Oct: UI bug in window: User Manager? 06 Oct: ERROR: syntax error at or near "DETERMI ... 06 Oct: Crash lost connection to mysql during query when accessing database tab. 06 Oct: php query 06 Oct: Help.. lost connection to mysql server ... 06 Oct: Bug: Crash showing tooltip of MediumTex ... 05 Oct: 2 minor suggestions 05 Oct: Multiple "From http://stackoverflow.com/questions/10563619/error-code-2013-lost-connection-to-mysql-server-during-query IP"s in user manager 05 Oct: Remember queries between sessions (?RFC) DonateHow to donate List of donors HelpRequirements Connecting to a server Command line switches The database tree Creating a table Creating a view Creating a stored procedure Creating a trigger Creating a scheduled event The Data tab Running SQL queries SQL export HeidiSQL portable License Credits SQL Error(2013) Lost Connection: reading initial communication packet New topic Register Log in http://www.heidisql.com/forum.php?t=10835 3 posts stugol posted 4 years ago in Creating a connection Hi, I am able to connect to mysql on Hostgator over TCP, which works great but ssh has caused the following error: SQL Error (2013): Lost connection to MySQL server at 'reading inital communication packet', system error:0 I used putty and is ablke to connect to ssh and mysql without problems using the same credentials as below: Settings: Network type: MySQL (SSH Tunnel) Hostname/IP: 127.0.0.1 User: mysql_user Password: mysql_password Port: 3306 Database: mysql_database SSH Tunnel: plink location: plink_location ssh host: ssh_ip ssh port: 2222 user: ssh_user password: shh_password local port: 3307 Any help is much appreciated. 3 posts stugol posted 4 years ago Anyone? Thanks in advance. 6577 posts ansgar posted 4 years ago Probably too slow connection. Or something in the SSH server which does not work as expected. Well, just guesses here. It's very difficult to debug these tunnel connections. 3 posts stugol posted 4 years ago Thanks anse, probably not too slow as I could putty in manually. Thanks a million, the program rocks but too bad can't tunnel at this time. 6577 posts ansgar posted 4 years ago At least the error message "reading inital communication packet" tells me your tunnel works, as you al
... 10 Oct: Strange 1-Time Connect and then I have ... 09 Oct: Heidi duplicate row when i add new 08 Oct: Cross apply 08 Oct: HeidiSQL + SQLite 08 Oct: Title bar buttons flicker in Windows 10 07 http://www.heidisql.com/forum.php?t=8568 Oct: Help with query 07 Oct: Postgres tree 07 Oct: Feature Request 07 Oct: http://dba.stackexchange.com/questions/124964/error-2013-hy000-lost-connection-to-mysql-server-during-query-while-load-of-my Revision 4514 "Donate" button(s) 07 Oct: UI bug in window: User Manager? 06 Oct: ERROR: syntax error at or near "DETERMI ... 06 Oct: Crash when accessing database tab. 06 Oct: php query 06 Oct: Help.. lost connection to mysql server ... 06 Oct: Bug: Crash showing tooltip of MediumTex ... 05 Oct: lost connection 2 minor suggestions 05 Oct: Multiple "From IP"s in user manager 05 Oct: Remember queries between sessions (?RFC) DonateHow to donate List of donors HelpRequirements Connecting to a server Command line switches The database tree Creating a table Creating a view Creating a stored procedure Creating a trigger Creating a scheduled event The Data tab Running SQL queries SQL export HeidiSQL portable License Credits 2013 - Lost connection lost connection to to MySQL server during query New topic Register Log in 13 posts swaiba posted 5 years ago in General I am getting this all the time at the moment while trying to import a database... I've free'd up tons of memory and do nothing else with the machine... but at some point it just stops with this error. I have exported using heidisql and am inporting to an empty database locally 6577 posts ansgar posted 5 years ago Probably increase the maximum allowed packet size right before you import that file: SET @@global.max_allowed_packet = 1048576*10; What revision of HeidiSQL was used to create the export file? 13 posts swaiba posted 5 years ago I used both "stable 6" and "stable 6 + updates" - I'll try again with your suggestion... 30 posts combuilder posted 4 years ago I am receiving the same error when doing a long query, aprox after 113 seconds! I have a TCP-IP connection to a localhost! It doesn't matter if it's a query or if I run a procedure or function that exceed 2 minutes! I have SET @@global.max_allowed_packet = 1048576*10 but the problem remains. I have seen other solutions and i download th
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top error 2013 (hy000) lost connection to mysql server during query while load of mysqldump up vote 0 down vote favorite I'm trying to load mysqldump and I keep getting following error: ERROR 2013 (HY000) at line X: Lost connection to MySQL server during query /etc/my.cnf: [mysqld] max_allowed_packet = 16M net_read_timeout = 30 net_write_timeout = 60 ... [mysqldump] max_allowed_packet = 16M I tried to increase these values, but I keep getting that error no matter what( What else can I do to overcome this error? mysql mysqldump errors mysqladmin share|improve this question edited Jan 1 at 21:30 asked Jan 1 at 0:12 alexus 16511 Set the value in the [mysql] section of the config, as well? (Not [mysqladmin] though). SELECT @@MAX_ALLOWED_PACKET; to confirm that the server is using these values? –Michael - sqlbot Jan 1 at 4:15 @Michael-sqlbot I did typo, I meant to write mysqldump (not mysqldadmin), should I just keep max_allowed_packet or add net_read_timeout & net_write_timeout as well? –alexus Jan 1 at 21:27 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote The error code ERROR 2013 (HY000) related with aborted connection. You can run the following command to verify this. mysql> SHOW GLOBAL STATUS LIKE 'Aborted_connects'; If the counter getting increased one by each attempt to connect, then it is an issue with connection. One way to solve this issue, you can increase the connection timeout value in your configuration file. You can do that by using the following command. mysql> SET GLOBAL connect_timeout = 10; I hope this will help you. Thank you. share|improve this answer answered Jan 1 at 13:05 rathishDBA 5471722 right after I got error, I checked for Aborted_connects and it shows me 0. –alexus Jan 2 at 5:45 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as