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 peWWWKupera (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 Perlhttps://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):
Dzidza seo Basics: Nyoresa nhasi!
Simudzira kuoneka kwewebsite yako uye traffic nekumanikidza izvo zvakakosha zve seo neyedu nyore-kune-tevera basics kosi.
Tanga kudzidza seoUsakanganwa, 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 serverMibvunzo 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 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.
Dzidza seo Basics: Nyoresa nhasi!
Simudzira kuoneka kwewebsite yako uye traffic nekumanikidza izvo zvakakosha zve seo neyedu nyore-kune-tevera basics kosi.
Tanga kudzidza seo