December 29, 2009

How To set the timezone in FreeBSD OS

Linux/Windows Support,

Copy from /usr/share/zoneinfo/Etc or /usr/share/zoneinfo/<continent>/<city>, the timezone, that coresponds to your city/GMT setting to /etc/localtime Once the timezone is set in the FreeBSD server, run the command: adjkerntz -a (adjut kernel timezone). How To set the timezone in FreeBSD OS 슠

Read more
December 26, 2009

Converting MySQL query results into a CSV file

Database,

To dump data from the database into an Excel file, SELECT query 슠can be used to convert data to CSV formatting. Converting MySQL query results into a CSV file All needs to be done is to identify how the fields and lines should be terminated. For example, to dump a table named customers to a…

Read more
December 26, 2009

How to change the client prompt in MySQL?

Database,

Change MySQL’s prompt by using the prompt command: mysql>prompt mysql (\d)> Once executed, the currently selected database will appear in the prompt, like so: mysql (mydatabase)> It’s also easy to lose track of which database server you’re logged in to, not to mention which account you’re using. To fix this, modify your prompt using the…

Read more
December 26, 2009

Linux modules and libraries

Linux General,

Dynamically linked libraries are linked and loaded at run time, either by “ld.so” or “ld-linux.so”, depending on how it was compiled: in a.out or ELF format. Every program whenever they need a library, look through a known list of places to find the needed library. One place they look is “/etc/ld.so.cache”, which contains an ordered…

Read more
December 26, 2009

RPM – RedHat Package Manager

Linux General,

What does a RPM Package contain? RPMs (*.rpm) typically include 1) the compiled programs and/or libraries needed for the package, 2) documentation 3) install, verify, and uninstall scripts 4) cryptographic signatures for each file in the package. This makes it easy to verify the integrity of the package. 5) It also includes a list of…

Read more