Archive | Tips and Tricks RSS feed for this section

Folders Sync

26 May

0325-sync-folder-thumb-100029454-large This may not be a problem for many people but folder syncing can be an issue, especially if you are like me, who has work spread out over at least three computers; one at home, one at the office, and a mobile computer (laptop/tablet/phablet). This is not to mention the syncing of work to online resources like Dropbox, Google Drive and Microsoft’s OneDrive (formerly known as SkyDrive before an injuction by Sky Media in the UK put an end to that – Microsoft should fire the guy who came up with that name as clearly they have no research capabilities) – so that should one by any chance not be at one of their computers but has access to an online machine, they can still get access to their work.

I scoured the web searching for useful solutions to this conundrum and here are the applications I have ended up installing on my computers – in a bid to keep my folders up to date most of the time.

Continue reading

Install RPM with dependencies via CLI in openSUSE

15 Apr

So…this is most likely something trivial to many people, but I found myself googling this the last time I tried to install Skype on my office PC. So, should you not know or have forgotten how to install and RPM with dependencies in openSUSE, here are two ways that work like magic

Method 1 – Yast

The command to run is simple – and this works with the assumption that you have yast-ncurses installed to make yast work well in the command like interface

yast –i /path/to/your-package.rpm

This will refresh your configured repositories, resolve dependencies (if possible), confirm to you what is about to be installed, and then install them with a nice cli interface so to speak.

NB: With Yast, you can choose to browse the repositories for other things to install or update.

Method 2 – Zypper

The command to run is as follows

zypper in /path/to/your-package.rpm

This will refresh your repositories, resolve your dependencies (if possible), confirm to you what is to be installed, and then install them via a simple cli interface – not as complex as yast.

Memory issue with mysqld.exe in MySQL 5.6

8 Apr

If you have installed WAMP server or MySQL 5.6, you might have ended with memory issue with mysqld.exe process consuming huge RAM memory of around 400MB!

The problem can be solved by following the simple procedure below:

  1. Stop MySQL service if it is running.
  2. Open the file  my.ini which is found in “C:wampbinmysqlmysql5.6.xx” folder. [The actual path may vary depending upon the installation directory.]
  3. Add the following line: table_definition_cache = 400
  4. Save the file and start the MySQL.

NB: This also applies when you have installed MySQL 5.6 or other release alone.

Now open Task Manager and look at mysqld.exe process. It will be around 100MB or less.

Tips and Tricks Section of the Site…

8 Apr

From time to time, I come across small tips and tricks that are useful but really do not warrant a full blog post. Thus the birth of the tips and tricks section of this site. Hoe you all find it useful over time. Stand by for the first tip!