Monthly Archives: December 2015

conversion of #xml with attributes to #json with attributes

how can you convert #xml with attributes to #json with attributes

these three xml converters give three different answers

and represent XML attributes as either

  • _attr
  • @attr
  • -attr

Moving MySQL or Percona db files to another disk

Moving MySQL or Percona database files  to another disk

Phase I

  • add disk to vm
  • fdisk newdisk
  • mkfs newdisk
  • create new mountpoint
  • add newdisk to fstab
  • reboot

Phase II

  • service mysql stop
  • mkdir /storage/mysql
  • mv /var/lib/mysql/* to /storage/mysql
  • DO NOT DELETE /var/lib/mysql it is still used for sockets
  • vi /etc/my.cnf
  • [mysqld]
  • datadir=/storage/mysql
  • socket=/var/lib/mysql/mysql.sock

Phase III

  • chown -R mysql:mysql /storage/mysql
  • turn off selinux
  • service mysql start

See

HTTPD #PHP #PDO error caused by #SELinux

The HTTPD PHP PDO connect error “SQLSTATE[HY000] [2002] Permission denied” can be caused by SELinux on Centos & Red Hat 5 & 6

Quick Fix

# setenforce 0
# sestatus

See