Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2009
    Posts
    3

    Unanswered: Problem while restoring Backup files

    Hello,

    I try to restore the backup of my db (nearly 22 MB) using MySQL Admin 1.2.16 but I get error saying: "The server has returned this error message:MySQL server has gone away
    MySQL Error."
    The statement that causes error is an INSERT statement of a BLOB field with size 615264 bytes.
    I both tried restoring with the command line but it gives the same error.
    As I search internet about this error, some people get this error but they talk about GBs. My db is just 22MB, but I get the same error.

    Any suggestions, please?

  2. #2
    Join Date
    Jun 2007
    Posts
    197

    Smile

    Quote Originally Posted by xyzt
    Hello,

    I try to restore the backup of my db (nearly 22 MB) using MySQL Admin 1.2.16 but I get error saying: "The server has returned this error message:MySQL server has gone away
    MySQL Error."
    The statement that causes error is an INSERT statement of a BLOB field with size 615264 bytes.
    I both tried restoring with the command line but it gives the same error.
    As I search internet about this error, some people get this error but they talk about GBs. My db is just 22MB, but I get the same error.

    Any suggestions, please?
    Have you check the space on server

    just check df -h

  3. #3
    Join Date
    Feb 2009
    Posts
    3
    Sorry I forgot to specify, the server is Windows 2003 Server and there's 34GB free space. My backup file is just 22MB.

  4. #4
    Join Date
    Jun 2007
    Posts
    197

    Smile

    you can use

    mysql -u (user name) -p(password) database name <test.sql

    or

    mysql -u user -p(password)

    >source test.sql;

  5. #5
    Join Date
    Feb 2009
    Posts
    3
    Quote Originally Posted by ankur02018
    you can use

    mysql -u (user name) -p(password) database name <test.sql

    or

    mysql -u user -p(password)

    >source test.sql;
    I get the same error:
    "MySQL server has gone away"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •