[mythtv-users] Sync 2 remote backends over VPN
Craig G.
craig at goranson.org
Tue Sep 16 06:32:08 UTC 2008
robbinsck1 at gmail.com wrote:
>
>
> Something like this will work (not correct nuvexport syntax, you will
> need to look that up.)
>
> Ok, so I got everything set up to export, do the transfer etc.
>
> Where I'm stuck is I cannot figure out how to import the .mpg and .sql files. It seems google don't help either, I thought for sure it was myth.rebuilddatabase.pl but it seems I'm stuck.
>
> I need guidance on this it seems.
>
>
ok, looks like on the import things are a big more primitive then I
first thought. But its easy enough to do. You need to move the .mpg
file to the storage directory on the destination system. Then you
should be able to just execute the SQL file through mysql and it will
insert the data into the database:
mysql -u mythtv -pmythtv mythconverg < yourtvshow.sql
Where -u mythtv is the sql user account and -pmythtv is your sql
password. Not sure if the mythconverg is needed as "use mythconverg"
should already be in the SQL file on the first line. If it doesn't
work with mythconverg on the line above try it without.
I believe that should work, but would recommend backing up the database
before you do it just in case. Info on backing up and restoring
database as well as info on executing sql files can be found here:
http://www.mythtv.org/wiki/index.php/User_Manual:Periodic_Maintenance
More information about the mythtv-users
mailing list