Otu esi ebupụ faịlụ data na nchekwa data Linux MySQL?iwu nkwupụta csv mbupụ

Linux MySQL nchekwa dataOtu esi ebupu faịlụ data?iwu nkwupụta csv mbupụ

MySQLdata mbupụ

Na MySQL ị nwere ike ijiHọrọ… n'ime mpụgankwupụta ka ibupu data naanị na faịlụ ederede.

Mbupu data site na iji Họrọ ... n'ime nkwupụta

N'ihe atụ na-esonụ, anyị ga-ebupụ tebụl data na faịlụ /tmp/tutorials.txt:

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

Ị nwere ike ịtọ usoro mmepụta data akọwapụtara kpọmkwem site na nhọrọ iwu. Ihe atụ na-esonụ bụ maka mbupụ usoro CSV:

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

N'ọmụmaatụ na-esote, a na-emepụta faịlụ nwere ụkpụrụ nke rịkọm kewapụrụ.Enwere ike iji usoro a ọtụtụ mmemme.

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

Nkwupụta ahọpụtara ... n'ime nkwupụta nwere njirimara ndị a:

• LOAD DATA INFILE bụ ọrụ ntụgharị nke ahọpụtara ... N'ime mpụga, họrọ syntax.Iji dee data sitere na nchekwa data gaa na faịlụ, jiri SELECT ... INTO OUTFILE, na ịgụghachi faịlụ ahụ na nchekwa data, jiri LOAD DATA INFILE.
• HỌỌRỌ ... N'ime Mpụta Nhọrọ nke ụdị 'file_name' nwere ike ide ahịrị ahọpụtara na faịlụ.Emebere faịlụ a na onye nnabata nkesa, yabụ ị ga-enwerịrị ikike FILE iji syntax a.
• Mmepụta enweghị ike ịbụ faịlụ dị adị.Gbochie ka emebie data faịlụ.
• Ịkwesịrị ịnwe akaụntụ iji banye na sava ahụ iji weghachite faịlụ.Ma ọ bụghị ya, Họọrọ ... n'ime ihe agaghị enwe mmetụta.
• Na UNIX, a na-emepụta faịlụ ka ọ bụrụ nke a na-agụ, yana ikike nke sava MySQL nwere.Nke a pụtara na mgbe ị nwere ike ịgụ faịlụ ahụ, ị ​​gaghị enwe ike ihichapụ ya.

Mbupụ tebụl dị ka data raw

Ọ na-ewepụtakarị edemede SQL nwere iwu CREATE TABLE INSERT wdg achọrọ iji megharịa nchekwa data site na ọkọ.

Iji bupu data site na iji mysqldump, ịkwesịrị iji nhọrọ –tab iji kọwapụta ndekọ aha nke faịlụ mbupụ akọwapụtara, na ebumnuche ga-abụrịrị ederede.

Ihe atụ na-esonụ na-ebupụ tebụl data chenweiliang_tbl na ndekọ / tmp:

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

Mbupu data n'ụdị SQL

Bupu data n'ụdị SQL na faịlụ akọwapụtara, dị ka ndị a:

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

Ọdịnaya nke faịlụ mepụtara site na iwu dị n'elu bụ nke a:

- 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' ）;

Ọ bụrụ na ịchọrọ mbupụ data nke nchekwa data niile, ịnwere ike iji iwu a:

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

Ọ bụrụ na ịchọrọ ịkwado ọdụ data niile, ịnwere ike iji iwu a:

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

Agbakwunyere nhọrọ --all-databases na MySQL 3.23.12 na emesia.

Enwere ike iji usoro a mejuputa atumatu ndabere nchekwa data.

Detuo tebụl data na ọdụ data na ndị ọbịa ndị ọzọ

Ọ bụrụ na ịchọrọ idetu data na sava MySQL ọzọ, ị nwere ike ịkọwa aha nchekwa data na tebụl na iwu mysqldump.

Mezue iwu na-esonụ na onye ọbịa isi iyi iji kwado data na faịlụ dump.txt:

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

Ọ bụrụ na ị kwadoo nchekwa data n'uju, ịkwesighi iji aha tebụl akọwapụtara.

Ọ bụrụ na ịchọrọ ibubata nchekwa data ndabere na ihe nkesa MySQL, ị nwere ike iji iwu na-esonụ, iji iwu na-esonụ, ị ga-ekwenye na e mepụtara nchekwa data:

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

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

Iwu a dị n'elu na-eji ọkpọkọ ibubata data ebupụ na onye nnabata a kapịrị ọnụ.