[mythtv-users] Trying to upgrade to Mysql 5.x

Mike Diehl mdiehl at diehlnet.com
Mon Apr 2 23:35:50 UTC 2007


I've got an old version of MythTV running that I'm about to upgrade, but first 
I thought I'd upgrade to the latest version of Mysql.

I did a dump of the current database and moved it to a different server with 
the latest version of Mysql.  Then, on that server, I issued:

mysql -f mythconverg < /tmp/mythdump.sql

The results were pages of error messages.  Most of the error messages were due 
to a few tables failing to be created.   The rest of the errors are below:

=============================
ERROR 1071 (42000) at line 602: Specified key was too long; max key length is 
1000 bytes
ERROR 1071 (42000) at line 2007: Specified key was too long; max key length is 
1000 bytes
ERROR 1146 (42S02) at line 2021: Table 'mythconverg.profilegroups' doesn't 
exist
ERROR 1146 (42S02) at line 2022: Table 'mythconverg.profilegroups' doesn't 
exist
ERROR 1146 (42S02) at line 2023: Table 'mythconverg.profilegroups' doesn't 
exist
ERROR 1146 (42S02) at line 2024: Table 'mythconverg.profilegroups' doesn't 
exist
ERROR 1146 (42S02) at line 2025: Table 'mythconverg.profilegroups' doesn't 
exist
ERROR 1146 (42S02) at line 2026: Table 'mythconverg.profilegroups' doesn't 
exist
ERROR 1146 (42S02) at line 2027: Table 'mythconverg.profilegroups' doesn't 
exist
ERROR 1146 (42S02) at line 2028: Table 'mythconverg.profilegroups' doesn't 
exist
ERROR 1071 (42000) at line 2418: Specified key was too long; max key length is 
1000 bytes
=============================	

I'm sure that once I resolve these errors, the rest will go away as well.  But 
I have no idea how to fix this.

Any suggestions would be appreciated.

-- 
Mike Diehl


More information about the mythtv-users mailing list