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

💻🔧【Kev Qhia Yooj Yim Heev】Cov kauj ruam-rau-kauj ruam qhia txog kev hloov kho phpMyAdmin kev teeb tsa thiab daws teeb meem MySQL import tsis ua haujlwm❗

Sim thiab ua pov thawj tias zoo lawm! ✅ Tsuas siv peb feeb xwb ⏰ los daws qhov teeb meem ntawm MySQL tsis tuaj yeem nkag mus rau hauv daim nplaub tshev uas tau uploaded 📂.

Tsis muaj mob taub hau ntxiv lawm txog kev xa cov ntaub ntawv database💡, yooj yim tswj koj cov ntaub ntawv database📊 thiab ua rau koj lub Linux system khiav tau zoo dua🌟.

Yuav ua li cas yog tias kev importing ib lub database MySQL tsis ua haujlwm ntawm Linux ? Nov yog yuav ua li cas hloov kho phpMyAdmin configuration!

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 tau sim cov txheej txheem saum toj no thiab importing ib lub MySQL database siv phpMyAdmin tseem ua tsis tau, lossis koj ntsib qhov yuam kev 500 thaum importing ib lub MySQL database, koj tuaj yeem sim cov txheej txheem hauv qab no▼

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