phpMyAdmin e fetolela joang phetoho ea mofuta oa tafole ea data ea InnoDB ho enjene ea kamehla ea MyISAM?

phpMyAdminMokhoa oa ho fetolela mofuta oa tafole ea data ea InnoDB

Fetolela ho enjine ea kamehla ea MyISAM?

Ho khothalletsoa ho fetolela litafole tsa data tsa InnoDB ho litafole tsa data tsa MyISAM:

• E kopantsoe le litšoaneleho tsa li-blogs tsa botho, MyISAM e buelloa bakeng sa mekhoa ea li-blog tsa botho, hobane mesebetsi e ka sehloohong ea li-blogs ke ho bala le ho ngola, 'me ho na le ts'ebetso e fokolang ea ketane.
• KahooHo khetha enjene ea MyISAM ho etsa hore blog ea hau e bulehe mme leqephe le sebetse hantle ho feta blog ea enjine ea InnoDB.
• Ha e le hantle, ke tlhahiso ea botho feela, 'me li-bloggers tse ngata li khetha ka hloko ho latela maemo a sebele.

Malebela:ka tshokolohoMySQL databaseKa pel'a tafole, etsa bonnete ba hore u etsa "backup" ea database ▼

Mehato ea ho fetola ka letsoho mofuta oa tafole ea data mokokotlong oa phpMyAdmin

• 1) Kena ho taolo ea database ea phpMyAdmin;
• 2) Ka mor'a ho kena, tobetsa ka lehlakoreng le letšehali数据库;
• 3) Tobetsa kholomong e ka ho le letšehaliLitafole (mefuta eo e seng ea MyISAM);
• 4) Tobetsa "sebetsa"Taba;
• 5) Leqepheng la "Ts'ebetso", khetha ho fetola mofuta oa "Database Storage" ho "MOTSOALLE";
• 6) Tobetsa "e entsoe", phetoho e atlehile.

Taelo ea SSH ea ho fetolela ka potlako ho mofuta oa tafole ea database ea MyISAM

Bula SSH软件E hokahane leLinuxseva, kenya taelo e latelang▼

mysql -uroot -p

• Kenya phasewete ea phpMyAdmin ho kena ho SSH.
• hlaha "mysql>"U ka tsoela pele.
• Kena ka mokhoa o latelang, o nahanela maemo le ;.
• Lebitso la database le lebitso la tafole kaofela ke litlhaku tse nyane, 'me litaelo tse ling kaofela ke litlhaku tse kholo.Haeba ea ho qetela;

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

Tafole ea pele ea wp_commentmeta e fetotsoeng setšoantšong se ka tlase e bonts'oa ka katleho, ebe mabitso a tafole a ka fetoloa ka bonngoe▼

• Kenya SHOW TABLES;  Ka mor'a taelo, lebitso la tafole ea database le hlahisoa.
• Kopitsa le ho fetola lebitso la tafole le tsamaelanang ALTER TABLE 表名 ENGINE=MYISAM; Fetolela ho mofuta oa tafole ea database ea MyISAM bakeng sa ts'ebetso e potlakileng (bonyane ka potlako ho feta ho fetola ka letsoho mofuta oa tafole ea data mokokotlong oa phpMyAdmin).
• Ho na le mabitso a litafole a 13. Kamora hore phetoho e phethe, kenya "exit"tlohela.

Etsa MyISAM enjene ea kamehla

Kamora hore phetoho e phethoe, ho kgothaletswa ho koala enjene ea InnoDB, ebe o beha MyISAM nakong e tlang.MySQLenjene ea kamehla.

Mokhoa oa ho beha kamehla ho sebelisa mofuta oa "Database Storage" joalo ka "MOTSOALLE"?

Chen Weiliang以Sehlopha sa Taolo sa CWPLenaneo ke mohlala, 'me mehato ea ts'ebetso ke e latelang:

1) Fetola faele ea /etc/my.cnf 'me u fumane foldara e tsoang kantle ho naha !includedir /etc/my.cnf.d

2) Eya ho foldara /etc/my.cnf.d

3) Bula faele ea seva.cnf

4) Fumana "default_storage_engine"

5) Kenya ka tlase "#default_storage_engine=InnoDB":

default_storage_engine = MYISAM

6) Kamora ho boloka, qala ts'ebeletso ea MySQL hape:

service mysqld restart

Kapa qala hape tšebeletso ea Mariadb:

systemctl restart mariadb

Mokhoa o bonolo haholo, latela ts'ebetso feela, o ka phethela phetoho, thuto ena e felile!