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