mk-find db-name --engine MyISAM --exec "ALTER TABLE %D.%N ENGINE=INNODB" --print
11/29/2010
how to convert tables to InnoDB
Using nice tool from Maatkit, we can easy convert tables from any storage engine to other. there is example how to convert from myisam to innodb
11/22/2010
how to install php5.3.x & 5.2.x centos
there are 3 steps how to install/upgrade php on centos server/vps
1. install webtatic repo:
2. install/upgrade php 5.3.x
yum --enablerepo=webtatic install php
yum --enablerepo=webtatic upgrade php
3. install/upgrade php 5.2.x
yum --enablerepo=webtatic --exclude=php*5.3* update php
yum --enablerepo=webtatic --exclude=php*5.3* install php
1. install webtatic repo:
rpm -ivh http://repo.webtatic.com/yum/centos/5/`uname -i`/webtatic-release-5-1.noarch.rpm
2. install/upgrade php 5.3.x
yum --enablerepo=webtatic install php
yum --enablerepo=webtatic upgrade php
3. install/upgrade php 5.2.x
yum --enablerepo=webtatic --exclude=php*5.3* update php
yum --enablerepo=webtatic --exclude=php*5.3* install php
Labels:
centos,
lifehack,
Open Source,
PHP
Subscribe to:
Posts (Atom)