diff options
| author | Dmitriy Zaporozhets <dzaporozhets@gitlab.com> | 2015-07-14 08:52:01 +0000 |
|---|---|---|
| committer | Dmitriy Zaporozhets <dzaporozhets@gitlab.com> | 2015-07-14 08:52:01 +0000 |
| commit | ee53ba9f3462823335e3133b0c243abde2d7ea00 (patch) | |
| tree | 9821cea1c2984f388698e8a021fa1dc40e6acb75 | |
| parent | 5c53dc5a1e7cbae3e7c281cfb0740d44c771958f (diff) | |
| parent | 9ba0079c5133cfef71b469c0af69db3e6c01bda1 (diff) | |
| download | gitlab-ce-ee53ba9f3462823335e3133b0c243abde2d7ea00.tar.gz | |
Merge branch 'mysql-to-postgres-ed' into 'master'
Add 'ed' step to mysql-to-postgres procedure
This change brings the documentation in this repo up to date with that in https://github.com/gitlabhq/mysql-postgresql-converter .
See merge request !1896
| -rw-r--r-- | doc/update/mysql_to_postgresql.md | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/doc/update/mysql_to_postgresql.md b/doc/update/mysql_to_postgresql.md index 8ef3e0d55cc..6f89f9eda79 100644 --- a/doc/update/mysql_to_postgresql.md +++ b/doc/update/mysql_to_postgresql.md @@ -16,6 +16,7 @@ git clone https://github.com/gitlabhq/mysql-postgresql-converter.git -b gitlab cd mysql-postgresql-converter mysqldump --compatible=postgresql --default-character-set=utf8 -r gitlabhq_production.mysql -u root gitlabhq_production -p python db_converter.py gitlabhq_production.mysql gitlabhq_production.psql +ed -s gitlabhq_production.psql < move_drop_indexes.ed # Import the database dump as the application database user sudo -u git psql -f gitlabhq_production.psql -d gitlabhq_production @@ -56,6 +57,7 @@ sudo -u git -H git clone https://github.com/gitlabhq/mysql-postgresql-converter. # Convert gitlabhq_production.mysql sudo -u git -H mkdir db sudo -u git -H python mysql-postgresql-converter/db_converter.py gitlabhq_production.mysql db/database.sql +sudo -u git -H ed -s db/database.sql < move_drop_indexes.ed # Compress database backup sudo -u git -H gzip db/database.sql |