TYPE-0 FILEMANAGER

EDIT: convert_myisam_to_innodb_for_user.sh

#!/bin/bash

# Prompt for cPanel username
read -p "Enter the cPanel username: " CPANEL_USER

# Generate convert.sql file for the user's databases with MyISAM tables
mysql --skip-column-names -e "SELECT CONCAT('ALTER TABLE ', TABLE_SCHEMA, '.', TABLE_NAME, ' ENGINE=InnoDB;') FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA LIKE '${CPANEL_USER}_%' AND ENGINE = 'MyISAM';" > convert.sql

# Check if convert.sql is empty (no MyISAM tables found)
if [ ! -s convert.sql ]; then
    echo "No MyISAM tables found for ${CPANEL_USER}. No changes made."
    rm -f convert.sql
    exit 0
fi

# Display the generated SQL commands for confirmation
echo "Generated SQL commands for conversion:"
cat convert.sql

# Confirm execution
read -p "Do you want to proceed with converting these tables? (y/n) " CONFIRM
if [[ "$CONFIRM" =~ ^[Yy]$ ]]; then
    mysql < convert.sql
    echo "Conversion completed for ${CPANEL_USER}'s databases."
    rm -f convert.sql
else
    echo "Conversion aborted."
    rm -f convert.sql
fi

BACK TO DIR