Phoso ea 500 ea ho kenya database ea phpMyAdmin? Export MySQL e kholo mola oa taelo ea faele

motho ya kenengKhoeboMetsoalle ea indasteri, feelaKenya phanele ea VestaCPKa mor'a moo, batla ho fetaphpMyAdminho kenya tsamaiso ea polokelo ea boitsebisoMySQL database, ho bile le liphoso tse 500, mme thepa e tsoang kantle e ile ea hloleha kamora ho leka makhetlo a mangata...

Mohlomong ka lebaka la php.ini tlhophiso, kapa mathata a mang, kahoo romela thepa kapa ho kenya phpMyAdminMySQLFaele e kholo e nka nako e telele haholo, 'me nako ea php e etsa hore thomello kapa thepa e hlolehe ...

Le ha phetoho e ntlafatsa tlhophiso ea memori ea lifaele tse amanang, e ke ke ea thusa ...

Mothating ona, re ka feta Linux Ts'ebetsong ea mola oa taelo:

• Sebelisa mohala oa taelo oa "backup" oa MySQL ho romella ka potlako database ea MySQL;
• Sebelisa mola oa taelo ea ho kenya MySQL ho kenya marang-rang a MySQL kapele.

Taelo ea database ea MySQL ea kantle ho naha

Taelo ea "backup" ea MariaDB▼

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

Litaelo tsa ho boloka MySQL ▼

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

• taelo ha e kenyeletse matšoao []
• Ka kopo fetola "dumpfilename" ho lebitso la hau la database la MySQL.
• Ela hloko motsu o nepahetseng > ke thomello.

Ntša faele ea polokelo ea .gz MySQL

Haeba faele ea hau ea database ea MySQL e hatelloa ka sekoaelo sa .gz, e ke ke ea romelloa ka har'a database ka mola oa taelo oa SSH.

Pele o sebelisa taelo ea ho kenya polokelong ea polokelo ea MySQL, ka kopo kenya .gz unzip taelo ea ho bula ▼

gunzip FileName.gz

• Ka kopo fetola "FileName" ho lebitso la polokelo ea polokelo ea MySQL, mohlala: xxx.sql.gz

Taelo ea ho kenya database ea MySQL

Taelo ea ho kenya MariaDB▼

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

Taelo ea ho kenya MySQL ▼

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

• taelo ha e kenyeletse matšoao []
• Ka kopo fetola "dumpfilename" ho lebitso la hau la database la MySQL.
• Ela hloko motsu o ka letsohong le letšehali < ke import.

Litaelo tse ling tsa SSH bakeng sa lits'ebetso tsa Linux li ka fumanoa mona ▼

🔗Pokello ea litaelo tsa ho shebella tlhaiso-leseling ea Linux