Comments - Controlling the Database Locations

3 years, 4 months ago Ian Jones
This comment has the status of 'removed' and can only be seen by you.

OK - I've found Solutions to my questions raised above... After digging into the Oracle MySQL documentation and "inferring" back to the MariaDB Windows Installation I've worked out and successfully tried the following:

Qn 1. "How can I safely relocate the system database etc. to a new (Data) location...?" You cannot. MariaDB does not seem to support MOVE DATABASE capabilities directly. (Maybe possible indirectly.) BUT a solution (for me) was to de-install MariaDB and re-install it via the Windows MSI installer but specifying the DATA location to where I wanted it. The WinMSI installer allows this but it's not intuitively obvious how to do it. The Win Installation guide (at https://mariadb.com/kb/en/library/installing-mariadb-msi-packages-on-windows/ ) says "To change the data directory location, select "Database instance" in the feature tree, and use the "Browse" button to point to another place." Well, that works once you've decoded its meaning.

2. "T'would be better if the standard installation process allowed the installer to choose where to put the system and user databases and made the necessary installation/configuration adjustments." Well - as above, it does do so. But in my view it does not make the method very obvious. Could be clearer.

3. And I'm still strongly of the view MariaDB should not default to putting the Databases under the /Program Files/ folder. That really is to be discouraged strongly. Windows has a /Progam Data/ folder which would be a better default. Or just encourage (even force) the installer to specify their own choice of location.

4. I've also picked up that there's a way to "point" MariaDB to where your individual databases are. By default they sit as sub-folders under the Data path. But I've not yet figured out exactly what the "point" method is and how to use it. Again, a case where the MariaDB documentation lacks clarity.

 
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.