<div class="gmail_quote">On Wed, Jan 28, 2009 at 2:11 PM, Nick Rout <span dir="ltr"><<a href="mailto:nick.rout@gmail.com">nick.rout@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="Ih2E3d">On Thu, Jan 29, 2009 at 7:22 AM, Brad DerManouelian<br>
<<a href="mailto:myth@dermanouelian.com">myth@dermanouelian.com</a>> wrote:<br>
> On Jan 28, 2009, at 10:11 AM, Captain Krypto wrote:<br>
><br>
>> Hi all,<br>
>><br>
>> I am a dumb dumb and accidently dropped my videometadata table from<br>
>> mythconverg.<br>
>><br>
>> I was trying to restore it from a recent backup and I get the following<br>
>> error when running the command:<br>
>><br>
>> mysql -u mythtv -pmythtv mythconverg < videometadata.sql<br>
>><br>
>> ERROR 1064 (42000) at line 3: You have an error in your SQL syntax; check<br>
>> the manual that corresponds to your MySQL server version for the right<br>
>> syntax to use near 'LOCK TABLES `videometadata` WRITE' at line 3<br>
>><br>
>> With the code in question being:<br>
>><br>
>> -- Table structure for table `videometadata`<br>
>> DROP TABLE IF EXISTS `videometadata`;<br>
>> CREATE TABLE `videometadata` (<br>
>> -- Dumping data for table `videometadata`<br>
>> LOCK TABLES `videometadata` WRITE;<br>
>> /*!40000 ALTER TABLE `videometadata` DISABLE KEYS */;<br>
>> INSERT INTO `videometadata` (`intid`, [...]<br>
>><br>
>> Does anyone know what the issue with that is?<br>
><br>
> Yeah, you're completely missing the table definition. Mine looks like this<br>
> (but don't go by it because I'm running trunk and might have a different<br>
> schema for this table):<br>
<br>
<br>
</div>the OP said he grepped the whole database backup (mythtv_backup.sql)<br>
for just the parts that say 'Insert into videometadata' - in doing so<br>
he missed the table definition. If he looks at his mythtv_backup.sql<br>
file he should find the table definition relevant for his version.<br>
<div><div></div><div class="Wj3C7c">_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
<a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users" target="_blank">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br>
</div></div></blockquote></div><br><br>Yes, I was completely missing the table definition. I found the relevant part of the script in mythtv_backup.sql and I was able to recreate a blank table. However, when I tried to run imdb-bulk-update.pl it failed without an error. Also, I am no longer able to see a video icon in mythweb, and the video link gives me "An unknown module was specified"... perhaps I need to restart mythbackend?<br>
<br>Ugh... I'm at work now, but I'll have to look more into it when I get home. Don't mess with things when you are hungover ;)<br>