Search code examples
mysqldatabase-integrity

How to check MySQL integrity?

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:

ERROR 1064 (42000) at line **: 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

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

Solution

  • The fragment quoted in the error message looks nothing like MySQL - it looks like serialised PHP data which makes me think you're not escaping your data properly in the code. Has your PHP installation changed? Particularly the smartquotes? (note smartquotes is now deprecated).