title: MySQL error after deleting a row (Error 1194)
body: <p>I am running a MySQL database in windows server 2003. Because it is extremely old, I want to migrate all my data to a new Windows Server 2012 instance. I started dumping all the data into dumps. The problem is that I had to delete a row in a database's table, and I did it manually (note that I did the deletion while no dump was being generated). After that, while trying to query my table, or creating a dump from it I get:</p>
  
  <p><code>Table 'table' is marked as crashed and should be repaired</code> with <code>ErrorNr.</code> -> <code>1194</code>.</p>
  
  <p>What would be the procedure to "repair" the database. Any advice on this? I am also worried that I will lose any data. I wanted to make a table/database dump before trying to repair it, but while doing so I get the same error.</p>
  
  <p>Any suggestions? Does anybody know how can I backup my database?</p>
  
  <p>Thank you for your advice in advance!</p>
  
  <p>Jack</p>