convert innodb to myisam

[GumSlone]

login via ssh to your server
create a file myisam.sh

nano myisam.sh

insert this code:

#!/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 -v 'Create Table'`
                if [ $TABLE_TYPE = "InnoDB" ] ; then
                        mysqldump $db $table > $db.$table.sql
                        echo "ALTER TABLE $table ENGINE = MyISAM" | $MYSQLCMD $db
                fi
        done
done

chmod the myisam.sh

chmod 0775 myisam.sh

run it:

./myisam.sh

[just_m3.]

How about login on database before executing the loop on myisam.sh ??
i get error since i'm not loged in on a specific database , the code would not execute.

[GumSlone]

it works for me when i login as a root user to my server