title: To run a .sql -file in MySQL
body: <p>This question is based on <a href="https://stackoverflow.com/questions/1146470/to-read-sos-data-dump-effectively">this thread</a>.</p>
  
  <p>I run unsuccessfully</p>
  
  <pre><code>sudo mysql 
  \. /users/cs/SO_db/posts.sql 
  </code></pre>
  
  <p>I get the error</p>
  
  <pre><code>ERROR 1146 (42S02): Table 'personal.posts' doesn't exist
  </code></pre>
  
  <p><a href="http://dev.mysql.com/doc/refman/4.1/en/error-messages-server.html" rel="nofollow noreferrer">MySQL's manual</a> says</p>
  
  <blockquote>
    <p>A five-character SQLSTATE value
    ('42S02'). The values are specified by
    ANSI SQL and ODBC and are more
    standardized. Not all MySQL error
    numbers are mapped to SQLSTATE error
    codes. The value 'HY000'  (general
    error) is used for unmapped errors.</p>
  </blockquote>
  
  <p>and</p>
  
  <blockquote>
    <p>Error: 1146 SQLSTATE: 42S02 
    (ER_NO_SUCH_TABLE)</p>
    
    <p>Message: Table '%s.%s' doesn't exist</p>
  </blockquote>
  
  <p><strong>How can you solve the error message?</strong></p>