List:General Discussion« Previous MessageNext Message »
From:Bobb Crosbie Date:February 16 2012 3:16am
Subject:Upgrade 5.0 -> 5.1 - long table names with invalid chars.
View as plain text  
Hi Folks,

I'm preparing an upgrade of a 5.0.51a database to 5.1.58 (Ubuntu 11.10) -
Some of the table names contain invalid characters which mysql_upgrade
(mysqlcheck) is attempting to escape by renaming the filename.  However I'm
having trouble with some tables with long names.

For instance if I had a table in "some_db" called:   "A table with a really
long name - and some invalid characters"

Internally this will be converted to "#mysql50#A table with a really long
name - and some invalid characters" but it will be truncated to 64
characters: "#mysql50#A table with a really long name - and some invalid
char"  and I will get errors such as:

    Failed to RENAME TABLE `#mysql50#A table with a really long name - and
some invalid char` TO `A table with a really long name - and some invalid
char`
        Error: Can't find file: './some_db/A table with a really long name
- and some invalid char.frm' (errno: 2)

Any ideas or suggestions ?
I'd prefer to keep with the ubuntu version of mysql if possible. Would also
like to minimize the size of the downtime window.

Would it be best to just dump/drop/re-import the tables/databases ?

Many Thanks,

- bobb

Thread
Upgrade 5.0 -> 5.1 - long table names with invalid chars.Bobb Crosbie16 Feb
  • Re: Upgrade 5.0 -> 5.1 - long table names with invalid chars.MySQL)16 Feb