Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
Hello,
We have a big problem with our site.
We restore database from backup, clear cache and all special characters like "®", "em dash", "apostrophe" etc. are lost from the content. (replaced to "?" character )
We've tried to make backup via phpmyadmin and backup and migrate module. ( got same result)
Server is running on CentOS, php version is 5.5, mysql 5.5.52 version is.
Also we tried use defferent database encodings, such as utf8_general_ci and utf8mb4_general_ci
Drupal core 8.2.4
Please help.
Comments
Comment #2
mradcliffeChanged to support request and downgraded from Critical per How to create a good issue. Removed superfluous issue tag.
Comment #3
Anonymous (not verified) CreditAttribution: Anonymous commentedI don't know about phpmyadmin, but backup and migrate module has very big critical problem #2749885: Database irreversibly corrupted after export and restore - Encoding issues with non ASCIII texts. Half a year we have a RTBC issue, but .. We have also tried to apply for support through 'Project/Git problem' branch #2832836: Warning for Backup and Migrate 8.x users on project page and message to authors of the module, but nothing. It grieves because the module is quite popular (on the Planet Drupal I've read that this module even ranked in the top popular modules). Hopefully, your issue will help draw attention to the problem of someone, who can help to solve it.
Comment #4
cilefen CreditAttribution: cilefen as a volunteer commentedWhat is the method used to restore the database from backup? What evidence has led your investigation to conclude the database system is the problem? Is this database restoration to the same codebase as the original site?
Comment #5
Dmytro P. CreditAttribution: Dmytro P. commentedWe found solution.
The method used to restore database from backup was using module "Backup and migrate".
The solution is to avoid data from cache tables.
So if you want to make backup:
1. Copy all tables structure and data without tables with cahce_ prefix
2. Copy structure only from tables which begins with cache_
If you want to restore:
1. Restore all tables with data and structure
2. Restore cache_ tables with structure
This method works for us
Comment #6
cilefen CreditAttribution: cilefen as a volunteer commentedComment #7
ronan CreditAttribution: ronan commentedThe 8.x-3.x branch is non-functional and abandoned. I suspect this is a duplicate of #2749885: Database irreversibly corrupted after export and restore - Encoding issues with non ASCIII texts