WampServer

innodb-default-row-format=dynamic


Retionale: Prevent errors when importing from production databases with this settings

Please see Previous answer

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-



Edited 1 time(s). Last edit at 03/03/2022 04:14PM by RiggsFolly.

RiggsFolly Wrote:
-------------------------------------------------------
> Please see
> [url=http://forum.wampserver.com/read.php?2,163191
> ,163192#msg-163192]Previous answer[/url]


Sure.

In this specific case however the wampserver team decided to go aganst the standard [mariadb.com]. Apparently since 10.2.2 the default for the default_row_format is dynamic and not compact.


Is there a reason why a learning user should be using compact?

Hi,

Contrary to the various versions of PHP which are distributed by php.net with examples of php.ini, the versions of MariaDB as well as MySQL are distributed without any example of my.ini.

I'm not going to spend my time reading the MariaDB and MySQL documentations for each new version to see what the default values have changed.

If you have any comments, please ask MariaDB and MySQL to integrate a standard my.ini file in each new version.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

I understand.

I did read throw the manuals and rest assured adding

innodb-default-row-format=dynamic

to the ini does have it benefits, not only for me but for everyone using multi-byte character sets. MariaDB will through very confusing error messages at the user when this is the case.

On that note. If the my.ini deployed is never changed, for understandable reasons, this might have in some point of time have detrimental effects. The world changes

Btw I even recommend to remove the setting altogether and let MariaDB decide by commenting it:

;innodb-default-row-format = compact