k...@munnari.oz.au (Robert Elz) writes:
> Date: Wed, 16 Jan 2019 19:10:54 -0800
> From: John Nemeth <jnem...@cue.bc.ca>
> Message-ID: <201901170310.x0h3asgp014...@server.cornerstoneservice.ca>
> | 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: mlel...@serpens.de
"A potential Snark may lurk in every tree."
