Script to convert InnoDB tables to MyISAM

#!/bin/bash MYSQLCMD=mysql for db in `echo show databases | $MYSQLCMD | grep -v Database`; do for table in `echo show tables | $MYSQLCMD $db | grep -v Tables_in_`; do TABLE_TYPE=`echo show create table $table | $MYSQLCMD $db | sed -e’s/.*ENGINE=\([[:alnum:]\]\+\)[[:space:]].*/\1/’|grep…

E-Mail Testing

Following are the few sites from where we can test our mailserver and domain for testing, reputation and blacklsiting.  Blacklist Checking https://www.blacklistmaster.com/check?t=<ip address> DKIM Testing http://dkimcore.org/c/keycheck IP/Domain Reputation and Scores http://www.senderbase.org/lookup/?search_string=<ip address or domain> https://www.senderscore.org/lookup.php?lookup=<ip address>&validLookup=true http://mxtoolbox.com/ Scan Website for…

Parallels Plesk for Linux services logs and configuration files

Below, you will find the services’ configuration and log file locations, which may be useful in a troubleshooting procedure. Services Control Panel Logs Error log: /var/log/sw-cp-server/error_log and /var/log/sw-cp-server/sw-engine.log Access log: /usr/local/psa/admin/logs/httpsd_access_log Panel log: /usr/local/psa/admin/logs/panel.log Services Stop: /etc/init.d/psa stop Start: /etc/init.d/psa…