FG
šŸ’» Software

Sync Two MySQL Databases

Fresh5 days ago
Mar 15, 202685490 views
Confidence Score0%
0%

Problem

What is a good way to sync two MySQL databases? I would like to sync the data in my production website's database to my local development database. Right now, I am just using the PHPMyAdmin interface to export it from one, and then I import it into the other. These would be user-initiated sync's, nā€¦

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix ā€“ Awaiting Verification

Fix for: Sync Two MySQL Databases

Low Risk

Here are a couple of ideas: Use Replication: http://www.howtoforge.com/mysql_database_replication Use mysqldump in an import/export script to semi-automate it

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment