ervan:~# tail -f /var/log/blog

The first thing to do is backing up your database :

commands used :

mysqldump -u username -p databasename > filename.sql

After that login to your mysql databases,place where it belongs wordpress then select the database.

commands used :

mysql> UPDATE  wp_term_taxonomy,wp_terms SET wp_term_taxonomy.description = wp_terms.name WHERE wp_term_taxonomy.term_id = wp_terms.term_id

Requirement
* Apache
* Mysql

Package Extracting

debian:~# wget http://wordpress.org/latest.tar.gz
debian:~# tar -zxvf latest.tar.gz

Database setup

mysql> create database wordpress;
Query OK, 1 row affected (0.01 sec)
mysql> GRANT ALL PRIVILEGES on wordpress.* to user@localhost identified by 'user_password';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
mysql> exit;

WordPress setup

ervan:~# cd wordpress/
ervan:~/wordpress# cp wp-config-sample.php wp-config.php
ervan:~/wordpress# nano wp-config.php

// ** MySQL settings - You can get this info from your web host ** //
/** The name of the database for WordPress */
define('DB_NAME', 'wordpress');

/** MySQL database username */
define('DB_USER', 'user');

/** MySQL database password */
define('DB_PASSWORD', 'user_password');

/** MySQL hostname */
define('DB_HOST', 'localhost');

ervan:~/wordpress# cd
ervan:~# mv wordpress/ /usr/local/apache2/htdocs/wordpress/

Restart your Web Server

ervan:~/wordpress# /usr/local/apache2/bin/apachectl stop
ervan:~/wordpress# /usr/local/apache2/bin/apachectl start

You can setup your virtual host pointing to your wordpress htdocs