Yuav hloov kho li cas phpMyAdmin configuration los daws qhov teeb meem uas tsis muaj uploadable MySQL database file?

💻🔧 【Super simple tutorial】Qhia koj cov kev hloov kho ib ntusphpmyadminconfigure, dawsMySQLImport tsis ua hauj lwm teeb meem❗️

Tus kheej sim nws kom ua tau zoo ✅, nws tsuas siv peb feeb ⏰ los daws qhov teeb meemMySQLQhov teeb meem ntawm kev tsis tuaj yeem nkag mus rau cov ntaub ntawv upload 📂.

Tsis muaj mob taub hau ntxiv txog cov teeb meem ntshuam 💡, yooj yim tswj kev tswj hwm database📊, cia kojLinuxLub kaw lus ua haujlwm yooj yim dua🌟.

Linux importMySQL databaseYuav ua li cas yog tias koj ua tsis tiav? Hloov kho phpMyAdmin configuration method, tuaj thiab saib!

Txhawm rau nrhiav txoj hauv kev teeb tsa ntawm phpMyAdmin, koj tuaj yeem siv cov lus txib hauv qab no:

find / -name pma

los yog

find / -name phpMyAdmin

Yog tias koj pom txoj hauv kev zoo ib yam li:

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

phpMyAdmin installation txoj kev

Yog li, ua kev zoo siab, koj tau kaw qhov chaw teeb tsa ntawm phpMyAdmin!

Qee qhov kev tswj hwm vaj huam sib luag yuav nruab rau hauv 'pma' nplaub tshev, thaum lwm tus nyiam muab tso rau hauv 'phpMyAdmin' nplaub tshev.

Koj tuaj yeem pom cov kab no:

/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

Tom qab kev sim, nws tau pom thaum kawgHestiaCPphpMyAdmin installation txoj kev:/etc/phpmyadmin

Tom ntej no, koj tuaj yeem nkag mus rau phpMyAdmin, xaiv koj cov ntaub ntawv, thiab nyem "Ntshuam." Txawm li cas los xij, ntshuam functionality yuav raug txwv los ntawm lub neej ntawd.

Txawm li cas los xij, peb tuaj yeem hloov kho cov ntaub ntawv teeb tsa ntawm phpMyAdmin los txhawb nqa cov ntaub ntawv MySQL database los ntawm lub server. Cov kauj ruam tshwj xeeb yog raws li hauv qab no:

Hloov kho cov ntaub ntawv teeb tsa ntawm phpMyAdmin

Nrhiav thiab kho cov ntaub ntawv 'config.inc.php'. Yog tias koj tsuas muaj 'config.sample.inc.php', ua ib daim ntawv luam thiab hloov npe rau 'config.inc.php'.

1. Nrhiav cov kev teeb tsa hauv qab no:

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

2. Hloov rau:

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

Ceev faj

Thov nco ntsoov tias '/tmp' nplaub tshev ntawm no yog nyob rau hauv lub hauv paus directory ntawm tus neeg rau zaub mov.

Koj tuaj yeem rub tawm MySQL cov ntaub ntawv rau qhov '/tmp' directory. Siv SFTP los muab cov ntaub ntawv tso rau hauv '/tmp', thiab tom qab ntawd xaiv Ntshuam hauv kev tswj hwm database ntawm phpMyAdmin (tej zaum koj yuav tsum tau nkag rau hauv dua kom pom cov kev hloov pauv).

Yog tias koj siv HestiaCP, qee zaum phpMyAdmin yuav tsis txhawb txoj hauv kev. Hauv qhov no, thov hloov kho cov ntaub ntawv teeb tsa ntawm phpMyAdmin thiab hloov txoj hauv kev mus rau 'tmp' directory ntawm tus neeg siv lub vev xaib:

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

Yog tias koj ntsib "Upload folder los ntawm lub vev xaib server'/home/admin/tmp/`Xaiv "Nws qhia tau tias" Tsis muaj cov ntaub ntawv upload! ” qhov xwm txheej qhia tias cov ntaub ntawv tso cai tsis txaus.

Tsuas hloov `/home/admin/tmp'Tsim cov ntawv tso cai rau '755':

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

Tam sim no, koj tuaj yeem zoo siab import koj cov ntaub ntawv MySQL los ntawm txoj kev no! 🚀

Yog tias koj sim cov txheej txheem saum toj no, phpMyAdmin imports MySQL databasetseem tsis raug cai, los yog tshwm sim500 yuam kev thaum importing MySQL database, koj tuaj yeem sim cov hauv qab no ▼

🔗 phpMyAdmin import database 500 yuam kev? Export MySQL cov ntaub ntawv loj hais kom ua kab