Re: Changing Data directory

[Rick James]

MyISAM and InnoDB use the same directory. (Unless Administrator is talking about something different.)

Here's the structure (partial):
.../mysql/data/db1/ -- where stuff in database `db1` is stored
.../mysql/data/db2/
.../mysql/data/ibdata1 -- general 'tablespace' for InnoDB

Within a database directory (eg db1), you might find
For a MyISAM table `abc`: abc.frm, abc.MYD, abc.MYI
For an InnoDB table `def`: def.frm and maybe def.ibd
For PARTITION, etc: other things.

Assuming you have found the /data/ directory, suggest you create a little table with ENGINE=MyISAM and see if you can find the 3 files it creates.

What is your goal? To have all your data somewhere else, like on a different drive? Then you may have already achieved it.

If you want to have various tables in various places, see the options on CREATE TABLE.