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

mumwe munhu akabatanidzwaE-commerceShamwari dzeindasitiri, cheteIsa iyo VestaCP panelMushure mezvo, unoda kupfuuraphpMyAdminDatabase management importMySQL database, kwave nezvikanganiso mazana mashanu, uye kupinza kwakatadza mushure mekuedza kakawanda...

Pamwe nekuda kwe php.ini kumisikidza, kana mamwe matambudziko, saka tumira kunze kana kuendesa mu phpMyAdminMySQLIyo faira hombe inotora nguva yakareba, uye iyo php nguva yekubuda inoita kuti kutumira kunze kana kuendesa kunze kukundikane ...

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

Panguva ino, tinogona kupfuura Linux Command line kuita:

• 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