Archive for 2012

How to Delete WordPress Post Revisions To Reduce Database Size

 
It is also made sense to delete and remove all existing stored post revisions and changes made on pages stored in the database in order to reduce the wp_posts table size, especially when there is already tons of revisions or changes been kept. After this operation you can reduce several MB size of your wp_posts table.
 
To view your post revisions, select any post and click edit button then scroll down to bottom of the page.
 
Delete WordPress Post Revisions 1
 

To delete and remove all existing post revisions entries, delete all rows from WordPress database Posts table having post_type value as revision.


Read more »

How to change Hidden Attribute of a file/folder in Windows OS

When a Virus modifies these attributes to the files/folders in a removable device (USB/SD Memory/HDD) in order to hidden them from the user.

The problem is solved using attrib -s -h /s /d command.

The effect of New Folder.exe virus : It just make all your directory as system director and also make it hidden. Then it creates exe file for each directory with directory icon. This is why when you open any folder, it opens in new window (if you are using Microsoft windows as operating system).

So, First deleted all those exe files and delete recycle directory as well. This should remove your folder.exe virus. But still you need remove the effect of virus. You need to update back the folder attributes.

Open Command Prompt Window and navigate to the required folder usind cd <foldername> command then you can do it by a single line command:

Method 1

attrib -s -h /s /d


Method 2

attrib FOLDERNAME -s -r -a -h /S /D


Read more »

How to solve malayalam or any other font display error in wordpress

If your wordpress site don't show malayalam or any other fonts then no need to worry. It is a simple problem in your database.

Problem

Post title and post content accepts malayalam font and when you publish the post then it displays only ???????? characters.

Before publishing : After pasting malayalam texts in title and content page, It looks like below

malayalam font display error in wordpress 1

Read more »