Sengoli sa Lingoloa
Linux MySQL databaseJoang ho romela lifaele tsa data?export csv statement taelo
MySQLho romela data ya data
Ho MySQL u ka e sebelisaKHETHA … HO SEBELISA OUTFILEpolelo ea ho romella data feela ho faele ea mongolo.
Romella data kantle ho naha ka ho sebelisa polelo ea KHETHA ... INTO OUTFILE
Mohlaleng o latelang re tla romela tafole ea data ho file /tmp/tutorials.txt:
mysql > SELECT * FROM chenweiliang_tbl - > INTO OUTFILE '/tmp/tutorials.txt' ;
O ka seta sebopeho se boletsoeng sa tlhahiso ea data ka likhetho tsa litaelo. Mohlala o latelang ke oa ho romela mofuta oa CSV:
mysql > SELECT * FROM passwd INTO OUTFILE '/tmp/tutorials.csv' - > FIELDS TERMINATED BY ',' ENCLOSED BY ''' - > LINES TERMINATED BY '\ r \ n' ;
Mohlaleng o latelang, faele e hlahisoa e nang le boleng bo arohaneng ke lifeheloa.Sebopeho sena se ka sebelisoa ke mananeo a mangata.
SELECT a ,b ,a + b INTO OUTFILE '/tmp/result.text'FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '''行 终止'\ n'FROM test_table ;
Polelo ea SELECT ... INTO OUTFILE e na le litšobotsi tse latelang:
- LOAD DATA INFILE ke ts'ebetso e fapaneng ea KHETHA ... HO OUTFILE, KHETHA syntax.Ho ngola lintlha ho tloha polokelong ea boitsebiso ho ea faeleng, sebelisa KHETHA ... INTO OUTFILE, le ho bala faele hape ka har'a database, sebelisa LOAD DATA INFILE.
- KHETHA ... HO OUTFILE A KHETHA ea foromo 'file_name' e ka ngola mela e khethiloeng faeleng.Faele e entsoe ho moamoheli oa seva, kahoo o tlameha ho ba le tumello ea FILE ho sebelisa syntax ena.
- Sephetho e ka se be faele e teng.Thibela data ea faele hore e se ke ea senyeha.
- Na u hloka ho ba le akhaonto ea ho kena ho seva ho lata lifaele.Ho seng joalo KHETHA ... INTO OUTFILE e ke ke ea ba le phello.
- Ho UNIX, faele e entsoe hore e balehe, 'me litumello li na le seva sa MySQL.Sena se bolela hore ha u ntse u ka bala faele, u ka 'na ua sitoa ho e hlakola.
Romella tafole e le data e sa sebelisoang
Haholo-holo e hlahisa script ea SQL e nang le litaelo CREATE TABLE INSERT joalo-joalo tse hlokahalang ho tsosolosa database ho tloha qalong.
Ho romella data ka ho sebelisa mysqldump, o hloka ho sebelisa khetho ea -tab ho hlakisa bukana e boletsoeng ke faele ea kantle ho naha, 'me sepheo se tlameha ho ngoloa.
Mohlala o latelang o romella tafole ea data chenweiliang_tbl ho /tmp directory:
$ mysqldump - u root - p - no - create - info - tab = / tmp chenweiliang chenweiliang_tbl 密码******
Romella data ka sebopeho sa SQL
Romella data ka sebopeho sa SQL ho faele e boletsoeng, ka tsela e latelang:
$ mysqldump - u root - p chenweiliang chenweiliang_tbl > dump 。文本 密码******
Litaba tsa faele e entsoeng ke taelo e ka holimo ke tse latelang:
- 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' );
Haeba o hloka ho romella data ea database eohle, o ka sebelisa taelo e latelang:
$ mysqldump - u root - p chenweiliang > database_dump 。文本 密码******
Haeba o hloka ho boloka li-database tsohle, o ka sebelisa taelo e latelang:
$ mysqldump - u root - p - all - databases > database_dump 。文本 密码******
Khetho ea --all-databases e kentsoe ho MySQL 3.23.12 le hamorao.
Mokhoa ona o ka sebelisoa ho kenya ts'ebetsong leano la "backup" la database.
Kopitsa litafole tsa data le li-database ho batho ba bang
Haeba o hloka ho kopitsa data ho seva se seng sa MySQL, o ka bolela lebitso la database le tafole ho taelo ea mysqldump.
Etsa taelo e latelang ho moamoheli oa mohloli ho boloka boitsebiso ho faele ea dump.txt:
$ mysqldump - u root - p database_name table_name > dump 。文本 密码*****
Haeba u boloka database ka botlalo, ha ho hlokahale hore u sebelise lebitso le itseng la tafole.
Haeba o hloka ho kenya polokelong ea polokelo ho seva sa MySQL, o ka sebelisa taelo e latelang, o sebelisa taelo e latelang eo o e hlokang ho netefatsa hore database e entsoe:
$ mysql - u root - p database_name < dump 。文本 密码*****
你也可以使用以下命令将导出的数据直接导入到远程的服务器上,但请确保两台服务器是相通的,是可以相互访问的:</ p > $ mysqldump的- ü根- p DATABASE_NAME \ | mysql - h other - host 。com database_name
Taelo e ka holimo e sebelisa peipi ho kenya data e romelloang kantle ho moamoheli ea hole ea boletsoeng.
Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) e arolelane "Joang ho romella lifaele tsa data ho tsoa ho database ea Linux MySQL?Romella csv statement command" ho u thusa.
Rea u amohela ho arolelana sehokelo sa sengoloa sena:https://www.chenweiliang.com/cwl-501.html
Rea u amohela ho mocha oa Telegraph oa blog ea Chen Weiliang ho fumana lintlha tsa morao-rao!
📚 Tataiso ena e na le boleng bo boholo, 🌟Ona ke monyetla o sa tloaelehang, se ke oa o fetoa! ⏰⌛💨
Share le rata haeba u rata!
Ho arolelana le lintho tseo u li ratang ke khothatso ea rona e tsoelang pele!