title: MySQL I/O error
body: <p>I get the following error:</p>
  
  <pre><code>Can't create table 'tmp' (errno: 5) CREATE TABLE IF NOT EXISTS tmp
  </code></pre>
  
  <p>When trying to read the directory with the data files I get the following:</p>
  
  <pre><code>ls: reading directory .: Input/output error
  </code></pre>
  
  <p>In mysql:</p>
  
  <pre><code>mysql&gt; show tables;
  Empty set (0.28 sec)
  </code></pre>
  
  <p>But ...</p>
  
  <pre><code>mysql&gt; select * from nw_site LIMIT 0,1;
  1 row in set (0.00 sec)
  </code></pre>
  
  <p>So even though there's an I/O error, SELECTs and UPDATEs are working. The website still seems to be working. </p>
  
  <p>mysqldump unfortunately can't get any data out, which means I don't have a backup - just 3 days of empty mysqldumps. As the site is working OK, I've only just noticed. </p>
  
  <p>Any ideas how to proceed? I'd love to get a backup somehow.</p>
  
  <p>** Edit **</p>
  
  <p>I've found a way to get a backup without mysqldump:
  <a href="http://www.perlmonks.org/?node_id=149869" rel="nofollow">http://www.perlmonks.org/?node_id=149869</a></p>