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.
Great service with affordable price, also helpful and kindness staff.
I had never heard of AYK Solutions before, but they had an awesome deal I couldn't pass up on WHT. So far the service has been exceptional, and the server is rock solid. I'll be moving my other servers here soon!
Simply the best. have been using them from last 2 years. Remember Dedicated servers are hardware so few times problem do arrive. but always fixed in time. Really really Positive attitude from President.
© 2004 - 2025 AYKsolutions, LLC. All Rights Reserved.
