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.
My first experience with VPS and I din't really know what to do or what to expect. AykSolutions.com team help me and during the entire process, they are patient and problem solving peoples. Cheers,
AYK Solutions has provided me with a very cost effective hosting service with great uptime and lots of features. I would not hesitate to recommend them!
perfect service Using their service for 4 years without problem. Support is not the fastest of the world ,but all inquiry are fixed in time . they have also fixed my pbandwith overuse ,without make me paying it,just by upgrading my account ! perfect! Good services ,you can go with them !
© 2004 - 2026 AYKsolutions, LLC. All Rights Reserved.
