Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.