LinuxÎļþÄÚÈݲéѯÃüÁת£©
grep¡¢fgrepºÍegrepÃüÁî
Õâ×éÃüÁîÒÔÖ¸¶¨Ä£Ê½ËÑË÷Îļþ£¬²¢Í¨ÖªÓû§ÔÚʲôÎļþÖÐËÑË÷µ½ÓëÖ¸¶¨µÄģʽƥÅäµÄ×Ö·û´®£¬²¢´òÓ¡³öËùÓаüº¬¸Ã×Ö·û´®µÄÎı¾ÐУ¬ÔÚ¸ÃÎı¾ÐеÄ×îÇ°ÃæÊǸÃÐÐËùÔÚ µÄÎļþÃû¡£grepÃüÁîÒ»´ÎÖ»ÄÜËÑË÷Ò»¸öÖ¸¶¨µÄģʽ£»egrepÃüÁî¼ìË÷À©Õ¹µÄÕýÔò±í´ïʽ£¨°üÀ¨±í´ïʽ×éºÍ¿ÉÑ¡Ï£»fgrepÃüÁî¼ìË÷¹Ì¶¨×Ö·û´®£¬Ëü²» ʶ±ðÕýÔò±í´ïʽ£¬ÊÇ¿ìËÙËÑË÷ÃüÁî¡£
Õâ×éÃüÁîÔÚËÑË÷Ó붨λÎļþÖÐÌض¨µÄÖ÷Ìâ·½Ãæ·Ç³£ÓÐÓá£ÒªËÑË÷µÄģʽ¿ÉÒÔ±»ÈÏΪÊÇһЩ¹Ø¼ü´Ê£¬Äú¿ÉÒÔÓÃËüÃÇÀ´ËÑË÷ÎļþÖаüº¬µÄÕâЩ¹Ø¼ü´Ê¡£±àд³ÌÐòʱ£¬¿ÉÒÔ ÓÃËüÀ´Ñ°ÕÒijһ¸öº¯Êý£¬»òÊÇÏà¹ØµÄ´Ê×é¡£grepÃüÁîµÄËÑË÷¹¦ÄܱÈfgrepÇ¿´ó£¬ÒòΪgrepÃüÁîµÄËÑË÷ģʽ¿ÉÒÔÊÇÕýÔò±í´ïʽ£¬¶øfgrepÈ´²»ÄÜ¡£ÓÐ ¹ØÕýÔò±í´ïʽÇë²Î¼ûshellÒ»Õ¡£
¸Ã×éÃüÁîÖеÄÿһ¸öÃüÁÓÐÒ»×éÑ¡ÏÀûÓÃÕâЩѡÏî¿ÉÒԸıäÆäÊä³ö·½Ê½¡£ÀýÈ磬¿ÉÒÔÔÚËÑË÷µ½µÄÎı¾ÐÐÉϼÓÈëÐкţ¬»òÕßÖ»Êä³öÎı¾ÐеÄÐкţ¬»òÕßÊä³öËùÓÐÓëËÑË÷ģʽ²»Æ¥ÅäµÄÎı¾ÐУ¬»òÖ»¼òµ¥µØÊä³öÒÑËÑË÷µ½Ö¸¶¨Ä£Ê½µÄÎļþÃû£¬²¢ÇÒ¿ÉÒÔÖ¸¶¨ÔÚ²éÕÒģʽʱºöÂÔ´óСд¡£
Õâ×éÃüÁîÔÚÖ¸¶¨µÄÊäÈëÎļþÖвéÕÒÓëģʽƥÅäµÄÐС£Èç¹ûûÓÐÖ¸¶¨Îļþ£¬Ôò´Ó±ê×¼ÊäÈëÖжÁÈ¡¡£Õý³£Çé¿öÏ£¬Ã¿¸öÆ¥ÅäµÄÐб»ÏÔʾµ½±ê×¼Êä³ö¡£Èç¹ûÒª²éÕÒµÄÎļþÊǶà¸ö£¬ÔòÔÚÿһÐÐÊä³ö֮ǰ¼ÓÉÏÎļþÃû¡£
Óï·¨£º
grep £ÛÑ¡Ïî£Ý £Û²éÕÒģʽ£Ý £ÛÎļþÃû1£¬ÎļþÃû2£¬……£Ý
egrep £ÛÑ¡Ïî£Ý £Û²éÕÒģʽ£Ý £ÛÎļþÃû1£¬ÎļþÃû2£¬……£Ý
fgrep £ÛÑ¡Ïî£Ý £Û²éÕÒģʽ£Ý £ÛÎļþÃû1£¬ÎļþÃû2£¬……£Ý
Õâ×éÃüÁî¸÷Ñ¡ÏîµÄº¬ÒåΪ£º
- E ÿ¸öģʽ×÷Ϊһ¸öÀ©Õ¹µÄÕýÔò±í´ïʽ¶Ô´ý¡£
- F ÿ¸öģʽ×÷Ϊһ×é¹Ì¶¨×Ö·û´®¶Ô´ý£¨ÒÔÐÂÐзָô£©£¬¶ø²»×÷ΪÕýÔò±í´ïʽ¡£
- bÔÚÊä³öµÄÿһÐÐÇ°ÏÔʾ°üº¬Æ¥Åä×Ö·û´®µÄÐÐÔÚÎļþÖеÄ×Ö½ÚÆ«ÒÆÁ¿¡£
- c Ö»ÏÔʾƥÅäÐеÄÊýÁ¿¡£
- i ±È½Ïʱ²»Çø·Ö´óСд¡£
- h ÔÚ²éÕÒ¶à¸öÎļþʱ£¬Ö¸Ê¾grep²»Òª½«ÎļþÃû¼ÓÈëµ½Êä³ö֮ǰ¡£
- l ÏÔʾÊ×´ÎÆ¥Åä´®ËùÔÚµÄÎļþÃû²¢Óû»Ðзû½«Æä¸ô¿ª¡£µ±ÔÚijÎļþÖжà´Î³öÏÖÆ¥Å䴮ʱ£¬²»Öظ´ÏÔʾ´ËÎļþÃû¡£
- n ÔÚÊä³öÇ°¼ÓÉÏÆ¥Åä´®ËùÔÚÐеÄÐкţ¨ÎļþÊ×ÐÐÐкÅΪ1£©¡£
- v Ö»ÏÔʾ²»°üº¬Æ¥Åä´®µÄÐС£
- x Ö»ÏÔʾÕûÐÐÑϸñÆ¥ÅäµÄÐС£
- e expression Ö¸¶¨¼ìË÷ʹÓõÄģʽ¡£ÓÃÓÚ·ÀÖ¹ÒÔ“-”¿ªÍ·µÄģʽ±»½âÊÍΪÃüÁîÑ¡Ïî¡£
- f expfile ´ÓexpfileÎļþÖлñÈ¡ÒªËÑË÷µÄģʽ£¬Ò»¸öģʽռһÐС£
¶Ô¸Ã×éÃüÁîµÄ
Ïà¹ØÎĵµ£º
MySQL :: Linux ÏÂ×Ô¶¯±¸·ÝÊý¾Ý¿âµÄ shell ½Å±¾
Linux ·þÎñÆ÷ÉϵijÌÐòÿÌ춼ÔÚ¸üРMySQL Êý¾Ý¿â£¬ÓÚÊǾÍÏëÆðдһ¸ö shell ½Å±¾£¬½áºÏ crontab£¬¶¨Ê±±¸·ÝÊý¾Ý¿â¡£Æäʵ·Ç³£¼òµ¥£¬Ö÷Òª¾ÍÊÇʹÓà MySQL ×Ô´øµÄ mysqldump ÃüÁî¡£
½Å±¾ÄÚÈÝÈçÏ£º
#!/bin/sh
# File: /home/mysql/backup.sh
# Database info
DB_NAME=" ......
¿ÉÒÔ½«Õâ¸ö½Å±¾·Å½øcrontab£¬ËûµÄÅäÖÆÎļþÔÚ /etc/crontabÖÐÿÌìÁ賿ִÐÐÒ»´Î£¬×Ô¶¯±¸·Ý Õâ¸ö½Å±¾Ã¿Ìì×î¶àÖ»Ö´ÐÐÒ»´Î£¬¶øÇÒÖ»±£Áô×î½üÎåÌìµÄ±¸·ÝÔÚ·þÎñÆ÷ÉÏ¡£
#!/bin/bash
#This is a ShellScript For Auto DB Backup
#Powered by aspbiz
#2004-09
#Setting
#ÉèÖÃÊý¾Ý¿âÃû£¬Êý¾Ý¿âµÇ¼Ãû£¬ÃÜÂ룬±¸·Ý·¾¶£¬ÈÕ־ ......
¡¡Ò»¡¢ÒýÑÔ
¡¡¡¡ÏëʹÓÃLinuxÒѾºÜ³¤Ê±¼äÁË£¬ÓÉÓÚûÓÐÓ²ÐÔÈÎÎñһֱҲûÓÐϵͳѧϰ£¬½üÈÕÓÉÓÚ¹¤×÷ÐèÒª±ØÐëʹÓÃLinuxϵÄMySQL¡£±¾ÒÔΪÓÐ
WindowsÏÂʹÓÃSQL
ServerµÄ¾Ñ飬¾õµÃÔÚLinuxÏ°²×°MySqlÓ¦¸ÃÊÇÒ×Èç·´ÕƵÄÊ£¬¿ÉÔÚÕæÕý°²×°ºÍʹÓÃMySQLʱ×ßÁ˺ܶàÍä·£¬Óö¼ûºÜ¶àÎÊÌ⣬±Ï¾¹Linux
ºÍWindows±¾Éí¾ÍÓкܴóÇø±ð¡£ÎªÁËÈà ......
Æô¶¯mysql: /etc/rc.d/init.d/mysql start
ÐÞ¸ÄÃÜÂë: ¸ñʽ£ºmysqladmin -uÓû§Ãû -p¾ÉÃÜÂë password ÐÂÃÜÂë
ʹÓÃÃÜÂëµÇ¼: mysql -u root -p
ÏÔʾÊý¾Ý¿â: show databases;
Ñ¡ÔñÊý¾Ý¿â: use Êý¾Ý¿âÃû;
ÏÔʾ±í: show tables;
ÏÔʾ±í½á¹¹: descibe ±íÃû;
Ô¶³ÌµÇ¼mysqlÐèÒª¿ªÆôÈ ......
ÔÚLinux»·¾³ÏÂÊäÈë: cd /usr/openv/netbackup/bin/admincmd/
./bpexpdate -m ´Å´ø±êÇ©Ãû(media ID) -d 0 ±íʾ¶ÔÕâÅÌ´Å´øµÄÊý¾ÝÇå¿Õ,Èç´Å´ø½éÖʱ£´æÖÜÆÚÊÇÓÀ¾ÃµÄ,
Ò²»áÈ«²¿Çå¿Õ,ʹËü¹ýÆ ......