Momwe mungasinthire kasinthidwe ka phpMyAdmin kuti muthane ndi vuto loti palibe fayilo ya database ya MySQL yomwe ingakweze?

💻🔧【Phunziro losavuta kwambiri】 Amakuphunzitsani zosintha pang'onopang'onophpMyAdminkonza, thetsaMySQLVuto lolephereka kuitanitsa ❗️

Ndidayesa panokha kuti ikhale yogwira mtima✅, zimangotenga mphindi zitatu⏰ kuthetsa vutoloMySQLVuto lolephera kupeza foda yokweza📂.

Palibenso mutu wokhudza kuitanitsa💡, gwirani mosavuta kasamalidwe ka database📊, lolani zanuLinuxDongosolo limayenda bwino kwambiri🌟.

Linux importMySQL databaseKodi mungatani ngati mwalephera? Sinthani njira yosinthira phpMyAdmin, bwerani mudzawone!

Kuti mupeze njira yoyika phpMyAdmin, mutha kugwiritsa ntchito lamulo ili:

find / -name pma

Kapena

find / -name phpMyAdmin

Ngati mupeza njira yofanana ndi:

/usr/local/cwpsrv/var/services/pma
/usr/local/apache/htdocs/phpmyadmin

phpMyAdmin kukhazikitsa njira

Chifukwa chake, zikomo, mwatseka malo oyika phpMyAdmin!

Mapulogalamu ena owongolera adzayiyika mufoda ya `pma`, pomwe ena amakonda kuyiyika mufoda ya `phpMyAdmin`.

Mutha kupeza njira izi:

/usr/share/phpmyadmin
/usr/share/phpmyadmin/vendor/phpmyadmin
/usr/local/hestia/install/rpm/phpmyadmin
/usr/local/hestia/install/deb/phpmyadmin
/var/lib/mysql/phpmyadmin
/var/lib/phpmyadmin
/etc/phpmyadmin

Pambuyo poyesedwa, pamapeto pake zidatsimikiziridwaHestiaCPphpMyAdmin kukhazikitsa njira:/etc/phpmyadmin

Kenako, mutha kulowa mu phpMyAdmin, sankhani database yanu, ndikudina "Import." Komabe, magwiridwe antchito olowetsa akhoza kuchepetsedwa ndi kusakhazikika.

Komabe, titha kusintha fayilo yosinthira ya phpMyAdmin kuti ithandizire kutumiza mafayilo a database a MySQL kuchokera pa seva. Masitepe enieni ndi awa:

Sinthani fayilo yosinthira ya phpMyAdmin

Pezani ndikusintha fayilo ya `config.inc.php`. Ngati muli ndi `config.sample.inc.php`, pangani kope ndikulitchanso kuti `config.inc.php`.

1. Pezani masinthidwe awa:

$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';

2. Sinthani kukhala:

$cfg['UploadDir'] = '/tmp';
$cfg['SaveDir'] = '/tmp';

Njira zopewera

Chonde dziwani kuti chikwatu cha `/tmp` pano chili m'mizu ya seva.

Mutha kukweza mafayilo a MySQL ku `/tmp` directory. Gwiritsani ntchito SFTP kuti muyike fayilo mu `/tmp`, ndiyeno sankhani Lowani mu database ya phpMyAdmin (mungafunike kulowanso kuti muwone zosintha).

Ngati mukugwiritsa ntchito HestiaCP, nthawi zina phpMyAdmin sangagwirizane ndi njira yokhazikika. Pankhaniyi, chonde sinthani fayilo yosinthira ya phpMyAdmin ndikusintha njira yopita ku `tmp` chikwatu cha wogwiritsa ntchito webusayiti:

$cfg['UploadDir'] = '/home/admin/tmp';
$cfg['SaveDir'] = '/home/admin/tmp';

Mukakumana ndi "Kwezani chikwatu kuchokera pa seva ya webusayiti`/home/admin/tmp/`Sankhani "Zikuwonetsa" Palibe mafayilo oti mukweze! ” zomwe zikuwonetsa kuti zilolezo za chikwatu ndizosakwanira.

Ingosinthani `/home/admin/tmp`Khalani zilolezo za chikwatu ku `755`:

sudo chown www-data:www-data /home/admin/ -R
sudo chmod 755 /home/admin/ -R

Tsopano, mutha kulowetsa mosangalala mafayilo anu a MySQL kuchokera panjira iyi! 🚀

Ngati muyesa njira yomwe ili pamwambapa, phpMyAdmin imalowetsa database ya MySQLikadali yosavomerezeka, kapena ikuwonekaZolakwika 500 pakulowetsa database ya MySQL, mutha kuyesa njira zotsatirazi▼

🔗phpMyAdmin 500 cholakwika pakulowetsa nkhokwe? Tumizani fayilo yayikulu ya MySQL mzere wamafayilo