I-phpMyAdmin iluguqula kanjani uhlobo lwethebula ledatha ye-InnoDB libe yinjini ezenzakalelayo ye-MyISAM?

Ungashintsha kanjani uhlobo lwethebula le-InnoDB ku-phpMyAdmin?

Guqula ibe yinjini ezenzakalelayo ye-MyISAM?

Kunconywa ukuthi uguqule amathebula edatha e-InnoDB abe amathebula edatha e-MyISAM:

• Ihlanganiswe nezici zamabhulogi omuntu siqu, i-MyISAM inconywa ezinhlelweni zebhulogi yomuntu siqu, ngoba imisebenzi eyinhloko kumabhulogi ukufunda nokubhala, futhi kunemisebenzi embalwa yamaketanga.
• NgakhoUkukhetha injini ye-MyISAM kwenza ibhulogi yakho ivuleke futhi ikhasi lisebenze kahle kunebhulogi yenjini ye-InnoDB.
• Yebo, kuyisiphakamiso somuntu siqu, futhi ama-blogger amaningi akhetha ngokucophelela ngokuya ngesimo sangempela.

Isikhumbuzo esinobungane: Sicela wenze isipele sedatha yakho ye-MySQL ngaphambi kokuguqula noma yimaphi amathebula. ▼

Izinyathelo zokushintsha mathupha uhlobo lwethebula ledatha kungemuva le-phpMyAdmin

• 1) Ngena ngemvume ekuphathweni kwedatha ye-phpMyAdmin;
• 2) Ngemva kokungena ngemvume, chofoza kukholamu kwesokunxele数据库；
• 3) Chofoza kukholamu yesokunxeleAmathebula edatha (izinhlobo okungezona eze-MyISAM)；
• 4) Chofoza "iyasebenza"Ithebhu;
• 5) Ekhasini elithi "Ukusebenza", khetha ukushintsha uhlobo lwe-"Database Storage" ukuze "I-MyISAM";
• 6) Chofoza "sebenzisa", ukuguqulwa kuphumelele.

Guqula ngokushesha imiyalo ye-SSH ibe izinhlobo zetafula lesizindalwazi se-MyISAM

Vula isofthiwe yakho ye-SSH bese uxhuma kuseva ye-Linux . Faka umyalo olandelayo: ▼

mysql -uroot -p

• Faka iphasiwedi ye-phpMyAdmin ukuze ungene ku-SSH.
• vela "mysql>“Ungaqhubeka.
• Faka ngefomethi elandelayo, uzwela kakhulu futhi ;.
• Igama lesizindalwazi kanye negama lethebula zonke zingosonhlamvukazi abancane, futhi yonke eminye imiyalo ingosonhlamvukazi.Uma eyokugcina ingafakwanga, umyalo ngeke usebenze.

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

Ithebula lokuqala le-wp_commentmeta eliguqulelwe kumfanekiso ongezansi liboniswa ngempumelelo, bese amagama ethebula angashintshwa ngalinye ngalinye▼

• ngena SHOW TABLES;  Ngemva komyalo, igama lethebula lesizindalwazi liyavezwa.
• Kopisha futhi ulungise igama lethebula elihambisanayo ALTER TABLE 表名 ENGINE=MYISAM; Guqulela kuhlobo lwethebula lesizindalwazi se-MyISAM ukuze usebenze ngokushesha (okungenani ngokushesha kunokushintsha mathupha uhlobo lwethebula ledatha kungemuva le-phpMyAdmin).
• Kunamagama ethebula angu-13 esewonke. Ngemva kokuqedwa kokuguqulwa, faka "exit"yeka.

Yenza i-MyISAM ibe injini ezenzakalelayo

Ngemva kokuthi ukuguqulwa sekuqediwe, kunconywa ukuthi ucime injini ye-InnoDB bese usetha i-MyISAM njengenjini ezenzakalelayo ye -MySQL kusukela manje kuqhubeke.

Ngingayibeka kanjani uhlobo lwesitoreji sedatha oluzenzakalelayo lube yi-" MyISAM "?

UChen Weiliang usebenzisa uhlelo lwephaneli yokulawula ye-CWP njengesibonelo, futhi izinyathelo zokusebenza zimi kanje:

1) Hlela ifayela /etc/my.cnf bese uthola ifolda engenisiwe !includedir /etc/my.cnf.d

2) Iya kufolda /etc/my.cnf.d

3) Vula ifayela le-server.cnf

4) Thola "default_storage_engine"

5) Engeza ngezansi "#default_storage_engine=InnoDB":

default_storage_engine = MYISAM

6) Ngemva kokulondoloza, qala kabusha isevisi ye-MySQL:

service mysqld restart

Noma qala kabusha isevisi ye-Mariadb:

systemctl restart mariadb

• Indlela ilula kakhulu, vele ulandele ukusebenza, ungaqedela ukuguqulwa, lesi sifundo sesiphelile!

🛠️✨Ufuna ukwazi ukuthi ungayiguqula kanjani i-database yakho ye-MySQL isuke ku-MyISAM iye ku-InnoDB? Lesi sihloko sikunikeza isiqondiso esibanzi okulula ukusilandela!

👇Kunconyiwe ukuqhubeka nokufunda👇

🔗Ungayiguqula kanjani inqwaba i-MyISAM ibe injini yokugcina ye-InnoDB kusizindalwazi se-MySQL?

Ngemuva kokufunda, uzothola ukuthi ukuguqula i-MyISAM ibe yi-InnoDB kulula kakhulu kunokuba ucabanga! Chofoza isixhumanisi bese uqala ukufunda manje! 💻📚