소중한 메인 하드의 수명을 위해, 각종 로그 및 DB 파일은 타 볼륨에 관리할 예정이다.
- 현재 datadir 확인
HumingCubis-iMac:wordpress $ mariadb -uroot -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 405
Server version: 10.8.3-MariaDB Homebrew
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> select @@datadir;
+-----------------------+
| @@datadir |
+-----------------------+
| /usr/local/var/mysql/ |
+-----------------------+
1 row in set (0.001 sec)/usr/local/var/mysql 이 기본 DB 위치이다. 이를 변경하긴 귀찮고, alias를 걸어 사용해본다.
변경할 DB위치는 /Volumes/Data/Database/mariadb/mysql 로 결정했다.
- 기존 DB 디렉토리는 혹시모르니 백업후, 심볼릭 링크를 생성한다.
HumingCubis-iMac:mysql $ cd /usr/local/var
HumingCubis-iMac:var $ mv mysql mysql.org
HumingCubis-iMac:var $ ln -s /Volumes/Data/Database/mariadb/mysql ./mysql
HumingCubis-iMac:var $ ls -al
total 0
drwxrwxr-x@ 11 huming admin 352 Oct 24 21:12 .
drwxr-xr-x 14 root wheel 448 Oct 21 22:17 ..
drwxr-xr-x 3 huming admin 96 Oct 24 01:04 cache
drwxrwxr-x 4 huming admin 128 Oct 1 21:33 homebrew
drwxr-xr-x 3 huming admin 96 Oct 24 18:17 lib
drwxr-xr-x 5 huming admin 160 Oct 24 12:56 log
lrwxr-xr-x 1 huming admin 36 Oct 24 21:12 mysql -> /Volumes/Data/Database/mariadb/mysql
drwxr-xr-x 15 huming admin 480 Oct 24 19:52 mysql.org
drwxr-xr-x 3 huming admin 96 Oct 24 01:15 run
drwxr-xr-x 2 huming admin 64 Oct 24 18:17 tmp
drwxr-xr-x 4 huming admin 128 Oct 19 16:56 www이후 mariadb 재기동하면 완료.
HumingCubis-iMac:var $ brew services restart mariadb