title: Have a mysqldump with Indexes. How do I import it by disabling them?
body: <p>I am trying to import a large database but because there's an index, it is taking forever to import the database. I tried copying the raw files to a different machine but for some reason, the largest table is not being read giving me an error: <code>can't read file: 'tablename.MYD</code>. So I mysqldumped my old database but it did so with an index. I cannot do it again because it takes a really long time. </p>
  
  <p>I am trying to import the database but am not sure how to do it without indexes. I thought adding an index after import will be much faster. Does anyone have any suggestions?</p>