mariadb-install-db.exe - defaults-file - unknown variable

Hi. I am just seeking some advise or assistance with initialising a new database data folder for a new MariaDB installation. I am referring to this site for information, and am just stuck as one of the documented parameters is not working for me.

Web link reference: https://mariadb.com/kb/en/mysql_install_db/

The command I am running is: mariadb-install-db.exe --defaults-file="C:\Temp\my.ini"

I then get this error: unknown variable 'defaults-file=C:\Temp\my.ini'

I am running this command in CMD on a Windows 10 PC.

Hoping to get advice on what I am missing here to achieve initialising a new server install with a custom my.ini file.

Answer Answered by Vladislav Vaintroub in this comment.

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).

Comments

Comments loading...
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.