Database Crash - Lost users - A few questions (Page 1 of 2)

Assuming the backup is a backup of your database, yes, but you'll need to edit it so that you're only restoring the two users.

Assuming the backup is of all your PunBB tables, yes, restoring it would restore your forum to the state it was when it was backed up.
However, since only the users table crashed, you should only need to restore two rows. In fact, if you sent me a copy of the backup (smartys@ this site) and told me which usernames to look for, I should be able to give you the two queries to run to add them back.

Well, since only the users table crashed, the posts should still exist in the database. The only thing you need to do is add the users back with the proper IDs.
And the backup I'm referring to is the one you have been referring to (I'm not sure what you mean by backing up the user list though, you backed up the users table?)

Mmmm. Looks like maybe I didnt back up the user tables specifically.

What I have is as follows:

Within my control panel, under 'Backup Data' I have the option to back up the site and back up users.

The site backup is 40.2Mb.
The user back up is....236Mb.

These backups were made via the main control panel options and not the MySQL admin pages.

Not sure if the user back up includes the tables you are referring too. Anything you can recommend?

I unzipped the user back up. Its full of punbb posts. Includes even someone (a former admin) who deleted himself an age ago.

Examples:

INSERT INTO `punbb_posts` VALUES (17970, 'treelo', 38, '80.193.181.235', NULL, 'sell outs\r\n\r\nthats all spurs are', 0, 1140456042, NULL, NULL, 2193);
INSERT INTO `punbb_posts` VALUES (17971, 'treelo', 38, '80.193.181.235', NULL, 'first roasting on the season?', 0, 1140456083, NULL, NULL, 2207);
INSERT INTO `punbb_posts` VALUES (17972, 'Elzar', 3, '212.32.107.22', NULL, 'True. Apart from the Stacki bit.\r\n\r\nLike i said we''ll have to stop our own trolling, and learn to ignore rather than ''bite''. I still can''t have respect for someone that types ''u'' instead of ''you'' though.\r\n\r\nWe can hide the post counts on PunBB. Maybe little things like that will stop cliques?', 0, 1140456501, NULL, NULL, 1631);

So, what needs to be done, guv?

problem is, the file is huge. 236mb. dont see how i can email it

Righto,

Via SQL, entered the following:

hit go. got the following response:

A mate is saying that there is a fundamental problem between the two, probably a missing field. I'm a bit lost in understanding how to translate any of the above into table format to work out what the missing element is.

/scratches head

id -----------------                 int(10) unsigned             PRI      NULL      auto_increment
group_id  -----------------      int(10) unsigned                 4     
username  -----------------     varchar(200)           MUL           
password  -----------------     
email      -----------------           varchar(50)                       
title      -----------------             varchar(50)     YES           NULL     
realname ----------------- varchar(40)     YES           NULL     
url -----------------                 varchar(100)     YES           NULL     
jabber -----------------               varchar(75)     YES           NULL     
icq      -----------------            varchar(12)     YES           NULL     
msn      -----------------           varchar(50)     YES           NULL     
aim      -----------------           varchar(30)     YES           NULL     
yahoo      -----------------           varchar(30)     YES           NULL     
location      -----------------  varchar(30)     YES           NULL     
use_avatar      ----------------- tinyint(1)                 0     
signature      -----------------  text     YES           NULL     
disp_topics      -----------------  tinyint(3) unsigned     YES           NULL     
disp_posts      -----------------  tinyint(3) unsigned     YES           NULL     
email_setting  -----------------      tinyint(1)                 1     
save_pass      -----------------   tinyint(1)                 1     
notify_with_post      ----------------- tinyint(1)                 0     
show_smilies      ----------------- tinyint(1)                 1     
show_img      ----------------- tinyint(1)                 1     
show_img_sig      ----------------- tinyint(1)                 1     
show_avatars      ----------------- tinyint(1)                 1     
show_sig      ----------------- tinyint(1)                 1     
timezone      ----------------- float                 0     
language      ----------------- varchar(25)                 English     
style             -----------------   varchar(25)                 Oxygen     
num_posts      ----------------- int(10) unsigned                 0     
last_post      ----------------- int(10) unsigned     YES           NULL     
registered      ----------------- int(10) unsigned           MUL     0     
registration_ip      ----------------- varchar(15)                 0.0.0.0     
last_visit            -----------------   int(10) unsigned                 0     
admin_note        -----------------  varchar(30)     YES           NULL     
activate_string      ----------------- varchar(50)     YES           NULL     
activate_key         ----------------- varchar(8)     YES           NULL     
karma      ----------------- int(20)                 0     
read_topics      -----------------               mediumtext     YES           NULL     
reputation_enable      -----------------          smallint(6)     YES           1     
reputation_enable_adm      -----------------       tinyint(1) unsigned     YES           1

Mate, run that....seems to work. Its restored that particular user

2 users to go....

Their post count is stored in the users table, so what you see of it reflects how old the backup is

He deleted his posts in your forum. Unless you restore his posts from the backup, you won't see the posts, because they don't exist anymore.

Yes, the count is not calculated every time based on the number of posts in the database. It is simply incremented when a user makes a post. Since your backup is somewhat old, the users have whatever post count they had when the backup was taken