**Reported in Launchpad by navigator93 last update 25-09-2012 07:38:11

I created and restored a snapshot using the new 1.9 beta and discovered later that there is an issue with CSV tables.
When I show table on the mysql database:

mysql> show tables;
---------------------------

---------------------------
.
.
.

.
.
.

But when I try to access the table. I get an error:

mysql> show create table slow_log\G
ERROR 13 (HY000): Can't get stat of './mysql/slow_log.CSV' (Errcode: 2)

Looking at the mysql Db files on disk, it is confirmed that the slow log table '.frm' file is there but not the '.CSM' or thte '.CSV' files

This is fixed by issuing a drop table on the affected table then recreating it (by getting its create line from another DB).

Suggested fix: Actually backing up the cam and csv files