MySQL troubles

[IR15H]

I finally got it to work, with all the information .

I downloaded a program called PS Pad, which is a kinda like notepad++ except it can also read SQL (and doesn't suffer out of memory/file to big to open errors some other specialised sql editors do).

I ran the SQL backup through MySQL Admin, getting the usual error message;

Error while executing this query:INSERT INTO `customavatar` (`userid`,`filedata`,`dateline`,`filename`,`visibl e`,`filesize`,`width`,`height` ,`filedata_thumb`,`width_thumb`,`height_thumb`) VALUES ...LOADS OF NUMBERS...
The server has returned this error message:MySQL server has gone away
MySQL Error.

I then copied the offending string of numbers and did a search in the sql file in PS Pad. Once I found it I deleted the whole INSERT row command for that particular value. In total I had two erroneous queries, both contained within the customavatar table. After I got rid of the two dodgy quires I simply saved the sql file again and ran it through MySQL Admin's restore function, this time successfully without errors.


Thanks to everyone who tried to help .