Original Tips & Tricks

Almost all of us are using Facebook for the social netwoking, but the facebook profile link gives some dissatisfaction as it is not memorable.

For example, you can get

http://www.facebook.com/username

instead of,

http://www.facebook.com/profile.php?id=1234567890

To do so,

1. visit, http://www.facebook.com/username

2. And now select the username of your choice, after checking for its availability.

After completing it, you will get a memorable facebook profile link, which could be easily shared with you friends, and circles.

Earlier you have read how to disable the post revisions, but what, if you already have a number of post revisions in your wordpress database?

Here is the procedure to delete the existing post revisions in wordpress database.

1. Go to the phpMyAdmin or sql-manager to manage the wordpress database on your hosting service provider.

2. Now select the wordpress database, from which you want to remove the post revisions.

3. Now go to the SQL Tab, available at top in the options menu.

4. Paste

DELETE FROM wp_posts WHERE post_type = "revision";

in the text-area and Hit the Go button.

5. You’ll get a alert stating

Do you really want to :
DELETE FROM wp_posts WHERE post_type = "revision";

Click on OK button.

6. After a few moments, you’ll get the confirmation message (depending upon the available post revisions in that database).

That’s all.

This post is for the WordPress Bloggers, who want to elimination the redundancy of data in the WordPress Database.

As most of the bloggers know that WordPress internally saves each revision as a different post. Means if someone writes a post, and modifies it 10 times, then that particular post will be saved at 11 separate places, which is really annoying for the people who don’t want to keep all revisions, instead they just want to modify the post without making duplicates of that post.

So, here is the solution to get rid of the Post revisions in wordpress.

1. Go to your web file-system of wordpress, after logging in with your FTP username and password.

2. Right click on the wp-config.php file and then click on Edit option. (If Edit option is not available, then copy that wp-config.php file to your computer and open it in notepad.)

3. Now go to the last line of the page, and place

define('WP_POST_REVISIONS', false);

before the ?> php closing tag.

4. Save and overwrite it with the old wp-config.php file.

Now onwards, this particular wordpress installation will not save the revisions whenever you modify any post.

Click here to know How to delete the existing Post Revisions in WordPress.

We all need secondary or additional drives on our computer to manage the data easily. For example, we can divide our hard disk into 4 partitions: C-Drive for Windows, D-drive for Media, E-drive for Software and F-drive for keeping all Documents.

There are a number of ways, by which you can easily manage the partitions on your hard-disk.

One of such tool is provided free with the Windows 7 – Windows 7 Disk Management System:

1. Go to Windows Search Box, type Disk Management and you’ll see an option by the name Create and Format hard disk partitions, click on it.

2. Now perform a right click onto the primary partition (e.g. C-Drive) and hit the Shrink Volume option.

3. After a few moments, a screen will prompt to enter size to shrink the C-drive (Depending upon the size of your C-drive). Just enter the required size, and click the Shrink button.

4. Now do the right click on that newly created partition, and hit the New Simple Volume option. This option will take you to a wizard, after completing which, your new partition gets ready to use.