MySQL Restore issues

Posted on 2011-05-12
Last Modified: 2012-05-11
Good afternoon,
Ive been backing up my MySQL databases like a good boy every night, and archiving them off onto DVD, with no errors. Now I need to restore, and its all going wrong.

When I try and restore my database it seems to work for the first few seconds, and then get the message:-
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    143
Current database: tonelm2_odm

ERROR 2006 (HY000): MySQL server has gone away
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    144
Current database: tonelm2_odm

Open in new window

The database Im trying to restore does have blobs in, but I have already tried to increase the packet size with no sucess.

Any ideas whats going on, or even better how to fix it?

Thank you in advance
Question by:tonelm54
    LVL 18

    Expert Comment

    by:Andrej Pirman
    What is the format of your backups? Are they .SQL files with full insert statements?

    Accepted Solution

    Yes, Ive just found the issue which I dont really understand!

    In my my.ini file I have 2 entries for "max_allowed_packet", one (which I set) was 100M, the other was 1M, I changed the 1M to 100M restarted my service, and it restored easily!

    Hmm, all very strange!


    Author Closing Comment

    Found the answer

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    A lot of articles have been written on splitting mysqldump and grabbing the required tables. A long while back, when Shlomi ( had suggested a “sed” way, I actually shell …
    This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment). We need to replicate EVERY executed SQL query on server 1 to…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now