[mythtv-users] DB charset pre-conversion test failed! Your database seems to be partially corrupted.

[Brian J. Murrell]

On Mon, 2009-11-09 at 13:51 -0500, Michael T. Dean wrote: 
> Exactly.  It could be missing for a variety of reasons.
> 
> a) The table was crashed when the user did a backup of her 0.21-fixes 
> database, so it wasn't backed up

"The user"

> b) The user decided that he would "optimize" his MySQL database by 
> changing certain tables from the MyISAM storage engine to the InnoDB 
> storage engine, then backed up his 0.21-fixes database (which has the 
> instructions to create the table using the InnoDB storage engine), and 
> restored the backup into a database server on which the distro was kind 
> enough to disable the "unnecessary/RAM-consuming" InnoDB storage engine

"The user"

> c) The table was corrupt and mysqlcheck was unable to repair it, so the 
> user just deleted it and didn't see any problems so figured she had fixed it

"The user"

> d) The user accidentally deleted the table

"The user"

> e) The user at some point in the past did the backup/restore thing 
> mentioned above and has been running without that table (and getting 
> tons of error messages in his logs) since then

"The user"

> f) The user had problems with his DB schema in the past, and /rather 
> than fixing the problem properly/ (as my suggestion would do), he 
> decided to just hack at the DB/schema until he saw no signs of the issue 
> he had noticed (but left other brokennes in place)

"The user"

> g)...

Those are all variations on the same "the user was dicking around in the
database" theme.  There has been no dicking around here in mysql.  I
hate mysql and have as little to do with it as I can.  The only
manipulating of the database being done here is my the various pieces of
Myth software itself.

b.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: This is a digitally signed message part
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20091109/eb71b5dc/attachment.pgp>