title: How to check MySQL integrity?
body: <p>I have a big MySQL 5 Database for a drupal site on an old machine. After backing up and restoring on a fresh database, I got:</p>
  
  <blockquote>
    <p>ERROR 1064 (42000) at line <em>*</em>*: You
    have an error in your SQL syntax;
    check the manual that corresponds to
    your MySQL server version for the
    right syntax to use near
    ''captcha_success_form_ids|a:1:{s:13:\"user_register\";s:13:\"user_register\";}sp'
    at line 1</p>
  </blockquote>
  
  <p>I am not sure which table is the origion of  this error  (I have no table called 'user_register'). So I am wondering how can I have a quick check of the original database for integrity before making another failed backup/restore effort? (I have command line access). Thanks</p>