MySQL Forums
Forum List  »  Stored Procedures

Re: Backup Script, Stored Procedure check
Posted by: Gary Ikeda
Date: June 27, 2018 02:46PM

Oh well, I decided to create a table in a separate database which will be writable during the read lock on my database backup.

The shell script will execute 'update maint.backup_status set active=1' and my stored procedure which flush tables with read lock and waits in a loop for the active value to change in the maint.backup_status table.

When the loop completes it will unlock tables setting the database in read/write mode once again.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Backup Script, Stored Procedure check
509
June 27, 2018 02:46PM


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.