MAMP Pro 2.0.2 - Mysql db's synced on dropbox have somehow become out of sync?


Problem :

I am using Dropbox to synchronize some MAMP mysql databases via a symlink as per this tutorial. They are synced between my laptop and desktop.

For quite some time, everything has worked perfectly. I haven't changed anything and all of a sudden I've noticed the db's are out of sync. For example, in a wordpress database, I have made several changes that aren't reflected on the other computer, even after Dropbox has plenty of time to 'sync' up, and Mamp is running on only one system and quit before opening on the other.

Running

Tools > Check MySQL Databases

Shows every relevant db/table to be 'OK'

Both computers are symlinked to the same folder, so I'm really not sure what is going on here. I'm really unsure how to trouble shoot this as even the dropbox revision/file history shows no conflicts or anything. It's as though the data is being stored somewhere else even though both are linked to the same place.

To remedy, I've had to make a mysqldump from one system and reimport it to the other, but this defeats the purpose.

If anyone has a tip for how to begin troubleshooting this, I'd greatly appreciate it.



Solution :

There's a fundamental difference between what you're doing and what the article recommended. The article was using dropbox as a one-way sync. So only running MySQL server on one server, then using Dropbox to store a remote copy of the database in "The Cloud."

In your case, it sounds like you're trying to synchronize two running MySQL Servers using Dropbox. MySQL isn't designed to work this way. There's a whole (complex) feature for this purpose called replication. I'd strongly discourage you from using Dropbox to sync a database which has MySQL servers running on more than one machine.

Regarding the failure to sync, it sounds like a Dropbox issue. Do you have sufficient space left? You may need to contact their support to see why your symlinks aren't syncing properly.


Mysql Tutorials

Mysql Howto..

how to maintain a continuous id number row count in mysql

How to change mysql_connect into PDO. Updating form

MYSQL SELECT. How to distinguish customers by first four digits of number field

Mysql- How to change the rows into columns based on quarter column

How to optimize mysql indexes so that INSERT operations happen quickly on a large table with frequent writes and reads?

How to parse a string to insert a row into a mysql table?

How to recover just deleted rows in mysql?

How to parse MySQL built-code from within Python?

How to search an independent word in a mySQL search?

How to clear screen in MySQL? [duplicate]

How to select only unique values from a table column in mysql. NOT using DISTINCT

How to ensure INSERT INTO wont add the same value on the mySQL DB

How to handle DDL statements (create,alter,drop) with row based replication for MySql?

How to select a MAX record based on multiple results from a unique ID in MySQL

how can i rename a database in mysql? [duplicate]

How can I retrieve information from one table to order the results of another

How to implement a portable MySQL and connect to it from Ruby as a non-root under Linux

How to add up values in the table row which is retrieved from MySQL?

How do I merge two tables in MySQL and where table 1 is primary

how to put array into