On Tuesday 29 March 2005 11:26, Shamim Shaik wrote: > Can I run load data from master on myisam tables where my table size is > approx 30G?
- stop slave - on master do: - lock tables - tar cpf - /var/lib/mysql/tbl | ssh -C slave tar xpf - -C /var/lib/mysql/tbl - start slave - on master again: - unlock tables It's faster, but will keep you out of order untill all data is copied. --rengolin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]