By TWD on
Is my database corrupted?
And if so, how to fix it?
I have an empty Database on a test site.
When I try to run the PhpMyAdmin SQL Import
here is the result.
Error
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem
ERROR: Unclosed quote @ 13
STR: `
SQL:
INSERT INTO `drp_menu_rou
SQL query:
INSERT INTO `drp_menu_rou
MySQL said: Documentation
#1064 - 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 '' at line 1
Comments
OK, I manually flushed the
OK, I manually flushed the Drupal Cache and re-exported an SQL backup using
BackUp&Migrate.
Now it successfully imported!
Two questions.
1) Why would clearing the cache have any impact?
2) Does this mean the BackUp&Migrate is NOT to be trusted?
It's a worry if I can't rely on the auto generated DB backups
to recover whenever disaster strikes!
This happened again. I
This happened again.
I manually generated a MySQL backup file.
Tried to import into phpMyAdmin but got hit
with SQL errors.
Tried again. This time did a Site Configuration / Performance / Clear Cached Data.
Then generated the backup sql file.
Tried to import into phpMyAdmin.
This time success.
Anybody got some ideas on what is going wrong?
In the BM scheduled profile,
In the BM scheduled profile, exclude cache_* and search index tables. This is the default setting, and that configuration never gave me errors.
What's new and changing in PHP 8.4