MariaDB on MacOS: where is the default ibdata1 file?

Posted on

QUESTION :

Using Homebrew, I install MariaDB. It installs fine, but where is the ibdata1 file stored?

ANSWER :

From your MySQL Command Prompt, after root login,

SELECT @@datadir; should reveal the folder name

/usr/local/var/mysql is the default data directory for MariaDB.

It includes the ibdata1 file, log files, etc

Leave a Reply

Your email address will not be published. Required fields are marked *