資料庫備份匯出成.sql.gz

mysqldump -uroot -p [databasename] | gzip > [databasename].sql.gz

資料庫匯入 (Linux)  (要先解壓縮)

mysql -u [username] -p [database_name] < dumpfilename.sql

資料庫匯入 (Linux)  (不需先解壓縮)

gunzip < [databasename].sql.gz | mysql -uroot -p [databasename]

資料庫匯入 (Mac)

gunzip < [databasename].sql.gz | /usr/local/mysql/bin/mysql -uroot -p [databasename]

從本機上傳資料到遠端主機

scp -P [port] [yourfilename].tar.gz username@foo.com:/path/to/

從遠端主機下載資料到本機

scp username@foo.com:/path/to/[yourfilename].sql.gz /yourlocal/path/to/

資料打包壓縮

tar -zcvf [yourfilename].tar.gz [yourfoldername]

資料解壓縮

tar -zxvf [yourfilename].tar.gz

One thought on “系統維護常用的Linux指令

  1. Whoa! This really is one of the most helpful things on the matter I have ever found. Many thanks for your work.
    http://husek.cba.pl/?p=818
    https://coutoeuliana.com/2017/12/28/cheap-works-you-can-aquire-low-cost-article/
    http://icpd.web.ua.pt/index.php/2018/01/06/shop-for-documents-of-top-quality-shell-out/
    http://www.landmarksd.com/required-education-varies-from-some-web-design/
    https://democratsforunity.com/obtain-dissertation-on-the-web-professional/
    http://bofl.se/2017/12/27/obtain-essay-online-and-get-a-level/
    http://www.bronzart.nz/2017/12/the-paper-concludes-with-an-evaluation-of/
    http://ciitngo.org/authoring-documents-for-money-all-of-us-create/
    http://gsoft.edic.pt/creating-records-for-profit-people-create-essays/
    http://info-sphere.de/2017/11/20/purdue-owl-currently-talking-about-novels/
    http://www.siam2learn.com/customized-dissertation-crafting-support-very-best/
    http://ganb.com/term-paper-writing-service-for-student/
    http://www.gclglazing.co.uk/write-my-article-web-based-posting-solution-by/
    http://aamarbangla.in/beginning-with-innovative-dissertation-post-titles/
    http://footandankle-bh.com/put-together-my-own-paper-co-custom-made-structure/
    http://chalotaxi.co.in/get-investigation-papers-regarding-excellent/
    http://dreitan-dentaldoctor.co.il/2017/12/19/employ-the-service-of-some-sort-of-article-writer/
    http://creditfixer.uk/specialized-on-line-report-authoring-service/
    http://blog.vidaao.com/structuring-a-real-thesis-launch-research-of-style/
    http://kensingtonthaiterrace.co.uk/demand-for-pro-dissertation-experts/
    http://studie.michaelpage.se/professional-teaching-aid-from-phd-clone-writers/
    http://edusolidarity.us/?p=5061
    http://reseau-de-pret.info/2017/12/08/this-several-section-essay/
    http://www.12healthylife.com/2017/11/28/beginner-ii-level-is-for-students-who-have-had-at/
    http://www.cathinc.com/?p=3379
    http://www.mauricemarshaltrust.org/good-essay-writing-websites/you-can-find-articles-published-for-you-by-way-of/
    http://hukukarastirmavakfi.com/essay-tool-require-assistance-crafting-a/
    http://808entertainment.ca/?p=3233
    http://www.cuccuvaia.com/blog/perfect-personalized-composition-ever-before-try/
    http://www.ryanogline.dk/?p=1398
    http://www.lialianblog.com/2017/12/29/cheap-custom-crafting-want-to-conclude-analysis/
    http://nhomducsaigon.com/13-methods-to-constructing-any-research-report/
    http://archiv.trans-urban.de/under-section-232-of-the-trade-expansion-act-the/
    http://www.makaronzserem.eu/2018/01/28/high-quality-personalized-report-help-pertaining/
    http://restaurant-sleutelgat.be/essay-writing-aid-on-the-net/
    http://www.dekhoghar.com/?p=149
    http://demo.cms-theme.net/wordpress/brando/essay-writing-online-program-custom-paper-writing/
    http://princesseswithatwist.com/one-of-a-kind-essays-1234-help-me-documents-an-on/
    http://samaaknews.com/151912/be-wise-go-with-purchasing-essays-online-you-have/
    http://david-cohen.us/?p=4348
    http://archiv.trans-urban.de/best-dissertation-making-offerings/
    http://www.tripacificmarketing.com.au/do-my-homework-for-me-•-on-the-net-homework-23/
    http://www.logiservice.com.br/essay-or-dissertation-structure-and-description/
    http://www.healthandhealingclinic.net/you-can-receive-articles-penned-for-yourself-by/
    http://www.oxfordshire-builders.co.uk/essay-assistance-on-line-creating-expert-services/
    http://expokmi2017.polnep.ac.id/you-will-get-works-authored-available-for-you-by/
    http://www.shamrohomeremodeling.com/made-to-order-essay-or-dissertation-penning/
    http://www.trincalimmobilier.com/archives/26588
    http://oblak.site/2018/03/02/pay-for-dissertation/
    https://www.thestayfit.com/2018/03/22/finest-essay-writing-service-evaluations-of-2018/
    https://enlaspetrolube.co.za/2017/12/03/use-a-skilled-for-bachelor-s-dissertation/
    http://cofrex-eg.com/2018/01/17/find-out-what-you-can-do-with-your-degree-in-sport/
    http://caja-ahorros.es/order-preparation-studies-world-wide-web-15percent.html
    http://ksdiamonds.net/online-essay-writing-service-you-can-still-trust/
    http://jksaventureros.com/2017/11/28/purdue-owl-homework-newspapers/
    http://coloradoyoungleaders.org/principal-custom-investigate-report-on-line/
    https://ict-essl.pt/2018/01/11/get-report-reports-on-the-net/
    http://iqubeonline.com/low-cost-made-to-order-posting-service-to-close/
    http://101.255.40.202/2018/02/03/in-the-process-of-writing-the-bachelor-thesis-it/
    http://davaoaguilasfc.com/be-able-to-write-abstract-regarding-investigate/page/123/
    http://www.beirutyacht.com/index.php/2017/11/15/master-s-degree-programs-in-leisure-studies-will/
    http://henosistech.com/baby-progression-training-programmes-check-out-a/
    http://www.orgetech.com/?p=1797
    http://www.nlts.co.uk/custom-made-report-composing-program-perfect/
    http://polweld-urban.com/customized-researching-report-composing-company/
    https://edmperu.com/essay-editor/achieve-the-preparation-personally-to-math/
    http://jadimocreations.com/3339.html
    http://solar-water-heater.us/?p=5255
    http://feinbergmusic.com/information-technology-classes-support/
    http://www.one21designs.co.uk/essay-writing-solutions-from-us/write-the-article-in-my-situation-guide-i-would/
    http://sightline.ae/en/purchase-a-narrative-paper/
    http://estrategas.online/2017/11/09/analysis-cardstock-publishing-provider/
    http://www.siga.cnt.br/jot-down-the-essay-on-line-for-cheap-purchase/
    http://fazalevents.com/2017/12/14/grasp-ohydrates-dissertation-specialized/
    http://www.howtoanimation.com/my-essaytyper/
    http://www.alano.in/?p=1735
    http://www.bairesciudad.com.ar/buy-college-or-university-papers-web-based-as-a/
    http://www.holdingcamera.it/study-newspaper-creating-service-top-rated/
    http://kgbikers.com/obtain-caregiving-educational-forms-on-the-web/
    http://www.blackpresident.us/index.php/2018/03/16/publishing-lab-assessments-as-well-as/
    http://stream-live.cba.pl/archiwa/4010
    https://treblemengineering.com/master-of-arts-dissertation-instances-native/
    http://baybytoys.com/custom-clinical-article-crafting-service-buy-on/
    http://www.kohilavk.ee/crafting-research-laboratory-studies-scientific/
    http://elikrasnitsbio.awake.co.il/2017/12/09/short-article-writing-services/
    http://www.ladynelsonchildcare.com/any-instructions-intended-for-writers-involving
    http://simplefilms.com/2018/02/dissertation-publishing-products-britain-request/
    http://hattynaylor.co.uk/invest-in-paper-on-the-web-skilled-educative
    http://bovo-tighe.com/college-or-university-syllabus-kindspros-write-for/
    http://kosmetyczka-koscierzyna.pl/who-could-assist-to-write-down-my-own-personal/
    http://www.przegladpowszechny.pl/2018/01/08/get-hold-of-a-account-essay/
    http://www.olsys-mediaweb.fr/exactly-what-ph/
    https://kindredcommodities.com/2017/12/09/new-trends-in-power-electronics-for-the/
    https://ondategui.com/2017/12/17/hurry-up-to-find-up-to-date-qualified-hormone/
    http://marlaska.com/?p=4378
    http://blog.thebigwordproject.com/2017/12/27/the-custom-creating-provider-via-finest-essay-or/
    http://hbidr.com/2017/12/buy-a-strong-article-on-line-for-reasonable-24/
    http://www.doggen-vom-sallenbusch.de/2017/11/admission-essay-samples-statement-of-objective/
    http://vlaw.org/free-plagiarism-checker-for-college-students-on/
    https://bpsmijatim.org/2016/06/26/get-the-best-essay-writing-assistance-from-genuine/

Leave a reply

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> 

required