FUDforum: How To » Backup query

Home » FUDforum » How To » Backup query

Show: Today's Messages :: Polls :: Message Navigator

Backup query [message #29958]

Wed, 25 January 2006 22:37

srchild

Messages: 88
Registered: December 2003
Location: UK

Karma: 1

Member

I'm backing up with admdump.php. I thought it dumped the database as well as backing up files, but I just had reason to unpack a backup and can't find any user names in it. (I find them in the messages, but I don't find them in a fud_users table definition). Is it not backing up fud_users (and some other tables?)

Background. I wanted to export some data from my db and thought to unpack one of the backups. I gunzip'd a backup file and searched to locate the fud_users table definition, and its not in there. Searched on some user names, which I know are in the db, and they're not in the backup.

The backup is about the correct size: if I dump and gzip the db it is 18Mb, and my admdump.php backup is 29Mb (compressed). The backup gunzips to about 290Mb.

The admdump.php backup does contain some db data, notably table fud_index which has 3,000,000 records, and also the text of my message-base.

This is my backup command (all on one line), run from cron

echo -e 'submitted=1\n&compress=1\n&path=/usr/www/users/myuser/web/domain/f orumbackup/FUDforum.gz\n---' | /usr/local/bin/lynx http://www.domain.org/forum/adm/admdump.php?do_http_auth=1 -auth=adminname:password -post_data

p.s. searching the archives now, I realise that I could do this differently using cli option, but in fact my version of fudforum 2.6.9 had a missing line in there so that didn't work, so I've been using the http method, apparently successfully.

pps. searching the archive I also know there's a security issue with 2.6.9, but I'm not using avatars, and I want to get backups working properly before thinking about upgrading!

Thanks for any input to this, meantime I have immediately set up to do a nightly dbdump as well as an admdump.php backup. Let me know if I it is safe for me to cease this to save some diskspace and bandwidth!

Simon Child

Report message to a moderator

Re: Backup query [message #29960 is a reply to message #29958]

Wed, 25 January 2006 23:47

srchild

Messages: 88
Registered: December 2003
Location: UK

Karma: 1

Member

srchild wrote on Wed, 25 January 2006 22:37

The backup is about the correct size: if I dump and gzip the db it is 18Mb, and my admdump.php backup is 29Mb (compressed).

Hmmm, I've just noticed that all the previous backups were about 35Mb. I wonder whether this last one, which of course is the one that I looked at, got truncated during download for some reason, and lost a few tables off the end of the file...

Simon Child

Report message to a moderator