Re: load data from master - Shamim Shaik - com.mysql.lists.mysql

5 messages in com.mysql.lists.mysqlRe: load data from master

From	Sent On	Attachments
Shamim Shaik	29 Mar 2005 06:26
Renato Golin	29 Mar 2005 06:37
Shamim Shaik	29 Mar 2005 06:43
Renato Golin	29 Mar 2005 06:49
Atle Veka	29 Mar 2005 11:40

Subject:	Re: load data from master
From:	Shamim Shaik (sham...@yahoo.com)
Date:	03/29/2005 06:43:38 AM
List:	com.mysql.lists.mysql

I cannot stop or lock tables on the master webapps write data to it constantly.

I am copying over the binlogs and applying them to the slave.

It is taking a long time so I just want to know if load data or copying tables
over would bring replication back to where it is.

Renato Golin <reng...@yahoo-inc.com> wrote: 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