[mythtv-users] mysql upgrade can't import mythconverg dump
g8ecj at gilks.org
Tue Jan 2 10:29:53 UTC 2007
> I'm sure others have been through this - hopefully they can tell me the
> magic incantation.
> I'm running Gentoo and mysql has gone to 5.0 (I was on 4.0.27) in the
> stable tree. I've followed the instructions on the Gentoo wiki using
> mysqldump to make a backup of all the databases (which includes
> mythconverg of course) and done the upgrade.
> When I come to import the old stuff back in, it errors out with a "key too
> large" message due to the change from latin1 to utf8 character coding
> which increases the size of the keys beyond the allowed 1000 bytes.
> My sql backup is 73megs long - no way can I edit it to change the table
> creation to include a clause to define latin1 charset s I'm having to go
> back to the old version of mysql and I can no longer upgrade my system at
> all due to the dependances on the mysql-5.0.
> So is it possible to import a mysqldump-4 into a mysql-5 system without
> blowing up the key size. Do I have to dump all mythconverg tables
> individually so I can import them one by one so as to edit the ones where
> the keys are too large? Is there something that can be done in dbcheck.c
> to reduce the size of the keys that cause the problems?
> There may be other errors but the one that stops the import is the
> 'displayprofilegroups' table creation.
> AAhhhhh - there goes my New Years holiday :-((
Never mind - the answer was in svn version 8675 where the character set
change clause was added to mc.sql to create the database with single byte
per character keys (i.e. latin1 rather than utf8).
My database being 18 months old doesn't have this so its workaround time...
More information about the mythtv-users