MySQL Lists: mysql: copying a static table

List:	General Discussion	« Previous Message Next Message »
From:	Tom Worster	Date:	December 17 2009 6:38pm
Subject:	copying a static table
View as plain text

i have a large myisam table (about 3gb) that is updated once a day in the
middle of the night.

when it is not being updated, is there any reason not to copy it out with
rsync without shutting down the server or flush tables with read lock or
whatever?

Thread
• copying a static table	Tom Worster	17 Dec
• Re: copying a static table	Michael Dykman	17 Dec