Ungawakhipha kanjani amafayela wedatha kusuka ku-Linux MySQL database?thekelisa umyalo wesitatimende se-csv

Linux MySQL databaseIndlela yokuthekelisa amafayela edatha?thekelisa umyalo wesitatimende se-csv

MySQLthekelisa idatha yedatha

Ku-MySQL ungasebenzisaKHETHA ... NGENXA YEMPAHLAisitatimende sokumane ukhiphe idatha kufayela lombhalo.

Khipha idatha usebenzisa isitatimende esithi KHETHA ... INTO OUTFILE

Esibonelweni esilandelayo sizothekelisa ithebula ledatha kufayela /tmp/tutorials.txt:

mysql > SELECT * FROM chenweiliang_tbl 
     - > INTO OUTFILE '/tmp/tutorials.txt' ;

Ungasetha ifomethi eshiwo yokuphuma kwedatha ngokusebenzisa izinketho zomyalo. Isibonelo esilandelayo esokuthekelisa ifomethi ye-CSV:

mysql > SELECT * FROM passwd INTO OUTFILE '/tmp/tutorials.csv' - > FIELDS TERMINATED BY '，' ENCLOSED BY ''' - > LINES TERMINATED BY '\ r \ n' ;
    
    

Esibonelweni esilandelayo, ifayela likhiqizwa amanani ahlukaniswe ngokhefana.Le fomethi ingasetshenziswa izinhlelo eziningi.

SELECT a ，b ，a + b INTO OUTFILE '/tmp/result.text'FIELDS 
TERMINATED BY '，' OPTIONALLY ENCLOSED BY '''行
终止'\ 
n'FROM test_table ;

Isitatimende esithi KHETHA ... INTO OUTFILE sinezibaluli ezilandelayo:

• LAYISHA IDATHA I-INFILE wukusebenza okuphambene kokuthi KHETHA ... KU-OUTFILE, KHETHA i-syntax.Ukuze ubhale idatha usuka kusizindalwazi uye efayeleni, sebenzisa KHETHA ... KU-OUTFILE, futhi ukuze ufunde ifayela emuva kusizindalwazi, sebenzisa LOAD DATA INFILE.
• KHETHA ... KWI-OUTFILE UKUKHETHA kwefomu elithi 'file_name' kungabhala imigqa ekhethiwe efayeleni.Ifayela lakhiwe kumsingathi weseva, ngakho kufanele ube nemvume ye-FILE ukuze usebenzise le syntax.
• Okukhiphayo akukwazi ukuba ifayela elikhona.Vimbela idatha yefayela ukuthi ingaphazanyiswa.
• Ingabe udinga ukuba ne-akhawunti ukuze ungene kuseva ukuze ubuyise amafayela.Uma kungenjalo KHETHA ... INTO OUTFILE ngeke ibe nomphumela.
• Ku-UNIX, ifayela lidalelwa ukuthi lifundeke, futhi izimvume ziphethwe iseva ye-MySQL.Lokhu kusho ukuthi ngenkathi ufunda ifayela, ungase ungakwazi ukulisusa.

Khipha ithebula njengedatha eluhlaza

Ikhiqiza ikakhulukazi umbhalo we-SQL oqukethe imiyalo DALA ITHEBULA FAKA njll. edingekayo ukuze udale kabusha isizindalwazi kusukela ekuqaleni.

Ukuze uthumele idatha usebenzisa i-mysqldump, udinga ukusebenzisa inketho ye--tab ukuze ucacise uhla lwemibhalo olucaciswe yifayela lokuthekelisa, futhi okuhlosiwe kufanele kubhaleke.

Isibonelo esilandelayo sithumela ithebula ledatha elithi chenweiliang_tbl kumkhombandlela we-/tmp:

$ mysqldump - u root - p - no - create - info
             - tab = / tmp chenweiliang chenweiliang_tbl
密码******

Khipha idatha ngefomethi ye-SQL

Khipha idatha ngefomethi ye-SQL kufayela elishiwo, kanje:

$ mysqldump - u root - p chenweiliang chenweiliang_tbl > dump 。文本 
密码******

Okuqukethwe kwefayela elidalwe yilo myalo ongenhla kungokulandelayo:

- MySQL 转储8.23 - - 主机：localhost     数据库：chenweiliang
 ----------------------------------- ---------------------- - 服务器版本        3.23 。58   

 
 

- - 表结构为表`chenweiliang_tbl` -
 


CREATE TABLE chenweiliang_tbl （
  chenweiliang_id INT （11 ）NOT NULL的auto_increment ，
  chenweiliang_title VARCHAR （100 ）NOT NULL 默认'' ，
  chenweiliang_author VARCHAR （40 ）NOT NULL 默认'' ，
  submission_date日期默认NULL ，
  PRIMARY KEY   （chenweiliang_id ），
  UNIQUE KEY AUTHOR_INDEX （chenweiliang_author ））TYPE = MyISAM ;  


- - 转储数据的表`chenweiliang_tbl` -
 


INSERT INTO chenweiliang_tbl 
       VALUES （1 ，'Learn PHP' ，'John Poul' ，'2007-05-24' ）;
INSERT INTO chenweiliang_tbl 
       VALUES （2 ，'学习MySQL' ，'Abdul S' ，'2007-05-24' ）;
INSERT INTO chenweiliang_tbl 
       VALUES （3 ，'JAVA Tutorial' ，'Sanjay' ，'2007-05-06' ）;

Uma udinga ukuthekelisa idatha yayo yonke imininingwane egciniwe, ungasebenzisa umyalo olandelayo:

$ mysqldump - u root - p chenweiliang > database_dump 。文本
密码******

Uma udinga ukwenza ikhophi yasenqolobaneni yonke imininingwane yolwazi, ungasebenzisa umyalo olandelayo:

$ mysqldump - u root - p - all - databases > database_dump 。文本
密码******

Inketho --all-databases yengezwe ku-MySQL 3.23.12 nakamuva.

Le ndlela ingasetshenziswa ukwenza isu lokusekela isizindalwazi.

Kopisha amathebula edatha nezizindalwazi kwabanye ababungazi

Uma udinga ukukopisha idatha kwenye iseva ye-MySQL, ungacacisa igama lesizindalwazi kanye nethebula kumyalo we-mysqldump.

Sebenzisa umyalo olandelayo kumsingathi womthombo ukuze wenze isipele idatha kufayela le-dump.txt:

$ mysqldump - u root - p database_name table_name > dump 。文本 
密码*****

Uma wenza ikhophi yasenqolobaneni ngokugcwele, awudingi ukusebenzisa igama lethebula elithile.

Uma udinga ukungenisa i-database egciniwe kuseva ye-MySQL, ungasebenzisa umyalo olandelayo, usebenzisa umyalo olandelayo owudingayo ukuze uqinisekise ukuthi isizindalwazi senziwe:

$ mysql - u root - p database_name < dump 。文本 
密码*****

你也可以使用以下命令将导出的数据直接导入到远程的服务器上，但请确保两台服务器是相通的，是可以相互访问的：</ p > 
$ mysqldump的- ü根- p DATABASE_NAME \
        | mysql - h other - host 。com database_name

Umyalo ongenhla usebenzisa ipayipi ukungenisa idatha ethunyelwe kumsingathi wesilawuli kude esishiwo.