[ The imperialist Japanese military must officially acknowledge and apologize for the coercion of young women into sexual slaves. / êꪤҳàõªòàõªÎÒ¿Ö˪˪·ª¿ð¨ÏÐñ«ëùìíÜâÏÚªÎ?ð¤àõªòÍëãÒªËìãªá¡¢Þóñªª·ªÊª±ªìªÐªÊªéªÊª¤. ]

»ç¿ëÀÚ

ID:
PW:

INDEX
01.°Ô½ÃÆÇ
°Ô½ÃÆÇ [72]
02.File Book
File ÀÚ·á½Ç [96]
Site Link [14]
°³ÀÎÆú´õ [201]
03.Field Book
Altibase [19]
Tibero [31]
MS-SQL [32]
MySQL [47]
DB2 [79]
ORACLE [3204]
PSQL [143]
CUBRID [5]
±âŸÁ¤º¸ [194]
¿î¿µÃ¼Á¦ [634]
04.Q/A Book
Q/A [53]
05.¹æ¸í·Ï
¹æ¸í·Ï [54]
·¹º§¾÷ [37]
±¸ÀÎ/±¸Á÷ [2]

±â³äÀÏ
Search
LINK
+ °¡Á· Hompy
+ DNSEver
IOTN :: Work Book :: MySQL

 È¸¿ø°¡ÀÔ

MariaDB default datadir º¯°æ [ datafile À§Ä¡ º¯°æ ] test version 10.4
ÃÖ±æÈ£ [LIST]   2020-05-29 18:04:39, Á¶È¸ : 358

MariaDB [(none)]> select @@datadir;
+-----------------+
| @@datadir       |
+-----------------+
| /var/lib/mysql/ |
+-----------------+
1 row in set (0.000 sec)

root#
systemctl stop mariadb
systemctl status mariadb
mkdir /data
rsync -av /var/lib/mysql /data/
mv /var/lib/mysql /var/lib/mysql.bak

vi /etc/my.cnf
[client-server]
socket=/data/mysql/mysql.sock
[mysqld]
datadir=/data/mysql


## ±âÁ¸ Á¤º¸
!includedir /etc/my.cnf.d

semanage fcontext -a -t mysqld_db_t "/data/mysql(/.*)?"
restorecon -R /data/mysql

systemctl start mariadb

MariaDB [(none)]> select @@datadir;
+--------------+
| @@datadir    |
+--------------+
| /data/mysql/ |
+--------------+
1 row in set (0.000 sec)

MariaDB [(none)]>

Ãâó: https://www.tecmint.com/change-default-mysql-mariadb-data-directory-in-linux/


À§ Á¤º¸ ´Ù½Ã º¸°í ÇÏ¸é ¿¡·¯ ¾È³¯µí.
[root@node1 mysql]# systemctl start mariadb
Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.
[root@node1 mysql]# systemctl status mariadb.service
● mariadb.service - MariaDB 10.4.13 database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
           ⡱¡±â¡±¢æmigrated-from-my.cnf-settings.conf
   Active: failed (Result: exit-code) since Fri 2020-05-29 04:48:28 EDT; 8s ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 2943 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 5053 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
  Process: 5034 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
  Process: 5031 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 5053 (code=exited, status=1/FAILURE)
   Status: "MariaDB server is down"

May 29 04:48:28 node1 mysqld[5053]: 2020-05-29  4:48:28 0 [ERROR] Plugin 'InnoDB' init function returned error.
May 29 04:48:28 node1 mysqld[5053]: 2020-05-29  4:48:28 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
May 29 04:48:28 node1 mysqld[5053]: 2020-05-29  4:48:28 0 [Note] Plugin 'FEEDBACK' is disabled.
May 29 04:48:28 node1 mysqld[5053]: 2020-05-29  4:48:28 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
May 29 04:48:28 node1 mysqld[5053]: 2020-05-29  4:48:28 0 [ERROR] Failed to initialize plugins.
May 29 04:48:28 node1 mysqld[5053]: 2020-05-29  4:48:28 0 [ERROR] Aborting
May 29 04:48:28 node1 systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
May 29 04:48:28 node1 systemd[1]: Failed to start MariaDB 10.4.13 database server.
May 29 04:48:28 node1 systemd[1]: Unit mariadb.service entered failed state.
May 29 04:48:28 node1 systemd[1]: mariadb.service failed.
Hint: Some lines were ellipsized, use -l to show in full.
[root@node1 mysql]#




  LIST

Copyright 1999-2025 Zeroboard / skin by ÃÖ±æÈ£(gilho.kr@gmail.com)
ÃÖ±Ù ´ñ±Û
2008/12/15
MySQLÀÌ ¾ÈÁÁÀº°Ç°¡? Àå¾Öµµ ½±°Ô ³ª°í,...
by ÃÖ±æÈ£
ÃÖ±Ù °Ô½Ã¹°
07/03
[ORACLE]
ORA-02019: connection descript....
by ÃÖ±æÈ£
07/02
[¿î¿µÃ¼Á¦]
rsync -auv.
by ÃÖ±æÈ£
07/01
[±âŸÁ¤º¸]
shell for 001 ~ 100.
by ÃÖ±æÈ£