Kodi phpMyAdmin imatembenuza bwanji mtundu wa tebulo la InnoDB kukhala injini ya MyISAM?

phpMyAdminMomwe mungasinthire mtundu wa tebulo la InnoDB

Sinthani kukhala injini yokhazikika ya MyISAM?

Ndikofunikira kuti musinthe matebulo a data a InnoDB kukhala matebulo a data a MyISAM:

• Kuphatikizidwa ndi mawonekedwe a mabulogu amunthu, MyISAM imalimbikitsidwa pamakina aumwini abulogu, chifukwa ntchito zazikulu m'mabulogu ndikuwerenga ndi kulemba, ndipo pali magwiridwe antchito ochepa.
• ndipo kenakoKusankha injini ya MyISAM kumapangitsa kuti blog yanu ikhale yotseguka komanso tsamba labwino kwambiri kuposa blog ya injini ya InnoDB.
• Inde, ndi malingaliro aumwini, ndipo olemba mabulogu ambiri amasankha mosamala malinga ndi momwe zinthu zilili.

Malangizo:mu kutembenukaMySQL databasePamaso pa tebulo, onetsetsani kuti mwasunga zosunga zobwezeretsera ▼

Njira zosinthira pamanja mtundu wa tebulo la data kumbuyo kwa phpMyAdmin

• 1) Lowani ku phpMyAdmin database management;
• 2) Mukalowa, dinani kumanzere数据库;
• 3) Dinani pazanja lakumanzereMa data (amitundu omwe si a MyISAM);
• 4) Dinani "chogwira"Tsamba;
• 5) Patsamba la "Ntchito", sankhani kusintha mtundu wa "Database Storage" kukhala "MYISAM";
• 6) Dinani "zidachitidwa", kutembenuka kwapambana.

Sinthani mwachangu malamulo a SSH kukhala mitundu ya tebulo la MyISAM database

Tsegulani SSH软件Zolumikizidwa ndiLinuxseva, lowetsani lamulo ili▼

mysql -uroot -p

• Lowetsani mawu achinsinsi a phpMyAdmin kuti mulowe ku SSH.
• kuwonekera "mysql>“Mukhoza kupitiriza.
• Lowani mumtundu wotsatirawu, wokhala ndi vuto komanso ;.
• Dzina la database ndi dzina la tebulo onse ndi zilembo zazing'ono, ndipo malamulo ena onse ndi aakuluakulu.

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

Gome loyamba la wp_commentmeta lotembenuzidwa pachithunzi pansipa likuwonetsedwa bwino, ndiyeno mayina a tebulo akhoza kusinthidwa mmodzimmodzi▼

• lowani SHOW TABLES;  Pambuyo pa lamulo, dzina la tebulo la database likuwonetsedwa.
• Koperani ndikusintha dzina lolingana la tebulo ALTER TABLE 表名 ENGINE=MYISAM; Sinthani kukhala mtundu wa tebulo la MyISAM kuti mugwire ntchito mwachangu (ochepera mwachangu kuposa kusintha pamanja mtundu wa tebulo la data kumbuyo kwa phpMyAdmin).
• Pali mayina a tebulo okwana 13. Mukamaliza kutembenuza, lowetsani "exit"siyani.

Pangani MyISAM kukhala injini yokhazikika

Pambuyo kutembenuka kumalizidwa, tikulimbikitsidwa kutseka injini ya InnoDB, ndikuyika MyISAM mtsogolo.MySQLinjini yokhazikika.

Momwe mungakhazikitsire kusakhazikika kuti mugwiritse ntchito mtundu wa "Database Storage" ngati "MYISAM"?

Chen Weiliang以CWP Control PanelPulogalamuyi ndi chitsanzo, ndipo njira zogwirira ntchito ndi izi:

1) Sinthani fayilo ya /etc/my.cnf ndikupeza foda yomwe yatumizidwa kunja !includedir /etc/my.cnf.d

2) Pitani ku /etc/my.cnf.d chikwatu

3) Tsegulani fayilo ya seva.cnf

4) Pezani "default_storage_engine"

5) Onjezani pansipa "#default_storage_engine=InnoDB":

default_storage_engine = MYISAM

6) Mukasunga, yambitsaninso ntchito ya MySQL:

service mysqld restart

Kapena yambitsaninso ntchito ya Mariadb:

systemctl restart mariadb

• Njirayi ndiyosavuta, ingotsatirani ntchitoyi, mutha kumaliza kusinthidwa, phunziroli latha!

🛠️✨Mukufuna kudziwa momwe mungasinthire nkhokwe yanu ya MySQL kuchokera ku MyISAM kupita ku InnoDB? Nkhaniyi imakupatsirani malangizo atsatanetsatane omwe ndi osavuta kutsatira!

👇Analimbikitsa kupitiriza kuwerenga👇

🔗Momwe mungasinthire MyISAM kukhala injini yosungira ya InnoDB mu database ya MySQL?

Mukawerenga, mupeza kuti kutembenuza MyISAM kukhala InnoDB ndikosavuta kuposa momwe mukuganizira! Dinani ulalo ndikuyamba kuphunzira tsopano! 💻📚