When trying to export fully functional opensocial website database from localhost (using database export) to destination site (using database import), would get you errors that I have attached below,
I have also tried another option, that is to import and export the opensocial database using command line tools like mysqldump. In this senario the database is uploded successfully but the website user interface is completely messed up.
Since installing opensocial on shared hosting environment has installation errors (https://www.drupal.org/node/2854130) and upgrading it is almost impossible (runs out memory). My best solutions is try to install and configure on my local website and then export it to the main site.
Could you please fix the database issues so that it wont fail when we try to import it to a new database.
thanks in advance
Comment | File | Size | Author |
---|---|---|---|
Erro 1Captured.PNG | 36.7 KB | NahomA |
Comments
Comment #2
jochemvn CreditAttribution: jochemvn for Open Social commentedHi NahomA,
Exporting and importing mysql database isn't a bug in Open Social. Usually when that happens there's a difference in:
- mysql version
- database encoding
- database collation
Unfortunately we cannot control how tools like mysqldump export the database. Maybe you can check if there are some differences there.
Jochem
Comment #3
bramtenhove CreditAttribution: bramtenhove for Open Social commented