From 70994c348dede58b6ed8da84b02465e4665dc305 Mon Sep 17 00:00:00 2001 From: dosire Date: Mon, 17 Mar 2014 14:55:56 +0100 Subject: Postgresql conversion script. --- doc/update/mysql-to-postgresql.md | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 doc/update/mysql-to-postgresql.md 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 +``` -- cgit v1.2.1