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.
AYK Solutions offers unmatched top tier support. They have gone above and beyond time and time again. They are very pompt, highly knowlegeable and curtious. I have been using AYK for 4 years now and yup its easy to say they have earned a customer for life. Thank you so much for helping me and business excell. Regards, Johnny
Great prices and service! Truly is painless, professional and polite (That's their slogan).
I love AYK. been with them for over 5 years and the best ever
© 2004 - 2026 AYKsolutions, LLC. All Rights Reserved.
