Kedu ka phpMyAdmin si agbanwe ụdị tebụl data InnoDB gaa na injin ndabere MyISAM?

phpmyadminOtu esi agbanwe ụdị tebụl data InnoDB

Tugharia ka injin ndabara MyISAM?

A na-atụ aro ka ịtụgharị tebụl data InnoDB gaa na tebụl data MyISAM:

• Ejikọtara ya na njirimara nke blọọgụ nkeonwe, a na-atụ aro MyISAM maka sistemụ blọgụ nkeonwe, n'ihi na isi ọrụ na blọọgụ na-agụ na ịde ihe, yana enwere obere ọrụ agbụ.
• ya mereỊhọrọ injin MyISAM ga-eme ka blọọgụ gị mepee ibe ya nke ọma karịa blọọgụ nwere injin InnoDB.
• N'ezie, ọ bụ naanị ntụnye onwe onye, ​​​​ma ọtụtụ ndị na-ede blọgụ na-ahọrọ nke ọma dịka ọnọdụ dị adị.

Ndụmọdụ:na ntughariMySQL nchekwa dataTupu tebụl, jide n'aka na ị ga-eme ndabere nchekwa data ▼

Nzọụkwụ iji aka gbanwee ụdị tebụl data na ndabere phpMyAdmin

• 1) Banye na njikwa nchekwa data phpMyAdmin;
• 2) Mgbe ịbanye, pịa na kọlụm aka ekpeNdekota;
• 3) Pịa na kọlụm aka ekpeỤdị data (ụdị na-abụghị MyISAM);
• 4) Pịa "na-arụ ọrụ"Taabụ;
• 5) Na ibe "Operation", họrọ ịgbanwe ụdị "Ebe nchekwa data" ka ọ bụrụ "ỌMISI";
• 6) Pịa "rụrụ", ntụgharị ahụ na-aga nke ọma.

Iwu SSH ka ịgbanwee ngwa ngwa gaa na ụdị tebụl nchekwa data MyISAM

Mepee SSH软件Ejikọtara yaLinuxihe nkesa, tinye iwu na-esonụ▼

mysql -uroot -p

• Tinye paswọọdụ phpMyAdmin ka ịbanye na SSH.
• gosipụta "mysql>"Ị nwere ike ịga n'ihu.
• Tinye n'ụdị na-esonụ, na-enwe mmetụta nke ikpe na ;.
• Aha nchekwa data na aha tebụl bụ obere mkpụrụedemede, yana iwu ndị ọzọ bụ nnukwu. Ọ bụrụ na abanyeghị nke ikpeazụ, iwu ahụ agaghị arụ ọrụ.

USE 数据库名;
SHOW TABLES;
ALTER TABLE 表名 ENGINE=MYISAM;

Tebụl wp_commentmeta nke mbụ tụgharịrị na foto dị n'okpuru ka egosipụtara nke ọma, mgbe ahụ enwere ike ịtụgharị aha tebụl otu otu▼

• banye SHOW TABLES;  Mgbe iwu ahụ gasịrị, a na-egosipụta aha tebụl nchekwa data.
• Detuo ma gbanwee aha tebụl kwekọrọ ALTER TABLE 表名 ENGINE=MYISAM; Tụgharịa na ụdị tebụl nchekwa data MyISAM maka ịrụ ọrụ ngwa ngwa (opekata mpe ngwa ngwa karịa iji aka na-agbanwe ụdị tebụl data na ndabere phpMyAdmin).
• Enwere ngụkọta nke aha tebụl 13. Mgbe emechara ntụgharị, tinye "exit"kwụsị.

Mee MyISAM ka ọ bụrụ injin ndabara

Mgbe emechara ntughari, a na-atụ aro ka mechie injin InnoDB wee tọọ MyISAM n'ọdịnihuMySQLengine ndabara.

Otu esi edobe ndabara iji jiri ụdị nchekwa data dị ka "ỌMISI"?

Chen WeiliangNyeOgwe njikwa CWPMmemme bụ ihe atụ, na usoro ọrụ bụ ndị a:

1) Dezie faịlụ /etc/my.cnf wee chọta folda ebubata !includedir /etc/my.cnf.d

2) Gaa na /etc/my.cnf.d nchekwa

3) Mepee faịlụ server.cnf

4) Chọta "default_storage_engine"

5) Tinye n'okpuru "#default_storage_engine=InnoDB":

default_storage_engine = MYISAM

6) Mgbe ịchekwaa, malitegharịa ọrụ MySQL:

service mysqld restart

Ma ọ bụ malitegharịa ọrụ Mariadb:

systemctl restart mariadb

Usoro a dị nnọọ mfe, ọ bụrụhaala na ị na-agbaso ọrụ ahụ, ị ​​​​nwere ike mezue mgbanwe ahụ. nkuzi a kwụsịrị ebe a!