Hi all,<br><br>I am a dumb dumb and accidently dropped my videometadata table from mythconverg.<br><br>I was trying to restore it from a recent backup and I get the following 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 the manual that corresponds to your MySQL server version for the right 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? I ran the database dump using the command:<br><pre>mysqldump -u mythtv -pmythtv mythconverg -c > mythtv_backup.sql<br>
<br></pre><div style="text-align: left;">And then grepping out the videometadata parts:<br><pre>grep "INSERT INTO \`videometadata\` " mythtv_backup.sql > videometadata.sql</pre><br><div style="text-align: left;">
I would like to be able to recreate the table and the data using the backup, but worst case, I can just recreate the table and run the imdb-bulk update scripts.<br><br>Does anyone have the videometadata schema handy?<br><br>
Thanks!<br>Dave<br></div></div><pre></pre><br>