[mythtv-users] Update TV table without Internet

[R. G. Newbury]

> 
> On 4/17/07, Phill Edwards <philledwards at gmail.com> wrote:
>>> My BE/FE will not have Internet connection for a couple of weeks.
>>> What is the easiest way to grab the updated TV table on another
>>> computer (without Myth installed), transfer the updates on a USB
>>> memory stick, and import it to the BE/FE using mythfilldatabase?


Presuming that the mythtv (the host machine) setup you will be using is 
on the same lineup, you can update the host with:


mysqldump -u mythtv -pmythtv mythconverg --tables credits oldprogram 
people program programgenres programrating > /keep/mysqlzap.txt


And restore on your disconnected machine with

mysql -u mythtv -pmythtv mythconverg < /keep/mysqlzap.txt


where the file is transferred by USB memory key, writeable CDROM, SD 
memory card etc. etc.

The referenced tables will be replaced on the disconnected machine.

I used this method for over a year with my mythbox, using a setup at 
work to download using mythfilldatabase and a USB key.

Geoff





              R. Geoffrey Newbury			
            Barrister and Solicitor
       Suite 106, 150 Lakeshore Road West
          Mississauga, Ontario, L5H 3R2

         o905-271-9600 f905-271-1638
           newbury at mandamus.org

        Helping with the HTTP issue
<a href="http://www.w3.org/Protocols/">HTTP</a>