[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