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.
You can trust your business with AYKsolutions After a horrible experience with my prior host that left me with over 14 hours of downtime, AYKSolutions came in, took care of the transfer completely and made my life easier. When they say their servers are semi-managed, it means they take care of more then most managed server hosting companies. Average ticket response time? 2-5 minutes. One time i n the middle of the night it took 30 minutes. Problems that I create are fixed immediately and they take care of their customers. Artyom is the owner, who is somehow capable of not sleeping. He's always there to take care of everything with a personal touch. 3 AM on a Saturday? Not an issue for AYKSolutions. Trust me, I'm very thorough in researching a company. When it comes to business, you can never be too careful. I trust my business with AYKSolutions
Hi guys, I am pretty satisfied with your service. Yes, I have experienced some downtime issues with my boxes, but you guys have always been right there for me, at my beck and call whenever I need you. Additionally, you guys are always more than fair when it comes to helping me configure my boxes with my DirectAdmin control panel. Overall, I am very pleased with the service, both in terms of the hardware I receive from you as well as the customer service. Prices seem to be quite fair too. Thanks, Ephi
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