phpMyAdmin import database 500 yuam kev? Export MySQL cov ntaub ntawv loj hais kom ua kab

Ib tug phooj ywg uas ua haujlwm hauv kev lag luam e-commerce nyuam qhuav teeb tsa VestaCP vaj huam sib luag thiab xav import ib lub database MySQL los ntawm phpMyAdmin , tab sis tau txais qhov yuam kev 500 thiab ua tsis tau import nws tom qab ntau zaus sim ...

Qhov teeb meem yuav yog vim php.ini configuration lossis lwm yam teeb meem, ua rau phpMyAdmin siv sijhawm ntev dhau los export lossis import cov ntaub ntawv MySQL loj , ua rau PHP timeouts thiab export/import tsis ua haujlwm.

Txawm hais tias qhov kev hloov kho txhim kho lub cim xeeb teeb tsa ntawm cov ntaub ntawv cuam tshuam, nws yuav tsis pab ...

Hauv qhov no, peb tuaj yeem ua tiav cov hauv qab no los ntawm kab hais kom ua Linux :

• Siv MySQL thaub qab kab hais kom ua kom xa tawm MySQL database sai sai;
• Siv MySQL ntshuam kab hais kom ua sai sai import MySQL databases.

MySQL export database hais kom ua

MariaDB thaub qab hais kom ua ▼

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

MySQL Backup Commands ▼

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

• cov lus txib tsis suav nrog cov cim []
• Thov hloov "dumpfilename" rau koj MySQL database file name.
• Nco ntsoov tus xub xub > yog export.

Extract cov ntaub ntawv .gz MySQL database

Yog tias koj cov ntaub ntawv MySQL database yog compressed nrog .gz suffix, nws tsis tuaj yeem raug xa mus rau hauv cov ntaub ntawv ntawm SSH cov kab hais kom ua.

Ua ntej khiav cov lus txib kom import MySQL database, thov sau cov lus hauv qab no .gz unzip hais kom unzip ▼

gunzip FileName.gz

• Thov hloov "FileName" rau lub npe ntawm koj MySQL database archive, piv txwv li: xxx.sql.gz

MySQL import database hais kom ua

MariaDB import command ▼

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

MySQL ntshuam hais kom ua ▼

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

• cov lus txib tsis suav nrog cov cim []
• Thov hloov "dumpfilename" rau koj MySQL database file name.
• Nco ntsoov tus xub laug < yog import.

Ntau SSH cov lus txib rau Linux systems tuaj yeem pom ntawm no ▼

🔗 Linux system cov ntaub ntawv saib cov lus txib sau