14,959
edits
Linux commands: Difference between revisions
Jump to navigation
Jump to search
m
→mysql operation
| Line 91: | Line 91: | ||
import mysql sql dump file | import mysql sql dump file | ||
* import *.sql file: {{kbd | key = <nowiki>mysql -u username -p -h localhost DATA-BASE-NAME < data.sql</nowiki> }}<ref>[http://www.cyberciti.biz/faq/import-mysql-dumpfile-sql-datafile-into-my-database/ Import MySQL Dumpfile, SQL Datafile Into My Database]</ref> | * import *.sql file: {{kbd | key = <nowiki>mysql -u username -p -h localhost DATA-BASE-NAME < data.sql</nowiki> }}<ref>[http://www.cyberciti.biz/faq/import-mysql-dumpfile-sql-datafile-into-my-database/ Import MySQL Dumpfile, SQL Datafile Into My Database]</ref> | ||
* import *.zip file: {{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> | * import *.zip file: {{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> | ||
== system operation == | == system operation == | ||