Yuav ua li cas phpMyAdmin hloov InnoDB cov ntaub ntawv rooj hom hloov dua siab tshiab rau MyISAM default engine?

phpmyadminYuav ua li cas hloov InnoDB cov ntaub ntawv rooj hom

Hloov mus rau MyISAM default engine?

Nws raug pom zoo kom hloov InnoDB cov ntaub ntawv rau MyISAM cov ntaub ntawv:

• Ua ke nrog cov yam ntxwv ntawm tus kheej blogs, MyISAM tau pom zoo rau tus kheej blog systems, vim hais tias cov haujlwm tseem ceeb hauv blogs yog nyeem thiab sau ntawv, thiab muaj ob peb txoj haujlwm saw.
• thiab li ntawdXaiv lub cav MyISAM ua rau koj qhov blog qhib thiab nplooj ntawv ua haujlwm zoo dua li InnoDB cav blog.
• Tau kawg, nws tsuas yog ib qho kev tawm tswv yim ntawm tus kheej, thiab feem ntau cov bloggers xaiv ua tib zoo raws li qhov xwm txheej tiag tiag.

Cov Lus Qhia:hauv kev hloov dua siab tshiabMySQL databaseUa ntej lub rooj, nco ntsoov ua cov ntaub ntawv thaub qab ▼

Cov kauj ruam los hloov cov ntaub ntawv hom lus hauv phpMyAdmin keeb kwm yav dhau

• 1) Nkag mus rau phpMyAdmin database tswj;
• 2) Tom qab nkag rau hauv, nyem rau ntawm kab laug sabCov Ntaub Ntawv;
• 3) Nyem rau ntawm kab laug sabDatatables (tsis yog MyISAM hom);
• 4) Nyem "kev khiav hauj lwm"Tab;
• 5) Hauv nplooj ntawv "Kev Ua Haujlwm", xaiv los hloov "Database Storage" hom rau "MyISAM";
• 6) Nyem "siv", kev hloov dua siab tshiab tau ua tiav.

SSH hais kom hloov sai sai rau MyISAM database table type

Qhib SSHSoftwareTxuas nrogLinuxserver, nkag mus rau cov lus txib nram qab no ▼

mysql -uroot -p

• Nkag mus rau phpMyAdmin lo lus zais nkag mus rau SSH.
• Tshwm "mysql>"Koj tuaj yeem txuas ntxiv.
• Nkag mus rau hauv hom ntawv hauv qab no, ua tus lej-sensitive thiab ;.
• Lub npe database thiab lub npe lub rooj yog tag nrho cov ntawv me, thiab cov lus txib yog tus loj, Yog tias qhov kawg ; tsis nkag mus, cov lus txib yuav tsis siv.

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

Thawj wp_commentmeta lub rooj hloov dua siab tshiab nyob rau hauv daim duab hauv qab no tau tshwm sim ua tiav, thiab tom qab ntawd cov npe cov lus tuaj yeem hloov pauv ib qho los ntawm ib qho ▼

• Cov lus qhia SHOW TABLES;  Tom qab qhov hais kom ua, lub database lub rooj lub npe yog tso tawm kom pom.
• Luam thiab hloov kho lub npe rooj sib tham ALTER TABLE 表名 ENGINE=MYISAM; Hloov mus rau MyISAM cov ntaub ntawv hom lus rau kev ua haujlwm ceev (tsawg kawg sai dua li manually hloov cov ntaub ntawv hom hauv phpMyAdmin keeb kwm yav dhau).
• Muaj tag nrho ntawm 13 lub rooj npe. Tom qab hloov dua siab tshiab, sau "exit" tawm.

Ua MyISAM lub tshuab ua ntej

Tom qab kev hloov dua siab tshiab tiav, nws raug nquahu kom kaw lub cav InnoDB, thiab tom qab ntawd teeb tsa MyISAM rau yav tom ntejMySQLlub default engine.

Yuav ua li cas los teeb tsa lub neej ntawd siv "Database Storage" hom li "MyISAM"?

Chen WeiliangRauCWP Control Vaj Huam Sib LuagQhov kev zov me nyuam yog ib qho piv txwv, thiab cov kauj ruam ua haujlwm yog raws li hauv qab no:

1) Kho cov ntaub ntawv /etc/my.cnf thiab nrhiav cov ntawv tais ceev tseg !includedir /etc/my.cnf.d

2) Mus rau lub nplaub tshev /etc/my.cnf.d

3) Qhib cov ntaub ntawv server.cnf

4) Nrhiav "default_storage_engine"

5) Ntxiv hauv qab no "#default_storage_engine=InnoDB":

default_storage_engine = MYISAM

6) Tom qab txuag, rov pib qhov kev pabcuam MySQL:

service mysqld restart

Los yog rov pib qhov kev pabcuam Mariadb:

systemctl restart mariadb

Txoj kev no yooj yim heev, tsuas yog ua raws li kev ua haujlwm, koj tuaj yeem ua tiav qhov kev hloov kho, qhov kev qhia no dhau lawm!