|
Joined: Apr 2007
Posts: 120
member
|
member
Joined: Apr 2007
Posts: 120 |
Utilizing Gizmo's Backup Process is there a way to script the closing of the forums while this backup is taking place? Is it necessary to close the board or does the mysqldump process close the tables being backed up automatically? How do others perform this task? Our board is active 24x7 since we have a worldwide membership, though it is a tad light at the wee hours of the morning USA time.
|
|
|
|
Joined: Aug 2006
Posts: 1,649 Likes: 1
Pooh-Bah
|
Pooh-Bah
Joined: Aug 2006
Posts: 1,649 Likes: 1 |
My host makes daily backups automatically, but I don't think (know if) they lock the tables as I've never noticed it...
GangsterBB.NET (Ver. 7.6.1.1) PHP Version 5.6.40 / MySQL 5.7.23-23 (was 5.6.41-84.1) / Apache 2.4.54 2007 Content Rulez Contest - Hon Mention UBB.classic 6.7.2 - RIP
|
|
|
|
Joined: Apr 2007
Posts: 120
member
|
member
Joined: Apr 2007
Posts: 120 |
I looked at the dotoggleopen.php file and decided that if I were to close the board during the backup I will just swap in a config.inc.php file that has the BOARD_IS_CLOSED => '1' setting, run my sql dump and then swap back a config.inc.php file that has that set to '0'
|
|
|
|
Joined: Aug 2006
Posts: 1,358
Veteran
|
Veteran
Joined: Aug 2006
Posts: 1,358 |
I don't bother with the board close. The backup is done so quick, in the middle of the night, that anything lost would be close to nothing.
|
|
|
|
Joined: Apr 2007
Posts: 120
member
|
member
Joined: Apr 2007
Posts: 120 |
Good to know that, I'll just cron the backup job and see how it goes tonight.
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
You should close your board before backing up. The mysqldump will create the file as you select it; it will do it immediately. Automating the process would be possible, but I'd recommend doing it manually, then you know when to re open when the backup is done.
the backup should just take a couple of seconds/minutes.
|
|
|
|
Joined: Apr 2007
Posts: 120
member
|
member
Joined: Apr 2007
Posts: 120 |
Actually I just stumbled across a nice little utility script for monitoring mysqldump. Well actually it does a lot more than that, it will:
- set daily, weekly monthly backups - rotate backups - backup single, multiple, all or exclude databases - compress backups in addition to compressing the backup stream - email the results, backup file, both, or only on error - create time/date stamped backups, and separate directories - run pre and post backup commands
It is all in a shell script so it's easy to adjust to your needs.
I generally will run backups a few times manually to be sure nothing blows up, but once I know all is well things become automated from there on out.
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
how bout a Linky Poo™ to it .. i'd like to tinker with it too tia
|
|
|
|
Joined: Apr 2007
Posts: 120
member
|
member
Joined: Apr 2007
Posts: 120 |
Ah yes of course, linky poo...
|
|
|
|
Joined: Jul 2006
Posts: 4,057
|
Joined: Jul 2006
Posts: 4,057 |
Thats been around for a while and well used, probably because it does everything on the tin
BOOM !! Version v7.6.1.1 People who inspire me Isaac ME Gizmo
|
|
|
|
Joined: Apr 2007
Posts: 120
member
|
member
Joined: Apr 2007
Posts: 120 |
Another process I was considering was cstream to monitor the dump and when finished would continue on with the dump script. But the automysqlbackup.sh script, even as old as it is, seems to be simple enough and gets the job done.
|
|
|
|
Joined: Aug 2006
Posts: 1,358
Veteran
|
Veteran
Joined: Aug 2006
Posts: 1,358 |
I don't bother with the board close. The backup is done so quick, in the middle of the night, that anything lost would be close to nothing. I take my words back I've made a simple modification for ubb that closes the board on specific times with a specific message. This allows me to close my board automated in an easy way. Interested? [b]Get the goodie here at ubbdev[/b]
|
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
|
|
|
1 members (1 invisible),
756
guests, and
178
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|