hella dear friend,
mysql 5.0.91-community phpmyadmin 3.3.8.1 in server.
last days we have changed myisam database to innodb.
phpmyadmin is our interface.
1- i could not see exact data in some tables. when click on the table
(~23059) from phpmyadmin, the results of the datas are changing. first
20015, than 21201 and so. also in main window datas are shown ~ 23028.
the reason of this situation, regarding to phpmyadmin, exact
calculation makes server slower, but i can see exact datas of some
tables if the table data is around 6000 lines.i am curious my table is
damaged?
2- order table does not sort by order_id (auto_increment). i can sort
order table with another columns. When i click the order_id column, it
returns 0 data, but i can see the datas and go page by page, count with
count(*). i am curious my table is damaged?
3- repair function seems not working, gives "The storage engine for the
table doesn't support r..." error.
regards
