This is a discussion on Problem with upgrade 4.0 to 5.0 within the MySQL Database forums, part of the Database Forums category; > for sure that space in the column name is an error in version 5. that's the > problem ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
> for sure that space in the column name is an error in version 5. that's the
> problem with this create table statement. > -- > POST BY: lark with PHP News Reader Yes, this was the point. i modified the bad names with V4 without problems and reimported the tables in V5, now the tablecheck and -repair runs fine. Strange, that the tablecheck doesn't show, what the problem was. It seems that the tablecheck silently (i found nothing in the log) skipped the bad tables. Many thanks! Daniel |
|
|||
|
== Quote from Daniel Maus (maus@rumms.uni-mannheim.de)'s article
> > for sure that space in the column name is an error in version 5. that's the > > problem with this create table statement. > > -- > > POST BY: lark with PHP News Reader > Yes, this was the point. i modified the bad names with V4 without > problems and reimported the tables in V5, now the tablecheck and -repair > runs fine. > Strange, that the tablecheck doesn't show, what the problem was. It > seems that the tablecheck silently (i found nothing in the log) skipped > the bad tables. > Many thanks! > Daniel i think this could easily be documented as a bug at mysql's website. -- POST BY: lark with PHP News Reader |