No products in the cart.
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 September 16, 2009
Run Database Servers Optimally
Linux/Windows Support,Optimize Database Server Performance for Peak Efficiency Now, to ensure your systems are functioning at peak efficiency, you should run the database server optimally by following the procedures outlined below. – kernel.shmmax=268435456 for 32-bit – kernel.shmmax=1073741824 for 64-bit – kernel.msgmni=1024- fs.file-max=8192 – kernel.sem=”250 32000 32 1024″ Shared Memory Shared Memory To view current settings, run…
Read more September 16, 2009
Linux Security Tools
Linux General,In this page i will try to provide some of the must have tools for linux OS. Some of these tools can also be used for FreeBsd: ROOT KIT HUNTERS: Installation how to * CHKROOTKIT * RKHUNTER * ROOTCHECK @RootCheck: You can download the rootcheck latest version from the following URL: http://www.ossec.net/rootcheck/files/ Installation how to:…
Read more September 16, 2009
Exim Command line arguments
Linux General,Exim Command line arguments The command options are described in alphabetical order below. — This is a pseudo-option whose only purpose is to terminate the options and therefore to cause subsequent command line items to be treated as arguments rather than options, even if they begin with hyphens. -B This is a Sendmail option for…
Read more September 16, 2009
New File System
Linux/Windows Support,New Filesystem Development Under Process: Ext4 Evolution Explained It’s great to hear about exciting progress in Linux filesystem development! Theodore Ts’o, a leading Linux kernel developer, recently shared an insightful overview of the upcoming changes to the ext3 filesystem and the path toward ext4. Community Involvement in Filesystem Development Theodore Ts’o emphasized that many developers…
Read more September 16, 2009
Disk Quota Management
Linux/Windows Support,Managing Disk Quotas in Linux As long as you have your own system and are the only user, you can use any amount of disk space without restriction. However, because Linux primarily supports multiple users, you may need to set limits on how much disk space each user can consume. In this guide, you’ll learn…
Read more September 16, 2009
Kernel 2.6 features
Linux/Windows Support,It was in January 2001, almost five years ago, when the previous Linux operating system kernel 2.4 was released. At that time, the version introduced kernel support for ISA Plug-and-Play, USB, and PC Card technologies. Since then, the Linux community has continued to evolve rapidly. However, in December last year, the new Linux kernel 2.6…
Read more