title: Too many open files error on Ubuntu 8.04
body: <pre><code>mysqldump: Couldn't execute 'show fields from `tablename`': Out of resources when opening file './databasename/tablename#P#p125.MYD' (Errcode: 24) (23)
  </code></pre>
  
  <p>on checking the error 24 on the shell it says</p>
  
  <pre><code>&gt;&gt;perror 24
  
  OS error code  24:  Too many open files
  </code></pre>
  
  <p>how do I solve this?</p>