| LinHES Forums http://forum.linhes.org/ |
|
| Backup Mythtv Keybindings http://forum.linhes.org/viewtopic.php?f=17&t=17142 |
Page 1 of 1 |
| Author: | TVBox [ Tue Oct 30, 2007 2:41 pm ] |
| Post subject: | Backup Mythtv Keybindings |
Backup Mythtv Keybindings Is there a way to backup Mythtv key bindings so that it can be reinstalled into a clean auto install. It is OK with me to overwrite the default bindings. I have searched my R5F27 install for *keybindings* and *jumppoints* this is what I come up with. Some how I do not think it is as easy as cut and paste when you are dealing with a data base. /var/lib/mysql/mythconverg/jumppoints.MYD /var/lib/mysql/mythconverg/jumppoints.MYI /var/lib/mysql/mythconverg/jumppoints.frm /var/lib/mysql/mythconverg/keybindings.MYD /var/lib/mysql/mythconverg/keybindings.MYI /var/lib/mysql/mythconverg/keybindings.frm Any good or bad experience out there? Thanks TVBox |
|
| Author: | nigelpearson [ Tue Oct 30, 2007 9:19 pm ] |
| Post subject: | |
Well, the mythbackup script is designed to backup everything so that an auto-install uses those settings, but I will assume you just want the keybindings from another machine for some reason. Using the raw database files isn't the way to do it. The databases might be different versions of MySQL, the files may partially written records in them, et c. On the source machine, do: Code: mysql -t -u root mythconverg keybindings > kb.sql then copy that file across the the newly installed machine, and do: Code: mysql -u root mythconverg < kb.sql
If you are happy to destroy the existing keybindings, remove the -t argument in mysqldump. Do man mysqldump for further information. |
|
| Author: | tjc [ Tue Oct 30, 2007 9:25 pm ] |
| Post subject: | |
- Do a normal backup. - Uncompress the SQL dump file. - Extract the statements related to those two tables. Code: mythbackup cd /myth/backup gzip -dc mythconverg.sql.gz | egrep -i 'INSERT INTO `(jumppoints|keybindings)`' >keystuff.sql - Save that file - Pipe the results into mysql on the new install. Code: mysql -u root mythconverg <keystuff.sql
|
|
| Author: | TVBox [ Wed Oct 31, 2007 2:14 am ] |
| Post subject: | Keybindings |
Thanks Nigel and tjc for providing the good experience. I received education from the posts both of you provided. I wanted the backup to do an install on my current machine. After a Lirc irrecord that went astray and damaged my database, I haven't been able to get it back to 100%. Add to that a NIC MAC address problem and it is time for a new install. I plan on doing a clean auto install and take as little baggage with me as I can. Thanks TVBox |
|
| Author: | tjc [ Wed Oct 31, 2007 6:23 pm ] |
| Post subject: | |
An auto-upgrade is pretty close to a clean install. There are very few files carried over aside from your media files in the /myth partition and the DB. Definitely worth a try in any case... |
|
| Page 1 of 1 | All times are UTC - 6 hours |
| Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |
|