[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