[mythtv-users] Can I have my remote frontend database running as a separately named mysql database on the backend?

[Jeffrey J. Kosowsky]

Jeffrey J. Kosowsky wrote at about 03:39:26 -0500 on Thursday, January 7, 2010:
 > So to be clear are you saying that there is always only a *single*
 > mythconverg database and a *single* instance of mysqld running at any
 > time?  And furthermore does that mean that mysql only needs to be
 > installed on the master backend?
 > 
 > Note: regarding the Windows mythtv wiki, I read the following as a "dire"
 > warning that a Windose mythtv version could overwrite a Linux
 > version (the English is a bit rough so I can now see how this may be
 > referring to moving databases back-and-forth between two separate
 > installations rather than interactions between frontends and backends
 > on the same installation)
 > 
 > 	Installing MySQL Server
 > 
 >  	Next, you need to actually need to have a mysql server running, and
 > 	configured to accept the username,password, and database that you
 > 	specified in the mysql.txt!
 > 
 > 	You can configure your database on a different (eg existing) mysql
 > 	server/box (like a linux box), but I STRONGLY urge you to NOT to point
 > 	it to any existing mythty database without taking a backup first, and
 > 	realising that you will quote probably break any other mythtv install
 > 	connected to that database (due to the schema differences in different
 > 	versions )! 

And I guess most importantly, I really need to understand whether a
frontend on a new machine can destroy the data in my backend
mythconverg database. For example, if the frontend has a newer version
of mythtv, will it upgrade the schema without warning or will there be
incompatibilities leading to data corruption?

More generally, is the Windows version considered stable enough that
at a minimum it is very unlikely to corrupt the database? In other
words, I can live with Windows frontend crashes or missing
functionality but I don't want to risk losing video data or corrupting
the database.

Thanks