[mythtv-users] OT: Mirroring a sql database

[Adam Bodnar]

Yes, you can copy the files, but to make sure you don't corrupt the
database as well as get the latest changes to the database you'd have
to shut down mysql in order to copy the files.

The better way would be to read up on replication. Setting up the one
on your windows machine to be a slave to your myth box.

On 8/26/05, Marc Nicholas <marc at geekythings.com> wrote:
> Craig's *almost* right -- your chances of just copying the MySQL files and
> having them work are >99% for a thinly used (i.e. writes) database.
> 
> Do be ware, however, there are times when you could end up with a corrupt
> database when doing this. Oh, and this assumes MyISAM container format.
> 
> -marc
> 
> On Sat, 27 Aug 2005, Craig Tinson wrote:
> 
> > Nathan Hesson wrote:
> >
> >> This is sort of off topic but I like to watch shows that I have recorded
> >> on my windoze laptop, I tried booting a frontend off of knoppmyth but i
> >> get no audio.  anyway i use the dsmyth filters and it is able to grab the
> >> appropriate program info from the db and display it inside my smb mount.
> >> My question is, does anyone know if it is possible to mirror a copy of a
> >> database without having to export and reimport everything.  I have mysql
> >> running on my laptop and it would be cool to be able to copy files
> >> (travelling) and just point the database elsewhere to get the program
> >> info.
> >> TIA
> >>
> >
> > Mysql is just set of files ( /var/lib/mysql/mythconverg/* )
> >
> > In *theory* and I've never tried this - you could use a "rsync for windows"
> > (http://optics.ph.unimelb.edu.au/help/rsync/)  to sync between your myth box
> > and your windows laptop.
> >
> > I'm talking off-the-top of my head here and I might have the wrong end of
> > the stick in terms of what you are after
> >
> > hth
> >
> > Craig
> >
> >
> > _______________________________________________
> > mythtv-users mailing list
> > mythtv-users at mythtv.org
> > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> >
> 
> 
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> 
> 
>