Hi,

I have a requirement where I write regular data from Mysql to an output folder using

select * into outfile 'filename' from table...

I have a cronjob written in php which reads these files and upload to a backup.

My worry is that it might not try to read a file which is still being written by MySql.

My question is:
1)Is it possible at first place?
2)Can we use some locking mechanism in this case and if yes which one.
I am solving the issue where data is written by another files using flock.

Thanks

Originally asked by: Shashwat on Stack Overflow