[mythtv-users] Database Backup file not restoring

mlt at etruscott.co.uk mlt at etruscott.co.uk
Mon Jul 18 07:31:39 UTC 2011


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...
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.mythtv.org/pipermail/mythtv-users/attachments/20110718/5503ea71/attachment.html 


More information about the mythtv-users mailing list