Alex Greg wrote:
Hi,
Our company is considering migrating some tablesfrom MyISAM to InnoDB,
as it has row-level locking and other improvements over MyISAM.
However, one of the things we do at the moment is rsync the MySQL data
directory to our development server every night over an 2Mbps ADSL
connection (as we have 40GB of data, downloading it all every night
isn't a viable option).
I am aware that you can't copy the InnoDB binaries around to different
installations. Does anyone have any suggestions as to how we could
continue to do incremental downloads of this data over a slow
connection?
Regards,
-- Alex
make a dump file of only the previous days data compress it , transfer
the file , decompress it and import that days records into the other
database.
remember that you should have a complete copy of the the database on
the other server before you start the daily process.
--
Arno Coetzee
Developer
Flash Media Group
Office : 2712 342 7595
Mobile : 2782 693 6180
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
