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.
good service/support We have been with AYK for years. Good pricing/support. No complaints.
Great response time and excellent service. I've been with AYK for nearly a year now and I couldn't be happier. If you're ready to make the step up from budget hosting to someone that can still work with you to spec out a server for your needs at an extremely competitive price, shoot these guys an email and see what they have available. You will not regret it. With datacenters located all ove r the globe they're certain to have something for you.. or they'll just build it
We're Happy with our 1 Gigabit Server AYK Solutions! AYK Solutions provides all our back-end server infrastructure for our video streaming sites which burn up about 200 GB of data every day. I have had nothing less then 1 MB/second downloads from all the servers that I have had from them. Their technical support saved me several times, and their tech support is 24/7 and responsive. I currently have a Quad Xeon on a 1 gigE port for WAY LESS then any other dedicated server provider