Allows you to search a variety of questions and answers
To do this, you will need to stop your httpd server and then run the following script:
Code:
#/bin/bash #script to convert the whole database to innodb format. cp -iRfp /var/lib/mysql /var/lib/mysql-$(date +%s) for mydatabase in $(mysql --batch --column-names=false -e "show databases"); do for t in $(mysql --batch --column-names=false -e "show tables" $mydatabase); do mysql -e "alter table $t type=InnoDB" $mydbname; echo "converted "$t" to innodb" done done
Save it to a file and then execute it. Just make sure to make a backup before hand. Replace 'InnoDB' with MyISAM if you want to switch to MyISAM. Also replace 'mydatabase' and 'mydbname' with the name of the actual database that you want this done to.
Ayksolutions Customer Reviews Prompt, professional, efficient. I am currently using a shared account and plan on upgrading to a dedicated server...eventually when traffic picks up. The Ayk team is quick to reply to any concerns and does the best they can to correct the situation. I strongly recommend them for hosting.
Simply the best. have been using them from last 2 years. Remember Dedicated servers are hardware so few times problem do arrive. but always fixed in time. Really really Positive attitude from President.
I've been a client of AYK Solutions for about six months now. They have provided the best overall experience I have had in over 10 years. I've tried iWeb, SingleHop, and a few others supposed to be the so-called best. Specifically, you are dealing with personal, professionals with AYK Solutions, and they are willing to help when all others want to charge you $** for this and $**/hr for that. I'm happy, and have no plans of going anywhere else; ever.