Error Code 2013. Lost Connection To Mysql Server During Query
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 mysql workbench error code 2013. lost connection to mysql server during query Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs
Error Code 2013lost Connection To Mysql Server During Query
Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, error 2013 lost connection to mysql server during query when dumping table just like you, 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 error 2013 lost connection to mysql server during query when dumping table at row server during query I 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
Error 2013 Lost Connection To Mysql Server During Query Sql Statement
question edited Apr 22 at 3:19 asked Mar 29 '13 at 22:40 Omar 3,02774480 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,55471437 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... –Ljubi
server during query 600.135 sec" error message?(Windows 7 64-bit Ultimate, MySQL Workbench 5.2.47 CE)The following figure shows 6.5 sec instead of the usual ~600 seconds as it was fastest to illustrate:UpdateCancelAnswer Wiki1 Answer Franck error 2013 (hy000) lost connection to mysql server during query innodb Dernoncourt, PhD student in AI @ MITWritten 175w agohttp://bugs.mysql.com/bug.php?id...:Go to Preferences -> SQL Editor mysqldump error 2013 lost connection to mysql server during query when dumping table at row and set to a bigger value this parameter: DBMS connection read time out (in seconds) You might have to close and
2013 Lost Connection To Mysql Server During Query Phpmyadmin
re-open MySQL WorkBench. Eventually kill your previously query which probably is running, and run the query again.12.6k Views · View UpvotesView More AnswersRelated QuestionsHow will you explain max_allowed_packet in MySQL to someone new to MySQL?MySQL Workbench: http://stackoverflow.com/questions/15712512/mysql-workbench-how-to-keep-the-connection-alive How can I solve the "Current Profile Has no WMI enable" error message?How do I connect PHP to MySQL workbench?MySQL Workbench: How can I solve the "General error code: 1005 Can't create table '...' (errno: 150)" error message?MySQL Workbench: How can I solve the "Error while storing password" error message?MySQL Workbench: How can I solve the "ERROR 1206 The total number of locks exceeds the lock table size" error message?What kind https://www.quora.com/How-can-I-solve-the-Error-Code-2013-Lost-connection-to-MySQL-server-during-query-600-135-sec-error-message of error messages do you get with the MySQL Workbench?I am getting an error while trying to export data from mysql. I tried using workbench 6.0 and 6.1. The message is "Error retrieving version fr...How do I open a query window in MySQL workbench?Why can't MySql client connect using IP address?I need to learn enough MYSQL and MYSQL Workbench to help someone who had his helper disappear during the middle of a database project. Tutoria...How can I rename a schema with MySQL Workbench using MySQL 5.6?How do I setup a 250GB MySQL database?What do people think about the MySQL workbench?Does MySQL workbench work well on Maria DB?How can I have dark theme in MySQL Workbench?How do I select multiple relationships in MySQL Workbench?Why can't I edit this table in MySQL Workbench?How can I commit changes in MySql workbench?How can I have MySQL Workbench autocomplete with uppercase?Related QuestionsHow will you explain max_allowed_packet in MySQL to someone new to MySQL?MySQL Workbench: How can I solve the "Current Profile Has no WMI enable" error message?How do I connect PHP to MySQL workbench?MySQL Workbench: How can I solve the "General error code: 1005 Can't create table '...' (errno: 150)" error message?MySQL Workbench: How can I solve the "Error while storing password" error message?MySQL Workbench:
... 10 Oct: Better replacement patterns for databas ... 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 query 07 http://www.heidisql.com/forum.php?t=8568 Oct: Postgres tree 07 Oct: Feature Request 07 Oct: 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: 2 minor suggestions 05 Oct: Multiple "From IP"s in user manager DonateHow to donate List of donors HelpRequirements lost connection 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 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 lost connection to 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 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! 6577 posts ansgar posted 4 years ago This thread is one year old, btw. Well, however. I highly guess your connection is killed due to a short "interactive_timeout" variable? Look it up in HeidiSQL under "