Yadda za a gyara tsarin phpMyAdmin don magance matsalar cewa babu fayil ɗin bayanan MySQL da za a iya aikawa?

💻🔧【Koyarwa Mai Sauƙi】Jagorar mataki-mataki don gyara tsarin phpMyAdmin da warware kurakuran shigo da MySQL❗️

An gwada kuma an tabbatar da ingancinsa! ✅ Yana ɗaukar mintuna uku kacal ⏰ don magance matsalar rashin samun damar shiga babban fayil ɗin da aka ɗora 📂.

Babu ƙarin ciwon kai game da shigo da bayanai💡, sarrafa bayanai cikin sauƙi📊 kuma sa tsarin Linux ɗinku ya yi aiki cikin sauƙi🌟.

Me za a yi idan shigo da bayanai na MySQL ya gaza a Linux ? Ga yadda ake gyara tsarin phpMyAdmin!

Don nemo hanyar shigarwa na phpMyAdmin, zaku iya amfani da umarni mai zuwa:

find / -name pma

或

find / -name phpMyAdmin

Idan kun sami hanya mai kama da:

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

phpMyAdmin hanyar shigarwa

Don haka, taya murna, kun kulle wurin shigarwa na phpMyAdmin!

Wasu shirye-shiryen gudanarwa za su shigar da shi a cikin babban fayil na 'pma', yayin da wasu ke son sanya shi a cikin babban fayil 'phpMyAdmin'.

Kuna iya samun waɗannan hanyoyi:

/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

Bayan gwaji, a ƙarshe an tabbatar da shiHestiaCPHanyar shigarwa phpMyAdmin:/etc/phpmyadmin

Na gaba, zaku iya shiga cikin phpMyAdmin, zaɓi bayananku, sannan danna "Import." Koyaya, ana iya iyakance ayyukan shigo da kaya ta tsohuwa.

Koyaya, zamu iya canza fayil ɗin sanyi na phpMyAdmin don ya goyi bayan shigo da fayilolin bayanan MySQL daga sabar. Takamaiman matakai sune kamar haka:

Gyara fayil ɗin sanyi na phpMyAdmin

Nemo kuma gyara fayil ɗin `config.inc.php`. Idan kawai kuna da `config.sample.inc.php`, yi kwafi kuma ku sake suna zuwa `config.inc.php`.

1. Nemo tsari mai zuwa:

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

2. Gyara zuwa:

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

Kariya

Lura cewa babban fayil `/tmp` anan yana cikin tushen adireshin uwar garken.

Kuna iya loda fayilolin MySQL zuwa wannan kundin '/tmp'. Yi amfani da SFTP don saka fayil ɗin cikin `/tmp`, sannan zaɓi Shigo cikin sarrafa bayanai na phpMyAdmin (zaka iya buƙatar sake shiga don ganin canje-canje).

Idan kana amfani da HestiaCP, wani lokacin phpMyAdmin bazai goyi bayan hanyar tsoho ba. A wannan yanayin, da fatan za a canza fayil ɗin sanyi na phpMyAdmin kuma canza hanyar zuwa kundin adireshin 'tmp' na mai amfani da gidan yanar gizon:

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

Idan kun ci karo da "Load da babban fayil daga uwar garken gidan yanar gizo'/home/admin/tmp/'Zaɓa "Yana nunawa" Babu fayilolin da za a loda! ” halin da ake ciki yana nuna cewa izinin babban fayil ɗin bai isa ba.

Sauya kawai `/home/admin/tmp'A saita izinin kundin adireshi zuwa'755':

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

Yanzu, zaku iya shigo da fayilolin MySQL da farin ciki daga wannan hanyar! 🚀

Idan kun gwada hanyoyin da ke sama kuma kun shigo da bayanai na MySQL ta amfani da phpMyAdmin har yanzu ba su yi nasara ba, ko kuma kun ci karo da kuskuren 500 lokacin shigo da bayanai na MySQL, kuna iya gwada waɗannan hanyoyin▼

🔗phpMyAdmin shigo da bayanai 500 kuskure? Fitar da babban layin umarni na fayil MySQL