As I would like to move those files from one server to another server, while the database is offline.
It should be stored in: /usr/local/mysql/data
When you use mysql installed via Homebrew, you should find your database folders and files in
If you've installed MySQL by running MAMP on the Mac, then the files are stored at
For MAMP Pro, the files should be in
/Library/Application Support/appsolute/MAMP PRO/db/mysql
Stack Overflow answer that addresses MAMP / Sequel Pro installations here: https://stackoverflow.com/questions/7341897/where-does-sequel-pro-mamp-store-local-databases