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.
I have had my hosting with AYK since 2006, and it has by far been the best experience I have ever had with any hosting company. The support is always spot on and available around the clock, excellent for me since I'm always working on things at odd hours. They make upgrading to fit needs very clean and easy, the cost is excellent for services received, and they have me as a customer for life.
I have been a client for many years now. They always answer to my needs, and keep their prices affordable. I will continue with them in the future.
Without doubt the most professional and friendly support team i have ever experienced. These guys are really way above any other company i have worked with in the past.