MySQL server gone away


Hello , 

If your project is using many modules especially big modules, may be you will also come across this problem.

The problem was-
                          I was uploading my database in abc.com, then it was giving following error.

                          Error:  got a data bigger than max_allowed_packet 
                        
                          While uploading database from abc.com to localhost the error was:
                         
                          Error:  MySQL  server gone away

     This problem occurs because of large binary data storage in cache_menu table and sometimes because of cache_update table also.     

      To overcome this problem just increase the max_allowed_packet size.

      To increase  max_allowed_packet size you must have MySQL admin username and password. 
      Login to MySQL as admin. (For localhost you know your username and password!)
        
       1) Open your MySQL window and open your database (initially which is empty database).
       
       2) Click on SQL tab (where we write SQL queries).

       3)  Type:
                      SHOW VARIABLES LIKE 'max_allowed_packet';         (This will show you current max_allowed_packet size.)
                     
       4) Type:
                     set global net_buffer_length=1000000;                          (This will set buffer size)              

       5) Type:
                     set global max_allowed_packet=1000000000;                (This will set max_allowed_packet size to 1000000000 M)
      
       6) Now upload your database zip file as usual. You will never get above mentioned errors.

Comments

Post a Comment

Popular posts from this blog

PHP - How to increase size of POST value in php

Problem: PHP/HTML Forms with more the >20 fields(which approx post more the 1000 characters) will end up in error or the posted values will not be received in form action because by default in php  max_input_vars is set to 1000 . Solution:   In this case you can increase the size of  max_input_nesting_level and  max_input_vars in php.ini to resolve. max_input_nesting_level: Sets the max nesting depth of input variables (i.e. $_GET, $_POST.) max_input_vars How many input variables may be accepted (limit is applied to $_GET, $_POST and $_COOKIE superglobal separately). Use of this directive mitigates the possibility of denial of service attacks which use hash collisions. If there are more input variables than specified by this directive, an E_WARNING is issued, and further input variables are truncated from the request.
Read more

D8 KernelEvents constants

Here is a list of KernelEvents constants: KernelEvents::CONTROLLER ; // The CONTROLLER event occurs once a controller was found for handling a request. KernelEvents::EXCEPTION ; // The EXCEPTION event occurs when an uncaught exception appears. KernelEvents::FINISH_REQUEST ; //The FINISH_REQUEST event occurs when a response was generated for a request. KernelEvents::REQUEST ; // The REQUEST event occurs at the very beginning of request dispatching. KernelEvents::RESPONSE ; // The RESPONSE event occurs once a response was created for replying to a request. KernelEvents::TERMINATE ; // The TERMINATE event occurs once a response was sent. KernelEvents::VIEW ; // The VIEW event occurs when the return value of a controller is not a Response instance.
Read more

D8 - Attach file programmatically to a node

Scenario 1: If the file resides on the other server/website. Try the below code, use \Drupal\node\Entity\Node; /** Create file object from remote server/website URL. */ $data = file_get_contents('https://www.example.com/sites/default/files/logo.png'); $file = file_save_data($data, 'public://logo.png', FILE_EXISTS_REPLACE); // Create node object with attached file. $node = Node::create([   'type'        => 'article',   'title'       => 'Sample test',   'field_image' => [     'target_id' => $file->id(),   ], ]); $node->save(); Refer " file_save_data " API for more options/overide functions Scenario 2:  If the file resides on the same server/website. Try the below code, use \Drupal\node\Entity\Node; use \Drupal\file\Entity\File; // Create file object from a locally copied file. $uri  = file_unmanaged_copy('public://source.jpg', 'public://destination.jpg', ...
Read more