<br><br><div><span class="gmail_quote">On 1/11/07, <b class="gmail_sendername">Ken Taylor</b> <<a href="mailto:ken@onramp.com.au">ken@onramp.com.au</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
On 11/01/2007, at 5:58 AM, ryan patterson wrote:<br>> I am trying to upgrade my mythtv setup. I am moving from a debian<br>> install<br>> to a ubuntu install.<br>><br>> I tried following these<br>> instructions:
<a href="http://www.mythtv.org/docs/mythtv-HOWTO-23.html#ss23.7">http://www.mythtv.org/docs/mythtv-HOWTO-23.html#ss23.7</a><br>> which explain how to back up the database and move it to a fresh<br>> myth-backend install. I performed the database backup no problem. I
<br>> verified that every grep command produced output in the<br>> restore.sqlfile. My new backend is up and running.<br>><br>> Now I am trying to restore the database backup using the following<br>> command:
<br>> $ mysql -u mythtv -pmythtv mythconverg < restore.sql<br>><br>> But I get the following error message:<br>> ERROR 1054 (42S22) at line 1: Unknown column 'storage group' in<br>> 'field list'
<br>><br>> (there might not have been a space in 'storagegroup'. I'm not at<br>> home so I<br>> can't check.)<br><br>Sounds like you're trying to restore over an existing database.<br><br>
You should drop the existing mythconverg database fisrt, and then<br>mythtv will update the data to the new format.<br><br>Ken<br>--<br>Ken Taylor</blockquote><div><br>Okay if I drop the current database should I restore the entire database from my old backend or just the parts the instructions said to grep out of the mysqldump?
<br> </div></div>-- <br>_____________<br>Ryan Patterson