blob: 069fdb8d440d2b965ce70f3b64c3713581b9ea1f (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
|
[](https://ci.genenetwork.org/jobs/dump-genenetwork-database-tests)
[](https://ci.genenetwork.org/jobs/dump-genenetwork-database)
The GeneNetwork database is being migrated from a relational database to
a plain text and RDF database. This repository contains code to dump the
relational database to plain text.
# Using
Drop into a development environment with
``` shell
$ guix shell
```
Describe the database connection parameters in a file *conn.scm* file as
shown below. Take care to replace the placeholders within angle brackets
with the appropriate values.
``` scheme
((sql-username . "<sql-username-here>")
(sql-password . "<sql-password-here>")
(sql-database . "<sql-database-name-here>")
(sql-host . "<sql-hostname-here>")
(sql-port . <sql-port-here>))
```
Then, to dump the database to \~/data/dump, run
``` shell
$ ./pre-inst-env ./dump.scm conn.scm ~/data/dump
```
Make sure there is enough free space! It\'s best to dump the database on
penguin2 where disk space and bandwidth are not significant constraints.
# Contributing
See bugs and tasks in BUGS.org.
|
