Where are mysql data files (.MYD)

[Migrated From Jforum.net]

Hello,
I can't seem to find where JForum/Mysql stores its MYSQL Data files (e.g. jforum_forums.MYD). I can find the .frm files, but not the data. Any ideas? I'm using MacOSX with mysql 5.

Thanks,
JEff
[originally posted on jforum.net by netbracketsJeff]

[Migrated From Jforum.net]

netbracketsJeff wrote:Hello,
I can't seem to find where JForum/Mysql stores its MYSQL Data files (e.g. jforum_forums.MYD). I can find the .frm files, but not the data. Any ideas? I'm using MacOSX with mysql 5.

Thanks,
JEff

Jeff,

JForum doesn't change the "default" MySQL database directory.

I use Gentoo Linux, and MySQL stores it's DBs in the /var/lib/mysql/database_name directories which contain the .frm, .MYD, & .MYI files.

[originally posted on jforum.net by GatorBait3]

[Migrated From Jforum.net]

OK, thanks. Kind of weird, everything works great, but I'm not sure where all the MYD files are. I even did a full directory find, and it didn't turn up anything. I guess no biggie, I can do a dump and I can re-build from the dumped file.

Thanks,
Jeff
[originally posted on jforum.net by netbracketsJeff]

[Migrated From Jforum.net]

In Linux, you have to be running as root for the "locate" or "find" commands to actually find these files (due to permissions). Since OS X is *nix based, that may be the issue with you not finding the files.

Are you doing the search as the root user? If not, try su'ing to root then do the search.
[originally posted on jforum.net by GatorBait3]

[Migrated From Jforum.net]

netbracketsJeff wrote:Hello,
I can't seem to find where JForum/Mysql stores its MYSQL Data files (e.g. jforum_forums.MYD). I can find the .frm files, but not the data. Any ideas? I'm using MacOSX with mysql 5.

default:

/usr/local/mysql/data


[originally posted on jforum.net by MyJForum]