This release of MySQL Table Sync adds the ability to sync only part of a table, adds minor new functionality, and fixes a bug that could crash the tool.
I will be focusing some effort on this tool soon. If you would like to see particular features, please consider sponsoring them.
Technorati Tags:No Tags
Is it possible to sync all tables inside a database somehow (without listing tables manually) or am I missing something?
No, it works on one table at a time. The idea is to use it to repair a table known to differ (see MySQL Table Checksum for an efficient way to check all tables for differences).
That said, it would be trivial to write a shell-script wrapper to run it against all tables, but as stated in the documentation, the script requires the insight of a smart person to tell it an efficient way to find and resolve the differences.
Hi,
I tried out your tool but it seems like I can’t get it running.
I ssh tunneled my second mysql server through port 1100.
linux:~ # mysql-table-sync –print –debug sync:123@localhost:3306/stest.test sync:123@localhost:1100/stest.test
– SELECT /*source:`stest`.`test`*/ `id`, MD5(CONCAT_WS(’#', `id`,`type`,`client_id`,`agent_id`,`user_id`,`country_id`,`region_id`,`city_id`,`image_id_array`,`comment_id`,`category_id`,`extra_id_array`,`price`,`price2`,`price_currency`,`price_comment_id`,`visits`,`reality_size`,`living_space_size`,`situation_id`,`creation_date`,`map`,`name`,`name_id`,`seasons_id`,`promotion`,`note_id`,`short_comment_id`,`area_id`,`near_location`,`hidden`,`ge_location`,`l_price`,`h_price`,`price_timestamp`,`confirmnow`)) AS __crc FROM `stest`.`test` ORDER BY `id`
– SELECT /*dest:`stest`.`test`*/ `id`, MD5(CONCAT_WS(’#', `id`,`type`,`client_id`,`agent_id`,`user_id`,`country_id`,`region_id`,`city_id`,`image_id_array`,`comment_id`,`category_id`,`extra_id_array`,`price`,`price2`,`price_currency`,`price_comment_id`,`visits`,`reality_size`,`living_space_size`,`situation_id`,`creation_date`,`map`,`name`,`name_id`,`seasons_id`,`promotion`,`note_id`,`short_comment_id`,`area_id`,`near_location`,`hidden`,`ge_location`,`l_price`,`h_price`,`price_timestamp`,`confirmnow`)) AS __crc FROM `stest`.`test` ORDER BY `id`
Thanks for any help ..
Simon
Looks like it’s working okay. Try the –execute option.