CODEWITHSUNDEEP
mysqlmacos
OM The Eternity
OM The Eternity

Reputation: 16244

Where is the created MySQL database folder stored in Mac OS X?

Where is the created MySQL database folder stored in Mac OS X?

Upvotes: 22

Views: 25764

Answers (4)

swelbo
swelbo

Reputation: 21

I installed mysql (Ver 8.0.31 for macos13.0 on arm64) using Homebrew 3.6.12 the databases are stored here /opt/homebrew/var/mysql/

Upvotes: 2

DevonDahon
DevonDahon

Reputation: 8360

For me, it's in /usr/local/var/mysql.

Upvotes: 12

user579343
user579343

Reputation:

mysql is found in /usr/local/mysql. Databases are stored in the data folder (/usr/local/mysql/data/databasename). This may be different depending on how you installed it.

Upvotes: 3

Álvaro González
Álvaro González

Reputation: 146640

Run this query:

SELECT @@datadir, @@innodb_data_home_dir

The exact files and or subfolders depend on the exact database name and table types.

Upvotes: 36

Related Questions