title: mysqldump: Got error: 1146: Table ' myDatabase.table' doesn't exist when using LOCK TABLES
body: <p>I'm trying to get dump of my database:</p>
  
  <pre><code>mysqldump myDatabase &gt; myDatabase.sql
  </code></pre>
  
  <p>but I'm getting this error:</p>
  
  <pre><code>mysqldump: Got error: 1146: Table 'myDatabase.table' doesn't exist when using LOCK TABLES
  </code></pre>
  
  <p>When I go to mysql:</p>
  
  <pre><code> mysql -u admin -p
  </code></pre>
  
  <p>I query for the tables:</p>
  
  <pre><code>show tables;
  </code></pre>
  
  <p>I see the table. but when I query for that particular table:</p>
  
  <pre><code> select * from table;
  </code></pre>
  
  <p>I get the same error:</p>
  
  <pre><code>ERROR 1146 (42S02): Table 'myDatabase.table' doesn't exist
  </code></pre>
  
  <p>I tried to repair:</p>
  
  <pre><code>mysqlcheck -u admin -p --auto-repair --check --all-databases
  </code></pre>
  
  <p>but get the same error:</p>
  
  <pre><code>Error    : Table 'myDatase.table' doesn't exist
  </code></pre>
  
  <p>Why I'm getting this error or how can I fix this error?</p>
  
  <p>I'll really appreciate your help</p>