MySQL Forums
Forum List  »  Backup

Re: Copy of Mysql Files
Posted by: Chris Pendse
Date: September 08, 2005 03:48AM

Hi Philipp,

I do not know for sure, but I had problems with corrupt indexes (on the copy) when copying large tables which were still being used. It depends how long it will take to rebuild your indexes as to whether it is worth locking I guess. You could also get data issues if some tables have been updated and others haven't mid copy.

I am just writing a script which locks the tables before and unlocks after the copy but having some problems to which I am waiting for an answer (http://forums.mysql.com/read.php?35,43383,43383#msg-43383).

If I get a resolution to it, then you could use the same method.

Hope that helps,
Chris

Options: ReplyQuote


Subject
Views
Written By
Posted
7435
September 02, 2005 06:27AM
Re: Copy of Mysql Files
3672
September 08, 2005 03:48AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.