Did anybody tried to import/restore the backup sql file generated by the admin/backend ?
I did and MySQL gives an error as shown below:
DROP TABLE IF EXISTS ‘admin_assert’;
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 ‘’admin_assert’’ at line 1
On further analysis i tried a quick-fix, here in:
$script.= $this->_read->quoteInto('DROP TABLE IF EXISTS ?', $tableName).";\n";
to make it work i changed the line to
$script.= 'DROP TABLE IF EXISTS '.$this->_read->quoteIdentifier($tableName).";\n";
Actually it’s a problem with quote-symbol used of ‘ instead of ` in the generated sql. The code i changed is a quick-fix which worked on my side, so may need further investigation. Hope the Magento-Team will look into it.