copying a static table

2009-12-17 Thread Tom Worster
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? -- MySQL General Mailing List For list

Re: copying a static table

2009-12-17 Thread Michael Dykman
Tom, For MyISAM tables, as long as you aren't overlapping your update cycles, I can see nothing wrong with this. We used to rync to prepare slaves under inndb: do a broken rsync from the live data files on the master to the archives.. when that is complete, the result file is quite broken but