Menu
I had a few databases created on my computer via Sequel Pro & MAMP, and was running localhost to view them. However, I did a fresh install of Mac OS Lion, and I forgot to backup the databases to .sql files.
I do backup my files regularly, and have a copy of the computer pre-install. Does anyone know the path to the db files? Are they stored in a format that I could rebuild, so I could import into Sequel Pro?
391
Where is my MySQL 5.7 database data in MAMP PRO 6? Your MySQL 5.7 database data is located in “/Library/Application Support/appsolute/MAMP PRO/db/mysql57”.
Connecting via a socket connectionOpen Sequel Pro. Choose a Socket Connection. You must only specify the username and password (if any). Most MySQL installations use the default username root and a blank password.
The default data directory location is C:\Program Files\MySQL\MySQL Server 8.0\data , or C:\ProgramData\Mysql on Windows 7 and Windows Server 2008. The C:\ProgramData directory is hidden by default.
Servers and Services > MySQL Your MAMP PRO MySQL database data is located in “C:\Users\Public\Documents\Appsolute\MAMPPRO\db". To connect to your MySQL database in MAMP PRO you must use TCP/IP (network) connections.
Brian W's answer didn't really help with me using MAMP Pro (v2.1.4), but luckily someone else did. Location for mine were:
/Library/Application Support/appsolute/MAMP PRO/db/mysql
They also said that they've moved it to Dropbox and then used a unix symlink for the original location (not a Mac OS X alias as they don't work), that way it does get backed up as well.
127
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
