Maitiro ekugadzirisa iyo phpMyAdmin kumisikidza kugadzirisa dambudziko rekuti hapana inokwirisa MySQL dhatabhesi faira?

💻🔧【Chidzidzo chakareruka】 Dzidzisa iwe nhanho-ne-nhanho shandukophpMyAdmingadzirisa, gadzirisaMySQLKupinza dambudziko rekutadza❗️

Ini pachangu ndakaiedza kuti ishande✅, zvinongotora maminetsi matatu⏰ kugadzirisa zvachose dambudzikoMySQLDambudziko rekutadza kuwana iyo yekurodha folda📂.

Hapasisina kutemwa nemusoro nezve ekunze nyaya💡, bata nyore manejimendi yedatabase📊, rega yakoLinuxIyo system inofamba zvakanyanya mushe🌟.

Linux importMySQL databaseChii chaunofanira kuita kana ukakundikana? Shandura iyo phpMyAdmin yekumisikidza nzira, huya uye utarise!

Kuti uwane nzira yekuisa ye phpMyAdmin, unogona kushandisa murairo unotevera:

find / -name pma

Kana

find / -name phpMyAdmin

Kana iwe ukawana nzira yakafanana ne:

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

phpMyAdmin yekuisa nzira

Saka, makorokoto, wakakiya nzvimbo yekuisa yephpMyAdmin!

Mamwe mapurogiramu epaneru ekutonga anoiisa mu `pma` folda, nepo vamwe vachida kuiisa mu `phpMyAdmin` folda.

Unogona kuwana nzira idzi:

/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

Mushure mekuedzwa, zvakazosimbiswaHestiaCPphpMyAdmin yekuisa nzira:/etc/phpmyadmin

Tevere, unogona kupinda mu phpMyAdmin, sarudza dhatabhesi yako, uye tinya "Import." Zvakadaro, mashandiro ekunze anogona kuganhurwa nekukasira.

Nekudaro, isu tinokwanisa kugadzirisa iyo faira yekumisikidza yephpMyAdmin kutsigira kupinza MySQL dhatabhesi mafaera kubva kuseva. Matanho chaiwo ndeaya anotevera:

Shandura iyo faira yekumisikidza ye phpMyAdmin

Tsvaga uye gadzirisa iyo `config.inc.php` faira. Kana uine chete `config.sample.inc.php`, ita kopi uye uipe zita rekuti `config.inc.php`.

1. Tsvaga gadziriro inotevera:

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

2. Shandura ku:

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

Kuchenjerera

Ndokumbira utarise kuti `/tmp` folda iri pano iri mumudzi wedhairekitori reseva.

Unogona kurodha mafaera eMySQL kune iyi `/tmp` dhairekitori. Shandisa SFTP kuisa faira mu `/ tmp`, uye wozosarudza Ngenisa mune dhatabhesi manejimendi yephpMyAdmin (ungangoda kupinda zvakare kuti uone shanduko).

Kana iwe uri kushandisa HestiaCP, dzimwe nguva phpMyAdmin inogona kusatsigira nzira yakasarudzika. Mune ino kesi, ndapota shandura iyo faira yekumisikidza ye phpMyAdmin uye shandura nzira kuenda kune `tmp` dhairekitori rewebhu mushandisi:

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

Kana ukasangana ne "Isa folda kubva kune webhusaiti server'/home/admin/tmp/`Sarudza "Inoratidza" Iko hakuna mafaera ekuisa! ” mamiriro anoratidza kuti mvumo yeforodha haina kukwana.

Ingotsiva `/home/admin/tmp`Seta mvumo yedhairekitori ku `755`:

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

Iye zvino, unogona kupinza nemufaro mafaera ako eMySQL kubva munzira iyi! 🚀

Kana ukaedza nzira iri pamusoro, phpMyAdmin inopinza iyo MySQL databasehaisati yashanda, kana kuoneka500 kukanganisa paunenge uchipinza dhatabhesi reMySQL, unogona kuedza nzira dzinotevera▼

🔗phpMyAdmin pinza dhatabhesi 500 kukanganisa? Export MySQL hombe faira rekuraira mutsara