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

ib tug neeg koom nrogE-kev lag luamCov phooj ywg ntawm kev lag luam, tsuas yogNruab VestaCP vaj huam sib luagTom qab ntawd, xav dhauphpmyadmindatabase tswj ntshuamMySQL database, muaj 500 qhov yuam kev, thiab kev ntshuam ua tsis tiav tom qab sim ntau zaus ...

Tej zaum vim yog php.ini configuration, los yog lwm yam teeb meem, yog li export los yog ntshuam hauv phpMyAdminMySQLCov ntaub ntawv loj yuav siv sij hawm ntev heev, thiab lub sijhawm php ua rau kev xa tawm lossis ntshuam ua tsis tiav ...

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

Lub sijhawm no, peb tuaj yeem dhau mus Linux Kev siv kab hais kom ua:

• 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