| Backup query [message #29958] |
Wed, 25 January 2006 22:37  |
srchild
Messages: 88
Registered: December 2003
Location: UK
Karma:
|
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
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]