I have a mysql database with at least two tables in it that I am working with - and this has NEVER happened before - where the results and updates don't show. I run this command:

flush tables;

and the updates show. ALL tables are MyISam - no innodb, I don't even use innodb.

same thing when I need to add a field; I get an error message saing incorrect data definition or similar, and suggesting I try to repair the table. I then run:

flush tables;
repair table finan_items;

and sometimes the fields were added but only then show, other times they need to be added again.

any idea what is going on here?

thanks,
Sam

    Write a Reply...