Tumira huru SQL file mu PHPMyAdmin



Kana uchishamisika kuti ungakwanisa sei kuisa SQL yakawanda faira mu PHPMyAdmin, mhinduro iri nyore nyore, kuibvumira kuburikidza nehuwandu hwe phpMyAdmin sql import - iyo inogona kushandiswa kuisa csv mu phpMyAdmin, kana kuti kutumira OpenDocument Spreadsheet mu phpMyAdmin, nekungoshandura mafomu ekushandisa mumutengerwo wemenu.

PHPMyAdmin: Chigwaro chakanyorwa muFP chaida kuronga kutungamirirwa kweMySQL pamusoro peWWW

Kupera (semuenzaniso, kunogona kuva 2Mb ne XAMPP (Fig 1)) zvinowanzoita nekuda kwekugadzirisa php.ini.

Ingovhura nyore - somuenzaniso, pamwe neXAMPP, nokusarudza Apache Config menu yekupinda php.ini (Fig 2). Tsvaga mazano anotevera mune fp.ini file: post_max_size, upload_max_filesize, uye memory_limit.

XAMPP iri nyore kuisa kuparadzirwa kweApache ine MySQL, PHP uye Perl
https://www.ybierling.com/v2/en/2015/04/19/import-a-large-sql-file-in-phpmyadmin/: Tsvaga mabasa emunharaunda

Kana zvisingabvumirane, huwandu hwakabvumidzwa kuti uwane faira yefaira huchagadziriswa nehuwandu hunokosha, uchiyeuka mupfungwa yekuyeuka inofanira kunge yakakwirira kudarika mamwe maitiro maviri, sezvo chiyeuchidzo chichadikanwa kuchengetedza nekugadzira data, kwete kuverenga mamwe mabasa eva server.

Aya ndiwo maitirwo emitemo yakasvibiswa panzvimbo yangu yepava:

Izvo zvinogona - kuzviisa pane zvaunoda - zvinogona kuvavandudza kuti zviite zvinodiwa (Figi 3):

Master webhusaiti wegumi: Nyoresa izvozvi!

Shandura yako yekuvapo kwedhijitari ine yedu yebhusaiti yewebhusaiti yekugadzira kosi - Kutanga rwendo rwako rwekuve webhu nyanzvi nhasi!

Nyoresa pano

Shandura yako yekuvapo kwedhijitari ine yedu yebhusaiti yewebhusaiti yekugadzira kosi - Kutanga rwendo rwako rwekuve webhu nyanzvi nhasi!

Usakanganwa, mushure mekushandura kuchinja uku, kutangazve seApache server - pane XAMPP, rega (Fig 4) uye utangezve (Figi 5) (Fig 6) (Fig 7).

Kungofanirwa kuratidza muenzaniso, kana pane imwe chete yehuwandu inoshandiswa, somuenzaniso upload_max_filesize, inogona kuguma nehuwandu hunotevera (Fig 8):

Kunyange zvazvo fesi yakawanda yakave yakagadzirirwa kune yakakwirira, haikwanisi kushanda sezvo huwandu hukuru hwekutumira huri pasi.

PHPMyAdmin inongobvumira 8Mb munyaya inotevera.

Inotsigira kukurudzirwa kwezvikamu zvakawanda zvevhu rakavhurwa purojekiti, kusanganisira Apache web server

Mibvunzo Inowanzo Bvunzwa

Ini ndinopinza sei iyo hombe yeSQL faira uchishandisa Xampp uye Phpmyadmin?
Kuisa kunze kwefaira hombe yeSQ: Wedzera iyo upload_max_fivalize uye post_max_size mune yako php.wi faira. Zvadaro, restart xampp uye yakavhurika Phpmyadmin. Enda kune 'Import' tab, Sarudza yako SQL faira, uye tinya 'Enda'. Kana iyo faira iri yakakura kwazvo, funga kushandisa mutsara wekuraira kana kupatsanura iyo faira kuita zvidiki zvikamu.
Vashandisi vanogona sei kupinza mafaira makuru eSQL mune database uchishandisa phpmyadmin kana iyo faira inodarika huwandu upload upload.
Nekununura kunze kwenyika mafaira eSQL, vashandisi vanogona kuwedzera saizi yekuroora muPHP yekugadziriswa (`php.Chi`) kana kushandisa iyo phpmyadmin kurodha zvigadziriso.

Yoann Bierling
Nezvemunyori - Yoann Bierling
Yoann Bierling ibhusaiti yekushambadzira & Dhijitari Kukurukurirana Professional, kugadzira kukanganisa kwepasi rose kuburikidza nehunyanzvi uye hunyanzvi mune tekinoroji. Passionate nezve kupa simba vanhu uye masangano kuti akubudirire muzera redhijitari, anofambiswa kununura mhedzisiro yakasarudzika uye yekufambisa ichipfuura kuburikidza nedzidziso yezvinyorwa zvemukati.

Master webhusaiti wegumi: Nyoresa izvozvi!

Shandura yako yekuvapo kwedhijitari ine yedu yebhusaiti yewebhusaiti yekugadzira kosi - Kutanga rwendo rwako rwekuve webhu nyanzvi nhasi!

Nyoresa pano

Shandura yako yekuvapo kwedhijitari ine yedu yebhusaiti yewebhusaiti yekugadzira kosi - Kutanga rwendo rwako rwekuve webhu nyanzvi nhasi!




Comments (5)

 2018-08-19 -  Shane Ross
Uwielbiam czytać twoje treści, publikuj dalej
 2018-08-19 -  Samantha Murray
So machen wir das, großartig zu wissen
 2018-08-19 -  Raul Lamb
Adoro ler seu conteúdo, continue postando
 2018-08-19 -  Samantha Gonzales
Đã có thời gian tuyệt vời khi đọc thông tin này, hãy tiếp tục công việc tốt
 2018-08-19 -  pravitates
Velké množství informací, díky za sdílení

Siya mhinduro