Ko phpMyAdmin inoshandura sei InnoDB data tafura mhando shanduko kuMyISAM default injini?

phpMyAdminMaitiro ekushandura InnoDB data tafura mhando

Shandura kuMyISAM default injini?

Inokurudzirwa kushandura InnoDB data matafura kuti MyISAM data matafura:

• Yakasanganiswa nehunhu hwemabloggi ega, MyISAM inokurudzirwa kune yega blog masisitimu, nekuti iyo mikuru mashandiro mumablogi kuverenga nekunyora, uye kune mashoma echeni mashandiro.
• uye zvakadaroKusarudza injini yeMyISAM kunoita kuti bhurogi rako rivhurike uye peji rishande zvakanyanya kupfuura iyo InnoDB injini blog.
• Ehe, ingori zano remunhu, uye vazhinji vanoblogi vanosarudza nekungwarira zvinoenderana nemamiriro chaiwo.

Mazano:mukutendeukaMySQL databasePamberi petafura, ita shuwa kuita dhatabhesi yekuchengetedza ▼

Matanho ekushandura nemaoko rudzi rwetafura yedata mu phpMyAdmin kumashure

• 1) Pinda kune phpMyAdmin dhatabhesi manejimendi;
• 2) Mushure mekupinda mukati, tinya pakona yekuruboshweDhatabhesi;
• 3) Dzvanya pakona yekuruboshweDatatables (asiri-MyISAM marudzi);
• 4) Dzvanya "kushanda"Tab;
• 5) Mu "Operation" peji, sarudza kushandura "Database Storage" mhando kuti "MyISAM";
• 6) Dzvanya"shandisa", kutendeuka kwabudirira.

SSH rairo yekukurumidza kushandura kune MyISAM dhatabhesi tafura mhando

Vhura SSH软件Yakabatanidzwa neLinuxserver, isa murairo unotevera▼

mysql -uroot -p

• Isa iyo phpMyAdmin password kuti upinde muSSH.
• Kuonekwa "mysql>"Unogona kuenderera.
• Pinda mune inotevera fomati, kuva nyaya-sensitive uye ;.
• Zita redatabase uye zita retafura zvese zvimiro zvidiki, uye mimwe mirairo ine mavara makuru Kana iyo yekupedzisira ; isina kuiswa, murairo haushande.

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

Yekutanga wp_commentmeta tafura yakashandurwa mumufananidzo pazasi inoratidzwa zvinobudirira, uye ipapo mazita etafura anogona kushandurwa rimwe nerimwe▼

• kupinda SHOW TABLES;  Mushure mekuraira, zita retafura re database rinoratidzwa.
• Kopa uye shandura zita retafura rinoenderana ALTER TABLE 表名 ENGINE=MYISAM; Shandura kuMyISAM dhatabhesi tafura yemhando yekukurumidza mashandiro (zvirinani nekukurumidza pane kushandura nemaoko rudzi rwetafura yedata mu phpMyAdmin kumashure).
• Pane mazita ematafura gumi nematatu. Kana shanduko yapera, isa "exit"siya.

Ita MyISAM ive injini yakasarudzika

Mushure mekushandura kwapera, zvinokurudzirwa kuvhara injini yeInnoDB, uye wozoisa MyISAM kune ramangwana.MySQLiyo default injini.

Maitiro ekuseta default kushandisa "Database Storage" mhando se "MyISAM"?

Chen Weiliang以CWP Control PanelIyo purogiramu muenzaniso, uye matanho ekushanda ndeaya anotevera:

1) Rongedza iyo /etc/my.cnf faira uye tsvaga iyo yakaunzwa folda !includedir /etc/my.cnf.d

2) Enda ku /etc/my.cnf.d forodha

3) Vhura iyo server.cnf faira

4) Tsvaga "default_storage_engine"

5) Wedzera pazasi "#default_storage_engine=InnoDB":

default_storage_engine = MYISAM

6) Mushure mekuchengetedza, tangazve iyo MySQL sevhisi:

service mysqld restart

Kana kuti tangazve basa reMariadb:

systemctl restart mariadb

Iyo nzira iri nyore kwazvo, ingotevera oparesheni, unogona kupedzisa kugadziridza, iyi tutori yapera!