books1 wrote:Jon, has there been another "site down" situation?

There are only a few messages in the "active"list, plus I can see a few of my more recent messages that I posted a few days ago to various topics are missing.

oldone wrote:Duh??? I tried yesterday evening to login after drivung 875 miles & could get 7 items that were 7 days old?????? This morning it was fine??? ran some errands & now can get 5 topics to pull up???? Me ,My computer,Or server???? Lost in la la land.
Got the topics to pull up after changing the little box in the center of the page from 7 days to all, but am missing the posts between Apr 23 to Apr 30?????? And after posting some thing it went back to 5 items????

When you capitalized the word IMMEDIATELY who was that supposed to incite?
Because officially, there is no one "in charge" of database maintenance.

Sigmaz wrote:No I wasn't saying they are in charge of backups.
We are.

When you capitalized the word IMMEDIATELY who was that supposed to incite?
Because officially, there is no one "in charge" of database maintenance.

But if you should choose to move databases from one server to another it would be a best practice to at least use a current snapshot.
Unscheduled or unannounced changes tend to often cause problems.
We are an active forum but sometimes forums don't always command the care they deserve, especially to an anonymous db grunt changing tapes. We are just another file in the mess that is his daily grind.

I have executed several backups myself and on many occasions the backup tool fails to complete and/or notify me of any error.
Its not until I check for a certain day that I realize its missing.
The service is a rubber stamp tool that comes with the reseller suite, it may or may not be properly configured on thier side.

Note that prior to myself attempting to make backups, they just werent being made.
Read- Not being made, no backups, none.

Now, I'm not suggesting that we jump ship because they don't email us about changes.
In fact they may and probably do. But i don't get them.

My gripe is that there are many names associated with the official keepers of the forum infrastructure.
However, it's only ever been Jamie and myself hard at work on the back end keeping it alive and for the record, I was never officially anointed an admin but I serve the community by request proudly and happily as if I were.

Most of the other names I see I have never met nor even read any threads written by them.
If you aren't going to man your post then why hold it.


I totally agree with you that its not fair that users spend valuable time posting and adding to the community just to have it lost to a glitch or to a mindless mistake.

That is why l'ill be revisiting and revising the backup strategy in an attempt to avoid this conversation in the future.

I've been an I.T. professional since 1990 so I get how it works when it comes time for finger pointing.

As a side note you may see an interesting message in the following screen cap of the backup tool.
Perhaps this is a hint as to why it doesn't always work.
BTW, love you man.

#!/usr/bin/perl
use warnings;
use strict;

# Set connection values
my $DATABASE   = 'database_name';
my $DUMP_DIR   = '/path/to/backup_folder/';
my $MYSQLADMIN = '/usr/bin/mysqldump';
my ($DUMP_FILE,$DUMP_SCRIPT);
######################################

  $DUMP_FILE = $DUMP_DIR . $DATABASE . ".sql";
  if(-e "$DUMP_FILE") { unlink("$DUMP_FILE"); }
  $DUMP_SCRIPT = $MYSQLADMIN . " --defaults-file=/home/<username>/.my.cnf" . ' --opt' . " $DATABASE > $DUMP_FILE";
  system("$DUMP_SCRIPT");

  exit(0);

#! /usr/bin/env python2

import os
import sys
import time

database = sys.argv[1]
location = sys.argv[2]

location = location.replace("DAY", time.strftime("%d"))
location = location.replace("MONTH", time.strftime("%m"))
location = location.replace("YEAR", time.strftime("%y"))
location = location.replace("HOUR", time.strftime("%H"))
location = location.replace("MIN", time.strftime("%M"))
location = location.replace("SEC", time.strftime("%S"))

command = "mysqldump "+database+" > "+location+".sql"
print command
os.system(command)
command = "tar -czvf "+location+" "+location+".sql"
print command
os.system(command)
command = "rm -f "+location+".sql"
print command
os.system(command)

crontab


0 4 * * * path to above file dbtoback /home/dbtobackbackup_DAY-MONTH-YEAR.tar.gz 

Micro Image wrote:Yes, the host is http://www.fastwebhost.com/

Who has access to the account?
I think some answers are in order. I'm tenacious about this kind of thing, and always get the result I want -- but I don't have the authority. :'(

books1 wrote:Blimey! ...... "Users browsing this forum: books1 and 0 guests"

So why does it feel like I've slipped through a crack in the Space-Time Continuum and gone back to dial-up days of olde
(alternatively, like I am visiting ye oldone and trying to send an email back home) ?

Is all that water between us getting in the wires?