Cloud storage is everywhere these days. Cloud Backup has become somewhat of a fad. But the good news is that cloud storage is actually useful. You can save a lot of time and money by utilizing cloud storage for both business and personal use. But there are plenty of ways to use cloud backup services in addition to simply storing data in the cloud. Let's take a look at 10 ways you can use virtual backup services creatively.
[Read more…]

Here’s the shortcut keys to collapse all and expand all code folds in eclipse.

Collapse All: CTRL + SHIFT + NUM_PAD_DIVIDE (/)
Expand All: CTRL + SHIFT + NUM_PAD_MULTIPLE (*)

Note that both uses the divide(/) and multiply(*).

They are not the same as “the / which share the same key with ?” and “the * which you can get with shift+8

The MySQL replace syntax is pretty simple to use. For example, let’s say using wordpress and you would like to replace all post titles with 2013-2014 to 2014-2015, you can simply use the following SQL syntax:

UPDATE wp_posts SET post_title = REPLACE(post_title,’2013-2014′,’2014-2015′)

More examples, such as searching and replacing text in the post_content column

UPDATE wp_posts SET post_content = REPLACE(post_content,”width:500px; height:500px;”,”width:740px; height:900px;”)

UPDATE wp_posts SET post_content = REPLACE(post_content,’text\’>www.’,’text\’>http://www.’)

Note that the REPLACE function performs a case-sensitive match when searching.

So let’s say post_title is “OLD POST title” and we would like to update that to “new post title”

This won’t work as there’s no exact match of “old post”

UPDATE wp_posts SET post_title = REPLACE(post_title,’old post’,’new post’)

Do this instead

UPDATE wp_posts SET post_title = REPLACE(post_title,’OLD POST’,’new post’)

While working on a project to read and write mp3 id3 tags using Perl’s MP3 Tag module, I found out that I was getting this error:

Software error:
Writing of ID3v2.4 is not fully supported (prohibited now via `write_v24′).
For help, please send mail to the webmaster, giving this error message and the time and date of the error.

[Read more…]