Migrate from pgsql to mysql - Githubissues

thegooddata / social

GNU General Public License v2.0

0 stars 0 forks source link

Migrate from pgsql to mysql #21

Closed josereyero closed 10 years ago

josereyero commented 10 years ago

Migration run successfully on PRE. Notes:

One error, no idea which table, I think we can ignore it for now, we'll see any side effects while testing before the release: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'securing-56-node' for key 'PRIMARY'
Needed to install php5-mysql (it is already installed on PROD, according to Diego).

Quick instructions for PROD:

Put site into maintenance mode
Edit settings.php, add the mysql database.. $databases['mysqltarget']['default'] = array(....)
Migrate from 'default' to 'myqltarget' using DBTNG
Edit settings.php, rename 'default' to 'pgsql' and 'mysqltarget' to 'default' (we keep the old database for now, just in case).
Put site into live mode.

josereyero commented 10 years ago

Migrated PROD database, no issues. Disabled DBTNG module