Archive for September, 2010

ls command options

Sep-10th-2010

ls command :-  you use it 10 times a day or 100 times a day, see the power of  ls command. Name ls – list directory contents Syntax ls [-a] [-A] [-b] [-c] [-C] [-d] [-f] [-F] [-g] [-i] [-l] [-L] [-m] [-o] [-p] [-q] [-r] [-R] [-s] [t] [-u] [-x] [pathnames] -a :    [...]

What is MYI, MYD and FRM in mysql

Sep-10th-2010

Hi, Mysql data stores into /var/lib/mysql directory. Here is the content of a folder containing a database : root@map007 [/var/lib/mysql]# ls -l cphulkd/ total 348 drwx——  2 mysql mysql   4096 Sep  8 21:37 ./ drwxr-x–x 85 mysql mysql   4096 Sep  8 08:05 ../ -rw-rw—-  1 mysql mysql   8590 Feb 28  2010 auths.frm -rw-rw—-  1 mysql [...]