[mythtv-users] Database Backup file not restoring

[Michael T. Dean]

On 07/18/2011 03:31 AM, mlt wrote:
> I have just reinstalled mythtv and am having trouble restoring my 
> database backup - I am using mythbuntu 11.04.
>
> When I run restore I get the following message:
>
>     ERROR 1064 (42000) at line 2794: You have an error in your SQL
>     syntax; check the manual that corresponds to your MySQL server
>     version for the right syntax to use near
>     '308:64,9),(1002,'2010-12-28 08:33:00',15726,(10402,'910-12-28
>     08:33:00',12066,32' at line 1
>
>     ERROR: Cannot write to mysql, stopped at ./mythconverg_restore.pl
>     line 1720, <BACKUP> line 2797.
>
>
> I have tried to do a partial restore and get the same message.
>
> When I try to open the file I get this message:
>
>     gzip: mythconverg-1264-20110716142445.sql.gz: invalid compressed
>     data--crc error
>
>     gzip: mythconverg-1264-20110716142445.sql.gz: invalid compressed
>     data--length error
>
>
> Is there anything that I can do with this or is the backup file 
> corrupted in a way beyond recall -mysql is not my thing...

Looks like your file got truncated somehow.  Does gzip -d leave an 
uncompressed "partial" file?

gzip -d mythconverg-1264-20110716142445.sql.gz

Do you have other backups or even the originaly mysql binary data files?

Mike