使用MAPS Pro 3将MySQL数据库与Dropbox同步

问题描述

在我将MAMP（Pro）安装从2.2更新到3.0.2后，我无法使我的dropbox mysql数据库同步工作。

I'm having issues getting my dropbox mysql database sync working after updating my MAMP (Pro) installations from 2.2 to 3.0.2.

我一直使用以下设置退出一段时间，它工作完美，直到我更新：

I've been working with the following setup for quit some time now and it worked perfectly until I updated:

工作电脑：

Mac Pro G5运行MacOS 10.8.5

（含用户名）

MAMP& MAMP Pro正常安装

用户根目录中的Dropbox文件夹： / Users / UsernameA / Dropbox 与第二个分区的符号链接： / Volumes / Diskname / Dropbox

符号链接到Dropbox：

Work computer:
Mac Pro G5 running MacOS 10.8.5
with UsernameA
MAMP & MAMP Pro installed as normal
Dropbox folder in user root: /Users/UsernameA/Dropbox with a symlink to second partition: /Volumes/Diskname/Dropbox
Symlinks to Dropbox from:

/Applications/MAMP/htdocs 
/Applications/MAMP/db/mysql  
/Library/Application Support/appsolute/MAMP PRO/db/mysql

主机：

Mac Mini运行MacOS 10.9.2

with UsernameB

MAMP& MAMP Pro正常安装

用户根目录中的Dropbox文件夹： / Users / UsernameB / Dropbox
符号链接到Dropbox：

Home computer:
Mac Mini running MacOS 10.9.2
with UsernameB
MAMP & MAMP Pro installed as normal
Dropbox folder in user root: /Users/UsernameB/DropboxSymlinks to Dropbox from:

/Applications/MAMP/htdocs  
/Applications/MAMP/db/mysql  
/Library/Application Support/appsolute/MAMP PRO/db/mysql

两台计算机上的MAMP Pro设置 p>

MAMP Pro Settings on both computers

Default Apache port for http connections: 80  
Default Apache port for https connections (SSL): 443  
MySQL port: 3306  
Run Apache/MySQL server as user: www (Apache) / mysql (MySQL)  
MySQL Password user root: notroot

在我的工作计算机一切正常，Apache和MySQL服务器启动正常。
然而，当我试图在家启动MAMP Pro，我不断得到MYSQL不能启动错误。在MAMP中，MySQL服务器也不会启动。
这是在我的 mysql_error.log ：

On my work computer everything works fine and both Apache and MySQL server startup normally.However when I tried to start MAMP Pro at home, I keep getting the MYSQL couldn't be started error. In MAMP the MySQL server won't start either.This is in my mysql_error.log:

140320 11:09:14 mysqld_safe Starting mysqld daemon with databases from /Library/Application Support/appsolute/MAMP PRO/db/mysql
140320 11:09:14 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
140320 11:09:14 [Warning] Setting lower_case_table_names=2 because file system for /Library/Application Support/appsolute/MAMP PRO/db/mysql/ is case insensitive
140320 11:09:14 [Note] Plugin 'FEDERATED' is disabled.
/Applications/MAMP/Library/bin/mysqld: Table 'plugin' is read only
140320 11:09:14 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140320 11:09:14 InnoDB: The InnoDB memory heap is disabled
140320 11:09:14 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140320 11:09:14 InnoDB: Compressed tables use zlib 1.2.3
140320 11:09:14 InnoDB: Initializing buffer pool, size = 128.0M
140320 11:09:15 InnoDB: Completed initialization of buffer pool
140320 11:09:15 InnoDB: highest supported file format is Barracuda.
140320 11:09:15 InnoDB: Waiting for the background threads to start
140320 11:09:16 InnoDB: 5.5.34 started; log sequence number 100221878
140320 11:09:16 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'host' is read only
140320 11:09:16 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended

我知道它有东西使用 / Library / Application Support / appsolute / MAMP PRO / db / mysql 文件夹，因为当我删除符号链接并使用家庭计算机上的默认安装的mysql文件夹时，MySQL服务器启动为正常。

我试过一切：

I know for sure it has something to do with the /Library/Application Support/appsolute/MAMP PRO/db/mysql folder, because when I remove the symlink and use the default installed mysql folder on my home computer, the MySQL server starts as normal.
I tried everything:

1. 已移除&重新安装MAMP& MAIL Pro


2. 检查活动监视器中是否有其他任何运行的mysql服务器


3. 验证并修复磁盘工具中的磁盘权限


4. 导出所有数据库，并将其导入新的MAMP安装，并将
   mysql文件夹用作新的同步文件夹

1. Removed & reinstalled MAMP & MAMP Pro completely
2. Checked if there were any other mysql servers running in Activity Monitor
3. Verify and Repair disk permissions in Disk utility
4. Exported all my databases and imported them in a fresh MAMP install and used thatmysql folder as new sync folder

但没有什么帮助！

我在某处读到Dropbox的路径必须在两台计算机上完全相同，但是在更新之前这样工作得很好？

还有人提到两个计算机上的用户名必须是相同的，但在更新之前也工作正常？

But nothing helps!
I read somewhere that the path to Dropbox has to be exactly the same on both computers, but that worked fine like this before the update?
Also someone mentioned that the usernames on both computers have to be the same, but that also worked fine before the update?

任何想法会导致什么？

谢谢！

Any ideas what's causing this?
Thanks!

推荐答案

我有新的Xampp安装类似的问题，我试图更改这些行在 my.ini ：

datadir="C:/xampp/mysql/data"
innodb_data_home_dir = "C:/xampp/mysql/data"
innodb_log_group_home_dir = "C:/xampp/mysql/data"

进入：

datadir="D:/Dropbox/web-data"
innodb_data_home_dir = "D:/Dropbox/web-data"
innodb_log_group_home_dir = "D:/Dropbox/web-data"

您需要将数据文件夹中的所有初始内容复制到新的web数据文件夹。你可以与你的安装进行比较，希望它能工作。

You need to copy all initial content inside data folder into the new web-data folder. You can compare with your installation, hope it will work.

这篇关于使用MAPS Pro 3将MySQL数据库与Dropbox同步的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！