MySQL table conversion

To convert all InnoDB Tables to MyISAM (all databases)

SELECT CONCAT('ALTER TABLE ', TABLE_SCHEMA, '.', TABLE_NAME, ' engine=MyISAM;')
FROM information_schema.TABLES WHERE ENGINE = 'InnoDB';

To convert all MyISAM Tables to InnoDB (all databases)

SELECT CONCAT('ALTER TABLE ', TABLE_SCHEMA, '.', TABLE_NAME, ' engine=InnoDB;')
FROM information_schema.TABLES WHERE ENGINE = 'MyISAM';

Run the single command from the provided list of commands got from the above result to convert the tables

Popular posts from this blog

Add addon-domain, sundomain and parked domains via shell in a Cpanel server

For Subdomain and Addon domains echo "[UID] ADD [SUB] [DOMAIN] [TURN OFF CAN NAME] [DIR]" | /usr/local/cpanel/bin/ domainadmin [UID] = unix uid of user to add domain to [SUB] = subdomain portion of the domain ==>bob<===. cpanel.net [DOMAIN] non sub portion bob.==> cpanel.net <== [TURN OFF CAN NAME] = 0 for subdomains, 1 for addon domains [DIR] = /home/USER/public_html/bob For Parked domains echo "[UID] ADD [DOMAIN] [TOPDOMAIN]" | /usr/local/cpanel/bin/ parkadmin [UID] = unix uid of user to add domain to [DOMAIN] = parked domain [TOPDOMAIN] = domain to park on  
Read more

Cpanel Migration Script

#!/bin/bash #Script Usage:  sh migration.sh <user> <source_IP> #by Sileep Kumar M S <sileepkumar@gmail.com> USER=$1 IP=$2 PORT=22 if [ -z "$USER" ] | [ -z "$IP" ]; then     echo "Usage: sh migration.sh <user> <source_IP>" else /usr/bin/ssh -p $PORT -o StrictHostKeyChecking=no root@$IP "/bin/mkdir /home/MIGRATION" echo "Packing the account $USER" /usr/bin/ssh -p $PORT -o StrictHostKeyChecking=no root@$IP "/usr/local/cpanel/bin/pkgacct --skiphomedir $USER /home/MIGRATION" echo "Downloading the package from $IP" /bin/rm -f /home/cpmove-$USER.tar.gz  /usr/bin/scp -P $PORT root@$IP:/home/MIGRATION/ cpmove-$USER.tar.gz /home/ echo "Restoring the account $USER"   if [ -f /home/cpmove-$USER.tar.gz ]; then   /usr/local/cpanel/bin/ restorepkg --force $USER   else   echo "/home/cpmove-$USER.tar.gz not found"   fi echo "C...
Read more