Blog WordPress Management

* DB Backup
mysqldump –add-drop-table -u USER_NAME -p DB_NAME TABLE_NAMES1 TABLE_NAMES2.. | bzip2 -c > blog.bak.sql.bz2

* DB Restore
$ bzip2 -d blog.bak.sql.bz2
$ mysql -u USER_NAME -p DB_NAME < blog.bak.sql

* Password Recovery
$ echo -n password|md5sum
b59c67bf196a4758191e42f76670ceba

SELECT ID, user_login, user_pass FROM wp_users;
UPDATE wp_users SET user_pass=”b59c67bf196a4758191e42f76670ceba” WHERE ID = 1;

* delete table.
drop tables TABLE_NAME;