Sequel Pro / MAMP在哪里存储本地数据库?[英] Where does Sequel Pro / MAMP store local databases?

本文是小编为大家收集整理的关于Sequel Pro / MAMP在哪里存储本地数据库?的处理/解决方法,可以参考本文帮助大家快速定位并解决问题,中文翻译不准确的可切换到English标签页查看源文。

问题描述

我通过续集Pro&Mamp在计算机上创建了一些数据库,并且正在运行Localhost来查看它们.但是,我对Mac OS Lion进行了全新安装,我忘了将数据库备份到.sql文件中.

我会定期备份文件,并具有计算机预安装的副本.有人知道DB文件的路径吗?它们是否以我可以重建的格式存储,因此我可以将其导入续集Pro?

推荐答案

Brian W的答案并没有真正帮助我使用MAMP Pro(v2.1.4) ,但幸运的是别人做了.我的位置是:

/Library/Application Support/appsolute/mamp pro/db/mysql

他们还说,他们已经将其移至Dropbox,然后在原始位置使用Unix Symlink(而不是Mac OS X Alias,因为它们不起作用),这样它也会得到备份.<<<<<<<<<<<<<<<<

其他推荐答案

好吧,我发现了.如果您使用MAMP和Localhost来创建数据库,则只需转到MAMP> db> mySQL文件夹即可,其中将有您的所有数据库.

希望能帮助任何使用续集/mamp/localhost的人!

其他推荐答案

从标准MAMP到MAMP PRO中携带以前的数据库:

复制 /申请/mamp/db/mysql/ 进入 /库/应用程序支持/appsolute/mamp pro/db/mysql/

要携带以前的数据库用户您需要复制: /申请/mamp/db/mysql/mysql/ 进入
/library/应用程序支持/appsolute/mamp pro/db/mysql/mysql

本文地址:https://www.itbaoku.cn/post/597710.html

问题描述

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?

推荐答案

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.

其他推荐答案

Okay, I figured it out. If you are using MAMP and localhost to create databases, you just need to go to MAMP > db > mysql folder and in there will be all your databases.

Hope that helps anyone who uses Sequel Pro / MAMP / Localhost!

其他推荐答案

To carry over previous databases from Standard MAMP to MAMP PRO:

copy over /Applications/MAMP/db/mysql/ into /Library/Application Support/appsolute/MAMP PRO/db/mysql/

To carry over previous database users you need to copy over: /Applications/MAMP/db/mysql/mysql/ into
/Library/Application Support/appsolute/MAMP PRO/db/mysql/mysql