Copy Mythtv Setup [SOLVED]

cawill · 2008-02-16 22:14:08

I have two computers (one old, one new) using the same tv card, how could I copy all of the mysql database, mythtv settings etc?

Thanks, Chris.

Last edited by cawill (2008-02-19 19:06:16)

clarence · 2008-02-16 23:29:12

I've done this several times.

copy your - /home/username/.mythtv - folder to your second machine.

and check the mythtv.org wiki page for how to backup and restore the mythtv database. it has instructions there for how to backup the database to a file. then copy that file to your second machine and follow the wiki instructions there to restore (or import) the database.

I'm a little short of time otherwise i'd find the link for you. just type backup database into mythtv.org's wiki search it should come up.

You may still have to spend some time tweaking little bits here and there.

Best of luck

cawill · 2008-02-17 09:42:17

Thanks, I've found out how to copy the database, if I copy '~/.mythtv' what else will I need to configure?

clarence · 2008-02-17 10:41:07

hopefully nothing. give it a go and see what happens

cawill · 2008-02-17 11:23:41

From the mythtv website:

[root@myhost chris]# mysqldump -u mythtv -pmythtv mythconvery -c > mythtv_backup.sql
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect
[root@myhost chris]#

How can I fix this?

cawill · 2008-02-17 15:54:03

Ok backed that up, can't set my password though,

For Example:

[root@myhost chris]# mysqladmin -u root password root
mysqladmin: error while loading shared libraries: libmysqlclient.so.15: cannot open shared object file: No such file or directory

Any help?

Edit: All up and running apart from the data for my guide:

[~] mythfilldatabase 
2008-02-17 21:14:24.116 Using runtime prefix = /usr
2008-02-17 21:14:24.120 New DB connection, total: 1
2008-02-17 21:14:24.124 Connected to database 'mythconverg' at host: localhost
2008-02-17 21:14:24.126 New DB connection, total: 2
2008-02-17 21:14:24.131 Connected to database 'mythconverg' at host: localhost
2008-02-17 21:14:24.131 Updating source #1 (radiotimes) with grabber tv_grab_uk_rt
2008-02-17 21:14:24.132 Found 5 channels for source 1 which use grabber
2008-02-17 21:14:24.139 Grabber has capabilities: baseline manualconfig cache preferredmethod 
2008-02-17 21:14:24.146 Grabber prefers method: allatonce
2008-02-17 21:14:24.147 New DB connection, total: 3
2008-02-17 21:14:24.154 Connected to database 'mythconverg' at host: localhost
2008-02-17 21:14:24.154 Grabber Command: nice tv_grab_uk_rt --config-file '/home/chris/.mythtv/radiotimes.xmltv' --output /tmp/mythYwdHq6
2008-02-17 21:14:24.154 ----------------- Start of XMLTV output -----------------
Can't locate File/Slurp.pm in @INC (@INC contains: /usr/lib/perl5/5.8.8/i686-linux-thread-multi /usr/lib/perl5/5.8.8 /usr/lib/perl5/site_perl/5.8.8/i686-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl/5.8.7/i686-linux-thread-multi /usr/lib/perl5/site_perl/5.8.7 /usr/lib/perl5/site_perl/5.8.6/i686-linux-thread-multi /usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5/i686-linux-thread-multi /usr/lib/perl5/site_perl/5.8.5 /usr/lib/perl5/site_perl/5.8.4/i686-linux-thread-multi /usr/lib/perl5/site_perl/5.8.4 /usr/lib/perl5/site_perl/5.8.3/i686-linux-thread-multi /usr/lib/perl5/site_perl/5.8.3 /usr/lib/perl5/site_perl/5.8.2/i686-linux-thread-multi /usr/lib/perl5/site_perl/5.8.2 /usr/lib/perl5/site_perl/5.8.1/i686-linux-thread-multi /usr/lib/perl5/site_perl/5.8.1 /usr/lib/perl5/site_perl/5.8.0/i686-linux-thread-multi /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl .) at /usr/lib/perl5/site_perl/5.8.8/XMLTV/Supplement.pm line 16.
BEGIN failed--compilation aborted at /usr/lib/perl5/site_perl/5.8.8/XMLTV/Supplement.pm line 16.
Compilation failed in require at /usr/bin/tv_grab_uk_rt line 100.
BEGIN failed--compilation aborted at /usr/bin/tv_grab_uk_rt line 100.
2008-02-17 21:14:24.400 ------------------ End of XMLTV output ------------------
2008-02-17 21:14:24.401 FAILED:  xmltv returned error code 512.
Error in 1:1: unexpected end of file
2008-02-17 21:14:24.401 Updating icons for sourceid: 1
2008-02-17 21:14:24.402 New DB connection, total: 4
2008-02-17 21:14:24.402 Connected to database 'mythconverg' at host: localhost
2008-02-17 21:14:24.403 No programs found in data.
2008-02-17 21:14:24.406 New DB connection, total: 5
2008-02-17 21:14:24.407 Connected to database 'mythconverg' at host: localhost
2008-02-17 21:14:24.408 Failed to fetch some program info
2008-02-17 21:14:24.408 Adjusting program database end times.
2008-02-17 21:14:24.411     0 replacements made
2008-02-17 21:14:24.411 Marking generic episodes.
2008-02-17 21:14:24.411     Found 0
2008-02-17 21:14:24.411 Marking repeats.
2008-02-17 21:14:24.416     Found 0
2008-02-17 21:14:24.416 Unmarking new episode rebroadcast repeats.
2008-02-17 21:14:24.422     Found 0
2008-02-17 21:14:24.435 Marking episode first showings.
2008-02-17 21:14:24.436     Found 0
2008-02-17 21:14:24.436 Marking episode last showings.
2008-02-17 21:14:24.436     Found 0
2008-02-17 21:14:24.436 
===============================================================
| Attempting to contact the master backend for rescheduling.  |
| If the master is not running, rescheduling will happen when |
| the master backend is restarted.                            |
===============================================================
2008-02-17 21:14:24.441 Connecting to backend server: 127.0.0.1:6543 (try 1 of 5)
2008-02-17 21:14:24.441 Using protocol version 31
2008-02-17 21:14:24.447 Received a remote 'Clear Cache' request
2008-02-17 21:14:24.448 mythfilldatabase run complete.
2008-02-17 21:14:24.448 DataDirect: Deleting temporary files

Can anyone fix this?

Last edited by cawill (2008-02-17 21:11:51)

clarence · 2008-02-18 04:08:34

try installing-> perl-file-slurp
from the community repo.

cawill · 2008-02-19 19:05:57

clarence wrote:

try installing-> perl-file-slurp
from the community repo.

That worked, everything works now , Thank you for all your help.

clarence · 2008-02-20 01:21:14

Well done two thumbs up

Arch Linux

#1 2008-02-16 22:14:08

Copy Mythtv Setup [SOLVED]

#2 2008-02-16 23:29:12

Re: Copy Mythtv Setup [SOLVED]

#3 2008-02-17 09:42:17

Re: Copy Mythtv Setup [SOLVED]

#4 2008-02-17 10:41:07

Re: Copy Mythtv Setup [SOLVED]

#5 2008-02-17 11:23:41

Re: Copy Mythtv Setup [SOLVED]

#6 2008-02-17 15:54:03

Re: Copy Mythtv Setup [SOLVED]

#7 2008-02-18 04:08:34

Re: Copy Mythtv Setup [SOLVED]

#8 2008-02-19 19:05:57

Re: Copy Mythtv Setup [SOLVED]

#9 2008-02-20 01:21:14

Re: Copy Mythtv Setup [SOLVED]

Board footer