On Wed, 24 Aug 2005, Arno Coetzee wrote:
Alex Greg wrote:
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?
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.
http://dev.mysql.com/doc/mysql/en/backup.html
you can rsync the bin logs.
our server flushes 4 times a day for the backup script.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner & Sr. Manager 7 West 24th Street #100 -
- +1 (443) 921-0381 Baltimore, Maryland 21218 -
- -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
This message is for the designated recipient only and may contain
privileged, proprietary, or otherwise private information. If you
have received it in error, purge the message from your system and
notify the sender immediately. Any other use of the email by you
is prohibited.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
