phpMyAdmin kupinza dhatabhesi 500 kukanganisa? Export MySQL hombe faira rekuraira mutsara

Shamwari inoshanda muindasitiri ye e-commerce munguva pfupi yapfuura yakaisa panel yeVestaCP uye yaida kupinza database yeMySQL kuburikidza ne phpMyAdmin , asi yakaramba ichiwana 500 error uye yakatadza kuipinza mushure mekuedza kakawanda…

Dambudziko iri rinogona kunge riri nekuda kwekugadzirisa kwephp.ini kana mamwe matambudziko, zvichiita kuti phpMyAdmin itore nguva yakareba kutumira kana kupinza mafaira makuru eMySQL , zvichikonzera kuti PHP igare kwenguva refu uye kutadza kutumira/kupinza mafaira.

Kunyangwe iyo shanduko ikavandudza ndangariro kumisikidzwa kwemafaira ane hukama, hazvibatsire ...

Panguva ino, tinogona kuita zvinotevera kuburikidza neLinux command line:

• Shandisa MySQL backup command line kukurumidza kutumira kunze MySQL database;
• Shandisa iyo MySQL import command line kukurumidza kupinza MySQL dhatabhesi.

MySQL kutumira kunze database yekuraira

MariaDB backup command▼

mariadb-dump -u root -p[root_password] [database_name] > dumpfilename.sql

MySQL Backup Commands ▼

mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql

• murairo haubatanidzi zviratidzo []
• Ndokumbirawo shandura "dumpfilename" kune yako MySQL database faira zita.
• Cherechedza museve wekurudyi > iri kunze kwenyika.

Bvisa .gz MySQL database file

Kana faira yako yedatabase yeMySQL yakadzvanywa ne .gz suffix, haigone kuendeswa kunze kwenyika mudhatabhesi kuburikidza neSSH command line.

Usati waita murairo wekupinza dhatabhesi reMySQL, ndapota isa inotevera .gz unzip command kuti unzip ▼

gunzip FileName.gz

• Ndokumbira uchinje "FileName" kuzita reMySQL database yako, semuenzaniso: xxx.sql.gz

MySQL import database command

MariaDB import command▼

mariadb-dump -u root -p[root密码] [数据库名称] < dumpfilename.sql

MySQL import command ▼

mysql -u root -p[root密码] [数据库名称] < dumpfilename.sql

• murairo haubatanidzi zviratidzo []
• Ndokumbirawo shandura "dumpfilename" kune yako MySQL database faira zita.
• Cherechedza museve wekuruboshwe < iri import.

Mimwe SSH mirairo yeLinux masisitimu inogona kuwanikwa pano ▼

🔗Linux sisitimu ruzivo rwekutarisa kuunganidzwa kwekuraira