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

CommentFileSizeAuthor
Erro 1Captured.PNG36.7 KBNahomA
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

NahomA created an issue. See original summary.

jochemvn’s picture

Component: Code (back-end) » Other
Category: Bug report » Support request
Priority: Major » Normal

Hi 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

bramtenhove’s picture

Status: Active » Closed (outdated)