summaryrefslogtreecommitdiff
path: root/topics/setting-up-local-development-database.gmi
diff options
context:
space:
mode:
authorFrederick Muriuki Muriithi2022-08-22 07:38:57 +0300
committerFrederick Muriuki Muriithi2022-08-22 07:40:10 +0300
commit7cb0678f263326983a24b97d366d6b2ef67ce58b (patch)
tree90e2acbcafbb789b91abbd71115022538cf05516 /topics/setting-up-local-development-database.gmi
parent0fde34533b01168c5de81fa63f8b08ad79c10da6 (diff)
downloadgn-gemtext-7cb0678f263326983a24b97d366d6b2ef67ce58b.tar.gz
Use ${HOME} for documentation.
Diffstat (limited to 'topics/setting-up-local-development-database.gmi')
-rw-r--r--topics/setting-up-local-development-database.gmi16
1 files changed, 8 insertions, 8 deletions
diff --git a/topics/setting-up-local-development-database.gmi b/topics/setting-up-local-development-database.gmi
index 3c6c291..9d55d33 100644
--- a/topics/setting-up-local-development-database.gmi
+++ b/topics/setting-up-local-development-database.gmi
@@ -84,8 +84,8 @@ MariaDB [mysql]> GRANT ALL PRIVILEGES ON webqtlout.* TO 'webqtlout'@'localhost';
Now logout, and log back in as the new webqtlout user:
```
-/home/frederick/opt/gn_profiles/gn2_latest/bin/mysql \
- --defaults-file=/home/frederick/genenetwork/mariadb/my.cnf \
+${HOME}/opt/gn_profiles/gn2_latest/bin/mysql \
+ --defaults-file=${HOME}/genenetwork/mariadb/my.cnf \
--user=webqtlout --host=localhost --password webqtlout
```
@@ -124,16 +124,16 @@ ${HOME}/opt/gn_profiles/gn2_latest/bin/mysqld_safe \
Then update the databases
```
-$ /home/frederick/opt/gn_profiles/gn2_latest/bin/mysql_upgrade \
- --defaults-file=/home/frederick/genenetwork/mariadb/my.cnf \
+$ ${HOME}/opt/gn_profiles/gn2_latest/bin/mysql_upgrade \
+ --defaults-file=${HOME}/genenetwork/mariadb/my.cnf \
--user=frederick --password --force
```
and login as the administrative user:
```
-$ /home/frederick/opt/gn_profiles/gn2_latest/bin/mysql \
- --defaults-file=/home/frederick/genenetwork/mariadb/my.cnf \
+$ ${HOME}/opt/gn_profiles/gn2_latest/bin/mysql \
+ --defaults-file=${HOME}/genenetwork/mariadb/my.cnf \
--user=$(whoami) --password
```
@@ -146,8 +146,8 @@ MariaDB [mysql]> GRANT ALL PRIVILEGES ON db_webqtl_s.* TO 'webqtlout'@'localhost
now logout as the administrative user and log back in as the normal user
```
-/home/frederick/opt/gn_profiles/gn2_latest/bin/mysql \
- --defaults-file=/home/frederick/genenetwork/mariadb/my.cnf \
+${HOME}/opt/gn_profiles/gn2_latest/bin/mysql \
+ --defaults-file=${HOME}/genenetwork/mariadb/my.cnf \
--user=webqtlout --host=localhost --password db_webqtlout_s
MariaDB [db_webqtlout_s]> SELECT * FROM ProbeSetData LIMIT 20;