<div dir="ltr">I was having an issue with my server and had to migrate to a new myth-tv backend box. So I followed the directions at <a href="http://mythtv.org/docs/mythtv-HOWTO-23.html#ss23.7">http://mythtv.org/docs/mythtv-HOWTO-23.html#ss23.7</a> , I installed the exact same version of mythtv onto my new system (the latest unmasked Gentoo version) but when I ran the commands:<br>
<pre><font style="font-family: arial,sans-serif;" size="2">$ mysql -u mythtv -pmythtv mythconverg < record.sql </font><br><br><span style="font-family: arial,sans-serif;">and</span><br><br><font style="font-family: arial,sans-serif;" size="2">$ mysql -u mythtv -pmythtv mythconverg < recorded.sql </font><br>
<br><font style="font-family: arial,sans-serif;" size="2"><br>I got the error:<br></font><br><font size="2"><span style="font-family: arial,sans-serif;">ERROR 1136 (21S01) at line 24: Column count doesn't match value count at row 27</span></font><br>
</pre>I know that I could have avoided this by issuing the mysqldump -c command for the export of the data, but this wasn't in the documentation and I didn't think about it until after my old box was inaccessible. Is there anything that I can do to get these two tables into my new system? Is there a place I can go to look at the database schema changes to determine what columns no longer match?<br>
<br>Thanks,<br><br>CD Waddell<br></div>