does anybody know some free tool for synchronization MySQL database (data and structure) like in Navicat for Windows ?
I'm using Structure and Data synchronization. Sometimes Data transfer. I was just wondering if there is not any software like this for free. Found only HeidiSQL (which looks perfect but work worse).
You should use MySQL Workbench. It has sync feaures, which is great. I use 2 different servers (dev and prod) and of course the EER Model. I sync the model with the development database, and then I sync the prod database with my model.
What functionality of Navicat do you need? There is a number of ways without that software to synchronize mysql. You can use the MySQL replication functionality or simply copy and paste the data files (if your using MyISAM tables it's just a straight copy) innoDB tables are a little more tricky.
{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 小情绪 Triste * 的问题《Free MySQL synchronization tool [closed]》','https://www.manongdao.com/q-1233861.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
Toad for MySQL has synchronization abilities and is free.
MySQL Workbench Beta does this perfectly and for free for now.
You can just try dbForge Studio for MySQL to sync mysql databases. This tool provides a number of features that help you with mysql synchronization:
There is free 30-days usage of the MySQL sync tools in a dbForge Studio trial.
If you just want synchronization would MySQL replication work for you?
http://dev.mysql.com/doc/refman/5.0/en/replication.html
You should use MySQL Workbench. It has sync feaures, which is great. I use 2 different servers (dev and prod) and of course the EER Model. I sync the model with the development database, and then I sync the prod database with my model.
What functionality of Navicat do you need? There is a number of ways without that software to synchronize mysql. You can use the MySQL replication functionality or simply copy and paste the data files (if your using MyISAM tables it's just a straight copy) innoDB tables are a little more tricky.