Comments - mariadb-install-db.exe - defaults-file - unknown variable
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
Thanks for your post. I tried to use this option --config, but this is also giving the same error of "unknown variable". When I run the --help option, neither --defaults-file or --config are listed. I am using MariaDB 10.5. My aim is to install the MariaDB program files, and then initialize the database folder structure with a settings template from an INI file. If not able to use INI template, then just seeking to know how to initialize database so the settings/options are set as follows:
default-storage-engine=MyISAM max_allowed_packet=40M max_connections=3000 port=3306 sql_mode='' explicit_defaults_for_timestamp=1 innodb_file_per_table=1 myisam_recover_options=OFF optimizer_switch=split_materialized=OFF
I know have something silly missing in what I am doing. But I do not have the knowledge yet to know what.
There is no --config in the 10.5 . If you look into https://mariadb.com/kb/en/mysql_install_dbexe/ which I mentioned previously, you'll find --config was introduced in 10.6.1, also you won't any mentioning of --defaults-file there.
Now, if your version does not support --config, you'd need to do something else. Lilke a tool which can be used to automate ini editing on the command line. Quick googling finds https://github.com/dbohdan/initool , which has prebuilt windows binaries. stackoverflow find something about powershell https://stackoverflow.com/questions/55338755/function-get-inicontent-is-not-recognized-ini-file-support-inpowershell (this module needs to be installed).