Facebook
Twitter
D
DoobyWho
Guest
During a MySQL backup it locks the table it's working on, is there a way to display a temporary page on a site while the backup is occuring, this way the site is not down or getting access denied messages. I have two ideas for this, let me know what you think or any other suggestions:
(1) For each site, have two sets of httpdocs (and httpsdocs) directories, before the backup happens rename the first set (the originals) and name the second set the standard folders (which contain the temporary pages, this prevents any bookmarked pages from being broken during the backup)
(2) Somehow read that the table is locked and if the table is locked when trying to access the database, display a message about a backup being performed.
(1) For each site, have two sets of httpdocs (and httpsdocs) directories, before the backup happens rename the first set (the originals) and name the second set the standard folders (which contain the temporary pages, this prevents any bookmarked pages from being broken during the backup)
(2) Somehow read that the table is locked and if the table is locked when trying to access the database, display a message about a backup being performed.