升级MAMP后找不到旧的MySQL数据库 [英] Cannot find old MySQL databases after upgrading MAMP
问题描述
- 我安装了优胜美地
- 将MAMP重命名为MAMP_old
- 干净安装了MAMP
- 将db文件夹从旧复制到新文件夹中
现在我所有的数据库都没有出现在PHPMyAdmin中
Now none of my databases appear in PHPMyAdmin
在 db/mysql 文件夹中，我看到了旧数据库的文件夹，但是没有sql文件.例如，一个Wordpress文件夹包含 .frm 文件和 db.opt 文件.
Inside the db/mysql folder I see the folder for my old databases, but there are no sql files. For example a Wordpress folder contains .frm files and db.opt files.
我尝试这样做(使用下面的链接)，但是我似乎没有mysql文件夹usr/local/
I tried doing this (using the link below), but I don't seem to have a mysql folder usr/local/
/usr/local/mysql/bin/mysqldump -u root -p[pass] [db] > [filename].sql
在访问之后无法访问MySQL数据库升级到Mountain Lion(使用MAMP)
我该怎么做才能还原我的旧数据库?我在这方面的知识非常有限.
What should I do to restore my old databases? I have very limited knowledge in this area.
非常感谢
推荐答案
我遇到了从4升级到MAMP PRO 5的问题.以下文章被证明是无价之宝: https://appsolute.zendesk.com/hc/en-us/articles/215198946-I-upgraded-to-MAMP-PRO-5-and-I-am-missing-databases-
I ran into this problem with upgrading to MAMP PRO 5 from 4. The following article proved invaluable: https://appsolute.zendesk.com/hc/en-us/articles/215198946-I-upgraded-to-MAMP-PRO-5-and-I-am-missing-databases-
引用:
您的旧MySQL 5.6数据已存在
Your old MySQL 5.6 data is in
/库/应用程序支持/appsolute/MAMP PRO/db/mysql56_2018_xxxx
/Library/application support/appsolute/MAMP PRO/db/mysql56_2018_xxxx
为了安全起见，请先备份主机数据，然后再备份整个/图书馆/应用程序支持/appsolute/MAMP PRO/db/
To be on the safe side, first make backups of your host data, and your entire /Library/application support/appsolute/MAMP PRO/db/
要验证这是您的旧数据，请查看此mysql56_2018_xxx内部文件夹中，您应该在中看到所有旧数据库的子目录此文件夹.
To verify this is your old data, look inside of this mysql56_2018_xxx folder, you should see subdirectories of all of your old databases in this folder.
如果您在MAMP PRO 5中看到丢失的数据库，则可以重新升级"您的通过执行以下操作来处理旧数据.
If you see missing databases in MAMP PRO 5, you can "reupgrade" your old data by doing the following.
- 退出MAMP PRO
- 将mysql57文件夹重命名为mysql57_back
- 复制mysql56_2018_xxxx文件夹，并将其命名为mysql57.
- 启动MAMP PRO，启动服务器
- 运行工具>升级MySQL数据库
注意:
-
可在线获得的MAMP(不是MAMP PRO )说明具有误导性.
上面的内容不是指MAMP PRO应用程序包装内容中的/Library，而是驱动器根目录中的/Library.
The above refers not to the /Library inside the package contents of the MAMP PRO app, but /Library from the root of your drive.
在我的情况下，完整的原始数据库位于简单命名为 mysql56 的文件夹中.还有其他不完整的带日期戳的文件夹，表明原始数据库更新过程中失败.
In my case the complete original databases were in the folder simply named mysql56. There were additional incomplete date-stamped folders suggestive of failures during the original DB update process.
这篇关于升级MAMP后找不到旧的MySQL数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
