Linux commands: Difference between revisions

From LemonWiki共筆
Jump to navigation Jump to search
Line 112: Line 112:
== mysql operation ==
== mysql operation ==
=== export MySql sql file ===
=== export MySql sql file ===
* {{Gd}} export the compressed *.sql file (especially for BIG sql file). It will show a progress bar and estimated time to complete the mysqldump<ref>[http://dba.stackexchange.com/questions/17367/how-can-i-monitor-the-progress-of-an-import-of-a-large-sql-file mysql - How can I monitor the progress of an import of a large .sql file? - Database Administrators Stack Exchange]</ref>:  
* {{Gd}} export the compressed *.sql file (especially for BIG sql file). It will show a progress bar and estimated time to complete the mysqldump<ref>[http://dba.stackexchange.com/questions/17367/how-can-i-monitor-the-progress-of-an-import-of-a-large-sql-file mysql - How can I monitor the progress of an import of a large .sql file? - Database Administrators Stack Exchange]</ref><ref>[https://dev.mysql.com/doc/refman/5.1/en/mysqldump.html MySQL :: MySQL 5.1 Reference Manual :: 4.5.4 mysqldump — A Database Backup Program]</ref>:  
*# (optional if the {{kbd | key =pv}} was not installed) {{kbd | key =yum install pv}} for RHEL / CentOS / SL / Fedora Linux<ref>[http://www.cyberciti.biz/open-source/command-line-hacks/pv-command-examples/ Linux / Unix pv Command: Monitor Progress of Data Sent Via a Pipe]</ref>
*# (optional if the {{kbd | key =pv}} was not installed) {{kbd | key =yum install pv}} for RHEL / CentOS / SL / Fedora Linux<ref>[http://www.cyberciti.biz/open-source/command-line-hacks/pv-command-examples/ Linux / Unix pv Command: Monitor Progress of Data Sent Via a Pipe]</ref>
*# (for InnoDB tables){{kbd | key =  <nowiki>mysqldump -h localhost -u username -p --single-transaction DATA_BASE_NAME | pv | gzip -c > database.sql.gz</nowiki>}} <ref>[http://journal.andrewloe.com/2009/05/12/pv-gzip-mysql/ pv + gzip + mysql — W. Andrew Loe III: Journal]</ref><ref>(if have permission to LOCK TABLES){{kbd | key =  <nowiki>mysqldump -h localhost -u username -p DATA_BASE_NAME | pv | gzip -c > database.sql.gz</nowiki>}} (if have no permission to LOCK TABLES){{kbd | key =  <nowiki>mysqldump -h localhost -u username -p --lock-tables=false DATA_BASE_NAME | pv | gzip -c > database.sql.gz</nowiki>}} via [http://stackoverflow.com/questions/104612/run-mysqldump-without-locking-tables mysql - Run MySQLDump without Locking Tables - Stack Overflow]</ref> and press {{kbd | key =  <nowiki>Enter</nowiki> }}
*# (for InnoDB tables){{kbd | key =  <nowiki>mysqldump -h localhost -u username -p --force --single-transaction DATA_BASE_NAME | pv | gzip -c > database.sql.gz</nowiki>}} <ref>[http://journal.andrewloe.com/2009/05/12/pv-gzip-mysql/ pv + gzip + mysql — W. Andrew Loe III: Journal]</ref><ref>(if have permission to LOCK TABLES){{kbd | key =  <nowiki>mysqldump -h localhost -u username -p DATA_BASE_NAME | pv | gzip -c > database.sql.gz</nowiki>}} (if have no permission to LOCK TABLES){{kbd | key =  <nowiki>mysqldump -h localhost -u username -p --lock-tables=false DATA_BASE_NAME | pv | gzip -c > database.sql.gz</nowiki>}} via [http://stackoverflow.com/questions/104612/run-mysqldump-without-locking-tables mysql - Run MySQLDump without Locking Tables - Stack Overflow]</ref> and press {{kbd | key =  <nowiki>Enter</nowiki> }}
*# enter {{kbd | key =  <nowiki>password</nowiki> }} and press {{kbd | key =  <nowiki>Enter</nowiki> }}
*# enter {{kbd | key =  <nowiki>password</nowiki> }} and press {{kbd | key =  <nowiki>Enter</nowiki> }}


* export the *.sql file. It will show a progress bar and estimated time to complete the mysqldump <ref>[http://dubbs.github.io/blog/2013/09/05/mysql-import-slash-export-progress-bar/ MySQL Import/Export Progress Bar - Kevin Warrington]</ref>:  
* export the *.sql file. It will show a progress bar and estimated time to complete the mysqldump <ref>[http://dubbs.github.io/blog/2013/09/05/mysql-import-slash-export-progress-bar/ MySQL Import/Export Progress Bar - Kevin Warrington]</ref>:  
*# (optional if the {{kbd | key =pv}} was not installed) {{kbd | key =yum install pv}} for RHEL / CentOS / SL / Fedora Linux
*# (optional if the {{kbd | key =pv}} was not installed) {{kbd | key =yum install pv}} for RHEL / CentOS / SL / Fedora Linux
*# (for InnoDB tables){{kbd | key =  <nowiki>mysqldump -h localhost -u username -p --single-transaction DATA_BASE_NAME | pv > database.sql</nowiki>}}  and press {{kbd | key =  <nowiki>Enter</nowiki> }}
*# (for InnoDB tables){{kbd | key =  <nowiki>mysqldump -h localhost -u username -p --force --single-transaction DATA_BASE_NAME | pv > database.sql</nowiki>}}  and press {{kbd | key =  <nowiki>Enter</nowiki> }}
*# enter {{kbd | key =  <nowiki>password</nowiki> }} and press {{kbd | key =  <nowiki>Enter</nowiki> }}
*# enter {{kbd | key =  <nowiki>password</nowiki> }} and press {{kbd | key =  <nowiki>Enter</nowiki> }}
* export the *.sql file
* export the *.sql file

Revision as of 09:53, 13 March 2014

(1) alternative Linux commands to complete the same task, (2) The equivalent or similar commands between Windows and Linux system.

Owl icon.jpg Help for command:
(Linux Os linux.png ) Type command --help or man command  ;
(Win Os windows.png ) Type command /?

text file manipulation

display the first lines of text file

  • head [options] filename (OS: Linux Os linux.png )
  • vi [options] filename (and press gg) (Linux Os linux.png )
  • vim [options] filename (and press gg) (Linux Os linux.png ); Open file and press gg for gVim (Win Os windows.png )

display the last few lines of text file

  • tail [options] filename (Linux Os linux.png )
  • vi [options] filename (and press G) (Linux Os linux.png )
  • vim [options] filename (and press G) (Linux Os linux.png ); Open file and press G for gVim (Win Os windows.png )
  • Tail for Win32 GUI interface (Win Os windows.png ) Icon_exclaim.gif not support Unicode file for v.4.2.6

Display the full text file

  • vi [options] filename (Linux Os linux.png )
  • cat filename (Linux Os linux.png )

Save a Unix manpage as plain text

Search text in a file

  • grep command for multiple files: grep -ir "string to search" /path/to/directory or grep keyword /path/to/file (Linux Os linux.png )
  • (1)vim [options] filename (2)press /keyword (Linux Os linux.png )
  • cat & grep: cat /path/to/file | grep keyword (Linux Os linux.png ) keyword is case sensitive

Search text in files[1]

file operation

find a file

  • find (Linux Os linux.png ) ex: find / -iname filename Find the case-insensitive file name Under the path / (root folder) [2]
  • dir (Win Os windows.png ) ex: dir /s filename [3][4] Icon_exclaim.gif I have no idea to specify the file path to find the file.

copy old directory to new directory

  • cp -a old_dir new_dir/ (Linux Os linux.png )
  • copy /Y old_dir new_dir/ (Win Os windows.png )[5]
  • make new directory & copy all old files to new directory
    • mkdir new_dir
    • cp old_dir/* new_dir

download file from remote server

  • FTP
  • wget (with progress bar): wget http://path.to/file
  • SVN update: svn up http://remote.svn.server/path/ /local/path/ --username=your_account and key in your SVN password [6]
  • more on File transfer methods

delete files or directory

  • rm -rf /Name_of_directory (Linux Os linux.png )[7]
  • del Name_of_directory (Win Os windows.png )
    • After executed del Name_of_directory but the empty directory directory_name will be left.
    • Command delete is not available in Win XP
  • rsync --delete-before -a -H -v --progress --stats /path/to/empty/folder/ /path/to/target_folder_will_be_deleted/ (Linux Os linux.png )[8] un-verified

rename (move) files or directory

  • mv old_folder_name new_folder_name (Linux Os linux.png )[9]
  • mv /path/to/file /path/to/new_folder_name (Linux Os linux.png )
  • rename old_folder_name new_folder_name (Win Os windows.png )[10]

list directory or files / list directory contents

  • ls (Linux Os linux.png ) ex: ls -lh List detailed information of files [11] [12]
  • dir (Win Os windows.png ) ex: dir/s/b is equal to Linux Os linux.png find /path/to/files/ -print [13]

show the current directory

  • pwd(Linux Os linux.png )
  • echo %cd%(Win Os windows.png ) [14]

file compression and decompression

compress

  • pv big.file | gzip > big.file.gz(Linux Os linux.png )[15] keep the original file
  • gzip -v big.file(Linux Os linux.png ) NOT keep the original file

decompress

  • gunzip -c big.file.gz > big.file(Linux Os linux.png ) keep the gz file[16]
  • gzip -d big.file.gz(Linux Os linux.png ) NOT keep the gz file

network

show ip

  • ifconfig (Linux Os linux.png )[17][18]
  • ipconfig/all (Win Os windows.png )

ping Icon_exclaim.gif You may got no response if the server was disabled the ICMP (Internet Control Message Protocol) response.

  • ping domain_or_ip (Linux Os linux.png )
  • ping domain_or_ip -t (Win Os windows.png )

whois: search the information of domain (related: Domain Name Register)

apache operation

check apache servie is running or not

  • service --status-all | grep -i httpd (Linux Os linux.png [19][20])
  • netstat -npl | grep httpd for Linux Os linux.png [21]
  • netstat -an | find /i "listening" (Win Os windows.png ) find the local open ports & find local address TCP 0.0.0.0:80 is listening[22]
  • more on connection test...

Where is apache installed?[23]

  • cat /etc/rc.d/rc.local if the apache service is already launched

check which mpm (multi processing module) apache is running

  • httpd -l (Linux Os linux.png & Win Os windows.png ) ex: Linux Os linux.png /usr/local/httpd/bin/httpd -l or Win Os windows.png x:\apache\bin>httpd -l where x:\apache is the installation folder of apache [24]

mysql operation

export MySql sql file

  • Good.gif export the compressed *.sql file (especially for BIG sql file). It will show a progress bar and estimated time to complete the mysqldump[25][26]:
    1. (optional if the pv was not installed) yum install pv for RHEL / CentOS / SL / Fedora Linux[27]
    2. (for InnoDB tables)mysqldump -h localhost -u username -p --force --single-transaction DATA_BASE_NAME | pv | gzip -c > database.sql.gz [28][29] and press Enter
    3. enter password and press Enter
  • export the *.sql file. It will show a progress bar and estimated time to complete the mysqldump [30]:
    1. (optional if the pv was not installed) yum install pv for RHEL / CentOS / SL / Fedora Linux
    2. (for InnoDB tables)mysqldump -h localhost -u username -p --force --single-transaction DATA_BASE_NAME | pv > database.sql and press Enter
    3. enter password and press Enter
  • export the *.sql file
    1. mysqldump -h localhost -u username -p DATA-BASE-NAME > /path/to/database.sql

import MySql sql file

Icon_exclaim.gif Notice: existing database will be overwritten

  • Good.gif Import the compressed *.sql file with gzip (especially for BIG sql file). It will show a progress bar and estimated time to complete the mysql command:
    1. (optional if the pv was not installed) yum install pv for RHEL / CentOS / SL / Fedora Linux
    2. pv database.sql.gz | gunzip | mysql -u username -p -h localhost DATA-BASE-NAME [31] and press Enter
    3. enter password and press Enter
  • Import *.sql file:
    1. (optional if the .sql file was compressed) unzip data.zip or gzip -d data.gz if the file was compressed by gzip
    2. mysql -u username -p -h localhost DATA-BASE-NAME < data.sql [32] and press Enter
    3. enter password and press Enter
  • Import the *.sql file (especially for BIG sql file). It will show a progress bar and estimated time to complete the mysql command[33]:
    1. (optional if the pv was not installed) yum install pv for RHEL / CentOS / SL / Fedora Linux
    2. pv data.sql | mysql -u username -p -h localhost DATA-BASE-NAME [34] and press Enter
    3. enter password and press Enter
  • Import ZIP file to MySql directly:
    1. (optional if the 7Zip was not installed) yum install p7zip
    2. 7za x -so data.zip | mysql -u username -p -h localhost DATA-BASE-NAME [35][36] and press Enter
    3. enter password and press Enter

system operation

show current time

  • date (Linux Os linux.png ) output: Thu Oct 25 15:05:10 CST 2012 [37]
  • date/t (Win Os windows.png )
output:
OS in English: Thu 05/03/2012
OS in Chinese: 2012/05/03 星期四

specify the location where Linux or MS-DOS looks when using a command

reboot the system/server

  • reboot (Linux Os linux.png )[39]
  • shutdown -r (Win Os windows.png )[40]

OS version

  • lsb_release -a (Linux Os linux.png )[41]
  • ver (Win Os windows.png )[42]

Search text of command output

  • linux command | grep string (Linux Os linux.png ) ex: keyin yum list installed | grep tar to search the installed package naming tar.[43]
  • Windows command | find "string" (Win Os windows.png ) ex: netstat -a | find "3306" (note: enclose string in double quotation marks)[44]

help for command

view the documentation for this command

  • command --help or man command (Linux Os linux.png )
  • command /? (Win Os windows.png )

emergency exit

  • ctrl+c or ctrl+break (Linux Os linux.png & Win Os windows.png )
  • Pause/Break (Linux Os linux.png ) ex: I pressed the key to leave from the warning message "Vim: Warning: Output is not to a terminal".

references

  1. ↑ 鳥哥的 Linux 私房菜 -- 學習 bash shell
  2. ↑ Find command: how to ignore case? - Unix and Linux; Find the case-sensitive file name Under the path / (root folder) ex: find / -name filename ref:Tips For Linux - How to find files in Linux using 'find'
  3. ↑ How to find a file in MS-DOS.
  4. ↑ /S 顯示指定目錄及所有子目錄中的檔案。 (引用自 dir /? 命令說明)
  5. ↑ /Y 不顯示覆寫現存目的檔案的確認提示。 (引用自 copy /? 命令說明)
  6. ↑ using the www account su - www -c "svn up http://remote.svn.server/path/ /local/path/ --username=your_account --password=xxx"
  7. ↑ [OPTION]
    • -r remove directories and their contents recursively;
    • -f ignore nonexistent files, never prompt
    (above content cited from linux documentation: rm --help)
  8. ↑ Linux下使用rsync最快速删除海量文件的方法_果冻的剥壳_新浪博客
  9. ↑ Linux Rename Files, Folders or Directories
  10. ↑ MS-DOS ren and rename command help
  11. ↑ 鳥哥的 Linux 私房菜 -- Linux 的檔案權限與目錄配置
  12. ↑ [OPTION]
    • -l use a long listing format
    • -h, --human-readable; with -l, print sizes in human readable format (e.g., 1K 234M 2G) Quoted from linux man ls
  13. ↑ linux - Making ls output like dir /b /s - Super User
  14. ↑ Windows equivilent to UNIX pwd - Stack Overflow
  15. ↑ A Unix Utility You Should Know About: Pipe Viewer - good coders code, great reuse
  16. ↑ linux - How do you gunzip a file and keep the .gz file? - Super User
  17. ↑ 鳥哥的 Linux 私房菜 -- Linux 常用網路指令介紹
  18. ↑ bash: ifconfig: command not found 無法使用ifconfig指令？ 先加上 su -l指令
  19. ↑ Red Hat / CentOS: Check / List Running Services
  20. ↑ -i means ignore caseHow to use the grep command, by The Linux Information Project (LINFO)
  21. ↑ Linux / UNIX Find Out What Program / Service is Listening on a Specific TCP Port
  22. ↑ Netstat
  23. ↑ Enabling and disabling services during start up in GNU/Linux | All about Linux
  24. ↑ Check which mpm (multi processing module) apache is running | Binary Tides
  25. ↑ mysql - How can I monitor the progress of an import of a large .sql file? - Database Administrators Stack Exchange
  26. ↑ MySQL :: MySQL 5.1 Reference Manual :: 4.5.4 mysqldump — A Database Backup Program
  27. ↑ Linux / Unix pv Command: Monitor Progress of Data Sent Via a Pipe
  28. ↑ pv + gzip + mysql — W. Andrew Loe III: Journal
  29. ↑ (if have permission to LOCK TABLES)mysqldump -h localhost -u username -p DATA_BASE_NAME | pv | gzip -c > database.sql.gz (if have no permission to LOCK TABLES)mysqldump -h localhost -u username -p --lock-tables=false DATA_BASE_NAME | pv | gzip -c > database.sql.gz via mysql - Run MySQLDump without Locking Tables - Stack Overflow
  30. ↑ MySQL Import/Export Progress Bar - Kevin Warrington
  31. ↑ pv + gzip + mysql — W. Andrew Loe III: Journal
  32. ↑ Import MySQL Dumpfile, SQL Datafile Into My Database
  33. ↑ mysql - How can I monitor the progress of an import of a large .sql file? - Database Administrators Stack Exchange
  34. ↑ Import MySQL Dumpfile, SQL Datafile Into My Database
  35. ↑ database - Importing zipped files in Mysql using command line - Stack Overflow
  36. ↑ Install 7Zip on CentOS 5.5
  37. ↑ 鳥哥的 Linux 私房菜 -- NTP 時間伺服器
  38. ↑ 鳥哥的 Linux 私房菜 -- 檔案與目錄管理 -- 關於執行檔路徑的變數： $PATH
  39. ↑ reboot - Linux Command - Unix Command
  40. ↑ Windows原來也有內建好用的關機軟體(Shutdown.exe) | ㊣軟體玩家
  41. ↑ The Will Will Web | 如何查詢 Linux 的種類與版本 ( Linux Standard Base )
  42. ↑ Find windows OS version from command line
  43. ↑ Unix/Linux grep command examples | grep command in Unix and Linux | grep examples | alvinalexander.com
  44. ↑ Microsoft Windows XP - Find

further reading

Retrieved from "https://wiki.planetoid.info/index.php?title=Linux_commands&oldid=13488"