[mythtv-users] mysql-5.0
Paul Bender
pebender at san.rr.com
Thu Nov 30 05:02:41 UTC 2006
Mike Lewis wrote:
> On 11/23/06, Mark Knecht <markknecht at gmail.com> wrote:
>> Hi,
>> General question. Is it safe & easy to update mysql from a 4.1.21
>> installation to mysql-5.0?
I cannot say whether it is safe. However, when I upgraded my backend
from FC4 to FC6, I upgraded from MySQL 4.1.20 to MySQL 5.0.27 without
any problems.
>> 1) Do I have to do anything on the backend to continue using the
>> existing recordings and database?
What I did was dump (backup) the mythconverg database from MySQL 4.1.x,
dropped the database, and restored the dumped database base on the MySQL
5.0.x server. I followed the instructions for dumping, dropping and
restoring in the MythTV documentation.
It is likely this was more than was needed. However, since I was
building a clean FC6 on a new drive rather than updating the install on
my existing drive, this was the easiest way to do it. Also, have a dump
of the mythconverg database meant that I could easily undo the damage.
>> 2) Do I have to update every front end on the network to 5.0 so they
>> will all speak the same language, or can a frontend continue to run
>> 4.1.21 for a few days?
No. All my frontends still run 4.1.x.
More information about the mythtv-users
mailing list