title: what is and how to remove tablespace error from my database?
body: <p>Because of loadshading issue, one of the table in my database got currupted.
  I dropped the table and now I want to create the table again.</p>
  
  <p>I'm getting this <strong>error</strong>:</p>
  
  <blockquote>
    <p>ERROR 1813: Tablespace for table '<code>zorkif</code>.<code>sys_user_accounts</code>' exists. Please DISCARD the tablespace before IMPORT.</p>
  </blockquote>
  
  <p><strong>SQL Statement:</strong></p>
  
  <pre><code>CREATE  TABLE `zorkif`.`sys_user_accounts` (
      `UserID` INT NOT NULL AUTO_INCREMENT ,    
      PRIMARY KEY (`UserID`) ,    
      UNIQUE INDEX `UserID_UNIQUE` (`UserID` ASC)
  )
  </code></pre>
  
  <p>What is tablespace and how to discard this tablespace? 
  Is there any command I have to run in query? 
  How to deal with this issue?</p>