MySQL: restoring database and MySQL Server GONE AWAY....what is the reason ???

Categories

  • Wordpress 10
  • Magento 3
  • Apache 2
  • Database 2
  • MySQL 4
  • PostgreSQL 1
  • Unix 25
  • Windows 4
  • Mac OS 4
  • BBPress 1
  • HTML-CSS-JS 1
  • Python 3
  • Django 3
  • PHP 13
  • Miscellaneous 17

    • Latest post

    Monitor computer temperature in Ubuntu
    Monitor computer temperature in Ubuntu
    8 years ago
    Enable exfat in Ubuntu 14
    Enable exfat in Ubuntu 14
    9 years ago
    Remove duplicate items in multi-dimension array in PHP
    Remove duplicate items in multi-dimension array in PHP
    10 years ago
    Rename Apps in Django Admin
    Rename Apps in Django Admin
    10 years ago
    Cannot start Apache in MAMP/MAMP Pro on Yosemite 10.10
    Cannot start Apache in MAMP/MAMP Pro on Yosemite 10.10
    10 years ago
    Restore missing skype icon on status bar in Ubuntu 14
    Restore missing skype icon on status bar in Ubuntu 14
    10 years ago

    MySQL: restoring database and MySQL Server GONE AWAY....what is the reason ???

    Posted: 11 years ago in  Unix | Database | MySQL |


    This error is occurred when you try to restore big, very big database file. Hope the way I write here help you save a bit of time 8-)


    This error is occurred when you try to restore big, very big database file. Hope the way I write here help you save a bit of time 8-)

    The solution is quite simple by increase max_allowed_packet.

    Go to /etc/mysql and edit my.cnf

    Find max_allow_packet and change to 512M (it is fine for me to restore 400MB database file with 521MB)

    Good luck