Developer Blog - Inventic.eu
  • Skipper - The ORM Designer
  • VsBuilds - Parallel building
  • Pulpo - Free Skipper CLI

Tag: #mysql

MySQL Strict mode

</p>
<p>SET GLOBAL sql_mode = 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';</p>
<p>SET GLOBAL sql_mode = 'modes';<br />
SET SESSION sql_mode = 'modes';</p>
<p>SELECT @@GLOBAL.sql_mode;<br />
SELECT @@SESSION.sql_mode;<br />

30 Jan 2015

Posted by: ludek.vodicka

Programming #mysql

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

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:

30 Jan 2015

Posted by: ludek.vodicka

Programming #mysql

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

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:

</p>
<p>[mysqld]<br />
max_allowed_packet = 64M<br />
wait_timeout = 6000</p>
<p>[mysqldump]<br />
max_allowed_packet = 64M</p>
<p>

External links

02 Sep 2013

Posted by: ludek.vodicka

Windows #Windows #mysql #srevice