I have a web site that accesses and updates a MySQL database. Occasionally I need to reload certain tables in that database from a local SQL Server database.
How can I programmatically:
a) Establish that no-one is actually using the database
b) Lock the MySQL database to prevent users accessing the web database while the re-load is in progress
c) Test whether the database is locked - i.e. prevent visitors from attempting to access / update the database while the refresh is in progress
View Complete Post