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

• http://codebeautify.org/xmltojson
• http://www.freeformatter.com/xml-to-json-converter.html
• http://www.utilities-online.info/xmltojson/

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

• http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1003940

MySQL or @percona startup error caused by #SELinux

MySQL or @percona startup error “Starting MySQL (Percona Server).The server quit without upd” can be caused by #SELinux

Quick fix

# setenforce 0
# sestatus

 

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

• https://www.centos.org/docs/5/html/5.2/Deployment_Guide/sec-sel-enable-disable-enforcement.html
• https://www.centos.org/docs/5/html/5.2/Deployment_Guide/sec-sel-enable-disable.html