Data sync offline

2005-08-24 Thread Alex Greg
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

Re: Data sync offline

2005-08-24 Thread Arno Coetzee
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

Re: Data sync offline

2005-08-24 Thread Jason Pyeron
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

Re: Data sync offline

2005-08-24 Thread Karam Chand
http://www.sitepoint.com/article/mysql-data-sqlyog-job-agent SJA is available for both Linux and Windows. Karam --- Alex Greg [EMAIL PROTECTED] wrote: Hi, Our company is considering migrating some tablesfrom MyISAM to InnoDB, as it has row-level locking and other improvements over

Re: Data sync offline

2005-08-24 Thread Gleb Paharenko
Hello. Think about replication among other solutions. See: http://dev.mysql.com/doc/mysql/en/replication.html Alex Greg [EMAIL PROTECTED] wrote: Hi, Our company is considering migrating some tablesfrom MyISAM to InnoDB, as it has row-level locking and other improvements over