This can be done with plugins, there might be such plugins. But you can aldo do it with one simple sql query.

update your_wp_prefix_term_relationships set 
(select term_taxonomy_id from your_wp_prefix_term_taxonomy where term_id=_ID_NEW_) 
(select term_taxonomy_id from your_wp_prefix_term_taxonomy where term_id=_ID_OLD_)

This mysql code is for mysql editors of course.
Running this code via php:

update $wpdb->term_relationships set 
(select term_taxonomy_id from $wpdb->term_taxonomy where term_id=_ID_NEW_) 
(select term_taxonomy_id from $wpdb->term_taxonomy where term_id=_ID_OLD_)

Let’s say that you have new server and you have copied all files from there, but you have forgotten to export mysql database. And old server no longer exists. I did this mistake 2-3 times when i migrated to a new computer.:) So, what to do? How to restore mysql tables from files?
If you have full file backup, you should have mysql databases’ files, which have FRM extensions. Search and find them.
In Linux they are in /var/lib/mysql. So
1. Copy ALL folders and files from /var/lib/mysql and paste them into /var/lib/mysql of new server.
2. It will not work immeditially. After pasting you should do mysql restart with folloing command in terminal:
sudo service mysql restart
That’s all.

Day by day new vendors introduces their own cloud storages, and offers more and more free spaces.

Google Drive, Dropbox, Copy, Mega, Yandex Disk, cloud, Microsoft SkyDrive, Sugar Synch etc..

But which of them supports Linux family OS-es? Which of them has native app for Linux? Let’s list 5 of them:

  1. Dropbox
    The most popular Cloud Storage Service. Has enough good Linux app. (offers 2 GB up to 18 GB free storage)
  2.  Copy
    New and powerful Cloud Service. Offers 15 GB free disk

  3. Cloud

    Russian service, offers 10 GB free space (up to 100 GB!)
  4. Ubuntu One
    download (1)
    Offers 5 GB, up to 20 GB free space
  5. Wuala
    Offers 5 GB free storage

I would like to share some screenshots from my smartphone, which i have used with Smart Launcher since i bought Nexus 4. In previous Android smartphones i used traditional launchers such as Trebuchet, Touchwiz, Sense, Nova, Go Launcher etc. Each of them has its own unique features, but all of them are traditional, home screens with horizontal slides, and menu with same slide. To be open i got bored with same effects and i hadn’t been able to optimize my home screen to satisfy me. I did experiments every day, reorganizing screens, folders etc. Then i heard about Launcher 7 and Launcher 8 which is copy of Windows Phone 7-8 Metro UI solution. And i used both of them. First days i liked them, but then i felt that it is too primitive solution for smartphone, and with using it you can not feel your device is smartphone. I realized that i need space in homescreen, space+icons. Metro could not give it. When i switched to Nexus 4, in play store i discovered smart launcher, and from that day i have been using it with great pleasure.(>3 monthes)  It has nearly everything what i need. No horizontal slides in home screen and menu screen, smart categories to access apps easily, widgets screen. But it also had some limitations in some features. But coming updates solved it soon.

I am sharing some screenshots from my Nexus 4 with Smart Launcher Pro.

1. This is home screen. Only one screen, and flower circle for apps.

2013-05-12 12.22.10

2. This is apps menu. With fully customizable smart categories 

2013-05-12 12.22.19

Continue reading

It is no secret that Google Chrome is the fastest browser. But it has one big problem: high RAM usage. Another browsers runs in OS as a single process. But Chrome is different. Each Chrome tab runs in OS as different process. So, sum of such process usages equals to high index.

For example, today i tested my Chrome RAM usage with 12-15 open tabs. Result was 1.5 GB. Considering that average users’ pc RAM < 4 GB, then 1.5 GB is extra high.


Tab which has some work in background, tab with flash, tab with huge html data etc use a lot of memory. Of course closing such tabs is straight solution. But closing is not effective way as we want to keep some tabs open. (I always keep open Evernote app, Gmail, Google+, Feedly app)

So we have to look for 3rd party solutions. I have tested 2 of them. 1st dissatisfied, 2nd satisfied.

1. First one – Tabmemfree

This extension can automatically suspend inactive tabs. We can set inactivity time, except pinned tabs. But we can not create white list, and this is main problem of this extension.

2. Second one – The Great Suspender

This extension has everything you need: Manual suspend, automatically suspend, setting inactivity time, creating white list. So i use this extension.

Screenshot from 2013-03-28 11:51:40

If you have further recommendations about this topic, please put comment below.