title: MYSQL Error at restoring database: Please DISCARD the tablespace before IMPORT
body: <p>For many times I have done successfully the same sequence for restoring the database commerce_db_622:</p>
  
  <ol>
  <li><p>Go to the directory /usr/local/mysql/data and perform the command: </p>
  
  <pre>sudo rm -rf COMMERCE_DB_622.</pre></li>
  </ol>
  
  <p>This drops the database COMMERCE_DB_622</p>
  
  <ol start="2">
  <li><p>Start the DB client :<pre> mysql –u root</pre></p></li>
  <li><p>Run the following script to create the database:</p>
  
  <pre>CREATE DATABASE COMMERCE_DB_622 /*!40100 DEFAULT CHARACTER SET utf8 */;
  </pre></li>
  <li><p>Move to the directory that stores the dump file COMMERCE_DB_622.sql and run the following command:</p>
  
  <p><code>mysql -u root COMMERCE_DB_622 &lt; COMMERCE_DB_622.sql</code></p></li>
  </ol>
  
  <p>This worked fine but suddenly today I am starting getting the error with the <strong>valid already checked backup file</strong>. </p>
  
  <blockquote>
    <p>ERROR 1813 (HY000) at line 25: Tablespace for table
    '<code>commerce_db_622</code>.<code>batch_job_execution</code>' exists. Please DISCARD the
    tablespace before IMPORT.</p>
  </blockquote>