View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 5 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
PostPosted: Tue Oct 30, 2007 2:41 pm 
Offline
Joined: Mon Apr 23, 2007 1:45 pm
Posts: 405
Location: Fargo, ND, USA
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

_________________
TVBox
LinHES R8.6.1


Top
 Profile  
 
 Post subject:
PostPosted: Tue Oct 30, 2007 9:19 pm 
Offline
Joined: Wed Mar 03, 2004 7:43 pm
Posts: 748
Location: Sydney, Australia
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.

_________________
| Nigel Pearson, nigel.pearson.au@gmail.com
| "Things you own end up owning you" - Tyler, Fight Club


Top
 Profile  
 
 Post subject:
PostPosted: Tue Oct 30, 2007 9:25 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
- 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


Top
 Profile  
 
 Post subject: Keybindings
PostPosted: Wed Oct 31, 2007 2:14 am 
Offline
Joined: Mon Apr 23, 2007 1:45 pm
Posts: 405
Location: Fargo, ND, USA
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

_________________
TVBox
LinHES R8.6.1


Top
 Profile  
 
 Post subject:
PostPosted: Wed Oct 31, 2007 6:23 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
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...


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 5 posts ] 


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 6 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu