如何在XAMPP中将默认存储引擎设置为InnoDB [英] How to set the default storage engine to InnoDB in XAMPP

问题描述

如何在Linux XAMPP 1.7.3中将default-storage-engine设置为InnoDB?

How do I set the default-storage-engine to InnoDB in Linux XAMPP 1.7.3?

推荐答案

最简单的方法是转到mysql配置文件(Windows中为my.ini，Linux中为my.cnf)并添加以下内容:

The easiest way is just to go to the mysql config file (my.ini in windows, my.cnf in Linux) and just add this:

[mysqld]
default-storage-engine=InnoDB

这假定您已启用InnoDB，这是另一个主题，但是有大量答案关于如何做到这一点.您始终可以在XAMPP上的phpMyAdmin中检查默认存储引擎:只需单击服务器，然后单击引擎，然后单击特定引擎(例如MyISAM)，然后查看是否显示MyISAM is the default storage engine on this MySQL server.

This assumes that you have enabled InnoDB, which is another topic, but there are plenty of answers on how to do this. You can always check the default storage engine in phpMyAdmin on XAMPP: Just click on the server, then on engines, then on a particular engine (like MyISAM), and then see if it says MyISAM is the default storage engine on this MySQL server.

这篇关于如何在XAMPP中将默认存储引擎设置为InnoDB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！