Re: FLUSH TABLES WITH READ LOCK via shell script
Posted by: Duncan Berriman
Date: September 29, 2005 02:16PM

Or you could just use the system command within mysql to execute the backup.

Lock the tables before.
Use the system command to do the backup
Unlock the tables.

Since the process is in mysql the locks remain in place whilst the backup is done.

Options: ReplyQuote


Subject
Written By
Posted
Re: FLUSH TABLES WITH READ LOCK via shell script
September 29, 2005 02:16PM


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.