Centos – Are MySQL databases always stored in /var on CentOS

centoscentos5dedicated-serverMySQLvar

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

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.

Related Solutions

MySQL tmpdir on /dev/shm with SELinux

SELinux is preventing mysqld (mysqld_t) "getattr" to /dev/shm (tmpfs_t).

This means, that SELinux deny access to /dev/shm dir, which is a parent of /dev/shm/mysqltmp.

ls -lZd /tmp/
drwxrwxrwt 3 system_u:object_r:tmp_t:s0
ls -lZd /dev/shm
drwxrwxrwt  root root system_u:object_r:tmpfs_t:s0

You have 3 options:

1) Change /dev/shm type label from tmpfs_t to tmp_t

2) Run SELinux in permissive mode, and collect all denies in /var/log/audit/audit.log

tail -n 0 -f /var/log/audit/audit.log | audit2allow -m myMySQL -o myMySQL.te
checkmodule -M -m myMySQL.te -o myMySQL.mod
semodule_package -m myMySQL.mod -o myMySQL.pp

You should check, if myMySQL.te contains only necessary allows. Finally, you load module into kernel semodule -i myMySQL.pp

3) Disable SELinux protection for MySQL setsebool -P mysqld_disable_trans=on

Mysql – thesql with innodb_file_per_table – cannot see any .ibd files

File-per-table only applies to tables created after the option was enabled -- existing tables aren't copied out to separate files. You'll need to create new tables, copy the records across, then drop the old table and rename the new one to the old name to get all of your tables into their own files.

Best Answer

Related Solutions

MySQL tmpdir on /dev/shm with SELinux

Mysql – thesql with innodb_file_per_table – cannot see any .ibd files

Related Topic