Home / server / Questions / 153921
Accepted
inac
Asked: 2010-06-23 23:01:37 +0800 CST

Are MySQL databases always stored in /var on CentOS?

  • 772

Are MySQL databases always stored in /var on CentOS?

Specifically - If a new CentOS/cPanel server that needs to support MySQL, doesn't have that partition, but only has these, does that mean MySQL data is somehow being stored in a temporary dump somewhere?

/dev/sda3              /
tmpfs                  /dev/shm
/dev/sda1              /boot
/usr/tmpDSK            /tmp
centos mysql dedicated-server var centos5

2 Answers

  1. Best Answer

    In your case /var is stored on /dev/sda3 as a subdirectory of /.

    The default datadir for MySQL is /var/lib/mysql and as long as you do not change the configuration, the database files are stored in this directory.

    • 11

  2. In *nix, if a directory is not a separate mount then it is part of its parent mount. In this case, /var is considered part of /.

    • 4