[mythtv-users] Running as root

[R. G. Newbury]

Dave Sherohman wrote:
>>
>> My mythbox is not connected to any network, unless I lug it to the office.
> 
> So you hook up to the net, update your listings of upcoming programs
> manually, then immediately disconnect?  Definitely a workable option,
> but I get the impression that's not how most people operate.


Actually I have a parallel myth setup on the office desktop (no tuner 
cards or cable however) . The mythconverg database is a dump of the one 
on the mythbox at home. I run mythfilldatabase (at work) and then dump 
the listings data to a file, which gets copied to a usb key. At home I 
restore the new data. Note that this over-writes the relevant tables 
with the new data.

The listings file averages about 13Meg in size, so nearly any usb key,
etc. will do. A full mysql dump is just under 35Meg for me. A full svn
download plus the database dumps is 382 Meg.


#mysqlzap
# transfer listings data created by mythfilldatabase to dump file
#!/bin/bash
mysqldump -u mythtv -pmythtv mythconverg --tables credits oldprogram
people program programgenres programrating > /keep/usb/db/mysqlzap.txt

#mysqlzaprestore
#replace old program listings data with updated listings
mysql -u mythtv -pmythtv mythconverg < /keep/usb/db/mysqlzap.txt


Geoff