The documentation mentions a sync function, but that function is not available from the Database menu as shown in the screenshots there. Is this functionality available elsewhere? Using reverse engineer makes the option show, but the wizard is unclear..

It would be nice being able to choose specific tables, but have the necessary tables linked through foreign keys be automatically included to avoid synchronization failure, and to do it all from the mysql shell not from an error prone UI.

  • 2
    in workbecnh press ctrl+R or do reverse engineer and then you can view the given options under Database tab option – Nawaz Sohail Mar 18 '16 at 14:20
  • what do the warnings about development environments mean? can this break a database, even a development/staging one? – matt Mar 18 '16 at 14:29
  • If they have to break you may have faced errors not the warnings. Try to resolve warnings if possible or you may proceed further and see what it does at the end. Would be better to do it on testing machines first and to see if everything works as perceived. – Nawaz Sohail Mar 18 '16 at 14:48
  • Can the synchronization process be done from the mysql shell? the UI is a little cumbersome to use, and more error prone if you want to repeat the process the same way once in a while – matt Mar 18 '16 at 15:59
  • Check out Percona's pt-table-checksum and pt-table-sync. – Rick James Mar 20 '16 at 23:50

Seems like the migration wizard (available from menu Database) is a better choice for this scenario.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.