Trick to shorten MySQL error message

The steps provided here are only for Linux, If you are using some other OS then use respective editor and commands.

MySQL stores error message file at /usr/share/mysql/english/errmsg.sys where english is the language you want to use.

Note:You need to have super user privileges

Step 1. Take backup of existing errmsg.sys (so that you can revert if some problem occured

$sudo cp /usr/share/mysql/english/errmsg.sys ~/errmsg.sys.bkp

Step 2. Open /usr/share/mysql/english/errmsg.sys in vi editor.

$sudo vi /usr/share/mysql/english/errmsg.sys

Step 3. Search for "You have an" in errmsg.sys

in vi editor for searching try this way-->  /You have an [press enter]

It will get you to the string "You have an error...." as show in screen-shot 

Step 4. Edit that error message as per your need. I've deleted string You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the and kept just right syntax to use

Refer below screen-shot. 

Step 5. Save and Exit.

in vi editor to save and exit-->   :x! [press enter]     here ! is added to override read-only file

Step 6. Restart mysql service.

$sudo mysql restart

step 7. check error message (I'm checking in phpMyAdmin)

Top 10 Linux distributions for Server

You know that Linux is a hot data center server. You know that it saves you money in licensing and maintenance costs. But, what are your options for Linux as a server operating system? Listed here are the top ten Linux server distributions -- some of which you may not be aware. The following chararistics, in no particular order, qualified a distribution for inclusion in this list: Ease-of-use, available commercial support and data center reliability.
Rated: The Top 10 Linux server distributions by ease of use, paid support, and data center reliability.
1. Ubuntu - At the top of almost every Linux-related list, Debian-based Ubuntu is in a class by itself. It surpasses all other distributions from its simple installation to its excellent hardware discovery to its world-class commercial support; Ubuntu leaves the others fumbling in the dusty distance.
2. Red Hat - Red Hat Enterprise Linux (RHEL) started out as the "little Linux company that could" and is now a major force in the quest for data center rackspace. The Linux darling of large companies throughout the world, Red Hat's innovations and non-stop support will have you coming back for more.
3. SUSE - Novell-owned SUSE Linux is stable, easy-to-maintain and offers Novell's 24x7 rapid-response support for those who don't have the time or patience for lengthy troubleshooting calls. And, Novell's consulting teams will have you meeting your SLAs and making your accountants happy to boot.
4. Mandriva - For U.S.-based executive or technical folks, Mandriva might be a bit foreign. This incredibly well-constructed Linux distibution hails from France and claims extreme acceptance in Europe and South America. It is, as its website claims, a worldwide Linux provider. Its name and its construction derive from the Mandrake Linux and Connectiva Linux distributions.
5. Xandros - If you prefer a Linux distribution with a Microsoft connection, Xandros is the one for you. Rumors aside, Xandros and Microsoft collaborate in what's known in technical circles as "cooperatition." This means that they compete cooperatively. To find out more about this unique perspective, check out the Xandros About page.
6. Slackware - While not generally associated with commercial distributions, Slackware maintains relationships with several companies that provide fee-based support. One of the earliest available distributions, Slackware has an extensive and faithful fan base. Its developers regularly release new versions.
7. Debian - If you're confused by Debian's inclusion here, don't be. Debian doesn't have formal commercial support but you can connect with Debian-savvy consultants around the world via their Consultants page. Debian has spawned more child distributions than any other parent distribution including Ubuntu, Linux Mint and Vyatta.
8. Vyatta - Vyatta is more at home on routers and firewalls than PC-based systems but if you want a commercially-driven distribution for those applications, Vyatta works well for your secure communications needs. Check out the free version of Vyatta Linux.
9. CentOS - It's true that CentOS isn't strictly commercial but since it's based on Red Hat Enterprise Linux, you can leverage commercial support for it. CentOS has its own repositories and community support and is not the same as Fedora Linux.
10. Unbreakable Linux - Oracle's Unbreakable Linux is Red Hat Enterprise Linux with some Oracle logos and art. Oracle competes directly with Red Hat with their distribution and quite effectively, since purchased support through Oracle is half the price of Red Hat's equivalent model.

Difference Between Linux and UNIX

UNIX is copyrighted name only big companies are allowed to use the UNIX copyright and name, so IBM AIX and Sun Solaris and HP-UX all are UNIX operating systems. The Open Group holds the UNIX trademark in trust for the industry, and manages the UNIX trademark licensing program.

Most UNIX systems are commercial in nature.

Linux is a UNIX Clone

But if you consider Portable Operating System Interface (POSIX) standards then Linux can be considered as UNIX. To quote from Official Linux kernel README file:

Linux is a Unix clone written from scratch by Linus Torvalds with assistance from a loosely-knit team of hackers across the Net. It aims towards POSIX compliance.

However, "Open Group" do not approve of the construction "Unix-like", and consider it misuse of their UNIX trademark.

Linux Is Just a Kernel

Linux is just a kernel. All Linux distributions includes GUI system + GNU utilities (such as cp, mv, ls,date, bash etc) + installation & management tools + GNU c/c++ Compilers + Editors (vi) + and various applications (such as OpenOffice, Firefox). However, most UNIX operating systems are considered as a complete operating system as everything come from a single source or vendor.
As I said earlier Linux is just a kernel and Linux distribution makes it complete usable operating systems by adding various applications. Most UNIX operating systems comes with A-Z programs such as editor, compilers etc. For example HP-UX or Solaris comes with A-Z programs.

License and cost

Linux is Free (as in beer [freedom]). You can download it from the Internet or redistribute it under GNU licenses. You will see the best community support for Linux. Most UNIX like operating systems are not free (but this is changing fast, for example OpenSolaris UNIX). However, some Linux distributions such as Redhat / Novell provides additional Linux support, consultancy, bug fixing, and training for additional fees.

User-Friendly

Linux is considered as most user friendly UNIX like operating systems. It makes it easy to install sound card, flash players, and other desktop goodies. However, Apple OS X is most popular UNIX operating system for desktop usage.

Security Firewall Software

Linux comes with open source netfilter/iptables based firewall tool to protect your server and desktop from the crackers and hackers. UNIX operating systems comes with its own firewall product (for example Solaris UNIX comes with ipfilter based firewall) or you need to purchase a 3rd party software such as Checkpoint UNIX firewall.

Backup and Recovery Software

UNIX and Linux comes with different set of tools for backing up data to tape and other backup media. However, both of them share some common tools such as tar, dump/restore, and cpio etc.

File Systems

• Linux by default supports and use ext3 or ext4 file systems.
• UNIX comes with various file systems such as jfs, gpfs (AIX), jfs, gpfs (HP-UX), jfs, gpfs (Solaris).

System Administration Tools

1. UNIX comes with its own tools such as SAM on HP-UX.
2. Suse Linux comes with Yast
3. Redhat Linux comes with its own gui tools called redhat-config-*.

However, editing text config file and typing commands are most popular options for sys admin work under UNIX and Linux.

System Startup Scripts

Almost every version of UNIX and Linux comes with system initialization script but they are located in different directories:

1. HP-UX - /sbin/init.d
2. AIX - /etc/rc.d/init.d
3. Linux - /etc/init.d

End User Perspective

The differences are not that big for the average end user. They will use the same shell (e.g. bash or ksh) and other development tools such as Perl or Eclipse development tool.

System Administrator Perspective

Again, the differences are not that big for the system administrator. However, you may notice various differences while performing the following operations:

1. Software installation procedure
2. Hardware device names
3. Various admin commands or utilities
4. Software RAID devices and mirroring
5. Logical volume management
6. Package management
7. Patch management

UNIX Operating System Names

A few popular names:

1. HP-UX
2. IBM AIX
3. Sun Solairs
4. Mac OS X
5. IRIX

Linux Distribution (Operating System) Names

A few popular names:

1. Redhat Enterprise Linux
2. Fedora Linux
3. Debian Linux
4. Suse Enterprise Linux
5. Ubuntu Linux

Common Things Between Linux & UNIX

Both share many common applications such as:

1. GUI, file, and windows managers (KDE, Gnome)
2. Shells (ksh, csh, bash)
3. Various office applications such as OpenOffice.org
4. Development tools (perl, php, python, GNU c/c++ compilers)

UNIX and Linux Hardware

Commercial UNIX hardware has more advanced initial boot options such as:

• Decide how to boot
• Check system health
• Set hardware parameters etc

The BIOS that is standard in PCs which is used by Linux has few, of these features. UNIX hardware or servers are pretty expensive as compare to Linux server systems.

Further readings:

Following documents or URL should help anyone to get more idea:

• UNIX System Management and Security: Differences between Linux, Solaris, AIX and HP-UX
• 40 years of Unix

 

Latest Linux Version : BackBox Linux 2.01 released

The BackBox team is proud to announce the release 2.01 of BackBox Linux.The new release include features such as Ubuntu 11.04, Linux Kernel 2.6.38 and Xfce 4.8.0. The ISO images (32bit & 64bit) can be downloaded from the following location: http://www.backbox.org/downloads
What's new

• System upgrade
• Performance boost
• New look
• Improved start menu

Bug corrections

• New sections such as Forensic Analysis, Documentation & Reporting and Reverse Engineering
• New Hacking tools and updated tools such as dradis 2.8, ettercap 0.7.4.2, john 1.7.8, metasploit 4.2, nmap 5.51, set 2.5.2, sleuthkit 3.2.1, w3af 1.0, weevely 0.5, wireshark 1.6.3, etc.

System requirements

• 32-bit or 64-bit processor
• 256 MB of system memory (RAM)
• 4.4 GB of disk space for installation
• Graphics card capable of 800×600 resolution
• DVD-ROM drive or USB port

Ubuntu Inside Windows... Portable Ubuntu

hey.. friends.. i have found one latest portable version of Ubuntu...

which can be runs inside windows... so.. you don't have to Restart your pc and switch from Windows to Ubuntu..
with the use of this "Portable Ubuntu" u can run any Ubuntu applications (Terminal/Shell, Firefox, etc)..
for more information about use..
portable-ubuntu-runs-ubuntu-inside-windows

you can directly download from here.... Download Portable Ubuntu (438 MB)

Linux Shell on windows platform (Supports only Basic Commands)

Download
kvGroup_LINUX Shell on Windows (BASIC LINUX COMMANDS).exe (19 MB)

*This version Supports only Basic Linux commands... it doesn't provide facility to ShellScript.. it doesn't provide VI Editor..

Redhat Linux Shell FULL version (Windows Platform)

this is the full version... you need to download only this... and then install it...

kvGroup_RedHat_on Windows.exe

===========================
Installation Steps.....
===========================
1. After download this kvGroup_RedHat_on Windows.exe (119 MB) >> Extranct to your HDD
2. Then run rhsetup.exe and click on Next button
3. Then Select 3rd option i.e. Install From Local Directory.
4. Then write the root directory location to where you want to install Linux Shell. then click on Next button.
5. Then brows Local Package directory where you extract thiese installation files.
6. then select option "Curr" for most Recommonded packages installation... and click on Next button.
7. After all Extractation and installation completed run...  "Cygwin.bat" file from your root directory (set in Step#4)

Install Redhat LINUX Shell on Windows platform

here is the link to Download Redhat LINUX Shell....

this version also includes VI editor to write shell scripts...

===========================
Installation Steps.....
===========================
1. After download this rhsetup.exe (1.5MB) run it.
2. Then click on next button
3. Then Select 1st option i.e. Install From Internet.
4. Then write the root directory location to where you want to install Linux Shell. then click on Next button.
5. Then write Local Package directory to store downloaded files.
6. Then select your Internet connection type.
7. After some time it will show you Avilable download sites...
8. click on Next button in will find packages to install
9. then select option "Curr" for most Recommonded packages installation... and click on Next button.
10. After all downloads and installation completed run...  "Cygwin.bat" file from your root directory (set in Step#4)

cheer$$$$$...!!!!!

you have done installation... now Njoy the Linux commands on your windows platform....

(soooon we will uploads full version of this Application i.e. 115MB)...