summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authordosire <sytses@gmail.com>2014-03-17 14:55:56 +0100
committerdosire <sytses@gmail.com>2014-03-17 14:55:56 +0100
commit70994c348dede58b6ed8da84b02465e4665dc305 (patch)
tree83588cabfe973adcdd99be18dbc1a67996a01535
parent0aa389b4911221e0ec5730d5342a1c59f37a8015 (diff)
downloadgitlab-ce-70994c348dede58b6ed8da84b02465e4665dc305.tar.gz
Postgresql conversion script.
-rw-r--r--doc/update/mysql-to-postgresql.md9
1 files changed, 9 insertions, 0 deletions
diff --git a/doc/update/mysql-to-postgresql.md b/doc/update/mysql-to-postgresql.md
new file mode 100644
index 00000000000..9a324545eb0
--- /dev/null
+++ b/doc/update/mysql-to-postgresql.md
@@ -0,0 +1,9 @@
+# Use the shell commands below to convert a MySQL GitLab database to a PostgreSQL one.
+
+```
+git clone https://github.com/lanyrd/mysql-postgresql-converter.git
+cd mysql-postgresql-converter
+mysqldump --compatible=postgresql --default-character-set=utf8 -r databasename.mysql -u root gitlabhq_production
+python db_converter.py databasename.mysql databasename.psql
+psql -f databasename.psql -d gitlabhq_production
+```