Skip to content

Blog Inventic.eu

Notes and comments from ORM Designer development

Tag: mysql

MySQL Strict mode

2015/01/30 ludek.vodicka Leave a comment
SET GLOBAL sql_mode = 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

SET GLOBAL sql_mode = 'modes';
SET SESSION sql_mode = 'modes';

SELECT @@GLOBAL.sql_mode;
SELECT @@SESSION.sql_mode;

Error Code: 2006 – MySQL server has gone away when importing backup

2015/01/30 ludek.vodicka Leave a comment

The problem is probably caused by too large backup/restore script or SQL commands. The solution which works for me is increasing `max_allowed_packet` setting in my.ini

  • Open “c:\ProgramData\MySQL\MySQL Server 5.6\my.ini”
  • Change max_allowed_packet to 24M
  • Save and restart mysql service

External sources:

  • http://eppand.com/solution-to-mysql-error-2006-in-xampp/

ERROR 2006 (HY000) at line 1: MySQL server has gone away

2013/09/02 ludek.vodicka Leave a comment

Problem:

Getting error 2006 during database backup import. The problem is in short timeout and small packet size. It’s necessary to update my.cnf and restart MySql service.

Solution:

[mysqld]
max_allowed_packet = 64M
wait_timeout = 6000

[mysqldump]
max_allowed_packet = 64M

External links

  • http://stackoverflow.com/questions/13323833/error-2006-hy000-at-line-1-mysql-server-has-gone-away

Search

Categories

  • BMW
  • Features
  • Hardware
  • Internal
  • Linux
  • Mac OS
  • MinGW
  • OpenCart
  • Programming
  • Qt
  • Uncategorized
  • Web tools
  • Windows

Tags

Bash bugfix C++ certificate codesign command line crash cygwin debug debugging deploy developer fastcgi g++ gcc Git incredibuild installation java jenkins Linux mac MacOs mysql network nginx osx plugins Programming qml Qt root s3 signing application srevice ssh svn system templates terminal visual studio web Windows wordpress xslt

Blogroll

  • Inventic.eu
  • ORM Designer
WordPress Theme: Treville by ThemeZee.