[mythtv-users] Sync 2 remote backends over VPN

[Craig G.]

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