[mythtv-users] How to copy 'frontend' portion of mysql database

Jeffrey J. Kosowsky jeff at kosowsky.org
Thu Jan 7 06:59:51 UTC 2010


On my server's combined frontend/backend, I spent a fair bit of time
customizing all the zillions of options in the mythfrontend setup
menu.

I now am adding a remote frontend only and would like to copy over all
the mythfrontend relevant tables without copying over all the backend
video card/input and program data.

So, I would like to know what tables can I 'drop' that are only used
by the backend?

Then I would like to do something like the following:

Specifically, I would like to do something like the following:
1. First dump only the mythfrontend-relevant tables from my existing
   setup using
   mysqldump -umythtv -pmythtv -c -e mythconverg [list of mythfrontend tables to dump] > myth_partial_dump_file

2? [If necessary???]
    Create a new blank mythconverg table for the remote frontend using:
	  mysql -u root -p mythtv mythconverg < mc.sql

   Is this step necessary????

3? [If necessary???]
   Run mythfrontend on the new remote frontend to initialize all the
   tables (but don't go through the setup -- just start, select the
   language, and quit)

   Is this step necessary????

4. Import the setup values dumped in step 1, using:
   mysql -u mythtv -pmythtv mythconverg < myth_partial_dump_file


SOOOOOO.... 
A. Will this approach work? Is there anything else I need to change or
copy over?

B. What tables specifically do I need to list?

C. Is there a better way?



More information about the mythtv-users mailing list