0

Am a Newbie to MySql when I tried to do the backup its throwing me an error

mysqldump: Got error: 1146: 
Table doesn't exist when using LOCK TABLES

when i tried to drop that problem table it throws me an

error 1051 mysql
unable to drop the table.

I've tried everything, but doesnt work.

As it is still in the development stage, I've decided to drop that troubled Database and create new One.

Can't do this also.

Can anyone, please, help me out?

vyegorov
  • 21,787
  • 7
  • 59
  • 73
user1283164
  • 11
  • 2

3 Answers3

1

Try to delete the .frm .myi and .myd files of the following table.. if the table is using MyISAM storage engine or .frm and .ibd files if table is using InnoDB storage engine

user1283164
  • 11
  • 2
0

it explains. the table does not exist. Have you selected the active database schema ?

Raptor
  • 53,206
  • 45
  • 230
  • 366
0

Try to DROP this table and then create again (sometimes it helps). Also try to repair the database via mysqlcheck.

ruvim
  • 7,151
  • 2
  • 27
  • 36