[mythtv-users] Database Backup file not restoring

[mlt at etruscott.co.uk]

>
> 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

Thanks for the reply.

I was able to unzip the archive using ark in KDE, and their seem to be a 
number of errors in the syntax to do with recordings.

Unfortunately, this really was the backup as I trashed the previous 
installation (apart from the recordings).

Anyway of tidying up the syntax automatically?  As I say MySQL isn't 
something I have any knowledge of...

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.mythtv.org/pipermail/mythtv-users/attachments/20110719/43cad6d6/attachment.html