Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a mysql table (MyISAM), called bla. The Version is 9 (mysql4) Using a mysql5-server I did an alter table (add column, delete the same column). This is a simple trick to upgrade the table Version. As shown by mysql:

$ echo "show table status from mydb like 'bla'\G" | mysql -p | grep Version
Enter password: 
        Version: 10

Normally the unix file command gives the same result, i.e. for another "altered" table:

file bla_ok.frm
bla_ok.frm:  MySQL table definition file Version 10

But for some "altered" tables (like bla) the file command still gives Version 9 while the above mysql command gives version 10

file bla.frm:
bla.frm: MySQL table definition file Version 9

Someone has a clue?

share|improve this question

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.