<div>
What is the format of your backups? Are they .SQL files with full insert statements?
</div>


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

<div>
<div class="content wysiwyg-content">
Good afternoon,<br />
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.<br />
<br />
When I try and restore my database it seems to work for the first few seconds, and then get the message:-<br />

<pre><code id="code-10-27035198-1">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</code></pre>
<br />
The database Im trying to restore does have blobs in, but I have already tried to increase the packet size with no sucess.<br />
<br />
Any ideas whats going on, or even better how to fix it?<br />
<br />
Thank you in advance
</div>
</div>


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:-
(CODE)

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

MySQL Restore issues

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.