> -----Original Message----- > From: Octavian Rasnita [mailto:[EMAIL PROTECTED] > Sent: Tuesday, December 14, 2004 9:21 AM > To: Ron Goral; [EMAIL PROTECTED] > Subject: Re: MySQL and flock > > > Thanks but I don't have access to MySQL nor to the client that makes the > update. I don't even know if it locks the tables or not. > > I would like to just copy some files in order to create a backup > but I don't > want to copy them while they are locked. > However, I don't know if this is possible, because now I am > thinking that if > my program starts copying the files, they might start beeing updated just > after I have started the copy process... > > Teddy
Hm. Guess I thought you'd be doing this using SQL via a perl script. Are you going to be physically copying files? If that is the case, you will either have to deny access to them while you're copying or perhaps hold your breath and hope for the best. If you are using SQL, then the link I gave you outlines how you can lock them while copying the data. Ron -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>