phpMyAdmin mbubata nchekwa data njehie 500? Mbupụ MySQL nnukwu ahịrị iwu faịlụ

Onye na-etinye aka na yaE-azụmahịaNdị enyi ụlọ ọrụ, naanịWụnye panel VestaCPE mesịa, chọrọ ịgafephpmyadminMbubata njikwa nchekwa dataMySQL nchekwa data, Njehie 500 na-apụta, na mbubata na-ada ada mgbe ịnwale ọtụtụ oge ...

O nwere ike ịbụ n'ihi nhazi php.ini ma ọ bụ nsogbu ndị ọzọ, ya mere mbupụ ma ọ bụ bubata na phpMyAdminMySQLNnukwu faịlụ na-ewe ogologo oge, yana oge PHP na-apụ, na-eme ka mbupụ ma ọ bụ mbubata daa.

Ọbụlagodi na ị gbanwee ma welie nhazi ebe nchekwa faịlụ ndị metụtara ya, ọ gaghị enyere aka...

N'ebe a, anyị nwere ike ịgafe Linux Mmejuputa ahịrị iwu:

• Jiri ahịrị iwu ndabere MySQL ka mbupụ nchekwa data MySQL ngwa ngwa;
• Jiri ahịrị iwu mbubata MySQL ka ibubata nchekwa data MySQL ngwa ngwa.

MySQL mbupụ nchekwa data iwu

MariaDB ndabere iwu ▼

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

MySQL ndabere iwu ▼

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

• iwu anaghị agụnye akara []
• Biko gbanwee "dumpfilename" ka ọ bụrụ aha faịlụ nchekwa data MySQL gị.
• Rịba ama akụ aka nri > na-ebupụ.

Mepee faịlụ nchekwa data .gz MySQL

Ọ bụrụ na faịlụ nchekwa data MySQL nwere suffix mkpakọ .gz, enweghị ike ibubata ya na nchekwa data site na ahịrị iwu SSH.

Tupu ịme iwu ka ibubata nchekwa data MySQL, biko tinye iwu decompression .gz na-esonụ ka decompress▼

gunzip FileName.gz

• Biko gbanwee "FileAme" ka ọ bụrụ aha ngwugwu mkpakọ nchekwa data MySQL gị, dịka ọmụmaatụ: xxx.sql.gz

MySQL mbubata iwu nchekwa data

Iwu mbubata MariaDB▼

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

Iwu mbubata MySQL ▼

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

• iwu anaghị agụnye akara []
• Biko gbanwee "dumpfilename" ka ọ bụrụ aha faịlụ nchekwa data MySQL gị.
• Rịba ama akụ aka ekpe < Ọ bụ mbubata.

Maka iwu SSH ndị ọzọ na sistemụ Linux, ị nwere ike ịhụ ebe a ▼

🔗 Nchịkọta iwu na-elele ozi sistemụ Linux