Since YaBBSE Forums down I have to post here. Help me this is an emergency...

[[Unknown]]

I've restored the data you gave me, but you didn't send me the backup of the yabbse_topics table, so the posts are there... but there's no way to get to them.

-[Unknown]

[ROGUE-Master]

Code Select Expand

#
# Table structure for table 'yabbse_log_topics'
#

DROP TABLE IF EXISTS yabbse_log_topics;

CREATE TABLE yabbse_log_topics (
   ID_MEMBER mediumint(8) unsigned DEFAULT '0' NOT NULL,
   ID_TOPIC mediumint(8) unsigned DEFAULT '0' NOT NULL,
   logTime int(10) unsigned DEFAULT '0' NOT NULL,
   notificationSent tinyint(4) unsigned DEFAULT '0' NOT NULL,
   PRIMARY KEY (ID_TOPIC, ID_MEMBER)
);

There it is. 

Edit: O CRAP. Thats log topics. I didn't know there was a difference. What you restored on my forum is exactly what I had before I deleted it. And the amount of "Total members" is still messed up because it should be more than 500.

Well thanks for your help anyway, greatly appreciated, but I'll obiously have to restart my forums. =(

By the way. You should address the issue of an option to back up ALL aspects of the forum database with dump in the forums.... I know some people would say it would crash the server but if you could do it in incriments or something, that would work.

[Tyris]

thats the structure... you need to give him its contents... the backup for all its data...
otherwise the messages are there... but no topics will be displayed.. coz well that topic table is empty.

[ROGUE-Master]

And, When I view the member list here:
http://www.clanrogue.com/yabbse/index.php?action=viewmembers
I see all the members

but on the YaBB SE Stats on the forum homepage (http://www.clanrogue.com/yabbse) it says "Total Members: 3"
Anyone know how to fix that? If someone can fix that then I won't restart my forums.

[[Unknown]]

You have to do a forum recount.  You might be able to save some posts if you do a "repair all errors" too.

-[Unknown]

[andrea]

Would it not be possible to create the topics with some query? I mean isn't all information also stored somehow in the messages table? Maybe all but the forum where the topic was in?

[[Unknown]]

Polls, the board it was posted in, stickies, locked topics, and views will be lost.  Repair all Errors will do this however.

-[Unknown]

[ROGUE-Master]

well i did a repair all topics and it created a "Salvaged Board". Every single topic is now in that forum.... I suppose this fixes everything. And I did want to move all our old posts away anyway... so I guess this was for the best...

Thanks..!

[Tyris]

well, glad to hear things have at least worked out okish
what happened to the backup of the actual topics tho..?

[andrea]

I suppose this file was by mistake never backuped. Right?

[ROGUE-Master]

Yep. I thought it was in the dump I made but I was wrong. Once again backup of topics and messages should be implemented in simple machines.

[Yeehaw]

Yep. I thought it was in the dump I made but I was wrong. Once again backup of topics and messages should be implemented in simple machines.

No, proper (tape) backups need to be made by the host. Nothing will replace the issue of proper data backups and should be a priority on choosing a host for a domain. There's no excuse for an ISP/host to lose data (unless the world ends) and the lesson that cheap never should be a high critieria on choosing your ISP/host.

IMO

[andrea]

Yep. I thought it was in the dump I made but I was wrong. Once again backup of topics and messages should be implemented in simple machines.

This is implemented in SMF, and it is already implemented in YaBB SE! This since several versions, take a look in your admin menu.

[Tyris]

Yep. I thought it was in the dump I made but I was wrong. Once again backup of topics and messages should be implemented in simple machines.

No, proper (tape) backups need to be made by the host. Nothing will replace the issue of proper data backups and should be a priority on choosing a host for a domain. There's no excuse for an ISP/host to lose data (unless the world ends) and the lesson that cheap never should be a high critieria on choosing your ISP/host.

IMO

whilst I agree its important to find a good host who backs everything up etc... sometimes thats just not feasable... when I was 14 and making websites... I couldnt afford that... so I went for free hosts.. then some really sheap ones... it not someones fault if they cant afford a good host

[ROGUE-Master]

This is implemented in SMF, and it is already implemented in YaBB SE! This since several versions, take a look in your admin menu.

Dump is available and it backs up data and structure but it DOESN'T back up the topic information or the message information.

[dschwab9]

I thought the dump dv function did all the tables?

[andrea]

This is implemented in SMF, and it is already implemented in YaBB SE! This since several versions, take a look in your admin menu.

Dump is available and it backs up data and structure but it DOESN'T back up the topic information or the message information.

It should save also these tables ROGUE-Master. Just double checked my own forum dumps (created with that admin option) and they do contain also these tables. It may happen with big forums that timeout occur and databases are partially dumped only. In that case it is possible to switch to a different backup method. Various alternative backup methods are described in this FAQ thread:
http://www.yabbse.org/community/index.php?thread=15902/0

It is very important to achieve a working backup method such that *all* your forum data is saved.

[ROGUE-Master]

Yes I remember my server did timeout.