FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » How To » Backup query
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Backup query [message #29958] Wed, 25 January 2006 22:37 Go to next message
srchild is currently offline  srchild   United Kingdom
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
Re: Backup query [message #29960 is a reply to message #29958] Wed, 25 January 2006 23:47 Go to previous messageGo to next message
srchild is currently offline  srchild   United Kingdom
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
Re: Backup query [message #29967 is a reply to message #29960] Thu, 26 January 2006 15:17 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
The forum backs up all database table with the exception of the sessions and topic view tables which are rebuilt from scratch on import.

FUDforum Core Developer
Re: Backup query [message #29985 is a reply to message #29967] Thu, 26 January 2006 22:15 Go to previous message
srchild is currently offline  srchild   United Kingdom
Messages: 88
Registered: December 2003
Location: UK
Karma: 1
Member
Ilia wrote on Thu, 26 January 2006 15:17

The forum backs up all database table with the exception of the sessions and topic view tables which are rebuilt from scratch on import.


Thanks for the confirmation, I can now stop sweating and plan an upgrade Smile


Simon Child
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: postgresql vs mysql
Next Topic: restrict file type on upload
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Nov 13 09:21:26 GMT 2024

Total time taken to generate the page: 0.02607 seconds