[mythtv-users] Myth Database Upgrade failed preventing 0.22 from starting on gentoo.
Michael T. Dean
mtdean at thirdcontact.com
Sat Dec 5 18:44:15 UTC 2009
On 12/05/2009 01:07 PM, John Drescher wrote:
> I am having problems upgrading my database on gentoo for 0.22 because
> it appears mythbackend is causing my database to go back from latin1
> to utf8
>
That's what the upgrade to 0.22 will do. (It's a good thing.)
> jmd0 mythtv # mysql -umythtv -p mythconverg -e 'status;'
> Enter password:
> --------------
> mysql Ver 14.12 Distrib 5.0.84, for pc-linux-gnu (x86_64) using readline 5.2
>
...
> Server characterset: latin1
> Db characterset: latin1
> Client characterset: latin1
> Conn. characterset: latin1
Good. Your DB server is properly configured, now.
> jmd0 mythtv # ~john/scripts/mythconverg_restore.pl --filename
> mythconverg-to_uncorrupt.sql
>
Did you try upgrading from the original backup?
> jmd0 mythtv # mythbackend
>
...
> 2009-12-05 13:05:27.059 Newest MythTV Schema Version : 1244
> 2009-12-05 13:05:27.345 Database corruption detected. Unable to
> proceed with database upgrade. (Table: people, Warnings: 289)
> 2009-12-05 13:05:27.345 Your database must be fixed before you can
> upgrade beyond 0.21-fixes. Please see
> http://www.mythtv.org/wiki/Fixing_Corrupt_Database_Encoding for
> information on fixing your database.
>
Because the changed one is putting broken data in your database.
If you've tried both the original pre-upgrade 0.21-fixes backup and the
"uncorrupted" backup you show your using above, then you have partial
corruption, and you'll need to do:
http://www.gossamer-threads.com/lists/mythtv/users/406111#406111 .
Mike
More information about the mythtv-users
mailing list