title: MariaDB 10 CentOS 7 moving datadir woes
body: <p>Brand new "minimal" install of CentOS 7 along with MariaDB 10. I have an additional mounted mirrored volume that I want to use for the datadir. Startup sequence is fine and completes normally when my.cnf [mysqld] is commented out. I've copied the data..</p>
  
  <pre><code>sudo cp -R -p /var/lib/mysql/* /mnt/mysql/
  </code></pre>
  
  <p>The permissions are identical to those of the original. The volume is in /etc/fstab and mounts fine
      <code>/dev/sdb1 /mnt/mysql               xfs defaults    0 0</code></p>
  
  <pre><code>[root@femur mysql]# ls -la
  total 110632
  drwxr-xr-x. 5 mysql mysql     4096 Oct 20 15:27 .
  drwxr-xr-x. 3 root  root        18 Oct 16 16:46 ..
  -rw-rw----. 1 mysql mysql    16384 Oct 20 15:27 aria_log.00000001
  -rw-rw----. 1 mysql mysql       52 Oct 20 15:27 aria_log_control
  -rw-r-----. 1 mysql root      7005 Oct 20 13:49 femur.err
  -rw-rw----. 1 mysql mysql 12582912 Oct 20 15:27 ibdata1
  -rw-rw----. 1 mysql mysql 50331648 Oct 20 15:27 ib_logfile0
  -rw-rw----. 1 mysql mysql 50331648 Oct 20 12:21 ib_logfile1
  -rw-rw----. 1 mysql mysql        0 Oct 20 12:22 multi-master.info
  drwx--x--x. 2 mysql mysql     4096 Oct 20 12:21 mysql
  drwx------. 2 mysql mysql     4096 Oct 20 13:37 performance_schema
  drwxr-xr-x. 2 mysql mysql        6 Oct 20 12:21 test
  </code></pre>
  
  <p>this is in my.cnf</p>
  
  <pre><code>!includedir /etc/my.cnf.d
  [mysqld]
  log_error = /var/log/mysql-error.log
  user = mysql
  datadir = /mnt/mysql
  socket = /mnt/mysql/mysql.sock
  </code></pre>
  
  <p>This is what I get when I try to start it...</p>
  
  <pre><code>'[root@femur mysql]# sudo systemctl start mysql.service
  Job for mysql.service failed. See 'systemctl status mysql.service' and 'journalctl -xn' for details.'
  </code></pre>
  
  <p>Neither of those two files says much, but this is in /var/log/mysql-error.log</p>
  
  <pre><code>141020 16:07:09 mysqld_safe Starting mysqld daemon with databases from /mnt/mysql
  141020 16:07:09 [Warning] Can't create test file /mnt/mysql/femur.lower-test
  141020 16:07:09 [Note] InnoDB: Using mutexes to ref count buffer pool pages
  141020 16:07:09 [Note] InnoDB: The InnoDB memory heap is disabled
  141020 16:07:09 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  141020 16:07:09 [Note] InnoDB: Memory barrier is not used
  141020 16:07:09 [Note] InnoDB: Compressed tables use zlib 1.2.7
  141020 16:07:09 [Note] InnoDB: Using Linux native AIO
  141020 16:07:09 [Note] InnoDB: Using CPU crc32 instructions
  141020 16:07:09 [Note] InnoDB: Initializing buffer pool, size = 128.0M
  141020 16:07:09 [Note] InnoDB: Completed initialization of buffer pool
  2014-10-20 16:07:09 7f6cb59c9880  InnoDB: Operating system error number 13 in a file operation.
  InnoDB: The error means mysqld does not have the access rights to
  InnoDB: the directory.
  141020 16:07:09 [ERROR] InnoDB: os_file_get_status() failed on './ibdata1'. Can't determine file permissions
  141020 16:07:09 [ERROR] InnoDB: The system tablespace must be writable!
  141020 16:07:09 [ERROR] Plugin 'InnoDB' init function returned error.
  141020 16:07:09 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
  141020 16:07:09 [ERROR] mysqld: File '/mnt/mysql/aria_log_control' not found (Errcode: 13 "Permission denied")
  141020 16:07:09 [ERROR] mysqld: Got error 'Can't open file' when trying to use aria control file '/mnt/mysql/aria_log_control'
  141020 16:07:09 [ERROR] Plugin 'Aria' init function returned error.
  141020 16:07:09 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
  141020 16:07:09 [Note] Plugin 'FEEDBACK' is disabled.
  141020 16:07:09 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
  141020 16:07:09 [ERROR] Unknown/unsupported storage engine: InnoDB
  141020 16:07:09 [ERROR] Aborting
  
  141020 16:07:09 [Note] /usr/sbin/mysqld: Shutdown complete
  
  141020 16:07:09 mysqld_safe mysqld from pid file /mnt/mysql/femur.pid ended
  </code></pre>
  
  <p><a href="http://www.reddit.com/r/linuxadmin/comments/2ebhpf/adventures_in_moving_mariadb_data_folder/">http://www.reddit.com/r/linuxadmin/comments/2ebhpf/adventures_in_moving_mariadb_data_folder/</a> helped a bit, but I wasn't able to get it to work.</p>
  
  <p>Any help would be greatly appreciated.</p>