<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
<table width="100%" border="0">
<tbody>
<tr>
<td colspan="2">
<blockquote type="cite">
<table width="100%" border="0">
<tbody>
<tr>
<td colspan="2"><br>
</td>
</tr>
</tbody>
</table>
<font color="black" face="Verdana,Arial,Helvetica"
size="2"> On 07/18/2011 03:31 AM, mlt wrote: <br>
<font color="#660066">> I have just reinstalled
mythtv and am having trouble restoring my <br>
> database backup - I am using mythbuntu 11.04. <br>
> <br>
> When I run restore I get the following message: <br>
> <br>
> ERROR 1064 (42000) at line 2794: You have an
error in your SQL <br>
> syntax; check the manual that corresponds to your
MySQL server <br>
> version for the right syntax to use near <br>
> '308:64,9),(1002,'2010-12-28
08:33:00',15726,(10402,'910-12-28 <br>
> 08:33:00',12066,32' at line 1 <br>
> <br>
> ERROR: Cannot write to mysql, stopped at
./mythconverg_restore.pl <br>
> line 1720, <BACKUP> line 2797. <br>
> <br>
> <br>
> I have tried to do a partial restore and get the
same message. <br>
> <br>
> When I try to open the file I get this message: <br>
> <br>
> gzip: mythconverg-1264-20110716142445.sql.gz:
invalid compressed <br>
> data--crc error <br>
> <br>
> gzip: mythconverg-1264-20110716142445.sql.gz:
invalid compressed <br>
> data--length error <br>
> <br>
> <br>
> Is there anything that I can do with this or is
the backup file <br>
> corrupted in a way beyond recall -mysql is not my
thing... </font><br>
</font></blockquote>
</td>
</tr>
</tbody>
</table>
<font color="black" face="Verdana,Arial,Helvetica" size="2"><font
color="#660066"><br>
</font> <br>
>Looks like your file got truncated somehow. Does gzip -d leave
an <br>
>uncompressed "partial" file? <br>
><br>
>gzip -d mythconverg-1264-20110716142445.sql.gz <br>
><br>
>Do you have other backups or even the originaly mysql binary
data files? <br>
<br>
>Mike </font><br>
<br>
Thanks for the reply. <br>
<br>
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.<br>
<br>
Unfortunately, this really was the backup as I trashed the previous
installation (apart from the recordings).<br>
<br>
Anyway of tidying up the syntax automatically? As I say MySQL isn't
something I have any knowledge of...<br>
<br>
</body>
</html>