E faʻafefea ona faʻatau atu faila faʻamaumauga mai le Linux MySQL database?auina atu i fafo csv faamatalaga poloaiga

Fa'afefea ona auina atu faila fa'amaumauga mai se fa'amaumauga Linux MySQL? O a poloaiga mo le auina atu i le CSV?

MySQLfa'amatalaga fa'amatalaga auina atu i fafo

I le MySQL, e mafai ona e faʻaaogaina le faʻamatalaga SELECT … INTO OUTFILE e faigofie ai ona auina atu faʻamatalaga i se faila tusitusia.

Fa'asalalauina fa'amatalaga e fa'aaoga ai le fa'amatalaga SELECT ... INTO OUTFILE

I le fa'ata'ita'iga o lo'o mulimuli mai o le a matou fa'atau atu le laulau fa'amaumauga i le faila /tmp/tutorials.txt:

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

E mafai ona e setiina le fa'atulagaina o fa'amaumauga o fa'amatalaga e ala i filifiliga o fa'atonuga.

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

I le faʻataʻitaʻiga o loʻo mulimuli mai, o se faila e faʻatupuina ma tau e vavaeeseina e koma.O lenei faatulagaga e mafai ona faʻaaogaina e le tele o polokalame.

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

O le fa'amatalaga SELECT ... INTO OUTFILE e iai uiga nei:

• LOAD DATA INFILE o le faagaioiga faafeagai a SELECT ... INTO OUTFILE, SELECT syntax.Ina ia tusia faʻamatalaga mai se faʻamaumauga i se faila, faʻaoga SELECT ... INTO OUTFILE, ma toe faitau le faila i totonu o le database, faʻaaoga LOAD DATA INFILE.
• FILIFILI ... I LE FILIFILI O se FILIFILI o le fomu 'file_name' e mafai ona tusi laina filifilia i se faila.O le faila na faia i luga o le 'au'aunaga, o lea e tatau ai ona i ai sau fa'atagaga FILE e fa'aoga ai lenei fa'asologa.
• Ole fa'aaliga e le mafai ona avea ma faila o iai.Taofi fa'amaumauga faila mai le fa'alavelaveina.
• E te manaʻomia e iai sau faʻamatalaga e te ulufale ai i le server e toe aumai faila.A leai, FILIFILI ... INTO OUTFILE o le a leai se aoga.
• I UNIX, ua faia le faila ina ia mafai ona faitau, ma faʻatagaga e umia e le MySQL server.O lona uiga e ui e mafai ona e faitauina le faila, atonu e le mafai ona e tapeina.

Lafoa'i laulau e fai ma fa'amatalaga mata'utia

E masani lava ona maua ai se fa'amaumauga SQL o lo'o iai fa'atonuga CREATE TABLE INSERT ma isi mea e mana'omia e toe fa'atupu ai le fa'amaumauga mai le sasa.

Ina ia faʻatau atu faʻamatalaga e faʻaaoga ai mysqldump, e tatau ona e faʻaogaina le -tab filifiliga e faʻamaonia ai le lisi o loʻo faʻamaonia e le faila auina atu, ma o le sini e tatau ona tusitusi.

O le fa'ata'ita'iga o lo'o i lalo e fa'atau atu le laulau fa'amaumauga chenweiliang_tbl i le /tmp directory:

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

Fa'asalalauina fa'amaumauga ile fa'atulagaga SQL

Fa'atau atu fa'amatalaga ile fa'asologa SQL ile faila fa'apitoa, e fa'apea:

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

O mea o loʻo i totonu o le faila na faia e le poloaiga o loʻo i luga e faʻapea:

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

Afai e te manaʻomia le faʻatau atu o faʻamatalaga o le database atoa, e mafai ona e faʻaogaina le poloaiga lenei:

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

Afai e te manaʻomia le faʻasaʻoina o faʻamaumauga uma, e mafai ona e faʻaogaina le poloaiga lenei:

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

O le filifiliga --all-databases na faʻaopoopoina ile MySQL 3.23.12 ma mulimuli ane.

O lenei metotia e mafai ona faʻaaogaina e faʻatino ai se taʻiala faʻamaumauga faʻamaumauga.

Kopi laulau fa'amaumauga ma fa'amaumauga i isi 'au

Afai e te manaʻomia le kopiina o faʻamatalaga i se isi MySQL server, e mafai ona e faʻamaonia le igoa faʻamaumauga ma le laulau i le mysqldump command.

Fa'atino le fa'atonuga o lo'o i lalo i luga o le 'au fa'apogai e toe fa'afo'i fa'amaumauga i le faila dump.txt:

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

Afai e te fa'aola le fa'amaumauga atoa, e te le mana'omia le fa'aogaina o se igoa o le laulau fa'apitoa.

Afai e te manaʻomia le faʻaulufaleina o faʻamaumauga faʻamaumauga i le MySQL server, e mafai ona e faʻaogaina le poloaiga lenei, faʻaaoga le poloaiga lenei e te manaʻomia e faʻamaonia ai ua fatuina le database:

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

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

O le fa'atonuga o lo'o i luga e fa'aaogaina ai se paipa e fa'aulufale mai ai fa'amatalaga fa'atau atu i le 'au fa'apitoa mamao.