On 2/12/07, <b class="gmail_sendername">Brad Fuller</b> <<a href="mailto:bradallenfuller@yahoo.com">bradallenfuller@yahoo.com</a>> wrote:<div><span class="gmail_quote"></span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
On the FC4 machine running mysql version 4 I dumped the mythconverg<br>database using:<br>mysql dump -tc -u mythtv -p mythconverg > mythdb.sql</blockquote><div><br>This is the problem - the "-t" switch tells mysqldump not to put table creation statements in the dump file. That's what you want if you will be reimporting the dump into an existing mythconverg db. But you want to recreate the db from scratch so you needed those create table statements.
<br> </div></div>I assume you can't do another dump?<br><br>You might be able to get it working by doing a fresh Myth install (to recreate the database) and then importing the dump file into that. You may have to truncate all the tables first.
<br><br>Cheers,<br>Steve<br>