Re: choosing a lightweight database

[mlelstv%serpens.de@localhost (Michael van Elst)]

kre%munnari.OZ.AU@localhost (Robert Elz) writes:

>    Date:        Wed, 16 Jan 2019 19:10:54 -0800
>    From:        John Nemeth <jnemeth%cue.bc.ca@localhost>
>    Message-ID:  <201901170310.x0H3AsGP014656%server.cornerstoneservice.ca@localhost>
>  |      If you're using the package, then it is:
>  | mysqld=YES              mysqld_datadir="/usr/local/mysql"

>But doesn't that put all databases there?   That's not the idea, I
>just want one partticular database in one particular directory,
>everything else can go where it chooses, or some default if
>it doesn't.

It's just the default place for your data and the place where system
tables are located.

For classic 'MyISAM' tables you can specify a directory.
For things like 'InnoDB' or 'NDB' tables you can create a "tablespace"
in a different location and create the table there.

Other database engines have a similar tablespace concept.

-- 
-- 
                                Michael van Elst
Internet: mlelstv%serpens.de@localhost
                                "A potential Snark may lurk in every tree."