summaryrefslogtreecommitdiff
path: root/doc/update/mysql-to-postgresql.md
blob: 9a324545eb0ae373fe26a04e329206f033a55813 (plain)
1
2
3
4
5
6
7
8
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
```