<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body text="#000000" bgcolor="#ffffff">
I have just reinstalled mythtv and am having trouble restoring my
database backup - I am using mythbuntu 11.04.<br>
<br>
When I run restore I get the following message:<br>
<br>
<blockquote>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<br>
<br>
ERROR: Cannot write to mysql, stopped at ./mythconverg_restore.pl
line 1720, <BACKUP> line 2797.<br>
</blockquote>
<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>
<blockquote>gzip: mythconverg-1264-20110716142445.sql.gz: invalid
compressed data--crc error<br>
<br>
gzip: mythconverg-1264-20110716142445.sql.gz: invalid compressed
data--length error<br>
</blockquote>
<br>
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...<br>
</body>
</html>