mysqldump error 1146 non exist table

[swapshop]

Hello

I am currently with <host snipped>

I was told to move to a PSMysql server due to hight usage as my sites ramp up

I want to take my usual weekly backup using mysqldump

mysqldump --opt -uuser_user -ppassword! -h localhost dateau_db > BK_11_Aug_2008.sql

Most of the sites complete this ok (chaneg the cmd line per site) but two sites report this error

mysqldump error 1146 non exist table

Check to see the table and it does not exist yet when I try to create it I get a message that the table is actually there in both case?

<host snipped> tell me they need to restore from BK?

What else can I do before I need to BK as the sites are fine except no BK?

[edited by: physics at 7:03 pm (utc) on Oct. 12, 2008]

[physics]

Did you try doing an optimize/repair?

[dev.mysql.com...]

[swapshop]

yes I have cron jobs doing this weekly

Still no further ahead?

[swapshop]

Sorry is this the same as repair from Mysql web interface?