Re: [mythtv-users] OT: Mirroring a sql database

2005-08-26 Thread 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 yo

Re: [mythtv-users] OT: Mirroring a sql database

2005-08-26 Thread Marc Nicholas
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. -mar

Re: [mythtv-users] OT: Mirroring a sql database

2005-08-26 Thread Craig Tinson
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 i

[mythtv-users] OT: Mirroring a sql database

2005-08-26 Thread Nathan Hesson
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 que