Re: [mythtv-users] OT: Mirroring a sql database
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 [EMAIL PROTECTED] 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@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] OT: Mirroring a sql database
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@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] OT: Mirroring a sql database
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@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
