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.
The most caring provider AYKSolutions is a reliable hosting and decicated server probider with good uptimes etc etc, which nowadays is a must for any copany in the hosting industry, But what makes them stand out from cowd - is there sincere care for their customers. AYK stuff is always asking you about problems you have and doing their best to solve the problems and help yo ur business to grow. Best support ever!
good service/support We have been with AYK for years. Good pricing/support. No complaints.
© 2004 - 2025 AYKsolutions, LLC. All Rights Reserved.
