E faʻafefea ona suia le phpMyAdmin configuration e foia ai le faʻafitauli e leai se faila faila database MySQL e mafai ona faʻapipiʻiina?

💻🔧【A'oa'oga Faigofie Tele】Ta'iala la'asaga i lea la'asaga i le suia o le fa'atulagaga o le phpMyAdmin ma le fo'ia o fa'aletonu o le fa'aulufale mai o le MySQL❗️

Ua uma ona fa'ata'ita'iina ma fa'amaonia lona aoga! ✅ E na'o le tolu minute ⏰ e fo'ia atoa ai le fa'afitauli o le le mafai e le MySQL ona maua le faila ua lafoina i luga 📂.

Leai se isi tiga ulu e uiga i le aumaia o faʻamaumauga💡, pulea faigofie lau faʻamaumauga📊 ma faʻafaigofie lau faiga Linux🌟 .

O le ā se mea e fai pe a lē manuia le aumaia o se fa'amaumauga MySQL i luga o le Linux ? O le auala lea e sui ai le fa'atulagaga o le phpMyAdmin!

Ina ia maua le auala faʻapipiʻi o phpMyAdmin, e mafai ona e faʻaogaina le poloaiga lenei:

find / -name pma

或

find / -name phpMyAdmin

Afai e te mauaina se auala e pei o:

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

phpMyAdmin auala faʻapipiʻi

O lea la, faʻafetai, ua e lokaina le nofoaga faʻapipiʻi o phpMyAdmin!

E fa'apipi'i e nisi polokalame fa'atonu i totonu o le 'pma' folder, ae o isi e manana'o e tu'u i totonu o le 'phpMyAdmin' folder.

E mafai ona e mauaina auala nei:

/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

Ina ua uma le suʻega, na faʻamaonia mulimuli aneHestiaCPphpMyAdmin auala faʻapipiʻi:/etc/phpmyadmin

Le isi, e mafai ona e ulufale i totonu phpMyAdmin, filifili lau database, ma kiliki "Auina mai." Peita'i, e mafai ona fa'atapula'aina galuega fa'aulufale mai ona o le fa'aletonu.

Ae ui i lea, e mafai ona matou suia le faila o le phpMyAdmin e lagolago ai le faʻaulufaleina mai o faila database MySQL mai le server. Laasaga fa'apitoa e fa'apea:

Suia le faila faatulagaina o le phpMyAdmin

Su'e ma fa'asa'o le faila `config.inc.php`. Afai e na'o lau `config.sample.inc.php`, fai sau kopi ma toe faaigoa i le `config.inc.php`.

1. Su'e le fa'atulagaina lea:

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

2. Suia i:

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

Lapataiga

Faamolemole ia matau o le `/tmp` faila iinei o loo i totonu o le root directory o le server.

Ona mafai lea ona e lafoina faila MySQL i lenei `/tmp` directory. Fa'aaoga le SFTP e tu'u ai le faila i le `/tmp`, ona filifili lea o le Fa'aulufale mai i le fa'atonuga o fa'amaumauga a le phpMyAdmin (atonu e te mana'omia le toe saini e va'ai i suiga).

Afai o lo'o e fa'aogaina le HestiaCP, o nisi taimi e le lagolagoina e phpMyAdmin le ala fa'aletonu. I lenei tulaga, fa'amolemole sui le faila o le phpMyAdmin ma sui le ala i le 'tmp' directory a le tagata fa'aoga upega tafa'ilagi:

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

Afai e te feagai ma le "Upload folder from website server`/home/admin/tmp/`Filifili "E faʻaalia" E leai ni faila e faʻapipiʻi! ” tulaga e faailoa mai ai e le lava le faatagaga o faila.

Na'o le sui '/home/admin/tmp'Se'i le fa'atagaga o fa'atonuga ile `755':

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

I le taimi nei, e mafai ona e faʻaulufale mai ma le fiafia au faila MySQL mai lenei ala! 🚀

Afai ua e faʻataʻitaʻiina auala o loʻo i luga ma e le manuia lava le faʻaulufaleina mai o se faʻamaumauga MySQL e faʻaaoga ai le phpMyAdmin, pe e te fetaiaʻi ma se faʻaletonu 500 pe a faʻaulufaleina mai se faʻamaumauga MySQL, e mafai ona e faʻataʻitaʻi auala nei▼

🔗phpMyAdmin import database 500 sese? Fa'atau atu i fafo MySQL laina tele faila faila