lhungil

If using the database engine “MyISAM”, case sensitivity of database and table names can vary on different Operating Systems and based upon the MySQL configuration. REF: https://dev.mysql.com/doc/refman/5.5/en/identifier-case-sensitivity.html

If using the database engine “InnoDB”, on Windows it always uses lowercase database and table names (irregardless of the MySQL configuration). REF: https://dev.mysql.com/doc/refman/5.5/en/innodb-restrictions.html

WordPress (and most database installation tools) will use the default database engine configured by the database server (unless requested otherwise). As of MySQL 5.5, the default database engine is InnoDB. REF: https://dev.mysql.com/doc/refman/5.5/en/innodb-default-se.html

WordFence uses camelCased tables names. Doing so complicates any database export / import between different database servers as case sensitivity regarding database and table names is not guaranteed consistent (even from UNIX to UNIX). I would strongly recommend future versions of WordFence use snake_case names (or all lowercase names) to avoid complications.

In addition to server migration (from an old server to a new server), people maintaining separate “live” and “development” servers to allow for testing without impacting the “production” website are also impacted by the use of camelCase table names.