phpMyAdmin import database 500 sese? Fa'atau atu i fafo MySQL faila faila laina tele

se tasi na auaiE-fefaʻatauaigaUo o le alamanuia, na oFaʻapipiʻi le VestaCP panelA maeʻa lena, manaʻo e pasiphpMyAdminfa'aulufale mai fa'amaumauga fa'amaumaugaMySQL database, ua 500 mea sese, ma ua le manuia le faaulufale mai ina ua uma ona taumafai i le tele o taimi...

Masalo ona o le php.ini configuration, poʻo isi faʻafitauli, o lea e auina atu i fafo pe faʻaulufale mai ile phpMyAdminMySQLOle faila tele e umi tele, ma ole taimi ole php e mafua ai ona le manuia le auina atu i fafo poʻo le faʻaulufale mai...

E tusa lava pe faʻaleleia e le suiga le faʻatulagaina o mafaufauga o faila e fesoʻotaʻi, e le fesoasoani ...

I lenei tulaga, e mafai ona tatou pasia Linux Fa'atonuga laina:

• Fa'aaoga le laina fa'atonu MySQL backup e vave fa'atau atu ai le database MySQL;
• Fa'aoga le MySQL import command line e vave fa'aulufale mai MySQL databases.

MySQL export database command

MariaDB backup command▼

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

MySQL Fa'atonu Poloaiga ▼

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

• poloaiga e le aofia ai faailoga []
• Fa'amolemole sui le "dumpfilename" i lau MySQL database file name.
• Matau le aū taumatau > o le auina atu i fafo.

Aveese le .gz MySQL database faila

Afai o lau faila database MySQL e faʻapipiʻiina i se suffix .gz, e le mafai ona faʻaulufale mai i totonu o le database e ala i le SSH command line.

A'o le'i fa'atonuina le fa'atonuga e fa'aulufale mai le MySQL database, fa'amolemole fa'aoga i lalo le .gz unzip command to unzip ▼

gunzip FileName.gz

• Fa'amolemole sui le "FileName" i le igoa o lau MySQL database compressed package, mo se fa'ata'ita'iga: xxx.sql.gz

MySQL import database command

MariaDB faaulufale mai poloaiga▼

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

MySQL faaulufale mai poloaiga ▼

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

• poloaiga e le aofia ai faailoga []
• Fa'amolemole sui le "dumpfilename" i lau MySQL database file name.
• Matau le aū agavale < e faaulufale mai.

E tele tulafono SSH mo Linux e mafai ona maua iinei ▼

🔗Linux system information viewing command collection