Error No 2013 Lost Connection Mysql
Contents |
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 sqlyog error 2013 lost connection to mysql more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags sqlyog error no 2013 Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, error 2013 (hy000): lost connection to mysql server during query helping each other. Join them; it only takes a minute: Sign up MySQL Workbench: How to keep the connection alive up vote 39 down vote favorite 6 Error Code: 2013. Lost connection to MySQL server during query I
Lost Connection To Mysql Server At 'reading Initial Communication Packet' System Error 110
am using MySQL Workbench. Also, I am running a batch of inserts, about 1000 lines total (Ex. INSERT INTO mytable SELECT * FROM mysource1; INSERT INTO mytable SELECT * FROM mysource2;...mysource3...mysource4 multiplied 1000 times) Each batch takes a considerable amount of time, some of them, more than 600 seconds. How can I configure workbench, to continue working overnight, without stopping and without losing the connection? mysql sql mysql-workbench connection-timeout share|improve this question edited Apr 22 at 3:19 lost connection to mysql server at 'reading initial communication packet' system error 104 asked Mar 29 '13 at 22:40 Omar 3,02274480 add a comment| 6 Answers 6 active oldest votes up vote 95 down vote accepted Try this. Go to Edit -> Preferences -> SQL Editor and set to a higher value this parameter: DBMS connection read time out (in seconds). For instance: 86400. Close and reopen MySQL Workbench. Kill your previously query that probably is running and run the query again. share|improve this answer edited Jan 23 '15 at 19:06 Makyen 8,64371437 answered Mar 29 '13 at 22:49 Ignacio 1,450910 There is a bug in all version of MySQL Workbench beyond 6.0.x on Mac OS : stackoverflow.com/a/37890150/1014813 –lepix Jun 17 at 20:48 add a comment| up vote 19 down vote If you are using a "Standard TCP/IP over SSH" type of connection, under "Preferences"->"Others" there is "SSH KeepAlive" field. It took me quite a while to find it :( share|improve this answer answered Nov 13 '15 at 20:02 Ljubitel 30123 Why are you repeating an answer? –Jan Doggen Nov 13 '15 at 20:29 10 @JanDoggen I don't see any other answer that points where in MySQL Workbench you can change "SSH KeepAlive" which by default is 0 => disabled. I only see an answer that suggest to change server's ssh settings... –Ljubitel Nov 14 '15 at 21:27 This is the real an
Connectors More MySQL.com Downloads Developer Zone Section Menu: Documentation Home MySQL 5.7 Reference Manual Preface and Legal Notices General Information Installing and Upgrading MySQL Using MySQL as a lost connection to mysql server at 'reading initial communication packet' system error 113 Document Store Tutorial MySQL Programs MySQL Server Administration Security Backup and Recovery
Lost Connection To Mysql Server At 'reading Initial Communication Packet' System Error 111
Optimization Language Structure Globalization Data Types Functions and Operators SQL Statement Syntax The InnoDB Storage Engine Alternative Storage
Lost Connection To Mysql Server At 'reading Authorization Packet' System Error 0
Engines High Availability and Scalability Replication MySQL Cluster NDB 7.5 Partitioning Stored Programs and Views INFORMATION_SCHEMA Tables MySQL Performance Schema MySQL sys Schema Connectors and APIs Extending MySQL MySQL http://stackoverflow.com/questions/15712512/mysql-workbench-how-to-keep-the-connection-alive Enterprise Edition MySQL Workbench MySQL 5.7 Frequently Asked Questions Errors, Error Codes, and Common Problems Sources of Error Information Types of Error Values Server Error Codes and Messages Client Error Codes and Messages Problems and Common Errors How to Determine What Is Causing a Problem Common Errors When Using MySQL Programs Access denied Can't connect to [local] MySQL server https://dev.mysql.com/doc/refman/5.7/en/error-lost-connection.html Lost connection to MySQL server Client does not support authentication protocol Password Fails When Entered Interactively Host 'host_name' is blocked Too many connections Out of memory MySQL server has gone away Packet Too Large Communication Errors and Aborted Connections The table is full Can't create/write to file Commands out of sync Ignoring user Table 'tbl_name' doesn't exist Can't initialize character set File Not Found and Similar Errors Table-Corruption Issues Administration-Related Issues Problems with File Permissions How to Reset the Root Password What to Do If MySQL Keeps Crashing How MySQL Handles a Full Disk Where MySQL Stores Temporary Files How to Protect or Change the MySQL Unix Socket File Time Zone Problems Query-Related Issues Case Sensitivity in String Searches Problems Using DATE Columns Problems with NULL Values Problems with Column Aliases Rollback Failure for Nontransactional Tables Deleting Rows from Related Tables Solving Problems with No Matching Rows Problems with Floating-Point Values Optimizer-Related Issues Table Definition-Related Issues Problems with ALTER TABLE TEMPORARY Table Problems Known Issues in MySQL Restrictions and Limits Indexes MySQL Glossary Related Documentation MySQ
... 13 Oct: How to always show at first "Data" tab ... 13 Oct: Feature Request: Export sql, but one fi ... 13 Oct: Are sessions automatically closed at ha ... 13 Oct: How to export a Table "Data" content as ... 13 Oct: How to select different font and line h ... http://www.heidisql.com/forum.php?t=8568 13 Oct: "SHOW PROFILE[S]" is deprecated (and wi ... 13 Oct: unable to export database & http://dba.stackexchange.com/questions/124964/error-2013-hy000-lost-connection-to-mysql-server-during-query-while-load-of-my max row lim ... 13 Oct: Save session in command line 13 Oct: No connection to MySQL server through S ... 12 Oct: BUG: Kill running query when user doesn ... 12 Oct: Title bar buttons flicker in Windows 10 12 Oct: Cross apply 12 Oct: Feature request: "Connect to" menu to u ... 11 Oct: Feature request: enable SSL & set SSL-C ... 11 lost connection Oct: Better replacement patterns for databas ... 11 Oct: View Editor 11 Oct: Steps on using HeidiSQL 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 to MySQL server during query New topic Register Log in 13 posts swaiba posted 5 lost connection to 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 6590 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 the lastest libmysql.dll, but the warning still remains. Can someone tell me how should i configure HeidiSql in order to allow long querys without lossing connection? If i did the query on a MySql Command Line, i have no problem! neither with MySQL WorkBench! 6590 posts ansgar posted 4 years ago This thread is one year old, btw. Wel
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 d