Sidee phpMyAdmin u beddelaa nooca miiska xogta InnoDB u beddelashada mashiinka caadiga ah ee MyISAM?

phpMyAdminSida loo beddelo InnoDB xogta miiska nooca

U beddelo mashiinka asalka ah ee MyISAM?

Waxaa lagu talinayaa in loo rogo miisaska xogta InnoDB shaxda xogta MyISAM:

• Marka lagu daro sifooyinka baloogyada gaarka ah, MyISAM waxaa lagula talinayaa nidaamyada blog-ka ee shakhsi ahaaneed, sababtoo ah hawlgallada ugu muhiimsan ee blogyada waa akhrinta iyo qorista, waxaana jira hawlgallo silsilado ah.
• MarkaDoorashada mishiinka MyISAM waxay ka dhigaysaa balooggaga mid furan oo bogga ka waxtar badan marka loo eego baloogga injiinka InnoDB.
• Dabcan, waa uun talo soo jeedin shakhsi ah, iyo inta badan bloggers ayaa si taxadar leh u doortaan xaaladda dhabta ah.

Talooyin:beddeliddadatabase MySQLJadwalka ka hor, hubso inaad samaysid kayd kayd ah ▼

Tallaabooyinka gacanta lagu beddelayo nooca miiska xogta ee asalka phpMyAdmin

• 1) Gal maamulka xogta phpMyAdmin;
• 2) Kadib markaad gasho, dhagsii tiirka bidix数据库;
• 3) Guji tiirka bidixJadwalka xogta (noocyada aan ahayn MyISAM);
• 4) Guji"shaqeeya" Tab;
• 5) Bogga "Hawlgalka", dooro si aad u bedesho "Kaydinta Database" nooca "MIISAM";
• 6) Guji"fuliyay", beddelaaddu waa guul.

Amarka SSH si dhakhso ah loogu beddelo nooca miiska xogta MyISAM

Fur SSH软件Ku xidhanLinuxserver, geli amarka soo socda▼

mysql -uroot -p

• Geli furaha phpMyAdmin si aad u gasho SSH.
• Muuqda"mysql>"Waad sii wadi kartaa.
• Ku qor qaabkan soo socda, adigoo kiis xasaasi ah iyo ;.
• Magaca database-ka iyo magaca miiska dhamaantood waa far-yar, inta soo hartayna waa far waaweyn, haddii kan u dambeeya; aan la gelin, amarku ma dhaqan gelayo.

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

Shaxda wp_commentmeta ugu horraysa ee shaxanka hoose loo beddelay si guul leh ayaa loo soo bandhigay, ka dibna magacyada shaxda mid mid ayaa loo rogi karaa ▼

• Gelinta SHOW TABLES;  Amarka ka dib, magaca miiska macluumaadka ayaa la soo bandhigay.
• Nuqul oo wax ka beddel magaca miiska u dhigma ALTER TABLE 表名 ENGINE=MYISAM; U beddelo nooca miiska xogta ee MyISAM ee hawlgallada degdegga ah (ugu yaraan si ka dhakhso badan adigoo gacanta ku beddelaya nooca miiska xogta ee asalka phpMyAdmin).
• Waxaa jira wadar ahaan 13 magacyo miiska ah. Ka dib marka beddelidda la dhammeeyo, geli "exit"jooji

Ka dhig MyISAM mashiinka caadiga ah

Ka dib markii beddelka la dhammeeyo, waxaa lagu talinayaa in la xiro engine InnoDB, ka dibna dhigay MyISAM mustaqbalkaMySQLmishiinka caadiga ah.

Sida loo dejiyo default si loo isticmaalo "Database Storage" nooca sida "MIISAM"?

Chen WeiliangKuCWP Control PanelBarnaamijku waa tusaale, tillaabooyinka hawlgalkuna waa sida soo socota:

1) Tafatir faylka /etc/my.cnf oo hel galka la soo dejiyay !includedir /etc/my.cnf.d

2) Tag faylka /etc/my.cnf.d

3) Furo faylka server-ka.cnf

4) Soo hel "default_storage_engine"

5) Hoos ku dar "#default_storage_engine=InnoDB":

default_storage_engine = MYISAM

6) Ka dib markaad kaydiso, dib u bilaw adeegga MySQL:

service mysqld restart

Ama dib u bilow adeegga Mariadb:

systemctl restart mariadb

Habka waa mid aad u fudud, kaliya raac qalliinka, waxaad buuxin kartaa wax ka beddelka, casharkan waa dhammaaday!