I am looking for some information about synchronizing 2 mysql databases.
The
connection is internet and we would like to update any change on the far
away one with our local server every week.
You can do
USE your_database;
BACKUP TABLES table1,table2... TO 'some_path_on_local_disk';
on source server, send all *.frm and *.MYD as a binary file to target
computer into some afficient location (eg. /var/temp on Linux or
c:\widnows\temp on Windows) and do
USE your_database;
DROP TABLES table1,table2...;
RESTORE TABLES table1,table2... FROM 'some_path_on_local_disk';
Other way is to buy SQLyog SW on www.webyog.com ;-) This SW have a tool for
synchronisation databases.
6 messages in com.mysql.lists.win32Re: synchronizing 2 mysql servers
