[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