Time is important on servers, especially mission-critical ones. You, as system administrator have to make sure that the time on all of your servers is correct. You can use NTP to sync time on your ser…
(more...)
Run command prompt is a place from where users can initiate most system integrated programs. For example, if users want to open Notepad they just need to type ‘Notepad’ in the Run command prompt and p…
(more...)
■ Operations <With a keyboard key> F7: shows your command prompt history in a small window. Tab: Autocomplete feature like Linux <With a mouse> Right clicking → P: pastes data quickly. Dra…
(more...)
Syntax update (table name) set (column name) = replace(column name,’search string’,'replacement’); Example Remove all the half-width/full-width spaces from a table. update test_table set column1 = rep…
(more...)
[Backup with mysqldump] # mysqldump –default-character-set=latin1 -u root -p dbname > /home/ backup.sql I specified “latin1″ as the default character set because the default environmen…
(more...)
Use “mysql> show variables;” or “mysql> status;” to check your MySQL settings. mysql> status mysql Ver 14.12 Distrib 5.0.27, for redhat-linux-gnu (i686) using readline…
(more...)
Warning If you force quit the process while a file is being written, it may damage the data or adversely affect its integrity. Command Note that “process” here means that of MySQL, not the OS. KILL &l…
(more...)
Command Installation command # yum -y install php-pear Confirmation of installation # pear -V PEAR Version: 1.9.4 … Error message If you have mistyped “pear” for “php-pear”, an error message appears…
(more...)
The following command allows non-root users to check the Linux version/release information. $ cat etc`ls etc -F grep release$version$` The following reasons explain why the above command gives the ver…
(more...)
Steps 1. In a command prompt window, enter the following command to show the process IDs of services that use ports. netstat -a -o or in the the Search Programs and Files box, run: cmd /k netstat -a -…
(more...)
In Linux, files/directories which begin with a dot (e.g. “.svn”, “.hg”) are hidden. Is command does not show them as it is; you need to specify options as suggested below. Commands Shows a list of all…
(more...)
Symbolic links point to files and folders. Let’s say you log in and are now at /home/user. /var/www/html is far from your current location and you may think it is a pain to access by specifying …
(more...)
