Home / server / Questions / 240032
Accepted
blunders
Asked: 2011-02-25 12:49:50 +0800 CST

MySQL Database Restore error

  • 772

Getting the following error:

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

Which I get after running the following from the MySQL (5.1.53-community) command line:

CREATE DATABASE restoredb;

then this from the Windows 7 system command line:

mysql -u root -p restoredb < "C:\restoredb.sql"

I've tried another database restore using another file and the MySQL restore command works fine.

Questions, feedback, requests -- just comment, thanks!!

mysql database-restore

1 Answers

  1. Best Answer

    Put this in your my.ini (Win) or my.cnf (Linux)

    If running as a service, put under [mysqld]

    [mysqld]
max_allowed_packet=32M
    • 2