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

morrllok created an issue. See original summary.

mradcliffe’s picture

mradcliffe
he/him
Primary language English
CreditAttribution: mradcliffe commented
Assigned: Dmytro P. » Unassigned
Category: Bug report » Support request
Priority: Critical » Major
Issue tags: -database symbols

Changed to support request and downgraded from Critical per How to create a good issue. Removed superfluous issue tag.

Support requests by definition cannot be critical. Asking for support is often critical from the point of view from the requester, because (s)he is stuck, but it doesn't mean the software is unusable.

Anonymous’s picture

Anonymous (not verified) CreditAttribution: Anonymous commented
Related issues: +#2749885: Database irreversibly corrupted after export and restore - Encoding issues with non ASCIII texts

I 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.

cilefen’s picture

cilefen CreditAttribution: cilefen as a volunteer commented
Status: Active » Postponed (maintainer needs more info)

What 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?

Dmytro P.’s picture

Dmytro P. CreditAttribution: Dmytro P. commented

We 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

cilefen’s picture

cilefen CreditAttribution: cilefen as a volunteer commented
Project: Drupal core » Backup and Migrate
Version: 8.3.x-dev » 8.x-3.x-dev
Component: database system » Code
Category: Support request » Bug report
Status: Postponed (maintainer needs more info) » Active
ronan’s picture

ronan CreditAttribution: ronan commented
Status: Active » Closed (duplicate)

The 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