Sequel Pro / MAMP在哪里存储本地数据库？

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

中文
English

问题描述

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

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

其他推荐答案

好吧，我发现了.如果您使用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?

其他推荐答案

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

上一篇：在Ruby on rails中通过生成迁移为一列添加索引:unique

下一篇：排除甲骨文挂起过程的故障