14,959
edits
Linux commands: Difference between revisions
Jump to navigation
Jump to search
→mysql operation
| Line 150: | Line 150: | ||
*# {{kbd | key = <nowiki>7za x -so data.zip | mysql -u username -p -h localhost DATA_BASE_NAME</nowiki>}} <ref>[http://stackoverflow.com/questions/11267309/importing-zipped-files-in-mysql-using-command-line database - Importing zipped files in Mysql using command line - Stack Overflow]</ref><ref>[http://needs-be.blogspot.tw/2011/01/install-7zip-on-centos-55.html Install 7Zip on CentOS 5.5]</ref> and press {{kbd | key = <nowiki>Enter</nowiki> }} | *# {{kbd | key = <nowiki>7za x -so data.zip | mysql -u username -p -h localhost DATA_BASE_NAME</nowiki>}} <ref>[http://stackoverflow.com/questions/11267309/importing-zipped-files-in-mysql-using-command-line database - Importing zipped files in Mysql using command line - Stack Overflow]</ref><ref>[http://needs-be.blogspot.tw/2011/01/install-7zip-on-centos-55.html Install 7Zip on CentOS 5.5]</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> }} | ||
=== Show the MySQL process list & kill the process === | |||
Show the MySQL process list & kill the process<ref>[http://dev.mysql.com/doc/refman/5.1/en/show-processlist.html MySQL :: MySQL 5.1 Reference Manual :: 13.7.5.31 SHOW PROCESSLIST Syntax]</ref> | |||
# {{kbd | key=mysql -h HOST -u ACCOUNT -p }} And keyin the PASSWORD for your MySQL ACCOUNT to connect the MySQL server. | |||
# {{kbd | key=SHOW FULL PROCESSLIST\G}} to show the process list | |||
# {{kbd | key=kill 101}} to kill the process with Id number: 101 | |||
== system operation == | == system operation == | ||