Change mysql db location when installed with homebrew

Question

I just installed mysql via homebrew and I wanted to change the location where mysql stores the databases. All the stuff I've found so far online have paths that I don't understand and don't exist on my machine (OSX 10.8).

Any help is greatly appreciated. Thanks.

Sam Aleksov · Accepted Answer · 2013-07-20 00:20:15Z

4

If you have MySQL running a simple ps ax | grep mysql will yeld the process path.

Otherwise search your fs for mysqld it will take some time but will get the job done:

sudo find / -type f -name "mysqld"

A find / | grep mysql will print every file containing mysql in its name.

Use MySQLWorkbench, it has a nice GUI which lets you configure INNODBs data path and will also help you managing your instances.

Otherwise edit /etc/my.cnf (or create it if you don't have any) insert a [mysqld] section and set innodb_data_home_dir = /path/to/where/you/moved/your/data

[mysqld]
innodb_data_home_dir = /path/to/where/you/moved/your/data

edited Jul 20, 2013 at 0:20

answered Jul 19, 2013 at 23:47

Sam Aleksov

1,2016 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

my_overflowed_stack Over a year ago

ps ax | grep mysql helped me find my datadir which is apparently /usr/local/var/mysql. If I move this folder to another location, how do I tell mysql where the new location is?

Brett Bond · Accepted Answer · 2019-04-17 19:03:12Z

3

When started via homebrew services:

Stop the server: brew services stop [email protected]
Modify the plist file for your installed version, for example: /usr/local/Cellar/[email protected]/5.6.43/[email protected]
Look for the --datadir=/usr/local/var/mysql key and set the value to the place you want to store your databases.
Copy over files from /usr/local/var/mysql to your new location.
Restart the server: brew services start [email protected]

edited Apr 17, 2019 at 19:03

answered Apr 17, 2019 at 18:46

Brett Bond

312 bronze badges

1 Comment

cspider Over a year ago

Thank you, @BrettBond! This worked for me for mysql installed with brew, version 8.0.16 on macOS Mojave v. 10.14.4

Collectives™ on Stack Overflow

Change mysql db location when installed with homebrew

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related