Monthly Archives: August 2007

Import data into table from a file

Very useful feature of mysql:

CREATE TEMPORARY TABLE table1(id int);

LOAD DATA LOCAL INFILE '/dir/file' INTO TABLE table1

Synergy config

Create a text file named synergy.conf with the following:

section: screens
screen1:
screen2:
end
section: links
screen1:
right = screen2
screen2:
left = screen1
end

In the above example, screen2 is to the right of screen1 and screen1 is to the left of screen2.

To run a server type the command below in a shell. If synergys is not in your PATH then use the full pathname.

synergys -f --config synergy.conf

To start a client enter the following:

synergyc -f server-host-name

Running ntp manually

If you want to synchronize your clock manually with NTP server just run:

/usr/sbin/ntpdate -v uk.pool.ntp.org

List of public NTP servers you can find here