mysqldump error 1146 non exist table

Discussion in 'MySQL' started by swapshop, Oct 10, 2008.

  1. #1
    Hello

    I am currently with DH

    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 (change 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?

    DH 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?
     
    swapshop, Oct 10, 2008 IP