I-phpMyAdmin iluguqula kanjani uhlobo lwethebula ledatha ye-InnoDB libe yinjini ezenzakalelayo ye-MyISAM?

phpMyAdminUngaluguqula kanjani uhlobo lwethebula ledatha ye-InnoDB

Guqula ibe yinjini ezenzakalelayo ye-MyISAM?

Kunconywa ukuthi uguqule amathebula edatha e-InnoDB abe amathebula edatha e-MyISAM:

• Ihlanganiswe nezici zamabhulogi omuntu siqu, i-MyISAM inconywa ezinhlelweni zebhulogi yomuntu siqu, ngoba imisebenzi eyinhloko kumabhulogi ukufunda nokubhala, futhi kunemisebenzi embalwa yamaketanga.
• NgakhoUkukhetha injini ye-MyISAM kwenza ibhulogi yakho ivuleke futhi ikhasi lisebenze kahle kunebhulogi yenjini ye-InnoDB.
• Yebo, kuyisiphakamiso somuntu siqu, futhi ama-blogger amaningi akhetha ngokucophelela ngokuya ngesimo sangempela.

Amathiphu:ekuguqulweniMySQL databaseNgaphambi kwetafula, qiniseka ukuthi wenza ikhophi yasenqolobaneni egciniwe ▼

Izinyathelo zokushintsha mathupha uhlobo lwethebula ledatha kungemuva le-phpMyAdmin

• 1) Ngena ngemvume ekuphathweni kwedatha ye-phpMyAdmin;
• 2) Ngemva kokungena ngemvume, chofoza kukholamu kwesokunxele数据库；
• 3) Chofoza kukholamu yesokunxeleAmathebula edatha (izinhlobo okungezona eze-MyISAM)；
• 4) Chofoza "iyasebenza"Ithebhu;
• 5) Ekhasini elithi "Ukusebenza", khetha ukushintsha uhlobo lwe-"Database Storage" ukuze "I-MyISAM";
• 6) Chofoza "sebenzisa", ukuguqulwa kuphumelele.

Guqula ngokushesha imiyalo ye-SSH ibe izinhlobo zetafula lesizindalwazi se-MyISAM

Vula i-SSH软件Kuxhunywe kuLinuxiseva, faka umyalo olandelayo▼

mysql -uroot -p

• Faka iphasiwedi ye-phpMyAdmin ukuze ungene ku-SSH.
• vela "mysql>“Ungaqhubeka.
• Faka ngefomethi elandelayo, uzwela kakhulu futhi ;.
• Igama lesizindalwazi kanye negama lethebula zonke zingosonhlamvukazi abancane, futhi yonke eminye imiyalo ingosonhlamvukazi.Uma eyokugcina ingafakwanga, umyalo ngeke usebenze.

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

Ithebula lokuqala le-wp_commentmeta eliguqulelwe kumfanekiso ongezansi liboniswa ngempumelelo, bese amagama ethebula angashintshwa ngalinye ngalinye▼

• ngena SHOW TABLES;  Ngemva komyalo, igama lethebula lesizindalwazi liyavezwa.
• Kopisha futhi ulungise igama lethebula elihambisanayo ALTER TABLE 表名 ENGINE=MYISAM; Guqulela kuhlobo lwethebula lesizindalwazi se-MyISAM ukuze usebenze ngokushesha (okungenani ngokushesha kunokushintsha mathupha uhlobo lwethebula ledatha kungemuva le-phpMyAdmin).
• Kunamagama ethebula angu-13 esewonke. Ngemva kokuqedwa kokuguqulwa, faka "exit"yeka.

Yenza i-MyISAM ibe injini ezenzakalelayo

Ngemuva kokuthi ukuguqulwa kuqediwe, kunconywa ukuvala injini ye-InnoDB, bese usetha i-MyISAM esikhathini esizayo.MySQLinjini ezenzakalelayo.

Ungasetha kanjani okuzenzakalelayo ukuze usebenzise uhlobo lwe-"Database Storage" njengokuthi "I-MyISAM"?

U-Chen WeiliangToIphaneli yokulawula ye-CWPUhlelo luyisibonelo, futhi izinyathelo zokusebenza zimi kanje:

1) Hlela ifayela /etc/my.cnf bese uthola ifolda engenisiwe !includedir /etc/my.cnf.d

2) Iya kufolda /etc/my.cnf.d

3) Vula ifayela le-server.cnf

4) Thola "default_storage_engine"

5) Engeza ngezansi "#default_storage_engine=InnoDB":

default_storage_engine = MYISAM

6) Ngemva kokulondoloza, qala kabusha isevisi ye-MySQL:

service mysqld restart

Noma qala kabusha isevisi ye-Mariadb:

systemctl restart mariadb

Indlela ilula kakhulu, vele ulandele ukusebenza, ungaqedela ukuguqulwa, lesi sifundo sesiphelile!