![]() If you do, you've successfully pointed MySQL to the new location. With your new data folder open so you can see the contents, start the MySQL Server and in that folder you should see a file named "ibtmp1" appear. Use the Terminal to reload the plist file To reflect the new location, noting there is no trailing '/' after the name of the data folder It's OK to rename the folder to something user friendly such as MySQLData In the Finder, useĪnd enter the location of the enclosing folder of the current data directoryĬopy the 'data' folder to your new location, e.g. It's best not to move everything, just the data folder. Open that file in an editor such as TextEdit or BBEdit and you should see a section with the following: Try to connect to the database, create a new database - see either the new database created in old directory /usr/local/var/mysql or you new path. Once you are done with above steps, do start the service. ![]() cp -R /usr/local/var/mysql /your/new/path You may use the following command to copy the files recursively. Make sure to copy all files under /usr/local/var/mysql to new directory.
0 Comments
Leave a Reply. |