Re: Mysql datafile location

[Yoav Ben Moha]

Hi Jon,

Thank you for your replay.

I see what you mean .
Yet , As you can see bellow data has been writen into the /mysql_data mount,
which mean that initialization done to /mysql_data.


# mysqld --initialize -u mysql --datadir /mysql_data
# cd /mysql_data
# ls -l

-rw-r----- 1 mysql mysql 56 Apr 12 16:37 auto.cnf
-rw-r----- 1 mysql mysql 420 Apr 12 16:37 ib_buffer_pool
-rw-r----- 1 mysql mysql 12582912 Apr 12 16:37 ibdata1
-rw-r----- 1 mysql mysql 50331648 Apr 12 16:37 ib_logfile0
-rw-r----- 1 mysql mysql 50331648 Apr 12 16:37 ib_logfile1
drwxr-x--- 2 mysql mysql 4096 Apr 12 16:37 mysql
drwxr-x--- 2 mysql mysql 8192 Apr 12 16:37 performance_schema
drwxr-x--- 2 mysql mysql 8192 Apr 12 16:37 sys

Yet , Why datadir point to the default location .... ?
mysql> select @@datadir;
+-----------------+
| @@datadir |
+-----------------+
| /var/lib/mysql/ |
+-----------------+
1 row in set (0.00 sec)

Best Regards
Yoav