MySQL
Wordpress change InnoDB to MyIsam
If you want to change a Wordpress database from InnoDB to MyIsam.
- make a backup of your database first
- open your phpMyAdmin, paste in the following codes
[ Read the rest ... ]
Delete un-used tags in Wordpress
Open phpMyAdmin, make a backup of your database first
Find all un-used tags
SELECT * From wp_terms wt INNER JOIN wp_term_taxonomy wtt ON wt.term_id=wtt.term_id WHERE wtt.taxonomy='post_tag' AND wtt.count=0;
[ Read the rest ... ]
Install LAMP on CentOS 5
Install LAMP (Linux Apache MySQL and PHP)
yum install httpd php php-mysql mysql mysql-server chkconfig httpd on chkconfig mysqld on /etc/init.d/httpd restart /etc/init.d/mysqld restart
set MySQL root password
[ Read the rest ... ]