diff options
| author | Jacob Vosmaer <contact@jacobvosmaer.nl> | 2015-07-13 18:14:26 +0200 |
|---|---|---|
| committer | Jacob Vosmaer <contact@jacobvosmaer.nl> | 2015-07-13 18:14:26 +0200 |
| commit | 9ba0079c5133cfef71b469c0af69db3e6c01bda1 (patch) | |
| tree | b3ff80c9e34e35d1ad6044203f01e14792ce0169 /doc/update/mysql_to_postgresql.md | |
| parent | 31565d78906577bf8582982e5492166e8edd3218 (diff) | |
| download | gitlab-ce-9ba0079c5133cfef71b469c0af69db3e6c01bda1.tar.gz | |
Add 'ed' step to mysql-to-postgres procedure
Introduced in
https://github.com/gitlabhq/mysql-postgresql-converter/commit/b2d1599706f532e1bac836243f25e005c816ef14
Diffstat (limited to 'doc/update/mysql_to_postgresql.md')
| -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 |