Tag Archives: to

How to unlock files on Windows 7

Leave a reply

It may happen that you are running several applications writing/reading on several files, then for example, you want to delete one of those files and you cannot because file is being used.

On Linux systems it allows you to know which application is using it, and close it. With Windows 7 (and Windows XP) you need to use a third-party software called Unlocker.

Using Unlocker is quite easy. When it is installed, it appears as an option in your context menu, so you just have to right click on the file and select Unlocker

Unlocker
Unlocker

You can download Unlocker from here

Short and useful tip: How to make “tail -f” beep on each new line.

Leave a reply

Just in case you do not know, tail prints the last ten lines of the indicated file. Like this:

tail /var/log/yum.log

Furthermore, if you want to print more lines you can do it with -n parameter:

tail -n 20 /var/log/yum.log

But I think the most interesting parameter for tail  is -f. This parameter allows tail to “follow” the file. New data is displayed as the file grows.

Now, using sed  we can append to each new line, a bell sound:

tail -f /var/log/yum.log | sed -e $'s/$/\a/'

Notice that ‘$’ escape sequences will only work on bash.

This was tested on Fedora 16.

How to install MySQL 5.1 on Ubuntu

Leave a reply

 

# apt-get install mysql-client-5.1 mysql-client-core-5.1 mysql-common mysql-server-5.1 mysql-server-core-5.1 mysql-admin mysql-gui-tools-common mysql-query-browser

With this packages we install mysql client, mysql server and some administration tools.

Packages to install

Packages to install

Later, we will be asked to set up a root password:

Asking for root password

Asking for root password

Be sure to remember that password.

Once it is installed we can run MySQL Administrator to manage our recently installed server.

MySQL Administrator Connection

MySQL Administrator Connection

It’s highly recommended to create other user to work

Creating a new user

Creating a new user

With MySQL Administrator you also can manage backups or check server’s health for example.

And finally, with MySQL Query Browser you can que to your server; create new databases, insert values, sql queries, etc.

Creating a new database with Query Browser

Creating a new database with Query Browser